Oracle Analytics Cloud and Server

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

Oracle OBI: Error Start BI Services

Received Response
71
Views
17
Comments
2»

Answers

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

    config.xml in FMW_HOME\user_projects\domains\YOURDOMAINNAMEHERE\config

    The  <jdbc-system-resource> tag.

    Check here: Copy Datasource XML files within Weblogic domains - JavaGalaxy.com Blog

  • Wij
    Wij Rank 4 - Community Specialist

    Ok thanks, it's more clear now.

    This is what is written in the file: mds-owsm_jdbc.xml

    <?xml version="1.0" encoding="UTF-8"?>

    <jdbc-data-source xsi:schemaLocation="http://www.bea.com/ns/weblogic/jdbc-data-source      http://www.bea.com/ns/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd" xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://www.bea.com/ns/weblogic/90/security" xmlns:wls="http://www.bea.com/ns/weblogic/90/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

      <name>mds-owsm</name>

      <jdbc-driver-params>

        <url>jdbc:oracle:thin:@localhost:1522/orcl</url>

        <driver-name>oracle.jdbc.OracleDriver</driver-name>

        <properties>

          <property>

            <name>SendStreamAsBlob</name>

            <value>true</value>

          </property>

          <property>

            <name>user</name>

            <value>DEV_MDS</value>

          </property>

          <property>

            <name>oracle.net.CONNECT_TIMEOUT</name>

            <value>10000</value>

          </property>

        </properties>

        <password-encrypted>{AES}dlmAR53vCwn5pKi8LDd29tjKSVbI+SoVLxlqn60YKkk=</password-encrypted>

      </jdbc-driver-params>

      <jdbc-connection-pool-params>

        <initial-capacity>0</initial-capacity>

        <max-capacity>50</max-capacity>

        <capacity-increment>1</capacity-increment>

        <connection-creation-retry-frequency-seconds>10</connection-creation-retry-frequency-seconds>

        <test-frequency-seconds>300</test-frequency-seconds>

        <test-connections-on-reserve>true</test-connections-on-reserve>

        <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>

        <seconds-to-trust-an-idle-pool-connection>0</seconds-to-trust-an-idle-pool-connection>

      </jdbc-connection-pool-params>

      <jdbc-data-source-params>

        <jndi-name>jdbc/mds/owsm</jndi-name>

        <global-transactions-protocol>None</global-transactions-protocol>

      </jdbc-data-source-params>

    </jdbc-data-source>

    I see two important things:

        <url>jdbc:oracle:thin:@localhost:1522/orcl</url>

        <driver-name>oracle.jdbc.OracleDriver</driver-name>

    This information is Ok

    And the other thing is the password thant I can't check because it's encrypted!

    I check config file xml, information related to datasouces are copied in the file.

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

    The password can be reset / set correctly / change through WLST like with all other passwords in the credential store:

    https://shivabizint.wordpress.com/2013/04/30/how-to-reset-forgotten-obiee-11g-rpd-password/

  • Wij
    Wij Rank 4 - Community Specialist

    I'm trying to run wlst and I get this message:

    console_wls.png

    It seems that my weblogic password is wrong.. I try to find solution so that I can change it, if you have any idea you can tell me please.

    And when I access this page: http://localhost:7001/Console, I get this message:

    Error 404--Not Found

    From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:

    10.4.5 404 Not Found

    The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.

    If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address.

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

    Well if you lost your weblogic password as well then you're basically dead.

  • Wij
    Wij Rank 4 - Community Specialist

    I think I will uninstall OBIEE. I found solution to change my password but I got more errors.

    Anyway, thank you for your help.

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

    Clean re-install does sound like the best solution for all your issues. Make sure to note all passwords next time

    Also: please close this thread.