Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

scheduler services is not up in obiee 11g

1001368May 28 2013 — edited May 29 2013
Hi All,

When rested the OPMN service Scdhuler not comeing up all services working fine this is log file.
please help me what is issue before it is working fine.Database is running.

[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41020940] [16020] Metadata Database Type: Oracle 11g [[
Data Source Name: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.116.7)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=Test)))
Data Source Type: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64b
]]
[OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41020940] [nQSError: 46066] Operation cancelled. [[
PRIMARY_POOL RetrieveColumnInfo from table S_NQ_JOB Exchange
]]
[OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41020940] [nQSError: 46066] Operation cancelled. [[
PRIMARY_POOL RetrieveColumnInfo from table S_NQ_JOB_PARAM Exchange
]]
[OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41020940] [nQSError: 46066] Operation cancelled. [[
PRIMARY_POOL RetrieveColumnInfo from table S_NQ_INSTANCE Exchange
]]
[OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41020940] [nQSError: 46066] Operation cancelled. [[
PRIMARY_POOL RetrieveColumnInfo from table S_NQ_ERR_MSG Exchange
]]
[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 871b810] [68013] Scheduler service started.
[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 871b810] Scheduler service started.
[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 871b810] [71076] Oracle BI Scheduler crmtest6:9705 has been changed to an Inactive state.
[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41222940] [43071] A connection with Cluster Controller CRMTEST6:9706 was established.
[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41222940] [71075] Oracle BI Scheduler crmtest6:9705 has been changed to an Active state.
[OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41222940] [43065]

Comments

Sasi Nagireddy
Are u able to connect to the database?

Thanks,
SunilSharma
998365 wrote:

[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 871b810] [68013] Scheduler service started.
[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 871b810] Scheduler service started.
[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 871b810] [71076] Oracle BI Scheduler crmtest6:9705 has been changed to an Inactive state.
[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41222940] [43071] A connection with Cluster Controller CRMTEST6:9706 was established.
[OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41222940] [71075] Oracle BI Scheduler crmtest6:9705 has been changed to an Active state.*
[OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004rSLEMUx3AtH4pzSt1iW000119000000] [tid: 41222940] [43065]
from the log it looks like its started as it changed the state to active. are you able to connect to database using biplatform schema details?
1 person found this helpful
Satya Ranki Reddy
Hi,

The OBIEE server is in Horizontal cluster mode?

If yes,

Scheduler service will work active -passive mode. One server will up another server will down.


Please cross check

Note : Similarly you can check scheduler ports are opened or not?


Hope this help's

Thanks,
Satya
ivamsy
Hi,

First check database is connecting or not.
Please Check like this username@service name(like sys@orcl as sysdba)
if it throws the following error([nQSError: 17001] Oracle Error code: 12514, message: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).

If it giving the same error u have to alter the Local_Listner.

i.e
alter system set LOCAL_LISTENER='orcl' scope=both;
alter system set SERVICE_NAMES='orcl' scope=both;

Now u have to connect the database.
commit these ones.
and clear the database.

Now restart all opmnctl it will connect.

Let me know i think it will help you.

If scheduler down it is database connection issue.

Please Mark if it helps
Thanks,

Edited by: 980767 on May 29, 2013 2:34 PM
1 person found this helpful
1001368
Reslove it.Schema password is expired.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 26 2013
Added on May 28 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
5 comments
2,994 views