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