Database Administration (MOSC)

MOSC Banner

Accessing listener from second instance

edited Jan 18, 2020 10:42AM in Database Administration (MOSC) 40 commentsAnswered ✓

Hello,

Oracle Version:

Oracle Database 18c Standard Edition 2 Release 18.0.0.0.0 - Production

Version 18.7.0.0.0

  29757256 APPLY           SUCCESS                   Database Release Update : 18.7.0.0.190716 (29757256)

  29774410 APPLY           SUCCESS                   OJVM RELEASE UPDATE: 18.7.0.0.190716 (29774410)

Two instances on one host:

orcl:/opt/app/oracle/product/18.0.0/dbhome_1:Y

oratest:/u01/app/oracle/product/18.0.0/dbhome_2:Y

lsnrctl status showed services only for production instance. There was no services for test thought it was running.

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string      LISTENER_ORCL               <= production settings

local_listener                       string      LISTENER_ORATEST        <= test settings

when I changed local_listener on test instance to following it started to show services correctly.

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center