Tip
2010.12.15 14:39

em 실행시 에러 발생 조치

조회 수 27305 추천 수 0 댓글 1

$ emctl start dbconsole

 

Starting Oracle Enterprise Manager 10g Database Control ............................................................................................. failed.
------------------------------------------------------------------
Logs are generated in directory /oracle/app/oracle/product/10g/PAMS_PAMS/sysman/log

 

위 log 경로 확인

 

$ cd /oracle/app/oracle/product/10g/PAMS_PAMS/sysman/log
$ ls -ltr
total 23448
-rw-r----- 1 oracle dba       0 Mar  3  2010 emdctl.log
-rw-r----- 1 oracle dba    4301 Mar  3  2010 secure.log
-rw-r----- 1 oracle dba       0 Mar  3  2010 emagentfetchlet.trc
-rw-r----- 1 oracle dba       0 Mar  3  2010 emagentfetchlet.log
drwxrwx--- 2 oracle dba    4096 Mar  3  2010 nmcPAMS1521
-rw-r----- 1 oracle dba 4194328 Sep  5 09:05 emagent.trc.4
-rw-r----- 1 oracle dba 4194378 Sep  6 08:29 emagent.trc.3
-rw-r----- 1 oracle dba 4194422 Sep  7 07:25 emagent.trc.2
-rw-r----- 1 oracle dba 4194347 Sep  8 06:27 emagent.trc.1
-rw-r----- 1 oracle dba  979509 Dec 15 14:06 emoms.trc
-rw-r----- 1 oracle dba  979509 Dec 15 14:06 emoms.log
-rw-r----- 1 oracle dba    4096 Dec 15 14:08 emdb.nohup.lr
-rw-r----- 1 oracle dba  796568 Dec 15 14:08 emdb.nohup
-rw-r----- 1 oracle dba     486 Dec 15 14:08 emagent.log
-rw-r----- 1 oracle dba 1922111 Dec 15 14:12 emdctl.trc
-rw-r----- 1 oracle dba 2403843 Dec 15 14:12 emagent.trc
$ vi emagent.trc

2010-12-15 14:11:34 Thread-39074704 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://........:1158/em/upload/: retStatus=-1
2010-12-15 14:12:03 Thread-39074704 ERROR upload: Error in uploadXMLFiles.  Trying again in 176.00 seconds.
2010-12-15 14:12:04 Thread-39074704 ERROR ssl: nzos_Handshake failed, ret=29024
2010-12-15 14:12:04 Thread-39074704 ERROR http: 9: Unable to initialize ssl connection with server, aborting connection attempt

 

DB Console HTTPS (SSL) Certificate Has Expired. Error "ssl: nzos_Handshake failed, ret=29024" Encountered in Emagent Logs [ID 738659.1]

Applies to:

Enterprise Manager Grid Control - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
All Platforms

Goal

When connecting to EM DB Console URL , there is a certificate notice indicating that the secure (SSL) certificate has expired.

Also, $ORACLE_HOME/<hostname>_<SID>/sysman/log/emagent.trc will show errors in the form of:

"ssl: nzos_Handshake failed, ret=29024"

Another side-effect of this is that the EM DB Console will no longer start when the certificate has expired. If the above error is found in the emagent.trc file, then your are hitting this issue.

Solution

When the EM DB Console is secured (HTTPS), the SSL certificate that is generated has a lifetime of 6 months. Ideally, when the Internet browser is alerting about the certificate expiring soon, it needs to generate a new one, before the expiration date, using the following command:

$ORACLE_HOME/bin/emctl secure dbconsole -reset

TAG •
  • 담벼락 2010.12.16 19:56

    아.. ssl은 lifetime이 6개월로 제한이 되어 있네요..


List of Articles
번호 분류 제목 글쓴이 날짜 조회 수
공지 Q&A Oracle관련 게시물만 Sean 2014.04.09 84896
159 Tip TEMP TABLESPACE 사용현황 조회하기 1 고구마 2010.05.19 43762
158 TM windows에서 Opatch 진행시 oci.dll 에러 조치 1 이현정 2012.03.26 37457
157 Tip 핫백업 디비올리기 유주환 2010.04.09 34980
156 Tip UDP Buffer Tuning 기법 3 김준호 2010.05.04 30910
155 Tip Log miner 사용방법 1 김준호 2010.04.06 29919
154 Tip 오라클 null값 정리 유주환 2010.04.18 29861
153 Tip (Diagnostics) Oracle10g DB 접속 안될때 sqlplus 에서 SYSTEMSTATE DUMP 받기 1 고구마 2011.05.18 29071
152 Tip shared pool wait event 2 file 유주환 2010.04.05 28881
» Tip em 실행시 에러 발생 조치 1 dbkill 2010.12.15 27305
150 Tip 오라클11g에서 SE1,SE,EE제품의 옵션비교입니다. file perfstat 2012.03.07 27011
149 TM audit 관련 2 이현정 2012.03.29 26569
148 TM check whether crs auto start is enable or disable 담벼락 2012.10.12 26286
147 Tip EM 재구성 고구마 2010.04.09 26261
146 Tip 10g standard edition과 enterprise edition의 차이점 2 윤현 2011.05.16 26048
145 Tip Buffer Cahe 관련 대기 이벤트들 고구마 2010.04.28 25635
144 TM 테이블과 인덱스의 관계 및 인덱스 종류 및 생성 방법. Tech1 2012.03.28 25522
143 Tip EXPORT/IMPORT 이용한 TABLE과 INDEX 분리하는 방법 고구마 2010.05.24 25452
142 Tip sysaux resize 유주환 2010.04.18 25290
141 Tip shared pool / library cache 고구마 2010.04.28 25066
Board Pagination Prev 1 2 3 4 5 6 7 8 Next
/ 8