RCU DB Config error-Unable to connect DB,Invalid service name

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).

Girimarich

Hi Simon,

Thanks for your suggestions.

Yes i installed the oracle myself.

I did not check the "Create as container database" option as i was causing OBIEE Configuration issue,so followed this step.

So if RCU config is not mandatory then i will ignore this message.

After successful OBIEE config my OBIEE Admin server is not starting as expected,so do you think this RCU error is some how connected to this issue.

Simon.D

If you check the logs for the admin server what do they say?

Thomas Dodds

Installing OBIEE 12c.  Part 3: Creating the Repositories - Red Stack Tech

It's a good step by step write up ... RCU is a required step ...

Simon.D

from the link you provided:

"

Another difference with OBIEE 12c is that you do not have to create the repositories with the RCU. You can instead let the configuration utility perform this (which I’ll cover in part 4). However the RCU gives you far more control over the configuration of the repositories, allowing you to choose/manage the tablespaces for the schemas.

"

Thomas Dodds

Yes ... I should have said the repository tables are required the actual utility (RCU) method is not.