TNS:listener does not currently know of service requested in connect
Error:
While
connecting to apps from Apps Tier
[applmgr@ebs1228 scripts]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 1
19:44:47 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ORA-12514: TNS:listener does not currently know
of service requested in connect
Descriptor
Sol:
This error may cause due to Listener Service Name
issue. You can check the service name in Listener.ora file and check in
tnsnames.ora file. If you still face issues you can follow as below
[oracle@ebs1228
ebs1228_ebs1228]$ cd $ORACLE_HOME/appsutil
[oracle@ebs1228 appsutil]$ cd bin
[oracle@ebs1228 bin]$ perl adbldxml.pl appsuser=apps
Starting context file generation for db tier..
Using JVM from
/u01/EBS1228/12.1.0/appsutil/jre/bin/java to execute java programs
APPS Password:
The log file for this adbldxml session is located at:
/u01/EBS1228/12.1.0/appsutil/log/adbldxml_11011939.log
Enter Database Service Name: ebs1228
Enter the value for Display Variable: 0
Context File
/u01/EBS1228/12.1.0/appsutil/ebs1228_ebs1228.xml
already exists.
Overwriting Context File may cause loss of existing
settings, hence
backing it up
as: /u01/EBS1228/12.1.0/appsutil/ebs1228_ebs1228.xml.bak
The context file has been created at:
/u01/EBS1228/12.1.0/appsutil/ebs1228_ebs1228.xml
[oracle@ebs1228 bin]$ echo $CONTEXT_FILE
/u01/EBS1228/12.1.0/appsutil/ebs1228_ebs1228.xml
[oracle@ebs1228 bin]$ pwd
/u01/EBS1228/12.1.0/appsutil/bin
[oracle@ebs1228 bin]$ sh adconfig.sh
contextfile=/u01/EBS1228/12.1.0/appsutil/eb s1228_ebs1228.xml
Enter the APPS user password:
The log file for this session is located at:
/u01/EBS1228/12.1.0/appsutil/log/eb
s1228_ebs1228/11011942/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if
present.
Using
ORACLE_HOME location : /u01/EBS1228/12.1.0
Classpath :
:/u01/EBS1228/12.1.0/jdbc/lib/ojdbc6.jar:/
u01/EBS1228/12.1.0/appsutil/java/xmlparserv2.jar:/u01/EBS1228/12.1.0/appsutil/ja va:/u01/EBS1228/12.1.0/jlib/netcfg.jar:/u01/EBS1228/12.1.0/jlib/ldapjclnt12.jar
Using Context
file :
/u01/EBS1228/12.1.0/appsutil/ebs1228_ebs1228.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 db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed with errors.
[oracle@ebs1228 bin]$ cd ../scripts/
[oracle@ebs1228 scripts]$ ls
ebs1228_ebs1228
[oracle@ebs1228 scripts]$ cd ebs1228_ebs1228/
[oracle@ebs1228 ebs1228_ebs1228]$ ls
adautocfg.sh
addbctl.sh adexecsql.pl adpreclone.pl
adstrtdb.sql
adchknls.pl
addlnctl.sh adlsnodes.sh adstopdb.sql
[oracle@ebs1228 ebs1228_ebs1228]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at:
/u01/EBS1228/12.1.0/appsutil/log/eb
s1228_ebs1228/11011944/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if
present.
Using
ORACLE_HOME location : /u01/EBS1228/12.1.0
Classpath :
:/u01/EBS1228/12.1.0/jdbc/lib/ojdbc6.jar:/ u01/EBS1228/12.1.0/appsutil/java/xmlparserv2.jar:/u01/EBS1228/12.1.0/appsutil/ja
va:/u01/EBS1228/12.1.0/jlib/netcfg.jar:/u01/EBS1228/12.1.0/jlib/ldapjclnt12.jar
Using
Context file :
/u01/EBS1228/12.1.0/appsutil/ebs1228_ebs12
28.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 db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
Run
autoconfig on Apps Tier
[applmgr@ebs1228 scripts]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at:
/u01/EBS1228/fs2/inst/apps/ebs1228_ebs1228/admin/log/11011944/adconfig.log
wlsDomainName: EBS_domain
WLS Domain Name is VALID.
AutoConfig is configuring the Applications
environment...
AutoConfig will consider the custom templates if
present.
Using
CONFIG_HOME location :
/u01/EBS1228/fs2/inst/apps/ebs1228_ebs1228
Classpath :
/u01/EBS1228/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/EBS1228/fs2/EBSapps/comn/java/classes
Using
Context file :
/u01/EBS1228/fs2/inst/apps/ebs1228_ebs1228/appl/admin/ebs1228_ebs1228.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 MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring CZ_TOP........COMPLETED
Configuring SHT_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
IBY_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 GMF_TOP.......COMPLETED
Configuring PON_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring
IGC_TOP.......COMPLETED
AutoConfig completed successfully.
[applmgr@ebs1228 scripts]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 1
19:50:07 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release
12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and
Real Application Testing options
SQL> exit
No comments:
Post a Comment