Low version using Dblink connection 11G version times wrong ora-02063/ora-01017

Source: Internet
Author: User

One home, a carrier phone to, create Dblink error ora-02063/ora-01017

On this bug, the encounter is not a single time, Oracle for the bug described as follows

Bug 6738104:ora-01017 ORA-02063 while connecting from10g to 11G VIA public DBLINK

Cause
The following Bug 6738104 is logged for this issue which is closed as not abug saying the cause being introduction of PA ssWOrd Case sensitivity Feature in11g
When the one creates a database link connection, a user name and password for theconnection needs to is defined. When the database link was created, the Passwordis case sensitive. Before a user can connect from a pre-release 11g database toa 11g release database and as the password case sensitivity is Enabled Bydefault, must re-create the password for this database link using alluppercase letters.
The reason need to re-create the password using all uppercase letters is sothat it would match how Oracle Database stor ES database link passwords. Oracledatabase always stores this type of password in uppercase letters, even if Thepassword had originally been created U Sing lower or mixed case letters. If casesensitivity is disabled, the user can enter the password using the case Thepassword were created in.

When the low version connects to the 11G library via Dblink, the password is changed to uppercase by default.

Solution is simple, re-create Dblink, password using double quotation marks + lowercase

Example: Create DATABASE link db_test
2 Connect to Wxboss
3 identified by "Wxboss"
4 using ' (DESCRIPTION =
5 (Address_list =
6 (ADDRESS = (PROTOCOL =tcp) (HOST = 192.168.99.100) (PORT = 1521))
7)
8 (Connect_data =
9 (SERVER = dedicated)
Ten (SID = Wxboss)
11)
12) ';

Hereby record.

Low version using Dblink connection 11G version times wrong ora-02063/ora-01017

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: info-contact@alibabacloud.com 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.