Skip to main content

How can we help you?

Druva Documentation

Backup fails with an error message “ERROR at line 1:\nORA-01034: ORACLE not available\nProcess ID: 0\nSession ID: 0”

 

 

Overview

This issue can happen when we try to take backup of oracle database using Phoenix Oracle DTC agent and the backup fails with the message “ERROR at line 1:\nORA-01034: ORACLE, not available\nProcess ID: 0\nSession ID: 0 “

Cause

Oracle was not started up. Possible causes include the following:

1. The SGA (System Global Area) requires more space than was allocated for it.

2. The operating-system variable pointing to the instance is improperly defined.

Traceback

level=error ts=2022-02-19T19:19:55.350126755-05:00 stack="failed to parse results: \nORACLE_BASE=/ora/app/oracle\nORACLE_HOME=/ora/app/oracle/product/12.1.0.2/dbhome\n\nSQL*Plus: Release 12.1.0.2.0 Production on 

Sat Feb 19 19:19:54 2022\n\nCopyright (c) 1982, 2014, Oracle. All rights reserved.\n\nConnected to an idle instance.\n\nPHOENIX_ORACLE_AGENT_DTC_SQLPLUS_SCAN_START\nDECLARE\n*\nERROR at line 1:\nORA-01034: ORACLE not available\nProcess ID: 0\nSession ID: 0 Serial number: 0\n\n\nPHOENIX_ORACLE_AGENT_DTC_SQLPLUS_SCAN_END\nDisconnected\n\\ngoroutine 38 [running]:\ 

Resolution

  • If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.
  • The ORA-01034 error can sometimes be fixed by setting the  ORACLE_SID environment variable:
  • Unix/Linux :

$ORACLE_SID=xxx

$export ORACLE_SID

$sqlplus sys/manager@xxx as sysdba/sysbackup

SQL> startup

Window :

C:\> set ORACLE_SID=xxx

C:\> sqlplus sys/manager@xxx as sysdba/sysbackup

C:\> startup

  • You may find that you are experiencing ORA-01034 when attempting to upgrade your Oracle database.
  • ORA-01034 is thrown during the attempt to upgrade because there is an invalid entry in one of the following files:

/etc/oratab

/var/opt/oracle/oratab

  • The ORA-01034 is a result of a discrepancy between ORACLE_HOME and ORACLE_SID
  • To resolve ORA-01034, be sure that the ORACLE_HOME and ORACLE_SID properly match within the files /etc/oratab or /var/opt/oracle/oratab .
  • As a last step in solving your ORA-01034 problem and running DBUA, make sure that  ORACLE_HOME is set to 'old' home, not 'new' home.

Note:Please involve DBA to verify the above steps.