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 12.2.1.4 - obis1 starting error

Received Response
161
Views
5
Comments
BenFreez
BenFreez Rank 5 - Community Champion
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

Hi all,

I have an error when i am trying to restart OBIEE 12c. The error is coming at the obis1 starting process with the foloowing error message :

Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error: NMProcess: ORA-12504, TNS:listener was not given the SID in CONNECT_DATA

I already check the connection to the application database with same information that i have in the Administration console, and everything is working fine.

Did you faced to this kind of error before guys?

Any help will be really appreciated

Best regards,

Ben

Tagged:

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    BenFreez wrote:I already check the connection to the application database with same information that i have in the Administration console, and everything is working fine.

    You mean the JDBC in the WLS Admin console? Or which "Administration Console"?

    What's important is that the OBI Server with the information contained in the RPD can get there. Nothing else matters.

  • BenFreez
    BenFreez Rank 5 - Community Champion

    Hi Christian,

    Yes sorry, i mean WLS Admin Console.

    I will investage on RPD side.

    Thanks for your help.

    Best regards,

    Ben

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

    Never forget to open the admin tool in online mode and see whether your connections actually work

  • BenFreez
    BenFreez Rank 5 - Community Champion

    Hi Christian,

    Sorry for the delay. I am not able to update the RPD because of obis1 process is down.

    We saw on db log file this error :

    28-JAN-2020 16:21:25 * (CONNECT_DATA=(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=biee))(SERVICE_NAME=)) * establish * 12504

    TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

    TNS-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

    The service name is empty. Impossible to determine where this error is coming from.

    I checked all datasource from WLS Admin console. everything is fine.

    I checked also these files :

    • [DOMAIN_HOME]/config/fmwconfig/jps-config.xml
    • [DOMAIN_HOME]/config/fmwconfig/jps-config-jse.xml

    I have no idea why obiee is trying to connect to the database with this wrong connect string.

    Best regards,

    Benoit

  • Adam Wickes
    Adam Wickes Rank 6 - Analytics Lead

    Not sure if you've seen this but might be relevant.ORA-12504: TNS:listener was not given the SID in CONNECT_DATA