Thursday, July 16, 2015

ORA-00000: normal, successful completion


ORA-00000: normal, successful completion



Symptoms

[oracle@vm110 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 6 17:14:31 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected.
SQL> startup force nomount ;
ORA-00000: normal, successful completion


Cause

This error is related to environment variable or DNS or /etc/hosts file which you have mentioned wrong or forget to set before execution.

check environment variables for below :

$ORACLE_HOME
$ORACLE_BASE
$ORACLE_SID

hostfile : /etc/hosts


Solution

Fixed the correct environment variable and retry

or


Add the hostname in /etc/hosts or route this server to DNS.

No comments:

Post a Comment