Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.3K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
PDB Service as DEFAULT_LISTENER_SERVICE in 12c

Hello,
I try to configure listener.ora so that I could log directly into pdb database putting in windows command line:
sqlplus user/user (without user/[email protected]_string)
Unfortunately, I get the message: Invalid username/password because sqlplus still tries to log me into CDB$ROOT.
Below all necessary pieces of my configuration involving the static registration:
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = \app\oracle\product\12.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\oracle\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = pdb)
(SID_NAME = pdb)
(SERVICE_NAME = pdb)
(ORACLE_HOME = \app\oracle\product\12.2.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.74.74.39)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
DEFAULT_SERVICE_LISTENER = pdb
Besides, I defined the local_listener parameter to handle dynamic registration.
show parameter local_listener
LISTENER_ORCL
Below tnsnames.ora with involved connection_strings:
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
I would be grateful for help. Greetings.
Best Answer
-
There is no need to configure anything special in your listener, all you need do is set your LOCAL environment variable to the tnsnames.ora alias you want to use. For example,
SET LOCAL=PDB
Answers
-
why you are mentioning SID_NAME=pdb
DO review this doc and correct your settings:
How To Setup Listener For PDBS In Multitenant Database. - ORACLE-HELP
https://dbaclass.com/article/setup-listener-pdbs-multitenant-database/
-
There is no need to configure anything special in your listener, all you need do is set your LOCAL environment variable to the tnsnames.ora alias you want to use. For example,
SET LOCAL=PDB
-
Thanks, I know that SID_NAME for PDB is improper, but I tried mixing listener configuraton ways to gain a default listener service. Besides, I don't need dynamic endpoints and valid node checking parameters because I have the standalone Oracle instance, not RAC cluster environment. Thanks for help.
-
Thanks very much. I missed that in the documentation. That is what I needed.
-
If it is resolved then do close this thread whenever you got time.
let me know if you need any more inputs.
-
Sorry, I can't see any actions to close this thread. Do I have required privileges?
-
Jawor wrote:Sorry, I can't see any actions to close this thread. Do I have required privileges?
You created it so of course you have the privileges.
There is no "close" button. What you need to do is open the thread, (don't just read it from the inbox), find the best response and use the 'correct' button. If there really was no response that was 'correct' and you eventually found the 'correct' answer yourself, write it up as a response and mark THAT as 'correct'.
-
Thanks for explanation. Everything is clear now.