Hello,
I have two virtual machines one with Oracle 11gR2 and the other with Oracle 12c installed both on RHEL 6
I wanted to setup a dblink between the 2, but after creating the dblink I get error: ORA-01017 Invalid username/password
Now I know the error is pretty clear but when I try to connect using netmgr it works
So just to recap, from Oracle 12c I try to connect to Oracle 11g using a DBLINK but I get ORA-01017
From Oracle 12c I have created a new service so that I have the alias of the remote db in tnsname.ora and at the end of the process, when they ask to test the connection, I can successfully connect to the remote db
Then I have created a dblink as per following:
SQL> CREATE PUBLIC DATABASE LINK DBLINK CONNECT TO
"hr" IDENTIFIED BY "password" USING 'REMOTEDB';
If I then select * from employees@dblink I get the error
What I have noticed is that in the 11g ( the target machine ) I can't login using OS authentication, not sure if its related
If I: sqlplus / as sysdba I get ORA-01031 insufficient provileges
I login to the linux machine as user "oracle" which is member of oinstall and dba groups
Am I missing something ?
Thank you !