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
Thursday, December 23, 2010
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
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.
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.
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.
Subscribe to:
Posts (Atom)