SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

前端之家收集整理的这篇文章主要介绍了SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

[[email protected] ~]$ sqlplus ‘/as sysdba‘

sql*Plus: Release 11.2.0.4.0 Production on Sat Oct 13 14:14:13 2018

Copyright (c) 1982,2013,Oracle.  All rights reserved.

ERROR:
ORA-00020: maximum number of processes (150) exceeded


 

解决方法:[[email protected] 11g ~]$ps -ef|grep "oracleXXXX (LOCAL=NO)"|grep -v grep|awk ‘{print $2}‘|xargs kill -9

     重启数据库

1、Linux下以Oracle帐户进入Linux系统

2、执行以下命令查看数据库监听器的状况:

lsnrctl status

3、执行以下命令停止数据库监听器运行:

lsnrctl stop

4、执行以下命令进入sqlPlus:

sqlplus / nolog

connect / as sysdba

shutdown immediate

5、执行以下命令退出sqlPlus:

Exit

6、启动,查看数据库监听器:

lsnrctl start

lsnrctl status

7、启动Oracle数据库

sqlplus / nolog

connect / as sysdba

startup

猜你在找的Oracle相关文章