Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Reg: oracle_instance:instance 1 failed contacting opmn

Received Response
11
Views
3
Comments
Newuser1
Newuser1 Rank 4 - Community Specialist
edited August 2024 in Oracle Analytics Cloud and Server

Hi All,

Good Evening.

I'm facing issue in bringing bi_server1 up and facing the below error while re starting the services,BI Application was down (able to login EM and Console) where as OPMN services are showing UP.

Please find the below screen. Version: OBIEE 11.1.1.7.1 Please suggest .

OPMN Status:

pastedImage_6.png

Error: (oracle_instance:instance 1 failed contacting opmn; please check if OPMN process running. Can not start or stop the components of BI instance.)

pastedImage_11.png

Thanks In Advance,

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Can you check the scheduler log files for more details of the error? Provide this information in order for some assistance as the information supplied isn't enougn unfortunately.

  • Newuser1
    Newuser1 Rank 4 - Community Specialist

    Hi Joel,

    Thanks for your reply.

    Please find the below scheduler log, also even presentation sever is up but  BI application was down.

    [2017-12-13T01:32:43.000-08:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: ] [tid: bed47720]  [68008] Scheduler Error:  [[

    Current Table: S_NQ_JOB.

    [nQSError: 17001] Oracle Error code: 12545, message: ORA-12545: Connect failed because target host or object does not exist

    at OCI call OCIServerAttach.

    Current Table: S_NQ_JOB_PARAM.

    [nQSError: 17001] Oracle Error code: 12545, message: ORA-12545: Connect failed because target host or object does not exist

    at OCI call OCIServerAttach.

    Current Table: S_NQ_INSTANCE.

    [nQSError: 17001] Oracle Error code: 12545, message: ORA-12545: Connect failed because target host or object does not exist

    at OCI call OCIServerAttach.

    Current Table: S_NQ_ERR_MSG.

    [nQSError: 17001] Oracle Error code: 12545, message: ORA-12545: Connect failed because target host or object does not exist

    at OCI call OCIServerAttach.. Errors were encountered while initializing Scheduler's backend database, check database configuration.

    Thanks In Advance,

  • Joel
    Joel Rank 8 - Analytics Strategist

    what the errors indicate are the OBIEE is unable to connect to your RCU schema. Can you try connecting to your RCU database from your OBIEE server? Try SQL*Plus or try to tnsping the database from the OBIEE server to validate connectivity.