select sys_context('USERENV','DB_NAME') as Instancefrom dual;
Following commands can be used to check the TNS Listener status
tnsping oracl (Where oracl is the instance name under concern
lsnrctl services
lsnrctl status
Thursday, March 5, 2009
Oracle instance currently running
To retrieve the Oracle instance name, execute the following SQL statement:
select sys_context('USERENV','DB_NAME') as Instancefrom dual;
Following commands can be used to check the TNS Listener status
tnsping oracl (Where oracl is the instance name under concern
lsnrctl services
lsnrctl status
select sys_context('USERENV','DB_NAME') as Instancefrom dual;
Following commands can be used to check the TNS Listener status
tnsping oracl (Where oracl is the instance name under concern
lsnrctl services
lsnrctl status
Subscribe to:
Post Comments (Atom)
Subscribe
No comments:
Post a Comment