cancel
Showing results for 
Search instead for 
Did you mean: 

How to migrate from a pluggable database

How to migrate from a pluggable database

Can someone please help me out to figure how I can connect to a Pluggable Database (PDB) in 12cR2.

Below is my toolkit.properties

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

SRC_DB_URL=jdbc:oracle:thin:@localhost:1521:dbone
SRC_DB_USER=c##soe
SRC_DB_PASSWORD=***

TARGET_DB_URL=jdbc:edb://localhost:5444/edb
TARGET_DB_USER=enterprisedb
TARGET_DB_PASSWORD=*******

*********************************************************************************************

I have service - pdbone is running for the PDB - pdbone.

I do have a tns entry as well called PDBONE as below.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

PDBONE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-pub)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdbone)
)
)

++++++++++++++++++++++++++++++++++++++++++++++++++

but it seems toolkit is only taking the sid name not any service name.

I am unable to figure out how to connect to pdb.

 

Thanks

TG

 

Accepted Solutions (0)

Answers (1)

Answers (1)

chaitalirs
EDB Team Member

Hi indianscout ,

 

We can connect Oracle by using following jdbc URL :  jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename

 

if SID being used then :  jdbc:oracle:thin:scott/tiger@//myhost:1521:SID

So entry for toolkit.properties file will be  :

 

SRC_DB_URL=jdbc:oracle:thin:@localhost:1521/<oracleServiceName>

SRC_DB_USER=c##soe

SRC_DB_PASSWORD=***

 

Above solution should work for Pluggable Database (PDB) in 12cR2.

 

Let us know in case you have any issues/queries further.

Ask a Question