Native access to Oracle database on other computers

Source: Internet
Author: User

Recently found a lot of people asked how to access other people on the machine Oracle, here to give you a demonstration

With tools, Oracle takes two of its own
Configure and Move value assistant below: NET Configuration Assistant and Net Manager

A. NET Configuration Assistant
1. Select the Local NET service name configuration
2. Add
3. In the service name, enter the Oracle service name (which is the database name) of the machine you want to access, such as ABC
4. The previous agreement with the default, the host name here is the host you want to access the IP or host name (this is only for LAN) (for example, with 192.168.0.100)
5. Then it will let you test the connection, the first time is generally a failure, because it is the SYS user in the test, MS does not support with the SYS user test,
You just need to change the user's test, okay?
6. This will let you enter the network service name, you can enter a name on the line, because this name is you used to connect to other machine service name, (such as with Keymen)
And then all the way next, complete

At this point you will notice changes in this file X:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

You will find more of the following:
Keymen =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.100) (PORT = 1521))
)
(Connect_data =
(service_name = ABC)
)
)
Then you can connect to this machine (such as: Conn as SYSDBA), but the premise is that the service is started.

Two. Using NET Manager is easier

Click Local in the orcle net configuration
Under local name first select the service and then choose Dot + sign to add the service
This will let you enter the network service name first, such as the above Keymen, followed by the host name such as the 192.168.0.100 of the machine
And then the service name is like ABC above.
The next step is OK, but note that after the completion of a certain point of the file, save network configuration
That's OK.

Native access to Oracle database on other computers

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.