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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Matthias Edelhof

Hello, what Client can i use to connect to 19c Database? When I install 21xe ( windows ) the path is modify to 21xe first. Must i create new net connection with the 21 net?
Matthias

MadMexx

Hi
Installation of 21c XE failed during configuration.
{IDS_OracleConfigDlg_DatabaseConfigFailedMsg} An error occurred while configuring Oracle XE database. Check the logs at... [FATAL] [DBT-50000] Prüfung auf verfügbaren Speicher nicht möglich.
In the Eventviewer there is also a entry for "OracleRemExecServiceV2". The service was not started because of an error.
I am using Windows 10 Professional Version 21H1 (Build 19043.1288) on a AMD Ryzen. Microsoft Hyper-V is installed.

L. Fernigrini

Hi, do no hijack an existing thread, open a new question and include a proper title and the description of the issue.

Hi MadMexx,
I will need to have a look at your logs.
Can you please zip up the contents of the [Oracle_Base]\cfgtoollogs\dbca directory and email them to me at christian dot shay at oracle dot com?
For example: c:\app\username\product\21c\cfgtoollogs\dbca
Then post here to let me know you emailed it?

MadMexx

Hello Christian,
I just send you a mail with the logs. Thanks

User_DKB06

I have the same issue and these are my logs, please help me with it
dbca.zip (297.61 KB)

User_MD054

I also have the same issue in please find error .
Configuring Oracle XE listener...
Oracle XE listener configured successfully.
Configuring Oracle XE database...
7% complete
8% complete

[FATAL] ORA-12560: TNS:protocol adapter error

29% complete
100% complete
[FATAL] ORA-12560: TNS:protocol adapter error

[FATAL] ORA-12560: TNS:protocol adapter error

29
7% complete
[FATAL] ORA-12560: TNS:protocol adapter error

29
0% complete
[FATAL] ORA-12560: TNS:protocol adapter error

29
Performing post XE database creation actions...
Post XE database creation actions completed.
{IDS_OracleConfigDlg_DatabaseConfigFailedM

User_YGSMU

i am unable to install a version of oracle database without problem, same issue {IDS_OracleConfigDlg_DatabaseConfigFailedMsg} An error occurred while configuring Oracle XE database.

User_MD054

Please try to use small name of your system and try In my case when change system name to small like 4 latter I am able to do installation such a weird but it rectify my error.

User_M27IT

it's really works, thanks man

User_G0SPM

2022-01-16.png{IDS_OracleConfigDlg_DatabaseConfigFailedMsg}
Anyone please help iam stuck out with these

User_G0SPM

Where to use small name of system?

Eusebius

Have a look here :
Maximum length of SID - Ask TOM (0 Bytes)

Eusebius

look here :
asktom.oracle.com/pls/apex/asktom.search?tag=maximum-length-of-sid

User_CNNKW

In my experience, I had tried reinstalling Oracle 21C XE on my Windows 10 Pro laptop for five times without success. Eventually, I followed the steps below:

  1. Uninstalled the Oracle 21C XE
  2. Deleted the folder app/..../product/21c
  3. This PC --> Manage --> Local Users and Groups --> Groups
  4. Deleted all the groups that had ORA associated with it, example name such as ORA_ASMADMIN
  5. Went to the registry as suggested above and deleted entries of my previous Oracle 21C XE installations.
  6. Opened the folder where I extracted Oracle 21C XE and then opened the ISSetupPrerequisites folder.
  7. Navigated to the file named vcredist_x64.exe
  8. Opened the file as Administrator and followed the installation wizard.
  9. Having installed the vcredist_64.exe, I restarted the computer.
    10. Now, I went ahead to install Oracle 21C XE. It took more than one hour to complete the installation.
    For now, I am able to connect to the XEPDB1 database and create table, add values to the table and view the table. I have no idea if other issues will crop up, but I have at least been able to install the software. I hope this helps someone.
User_CNNKW

I forgot to list a step.
Let say step 5a. Went to Environment variables and deleted the line that had oracleHome in it.

User_B2O2X

I have a same problem when install oracle xe,
here is the error message
{IDS_OracleConfigDlg_DatabaseConfigFailedMsg} An error occurred while configuring Oracle XE database. Check the logs at C:\app\user\product\21c\cfgtoollogs\dbca and try again.

I have attached the \dbca file, I have reinstalled it many times, but still can not figure out what the problem is, could someone help me, many thanks!!!
trace.zip (41.26 KB)

asahide

Hi @user-b2o2x ,
Could you check this comment?
Regards,

1 - 18

Post Details

Added on Aug 4 2020
6 comments
1,977 views