今天同事找我说ebs网页登不上去,喊我去看看,报错信息是:
You have encountered an unexpected error. Please contact the System Administrator for assistance.
如下图:
点click here 查看,发现是报数据库连接不上的原因
( 造成此问题的问题有很多,如内存不足、系统参数配置不当、程序代码、系统表空间不足等原因)
然后去系统里查看这个是哪个用户哪个库的
dev01:~ # netstat -tunlp |grep 8006
tcp 0 0 0.0.0.0:8006 0.0.0.0:* LISTEN 10218/httpd
dev01:~ # ps -ef | grep 10218
root 6774 24950 0 15:20 pts/6 00:00:00 grep 10218
acqcb 10218 10130 0 Apr28 ? 00:00:03 /data/cqcb/apps/tech_st/10.1.3/Apache/Apache/bin/httpd -d /data/cqcb/apps/tech_st/10.1.3/Apache/Apache -DSSL -f /data/cqcb/inst/apps/cqcbdev_dev01/ora/10.1.3/Apache/Apache/conf/httpd.conf
发现是acqcb这个用户,那么对应的数据库是ocqcb,登录进去看,果然,实例是down的,手动起起来
ocqcb@dev01:~> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Apr 29 15:20:50 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2235208 bytes
Variable Size 440403128 bytes
Database Buffers 612368384 bytes
Redo Buffers 13930496 bytes
Database mounted.
Database opened.
然后再去acqcb用户上把应用重启下
acqcb@dev01:/data/cqcb/inst/apps/cqcbdev_dev01/admin/scripts> ls
adalnctl.sh adautocfg.sh adexecsql.pl adformsctl.sh adoacorectl.sh adopmnctl.sh adstpall.sh gsmstart.sh java.sh msc mwactlwrpr.sh
adapcctl.sh adcmctl.sh adforms-c4wsctl.sh adformsrvctl.sh adoafmctl.sh adpreclone.pl adstrtal.sh ieo jtffmctl.sh mwactl.sh sqlnet.log
acqcb@dev01:/data/cqcb/inst/apps/cqcbdev_dev01/admin/scripts> ./adstpall.sh apps/apps
。。。
。。。
****************************************************
All enabled services on this node are stopped.
adstpall.sh:Exiting with status 0
adstpall.sh: check the logfile /data/cqcb/inst/apps/cqcbdev_dev01/logs/appl/admin/log/adstpall.log for more information ...
再启动服务:
acqcb@dev01:/data/cqcb/inst/apps/cqcbdev_dev01/admin/scripts> ./adstrtal.sh apps/apps
You are running adstrtal.sh version 120.15.12010000.3
The logfile for this session is located at /data/cqcb/inst/apps/cqcbdev_dev01/logs/appl/admin/log/adstrtal.log
Executing service control script:
/data/cqcb/inst/apps/cqcbdev_dev01/admin/scripts/adopmnctl.sh start
script returned:
****************************************************
。。。
。。。
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /data/cqcb/inst/apps/cqcbdev_dev01/logs/appl/admin/log/adstrtal.log for more information ...
服务重启后,再访问可以正常访问了
You have encountered an unexpected error. Please contact the System Administrator for assistance.
如下图:
点click here 查看,发现是报数据库连接不上的原因
( 造成此问题的问题有很多,如内存不足、系统参数配置不当、程序代码、系统表空间不足等原因)
然后去系统里查看这个是哪个用户哪个库的
dev01:~ # netstat -tunlp |grep 8006
tcp 0 0 0.0.0.0:8006 0.0.0.0:* LISTEN 10218/httpd
dev01:~ # ps -ef | grep 10218
root 6774 24950 0 15:20 pts/6 00:00:00 grep 10218
acqcb 10218 10130 0 Apr28 ? 00:00:03 /data/cqcb/apps/tech_st/10.1.3/Apache/Apache/bin/httpd -d /data/cqcb/apps/tech_st/10.1.3/Apache/Apache -DSSL -f /data/cqcb/inst/apps/cqcbdev_dev01/ora/10.1.3/Apache/Apache/conf/httpd.conf
发现是acqcb这个用户,那么对应的数据库是ocqcb,登录进去看,果然,实例是down的,手动起起来
ocqcb@dev01:~> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Apr 29 15:20:50 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2235208 bytes
Variable Size 440403128 bytes
Database Buffers 612368384 bytes
Redo Buffers 13930496 bytes
Database mounted.
Database opened.
然后再去acqcb用户上把应用重启下
acqcb@dev01:/data/cqcb/inst/apps/cqcbdev_dev01/admin/scripts> ls
adalnctl.sh adautocfg.sh adexecsql.pl adformsctl.sh adoacorectl.sh adopmnctl.sh adstpall.sh gsmstart.sh java.sh msc mwactlwrpr.sh
adapcctl.sh adcmctl.sh adforms-c4wsctl.sh adformsrvctl.sh adoafmctl.sh adpreclone.pl adstrtal.sh ieo jtffmctl.sh mwactl.sh sqlnet.log
acqcb@dev01:/data/cqcb/inst/apps/cqcbdev_dev01/admin/scripts> ./adstpall.sh apps/apps
。。。
。。。
****************************************************
All enabled services on this node are stopped.
adstpall.sh:Exiting with status 0
adstpall.sh: check the logfile /data/cqcb/inst/apps/cqcbdev_dev01/logs/appl/admin/log/adstpall.log for more information ...
再启动服务:
acqcb@dev01:/data/cqcb/inst/apps/cqcbdev_dev01/admin/scripts> ./adstrtal.sh apps/apps
You are running adstrtal.sh version 120.15.12010000.3
The logfile for this session is located at /data/cqcb/inst/apps/cqcbdev_dev01/logs/appl/admin/log/adstrtal.log
Executing service control script:
/data/cqcb/inst/apps/cqcbdev_dev01/admin/scripts/adopmnctl.sh start
script returned:
****************************************************
。。。
。。。
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /data/cqcb/inst/apps/cqcbdev_dev01/logs/appl/admin/log/adstrtal.log for more information ...
服务重启后,再访问可以正常访问了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31098809/viewspace-2090677/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31098809/viewspace-2090677/