Oracle dblink creation error: ORA-01017, ORA-02063 resolution

Oracle dblink creation error: ORA-01017, ORA-02063 solution 1, create dblink original statement: www.2cto.com create public database link db_lsxyconnect to lsxy identified by lsxyusing '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192. xxx. xxx. xxx) (PORT = 2261) (CONNECT_DATA = (SERVICE_NAME = serName) '; note: the user password is in lower case. Www.2cto.com 2. Create dblink after use with the prompt: ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from <link_name> III. Problem Analysis: according to the ORA-01017 prompt is connected to the other side of the User Password error, so directly use the configured User Password (lsxy/lsxy) to log on to the database found normal login, further Check the created dblink statement. The username is converted to uppercase, And you can guess whether the password is converted to uppercase, resulting in a Password error. According to Baidu's guess, this is indeed the case. When the 9i or 10g version of Oracle Database is connected to the 11g version, the password is automatically converted to uppercase. Www.2cto.com IV. Solution: (method 1. If the password of the 11g Database User is a lowercase letter, change it to uppercase and then connect it with 9i, this method is too crude and has a big impact. (Method 2: Use double quotation marks for the password. For example, if identified by "jxunicom_sale" adopts method 2, We Can slightly rewrite the dblink creation statement as follows: create public database link DB_LSXYconnect to lsxy identified by "lsxy" using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192. xxx. xxx. xxx) (PORT = 2261) (CONNECT_DATA = (SERVICE_NAME = serName )))';