Tuesday, July 12, 2011

server.out files rotation

I can't claim to have found this solution,one of my colleague hit upon this solution.Here it goes..

Q: Customer says that their server.out files are going upto 4GB causing server performance issues.These are not the diagnostic or log files,as we earlier assumed.But get created under a weblogic domain's managed server's log folder.Customer wanted it to rotate every 20MB.This cannot be controlled from weblogic as we assumed.

Here is how it was solved.

mv /etc/cron.daily/logrotate /etc/cron.hourly/

take backup and open the /etc/logrotate.conf and make changes as given below:

$DOMAIN_HOME/servers/<server-name>/logs/*.out 
{
daily
missingok
copytruncate
rotate 20
size=20Mb
 postrotate
mv  $DOMAIN_HOME/servers/<server-name>/logs/*.out.* $DOMAIN_HOME/servers/<server-name>/logs/archivedlogs
endscript 
    }

substitute domain home with absolute path

Saturday, January 8, 2011

EM doesn't work after OIM 11g installation.

<BEA-101162> <User defined listener oracle.sysman.eml.app.ContextInitializer failed: java.lang.NoClassDefFoundError: HTTPClient/ProtocolNotSuppException."

Solution:
The  workaround is to copy http_client.jar:

from
$ORACLE_HOME/oui/jlib

to
$DOMAIN_HOME/lib

After This change EM console is accessible.

Trivia on Oracle Data Integrator

Upgrade ODI ??How to find the exact patch number.

http://www.myoraclesupports.com/content/master-note-oracle-data-integrator-odi-and-legacy-sunopsis-releases-and-patches

Thursday, December 23, 2010

Disable oracle database direct NFS

The DB was migrated to sun filer.The database came up ,but there were issues in bringing up hyperion shared services.Also we noticed that "alter system switch logfile" command was hanging.There were entries in alert log as below,

===
Direct NFS: mount complete dir /vol/XXXXXXX
Direct NFS: mount complete dir /vol/XXXX   fsport 2049
====

We disabled direct NFS on database,which resolved the issue.
1. mv ${ORACLE_HOME}/lib/libodm11.so ${ORACLE_HOME}/lib/libodm11.so.bak
2. rm ${ORACLE_HOME}/lib/libodm11.so
3. ln -s ${ORACLE_HOME}/lib/libodmd11.so ${ORACLE_HOME}/lib/libodm11.so
4. start DB

Sunday, November 28, 2010

Upgrade BI publisher

I had upgraded BI publisher from 10.1.3.4 to 10.1.3.4.1 .We wanted to upgrade as there were issues with BI and LDAP integration.So support suggested Apply Patch 10256764 i.e. a BI upgrade.Upgrade solved the issue but a new issue with scheduler popped up.Just login to BI publisher console and click on scheduler tab it throws up the error,

    java.lang.ClassCastException: oracle.toplink.exceptions.QueryException

I was pretty baffled on this issue,googled and searched on oracle .I couldn't find a similar issue or solution.Here is what that needs to be done during upgrade.

1.Create a new schema in database.
2.Navigate to Admin->System Maintenance ->Scheduler Configuration.
3.Install schema for newly created schema in database.

These steps are missed out in patch readme or upgrade steps.But if not done,it causes issues with scheduler.