rman target / not connects to correct DBID and database

[karthikmca.bhc]

Hi support,

recently i cloned EBS 12.2.7 runs with 19c in Target server and i hope the clone was successful.  When i connect to rman, its not connecting to my CDB. instead it connect to something different DBID and database (PROD:EBSPDB) which is wrong. basically it must connect to the CDB while invoking rman. Please see below and let me know how to fix this issue.

[oracle@p2esprod ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 19 22:09:50 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> alter session set container=CDB$ROOT;
Session altered.
SQL> set lines 200 pages 200
SQL> col NAME format a20
SQL> select name,cdb,open_mode from v$database;

NAME                 CDB OPEN_MODE
-------------------- --- --------------------
PROD                 YES READ WRITE

SQL> select dbid,name,open_mode from v$database;

      DBID NAME                 OPEN_MODE
---------- -------------------- --------------------
 463033402 PROD                 READ WRITE

SQL> select con_id,name,open_mode from v$containers;

    CON_ID NAME                 OPEN_MODE
---------- -------------------- ----------
         1 CDB$ROOT             READ WRITE
         2 PDB$SEED             READ ONLY
         4 EBSPDB               READ WRITE

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

[oracle@p2esprod ~]$ env |grep ORA
ORACLE_UNQNAME=PROD
ORACLE_PDB_SID=EBSPDB
ORACLE_SID=PROD
ORA_NLS10=/u01/oracle/db/tech_st/19.3.0.0/nls/data/9idata
ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/db/tech_st/19.3.0.0

[oracle@p2esprod ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Sep 19 22:12:03 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD:EBSPDB (DBID=4028559305)

RMAN>

Why the RMAN connect to the database PROD:EBSPDB instead of PROD? and to wrong DBID which doesnt exists? It suppose to connects to DBID which is 463033402

Please provide fix for this issue.

Thanks,

[ErmanArslansOracleBlog]

Probably, it is because of ORACLE_PDB_SID.
Did you try unsetting ORACLE_PDB_SID? (unset ORACLE_PDB_SID)

EBS documents states it .. For instance ->

In MOS note named "Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 19c (Doc ID 2554156.1)", it is said that;

$ unset ORACLE_PDB_SID
$ sqlplus "/ as sysdba" @aucrdbCDB.sql
$ export ORACLE_PDB_SID=[PDB SID]
$ sqlplus "/ as sysdba" @aucrdbPDB.sql

[karthikmca.bhc]

Thanks a lot. I tried unsetting ORACLE_PDB_SID and that resolved the issue.

Thanks Erman. 

On Sun, 20 Sep 2020 at 10:35 PM ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

Probably, it is because of ORACLE_PDB_SID.


Did you try unsetting ORACLE_PDB_SID? (unset ORACLE_PDB_SID)



EBS documents states it .. For instance ->



In MOS note named "Export/Import Process for Oracle E-Business Suite Release 12.2 Database Instances Using Oracle Database 19c (Doc ID 2554156.1)", it is said that;



$ unset ORACLE_PDB_SID


$ sqlplus "/ as sysdba" @aucrdbCDB.sql


$ export ORACLE_PDB_SID=[PDB SID]


$ sqlplus "/ as sysdba" @aucrdbPDB.sql

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/rman-target-not-connects-to-correct-DBID-and-database-tp8788p8790.html

To unsubscribe from rman target / not connects to correct DBID and database, click here.


NAML

--