Hello Team,
I have one CDB named “HNDPRG" and inside the CDB i have one pdb “HCBSPND” . I am using the oracle 12.1.0.2. When connecting to PDB with “sqlplus system/<password>@HCBSPND”
SQL*Plus: Release 12.1.0.2.0 Production on Tue Sep 17 08:42:19 2024
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12641: Authentication service failed to initialize
Enter user-name: system
Enter password:
Last Successful login time: Tue Sep 17 2024 08:40:10 +02:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
SQL> SELECT SYS_CONTEXT('USERENV', 'CON_NAME') AS container_name FROM dual;
CONTAINER_NAME
--------------------------------------------------------------------------------
CDB$ROOT
First thing, i need to provide the username and password second time manually, Also It's connected to CDB not to PDB.
details :
pnd@lnzaydbdevsol03_HNDPRG [/oracle/product/12.1.0.2_sbsbe]> tnsping HCBSPND
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 17-SEP-2024 08:50:01
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/oracle/product/12.1.0.2_sbsbe/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS= (HOST=lnzaydbdevsol03.marc.fr.ssg) (PROTOCOL=TCP) (PORT=1576)) (CONNECT_DATA= (SERVICE_NAME=HCBSPND)))
OK (10 msec)
--
cat sqlnet.ora
NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT)
SQLNET.AUTHENTICATION_SERVICES = (ALL)
DEFAULT_SRV_HCBSPND = HCBSPND
--
cat listener.ora
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(KEY=ORA_12_1_0_2_sbsbe)
(PROTOCOL=IPC)
)
(ADDRESS=
(HOST=lnzaydbdevsol03)
(PROTOCOL=TCP)
(PORT=1576)
)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME=/oracle/product/12.1.0.2_sbsbe)
(SID_NAME=SABCONV2)
)
(SID_DESC=
(ORACLE_HOME=/oracle/product/12.1.0.2_sbsbe)
(SID_NAME=HCPTST)
)
(SID_DESC=
(ORACLE_HOME=/oracle/product/12.1.0.2_sbsbe)
(SID_NAME=PLSExtProc)
(PROGRAM=extproc)
)
(SID_DESC=
(ORACLE_HOME=/oracle/product/12.1.0.2_sbsbe)
(SID_NAME=HNDPRG)
)
)
-----
lsnrctl service HCBSPND
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 17-SEP-2024 08:51:28
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(HOST=lnzaydbdevsol03.marc.fr.ssg)(PROTOCOL=TCP)(PORT=1576))(CONNECT_DATA=(SERVICE_NAME=HCBSPND)))
Services Summary...
Service "HCPTST" has 1 instance(s).
Instance "HCPTST", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "HNDPRG" has 2 instance(s).
Instance "HNDPRG", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "HNDPRG", status READY, has 2 handler(s) for this service...
Handler(s):
"D000" established:1 refused:0 current:1 max:1022 state:ready
DISPATCHER <machine: lnzaydbdevsol03, pid: 21105>
(ADDRESS=(PROTOCOL=tcp)(HOST=lnzaydbdevsol03.marc.fr.ssg)(PORT=23771))
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "SABCONV2" has 1 instance(s).
Instance "SABCONV2", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "hcbspnd" has 1 instance(s).
Instance "HNDPRG", status READY, has 2 handler(s) for this service...
Handler(s):
"D000" established:1 refused:0 current:1 max:1022 state:ready
DISPATCHER <machine: lnzaydbdevsol03, pid: 21105>
(ADDRESS=(PROTOCOL=tcp)(HOST=lnzaydbdevsol03.marc.fr.ssg)(PORT=23771))
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully