Can't start SQL*plus [message #69962] |
Sat, 23 March 2002 01:20 |
Iskan
Messages: 1 Registered: March 2002
|
Junior Member |
|
|
Hi!!!
I've installed oracle9i on Linux Suse7.2
installed orarun9i.rpm from SUSE.de
but when I've type sqlplus scott/tiger it say
Error: Oracle not available
something about shared memory
|
|
|
Re: Can't start SQL*plus [message #69970 is a reply to message #69962] |
Mon, 25 March 2002 05:04 |
Cindy
Messages: 88 Registered: November 1999
|
Member |
|
|
Recently, we had the same problem when we upgraded our system. We discovered that the system was looking for the new sqlplus, but could not find it, because the ORACLE_HOME path was still pointing to old database version. After we modified the ORACLE_HOME path, the problem was resolved. My advice is check your environment setting to verify it is pointing to correct place.
Hope this help.
-- Cindy
|
|
|
Re: Can't start SQL*plus [message #69983 is a reply to message #69962] |
Tue, 26 March 2002 11:30 |
Paul Antony
Messages: 9 Registered: December 2001
|
Junior Member |
|
|
Make sure your database is started by using "svrmgrl". Before that make sure you set your ORACLE_SID environment variable to the correct database name. User "lsnrctl status" and make sure there are services for that database. Use tnsping and service name and check the service. If you have done a successful installation, after all these you can use sqlplus to connect. Otherwise there should hav ebeen some linking problems with your installation. Check your installation log file in Orainventory/log.
Paul
|
|
|