SAP Transaction for SAP Oracle Server Listener Service Name

[Former Member]

Hi,

anybody knows a

SAP Transaction

for the

Oracle Servers Listener Service Name

?

Thanks

Martin

[Former Member]

Hello Stephan,

the service alias of the database

the hostname of the database

the port of the service alias

Thanks

Martin

[Former Member]

you could check from /oracle/<SID>/<OracleRelease>/network/admin/listener.ora to find out which listener is using by oracle. There is no tcode in SAP to find out the listener name at this time.

[former_member524429]

Hi,

All information u can get from tnsnames.ora, listner.ora, sqlnet.ora files at OS level. You can view them using AL11 t-code -> under DIR_ORAHOME directory tree...-> NETWORK-> admin from SAP System.

Service alias information based on the port info, u can be get from /etc/services file at OS level.

I hope that the above info will fulfill ur brief requirements.

Regards,

Bhavik G. Shroff

[stefan_koehler]

Hello Martin,

what do you want to see / know through this transaction?

AFAIK there is no transaction for maintaining / getting information from the listener.

Regards

Stefan