DBA in the Trenches

In R12.2 with Weblogic now playing a huge role as well as java also creating resource heavy processes you will eventually run into a situation where you want to add servers to Weblogic. I'd actually recommend adding at least one more oa_core server as this is the one we've noticed is causing most of the issues. Add oacore_server2 via command line: perl /patch/115/bin/adProvisionEBS.pl ebs-create-managedserver -contextfile=$CONTEXT_FILE -managedsrvname=oacore_server2 -servicetype=oacore -managedsrvport=7205 -logfile=/tmp/addMS_oacoreserver2.log Started the new managed server as follows, admanagedsrvctl.sh start  oacore_server2 Added details of the newly added managed server into the OHS configuration files mod_wl_ohs.conf and apps.conf via command line as below: perl /patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE -configoption=addMS -oacore=testserver.example.com:7205 Bounce the apache server: sh /adapcctl.sh stop sh /adapcctl.sh start Reference: M...

Had a few issues come up in the alert log regarding memory with dreaded ORA-600 and ORA-7445. The search tool didn't really show anything regarding the problems so opened an SR and need to attach the incident package. Pretty simple setup and extracting and something I'd like to dig into a bit. Here's how its done: #adrci adrci>show incident -mode detail -p "incident_id=117345" adrci>set homepath diag/rdbms/test/TEST adrci>IPS CREATE PACKAGE INCIDENT 117345 Created package 3 based on incident id 117345, correlation level typical adrci>IPS GENERATE PACKAGE 3 IN /tmp Generated package 3 in file /tmp/ORA7445pe_20160211093814_COM_1.zip, mode complete

This is one of those where I'm left scratching my head. During the clone I was getting issues with the LOCAL_LISTENER parameter. The clone would not complete with this value set. Now when I go and create a new adop session using adop phase=prepare I get the following error [ERROR]     Cannot connect to database [ERROR]     Error Message: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (DBD ERROR: OCIServerAttach) I found a note to fix the issue and what does it say. I need to set the LOCAL_LISTENER. So I set the listener and now it runs. Again I'm lost for words with this new system of cloning and patching in R12.2 Reference adop phase=prepare fails with: Error Message : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (Doc ID 2007225.1)

Need to find the location of the alert log file. It's by default in the background dump destination. You can find it in the parameters of the instance. SQL> show parameter background_dump_dest NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ background_dump_dest                 string      /u01/app/oracle/diag/rdbms/dev/dev/trace SQL>  !ls -ltr /u01/app/oracle/diag/rdbms/dev/dev/trace/al* -rw-r-----. 1 oracle oinstall 134067 Jan 23 10:59 /u01/app/oracle/diag/rdbms/dev/dev/trace/alert_dev.log

Ran into this issue when trying to start up the services in a cloned instance. It took a bit of head scratching and google came to the rescue. Not sure what exactly is happening but I ran this andthen restarted the forms_server1 from weblogic and I was able to login to the instance. admanagedsrvctl.sh start oafm_server1 -Dweblogic.security.allowCryptoJDefaultJCEVerification=true Reference Oracle Forums

Came across this issue at a customer site or should I say my Liron ran across the issue and asked Arty and myself to investivate. He gave us the hint that it looked like XML Database was not installed. exec sys.dbms_network_acl_admin.create_acl (acl => 'test.xml', description => 'test acl', principal => 'test', is_grant => true, privilege => 'resolve') ;  PLS-00201: identifier 'DBMS_XEVENT.XDBREPOSITORYEVENT' must be declared Check which options are selected in the database select * from v$option order by value,parameter; PARAMETER                                                        VALUE ---------------------------------------------------------------- ---------- Active Data Guard                                        ...

Set the following to get a tracefile: SRW.DO_SQL ('alter session set events=''10046 trace name context forever, level 4'' tracefile_identifier=''REPORT'' '); Need to run this on the Database Tier select p.value from v$parameter p where 1=1 and p.name like 'user_dump_dest'; tkprof input.trc output.prf EXPLAIN=apps/apps SYS=NO You can know use this in a before report trigger srw.user_exit('FND SRWINIT');   srw.message(200,'XX_DEBUG_PRINT:'||fnd_profile.value('XX_DEBUG_REP'));  if (nvl(fnd_profile.value('XX_DEBUG_PRINT'),'N') = 'Y') then      SRW.DO_SQL ('alter session set events=''10046 trace name context forever, level 4'' tracefile_identifier=''REPORT'' '); end if;