Hardware

Even creating a pdb in lowercase, it's still created as uppercase, and my listener service names are all lowercase...

CREATE PLUGGABLE DATABASE "pdb3" FROM "PDB2"

gives me -

listener status -

Service "pdb3" has 1 instance(s).

So i'm not sure how to reproduce your scenario/problem...

Thanks for your reply...

What is the setting for parameter "_pdb_name_case_sensitive" in your database?    The default is FALSE but in EBS the value is set to TRUE.

I was told that controls if a lowercase value can be used.

Jim

ahhhh

i won't be able to easily test this

in the installer, what you you using, tns or the basic connect info?

TNS might get you around the problem, but this could cause issues further down the line...

if basic, did you try "dbname" vs dbname ?

I did try both suggestions, the use of TNS and using quotes around the name but got the same results

Jim

The SOLUTION is create a new service from pdb1 in lower case, and validate ords with new service name:
SQL> exec DBMS_SERVICE.CREATE_SERVICE('pdb1lowcase','pdb1lowcase');
SQL> exec DBMS_SERVICE.START_SERVICE('pdb1lowcase');
SQL> SELECT NAME FROM V$ACTIVE_SERVICES;
run now:
$java -jar ords.war validate advance
Introduce database servicename: pdb1lowcase
and it works.

So we tried the above but with no much luck.

[accadpch@mt64-027 ords_214]$
[accadpch@mt64-027 ords_214]$ java -jar ords.war install advanced --logDir $HOME/ords/ords_214/log
Specify the database connection type to use.
Enter number for [1] Basic [2] TNS [3] Custom URL [1]:1
Enter the name of the database server [localhost]:ccoap26.xxxxxxx.com
Enter the database listen port [1521]:9261
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:1
Enter the database service name:ords
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:1
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires to login with administrator privileges to verify Oracle REST Data Services schema.

Enter the administrator username:sys
Enter the database password for SYS AS SYSDBA:
Confirm password:
Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@//ccoap26.xxxxxxx.com:9261/ords

Retrieving information.
2022-04-15T15:37:53.806Z WARNING ORA-65011: Pluggable database CCOAP26 does not exist.

Enter the default tablespace for ORDS_METADATA [SYSAUX]: