It's the first time I'm setting up a Oracle database, I'm using Oracle Linux and Oracle 18.3 Everything went fine until this issue that I can't solve. I can connect through my Client side SQL Developer on the root ORCL, but not on my PDBs ORCLPDB and PDBTS. I also can't connect through SQLPlus directly to the PDBs, only alter session to them when inside the root db. I have searched for a solution for a couple days now, and unfortunately couldn't solve this issue... Any help is trully appreciated <3
So, here is my listener: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1539)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1539)) ) )
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl)
(SID_NAME=orcl)
(ORACLE_HOME=/u01/app/oracle/product/18/db_1)
)
(SID_DESC=
(GLOBAL_DBNAME=orclpdb)
(SID_NAME=orclpdb)
(ORACLE_HOME=/u01/app/oracle/product/18/db_1)
(SERVICE_NAME=orclpdb)
)
(SID_DESC=
(GLOBAL_DBNAME=pdbts)
(SID_NAME=pdbts)
(ORACLE_HOME=/u01/app/oracle/product/18/db_1)
(SERVICE_NAME=pdbts)
)
)
My connection to the ROOT container working fine: enter image description here
My connection to the PDB container that doesn't work: enter image description here
Status of the pluggable databases: enter image description here
Also my 'lsnrctl status' result: enter image description here
When I try to connect directly through the sqlplus in the server machine: enter image description here
And my tnsnames.ora: LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1539))
ORCLPDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1539)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclpdb) ) )
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1539)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
Thanks in advance for any kind soul that will try to help me with this issue.
I tried changing my listener details, my tnsnames details, shutting down than restarting the machine, the root database the pluggable dbs... Posted in other forums before discovering this one, tried chat gpt (lol), looked at the log but am no good at hexadecimal. Honestly it has been an adventure, fun and a bit stressfull. lol
