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

OBIEE Error- nQSError: 10058, nQSError: 16001, ORA-01035

OBIEE Error: Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

While working on Answers late yester-night, I got the following error:

Odbc driver returned an error (SQLExecDirectW).

Error Details

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 16001] ODBC error state: 08004 code: 1035 message: [Oracle][ODBC][Ora]ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege. (HY000)

SQL Issued: SELECT (My Query Here)

With a little help from Google, I found the following:

Oracle Error :: ORA-01035

ORACLE only available to users with RESTRICTED SESSION privilege

 

Cause

Logins are disallowed because an instance started in restricted mode. Only users with RESTRICTED SESSION system privilege can log on.

 

Action

Request that Oracle be restarted without the restricted option or obtain the RESTRICTED SESSION system privilege.

Actually, this error occurred because the Oracle database was being refreshed at the client site with the latest data. You can ask your DBA for RESTRICTED SESSION system privilege or wait for the database refresh t finish.

Cheers!

Deepak