Issue #3:
When running AC on DB node, it failed with below error:
afdbprf.sh started at Sun Feb 12 20:42:36 AST 2017
The environment settings are as follows ...
ORACLE_HOME : /oracle/TEST/db/tech_st/11.2.0.4
ORACLE_SID : TEST
PATH : /usr/bin:/oracle/TEST/db/tech_st/11.2.0.4/bin:/usr/ccs/bin:/usr/sbin:/oracle/TEST/db/tech_st/11.2.0.4/jdk/bin:/usr/bin:/oracle/TEST/db/tech_st/11.2.0.4/bin:/usr/bin:/oracle/TEST/db/tech_st/11.2.0.4/bin:/usr/ccs/bin:/usr/sbin:/oracle/TEST/db/tech_st/
11.2.0.4/jdk/bin:/oracle/TEST/db/tech_st/11.2.0.4/bin:/usr/bin:/oracle/TEST/db/tech_st/11.2.0.4/bin:/usr/ccs/bin:/usr/sbin:/oracle/TEST/db/tech_st/11.2.0.4/jdk/bin:/usr/ccs/bin:/oracle/TEST/db/tech_st/11.2.0.4/bin:/usr/bin:/bin:/opt/EMCpower/bin:/etc/emc/bin:/etc:/usr/X
/bin:/usr/X11/bin:.:/usr/X/bin:/usr/X11/bin:/usr/ccs/bin:.:/usr/X/bin:/usr/X11/bin:/usr/ccs/bin:.
Library Path : /oracle/TEST/db/tech_st/11.2.0.4/lib:/usr/dt/lib:/usr/openwin/lib:/oracle/TEST/db/tech_st/11.2.0.4/ctx/lib
Executable : /oracle/TEST/db/tech_st/11.2.0.4/bin/sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 12 20:42:36 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect Descriptor
Solution:
a) Tnsnames.ora contains wrong entries:
TEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=rsm4k02.bvo.com)(PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=TEST, ebs_patch)
(INSTANCE_NAME=TEST)
)
)
With this configuration, sqlplus connection to TEST will fail:
{oratest@rsm4k02: TEST_rsm4k02 $} sqlplus apps/apps@test
SQL*Plus: Release 11.2.0.4.0 Production on Sun Feb 12 21:28:29 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
b) AC is generating worng values, updating TEST_rsm4k02_ifile.ora with the correct values which will override the worng entries in tnsnames.ora
ð Try first to purge the complete Net Services Topology Data Model:
{appltest@rsm4k02: ~ $} perl $AD_TOP/bin/adgentns.pl contextfile=$CONTEXT_FILE -removesystem
Enter the APPS user password:
##########################################################################
Generate Tns Names
##########################################################################
Logfile: /oracle/TEST/prodappl/admin/TEST_rsm4k02/log/02122150/NetServiceHandler.log
Classpath : /oracle/TEST/prodcomn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/oracle/TEST/prodcomn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/oracle/TEST/prodcomn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/oracle/TEST/prodcomn/java/appsborg2.zip:/oracle/TEST/prodcomn/java
Updating s_tnsmode to 'generateTNS'
UpdateContext exited with status: 0
adgentns.pl exiting with status 0
ERRORCODE = 0 ERRORCODE_END
{appltest@rsm4k02: ~ $}
SQL> conn apps/apps
Connected.
SQL> select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID and
SERVER_TYPE='DB' and FND_NODES.NODE_NAME like upper('%rsm4k02%');
2 3
no rows selected
SQL> select DB_NAME from FND_DATABASES;
no rows selected
SQL>
c) Run AC on DB:
{oratest@rsm4k02: ~ $}
{oratest@rsm4k02: ~ $} $ORACLE_HOME/appsutil/scripts/TEST_rsm4k02/adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /oracle/TEST/db/tech_st/11.2.0.4/appsutil/log/TEST_rsm4k02/02122153/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /oracle/TEST/db/tech_st/11.2.0.4
Classpath : /oracle/TEST/db/tech_st/11.2.0.4/jdk/jre/lib/rt.jar:/oracle/TEST/db/tech_st/11.2.0.4/jdk/lib/dt.jar:/oracle/TEST/db/tech_st/11.2.0.4/jdk/lib/tools.jar:/oracle/TEST/db/tech_st/11.2.0.4/jdbc/lib/ojdbc5.jar:/oracle/TEST/db/tech_st/11.2.0.4/appsutil/java/xmlparserv2.zip:/oracle/TEST/db/tech_st/11.2.0.4/appsutil/java:/oracle/TEST/db/tech_st/11.2.0.4/jlib/netcfg.jar:/oracle/TEST/db/tech_st/11.2.0.4/jlib/ldapjclnt11.jar
Using Context file : /oracle/TEST/db/tech_st/11.2.0.4/appsutil/TEST_rsm4k02.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
{oratest@rsm4k02: ~ $}
SQL> select DB_NAME from FND_DATABASES;
DB_NAME
--------
TEST
SQL> select NAME, SERVER_TYPE from FND_APP_SERVERS, FND_NODES
where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID and
SERVER_TYPE='DB' and FND_NODES.NODE_NAME like upper('%rsm4k02%'); 2 3
NAME
--------------------------------------------------------------------------------
SERVER_TYPE
------------------------------
rsm4k02_TEST_DB
DB
SQL>
d) Run AC on MT:
{appltest@rsm4k02: ~ $} $AD_TOP/bin/adconfig.sh contextfile=$CONTEXT_FILE appspass=apps
The log file for this session is located at: /oracle/TEST/prodappl/admin/TEST_rsm4k02/log/02122154/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using APPL_TOP location : /oracle/TEST/prodappl
Classpath : /oracle/TEST/prodcomn/util/java/1.4/j2sdk1.4.2_04/jre/lib/rt.jar:/oracle/TEST/prodcomn/util/java/1.4/j2sdk1.4.2_04/lib/dt.jar:/oracle/TEST/prodcomn/util/java/1.4/j2sdk1.4.2_04/lib/tools.jar:/oracle/TEST/prodcomn/java/appsborg2.zip:/oracle/TEST/prodcomn/java
Using Context file : /oracle/TEST/prodappl/admin/TEST_rsm4k02.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring ABM_TOP.......COMPLETED
Configuring ECX_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring GL_TOP........COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring XNC_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring PA_TOP........COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring IMT_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
{appltest@rsm4k02: ~ $}
e) If the above did not work, you can apply below work around:
{oratest@rsm4k02: ~ $} cat /oracle/TEST/db/tech_st/11.2.0.4/network/admin/TEST_rsm4k02/TEST_rsm4k02_ifile.ora
TEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=rsm4k02.bvo.com)(PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=TEST)
(INSTANCE_NAME=TEST)
)
)
TEST_806_BALANCE=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=rsm4k02.bvo.com)(PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=TEST)
(INSTANCE_NAME=TEST)
)
)
TEST_FO=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=rsm4k02.bvo.com)(PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=TEST)
(INSTANCE_NAME=TEST)
)
)
TEST_LOCAL=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=rsm4k02.bvo.com)(PORT=1531))
)
TEST_BALANCE=
(DESCRIPTION=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=rsm4k02.bvo.com)(PORT=1531))
)
(CONNECT_DATA=
(SERVICE_NAME=TEST)
)
)
TEST_REMOTE=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=rsm4k02.bvo.com)(PORT=1531))
)
)
extproc_connection_data =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCTEST))
)
(CONNECT_DATA=
(SID=PLSExtProc)
(PRESENTATION = RO)
) )
{oratest@rsm4k02: ~ $}
f) Rerun AC:
{oratest@rsm4k02: ~ $} $ORACLE_HOME/appsutil/scripts/TEST_rsm4k02/adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /oracle/TEST/db/tech_st/11.2.0.4/appsutil/log/TEST_rsm4k02/02122130/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /oracle/TEST/db/tech_st/11.2.0.4
Classpath : /oracle/TEST/db/tech_st/11.2.0.4/jdk/jre/lib/rt.jar:/oracle/TEST/db/tech_st/11.2.0.4/jdk/lib/dt.jar:/oracle/TEST/db/tech_st/11.2.0.4/jdk/lib/tools.jar:/oracle/TEST/db/tech_st/11.2.0.4/jdbc/lib/ojdbc5.jar:/oracle/TEST/db/tech_st/11.2.0.4/appsutil/java/xmlparserv2.zip:/oracle/TEST/db/tech_st/11.2.0.4/appsutil/java:/oracle/TEST/db/tech_st/11.2.0.4/jlib/netcfg.jar:/oracle/TEST/db/tech_st/11.2.0.4/jlib/ldapjclnt11.jar
Using Context file : /oracle/TEST/db/tech_st/11.2.0.4/appsutil/TEST_rsm4k02.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
{oratest@rsm4k02: ~ $}
