今天在启动数据库时遇到下面的报错:
SQL> startup
ORA-10997: another startup/shutdown operation of this instance inprogress
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 5560
用root登录进去查看oracle用户的资源信息:
su -m -c 'ulimit -a' oracle
su: 无法设置用户ID: 资源暂时不可用
按经验看就是oracle用户开了太多线程,达到系统最大限制(默认1024)
ps -eL | wc