Wednesday, June 06, 2012


This was tested on Oracle 9. If you are in the middle of a shutdown immediate in one session (in red): 

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

... and you connect as SYS in another session (in blue), the session starts without an error message but, if you run any SQL, you get an ORA-01012: 

ANDREW > sqlplus '/ as sysdba'
SQL*Plus: Release - Production on Wed Jun 6 14:35:47 2012
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
SQL> select sysdate from dual;
select sysdate from dual
ERROR at line 1:
ORA-01012: not logged on

You can read about ORA-01012 in the book advertised below:

No comments:

Post a Comment