Cannot login to application designer for peoplesoft
Hello Guys,
Here is the scenario:
I have multiple oracle databases with the same name as PSPROD on different physical servers. The two tns entries are as follows:
PSPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.24.181)(PORT = 9988))
)
(CONNECT_DATA =
(SERVICE_NAME = PSPROD)
)
)
PSPRODT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.15.161)(PORT = 9988))
)
(CONNECT_DATA =
(SERVICE_NAME = PSPROD)
)
)
We are trying to connect to PSPRODT via application designer - it gives me error: Invalid user id and password
I remove the 1st entry from tnsnames.ora file and change the 2nd entry to following
PSPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.15.161)(PORT = 9988))
0