oracle nid ora 24324,Oracle-ora-24324,ora-01089

sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Aug 19 10:39:10

2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected.

SQL> startup nomount;

ORA-01081: cannot start already-running ORACLE - shut it down

first

SQL> shutdown immediate;

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are

permitted

SQL> shutdown abort;

ORA-01031: insufficient privileges

SQL> exit

Disconnected

sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Aug 19 10:41:43

2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected.

SQL> shutdown abort

ORACLE instance shut down.

SQL> exit

Disconnected

sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Aug 19 10:41:52

2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 595591168 bytes

Fixed Size 2073064 bytes

Variable Size 213913112 bytes

Database Buffers 373293056 bytes

Redo Buffers 6311936 bytes

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down

SQL> startup

ORACLE instance started

Total System Global Area 595591168 bytes

Fixed Size 2073064 bytes

Variable Size 213913112 bytes

Database Buffers 373293056 bytes

Redo Buffers 6311936 bytes

Database mounted.

ORA-16038: log 1 sequence# 799 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 1 thread 1: xxx

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started

Total System Global Area 595591168 bytes

Fixed Size 2073064 bytes

Variable Size 213913112 bytes

Database Buffers 373293056 bytes

Redo Buffers 6311936 bytes

Database mounted.

Database opened.

--> Work