Upgrade from 11g to 12c
perl adcfgclone.pl appsTier is unable to connect to RAC database Solution: 1> Use Target System…
autoconfig failing – jtfictx.sh
Fix: SQL> exec ctxsys.ctx_adm.set_parameter(‘file_access_role’, ‘public’) PL/SQL procedure successfully completed. SQL> Relevant note: Autoconfig Failed On…
perl cr9idata.pl
on Database server fails: $ perl cr9idata.plCan’t locate File/CheckTree.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5…
How to identify OPP process
ps -ef |grep GSM or ps -ef |grep FNDOPP
ORA 16038 log 1 sequence# 158249 cannot be archived
https://community.oracle.com/thread/1081454?start=15&tstart=0 https://lokeshaggarwal.wordpress.com/2010/06/07/ora-16038-log-3-sequence-13-cannot-be-archived-ora-19504-failed-to-create-file/ ORA-16038: log 3 sequence# 13 cannot be archived ORA-19504: failed to create file “”…
weblogic error
http://oraclesoaweblogics.blogspot.com/2015_04_15_archive.html Wednesday, April 15, 2015 Weblogic domain creation error “Unable to invoke parse in InvokeStaticMethodTask”…
Concurrent requests queries
http://www.erpschools.com/scripts/sysadmin-aol/concurrent-requests-programs-executed-specific-user http://dilipappsdba.blogspot.com/2015/07/long-running-concurrent-requests.html https://techgoeasy.com/concurrent-manager-queries/
RAC issues
Listener issue TNSLSNR for Linux: Version 12.1.0.2.0 – Production System parameter file is /d01/oracle/product/12.1.0/dbhome_1/network/admin/ebsdb1_linux1/listener.ora Log…
ORA-15001: diskgroup does not exist or is not mounted. ORA-15040: diskgroup is incomplete
https://jameshuangsj.wordpress.com/2017/09/05/ora-15001-diskgroup-data-does-not-exist-or-is-not-mounted-ora-15040-diskgroup-is-incomplete/ ORA-15001: diskgroup does not exist or is not mounted. ORA-15040: diskgroup is incomplete restore…
Clone issues
Issues 1>Concurrent manager was not starting https://moreappsdba.blogspot.com/2017/05/cm-was-not-coming-up-even-while-taking.html Concurrent Managers Fail to Start: “insert_fcp failed due…