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
