Toad World® Forums

Physical Server Name


#1

Is there any way that SQL Navigator can tell me what physical server name a database sits on??? Or is there an Oracle SQL script that will do so???

Thanks in advance for your review and hopeful for a response.

PSULionRP


#2

In Windows, open up a DOS Command Prompt Window (Start->Run->Cmd)
Type tnsping followed by the database name and press enter. Resulting text will indicate a HOST= which is the servername.

c:>tnsping xxdev

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 22-JUL-2009 13:05:54

Copyright © 1997 Oracle Corporation. All rights reserved.

Used parameter files:
C:\Program Files\odbc9210\network\admin\sqlnet.ora

Used ONAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=db06)(PORT=1541)))(CONNECT_DATA=(SID=xxdev)(SERVER=DEDICATED)))
OK (0 msec)


#3

sys_context(‘USERENV’, ‘OS_USER’) osuser,

sys_context(‘USERENV’, ‘HOST’) machine,

from dual;

If you are looking for an oracle way to see what system we do something like this. I think it only works on 8 or higher… There may be others…

select****sys_context(‘USERENV’, ‘TERMINAL’) terminal,sys_context(‘USERENV’, ‘SESSION_USER’) sess_user


#4

Hi,

You can get this information from Session Browser(Tools -> Session Browser). Select your session and looking for “TERMINAL” in Session tab.

Hope this help.
Jeff