ORA-24323: value not allowed ORA-01089

在远程连接oracle数据库时，提示：ORA-12537，TNS：连接关闭

使用ssh连接linux，使用oracle身份登录；

sqlplus /as nolog

sql> conn /as sysdba

Connected to an idle instance

sql> startup

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

--------------------------------------------------------------------------------------------------------------

原文地址：http://blog.sina.com.cn/s/blog_4748c4d201016nds.html

解决方法：

使用ssh连接linux，使用oracle身份登录；

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.

--> End