Oracle11g dblink用户密码大写限制-ORA-02063: preceding line from FOR244_DBLINK

最新推荐文章于 2023-01-19 10:52:47 发布

ciqiangzhun84942

最新推荐文章于 2023-01-19 10:52:47 发布

阅读量1.3k

点赞数

文章标签：数据库

[oracle@KY22 ~]$ sqlplus admin/admin4567

SQL*Plus: Release 10.2.0.1.0 - Production on D??ú?t 6?? 12 13:52:50 2012

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> create database link for244_dblink connect to kyxx_yx identified by admin4567 using 'ky_244';

Database link created.

SQL> select sysdate from dual@for244_dblink;
select sysdate from dual@for244_dblink
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from FOR244_DBLINK

[oracle@KY22 ~]$ sqlplus kyxx_yx/admin4567@ky_244

SQL*Plus: Release 10.2.0.1.0 - Production on D??ú?t 6?? 12 13:58:44 2012

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter user kyxx_yx identified by admin4567;

User altered.

[oracle@KY22 ~]$ sqlplus admin/admin4567

SQL*Plus: Release 10.2.0.1.0 - Production on D??ú?t 6?? 12 13:59:59 2012

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select sysdate from dual@for244_dblink;

SYSDATE
--------------
12-6?? -12

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26839123/viewspace-733188/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26839123/viewspace-733188/