Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can not connect to remote database by PL/SQL

user604243Apr 17 2008 — edited Apr 24 2008
Dear Sir/Madam,

I setup database orale 9i on windows server 2003 Enterprise Edition (setup default all of option). At server, I use PL/SQL to connect to database normally with sys/password@MYDB1 as sysdba.
in file "C:\oracle\ora92\database\SPFILEMYDB1.ora" parameter remote_login_passwordfile='exclusive'
But at the client, i can not use PL/SQL to connect to database. The error is always appear: “ORA-01017: invalid user name/password: logon denied” although i am sure that user name/password is correct (sys/password@MYDB1 as sysdba). I also copy file “tnsname.ora” from server to client:
MYDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.68)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB1)
)
)
With 192.168.1.68 is IP of sever
So, i have to do for connecting to database in server?
Thanks you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2008
Added on Apr 17 2008
19 comments
2,086 views