Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 545 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 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
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 440 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 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.