Modern Oracle DBA

  Step 1: The following environment variables must be set in order to run adbldxml.pl. ORACLE_HOME export ORACLE_HOME=<Physical Path, where the Oracle DB is installed> ORACLE_SID export ORACLE_SID=<name of the SID selected when you installed the DB> PATH export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH ORA_NLS10 export ORA_NLS10=$ORACLE_HOME/nls/data/9idata Ensure that the LD_LIBRARY_PATH environment variable is set correctly. PERL5LIB needs to be set export PERL5LIB=/u02/app/oracle/product/12.1.0/dbhome_3/perl/lib/5.16.3:/u02/app/oracle/product/12.1.0/dbhome_3/perl/lib/site_perl/5.16.3:/u02/app/oracle/product/12.1.0/dbhome_3/appsutil/perl Finally set the TNS_ADMIN variable to point to $ORACLE_HOME/network/admin/<SID>_<hostname> : export TNS_ADMIN=$ORACLE_HOME/network/admin/<SID>_<hostname> Generating DB Context file [oracle@vtebs1-lqhjl3 bin]$ perl adbldxml.pl jtop=/u02/app/oracle/product/12.1.0/dbhome_3/jdk/j

  $INST_TOP/admin/install directory and run adgendbc.sh script. [applmgr@vtebs1 secure]$ cd $INST_TOP/admin/install [applmgr@vtebs1 install]$ sh adgendbc.sh adgendbc.sh started at Sat Jul 10 03:31:35 EDT 2021 Enter the APPS username: apps Enter the APPS password: SQL*Plus: Release 10.1.0.5.0 - Production on Sat Jul 10 03:31:41 2021 Copyright (c) 1982, 2005, Oracle.  All rights reserved. Enter value for 1: Enter value for 2: Enter value for 3: Connected. [ APPS_DATABASE_ID ] Application Id : 0 Profile Value  : test Level Name: SITE INFO           : Updated/created profile option value. PL/SQL procedure successfully completed. Commit complete. Disconnected from Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production ============================== * * * * DBC PARAMETERS * * * * ============================== fnd_jdbc_buffer_min=1 fnd_jdbc_buffer_max=5 fnd_jdbc_buffer_decay_interval=300 fnd_jdbc_buffer_decay_size=5 fnd_jdbc_usable

  Solution: Check that the instance is not running using ps –ef oacore_server2 If it is, use kill -9 <pid> to stop the running instance. Remove the state file: If the managed server name is “ oacore_server2 ”, then go to the managed server machine, delete the following: cd $DOMAIN_HOME/servers/<Server-Name>/data/nodemanage/<Server-Name>.state <Server-Name>.state is the node manager file containing instance information and status. After deleting this file, the managed server can be remotely started from the Admin Console