Oracle Analytics and AI

Girimarich

Hi Team,

I am working installing the OBIEE 12 C using oracle 12 C data base.

While in the install does it require to config RCU before running the Config Tool.

I assume it is not mandatory to run RCU as it is useful for allotting the extra table space.

Ok the actual error is with RCU,i am getting "Unable to connect DB,Invalid service name" error as attached.

I am using the default ORCL TNSdetails for configuring the RCU.

"# tnsnames.ora Network Configuration File: C:\app\orauser1\product\12.1.0\dbhome_2\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

ORCL =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )"

I tried all googling like (.localdomain,orcl.localdomain etc..),but nothing helped.

Could any one help me??

Simon.D

Hi Girimarich ,

You are correct, you don't need to run the RCU before the Config Assistant - You would only do this if you were installing on a non-Oracle database or need to manage the table spaces. Regarding your issue; did you install the 12c database yourself? If you did, can you remember if you selected the "Create as Container database" checkbox during the installation? You may have created a Pluggable Database (PDB), in which case you will require another TNS entry pointing to the PDB and not to the Container Database (CDB).