I have made a entry in listerner.ora file for static service registration
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TEST_DG)
(ORACLE_HOME = /oracle/19.0.0.0.0)
(SID_NAME = TEST1)
)
)
The Static service registration works fine and I could see the static service name as unknows in the status
lsnrctl status LISTENER
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-JUL-2020 17:16:56
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=xxx)(PORT=xxx)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 02-JUL-2020 17:09:04
Uptime 0 days 0 hr. 7 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File XXX/listener.ora
Listener Log File XXX/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=xxx)(PORT=xxx)))
Services Summary...
Service "TEST_DG" has 1 instance(s).
Instance "TEST1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
When i try to connect this even using (UR=A) option i am getting ORA-01017: invalid username/password; logon denied. But the password is correct
Any idea how to make a static service entry in listener.ora for tcps protocol
Note: The tcps coonnection works fine by using listener_networks parameter
TEST> select sys_context('userenv','network_protocol') from dual;
SYS_CONTEXT('USERENV','NETWORK_PROTOCOL')
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
tcps