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

Source: Internet
Author: User

Oracle dblink creation error: ORA-01017, ORA-02063 solution 1, create dblink original statement: 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. 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. 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 )))';

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.