标题: Cannot CREATE DATABASE LINK IDENTIFIED BY VALUES [打印本页] 作者: 刘泽宇 时间: 2024-3-10 10:47 标题: 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';