Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PDB Service as DEFAULT_LISTENER_SERVICE in 12c

JaworJul 18 2019 — edited Aug 5 2019

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/user@tnsnames_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 = D:\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 = D:\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.

This post has been answered by JohnWatson2 on Jul 18 2019
Jump to Answer

Comments

Sunny kichloo
JohnWatson2
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

Marked as Answer by Jawor · Sep 27 2020
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.

1 - 8

Post Details

Added on Jul 18 2019
8 comments
1,862 views