Re: 19c upgrade with EBS 12.1.3 environment

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

sir,

as per your query, result below.

SQL> select SERVICE_ID,NAME from dba_services;

SERVICE_ID NAME
---------- ----------------------------------------------------------------
         1 SYS$BACKGROUND
         2 SYS$USERS
         5 TESTCDBXDB
         6 TESTCDB


one more thing i have realised, after autoconfig run, when i check tnsnames.ora we have found

ebs_TEST service but this service are not available any where, even if i grep context file

[oracle@ebs12 appsutil]$ grep s_dbService TEST_ebs12.xml
      <service_names oa_var="s_dbService">ebs_TEST</service_names>

From where it has fetch ebs_TEST in service name.

Even tnsnames.ora also same .

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

kindly explain me from where SERVICE_Name has ebs_TEST record to enter here.

Hope you understand my point.

Regards,