Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

FM Patch Set Assistant - issue with Database connectivity

Question
1
Views
0
Comments

Hello Everyone,

I am installing BI-APPS 11.1.1.10 on Windows Server R2.

All went through smoothly till I came across the Patch set Assistant, ie. while upgrading the ATG Lite Schema.

My Env details :

OS : Windows Server R2.

OBIEE : 11.1.1.10

ODI : 11.1.1.9

Weblogic : 10.3.6.0

DB : 12.1.0.2.0

JDK : 1.7.0_65

I used Pluggable DB to run the RCU and all, it failed at the above mentioned step.

Connect string passed : WIN-*****:1521/reli_pdb.local

once I give the DBA credentials and click on Connect -  the schema shows up (ie. APPS_BIACOMP)

   once the password is entered then it fails with the error message as mentioned below

Error msg :

[2016-05-05T18:24:55.199+02:00] [Framework] [NOTIFICATION] [upgrade.Framework]  Db connect string for ATGLITE jdbc:oracle:thin:SYS@reli_pdb AS SYSDBA/******@WIN-*****:1521/reli_pdb.local

[2016-05-05T18:24:55.199+02:00] [Framework] [ERROR] [UPGAST-00213] [upgrade.Framework]  Unable to connect to database as the dba user.

IO Error: Invalid connection string format, a valid format is: "//host[:port][/service_name]" .

]]

[2016-05-05T18:24:55.199+02:00] [Framework] [ERROR] [upgrade.Framework]  Cause: The database connection failed for the specified reason.

[2016-05-05T18:24:55.199+02:00] [Framework] [ERROR] [upgrade.Framework]  Action: Correct the problem using information provided in the log file; then retry the operation. In particular if the indicated reason is 'Login has timed out' verify that the host and port are correct and make sure the database is up and is configured for network access.

But I can connect to the DB with all the schemas using sqlplus.

Also tried running the RCU on the Container DB, it didnt go through.

Please suggest whether im missing something here ...

Thanks for the help in advance

Regards,

M