Oracle 12c JDBC Connection PDB error problem

Source: Internet
Author: User

A classmate sent a message that the Oracle database uses a JDBC connection to report ora-12505 errors.


Subconsciously replied to see if the database Sid/service name in the JDBC connection string was incorrectly written.

The other side feedback said yes. Then let him connect in the following way is OK to connect:

Sqlplus Scott/[email PROTECTED]:1521/PDBORCL  

Then let him change the JDBC format to the following as shown below after the connection succeeds!

Connection conn = Drivermanager.getconnection ("Jdbc:oracle:thin: @localhost: 1521/pdborcl", "Scott", "Tiger");

  

Because the ":" is followed by the SID, and the "/" is followed by the service_name. The way to connect using SIDS is already obsolete in 12C.

Oracle 12c JDBC Connection PDB error problem

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: 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.