This content has been marked as final. Show 6 replies
The administrator application will have that info but you will more than likely need to be an admin to access it. Your sysadmin will know.
In P6 Windows client, go to the login windows, click on the ellipsis button, select your alias configuration, see the details below. If you are connecting to a SQL Server database, you will the hostname or ip number in the details section. If you are connecting to Oracle database, you will see the name of the instance, go to the tnsnames file of your oracle client to see the hostname or ip number of there database server.
I can find sqlnames.ora on my machine bt cannot find tnsnames.ora. here is what the sqlnet files reads-
# SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
(ADDRESS = (PROTOCOL = TCP)(HOST = oranames1)(PORT = 1575))
(ADDRESS = (PROTOCOL = TCP)(HOST = oranames2)(PORT = 1575))
(ADDRESS = (PROTOCOL = TCP)(HOST = oranames3)(PORT = 1575))
(ADDRESS = (PROTOCOL = TCP)(HOST = oranames4)(PORT = 1575))
NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES)
Can u pl explain if I do not have sqlnames.ora in my local machine, any other way to track te DB server IP?
One way is to fire up the P6 Professional client. One you have logged in and it has updated the display, open a command window and type netstat -b
This will show you all the active connection you have on your PC. Look for the one that is opened by PM.EXE
that was easy. You r the man