Skip to Main Content

ORDS, SODA & JSON in the Database

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!

Integrating ORDS 19.2 with EBS 12.2 using a pdb

James DieblingAug 4 2020 — edited Aug 4 2020

Hi,

We upgraded our version of EBS to 12.2 on a 19c database and during the process a PDB was created using a lowercase name ("pdb1).   While installing ORDS, I enter the service name for access to the PDB but I get the following error:

2020-08-04T14:55:34.076Z WARNING ORA-65011: Pluggable database pdb1 does not exist.

It seems the installation expects the PDB name to be uppercase.  The DB initialization parameter _pdb_name_case_sensitive is set to TRUE (the default for this EBS version).

Has anyone had luck in connecting an ORDS installation to a 19c PDB in lowercase?  

Any help is appreciated

Comments

top.gun

OMG - where do I start!

If you are using Oracle for commercial purposes then you or your client needs a licence from Oracle. So really you should stop now.

Once you have your licence from Oracle, you can do a simulated import (ie show metadata) like this:

imp ar/live show=y statistics=none buffer=100000 feedback=100000 log=/gers/live/tmp/CUST_190312.log file=/gers/live/tmp/CUST_190312.dmp

Then if the above works you can do the real import (ie metadata and data) like this:

imp ar/live full=y statistics=none buffer=100000 feedback=100000 log=/gers/live/tmp/CUST_190312.log file=/gers/live/tmp/CUST_190312.dmp

Dean Gagne-Oracle

You can always use

imp help=y

to give you the available commands and options.  If you only want the data, then you can use:

imp user/password file=your_file.dmp rows=y

Hope this helps.

Dean

Lisa-Oracle

Hi AJVinkles,

You need to add ignore=y since the table pre-exists

Using IGNORE=y instructs Oracle to ignore any creation errors during the import

and permit the import to complete.

imp user/password file=  log= FROMUSER= TABLES=  ignore=y

rows=y as stated above is the default so it is not needed in the command

Regards,

Lisa

1 - 3

Post Details

Added on Aug 4 2020
6 comments
2,014 views