Questions about Oracle configuration of multiple databases

Source: Internet
Author: User
Tags port number

Oracle can be equipped with more than one database, and only need to open a listener on it, for multiple databases as long as the appropriate service name can be configured to connect.

I'm using Oracle 8.1.7 Enterprise edition,os is Windows Server, and I've illustrated my configuration process and situation and discussed it with you.

The first step: using NET8 Configuration Assistant tool to configure the listener, always point to the next step, finally completed! Listening to the address is usually a default of 1521 on it.

You can also use the Net8 Assistant tool to verify or configure the listener, as shown in the following figure, which allows you to configure the host and port.

Step two: Use the NET8 Assistant tool to configure the naming service, as shown in the following figure:

Note The service name is the database name, host name and port number must be the same as the listener!

Test, connection successful, ok!

Well, then with the second library service name, the following figure:

Note that the service name should correspond to the second database name!

Then test the connection to the second library, connect successfully, ok!

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.