oracle12528 解决办法,[Oracle] 连接报错ORA-12528

SQL> conn  @test ">meme/meme@test

ERROR:

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

这是因为数据库没有mount

SQL> conn /as sysdba

Connected.

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 9987977216 bytes

Fixed Size                  2261808 bytes

Variable Size            2080378064 bytes

Database Buffers         7885291520 bytes

Redo Buffers               20045824 bytes

Database mounted.

Database opened.

SQL> conn  @test ">meme/meme@test

Connected.