3
Jul

With AD-TXK Delta.9 and higher, Autoconfig Fails On PatchFS with error "ORA-12514: TNS:listener does not currently know of service requested

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!

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to Top