Tip
2010.12.15 14:39

em 실행시 에러 발생 조치

조회 수 27310 추천 수 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 84911
100 TM Oracle Silent Install Guide 3 file 송기성 2011.03.13 20252
99 TM 엔지니어필수품 file perfstat 2011.03.03 14117
98 TM RAC10g R2 patch(10.2.0.1->10.2.0.5) file 윤현 2011.03.02 10715
97 Tip windows os 에서 운영중 listener.log 삭제하기 2 file dbkill 2011.02.21 22264
96 Tip partition table에 index 생성시 perfstat 2011.01.28 18167
95 TM oracle client 와 database 간 상호 호환성(version) 1 담벼락 2011.01.24 23203
94 Tip DB계정에 profile설정 perfstat 2011.01.05 14594
93 TM Automatic Storage Management file 담벼락 2010.12.31 10629
92 TM 10g Transportable Tablespace 에 대한 세미나 자료 입니다 file 송기성 2010.12.29 9204
91 TM Replication 세미나 자료 file 고구마 2010.12.29 11200
90 TM SystemState 세미나자료 file 고구마 2010.12.29 11024
89 TM Database Replay 담벼락 2010.12.27 9515
88 TM ORA-1578 조치를 위한 event 10231 1 이성철 2010.12.22 8456
87 TM (10g) 자동 통계정보 수집(AUTOMATIC OPTIMIZER STATISTICS COLLECTION) 담벼락 2010.12.16 16384
86 TM 오라클 디렉토리 변경 송기성 2010.12.16 25815
» Tip em 실행시 에러 발생 조치 1 dbkill 2010.12.15 27310
84 Q&A RHEL5에 11gR2 RAC 구성시 ASM 관련 에러 file 송기성 2010.12.11 17729
83 Tip NetCA 실행시 VM 관련 에러 대처법 2 송기성 2010.12.09 18180
82 TM UPDATABLE SNAPSHOT 구축하기 고구마 2010.08.23 15507
81 TM replication table 다른 tablespace 로 옮기기 고구마 2010.08.23 13822
Board Pagination Prev 1 2 3 4 5 6 7 8 Next
/ 8