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
Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts
Thursday, March 5, 2009
Subscribe to:
Posts (Atom)

