Domain Name In Oracle Database. Alter database rename global_name to ORA19A. Note that after the database is created changing the initialization parameter DB_DOMAIN has no effect on the global database name or on the resolution of database link names.
Salesus is also the DB_NAME. ORACLE-BASE - Identifying Host Names and IP Addresses. Alter database rename global_name to ORA19A.
The third type to get database name is using the dbms utilityThe oracle system function get_parameter_value from dbms_utility package will give you the database name.
ORACLE-BASE - Identifying Host Names and IP Addresses. Note that after the database is created changing the initialization parameter DB_DOMAIN has no effect on the global database name or on the resolution of database link names. To do this user need to create one PLSQL procedure. If the domain name has any characters other than A-Z letters 0-9 numerals _ underscore hash dollar.