Friday, August 13, 2010

Error Handling

ORA-12518: TNS:listener could not hand off client connection tips
Start->Run->services.msc->OracleServiceMFD(instance name) manually start it
-------------------------------------------------------------------------------------------------
ORA-01034: ORACLE not available
The database and the instance are not started.
SQL>startup;
-------------------------------------------------------------------------------------------------
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
SQL>alter system disable restricted session;
-------------------------------------------------------------------------------------------------
ORA-01033: ORACLE initialization or shutdown in progress
database in mount or nomount mode
if it is in nomount:
   SQL>alter database mount;
   SQL>alter database open;
if it is in mount:
   SQL>alter database open;
-------------------------------------------------------------------------------------------------




Log file switch (checkpoint incomplete)



    * increase the size of the redo logs * add more redo log groups







No comments:

Post a Comment