adop error

[Roshan]

I am applying a patch using downtime
adop phase=apply apply_mode=downtime patches=PATCH_NUMBER

Checking for pending adop sessions...
Reading driver file (up to 50000000 bytes).
    No pending session exists.
    Staging new adop session...
    [ERROR]     Failed to execute SQL statement :
       begin
         ad_zd_adop.INSERT_ADD_NODE_RECORDS;
        end;

    [ERROR]     Error Message :
    [UNEXPECTED]Error occurred while adding new node information
    [UNEXPECTED]Unrecoverable error occured. Exiting the current session.


[STATEMENT] Please run adopscanlog utility, using the command


I am following doc (Doc ID 2030341.1)

I can see I have only 1 node:

SQL> select NODE_NAME,SUPPORT_ADMIN,DOMAIN from fnd_nodes;

NODE_NAME                      S
------------------------------ -
DOMAIN
--------------------------------------------------------------------------------
AUTHENTICATION                 N


ERPPREP                        Y
sunresort.local

[Roshan]

hostname is erpprep.sunresort.local

[ErmanArslansOracleBlog]

This might be caused by a hostname case mitmatch;
Why do you use uppercase hostnames?
Correct your hostname in /etc/hosts file.
Having lowercased hostname is always advantage, as there are lots of issue with Uppercase hostnames.

I suggest you to check this document firts, as you might be hitting it;

12.2 Adop Patching Fails With "[ERROR] Failed to execute SQL statement begin Ad_zd_adop.INSERT_ADD_NODE_RECORDS end" (Doc ID 2054360.1)

If the issue explained in the above doc. is not your case, then I suggest you to do a hostname change.

Correct your hostname in /etc/hosts file and "hostname lowercaseyourhostname" command, reboot your machine and ensure the hostname is turned to lowercase.

sqlplus app/apps
sql> exec fnd_conc_clone.setup_clean;
run autoconfig on db tier
run autoconfig on appstier
check fnd_nodes to ensure your hostname is lowercase there
rerun failed patch

[Roshan]

I changed the hostname to lower case. But autoconfig on application is completing with errors

[ErmanArslansOracleBlog]

Do a postclone on the application tier.

[Roshan]

I rerun the adautocfg appsTier? I delete FMW_HOME, inst folders?

[ErmanArslansOracleBlog]

Follow this: How To Change the Hostname In E-Business Suite R12.2.x? (Doc ID 1963018.1)

2016-03-29 9:40 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

I rerun the adautocfg appsTier? I delete FMW_HOME, inst folders?

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/adop-error-tp841p846.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[Ashok]

HI Erman

when im trying to cleanup adop section im get below erorr

[applmgr@icic patch]$ adop phase=cleanup

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /u01/applmgr/PROD/fs1/inst/apps/PROD_icic/appl/admin/PROD_icic.xml
    Patch edition context: /u01/applmgr/PROD/fs2/inst/apps/PROD_icic/appl/admin/PROD_icic.xml
    Patch file system free space: 309.36 GB

Validating system setup.
    [ERROR]     Failed to execute SQL statement:
 select AD_ZD_ADOP.GET_INVALID_NODES() from dual
    [ERROR]     Error Message:
    [ERROR]     ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)
    [UNEXPECTED]Error determining whether this is a multi-node instance
[ERROR]     Failed to execute SQL statement:
   select ad_zd_adop.validate_session_id('') from dual

[ERROR]     Error Message:
[ERROR]     ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 2 (Fail)

[Ashok]

Hi Team,

cloud you plz let me know whats the status about my erorr

[ErmanArslansOracleBlog]

Hi ASHOK,

Create a seperate issue for this! This is not related with the topic of this issue.