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

Database is "UP" but Veritas Netbackup detect that the oracle db is down and cannot create template from Netbackup Java Console.


Because of this error, than I try to configure the Hot Backup Oracle using RMAN script provided by Netbackup on "/usr/openv/netbackup/ext/db_ext/oracle/samples/rman". Using this script, I also found the same error.

RMAN-00571:=============================================
RMAN-00569:======== ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571:=============================================
RMAN-03002: failure of allocate command at 02/25/2008 15:12:29
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

We can connect locally to RMAN, and test the link to Veritas Netbackup with successfully.

bash-2.05$ pwd
/rdbms/oracle9

bash-2.05$ rman target veritas/veritas
Recovery Manager: Release 9.2.0.6.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: ODONG2 (DBID=1263713746)
RMAN> RUN {
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
3> RELEASE CHANNEL ch00;
4> }
using target database controlfile instead of recovery catalog
allocated channel: ch00
channel ch00: sid=38 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)
released channel: ch00
RMAN> quit
Recovery Manager complete.
bash-2.05$

But using the netbackup Java Console & Netbackup Script still the same error. After discuss with the DBA, refer to documentation support from Veritas Netbackup, and some tries, we found that, the problem is on environtment variables :

Here is our environtment variables on this server :

bash-2.05$ env
PWD=/rdbms/oracle9
ORACLE_SID=test
HOSTNAME=odong2
LD_LIBRARY_PATH=/rdbms/oracle9/OraHome1/lib
MACHTYPE=sparc-sun-solaris2.9
MAIL=/var/mail/oracle9
EDITOR=vi
ORACLE_BASE=/rdbms/oracle9/
ORACLE_HOME=/rdbms/oracle9//OraHome1/
LOGNAME=oracle9
SHELL=/bin/bash
HOSTTYPE=sparc
OSTYPE=solaris2.9
HOME=/rdbms/oracle9

And the problem is we cannot go directly to ORACLE_HOME using the script, but must be used "ORACLE_HOME=$ORACLE_BASE/OraHome1/" .

To SOLVE the problem, we "add" the ORACLE_BASE parameter to the Script :

# ----------------------------------------------------------
# Replace /db/oracle81, below, with the Oracle home path.
# ----------------------------------------------------------

ORACLE_BASE=/rdbms/oracle9/
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/OraHome1/
export ORACLE_HOME

After adding the ORACLE_BASE parameter, Hot Backup Online Oracle running normal.