Database Networking (MOSC)

MOSC Banner

ORA-32021 while setting LOCAL_LISTENER

edited Aug 14, 2013 9:06AM in Database Networking (MOSC) 10 commentsAnswered

Hi

In our 11.2.0.3 Database (on Linux),we have the following entry in the listener.ora

SID_LIST_LISTENER_TEST =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = ORCL)
    )
  )

LISTENER_TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.yyy.1.100)(PORT = 1525))
  )


TEST=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.yyy.1.100)(PORT = 1525))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

Tnsping works fine ....

$ tnsping test
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.yyy.1.100)(PORT = 1525))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (0 msec)

but trying to connect to that thru the listener fails and gives the following error

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