1. Oracle 11g R1 passwords are case sensitive by default.
2. Enclose username and password section of dblink in double quotes. Username is not mandatory to be in double quotes.
Eg: CREATE DATABASE LINK dblink10g11g CONNECT TO "username"
Tuesday, January 11, 2011
DatabaseLink between oracle 10g and 11g fails.ORA-01017. Invalid username/password
When i tried to create a database link between oracle 10g and 11g, i got an error ORA-01017. Invalid username/password. I found two solutions for this.
1. Oracle 11g R1 passwords are case sensitive by default.
2. Enclose username and password section of dblink in double quotes. Username is not mandatory to be in double quotes.
Eg: CREATE DATABASE LINK dblink10g11g CONNECT TO "username"IDENTIFIED BY "password" USING '11g db name';
1. Oracle 11g R1 passwords are case sensitive by default.
2. Enclose username and password section of dblink in double quotes. Username is not mandatory to be in double quotes.
Eg: CREATE DATABASE LINK dblink10g11g CONNECT TO "username"
Subscribe to:
Post Comments (Atom)
shhhh... dont let the DBA know...
ReplyDeleteALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE
hihihi :-)