ORA-01034: ORACLE not
available
Cause:
Oracle was not
started up. Possible
causes include the
following:
- The SGA requires
more space than was
allocated for it.
- The
operating-system
variable pointing to
the instance is
improperly defined.
Action:
Refer to
accompanying
messages for
possible causes and
correct the problem
mentioned in the
other messages. 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
SQL> startup
Window :
C:\> set ORACLE_SID=xxx
C:\> sqlplus sys/manager@xxx as sysdba
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.
This article covers ORA-01034 when trying to
change the domain name. It mentions that:
So long as you have
the DNS host name in your tnsnames.ora file,
changing the IP address from the DNS file (i.e.
/etc/hosts) should not have any changes at the
database level.