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 11G Installation on windows 7

Received Response
152
Views
23
Comments
ksbabu
ksbabu Rank 4 - Community Specialist
edited Aug 13, 2024 6:13PM in Oracle Analytics Cloud and Server

Hi Experts,

When i am installing RCU it throwing an error,i have given the sid,port number and user name and password but why it is showing,please help me.

error :

  • Unable to connect to the database using the provided details. Please enter a valid hostname and port or check if the listener is up and running.

I checked in databse instance status is open mode.could you please solve this issue.

Thanks,

Sateesh

«13

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Well ...

    The info you entered aren't correct, the message isn't really a fake one ...

  • ksbabu
    ksbabu Rank 4 - Community Specialist

    Hi Gianni Ceresa,

    Please find the attached screen short.

    pastedImage_0.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    Username: example 'sys'

    So why do you put SYS as SYSDBA?

    "as SYSDBA" isn't really a username...

  • ksbabu
    ksbabu Rank 4 - Community Specialist

    Thanks for the quick reply. even i put username: 'SYS'   throwing the same error

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you tried logging on to DB via TOAD/SQL Developer/SQL*Plus from machine which you're attempting to install OBIEE?

  • ksbabu
    ksbabu Rank 4 - Community Specialist

    I logging on to DB via SQL*PLUS  the following are the credentials.

    supervisor :sys as sysdba

    password: Sysdba123

  • rmoff
    rmoff Rank 6 - Analytics Lead

    Is your servicename really "ORCL123"?

  • ksbabu
    ksbabu Rank 4 - Community Specialist

    Yes.please find the tnsnames.

    ORCL123 =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

        (CONNECT_DATA =

          (SERVER = DEDICATED)

          (SERVICE_NAME = ORCL123)

        )

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    My turn to guess: listener is not working and you can connect with sql*plus using bequeath protocol, but can't with RCU via OCI.

  • ksbabu
    ksbabu Rank 4 - Community Specialist

    Thanks for the quick reply,i tried to start the listener in services but it is throwing error ,please find the screen short

    pastedImage_0.png