This content has been marked as final. Show 6 replies
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)