Solution : https://service.sap.com/sap/support/notes/153835 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the need for managing multiple Oracle DB versions on a single server, specifically when different SQLNet versions are incompatible. It details scenarios requiring the initiation of multiple Oracle listeners (tnslsnr) and provides a solution for a configuration supporting both older and newer Oracle DB versions, using separate listeners. Instructions include editing the listener.ora, tnsnames.ora, and /etc/services files to accommodate multiple listeners. It emphasizes this setup primarily applies to situations marred by Oracle version incompatibilities, necessitating the differentiation in SQL*Net configurations.
Key words :
ora tns_admin sqlnet net8 sql net sql netv2 tnsping ora-12500 tns-01106, 0 sectrace level offsecurity offsnmp offlistener parameter file /usr/sap/trans/listener, 0 sectrace level offsecurity offsnmp offlistener parameter file /, de additional key words tnslsnr lsnrctl listener listener, oralistener log file /oracle/yo1/network/log/listener, oralistener log file /oracle/rt2/network/log/lsnr805, 16 /oracle/rt2/bin/tnslsnr lsnr805 -inherit <--- note, 16 /oracle/yo1/bin/tnslsnr listener -inheritorayo1 23452 23432 0, 17 /oracle/yo1/bin/tnslsnr listener -inheritorart2 23503 1 0, /oracle/yo1/network/log/listener
Related Notes :
| 142746 | ORA-12500 on Digital running two Instances |