adcfgclone.pl fails on PATCH Error while generating listener.ora

classic Classic list List threaded Threaded
8 messages Options
big
Reply | Threaded
Open this post in threaded view
|

adcfgclone.pl fails on PATCH Error while generating listener.ora

big
Hi,
On R12.2.4 on AIX DB 11.2.0.4
We are cloning.
We run adcfgclone on RUN FS and it works fine.
Then we disable TRIGGER (note note 2357063.1):
SQL> exec ad_zd.ALTER_LOGON_TRIGGER('DISABLE');
PL/SQL procedure successfully completed.
SQL> commit;
We log out. Log in and source Patch file system and run adcfgclone on patch fs but it failes on autoconfig with
##########################################################################
                   Generate Tns Names
##########################################################################
Logfile:  /u01/appl_top/xxx/fs1/inst/apps/xxx/admin/log/clone/NetServiceHandler.log  
Updating s_tnsmode to 'generateTNS'
UpdateContext exited with status: 0
AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates
Instantiating Tools tnsnames.ora
Tools tnsnames.ora instantiated
adgentns.pl exiting with status 2
ERRORCODE = 2 ERRORCODE_END
.end std out.
.end err out.
   Result             : FAILED
We tried also
 sqlplus apps/apps
            exec fnd_conc_clone.setup_clean
            commit;
And then ran adautoconfig on patch fs. But failed.
Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: adcfgclone.pl fails on PATCH Error while generating listener.ora

ErmanArslansOracleBlog
Administrator
This is documented, but you are saying that you followed the documentation and disable the trigger already.
So, Send me the "NetServiceHandler.log"  and "autoconfig" log.. (if adcfg fails in autoconfig phase)
Reply | Threaded
Open this post in threaded view
|

Re: adcfgclone.pl fails on PATCH Error while generating listener.ora

ErmanArslansOracleBlog
Administrator
Bytheway, in that MOS note it says;

Disable the trigger and then "Run AutoConfig" -- not the postclone/adcfg.. Attention to that.
big
Reply | Threaded
Open this post in threaded view
|

Re: adcfgclone.pl fails on PATCH Error while generating listener.ora

big
hi,
Thank you.
How can I send you the log files?

Regards.
Reply | Threaded
Open this post in threaded view
|

Re: adcfgclone.pl fails on PATCH Error while generating listener.ora

ErmanArslansOracleBlog
Administrator
You can subscribe and upload it here.
big
Reply | Threaded
Open this post in threaded view
|

Re: adcfgclone.pl fails on PATCH Error while generating listener.ora

big
This post was updated on .
Hi,
Thank you.
I see in log of generating listener.ora:
WARNING: Could not create backup at /u01/appl_top/mysystem/fs1/inst/apps/mysystem_myserver/admin/out/07131859 for tnsnames.ora

And:
ERROR:
admk80ln.sh started at Tue Jul 13 18:59:33 CEST 2021
Enter value for 1: Enter value for 2: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Unable to generate listener.ora from database

Problem is with admk80ln.sql.

It cannot connect:
$ sqlplus /nolog @admk80ln.sql

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jul 15 10:21:52 2021

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: apps
Enter value for 2: xxxx
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

But outside of scripts, apps can connecte well with sqlplus apps@db
Password
Connected.


I upload the log.NetServiceHandler.log

Regards.

Reply | Threaded
Open this post in threaded view
|

Re: adcfgclone.pl fails on PATCH Error while generating listener.ora

ErmanArslansOracleBlog
Administrator
Well that script admk80ln.sh can not connect to the database using the listener.
Either the listener misconfigured or the tnsnames or the environment.. But! there is defitinetely a listener connection problem we have there..

admk80ln.sh ORA-12514

These kinds of things are seen in RAC setups.. a RAC configuration problem may cause this.. Local listener parameters, scan listener registrations and so on.. So you should check the all things related with the listener connections..
big
Reply | Threaded
Open this post in threaded view
|

Re: adcfgclone.pl fails on PATCH Error while generating listener.ora

big
Hi Erman.

Thank you.

 Apparently Run FS is correct. Is there any way (For example FS-CLONE) to replace Patch by Run, keeping our current Run as Run?

Regards.