Shulou(Shulou.com)06/01 Report--

What this article shares with you is about how to analyze the problems encountered by oracle dual network cards. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

OPENSUSE10.2 + ORACLE 10g2

After installing two network cards, the management side is unable to log in:

One way to look up the information on the Internet is to write the addresses of the two network cards into the listener.ora file.

For example:

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 10.1.1.1) (PORT = 1521))

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.1.1.1) (PORT = 1521))

)

)

)

Previously, the value of HOST is the host domain name defined in the / ETC/HOSTS file, which I tested on my own virtual machine.

It is found that the main problem is caused by duplicate hostnames defined in HOST, and set the

10.2.53.251 linux-2lw2.site linux-2lw2

192.168.1.1 linux-2lw2.site linux-2lw2 "- just remove the alias here

10.2.53.251 linux-2lw2.site linux-2lw2

192.168.1.1 linux-2lw2.site

In this way, the client will not be able to connect to the database.

If you want to change the host name, you need to modify several files.

/ etc/HOSTNAME

/ proc/sys/kernel/hostname

/ etc/hosts

Here hosts plays the function of host name resolution. I don't think it is necessary to write the address into the listen.ora file.

The above is how to analyze the problems encountered by the oracle dual network card. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.