Autoconfig errored out in 10.2.0.4 database on Linux server. The following is the sample output from adconfig.log.
/oracle/product/10.2.0.4/<SID>/appsutil/install/<SID_hostname>/afdbprf.sh
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Solution:
Ensure that the following two parameters in the database tier context file match each other.
s_global_database_name
s_dbService
Sometimes this is a source of listener problems.
Also check for the service_name parameter in init.ora. Its value should be SID.Domain_name.
If it is non-RAC database, ensure that the following parameters are disabled in init.ora
local_listener
remote_listener
Thursday, September 23, 2010
adcfgclone.pl fails in FE node
perl adcfgclone.pl appsTier fails in the front end node with the error message as follows:
Cannot proceed with ApplyApplTop - the paths/ports in the context file are not valid.
RC-20403: The following port numbers are busy - please make sure the ports are available and try again.
Raised by oracle.apps.ad.clone.ApplyAppsTechStack
s_fnd_cache_port_range :
--------------------------------------
Surprisingly, there is no value assigned for this particular variable s_fnd_cache_port_range in the xml file
Solution:
A simple solution is to delete the particular line of s_fnd_cache_port_range and the autoconfig will choose a port value by itself
References:
Oracle Article Ids: 390901.1 & 365871.1
External url: http://blogs.oracle.com/stevenChan/2007/09/java_caching_for_oracle_applic.html
Cannot proceed with ApplyApplTop - the paths/ports in the context file are not valid.
RC-20403: The following port numbers are busy - please make sure the ports are available and try again.
Raised by oracle.apps.ad.clone.ApplyAppsTechStack
s_fnd_cache_port_range :
--------------------------------------
Surprisingly, there is no value assigned for this particular variable s_fnd_cache_port_range in the xml file
Solution:
A simple solution is to delete the particular line of s_fnd_cache_port_range and the autoconfig will choose a port value by itself
References:
Oracle Article Ids: 390901.1 & 365871.1
External url: http://blogs.oracle.com/stevenChan/2007/09/java_caching_for_oracle_applic.html
adrelink errored for the patch 4653217
adrelink for the patch 4653217 failed with the below error:
/usr/lib/gcc/i386-redhat-linux/3.4.6/libgcc_s.so: undefined reference to `dl_iterate_phdr@GLIBC_2.2.4'
collect2: ld returned 1 exit status
make: *** [/apps/qtcdv/appl_top/ad/11.5.0/bin/adpchnew] Error 1
This error is specific to linux servers. If this is the same error you are also facing, then immediately check for the below two soft links. The destination should be similar as per this screen shot
# ls -l /usr/bin/gcc
lrwxrwxrwx 1 root root 15 Mar 22 02:45 /usr/bin/gcc -> /usr/bin/gcc296
# ls -l /usr/bin/g++
lrwxrwxrwx 1 root root 15 Mar 22 02:48 /usr/bin/g++ -> /usr/bin/g++296
After rectifying the mentioned softlinks you can restart the patch.
/usr/lib/gcc/i386-redhat-linux/3.4.6/libgcc_s.so: undefined reference to `dl_iterate_phdr@GLIBC_2.2.4'
collect2: ld returned 1 exit status
make: *** [/apps/qtcdv/appl_top/ad/11.5.0/bin/adpchnew] Error 1
This error is specific to linux servers. If this is the same error you are also facing, then immediately check for the below two soft links. The destination should be similar as per this screen shot
# ls -l /usr/bin/gcc
lrwxrwxrwx 1 root root 15 Mar 22 02:45 /usr/bin/gcc -> /usr/bin/gcc296
# ls -l /usr/bin/g++
lrwxrwxrwx 1 root root 15 Mar 22 02:48 /usr/bin/g++ -> /usr/bin/g++296
After rectifying the mentioned softlinks you can restart the patch.
Apps Login page is not being displayed properly
Error messages as found in error logs:
IAS Cache initialization failed. The Distributed Caching System failed to initialize on port: <port#>. The list of hosts in the distributed caching system is: <host_name>. The port <port> should be free on each host running the JVMs. The default port <port#> can be overridden using -Doracle.apps.jtf.cache.IASCacheProvidercacheProvider.port=<port number>
Solution:
There are many reasons for this error. Some of the possibilites are discussed below:
1) Check for the parameters nprocs in the file jerv.conf and compare this with the no. of ports in jserv.properties.
The rule is that the number of ports specified in jserv.properties should be greater than or equal to the total number of processes
mentioned in jserv.conf
2) If this is not the issue, then check for the entries in /etc/hosts file.
The mapping of the ip addresses of virtual name and the physical hostname might be wrong
3) If this also doesn't help then try to enable 'debug' parameter in the files httpd.conf, jserv.conf and jserv.properties and collect additional info w.r.t the error.
IAS Cache initialization failed. The Distributed Caching System failed to initialize on port: <port#>. The list of hosts in the distributed caching system is: <host_name>. The port <port> should be free on each host running the JVMs. The default port <port#> can be overridden using -Doracle.apps.jtf.cache.IASCacheProvidercacheProvider.port=<port number>
Solution:
There are many reasons for this error. Some of the possibilites are discussed below:
1) Check for the parameters nprocs in the file jerv.conf and compare this with the no. of ports in jserv.properties.
The rule is that the number of ports specified in jserv.properties should be greater than or equal to the total number of processes
mentioned in jserv.conf
2) If this is not the issue, then check for the entries in /etc/hosts file.
The mapping of the ip addresses of virtual name and the physical hostname might be wrong
3) If this also doesn't help then try to enable 'debug' parameter in the files httpd.conf, jserv.conf and jserv.properties and collect additional info w.r.t the error.
Steps to Download the Patch from Unix box
As the ftp updates.oracle.com got retired, the following procedure can be utilized for downloading patches directly onto the UNIX servers.
* Login to "My Oracle Support"
* Search for the patch
* Go to the download page
* Click on "show details" link beneath the "Download" button
* Right click on the patch name and Copy URL
Then to download the patch using "wget" follow these instructions:
* Check "wget" command is available OR install it.
Run the following command using your My Oracle Support login and password:
wget --http-user=<username> --http-password=<password>--output-document=<filename> "paste the above copied address here in quotes"
Example:
wget --http-user=user@company.com --http-password=password --output-document=p6194129_60828_LINUX.zip "https://updates.oracle.com/Orion/Services/download/p6194129_60828_LINUX.zip?aru=9347149&patch_file=p6194129_60828_LINUX.zip&patch_password="
By this way one can download the patches faster and easier.
* Login to "My Oracle Support"
* Search for the patch
* Go to the download page
* Click on "show details" link beneath the "Download" button
* Right click on the patch name and Copy URL
Then to download the patch using "wget" follow these instructions:
* Check "wget" command is available OR install it.
Run the following command using your My Oracle Support login and password:
wget --http-user=<username> --http-password=<password>--output-document=<filename> "paste the above copied address here in quotes"
Example:
wget --http-user=user@company.com --http-password=password --output-document=p6194129_60828_LINUX.zip "https://updates.oracle.com/Orion/Services/download/p6194129_60828_LINUX.zip?aru=9347149&patch_file=p6194129_60828_LINUX.zip&patch_password="
By this way one can download the patches faster and easier.
Autoconfig on FE node fails with TNS error
adcfgclone.pl or adconfig.pl was failing with the below error even though the listener is running in the db server
ORA-12541: TNS: no listener
You may further notice that it is trying to connecto to DB via a different port# whereas the DB listener is running on a different port#.
Well, the reason for your problem is the database context file was not updated with the new port# and hence the Autoconfig on FE node was erroring out.
Please do the following steps to rectify the error:
• Update the context file on db node with the original port# and run Autoconfig.
• Then run the Autoconfig on FE node which will complete successfully.
ORA-12541: TNS: no listener
You may further notice that it is trying to connecto to DB via a different port# whereas the DB listener is running on a different port#.
Well, the reason for your problem is the database context file was not updated with the new port# and hence the Autoconfig on FE node was erroring out.
Please do the following steps to rectify the error:
• Update the context file on db node with the original port# and run Autoconfig.
• Then run the Autoconfig on FE node which will complete successfully.
Library Path issue during DB autoconfig
On HP-UX Itanium server, while running autoconfig on the db tier it might fail with the below error:
AutoConfig could not successfully execute the following scripts:
Directory: /oracle/product/9.2.0.7/TS2QTC/appsutil/install/TS2QTC_tst-db54
afdbprf.sh INSTE8_PRF 137
[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /oracle/product/9.2.0.7/TS2QTC/appsutil/install/TS2QTC_tst-db54
adcrobj.sh INSTE8_APPLY 137
AutoConfig is exiting with status 2
Further investigation of the log file will reveal the below two errors:
/oracle/product/9.2.0.7/<SID>/appsutil/install/<CONTEXT_NAME>/afdbprf.sh[82]: 14372 Killed
.end std out.
/usr/lib/hpux64/dld.so: Unable to find library 'libclntsh.so.9.0'.
/oracle/product/9.2.0.7/<SID>/appsutil/install/<CONTEXT_NAME>/adcrobj.sh[117]: 16041 Killed
Solution:
Edit xml file to include LD_LIBRARY_PATH=$ORACLE_HOME/lib
and re-run the autoconfig
AutoConfig could not successfully execute the following scripts:
Directory: /oracle/product/9.2.0.7/TS2QTC/appsutil/install/TS2QTC_tst-db54
afdbprf.sh INSTE8_PRF 137
[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /oracle/product/9.2.0.7/TS2QTC/appsutil/install/TS2QTC_tst-db54
adcrobj.sh INSTE8_APPLY 137
AutoConfig is exiting with status 2
Further investigation of the log file will reveal the below two errors:
- ERRORCODE = 137 ERRORCODE_END
/oracle/product/9.2.0.7/<SID>/appsutil/install/<CONTEXT_NAME>/afdbprf.sh[82]: 14372 Killed
- adcrobj.sh exiting with status 137
.end std out.
/usr/lib/hpux64/dld.so: Unable to find library 'libclntsh.so.9.0'.
/oracle/product/9.2.0.7/<SID>/appsutil/install/<CONTEXT_NAME>/adcrobj.sh[117]: 16041 Killed
Solution:
Edit xml file to include LD_LIBRARY_PATH=$ORACLE_HOME/lib
and re-run the autoconfig
Subscribe to:
Posts (Atom)