Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to resolve ODI work repository connection error , ORA-12514?

Srija Radhakrishnan-OracleDec 17 2018 — edited Dec 17 2018

I am using ODI 12C client.

ODI Database connection URL : jdbc:oracle:thin:@localhost:1521/orclpdb.in.oracle.com

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I have checked the TNS entry details also.

ORCL =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl.in.oracle.com)

    )

  )

Tried giving the statement : alter plugabble database open;

                                                       ERROR at line 1:

                                                       ORA-01109: database not open

                                            alter plugabble database open;

                                                       ORA-01113: file 5 needs media recovery

                                                        ORA-01110: data file 5: 'D:\APP\SRIJRADH\ORADATA\ORCL\UNDOTBS01.DBF'
Comments
Post Details
Added on Dec 17 2018
#business-intelligence-applications, #data-integrator, #system-management-and-integration
4 comments
1,150 views