While doing Oracle application cloning, I got the following error while running autconfig
AutoConfig could not successfully execute the following scripts: afdbprf.sh
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /mnt/DEVapps/oracle/trcdevdb/11.2.0/dbhome_1/appsutil/install/TRCDEV_gddevdb1
afdbprf.sh INSTE8_PRF
In log file I see this error:-
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12541: TNS:no listener
But listener is up and running,
gddevdb1.tireco.com:/mnt/DEVapps/oracle/trcdevdb/11.2.0/dbhome_1/appsutil/scripts/TRCDEV_gddevdb1>ps -ef | grep tns
root 21 2 0 Aug12 ? 00:00:00 [netns]
oraDEV 4098 1 0 20:15 ? 00:00:00 /mnt/DEVapps/oracle/trcdevdb/11.2.0/dbhome_1/bin/tnslsnr TRCDEV -inherit
Work Around / Fix -
When I did nslookup gddevdb1(hostname) and it returned a different ip address then what was defined in /etc/hosts file ... which was causing it to fail to connect to listener
After running autoconfig again, it completed successfully.
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
vi /mnt/DEVapps/oracle/trcdevdb/11.2.0/dbhome_1/appsutil/log/TRCDEV_gddevdb1/08222201/adconfig.log
AutoConfig completed successfully.
AutoConfig could not successfully execute the following scripts: afdbprf.sh
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /mnt/DEVapps/oracle/trcdevdb/11.2.0/dbhome_1/appsutil/install/TRCDEV_gddevdb1
afdbprf.sh INSTE8_PRF
In log file I see this error:-
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12541: TNS:no listener
But listener is up and running,
gddevdb1.tireco.com:/mnt/DEVapps/oracle/trcdevdb/11.2.0/dbhome_1/appsutil/scripts/TRCDEV_gddevdb1>ps -ef | grep tns
root 21 2 0 Aug12 ? 00:00:00 [netns]
oraDEV 4098 1 0 20:15 ? 00:00:00 /mnt/DEVapps/oracle/trcdevdb/11.2.0/dbhome_1/bin/tnslsnr TRCDEV -inherit
Work Around / Fix -
When I did nslookup gddevdb1(hostname) and it returned a different ip address then what was defined in /etc/hosts file ... which was causing it to fail to connect to listener
After running autoconfig again, it completed successfully.
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
vi /mnt/DEVapps/oracle/trcdevdb/11.2.0/dbhome_1/appsutil/log/TRCDEV_gddevdb1/08222201/adconfig.log
AutoConfig completed successfully.
No comments:
Post a Comment