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

The correct posture in which the CVM binds the host name

For a long time, when I am working on a solution, I do not recommend installing oracle on the CVM. But with the deepening of publicity, someone wants to do this. The day before yesterday, I was asked to install an oracle rac cluster in a certain cloud; I really don't know how to solve shared storage and multiple network cards.

A guy who ignored me for a long time suddenly called me and said that the oracle installed on the Ali cloud server failed to execute netca and needed my help. I admire those programmers who have successfully installed oracle on the cloud server. Curiosity drove me to ask for system permissions and climbed up to see what happened.

First, check whether the oracle instance is normal, and follow the steps below:

1. Check the process: ps auxww | grep ora. Fortunately, all processes are available.

2. Check whether the instance is normal, and there is no problem. The screenshot is as follows:

3. Check the oracle instance log and listener log respectively, and there is nothing to gain.

4. Check the system log and find no obvious abnormality

5. Check the system resources and find that the swap partition is too small, but since oracle can be installed normally, it should not have much impact; in addition, java and memcached are also running on the same system, which will stop for fear of taking up too many resources (anyway, it is an unonline system, please kill it at will)

6. Execute lsnrctl stat with oracle user, and half of the output is stuck. Wait patiently for a while, and the result is as follows:

[oracle@qhwy ~] $lsnrctl stat

LSNRCTL for Linux: Version 11.2.0.1.0-Production on 09-MAR-2018 22:33:50

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (ADDRESS= (PROTOCOL=tcp) (HOST=) (PORT=1521))

TNS-12535: TNS:operation timed out

TNS-12560: TNS:protocol adapter error

TNS-00505: Operation timed out

Prompt timeout and manually start the listener, which is the same output.

According to some experience, after a good check, it is still not solved, so search it on the Internet. Luckily, I found an article and saw that there was a problem that netca could not start, and the lack of cloud startup may have something to do with the host name. Well, open the files / etc/sysconfig/network and / etc/hosts and see where the problem lies at a glance.

Brother, Ali Yun's server uses an intranet address. If you don't believe it, look:

[root@qhwy ~] # ifconfig

Eth0: flags=4163 mtu 1500

Inet 172.17.144.28 netmask 255.255.240.0 broadcast 172.17.159.255

Ether 00:16:3e:10:5c:61 txqueuelen 1000 (Ethernet)

RX packets 5322360 bytes 6866094153 (6.3GiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 2929473 bytes 386359858 (368.4 MiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

Lo: flags=73 mtu 65536

Inet 127.0.0.1 netmask 255.0.0.0

Loop txqueuelen 1 (Local Loopback)

RX packets 381760 bytes 25954689 (24.7 MiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 381760 bytes 25954689 (24.7 MiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

Change the public network address of the / etc/hosts file to the actual network listening address:

172.17.144.28 qhwy

Switch to your oracle account, and then perform lsnrctl start to troubleshoot.

However, it is also a hidden danger to expose the oracle database directly on the public network.

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.