LinuxQuestions.org
Visit Jeremy's Blog.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Other *NIX Forums > Solaris / OpenSolaris
User Name
Password
Solaris / OpenSolaris This forum is for the discussion of Solaris, OpenSolaris, OpenIndiana, and illumos.
General Sun, SunOS and Sparc related questions also go here. Any Solaris fork or distribution is welcome.

Notices


Reply
  Search this Thread
Old 08-14-2004, 04:20 AM   #1
linux_pioneer
Member
 
Registered: May 2003
Distribution: Solaris 10, Solaris 8.0, Fedora Core 3
Posts: 203

Rep: Reputation: 30
Running SQLPLUS after installing Oracle 8i


I installed Oracle 8.1.7 on a sparc system running Solaris 8. The install went fine. I was able to run sqlplus and even populate the database. After rebooting I started the listener and got a message back saying it started successfully. Now when I go to run sqlplus and put in the login credentials I get the following error:

ERROR:
ORA-01034: Oracle not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

I checked all my environment variables and they are set. I placed them in my .profile file so they are set and exported automatically. I even checked the /etc/system file to make sure there were no errors in my shared memory parameters. I am stumped here. I have been online looking for answers to include this site. I have tried many solutions that worked for others but will not work in my situation.

Thanks in advance for the help.
 
Old 08-14-2004, 07:37 AM   #2
Disillusionist
Senior Member
 
Registered: Aug 2004
Location: England
Distribution: Ubuntu
Posts: 1,039

Rep: Reputation: 98
It sounds as though the Oracle processes for your database are not running.

You can check by running ps -ef|grep ora_

Assuming you have a user called oracle
Try:
su - oracle
echo $ORACLE_SID - should be set to your database name
sqlplus '/ as sysdba'

startup normal
exit
 
Old 08-14-2004, 09:03 PM   #3
linux_pioneer
Member
 
Registered: May 2003
Distribution: Solaris 10, Solaris 8.0, Fedora Core 3
Posts: 203

Original Poster
Rep: Reputation: 30
ORACLE_SID is set as my database name. I ran that command as oracle user and got "insuffecient privileges" then it prompted for a username and password. I put in the credentials and I got the same error as before:
ERROR:
ORA-01034: Oracle not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

I know the password is correct because it worked fine before I rebooted the system. I do believe the database is not starting up. After the initial install everything worked fine. After I rebooted looks like the database did not start back up.

when I run dbstart it provides the following output:
# dbstart

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production

SVRMGR> Password:
Password:
ORA-01031: insufficient privileges
SVRMGR> ORA-01031: insufficient privileges
SVRMGR>
Server Manager complete.

Database "kigsys" warm started.

It says the database is started but I get the same sqlplus error. Looks like a bad password fro svrmgrl. When I run svrmgrl and try to connect with the system login I get same error I get when I try to login to sqlplus.

Last edited by linux_pioneer; 08-14-2004 at 09:09 PM.
 
Old 08-14-2004, 09:05 PM   #4
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
Moved: More suitable in Solaris as its definitely not a Linux question.
 
Old 08-14-2004, 11:59 PM   #5
linux_pioneer
Member
 
Registered: May 2003
Distribution: Solaris 10, Solaris 8.0, Fedora Core 3
Posts: 203

Original Poster
Rep: Reputation: 30
Okay I got it working.

My orapw<sid> file was missing that holds my password for svrmgrl utility. I corrected that. Ran svrmgrl.
connect internal
entered the password
and ran startup
now I can connect to sqlplus with the default system password
thanks for the help
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Installing TOra 1.3.18 & Qt 3.3.5 on CentOS 4.1 (RHEL 4 U1) box running Oracle 10g R2 dbaxps Linux - Software 2 02-22-2007 08:41 AM
installing oracle matrixon Linux - Software 1 09-14-2005 10:54 AM
installing oracle kpharda Linux - Software 2 03-18-2005 11:42 PM
Running Oracle on Fedora nicolas_rollin Fedora 5 12-17-2003 12:38 PM
Need to connect to db with SQLplus...or ANY oracle client.... vous Linux - Software 2 08-06-2003 04:54 AM

LinuxQuestions.org > Forums > Other *NIX Forums > Solaris / OpenSolaris

All times are GMT -5. The time now is 01:27 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration