`
rongren
  • 浏览: 1991 次
  • 性别: Icon_minigender_1
  • 来自: 江西
最近访客 更多访客>>
社区版块
存档分类
最新评论

关于创建oracle 连接时报以下错误,ORA-01017 ORA-02063

 
阅读更多

1. On the originating Oracle10g R2 database server, drop and recreate the public database link using double quotes around the password (IDENTIFIED BY clause) for the user account on the 11g Database. 

For example: 

DROP PUBLIC DATABASE LINK DEV11R1; 

CREATE PUBLIC DATABASE LINK DEV11R1 
CONNECT TO devuser1 IDENTIFIED BY "devuser1" 
USING 'DEV11R1'; 


2. Then test a simple select across the DEV11R1 DBLINK: 

SQL> select sysdate from dual@DEV11R1;


-- Otherwise, the 'SEC_CASE_SENSITIVE_LOGON' initialization parameter on the target (11g Database) can be used to disable password case sensitivity in the destination database.

Dynamic change:

    ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE SCOPE=BOTH;

PFILE change:

SEC_CASE_SENSITIVE_LOGON = FALSE

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics