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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Post Details

Added on Jul 18 2019
8 comments
1,837 views