Hi all,
Sorry for this newb question. I have loaded 18C XE and want to connect to XEPDB1 via SQL Developer. I can connect to the CDB and then alter the session to get to XEPDB1, but I would like to create a connection that takes me straight to it with a user that works only in XEPDB1.
I created user "Mary" while container = XEPDB1, but I do not see the user Mary in the Other Users list. When I try to create a connection for user Mary, I get an invalid user, password error. Below are my LISTENER and TNSNAMES.ORA Files. I'm obviously not a DBA and am lost in the documentation and would really appreciate your help. Thanks so much!
DEFAULT_SERVICE_LISTENER = XE
SID_LIST_LISTENER =
(SID_LIST =
(SID\_DESC =
(SID\_NAME = CLRExtProc)
(ORACLE\_HOME = C:\\18C\\dbhomeXE)
(PROGRAM = extproc)
(ENVS = "EXTPROC\_DLLS=ONLY:C:\\18C\\dbhomeXE\\bin\\oraclr18.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.126)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.126)(PORT = 1521))
(CONNECT\_DATA =
(SERVER = DEDICATED)
(SERVICE\_NAME = XE)
(SID = XE)
)
)
LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.126)(PORT = 1521))
XEPDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.126)(PORT = 1521))
(CONNECT\_DATA =
(SERVER = DEDICATED)
(SERVICE\_NAME = XE)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS\_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT\_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
