user8757041 wrote:No necessary. 3tier connection - through the AppServer - does not need it.
anyone knows how to connect database that we created with scripts by peoplesoft?
after I installed peopletools on window XP (client), should I have to instal oracle 11gR1 client??
user8757041 wrote:Hmmm, what's the content of table PSDBOWNER ?
would like to explain how to configure tnsnames.ora?? we configure it only on client machine. Am I right?
( DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST=18.104.22.168) (PORT=1521))
(SERVER = DEDICATED)
(SID = DMOHRMS9)
FYI, I can ping to 22.214.171.124 well in command prompt.
when I run Data Mover I get error
file: SQL ACCESS MANAGER SQL error. Stmt #:2 Error position: 0 return: 12154
ORA-12154: TNS: could not resolve the connect identifier specified
SQL> CONNECT PS/PS;Error accessing PRODUCT_USER_PROFILE
I restart all over again, but before I ran dbowner.sql, I ran pupbld.sql first. But I still got error.hello user8767041, just want to help.
well, i select * from ps.psdbowner; there is no row selected.
If I compare with your database creation steps, you don't even run pupbld.sql. I see that it is success. Are there missing steps??