要用impdp导数据,建了个dblink。在访问时提示“
ora-01017:
用户名/口令无效”。
怪了,密码肯定是没问题的,今天不经意中查了下ora-02063错误,有提到可能是在创建dblink时,指定的密码没有用双引号导致。
试了下,果然如此。以此记录一下。
另外,补充一下,这种情况发生在10g下创建访问11g库的情况,11g访问11g不存在这个问题(也就是无需加双引号)。
下面是操作过程:
SQL>
SQL> create database link wanghf
2 connect to qhky identified by qhky
3 using '(DESCRIPTION =
4 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.167.61)(PORT = 1521))
5 (CONNECT_DATA =
6 (SERVER = DEDICATED)
7 (SERVICE_NAME = orcl)
8 )
9 )';
Database link created
SQL> select * from dual@wanghf;
select * from dual@wanghf
ORA-01017: 用户名/口令无效; 登录被拒绝
ORA-02063: preceding line from WANGHF
SQL> drop database link wanghf;
Database link dropped
SQL>
SQL> create database link wanghf
2 connect to qhky identified by "qhky"
3 using '(DESCRIPTION =
4 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.167.61)(PORT = 1521))
5 (CONNECT_DATA =
6 (SERVER = DEDICATED)
7 (SERVICE_NAME = orcl)
8 )
9 )';
Database link created
SQL> select * from dual@wanghf;
DUMMY
-----
X
怪了,密码肯定是没问题的,今天不经意中查了下ora-02063错误,有提到可能是在创建dblink时,指定的密码没有用双引号导致。
试了下,果然如此。以此记录一下。
另外,补充一下,这种情况发生在10g下创建访问11g库的情况,11g访问11g不存在这个问题(也就是无需加双引号)。
下面是操作过程:
SQL>
SQL> create database link wanghf
2 connect to qhky identified by qhky
3 using '(DESCRIPTION =
4 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.167.61)(PORT = 1521))
5 (CONNECT_DATA =
6 (SERVER = DEDICATED)
7 (SERVICE_NAME = orcl)
8 )
9 )';
Database link created
SQL> select * from dual@wanghf;
select * from dual@wanghf
ORA-01017: 用户名/口令无效; 登录被拒绝
ORA-02063: preceding line from WANGHF
SQL> drop database link wanghf;
Database link dropped
SQL>
SQL> create database link wanghf
2 connect to qhky identified by "qhky"
3 using '(DESCRIPTION =
4 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.167.61)(PORT = 1521))
5 (CONNECT_DATA =
6 (SERVER = DEDICATED)
7 (SERVICE_NAME = orcl)
8 )
9 )';
Database link created
SQL> select * from dual@wanghf;
DUMMY
-----
X
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12932950/viewspace-2133143/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12932950/viewspace-2133143/