http://iotn.co.kr ¿¬¶ôó: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / ìíÜâïÙݤªÏìíÜâÏÚªÎàõîÜÒ¿ÖË?ßåíºªËÞóñªª¹ªÙª­. ]

»ç¿ëÀÚ

ID:
PW:

INDEX
01.°Ô½ÃÆÇ
°Ô½ÃÆÇ [71]
02.File Book
File ÀÚ·á½Ç [95]
Site Link [17]
°³ÀÎÆú´õ [200]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [41]
DB2 [79]
ORACLE [2955]
PSQL [132]
±âŸÁ¤º¸ [155]
¿î¿µÃ¼Á¦ [591]
04.Q/A Book
Q/A [53]
05.¹æ¸í·Ï
¹æ¸í·Ï [54]
·¹º§¾÷ [37]
±¸ÀÎ/±¸Á÷ [2]

±â³äÀÏ
Search
LINK
+ °¡Á· Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 È¸¿ø°¡ÀÔ

grid 19c crsctl start has / CRS-41053 / Infrastructure has À籸Ãà
ÃÖ±æÈ£ [LIST]   2021-10-01 21:47:59, Á¶È¸ : 1,449

grid 19.3, 19.11 patch »ó°ü ¾øÀÌ ¹ß»ý

uname -a
SunOS dbsvr 5.11 11.4.24.75.2 sun4v sparc sun4v [ ¿¡·¯ ¹ß»ý ]
SunOS dbsvr 5.11 11.3         sun4v sparc sun4v [ Á¤»ó ¼³Ä¡ ]


/oracle/product/grid/root.sh
2021-10-01 15:50:24 [OHASD(4154)]CRS-8500: Oracle Clusterware OHASD process is starting with operating system process ID 4154
2021-10-01 15:50:24 [OHASD(4154)]CRS-0715: Oracle High Availability Service has timed out waiting for init.ohasd to be started.
2021/10/01 15:50:24 CLSRSC-318: Failed to start Oracle OHASD service
Died at /oracle/product/grid/crs/install/crsinstall.pm line 3209.

-- log
2021-10-01 15:54:12: Executing cmd: /oracle/product/grid/bin/crsctl start has
2021-10-01 15:56:20: Command output:
>  CRS-41053: checking Oracle Grid Infrastructure for file permission issues
>  CRS-6707: init.ohasd is not running.
>  CRS-4000: Command Start failed, or completed with errors.

-- trace
/oracle_base/diag/crs/dbsvr/crs/trace/crsctl_4125.trc
2021-10-01 16:23:48.133 :GIPCXCPT:1:  gipcInternalConnectSync: failed sync request, addr 101952050 [0000000000000778] { gipcAddress : name 'ipc://scls_opct_dbsvr', objFlags 0x0, addrFlags 0x4 }, ret gipcretConnectionRefused (29)
default:1: u_set_comp_error: comptype '103' : error '29'
2021-10-01 16:23:48.135 :GIPCXCPT:1:  gipcInternalConnectSync: failed sync request, addr 101957b90 [000000000000079c] { gipcAddress : name 'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=OHASD_UI_SOCKET)(GIPCID=00000000-00000000-0))', objFlags 0x0, addrFlags 0x4 }, ret gipcretConnectionRefused (29)
2021-10-01 16:23:48.135 :GIPCXCPT:1:  gipcConnectSyncF [clscrsconGipcConnect : clscrscon.c : 686]: EXCEPTION[ ret (uknown) (910) ]  failed sync connect endp 10155c850 [0000000000000795] { gipcEndpoint : localAddr 'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=)(GIPCID=00000000-00000000-0))', remoteAddr 'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=OHASD_UI_SOCKET)(GIPCID=00000000-00000000-0))', numPend 0, numReady 0, numDone 0, numDead 0, numTransfer 0, objFlags 0x0, pidPeer 0, readyRef 0, ready 0, wobj 1018efe30, sendp 10155c350 status 13flags 0xa108071a, flags-2 0x0, usrFlags 0x0 }, addr 101957b90 [000000000000079c] { gipcAddress : name 'clsc://(ADDRESS=(PROTOCOL=ipc)(KEY=OHASD_UI_SOCKET)(GIPCID=00000000-00000000-0))', objFlags 0x0, addrFlags 0x4 }, flags 0x0
  CRFCLI:1: crfcli_init:  clscrs_stat2 failed
2021-10-01 16:23:48.136 :  CRFCLI:1: crfcli_isOsysmondRunning: scrfosm_isItRunning returned FALSE


Á¶Ä¡
/var/tmp/.oracle/npohasd : À̰Ÿ¸ ÀÖ´Â°Ô ¼ö»ó ÇÏ´Ù.
ls -al /var/tmp/.oracle
total 42
prw-r--r--   1 oracle   dba            0 Oct  1 19:43 npohasd


#!/bin/sh
# Cluster Failed to Start Due to Problem With Socket Pipe npohasd (Doc ID 1612325.1)
ps -ef | grep npohasd | grep -v grep
if [ $? == 0 ];
then
exit
fi
while true
do
if [ -f /var/tmp/.oracle/npohasd ]; then
dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
fi
sleep 1
done


ÁøÇàÁß ¸Þ¸ð
/oracle/product/grid/perl/bin/perl /oracle/product/grid/crs/install/roothas.pl -deconfig -force
rm -rf /oracle/product/grid
rm -rf /oracle_base/*
rm -rf /tmp/.oracle /var/tmp/.oracle
rm -rf /oracle/oraInventory

/tmp/.oracle /var/tmp/.oracle Æú´õ´Â ÀÚµ¿À¸·Î ¸¸µé¾îÁø´Ù.

chmod 1777 /tmp /var/tmp
ls -ld /tmp /var/tmp
drwxrwxrwt  11 root     sys          818 Oct  1 21:28 /tmp
drwxrwxrwt   4 root     sys            5 Oct  1 19:48 /var/tmp
44.200.145.223


  LIST

Á¦¸ñ ÀÛ¼ºÀÚ ÀÛ¼ºÀÏ Á¶È¸
Troubleshoot  ORA-15040: diskgroup is incomplete    ÃÖ±æÈ£ 2022/01/20 358
Install and Config  oraInventory / $ORACLE_HOME/oui/bin/runInstaller -attachHome    ÃÖ±æÈ£ 2022/01/18 285
Troubleshoot  oracleafd.conf ORA-15032: not all alterations performed ORA-15017: diskgroup "DATA" cannot be mounted    ÃÖ±æÈ£ 2022/01/16 308
Troubleshoot  CRS-2415: Resource cannot be registered because its owner 'root' is not the same as the Oracle Restart user 'oracle'.    ÃÖ±æÈ£ 2022/01/16 325
Troubleshoot  CRS-2527 CRS-2525 CRS-2673 CRS-2675    ÃÖ±æÈ£ 2022/01/15 265
Script  rmtrc.sh    ÃÖ±æÈ£ 2022/01/11 218
Troubleshoot  ORA-15032 ORA-15034 ORA-15080    ÃÖ±æÈ£ 2022/01/06 290
Install and Config  19c move ocr votedisk to +GRID2 / ÀÌÁßÈ­ Å×½ºÆ®    ÃÖ±æÈ£ 2022/01/04 318
Install and Config  19c ocr ÀÌÁßÈ­ ocrconfig -add , ocr votedisk Àå¾Ö test    ÃÖ±æÈ£ 2021/12/31 276
Troubleshoot  12c High CPU Usage by MMON_SLAVE    ÃÖ±æÈ£ 2021/12/31 335
RAC,OPS  create diskgroup vote normal redundancy / crsctl replace votedisk +VOTE    ÃÖ±æÈ£ 2021/12/22 216
Install and Config  19c rac change port 8888    ÃÖ±æÈ£ 2021/12/22 361
Troubleshoot  ORA-00201: control file version    ÃÖ±æÈ£ 2021/12/22 330

    ¸ñ·Ïº¸±â   ÀÌÀüÆäÀÌÁö   ´ÙÀ½ÆäÀÌÁö [1][2][3][4][5][6] 7 [8][9][10]..[148]   [´ÙÀ½ 10°³]
       

Copyright 1999-2023 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)
ÃÖ±Ù ´ñ±Û
2021/06/30
À©µµ¿ì ¼­¹ö¿¡¼­ sqlplus .... ORA-...
by ÃÖ±æÈ£
2021/06/30
ORA-28500: connection from O...
by ÃÖ±æÈ£
2019/05/02
pkg È®ÀÎ SELECT * FROM AL...
by ÃÖ±æÈ£
ÃÖ±Ù °Ô½Ã¹°
06/05
[ORACLE]
ORA-27303: additional informat....
by ÃÖ±æÈ£
06/02
[°Ô½ÃÆÇ]
2023³â Àû¿ë SW(¼ÒÇÁÆ®¿þ¾î)±â¼úÀÚ Æò±ÕÀÓ±Ý ....
by ÃÖ±æÈ£
06/01
[ORACLE]
ORA-19504: failed to create fi....
by ÃÖ±æÈ£