Symptoms:
When attempting to run autoconfig on patch fs the following error occurs.
ERROR
-----------------------
Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.
Cause:
The service name instance_name_ebs_patch is missing in the DB:
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string EBSPROD, EBSPROD_ebs_patch
In AD-TXK Delta.9 and higher, the service name to connect to the patch edition has been changed to 'instance_name_ebs_patch'.
Checking the context file we can see the right value present:
patch_service_name oa_var="s_patch_service_name">instance_name_ebs_patch
Solution:
1. Please create the service name instance_name_ebs_patch.
alter system set service_names='instance_name,instance_name_ebs_patch';
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string EBSPROD, EBSPROD_ebs_patch,EBSPROD_ebs_patch
alter system set service_names='EBSPROD,ebs_patch' scope=both;
System altered.
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string EBSPROD,ebs_patch
2. Run autoconfig on patch fs, for that:
Login to sqlplus as SYSTEM schema user.
a. Disable the ebs_login trigger using the following SQL.
SQL> alter trigger ebs_logon disable;
b. At this time Run autoconfig with the patch env sourced.
[applprod@ebsapp-01 ~]$ echo $FILE_EDITION
patch
[applprod@ebsapp-01 ~]$cd $ADMIN_SCRIPTS_HOME
[applprod@ebsapp-01 scripts]$./adautocfg.sh
c. Login to sqlplus as SYSTEM schema user to enable the ebs_login trigger using the following SQL.
SQL> alter trigger ebs_logon enable;
Autoconfig should now complete successfully!