Disable 11g gather stats

I know this is very simple,but here it is,


 col JOB_NAME for a30
 col START_DATE for a30
 col LAST_START_DATE for a30
 col NEXT_RUN_DATE for a30
select JOB_NAME,START_DATE,LAST_START_DATE,NEXT_RUN_DATE,JOB_ACTION from  DBA_SCHEDULER_JOBS where job_name like '%GATHER%'

SELECT owner, job_name, job_class, enabled FROM dba_scheduler_jobs;

exec dbms_scheduler.disable('GATHER_SYS_STATS_JOB');

OIM Bundle patch

I was applying bundle patch on OIM as per,

https://updates.oracle.com/Orion/Services/download?type=readme&aru=15248238

Issue:
+ opatch apply was failing.The logs are here,

/test/fmw/product/111/iam_111/server/setup/deploy-files/patch_oim_wls.log

Saw this error,
/test/fmw/product/111/iam_111/server/setup/deploy-files/setup.xml:337: Unable to delete directory --->I renamed the folder manually.

+ The script "sh patch_oim_wls.sh"  looks for profile files.Need to update weblogic.profile as well.

+ Later got the error as in Doc ID 1441378.1 .Set the path as per the note.

Later it failed with errors like,

With errors like,
java.lang.RuntimeException: Can't find resource 'solrconfig.xml' in classpath or '${RBACX_HOME}/.indexes/cores/core01/conf/',

java.lang.RuntimeException: Can't find resource 'solrconfig.xml' in classpath or '${RBACX_HOME}/.indexes/cores/core08/conf/', cwd=/twrl2s/admin/user_projects/oia_domain

RBACX_HOME is set in .profile.But i added additionally in setDomainEnv.sh

JAVA_PROPERTIES="-Dplatform.home=${WL_HOME} -Dwls.home=${WLS_HOME} -Dweblogic.home=${WLS_HOME}  -DRBACX_HOME=/test/fmw/product/111/oia_111"


Hope this port will be helpful.Took me sometime to figure out

Portal 11g patch issue

While applying patch on portal came across this issue and was able to fix it.

Applying Portal Patch!!

Copying file /prod/fmw/patches/13985116/custom/scripts/P13985116_PATCHBUNDLE.zip to /prod/fmw/product/111/portal/portal/patch/oneoffs/P13985116_PATCHBUNDLE.zip

CMD=./ptlpatch.csh  -z P13985116_PATCHBUNDLE.zip -s dev1_portal -p oracle -c host:port:SID

Return Code = 1

Command invocation returned Error... '', Return Code = 1

Execution of PRE script failed, with return value = 1

Do you want to proceed? [y|n]

y

User Responded with: Y

Patching component oracle.portal.midtier, 11.1.1.4.0...

Copying file to "/prod/fmw/product/111/portal/portal/patch/oneoffs/13985116.txt"

ApplySession adding interim patch '13985116' to inventory

Verifying the update...

Inventory check OK: Patch ID 13985116 is registered in Oracle Home inventory with proper meta-data.

Files check OK: Files from Patch ID 13985116 are present in Oracle Home.

--------------------------------------------------------------------------------

The following warnings have occurred during OPatch execution:

1) OUI-67133:Execution of PRE script failed, with return value = 1

--------------------------------------------------------------------------------

FIX:

===

+ ptlpatch.csh didnot have execute permission.Give it the 755 permission.
+ Added the tnsnames.ora in portal home ,it was unable to connect to database.
+ opatch apply /prod/fmw/patches/13985116 -pre -s dev1_portal -p oracle -c host:port:SID  -opatch_pre_end-->No quotes needed in syntax!

Issue with soa managed server

Today while starting soa managed server,i was getting issues.It used to go to starting mode and then to failed not restartable.I checked logs and found that AIA deployments were failing,

===========

WARNING: Error during preRegister for MBean oracle.dfw:name=Streamer,type=oracle.dfw.jmx.Streaming 

java.lang.RuntimeException: java.lang.NoClassDefFoundError: Could not initialize class oracle.dfw.impl.common.TempFileManager  at oracle.as.jmx.framework.generic.spi.interceptors.LoggingMBeanInterceptor.internalPreRegister(LoggingMBeanInterceptor.java:663) 

at oracle.as.jmx.framework.generic.spi.interceptors.AbstractMBeanInterceptor.doPreRegister(AbstractMBeanInterceptor.java:180) 

at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.preRegister(OracleStandardEmitterMBean.java:611) 

at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.preRegisterInvoke(DefaultMBeanServerInterceptor.java:1010) 

at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(DefaultMBeanServerInterceptor.java:938) 

at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(DefaultMBeanServerInterceptor.java:917) 

at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:312) 

at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:482) 

oracle/dfw/impl/common/TempFileManager --->Appeared many times.

It had a simple fix.

1. Check /tmp directory in your machine and check if having oracle-dfw* files created by a different user other than the "installation owner".

If so, delete them all.

2. If you want to have multiple installations, by different users, ensure to set the following java property Into the EXTRA_JAVA_PROPERTIES for the setDomainEnv.sh:

-Djava.io.tmpdir=<path>

Error on admin console

After a bounce on weblogic domain i got the below error after logging to admin console

================

Error opening /jsp/changemgmt/ChangeManager.jsp.

The source of this error is:
java.lang.NullPointerException
 at com.bea.console.taglib.changemgmt.ChangeCenterTag.doStartTag(ChangeCenterTag.java:82)
 at jsp_servlet._jsp._changemgmt.__changemanager._jspService(__changemanager.java:172)
 at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
 at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
 at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:183)
 at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:523)
 at weblogic.servlet.internal.RequestDispatcherImpl.include(RequestDispatcherImpl.java:444)
 at org.apache.beehiv

=====================

I thought someone edited the file and forgot to activate changes.I checked the DOMAIN_HOME pending folder to see if there was a change done.Found nothing here.

To fix this issue i tried restarting admin after clearing tmp and cache but no use,

We can fix this issue as below:

1. Navigate to <Domain_Home>/pending folder. In this folder, there are configuration files which are temporary config files which are cached with changes made from console. At the time of activating changes, the config.xml from the pending folder replaces the

 original config.xml and other configuration files inside the <Domain_Home>/config folder

2. Stop the Admin Server, and replace the config.xml from the <Domain_Home>/config folder with the config.xml from the <Domain_Home>/pending folder.

3. Delete all the .lok files inside <Domain_Home> like edit.lok and config.lok.

4. Restart Admin Server.

I my case i just removed the edit.lok file and restarted.