How Does oracle set ip addresses to access databases ?, Oracleip Database Access

How Does oracle set ip addresses to access databases ?, Oracleip Database Access

After successful oracle Installation, access to the database shows that access failed. What is the problem?

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 is 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.

3. In the same level directory, modify the tnsnames. ora file and change the original computer name to its own IP address.

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, and the connection is successful. Please try again.