English

Error: ORA-01034: ORACLE NOT available ORA-27101 shared memory realm does not exist

Error Message

The error message below appears when trying to connect to ArcSDE after a fresh install. This can include creating a connection in ArcCatalog, using the ArcSDE commandline tools with 3 tier connection parameters, and so forth.

"Extended DBMS error code: 1034
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Failed to connect to database
Underlying DBMS error [ORA-01034: ORACLE NOT available
ORA-27101 shared memory realm does not exist
SVR4: ERROR 2 No such file or directory]"

Regardless of the failed connection attempts, the user can log into SQLPLUS and also perform a direct connect. This is because the net service name is forced when establishing these connections. The ArcSDE commandline tools can also be used with the direct connection parameters.

For example:

Code:
sdelayer -o describe -i sde:oracle9i -u sde -p sde@ora10g

Cause

The $SDEHOME and/or $ORACLE_SID variables have not been properly defined in the shell script or $SDEHOME/etc/dbinit.sde file. These variables can be in the wrong case or contained in double quotes. An example of this is including the value for the Oracle SID in quotes in the .cshrc file. Variables contained in double quotes such as the Oracle SID are not run in the login script or recognized by other applications.

Code:
$ORACLE_SID "ora10g"

Solution or Workaround

Verify that the variables needed have been correctly defined in the shell script or the $SDEHOME/etc/dbinit.sde file.