PDB Service as DEFAULT_LISTENER_SERVICE in 12c

Jawor

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.

JohnWatson2

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

Sunny kichloo

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/

=

JohnWatson2

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

Jawor

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.

Jawor

Thanks very much. I missed that in the documentation. That is what I needed.

Sunny kichloo

If it is resolved then do close this thread whenever you got time.

let me know if you need any more inputs.

Jawor

Sorry, I can't see any actions to close this thread. Do I have required privileges?

EdStevens

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'.

Jawor

Thanks for explanation. Everything is clear now.