-
Hi guys/gals,
I installed Oracle 8i on Solaris, and had my database up and running. someone shut down the box, and my db has crashed. I can't seem to get it started up again. when I try to log into the db using sqlplus, I get the error message ORA-1034 ORACLE NOT AVAILABLE. I've run the tnslsnr binary, and the oracle binary, but still no luck. any ideas? is there something, that I'm overlooking?
-
Are your environment variables setup correctly? Did you run dbstart ? Do you see any oracle processes?
http://technet.oracle.com/docs/produ...de_sun_817.pdf
-
What happens if you connect internal in either SQLPLUS or SVRMGRL and startup?
any errors?
ORA-1034 suggests the database has not been started.
ps -ef | grep ora
will show what processes are running for Oracle.
if you see none, startup the database.
if you see some, shutdown (normal or abort) and startup
-
Code:
setenv ORACLE_SID database_name -- if it were to be C shell
export ORACLE_SID=databasename
export ORACLE_HOME= .../product/...
export PATH= $ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
First start the listeners
$> lnsrctl start
$> lsnrctl status
Now start the database
$> svrmgrl
SVRMGR> connect internal
SVRMGR> shutdown immediate -- To confirm a shutdown had taken place
SVRMGR> startup mount
SVRMGR> recover database;
SVRMGR> alter database open;
SVRMGR> exit
$> sqlplus username/password@servicename
SQL>
Remember when you set the environment depending on your shell you have to use either export or setenv
To get the list of all SIDs on solaris checl
$> less /var/opt/oracle/oratab
Home this would help you.
Before proceeding, check your alert_sid.log for error messages
Sam
[Edited by sambavan on 12-03-2001 at 03:15 PM]
-
thanks for your replies
thanks everyone, I'll follow the steps and update you with my progress. as luck would have it, I'm running the kshell, so I've been setting the variables, and then running export. ie.
ORACLE_SID=PLAT2001
export ORACLE_SID
-
new info
ok, I went to server manager and here's the output:
SVRMGR> connect internal
Message 701 not found; No message file for product=SVRMGR, facility=MGR
Error while trying to retrieve text for error ORA-12571
am I skipping something else? or are my environment variables set up improperly?
-
Your environment variables are not setup correctly.
Make sure you have set:
ORACLE_HOME
ORACLE_SID
LD_LIBRARY_PATH
PATH
variables correctly. The easiest way to set these variables is via the oraenv script.
. oraenv