EBS常见问题解决

目录

• 1、通过PL/sql develop 连接orauat，出现报错：‘ORA-12537 TNS 连接关闭’
• 2、执行adop phase=fs_clone,报如下错：
• 3、启动ebs应用服务报错：

1、通过PL/sql develop 连接orauat，出现报错：‘ORA-12537 TNS 连接关闭’

原因是sqlnet.ora中的下面两行问题，注释掉，并进行重启lsnrctl即可

[orauat@ebsuat ebsuat_ebsuat]$ vi sqlnet.ora

#tcp.validnode_checking = yes
#tcp.invited_nodes=(EBSUAT.*.com)

[orauat@ebsuat ebsuat_ebsuat]$ lnsrctl stop ebsuat

[orauat@ebsuat ebsuat_ebsuat]$ lnsrctl start ebsuat

2、执行adop phase=fs_clone,报如下错：

\[appluat@ebsuat stage\]$ adop phase=fs\_clone

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
Run Edition context : /u01/uat/ap/fs1/inst/apps/ebsuat\_ebsuat/appl/admin/ebsuat\_ebsuat.xml
Patch edition context: /u01/uat/ap/fs2/inst/apps/ebsuat\_ebsuat/appl/admin/ebsuat\_ebsuat.xml
Patch file system free space: 122.26 GB

Validating system setup.
Node registry is valid.

Checking for existing adop sessions.
No pending session exists.
Starting new adop session.

===========================================================================
ADOP (C.Delta.10)
Session ID: 5
Node: ebsuat
Phase: fs\_clone
Log: /u01/uat/ap/fs\_ne/EBSapps/log/adop/5/20200704\_082904/adop.log
===========================================================================

Validating configuration on node: \[ebsuat\].
Log: /u01/uat/ap/fs\_ne/EBSapps/log/adop/5/20200704\_082904/fs\_clone/validate/ebsuat
\[WARNING\]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
\[WARNING\]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.
\[ERROR\]: Domain might be locked by some other WLS user process
\[UNEXPECTED\]Error occurred running "perl /u01/uat/ap/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/uat/ap/fs1/inst/apps/ebsuat\_ebsuat/appl/admin/ebsuat\_ebsuat.xml -patchctxfile=/u01/uat/ap/fs2/inst/apps/ebsuat\_ebsuat/appl/admin/ebsuat\_ebsuat.xml -phase=fs\_clone -logloc=/u01/uat/ap/fs\_ne/EBSapps/log/adop/5/20200704\_082904/fs\_clone/validate/ebsuat -promptmsg=hide"
\[UNEXPECTED\]Error 1 occurred while Executing txkADOPValidation script on ebsuat

\[STATEMENT\] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.

adop exiting with status = 1 (Fail)

分析为WLS进程锁定了，进入wls查看，发现是编辑状态。释放即可

3、启动ebs应用服务报错：

apps的密码错误，

\[appldev@ebsdev ~\]$ adstrtal.sh apps/apps

You are running adstrtal.sh version 120.24.12020000.11


Enter the WebLogic Server password: 
adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.

USAGE: adstrtal.sh <appsusername/appspassword> \[-nothreading\]
adstrtal.sh <applications\_username/applications\_password> -secureapps
adstrtal.sh -nodbchk 
adstrtal.sh -mode=allnodes
adstrtal.sh -msimode
adstrtal.sh: exiting with status 1

密码错误，apps的密码错误会有此提示。