| Oracle errors [message #38176] |
Thu, 28 March 2002 04:01  |
George
Messages: 68
Registered: April 2001
|
Member |
|
|
I am trying to start an SQL Plus session to a Database that I loaded previously (So I can practice for my Oracle class). I intially logged on using the username and password SCOTT/TIGER then I ran the database text file using the @c:sample_database.txt command. After loading the sample database text file I could log on using "student/pwd" username and password. Everything worked fine, then (seemingly) after I reboot and run SQL Plus again, I get two errors: "ORACLE NOT AVAILABLE ORA-01034" and "SHARED MEMORY REALM DOES NOT EXIST ORA-27101".
Can anyone help a "Rookie"? Thanks
|
|
|
|
| Re: Oracle errors [message #38178 is a reply to message #38176] |
Thu, 28 March 2002 04:36  |
ssarzano
Messages: 2
Registered: November 2001
|
Junior Member |
|
|
From Metalink:
-------------------
You are attempting to connect to an Oracle8i database from a client using
sqlplus and receive the following errors:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
You have installed 8.1.7 on the same server in a seperate ORACLE_HOME.
Solution Description
--------------------
1) For local (BEQ/IPC) connections:
Verify that the ORACLE_SID environment variable is set and points to a valid
8.1.7 database that is up and running.
% echo $ORACLE_SID
junk
% ps -ef |grep smon
oracle 24603 1 0 15:22:51 ? 0:02 ora_smon_JUNK
In this scenario, because the ORACLE_SID value is case-sensitive on Unix
platforms, a database called 'junk' is not running as it does not exist - it
should be 'JUNK' i.e. upper case.
To fix the issue, set the ORACLE_SID value correctly or to a valid instance.
% setenv ORACLE_SID JUNK (for csh)
% ORACLE_SID=JUNK;export ORACLE_SID (for ksh, sh)
2) For remote (TCP/listener) connections:
Review the listener.ora currently used to startup the listener and verify
the ORACLE_HOME value is correct for all listed Oracle8i databases.
If the ORACLE_HOME points to the 8.1.7 software, however the database was
created using a different version (e.g. 8.1.6 or 8.1.5), then this error can
occur.
Explanation
-----------
Previously, when the ORACLE_HOME or ORACLE_SID were set incorrectly, in the
'oracle' or client user's environment, only ora-1034 was reported e.g.:
ORA-01034 "ORACLE not available"
With 8.1.7, error ORA-27101 reports that the shared memory key generated by the
client does not match any currently existing keys. This is to be expected if
the ORACLE_HOME used by the client is not the same as that used to startup the
database or when the ORACLE_SID value is not correctly referencing the right
instance.
Hope this help!
Regards,
Simone
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
