19c Upgrade with EBS R12.1.3

[Karthik]

Hi Erman,

We are upgrading our EBS R12.1.3 Instance DB from 11.2.0.4 to 19.3 using oracle document Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (Doc ID 2580629.1).

we have completed step "post PDB script" txkPostPDBCreationTasks.pl and autoconfig on DB side successfully. After this step, In tnsnames.ora file under $ORACLE_HOME/network/admin/CONTEXT_NAME are updated with "ebs_PBD_SID" in service name. see below example.

EBSDBA=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxxxxxx)(PORT=xxxx))
            (CONNECT_DATA=
                (SERVICE_NAME=ebs_EBSDBA)
                (INSTANCE_NAME=EBSDBACDB)
            )
        )

when checked in fnd_database_services table, can see that SERVICE_NAME column is "ebs_EBSDBA"

Can you please help on this, how it got changed.

Thanks,
Karthik

[ErmanArslansOracleBlog]

autoconfig touches FND_DATABASE_SERVICES. This is known.
txkPostPDBCreationTasks.pl may also touch the FND_DATABASE_SERVICES, we can know that.. We need to analyze the code, but I can't do that right now (I m a little busy)

Why do you ask this? How does this affect you?
Please explain your problem in a more detailed context, so I can help..

[Karthik]

Hi Erman,

We have done upgrade our EBS R12.1.3 database from 11.2.0.4 to 19c, upgrade completes success. But when we ran txkPostPDBCreationTasks.pl as part of 19c upgrade, autoconfig was ran at the end by itself and
we observed that our database service name was updated with prefix "ebs_". So need to know why it got changed.

Thanks,
Karthik

[ErmanArslansOracleBlog]

Hmmm.. Probably, it is a special case.. (Like the service name is set to "ebs_patch" for the Patch edition tns entry)

Interesting.. so you probably want it to be set to EBSDBA, right?

This may be related with the CDB and PDB..
What are your CDB SID and PDB SID?

[Karthik]

Hi Erman,

Below are the SIDs,

CDB SID= EBSDBACDB
PDB SID= EBSDBA

Before running txkPostPDBCreationTasks.pl, it was set to EBSDBA and after that it was changed to "ebs_EBSDBA".

Now we are planning upgrade to R12.2, so confused what will be service name for Patch edition tns entry in R12.2.

Thanks,
Karthik

[ErmanArslansOracleBlog]

Okay.

Then this is done by txkOnPremPrePDBCreationTasks.pl itself (or any other code or script that it execute/run during its run)
autoconfig templates may also be updated with the recent patches and that ebs_ prefix may come from those templates as well..

You can search that prefix in those templates and decide whether the prefix is coming from there.
autoconfig templates should be present in each PROD_TOP inside admin/template directory.

Example command ->

grep -rnw '/path/to/somewhere/' -e 'ebs_'

[ErmanArslansOracleBlog]

Or a command like the following ->

grep -Ril "text-to-find-here" /directory

this will search the directory and all the subdirectories of it, and try to find the text inside the files.