先试试 connect / as sysdba,看行不行,如果行的话,
再试试connect / @ as sysdba看看监听配置是否有问题。
如果这一步有问题,说明监听这块有问题。
a.For the DEDICATED occurrence of ORA-12518, you would need to try increasing the PROCESSES parameter so that it can handle the needed number of processes. You can ensure that you have the needed value by monitoring the listener log for ORA-12518. Also, note that because the PROCESSES parameter is static, the database will need to be bounced.
b.If you are experiencing ORA-12518 because of a shared server issue, you first would need to use the command below to shutdown the dispatcher:
SQL> alter system shutdown immediate 'D001';
Then, add on new dispatchers:
SQL> alter system set DISPATCHERS = '(protocol=tcp)(dispatchers=3)';
1.cmd
2.sqlpls /nolog
3.connect sys/test as sysdba
4.show parameters dispatchers;
NAME
TYPE
VALUE
dispatchers string (protocol=tcp)(service=orcl2xdb)
max_dispachersinteger
5.SQL>alter system set dispachters = '(protocol=tcp)(dispatchers=3)(service=orcl2xdb)';
system altered
|