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.



Saturday, October 30, 2010

Checking RCU schema version

Q.How will you know which version of RCU schema is installed?
A. Just query schema_version_registry table

Issue with Schema version

“Schema validation failed for message part CreateWorkerEBM. Please ensure at the message sender level that the data sent is schema compliant.”

We faced this issue on SOA Suite 11g R1 PS2 (11.1.1.3) requires AIA 11g R1 + patch 9717829.We were able to solve this by,

1) Login to EM Console
2) Right click on soa-infra(soa_server1).
3) Click on Common Properties in SOA administration.
4)Click on SOa infra advanced configuration properties.
5)Click on whichever property you want to change. In this case “ValidateSchema”
6)Set Validate Schema to "False"
7)click on Apply.