http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2896]
PostgreSQL [103]
기타정보 [150]
운영체제 [583]
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, 조회 : 834

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
18.207.157.152


  LIST

제목 작성자 작성일 조회
Install and Config  ASM Filter / asmcmd afd_label / asmcmd afd_lslbl / gridSetup.sh 설치전 asm disk    최길호 2021/10/07 288
Troubleshoot  sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found    최길호 2021/10/06 692
Troubleshoot  19c _optimizer_cost_based_transformation off bug [ SR 확인 ] lv:9   최길호 2021/10/05 889
Troubleshoot  ORA-12609: TNS: Receive timeout occurred    최길호 2021/10/03 1009
Troubleshoot  EXP-00083: The previous problem occurred when calling SYS.DBMS_AUTO_TASK_EXPORT.system_info_exp    최길호 2021/10/02 796
Troubleshoot  grid 19c crsctl start has / CRS-41053 / Infrastructure has 재구축    최길호 2021/10/01 834
Troubleshoot  ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT    최길호 2021/09/30 278
Admin  alter table add column large table [ 11gR2 부터 빠르다 ]    최길호 2021/09/29 262
Troubleshoot  ORA-15411 alter diskgroup data2 offline disks in failgroup fg1 / alter diskgroup data2 add failgroup fg1    최길호 2021/09/29 487
Troubleshoot  alter diskgroup data1 add failgroup fg1 DISK '/dev/sdb' name DATA1_0000 / drop disk    최길호 2021/09/28 3970
Install and Config  create diskgroup data1 normal redundancy failgroup fg1 disk    최길호 2021/09/28 311
Troubleshoot  [INS-30525] Insufficient number of failure groups specified for Normal Redundancy level.    최길호 2021/09/28 292
Troubleshoot  PRVG-11095 : The TCP system call "connect" failed with error "113"    최길호 2021/09/28 342
Troubleshoot  ORA-00600: internal error code, arguments: [tsdrv1-Bug#24841100]    최길호 2021/09/25 346
Install and Config  ORA-24247: network access denied by access control list (ACL)    최길호 2021/09/24 315
Troubleshoot  ORA-12805 Parallel Query Server Died    최길호 2021/09/23 370

    목록보기   이전페이지   다음페이지 [1][2][3][4][5][6] 7 [8][9][10]..[145]   [다음 10개]
       

Copyright 1999-2022 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 최길호
최근 게시물
08/10
[운영체제]
mobaxterm Remote desktop (RDP,....
by 최길호
08/09
[ORACLE]
ORA-12521 listener does not cu....
by 최길호
08/08
[ORACLE]
ogg save table DML total count....
by 최길호