linux中ora-12528,ORA-12528问题解决方法

lsnrctl status

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lypch)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))

Services Summary...

Service "LSExtProc" has 1 instance(s).

Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "ammicly" has 1 instance(s).

Instance "ammicly", status BLOCKED, has 1 handler(s) for this service...

The command completed successfully

这个问题说明数据库没有Mount

连接数据库,发现:

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

用sqlplus /nolog

sql>connect [email=sys/ammic@amicly]sys/ammic@amicly[/email] as sysdba

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

连接的问题可以通