Oracle Database Connectivity Analysis _oracle

Source: Internet
Author: User
Tags oracle database
1. Connect the native database
A. If the machine has a static ip,oracle installed, it can connect the native Oracle database.
B. When Oracle is installed, the computer does not have a static IP (that is, when the network cable is not plugged in).
Modify the Tnsnames.ora, Listener.ora file in the Network\admin file to HOST the native computer name.
If the computer name is not set well, modify the windows\system32\drivers\etc\ hosts file.
2. Connect it to the machine server
A. Open instance services and listeners.
B. Enter the Netmanager to build the connection.
3. Connection Note Point
A. Sqlplus NXG/NXG@ORCL format to connect, you must turn on the monitor.
B. The use of Pl-sql must be opened for monitoring.
C. Connecting in Myeclipes, connection string Jdbc:oracle:thin: @localhost: ORCL in 1521:ORCL must be a service
The instance name of the device, not the alias that was taken on the native machine.
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.