Loading...
Sunday, May 11, 2008

ORA-27101

ORA-27101
ORA-27101: Shared memory realm does not exist
Cause: Unable to locate shared memory realm
Action: Verify that the realm is accessible.

The following might be the solution:
1. Check your ORACLE_SID, ORACLE_HOME environment if they are set properly.
Run "oraenv" at the command line to see what they currently are. What you should get is something like this:

ORACLE_SID = [orcl] ?
ORACLE_HOME = [/home/oracle]

to reset the ORACLE_SID run command "export ORACLE_SID=orcl" where orcl is your oracle SID remember that the SID is case sensitive.

2. You may have not started your oracle using this command line, here is how to manually startup the your oracle database:
- login to your oracle
sqlplus "sys/password as sysdba"
- start your oracle database
startup

3. if the previous solution was not the case then try changing the permissions for $ORACLE_HOME/bin/tnslsnr using "chmod 6750 tnslsnr" at the command line.




Tags: ,,,,

0 comments:

 
TOP