BI scheduler error, 1064: An exception occurred in the service
faraiSep 24 2010 — edited Sep 24 2010I am getting an error below while trying to restart BI scheduler,
"could not start the oracle bi scheduler service on local computer, error 1064: An exception occurred in the service when handling the control request".
Obiee is running on windows 2003 server. Scheduler was working fine until env went down, when l tried to restart it, suddenly i get this error message. The other services restart fine. Answers, dboard work fine. Its only the scheduler.
I tried a couple suggested things on the Forum,
1) l tried to connect the scheduler user using sqlplus, i get an error, ORA-12560: TNS:protocol adapter error. i cant connect. checked with the DB the user is not locked.
2) I checked the tnsnames.ora everything is fine.
3) I tried tns ping the user from cmd line i get an error TNS-03505: Failed to resolve the name.
The scheduler log details are below
---------------------------------------------------
2010-09-24 07:44:01
[68008] Scheduler Error:
Current Table: S_NQ_JOB.
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
[nQSError: 17014] Could not connect to Oracle database.
Current Table: S_NQ_JOB_PARAM.
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
[nQSError: 17014] Could not connect to Oracle database.
Current Table: S_NQ_INSTANCE.
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
[nQSError: 17014] Could not connect to Oracle database.
Current Table: S_NQ_ERR_MSG.
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
[nQSError: 17014] Could not connect to Oracle database.
If enable tracing on sqlnet.ora i get
-------------------------------------------------------
(4472) [24-SEP-2010 09:10:14:390] nnftmlf_make_system_addrfile: entry
(4472) [24-SEP-2010 09:10:14:390] nnftmlf_make_system_addrfile: system names file is E:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora
(4472) [24-SEP-2010 09:10:14:390] nnftmlf_make_system_addrfile: exit
(4472) [24-SEP-2010 09:10:14:390] nnftboot: exit
(4472) [24-SEP-2010 09:10:14:390] nnftrne: entry
(4472) [24-SEP-2010 09:10:14:390] nnftrne: Original name: S_NQ_SCHED
(4472) [24-SEP-2010 09:10:14:390] nnfttran: entry
(4472) [24-SEP-2010 09:10:14:390] nnfgrne: Query unsuccessful, skipping to next adapter
(4472) [24-SEP-2010 09:10:14:390] nnfgrne: exit
(4472) [24-SEP-2010 09:10:14:390] nnfun2a: address for name "S_NQ_SCHED" not found
(4472) [24-SEP-2010 09:10:14:390] niqname: Return code from nnfsn2a is 1
(4472) [24-SEP-2010 09:10:14:390] nigtrm: Count in the NI global area is now 0
Thanks
Farai