Can't connect do pdbs - Listener problem?
Hi everyone, it's my first time configuring a VM with Oracle Linux and Oracle 18.3 on it.
Everything was going ok, but I'm having some trouble to connect to my PDBs.
I can connect to my main container using SQL Developer from a client machine, but can't connect to the pdbs...
The pdbs are open, and I can alter session to get into them, I just can't connect to them directly...
I have been going back and forth and trying many things for a few days now, and just can't find a way to connect to them.
Any help is truly appreciated.
They seem to be up and running...
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
4 PDBTS READ WRITE NO
My listener is never with status READY, always UNKNOWN...
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Service "orclpdb" has 1 instance(s).
Instance "orclpdb", status UNKNOWN, has 1 handler(s) for this service...
Service "pdbts" has 1 instance(s).
Instance "pdbts", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
And 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)
)
)
I can connect using SQL Developer to the ORCL root container, but just can't manage to connect to the pdbs
https://www.dbasupport.com/forums/im.../2023/03/1.jpg
