Oracle bug 汇总

database link
--访问database link时报如下错误：ORA-01017: invalid username/password;logon denied 原因是密码需要用引号”“引起来
create public database link dblinkname
  connect to username identified by "password"
  using 'connect_string';
 
--ora-02024：删除database link,原因是需要public关键字
drop public database link to_brmdb.us.oracle.com

--database link ORA-02019: 未找到远程数据库的连接说明
--源脚本
create database link dblinkname connect to username identified by "password" using 'connect_string';
--修改为
create database link dblinkname
connect to username identified by "password"
using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER   =   DEDICATED)
      (SERVICE_NAME = connect_string)
    )
  )';