ORA-01017: invalid username/password; logon denied


#1

Hi,

i am trying to access data from database to another in Toad through a simple SQL statement.

select * from sysadm.ps_fz_audit_table@fs9tst

fs9tst is my test server, but i get the below error.

ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from FS9TST


#2

That means that your database link fs9tst is not set up with the right username and password.


#3

for testing db_links always use query simple as possible. Example:

select 1 from dual@fs9tst;

If that doesn’t work then db_link is not defined well.

If this pass then you might have problem with select right on specific table.


#4

I think i am required to maintain the same password in both dev and test , i did that after which i am able to fetch data from other database.


#5

Having the same password for dev and test could lead to accidental connections to the wrong database. Be careful.