Cannot CREATE DATABASE LINK IDENTIFIED BY VALUES

刘泽宇

现象：
OCI DB  ver. 12.2 .
SQL> create database link mydblink connect to testuser identified by testuser using 'mydblink';    failed  with ORA-02153: invalid VALUES password string
On source database  SEC_CASE_SENSITIVE_LOGON is not  set  ,  On Target  SEC_CASE_SENSITIVE = true .
On the  target  , can login log  in  successfully as SYSTEM using either lower case system or upper case SYSTEM.


原因：
Internal  Bug 22135763 : ORA-02153 WHILE CREATE DATABASE LINK IDENTIFIED BY VALUES , which is  closed as  not a bug .

处理方法：
Use no quotes for the DBlink  name, no quotes for the user name  , double quotes for the password and single quotes for the tnsnames.ora entry.
  SQL> CREATE DATABASE LINK DBLINK_name CONNECT TO system IDENTIFIED BY "password" USING 'REPT';