This content has been marked as final. Show 9 replies
I could not understand "env."? What I have to do in db?
env. here means environment ...
What is oracle version and Os ??
If you are on window then set your environment as
C:\> set ORACLE_SID=<sid>
c:\>sqlplus / as sysdba
If on *nix
$sqlplus / as sysdba
If on *nix check the .bash_profile for checking your environment variable as
and in case of window check by using
my computer -->right click--> properties --> advance --> environment variables
check whether oracle path is set Properly or not and the path too ...
J.Arulraj wrote:An Oracle database instance comprises of 2 basic components.
Oracle 9i r1
shared memory realm does not exist error often occured. how to overcome this error?
The SGA - a shared memory area that is created and can be considered the brains of the database instance.
Processes - system and user and management processes attach to the SGA and provide various functions (these can be considered as the body parts of the database instance).
When you connect to the database using a local process (e.g. sqlplus on the server), the Oracle client driver does not contact the Listener via TCP. Instead it uses the ORACLE_HOME to launch a dedicated database server process. In order for this server process to service the local client process (e.g. sqlplus), it needs to join the database instance. This server process uses the ORACLE_SID to determine what the shared memory identifier is of the database's SGA to attach too.
The error you got means that this server process did not find an SGA to attach to. The "+shared memory realm+" in the error message refers to the SGA.
The ORACLE_SID (in that o/s session environment) as mentioned is used to identify the SGA to attach to. The ORACLE_SID either contains an invalid ORACLE_SID identifier (no such database SGA exists), or the ORACLE_SID refers to a database instance that is not running (which means no SGA exists to attach to).