ORA-01034

RMAN Backup Job Fails With Error "ORA-01034: ORACLE not available" [ID 1320219.1]

Applies to:

Enterprise Manager Grid Control - Version: 10.2.0.3 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

RMAN backup job from grid control fails with following error:

RMAN> run {
2> allocate channel oem_disk_backup device type disk;
3> backup as COMPRESSED BACKUPSET current controlfile tag '05022011115943';
4> restore controlfile validate from tag '05022011115943';
5> release channel oem_disk_backup;
6> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 05/02/2011 11:57:14
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available

Cause

Database is started with incorrect ORACLE_HOME set.
There is a trailing slash at the end of ORACLE_HOME.

This is verified from the output of following commands:

1. From the OS command:
       $ ps -ef | grep pmon

    Get the process ID and run the following command:

       $ cat /proc/<PID of pmon>/environ

Sample Output:
============

oracle@u-dp3f ~]$ ps -ef|grep pmon
oracle   11798     1  0 Apr28 ?        00:00:06 ora_pmon_FSPRD
oracle   28969 28049  0 10:21 pts/2    00:00:00 grep pmon

[oracle@u-dp3f ~]$ cat /proc/11798/environ
HOSTNAME=u-dp3f.mz.liu.eduTERM=vt100SHELL=/bin/bashHISTSIZE=1000LIC_ECHO=echo -eSSH_CLIENT=10.1.23.100 1742 22SSH_TTY=/dev/pts/2USER=oracleLD_LIBRARY_PATH=/opt/CA/SharedComponents/libLS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:ORACLE_SID=FSPRDORACLE_BASE=/u01/app/oracleMAIL=/var/spool/mail/oraclePATH=INPUTRC=/etc/inputrcPWD=/home/oracleLANG=en_US.UTF-8SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpassSHLVL=1HOME=/home/oracleLOGNAME=oracleCVS_RSH=sshSSH_CONNECTION=10.1.23.100 1742 10.0.0.105 22LESSOPEN=|/usr/bin/lesspipe.sh %sCASHCOMP=/opt/CA/SharedComponentsORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1/CALIB=/opt/CA/SharedComponents/libG_BROKEN_FILENAMES=1_=/u01/app/oracle/product/10.2.0/db_1//bin/sqlplusORA_NET2_DESC=8,11ORACLE_SPAWNED_PROCESS=1SKGP_HIDDEN_ARGS=<FATAL/S/x0/x1/x0/xFFF4E8F4/11793/11793/x0>0[oracle@u-dp3f ~]$ 

From the above, the ORACLE_HOME environment variable is set as below:

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1/ --> there is a trailing slash "/" at the end.

2. From the database side, run the following as SYS user:

      SQL> set autopri on
      SQL> var oracle_home varchar2(255)
      SQL> exec dbms_system.get_env('ORACLE_HOME',:ORACLE_HOME);

      

Sample Output:
============

SQL> set autopri on
SQL> var oracle_home varchar2(255)
SQL> exec dbms_system.get_env('ORACLE_HOME',:ORACLE_HOME)
PL/SQL procedure successfully completed.

ORACLE_HOME
-------------------------------------------------------------------------------
/u01/app/oracle/product/10.2.0/db_1/

From the above, output of ORACLE_HOME is /u01/app/oracle/product/10.2.0/db_1/ (there is a trailing slash "/" at the end).

Solution

Please stop and start the database by setting the ORACLE_HOME and ORACLE_SID correctly.

For example,
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 --> no trailing slash "/" at the end
ORACLE_SID=FSPRD

Also ensure that correct monitoring details are provided in the database monitoring configuration page in grid control.

1. Login to grid control

2. Navigate to Targets --> Databases

3. Select the problematic database and Click on Configure

4. Ensure that correct monitoring details are provided