denrepo

OracleInstance & database

Listener registration and services

Which listeners the instance registers with and which services it offers on every node. When clients get ORA-12514, the service they ask for is missing from this list or the listener parameters point somewhere else.

All RAC instances

Not yet verified. How scripts are tested

ora-listener-reg.sql 
1CLEAR COLUMNS2SET LINESIZE 200 PAGESIZE 100 TRIMOUT ON TAB OFF3COLUMN name  FORMAT A204COLUMN value FORMAT A120 WORD_WRAPPED5 6SELECT name, value7FROM v$parameter8WHERE name IN ('local_listener', 'remote_listener', 'service_names')9ORDER BY name;10 11COLUMN service      FORMAT A4012COLUMN network_name FORMAT A6013SELECT inst_id, name AS service, network_name14FROM gv$active_services15ORDER BY inst_id, name;

Save it as ora-listener-reg.sql and run it with SQL> @ora-listener-reg.

Open in denrepoRelated tool: Connection string builder

Helps with

Part of these runbooks

More Oracle scripts: Instance & database