Tuesday, November 13, 2012

[RDBMS] What is ORACLE_UNQNAME?

The ORACLE_UNQNAME is an environment variable that is set to the database’s unique name.

To find its value you must run the following query in the database instance using SQL*Plus (as SYSTEM user):
SELECT name, db_unique_name FROM v$database
 Problem solved!