Skip to Main Content

Oracle Database Discussions

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!

Public Database Link as SYS

135676Apr 7 2006 — edited Apr 11 2006
I have got an issue which Oracle Support has yet to figure out.

Simple issue:

1. create a public database link
2. login in as "/ as sysdba"
3. select sysdate from dual@db2.us;
4. the above select fails with invalid username/password.

5. so we created the password file on both db's,
6. altered user SYS password to be the same on both sides,
7. still, the issue is not resolved.


dev1> sqlplus "/ as sysdba"
sql>show user
USER is SYS
SQL_DB1> create public database link db2 using 'db2.us';
SQL_DB1> select sysdate from dual@db2.us;
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from db2

We have this working in our other databases, but can't get it to work here? i understand that the:
- password file has to be set up - same password for both db1 & db2.
- remote_login_passwordfile = EXCLUSIVE
- remote_os_authent = true

I have re-created the password file for both databases and set the SYS password to be the same, i also queried, dba_users view, looked at the password values (encrypted, but still matched), regardless, its still not working. I've been working with Oracle Support as well and they have yet to provide a solution,

Please kindly provide any suggestion? input?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2006
Added on Apr 7 2006
3 comments
856 views