Connectivity issue during OBIA 11.1.1.10.2 RCU

Sirish Malisetty

I have completed installing

OBIEE 12c

ODI 12c

both servers are up and running.

now, before installing OBIA 11.1.1.10.2, I ran its RCU component.

During the "Recpository Creation Utility - Step 2 of 8 : Database Connection Details" I am getting invalid username/password error. below are the parameters that i am entering at this step and they are same for OBIEE RCU and ODI RCU creations.

Database Type: Oracle Database

Host Name: biserver.smalisetty

Port: 1521

Service Name: orclpdb.smalisetty

username: sys

Password:

Role: SYSDBA

just to test tried to do silent install and there is no luck. below is the snapshot for your reference.

Please need help in identifying what wrong am doing.

============================================================

[oracle@biserver bin]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 03-AUG-2017 16:27:18

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=biserver.smalisetty)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production

Start Date                03-AUG-2017 11:37:36

Uptime                    0 days 4 hr. 49 min. 42 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/biserver/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=biserver.smalisetty)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=biserver.smalisetty)(PORT=5500))(Security=(my_wallet_directory=/home/oracle/app/oracle/admin/orcl/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "54b5f909b5f851d9e0538f09a6824d6c.smalisetty" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orcl.smalisetty" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB.smalisetty" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclpdb.smalisetty" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@biserver bin]$ tnsping orclpdb.smalisetty

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 03-AUG-2017 16:27:58

Copyright (c) 1997, 2016, Oracle.  All rights reserved.

Used parameter files:

/home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

[oracle@biserver bin]$ tnsping orclpdb

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 03-AUG-2017 16:28:16

Copyright (c) 1997, 2016, Oracle.  All rights reserved.

Used parameter files:

/home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = biserver.smalisetty)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclpdb.smalisetty)))

OK (0 msec)

[oracle@biserver bin]$ pwd

/home/oracle/app/oracle/FMW_Home/rcu/bia/bin

[oracle@biserver bin]$ ./rcu -silent -createRepository -databaseType ORACLE -connectString 'biserver.smalisetty:1521:orclpdb.smalisetty' -dbUser SYS -dbRole SYSDBA -variables RCU_LOG_LOCATION=$ORACLE_BASE/log/rcu,RCU_LOG_NAME=rcu_bia.log -schemaPrefix DEV -component DW -component BIACOMP -component ODI -f < /home/oracle/obiarcupwdfile.txt

Processing command line ....

Invalid username/password.

Please enter valid username/password

RCU-6090:Skipping Main operation: Failed in Connection step validation

[oracle@biserver bin]$

============================================================

Thanks,

Sirish