DBA in the Trenches

After aborting a adop session I ran into a bit of a problem with fs_clone. Log files weren't helping so I ran: adop phase=fs_clone loglevel=statement This is what I saw *******FATAL ERROR******* PROGRAM : (/oa01/oradata/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl) TIME    : Mon Jan  4 16:45:03 2016 FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] MESSAGES: SQLPLUS error: buffer= SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jan 4 16:45:03 2016 Copyright (c) 1982, 2005, Oracle.  All rights reserved. SQL> SQL> Connected. SQL> SELECT clone_status||',' FROM ad_adop_session_patches WHERE status in ('R','F','N') AND bug_number = 'CLONE' AND node_name = 'oraapdev' AND adop_session_id =                                                                                                                                                             * ERROR at line 1: ORA-00936: missing expr

If you want to run scripts from one server to the next or possibly a central server where you run clones and backups from you'll want to authorize the server on each of the servers you wan tto connect to. First thing you need to do is generate a public and private key. Remember to keep the password black, I also use the defaults as you can see below. ssh-keygen Using ssh copy keys to target server or a shared directory like below that all the environments see cp $HOME/.ssh/id_rsa.pub /nfs_share/tmp/id_rsa.pub Check if the ssh directory exists on the target server, if not create it mkdir -p ~/.ssh touch ~/.ssh/authorized_keys chmod 600 ~/.ssh/authorized_keys Copy the public keys into the authorized_keys cat /nfs_share/tmp/id_rsa.pub >> ~/.ssh/authorized_keys

ADOP is in my opinion still pretty half baked. This is a critical tool that just isn't as intuitive as the old adpatch was. However we move with the times and get the hang of the new way of doing things. Along the way you might want to abort or cancel a patching cycling. With the two file systems and db editioning this can be a bit more to manage. I have learnt the hard way so you need to use the full cleanup after aborting a session. adop phase=abort adop phase=cleanup cleanup_mode=full

I needed to run a clone and was running into a really head scratcher. As is Oracle\'s way they sometimes enjoy giving us DBA's a bit of detective work to do. As usual I kept knocking my head into various brick walls instead of tracking back through the logs. Eventually I came up with the problem Start to configure the run filesystem. You can do a dualfs from AD-TXK Delta 7 but for now I just needed to get this up and running: perl adcfgclone.pl appsTier START: Creating FMW Home. Running /u03/APPLUAT/UAT/fs1/EBSapps/comn/clone/FMW/ pasteBinary.sh -javaHome /u03/APPLUAT/UAT/fs1/EBSapps/comn/util/jdk64 -al /u03/APPLUAT/UAT/fs1/EBSapps/comn/clone/FMW/FMW_Home.jar -tl /u03/APPLUAT/UAT/fs1/FMW_Home -invPtrLoc /etc/oraInst.loc -ldl /u03/APPLUAT/UAT/fs1/inst/apps/UAT_erpapp05/admin/log/clone/fmwT2PApply -silent true -debug true -executeSysPrereqs false Script Executed in 21933 milliseconds, returning status 255 ERROR: Script failed, exit code 255 Oracle has left me a cryptic

When checking for the latest PSU you might want to know what the current PSU is. I also keep a list of PSU updates and latest CPU updates on the Critical Patch Updates page. If the below returns nothing you are on the base level, e.g. 11.2.4.0 opatch lsinventory -bugs_fixed | egrep -i 'PSU|DATABASE PATCH SET UPDATE'  10248523 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PSU 11.2.0.2.1 11724916 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011) 12419331 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011) 12827726 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011) 13343424 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPUJAN2012) 13696224 13696224 Fri Mar 30 14:00:25 EDT 2012 DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPUAPR2012) Reference : Patch Set Updates for Oracle Products (Doc ID 854428.1

Cloning the instance I ran into this weird error. Was not sure what to do but after learning my lesson I dug through the error logs after seeing this in the adcfgclone log file. START: Creating new WLS domain. Running /u03/APPLYES/YES/fs2/FMW_Home/oracle_common/bin/pasteConfig.sh -javaHome /u03/APPLYES/YES/fs2/EBSapps/comn/util/jdk64 -al /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/WLS/EBSdomain.jar -tdl /u03/APPLYES/YES/fs2/FMW_Home/user_projects/domains/EBS_domain_YES -tmw /u03/APPLYES/YES/fs2/FMW_Home -mpl /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/WLS/plan/moveplan.xml -ldl /u03/APPLYES/YES/fs2/inst/apps/YES_erpapyes/admin/log/clone/wlsT2PApply -silent true -debug true -domainAdminPassword /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/tempinfo.txt Script Executed in 1903 milliseconds, returning status 255 ERROR: Script failed, exit code 255 Dig a bit deeper into the log files cd /u03/APPLYES/YES/fs2/inst/apps/YES_erpapyes/admin/log/clone/wlsT2PApply cat CLONE2016-01-10_04-37-

During a PSU check I saw a list of patches that are recommended. I saw a list that has JVM and the DB bundled. I wasn't sure what this was and which one I should apply. After some digging around I understood that I could check whether I had JVM installed on the database although now I understand that with EBS it will probably be used by the database. This quick and dirty SQL will give you a list of components loaded into the database. One of which will be JServer JAVA Virtual Machine Release XXXXXXX. If its not there you probably don't have it installed. SQL> set pages 100 SQL> select * from all_registry_banners; BANNER -------------------------------------------------------------------------------- Oracle Database Catalog Views Release 11.2.0.4.0 - 64bit Production Oracle Database Packages and Types Release 11.2.0.4.0 - Development JServer JAVA Virtual Machine Release 11.2.0.4.0 - Development Oracle XDK Release 11.2.0.4.0 - Development Oracle Database Java Pac

When opening a form the Java Security pop shows but then freezes and you can't continue. The only way to close the form is via Task Manager. Solution Control panel > Java > Advanced > Java Plugin > [Disable] Enable the Next Generation Java Plug-in. Reference: ORACLE FORMS – THE APPLICATION’S DIGITAL SIGNATURE HAS AN ERROR – YOUR FORMS APPLICATION IS FOZEN