Re: 19c upgrade with EBS 12.1.3 environment

Posted by raiq1 on Feb 17, 2022; 7:26am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/19c-upgrade-with-EBS-12-1-3-environment-tp10619p10671.html

Hi,

As per your advice, I have followed the notes that you have mentioned but there is no luck.

Mean while again I run postpdbcreation and closely monitor the log , I have analyzed few things.

postpdbcreation are run autoconfig internally , at one stage it has changed the tnsnames.ora file with SERVICE_NAME= <CDBNAME> , it should be SERVICE_NAME=<PDBNAME>.

This changes has affected at the end of autoconfig.


[oracle@ebs12 TXK_POST_PDB_Thu_Feb_17_02_49_17_2022]$ grep tnsnames txkPostPDBCreationTasks.log

TARGET : /d01/oracle/TEST/19.0.0/appsutil/log/TXK_POST_PDB_Thu_Feb_17_02_49_17_2022/tns_admin_pdb_temp/tnsnames.ora
SOURCE : /d01/oracle/TEST/19.0.0/network/admin/TEST_ebs12/tnsnames.ora
TARGET : /d01/oracle/TEST/19.0.0/appsutil/log/TXK_POST_PDB_Thu_Feb_17_02_49_17_2022/tns_admin_pdb_bkp/tnsnames.ora
SOURCE : /d01/oracle/TEST/19.0.0/appsutil/log/TXK_POST_PDB_Thu_Feb_17_02_49_17_2022/tns_admin_pdb_temp/tnsnames.ora
TARGET : /d01/oracle/TEST/19.0.0/network/admin/TEST_ebs12/tnsnames.ora

We have grep tnsnames in txkPostPDBCreationTasks.log , the SOURCE has correct entries but when it moved to TARGET it has changed tnsnames.ora

SOURCE  --->  TEST= /d01/oracle/TEST/19.0.0/appsutil/log/TXK_POST_PDB_Thu_Feb_17_02_49_17_2022/tns_admin_pdb_temp/tnsnames.ora

Below are the tnsnames. ora in SOURCE destination .


TEST=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ebs12.appsdba.info)(PORT=1542))
            (CONNECT_DATA=
                (SERVICE_NAME=TEST)
                (INSTANCE_NAME=TESTCDB)
            )
        )

TARGET ---> /d01/oracle/TEST/19.0.0/network/admin/TEST_ebs12/tnsnames.ora

TEST=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ebs12.appsdba.info)(PORT=1542))
            (CONNECT_DATA=
                (SERVICE_NAME=TESTCDB)
                (INSTANCE_NAME=TESTCDB)
            )
        )


I dont know , from where autoconfig has getting the information and change the target tnsnames.ora to SERVCE_NAME=<TESTCDB>

Hope you understand all the scenario, for your informaton sending the logfile to you.

Regards,
RaiqtxkPostPDBCreationTasks.log