Home » Oracle » Oracle Ebuisness Suite » How to run autoconfig in 19c database with EBS

How to run autoconfig in 19c database with EBS

We know that with 19c, the EBS database is a Multitenant database, we need to take care of a few things before running Autoconfig. Here are the steps on how to run autoconfig in the 19c database

(1) We have to make sure Listener in the database server is started from the CDB $ORACLE_HOME/network/admin/listener.ora

Please verify using the below steps

lsnrctl status <CDB>

This should show the listener location as $ORACLE_HOME/network/admin/listener.ora
If the listener is started from $ORACLE_HOME/network/admin/<pdb>_<host>listener.ora. please do the below steps to start from CDB $ORACLE_HOME/network/admin/listener.ora

source $ORACLE_HOME/<pdb sid>_<host>.env 
addlnctl.sh stop <CDB>
source $ORACLE_HOME/<CDB sid>_<host>.env
adcdblnctl.sh start <CDB>

Also, verify $ORACLE_HOME/network/admin/listener.ora contains the below lines

USE_SID_AS_SERVICE_<CDB_NAME> = ON

If the $ORACLE_HOME/network/admin/listener.ora does not contain that, please add manually and restart the CDB listener

If both the above steps are not done correctly, you will get the below error while running autoconfig

getConnectionUsingSID() -->
   JDBC URL: jdbc:oracle:thin:@<host>:<port>:<pdb sid>
   Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
   JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<host>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<pdb sid>)))
   Exception occurred: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available

(2) If this is an Exadata box and you are using the Exadata default grid listener, then please add the below entry in the grid listener.ora

USE_SID_AS_SERVICE_LISTENER = ON

(3) Now source the PDB environment on the DB server and run autoconfig

source $ORACLE_HOME/<PDB SID>_<HOST>.env
$ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh

I hope you like this post on How to run autoconfig in 19c database with EBS. Please do provide the feedback

Related Articles

How to run Autoconfig in parallel: Check out this post on how to run autoconfig on multiple Apps tier in Parallel to save time.
Important Changes in Autoconfig R12.2: Autoconfig on R12.2 does not manage all the configurations like R12.0 and R12.1, This post gives us an overview of that
Oracle apps autoconfig templates location and customization: Check out this post for all the steps for Autoconfig templates customization, what important points to consider while customizing the autoconfig template
R12.2/R12/11i Common log file locations: This post has information for logfile locations in All the EBS Versions
https://docs.oracle.com/cd/E18727_01/doc.121/e12841/T120505T120514.htm

See also  How To Export -Import TDE Master Encryption Key

Leave a Comment

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

Scroll to Top