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

Obiee 12c. Clone_bi_machine.Error:problem finding singleton data directory

Received Response
174
Views
9
Comments
deniska
deniska Rank 5 - Community Champion
edited Aug 13, 2024 5:30PM in Oracle Analytics Cloud and Server

OS Win 2012 R2

I'm trying to scale out my BI EE.

I created shared folder, Copy bidata into it, changed bi-environment.xml (" <bi:singleton-data-directory>W:\bidata</bi:singleton-data-directory>") and set some other parameters.

But when I try to make jar-file  "clone_bi_machine.cmd -m BINODE02 192.168.10.77 binode2.jar" I get this error

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    What exact version?

  • deniska
    deniska Rank 5 - Community Champion

    12.2.1.4

    PS BI starting and working with new catalog

  • deniska
    deniska Rank 5 - Community Champion

    OMG,

    W:\bidata - WRONG SYNTAX

    W:\bidata\ - RIGHT SYNTAX

  • deniska
    deniska Rank 5 - Community Champion

    Ok. I synchronized two nodes but now nothing works.

    The main error everythere is Failed to read from SingletonDataDirectory.

    Ok. I rebooted these nodes.

    But when I start nodemanager on the second node I get the same error

    "SEVERE: Failed to validate SDD  Failed to read from SingletonDataDirectory w:\bi

    data\ - make sure correct SDD is specified in bi-environment XML C:\Oracle\Middl

    eware\Oracle_Home\user_projects\domains\bi_domain\config\fmwconfig\bienv\core\bi

    -environment.xml"

    "

    Crash recovery failed on System

    Component OBIPS server 'obips2': java.lang.RuntimeException: Failed to validate

    SDD  Failed to read from SingletonDataDirectory w:\bidata\ - make sure correct S

    DD is specified in bi-environment XML C:\Oracle\Middleware\Oracle_Home\user_proj

    ects\domains\bi_domain\config\fmwconfig\bienv\core\bi-environment.xml>

    "

    "

    Crash recovery failed on System

    Component OBIS server 'obis2': java.lang.RuntimeException: Failed to validate SD

    D  Failed to read from SingletonDataDirectory w:\bidata\ - make sure correct SDD

    is specified in bi-environment XML C:\Oracle\Middleware\Oracle_Home\user_projec

    ts\domains\bi_domain\config\fmwconfig\bienv\core\bi-environment.xml>

    "

    I tried to change the value on the second node to: w:\bidata\,w:\bidata,w\:\\bidata,w\:\\bidata\,w:/bidata...

    But nothing helped

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    "

    make sure correct SDD is specified in bi-environment XML C:\Oracle\Middl

    eware\Oracle_Home\user_projects\domains\bi_domain\config\fmwconfig\bienv\core\bi

    -environment.xml"

    Well is it?

  • deniska
    deniska Rank 5 - Community Champion

    xx1.jpg

  • deniska
    deniska Rank 5 - Community Champion

    xx2.jpg

    Nodemanager is starting on the node 2 but I want to resolve these issues first and then start the main node

  • deniska
    deniska Rank 5 - Community Champion

    I repared it by changing "w:\bidata\" to "\\192.168.10.78\share\"

    Now there is no problem with sigleton data directory and Node Manager, AdminServer, BI_Server1 and Bi_server2, BI Cluster Controllers 1 and 2, BI Java hosts 1 amd 2 are starting succesfully BUT

    BI Servers(nqservers), BI Presentation Servers(sawservers) and BI Schedulers crush during starting.

    xx3.jpg

    No errors in their logs.

    Only in nodemanager log i can see errors

    "

    <22.02.2019 16:34:56 MSK> <INFO> <bi_domain> <obis1> <The server 'obis1' with process id 2564 is no longer alive; waiting for the process to die.>

    <22.02.2019 16:34:56 MSK> <INFO> <bi_domain> <obis1> <Server failed during startup. It may be retried according to the auto restart configuration.>

    <22.02.2019 16:34:56 MSK> <INFO> <bi_domain> <obis1> <Server failed but will not be restarted because the maximum number of restart attempts has been exceeded>

    <22.02.2019 16:35:32 MSK> <INFO> <bi_domain> <obips1> <The server 'obips1' with process id 996 is no longer alive; waiting for the process to die.>

    <22.02.2019 16:35:32 MSK> <INFO> <bi_domain> <obips1> <Server failed during startup. It may be retried according to the auto restart configuration.>

    <22.02.2019 16:35:32 MSK> <INFO> <bi_domain> <obips1> <Server failed so attempting to restart (restart count = 1)>

    "

    And in Windows log I can see

    bi server error

    Failing application Path: C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\bin\nqsserver.exe

    Failing Module Path: C:\Windows\SYSTEM32\ntdll.dll

    bi presentation serevr error

    Failing application Path: C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\bin\sawserver.exe

    Failing Module Path: C:\Windows\SYSTEM32\MSVCR100.dll

    Next I tried to upload new repository and Repository password change utility crashed too.

    I tried to stop all servers, copy old version of bidata to shared folder and start bi again but with no success.

    What can I try to do else.

  • deniska
    deniska Rank 5 - Community Champion

    I deinstalled BI soft from two servers and installed again

    First node

    -installed Java (jdk-8u202-windows-x64.exe)

    -installed fmw 12.2.1.3

    -installed (setup_bi_platform-12.2.1.4.0_win64.exe)

    -configured database metadata repository with RCU

    -configured BI

    -applied patch 28500593

    -applied patch Essbase_orcl.zip

    -set oracle_home for c:\Oracle\Middleware\Oracle_Home\

    -created DSN(found correct port here http://localhost:9500/em/faces/ai/bi/instance?type=oracle_bi_instance&target=%2FDomain_bi_domain%2Fbi_domain%2FBusinessI…)

    they can be different from installation to installation!!

    -edited the DOMAIN_HOME\config\fmwconfig\bienv\OBIPS\obips.properties by appending the line:

    PATH=C:\\Oracle\\Middleware\\OBIEE\\oracle_common\\bin

    where C:\Oracle\Middleware\OBIEE is replaced with the OBIEE_HOME for your instance.

    The double '\' are needed in a Windows environment.

    Second node

    -installed Java (jdk-8u202-windows-x64.exe)

    -installed fmw 12.2.1.3

    -installed (setup_bi_platform-12.2.1.4.0_win64.exe)

    -applied patch 28500593

    -applied patch Essbase_orcl.zip

    -set oracle_home for c:\Oracle\Middleware\Oracle_Home\

    Clustering

    1.Checked that all available and works on single node

    2.Stopped bi on first node

    3. Changed location of singleton data directory bi-environment.xml (In Win 2012 only '\\192.168.10.78\share\bidata" works for me. W:\bidata\ WORKED UNSTABLE!!)

    4. Copied bidata folder to shared disk

    5. Started BI and in EM add network folder for bicache

    6. Stopped BI

    7. Created jar(on binode 1) for deployment on binode 2

    8."Unpack" it on binode 2

    9. synced midtier db on binode 1

    10. Started node manager on binode 2

    11. Started BI on binode 1

    So what I got?

    I got working clustered BI System BESIDES obis2, obips2, obisch2.

    These components were down.

    There were an error [46137] CSF error encountered. Error code: 43131 in all node 2 logs.

    The main reason of that error is connectivity issue between Oracle DB 12(I dont remember exact version) and OBIEE 12C.

    But we have 11.2.0.4...

    I've discovered a lot and found it.

    One person had the same problem.

    I have to run script sync_modtire_db on node 2.

    When all is started...

    After that all services are avalable...I think my post will help somebody

    But I have a question

    Should I change dsn setting for OBI Server and change localhost to clustered DSN on both nodes(or on master node) or it doesnt matter or BI do it by itself?

    Now I perform a clean install and check all things again.

    After that one more question How can I test load? Is there any special tool in OBIEE 12C?