Modern Oracle DBA

 If we try to connect PDB getting below error SQL> alter session set container="dev2"; ERROR: ORA-03114: not connected to ORACLE Solution: Check listener is working normally Below action plan no need application bounce   Close and reopen the PDB SQL> alter pluggable database "dev2" close; Pluggable database altered. SQL> alter pluggable database "dev2" open; Pluggable database altered. SQL> alter session set container="dev2"; Session altered. If “alter pluggable database "dev2" close” command taking time Please check how many users connected database ps -ef |grep -i local=no If more user connected open duplicate session connect sqlplus and startup force command. But startup force command is not recommended based on the scenarios we can use it. 

  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/j...

fnd_conc_clone.setup_clean : fnd_conc_clone is the package name setup_clean is procedure name After clone we must need to run the fnd_conc_clone.setup_clean script It will be clear the below tables in target node information in to source node table fnd_concurrent_queue_size fnd_concurrent_queues_tl fnd_concurrent_queue_size fnd_concurrent_queues fnd_nodes Syntax: $sqlplus apps/<apps_password> SQL> exec fnd_conc_clone.setup_clean; PL/SQL procedure successfully completed. SQL> commit; Commit complete. Once the script was executed must run the autoconfig in DB and Middle-Tier   Cmclean.sql We use the cmclean.sql scrip clean the running and pending requests Down the concurrent manager and check if any concurrent program running/not(ps- ef |grep FNDLIBR, ps- ef |grep FNDOPP) Cmclean.sql script is not recommended by oracle. R12 will user cpadmin.sh and  concurrent manager recovery wizard. It wil...

Step1: Login and choice the system Administrator Responsibility and choice                            profile->system Step2:   Query the profile option in “ SITE%” Step3: Change the site name in your environment name like DEV,UAT,etc… Step4: Save the settings and logout the application after login and check your modified site name in EBS

I explained Cloning step by step procedure for database and R12.2 application. My Database version 11.2.0.3.0         1. Preclone db tier and application Tier     2. Copy the apps Tier  and db home only to target server     3. Take Rman full backup and copy the backup to target server            cd [RDBMS ORACLE_HOME]/appsutil/clone/bin              $ perl adcfgclone.pl dbTechStack                         Run adcfgclone dbTechStack This files are to be restored to a different location: db_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data') log_file_name_convert=('/oracle/PROD/db/data' , '/oracle/CLONE/db/data') $ sqlplus '/as sysdba' SQL> s...