This discussion is archived
7 Replies Latest reply: Jun 14, 2013 1:42 PM by Teddd RSS

OBIEE Samples and installation problem... NAT vs. Bridged

user312242 Newbie
Currently Being Moderated
So, here's the quick problem... when running the Samples in VirtualBox and the Networking is set to NAT mode all is good all services start, etc. when the Network is set to Bridged mode I can't get the BIServer and the Presentation server to start?

I've added my IP to the /etc/hosts file as laid out in the install doc but still a no go.

Processes in Instance: instance1
--------------------------------------------------------------+---------
ias-component | process-type | pid | status
--------------------------------------------------------------+---------
coreapplication_obiccs1 | OracleBIClusterCo~ | 3918 | Alive
coreapplication_obisch1 | OracleBIScheduler~ | 3917 | Alive
coreapplication_obijh1 | OracleBIJavaHostC~ | 3919 | Alive
coreapplication_obips1 | OracleBIPresentat~ | N/A | Down
coreapplication_obis1 | OracleBIServerCom~ | N/A | Down


How do I fix this?
  • 1. Re: OBIEE Samples and installation problem... NAT vs. Bridged
    SunilSharma Expert
    Currently Being Moderated
    errors in sawlog.log and nqserver.log would be helpful to dig more about it. or else paste the logs here
  • 2. Re: OBIEE Samples and installation problem... NAT vs. Bridged
    user312242 Newbie
    Currently Being Moderated
    Since I'm new to OBIEE can you supply a path to those logs?

    Thanks,
  • 3. Re: OBIEE Samples and installation problem... NAT vs. Bridged
    SunilSharma Expert
    Currently Being Moderated
    Presentation Server log files
    /middlewarehome/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1
    Files: sawlog0.log

    BI Server log files
    /middlewarehome/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1
    Files: nqquery.log, nqserver.log
  • 4. Re: OBIEE Samples and installation problem... NAT vs. Bridged
    user312242 Newbie
    Currently Being Moderated
    I was looking for corresponding time stamps but got close as I could. I hope this is enough...

    *******************************
    from the SAW log... looks like it repeats.
    *******************************

    [2013-05-15T18:26:55.000-07:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Oracle BI Presentation Services (OBIPS) 11.1.1.6.2 (Build 120605.2000 BP1 32-bit) are starting up.[[
    File:sawserver.cpp
    Line:455
    Location:
         saw.sawserver
    ecid:
    ]]
    [2013-05-15T18:26:57.000-07:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Odbc driver returned an error (SQLDriverConnectW).
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
    [nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (obieesampleapp.us.oracle.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
    File:odbcuserpoploaderimpl.cpp
    Line:324
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-15T18:26:57.000-07:00] [OBIPS] [ERROR:16] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Unable to create a system user connection to BI Server during start up. Trying again.[[
    File:odbcuserpoploaderimpl.cpp
    Line:325
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-15T18:27:02.000-07:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Odbc driver returned an error (SQLDriverConnectW).
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
    [nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (obieesampleapp.us.oracle.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
    File:odbcuserpoploaderimpl.cpp
    Line:324
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-15T18:27:02.000-07:00] [OBIPS] [ERROR:16] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Unable to create a system user connection to BI Server during start up. Trying again.[[
    File:odbcuserpoploaderimpl.cpp
    Line:325
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]


    ********************
    from the nqquery.log...
    ********************

    [2013-05-16T07:54:27.000-07:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Oracle BI Presentation Services (OBIPS) 11.1.1.6.2 (Build 120605.2000 BP1 32-bit) are starting up.[[
    File:sawserver.cpp
    Line:455
    Location:
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:28.000-07:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Odbc driver returned an error (SQLDriverConnectW).
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
    [nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (obieesampleapp.us.oracle.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
    File:odbcuserpoploaderimpl.cpp
    Line:324
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:28.000-07:00] [OBIPS] [ERROR:16] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Unable to create a system user connection to BI Server during start up. Trying again.[[
    File:odbcuserpoploaderimpl.cpp
    Line:325
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:33.000-07:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Odbc driver returned an error (SQLDriverConnectW).
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
    [nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (obieesampleapp.us.oracle.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
    File:odbcuserpoploaderimpl.cpp
    Line:324
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:33.000-07:00] [OBIPS] [ERROR:16] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Unable to create a system user connection to BI Server during start up. Trying again.[[
    File:odbcuserpoploaderimpl.cpp
    Line:325
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:38.000-07:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Odbc driver returned an error (SQLDriverConnectW).
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
    [nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (obieesampleapp.us.oracle.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
    File:odbcuserpoploaderimpl.cpp
    Line:324
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:38.000-07:00] [OBIPS] [ERROR:16] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Unable to create a system user connection to BI Server during start up. Trying again.[[
    File:odbcuserpoploaderimpl.cpp
    Line:325
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:43.000-07:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Odbc driver returned an error (SQLDriverConnectW).
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
    [nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (obieesampleapp.us.oracle.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
    File:odbcuserpoploaderimpl.cpp
    Line:324
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:43.000-07:00] [OBIPS] [ERROR:16] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Unable to create a system user connection to BI Server during start up. Trying again.[[
    File:odbcuserpoploaderimpl.cpp
    Line:325
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:48.000-07:00] [OBIPS] [ERROR:10] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Odbc driver returned an error (SQLDriverConnectW).
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
    [nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (obieesampleapp.us.oracle.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
    File:odbcuserpoploaderimpl.cpp
    Line:324
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]
    [2013-05-16T07:54:48.000-07:00] [OBIPS] [ERROR:16] [] [saw.security.odbcuserpopulationimpl.initialize] [ecid: ] [tid: ] Unable to create a system user connection to BI Server during start up. Trying again.[[
    File:odbcuserpoploaderimpl.cpp
    Line:325
    Location:
         saw.security.odbcuserpopulationimpl.initialize
         saw.catalog.local.loadCatalog
         saw.subsystems.catalogbootstrapper.loadcatalog
         saw.webextensionbase.init
         saw.sawserver
    ecid:
    ]]

    Edited by: Adam M on May 16, 2013 11:00 AM
  • 5. Re: OBIEE Samples and installation problem... NAT vs. Bridged
    user312242 Newbie
    Currently Being Moderated
    Just wanted to post the /etc/hosts

    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    192.168.3.138 obieesampleapp.us.oracle.com
    127.0.0.1 obieesampleapp.us.oracle.com obieesampleapp localhost.localdoma$
    ::1 localhost6.localdomain6 localhost6



    tnsnames.ora

    # tnsnames.ora Network Configuration File: /home/oracle/app/oracle/product/11.2$
    # Generated by Oracle configuration tools.

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = obieesampleapp.us.oracle.com)(PORT = 152$
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl.us.oracle.com)
    )
    )



    and a ping to show it resolves..

    [oracle@obieesampleapp ~]$ ping obieesampleapp.us.oracle.com
    PING obieesampleapp.us.oracle.com (192.168.3.138) 56(84) bytes of data.
    64 bytes from obieesampleapp.us.oracle.com (192.168.3.138): icmp_seq=1 ttl=64 time=0.012 ms
    64 bytes from obieesampleapp.us.oracle.com (192.168.3.138): icmp_seq=2 ttl=64 time=0.019 ms


    opmn.log


    [2013-05-15T17:24:39-07:00] [opmn] [NOTIFICATION:1] [90] [ons-internal] ONS server initiated

    [2013-05-15T17:24:39-07:00] [opmn] [TRACE:1] [522] [pm-internal] PM state directory exists: /home/oracle/obiee/instances/instance1/config/OPMN/opmn/states

    [2013-05-15T17:24:39-07:00] [opmn] [NOTIFICATION:1] [675] [pm-internal] OPMN server ready. Request handling enabled

    [2013-05-15T17:24:40-07:00] [opmn] [NOTIFICATION:1] [667] [pm-requests] Request 2 Started. Command: /start

    [2013-05-15T17:24:40-07:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obis1~OracleBIServerComponent~coreapplication_obis1~1 (394:0)

    [2013-05-15T17:24:40-07:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obips1~OracleBIPresentationServicesComponent~coreapplication_obips1~1 (395:0)

    [2013-05-15T17:24:40-07:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obijh1~OracleBIJavaHostComponent~coreapplication_obijh1~1 (396:0)

    [2013-05-15T17:24:40-07:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (397:0)

    [2013-05-15T17:24:40-07:00] [opmn] [NOTIFICATION:1] [662] [pm-process] Starting Process: coreapplication_obiccs1~OracleBIClusterControllerComponent~BIClusterController~1 (398:0)

    [2013-05-15T17:24:41-07:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obis1~OracleBIServerComponent~coreapplication_obis1~1 (394:3987) [No addresses for the request]

    [2013-05-15T17:24:41-07:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obis1~OracleBIServerComponent~coreapplication_obis1~1 (394:3987)

    [2013-05-15T17:24:41-07:00] [opmn] [ERROR:1] [] [libopmncustom] Ping failed in Ready callback for proc:394

    [2013-05-15T17:24:42-07:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obips1~OracleBIPresentationServicesComponent~coreapplication_obips1~1 (395:3988) [No addresses for the request]

    [2013-05-15T17:24:42-07:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obips1~OracleBIPresentationServicesComponent~coreapplication_obips1~1 (395:3988)

    [2013-05-15T17:24:42-07:00] [opmn] [ERROR:1] [] [libopmncustom] Ping failed in Ready callback for proc:395

    [2013-05-15T17:24:42-07:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed

    Edited by: Adam M on May 16, 2013 1:40 PM
  • 6. Re: OBIEE Samples and installation problem... NAT vs. Bridged
    user312242 Newbie
    Currently Being Moderated
    Another interesting piece of the puzzle...

    I thought I would like to go ahead and try something with the NAT setup so I changed the VM back to NAT, removed the line in /etc/hosts and re-started the server. Now I have the same problem..


    opmnctl startall: starting opmn and all managed processes...
    ================================================================================
    opmn id=obieesampleapp.us.oracle.com:9501
    Response: 0 of 2 processes started.

    ias-instance id=instance1
    ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    --------------------------------------------------------------------------------
    ias-component/process-type/process-set:
    coreapplication_obis1/OracleBIServerComponent/coreapplication_obis1/

    Error
    --> Process (index=1,uid=445,pid=5642)
    failed to start a managed process after the maximum retry limit
    Log:
    /home/oracle/obiee/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/console~coreapplication_obis1~1.log

    ias-component/process-type/process-set:
    coreapplication_obips1/OracleBIPresentationServicesComponent/coreapplication_obips1/

    Error
    --> Process (index=1,uid=446,pid=5825)
    failed to start a managed process after the maximum retry limit
    Log:
    /home/oracle/obiee/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1/console~coreapplication_obips1~1.log


    Processes in Instance: instance1
    --------------------------------------------------------------+---------
    ias-component | process-type | pid | status
    --------------------------------------------------------------+---------
    coreapplication_obiccs1 | OracleBIClusterCo~ | 4409 | Alive
    coreapplication_obisch1 | OracleBIScheduler~ | 4411 | Alive
    coreapplication_obijh1 | OracleBIJavaHostC~ | 4410 | Alive
    coreapplication_obips1 | OracleBIPresentat~ | N/A | Down
    coreapplication_obis1 | OracleBIServerCom~ | N/A | Down



    So this obviously must be writing settings to a config file or something similar...

    No one has any suggestions on how to fix this???
  • 7. Re: OBIEE Samples and installation problem... NAT vs. Bridged
    Teddd Newbie
    Currently Being Moderated

    Did you get this resolved? I am having the same error and havent found a solution. Please Please Please Please help if you know the answer.

     

    Thanks,

    Ted.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points