How Does oracle set ip addresses to access databases and oracleip addresses to access data?

How Does oracle set ip addresses to access databases and oracleip addresses to access data?

The sky is vast and the sky is vast, and finally the oracle installation is successful, come to access the database, Access failed, what is going on, what is this error

 

Is my heart resentful? Do you want to play with me. No, how can a small Editor Be so kind of person? The following section describes the steps after installation.

 

First, if you need someone to access your database, you need to configure the following information. Remember the configuration path of the oracle database in the previous article, that's what you think (The following content determines whether the database can be accessed by ip addresses. You must make proper configuration.)

 

1. In the folder: c: \ windows \ system32 \ drivers \ etc, modify the hosts file and add your IP address (The IP address of xiaobian is 192.168.0.198. Please fill in your IP address):

 

2. Change the directory

F: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN listener. ora file (If your installation directory is different from the mini-editor, you need to find it on your own.), Change the original 127.0.0.1 to your own IP address, as shown below

 

3. In the same level directory, modify the tnsnames. ora file and change the original computer name to your own IP address, as shown below:

 

4. After all the modifications are completed, restart the oracle service.

 

You just need to restart the three. Just try again to see if it is successful.

 

 

The password is our own password. Use SYSTEM to log on and test the connection.

 

The connection is successful. Try it now. At this time, is my heart praising me silently? Since you are so generous, xiaobian will simply accept it with an empty mind. If you like it, I will forward it so that more friends can see it, let them leave the Bitter Sea as soon as possible

If you cannot see the image, check my public account!