Tuesday, March 15, 2011

OBIEE Error: BEA-001129, ORA-12514, WSM-02311

OBIEE Error: BEA-001129, ORA-12514, WSM-02311
New errors came up when I started my PC and OBIEE about two weeks ago. I started OBIEE services and http://localhost:9704/analytics page never showed up. I did a quick opmnctl check and found that Oracle BI Scheduler and Oracle Presentation Services are down.



I found the following from the logs:
Message ID: BEA-001129
Received exception while creating connection for pool "mds-owsm":
Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Message ID: WSM-02311
java.rmi.RemoteException: EJB Exception:
 nested exception is: \n oracle.adf.share.ADFShareException: MDSConfigurationException encountered in parseADFConfiguration
Failed to retrieve requested documents due to underlying error "java.rmi.RemoteException: EJB Exception:
nested exception is:
oracle.adf.share.ADFShareException: MDSConfigurationException encountered in parseADFConfiguration

Now, the only error that I can relate to was ORA-12514. This is an Oracle error so I thought to check if my connections to underlying reporting database are fine and the services are running.


I was able to successfully log on to my reporting database.

I tried logging into the database where my Oracle BI Schema resides. This is the database I used to create BI Schema using RCU for my OBIEE 11g installation.



ORA-12514 – this is exactly what I was looking for.
I checked to see if the services for this database instance are running.



To my surprise the services were running! I was expecting the Oracle services down for this instance. I went to EM for Oralce database and found this.



I restarted the Oracle services for this database to bring them up. Then, I restarted Oracle BI Services and checked status of the services after restart. This time all the services were alive.



As expected I was able to see the login screen this time.



Cheers!
Deepak