ORA-32021 while setting LOCAL_LISTENER
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
0