How to check the database GLOBAL_NAME in Oracle

GLOBAL_NAME is the database''s logical identity — form is DB_NAME.DB_DOMAIN. Used when creating database links and when Data Guard references the primary. Simple one-line query, but often the first thing you check when a database link refuses to connect.

SELECT * FROM global_name;