In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
I. installation environment
Operating system version: IBM AIX 7100-03-05-1524
ORACLE version: ORACLE DATABASE 12C 12.1.0.2.0-64BIT RAC
Second, installation error report
12c RAC is installed in this environment, and the following message appears when the node one executes the root.sh script:
17:11:43 on 2018-03-29 CLSRSC-330: ADDing clusterware entries to file'/ etc/inittab'2018/03/29 17:13:49 CLSRSC-214: Failed to start the resource 'ohasd'Failed to start the Clusterware. Last 20 lines of the alert log follow:-- no more information output
The ohasd service cannot be started. Check the installation log in the $ORACLE_HOME/cfgtoollogs/oui/ directory and find no useful error information. The log information is as follows:
2018-03-29 17:11:48: Done updating / etc/inittab.tmp2018-03-29 17:11:48: Saved / etc/inittab.crs2018-03-29 17:11:48: Installed new / etc/inittab2018-03-29 17:11:48: Executing / user/sbin/init g2018-03-29 17:11:48: Executing cmd: / user/sbin/init g2018-03-29 17:11:48: Executing cmd: / oracle/app/12.1.0/grid/bin/ Crsctl start has2018-03-29 17:13:49: Command output: > CRS-4124: Oracle High Availability Services startup failed. > CRS-4000: Command Start failed Or completed with errors. > End Command output2018-03-29 17:13:49: Executing / etc/ohasd install2018-03-29 17:13:49: Executing cmd: / etc/ohasd install2018-03-29 17:13:49: Executing cmd: / oracle/app/12.1.0/grid/bin/clsecho-p has-f clsrsc-m 2142018-03-29 17:13:49: Command output: > CLSRSC-214: Failed to start the resource 'ohasd' > End Command output2018-03-29 17:13: 49: Executing cmd: / oracle/app/12.1.0/grid/bin/clsecho-p has-f clsrsc-m 2142018-03-29 17:13:49: Command output: > CLSRSC-214: Failed to start the resource 'ohasd' > End Command output2018-03-29 17:13:49: CLSRSC-214: Failed to start the resource' ohasd'2018-03-29 17:13:49: ohasd failed to start2018-03-29 17:13:49: Alert log is / oracle/app/12.1.0 / grid/log/node1/alertnode1.log2018-03-29 17:13:49: Failed to start service 'ohasd'2018-03-29 17:13:49: Checking the status of ohasd2018-03-29 17:13:49: Configured CRS Home: / oracle/app/12.1.0/grid2018-03-29 17:13:49: Eexcuting cmd: / oracle/app/12.1.0/grid/bin/crsctl check has2018-03-29 17:13:49: Checking the status of ohasd2018-03- 29 17:13:49: Eexcuting cmd: / oracle/app/12.1.0/grid/bin/crsctl check has2018-03-29 17:13:49: Checking the status of ohasd
Then check the alarm log / oracle/app/12.1.0/grid/log/node1/alertnode1.log without any information output, and then check / u/app/11.2.0/grid/log/node1/ohasd/ohasd.log and other logs, there is no information output.
An attempt was made to manually pull the ohasd process. An error was reported and could not be pulled:
[root@node1 bin] # ps-ef | grep d.bin
Root 1245784 1 0 21:33:04-0:00 / oracle/app/12.1.0/grid/bin/ohasd.bin reboot
Root 1311392 16394110 0 21:37:31 pts/2 0:00 grep d.bin
[root@node1 bin] #. / oracle/app/12.1.0/grid/bin/crsctl start has
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
Try to unregister the information registered by the root.sh script through the script roothas.pl:
[root@node1 bin] # / oracle/app/12.1.0/grid/grid/crs/install/rootcrs.pl-deconfig-verbose-force
Execute the root.sh script again, and still fail:
[root@node1 bin] # / oracle/app/12.1.0/grid/root.sh
Third, error analysis
Because there is no effective output of error information in each log, it can be said that it does not report an error, so guess the following reasons:
1. Is there any damage or loss of files in the download and decompression process of the oracle installation package?
By comparing the file size of the official website and the output record of the decompression process, this situation is less likely.
2. 12.1.0.2 is not certified on the operating system (IBM AIX on POWER Systems (64-bit) 7.1)?
L for example: 11.2.0.2 uncertified RedHat 6.x system, 11.2.0.3 uncertified RedHat 7.x system, 11g and earlier versions can be found through metelink documents (ID 169706.1), 12c can be queried through metelink documents (ID 587357.1 / ID 2226599.1 Chinese). Oracle Database 12.1.0.2.0 has been certified on IBM AIX on POWER Systems (64-bit) 7.1.
3. Ignore the installation requirement options in the installation check, such as system package, kernel parameter configuration?
L during the installation process, some unnecessary installation requirements were ignored, so the system parameter settings and the installation of the system package were checked again, and no problems were found, and if it was for this reason, there should be an error message output. so the possibility of this situation is very small.
4. Do the underlying processes or settings of the operating system block the operation of the ohasd service?
We all know that session blocking often occurs in oracle databases, usually to find out the source of blocking sessions to deal with, and at the operating system layer, inter-process communications block each other. Based on this, this situation is most likely.
IV. Conjecture verification
Since it is very likely that the communication between OS layer processes is blocked with each other, is there any way to verify it?
Truss on OS is a very useful tool, which can quickly locate and solve problems by tracking system calls or signal generation of a process at the OS system level.
Check the system process calls during the installation process through truss tracking runcluvfy.sh:
Truss-o truss_runcluvfy.out. / runcluvfy.sh stage-pre crsinst-n node1,node2-fixup-verbose
2163566:psargs:/bin/sh. / runcluvfy.sh stage-pre crsinst-n node1, node2-fixup-verboseThu Mar 29 21:24:36 20182163566: 4588341 sleeping... 0.0000: kwaitpid (0x00000000, 0,0, 0x00000000, 0x00000000) (sleeping...) # below is the key ohasd process blocking waiting information 1245784: 3998277: 0.0003: _ nsleep (0x0FFFFFFFFFFFF540, 0x0FFFFFFFFFFFF610) = 01245784: 3998277: 1.0003: kopen ("/ tmp/.oracle/opohasd") O+WRONLY | O_NONBLOCK) Err#6 ENXIO1245784: 3998277: 0.0003: _ nsleep (0x0FFFFFFFFFFFF540, 0x0FFFFFFFFFFFF610) = 01245784: 3998277: 1.0003: kopen ("/ tmp/.oracle/opohasd", O+WRONLY | O_NONBLOCK) Err#6 ENXIO1245784: 3998277: 0.0004: _ nsleep (0x0FFFFFFFFFFFF540, 0x0FFFFFFFFFFFF610) = 01245784: 3998277: 1.0004: kopen ("/ tmp/.oracle/opohasd", O+WRONLY | O_NONBLOCK) Err#6 ENXIO
Track the information according to truss, then query the relevant information on metelink, and finally find the following corresponding document: OHASD FAILED TO START: A SPECIFIED FILE DOES NOT SUPPORT THE IOCTL SYSTEM CALL (document ID 1537338.1)
Then query node 1 and node 2 / etc/inittab content, and sure enough, this information exists:
[root@node1 bin] # grep install / etc/inittab
Install_assist:2:wait:/usr/sbin/install_assist / dev/console 2 > & 1
Install_assist is the installation assistant of the system and an interactive tool, that is, if there is no response, it will wait all the time, then the commands following the line will not be executed, that is, the service under rc2.d (default runlevel 2) will not be started, which is the real culprit that cannot start the ohasd service.
V. problem solving
Comment out or clean out the install_assist line in / etc/inittab, restart the system, then re-execute root.sh, and the database is installed smoothly.
[root@node1 bin] # grep install / etc/inittab
# install_assist:2:wait:/usr/sbin/install_assist / dev/console 2 > & 1
VI. Summary
Because the operating system is installed in an emergency (the database also requires emergency installation), install_assist is not disabled after the installation system is completed, and the ohasd process is behind this process, so it has been waiting and has not been started. This case can be used as a reference. When installing the database in the AIX environment, check the contents of the / etc/inittab file first and disable install_assist first.
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.
Views: 278
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.