ERROR pingManager: nmepm_pingReposURL: Cannot connect
737000Aug 6 2010 — edited Aug 7 2010Dear All,
I got a serious issues with my database
- I created a disks group (DATA) using ASMLib
- I installed Oracle grid infrastructure
- I Installed Oracle database software 11g
- My OS ORACLE ENTERPRISE LINUX 5
Result
- I couldn't start OEM
- lsnrctl take long time to start or get status
- emctl take long time to start or get status
everything ok I can access my database using SQL-Plus but I cant access using OEM
when I start lsnrctl it takes long long time (2 minutes)
when I start emctl start dbconsole it takes long time too ( > 2 min)
I tried to reconfigure emctl many times but nothing new
this's first time i use grid so i need some advice
in grid control which listener should start (grid itself or database home)
ORACLE_SID is orcl and ORACLE_HOME is /u01/app/oracle/product/11.2.0/dbhome_1
when i start dbconsole from /u01/app/oracle/product/11.2.0/dbhome_1 its start but i could not access OEM
[oracle@ora bin]$ ./emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://ora:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ............... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/ora_orcl/sysman/log
when I start dbconsole from /u01/app/oracle/product/11.2.0/grid this what happen but
ORACLE_SID is orcl and ORACLE_HOME is /u01/app/oracle/product/11.2.0/grid
[oracle@ora ~]$ emctl start dbconsole
Can't locate CompEMdbconsole.pm in @INC (@INC contains: %s_javapOracleHome%/sysman/admin/scripts %s_javapOracleHome%/bin /u01/app/oracle/product/11.2.0/grid/perl/lib/5.10.0/i686-linux-thread-multi /u01/app/oracle/product/11.2.0/grid/perl/lib/5.10.0 /u01/app/oracle/product/11.2.0/grid/perl/lib /u01/app/oracle/product/11.2.0/grid/perl/lib/site_perl/5.10.0/i686-linux-thread-multi /u01/app/oracle/product/11.2.0/grid/perl/lib/site_perl/5.10.0 /u01/app/oracle/product/11.2.0/grid/perl/lib/site_perl /u01/app/oracle/product/11.2.0/grid/perl/libwww-perl/lib /u01/app/oracle/product/11.2.0/grid/perl/ext/POSIX /u01/app/oracle/product/11.2.0/grid/perl/URI /u01/app/oracle/product/11.2.0/grid/perl/HTML_Parser /u01/app/oracle/product/11.2.0/grid/perl/HTML-Parser/lib /u01/app/oracle/product/11.2.0/grid/sysman/admin/scripts /u01/app/oracle/product/11.2.0/grid/bin /u01/app/oracle/product/11.2.0/grid/sysman/admin/scripts/Net-DNS-0.48/lib/ /u01/app/oracle/product/11.2.0/grid/sysman/admin/scripts/libnet-1.19/ .) at /u01/app/oracle/product/11.2.0/grid/bin/EmctlCommon.pm line 597.
this is the content of sysman log file emagent.trc
2010-08-07 01:28:44,551 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
2010-08-07 01:28:44,551 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
2010-08-07 01:28:44,552 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
2010-08-07 01:28:44,552 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
2010-08-07 01:29:14,567 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
2010-08-07 01:29:14,567 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
2010-08-07 01:29:14,568 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
2010-08-07 01:29:14,568 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
2010-08-07 01:29:15,663 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
2010-08-07 01:29:15,663 Thread-3007904656 ERROR upload: FxferSend: Cannot connect to: https://ora:1158/em/upload/. retStatus=-1
2010-08-07 01:29:15,663 Thread-3007904656 ERROR upload: Failed to upload file A0000001.xml: HTTP error.
2010-08-07 01:29:15,749 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
2010-08-07 01:29:15,749 Thread-3007904656 ERROR upload: FxferSend: Cannot connect to: https://ora:1158/em/upload/. retStatus=-1
2010-08-07 01:29:15,749 Thread-3007904656 ERROR upload: Failed to upload file A0000001.xml: HTTP error.
2010-08-07 01:29:15,835 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
2010-08-07 01:29:15,835 Thread-3007904656 ERROR upload: FxferSend: Cannot connect to: https://ora:1158/em/upload/. retStatus=-1
2010-08-07 01:29:15,835 Thread-3007904656 ERROR upload: Failed to upload file A0000001.xml: HTTP error.
2010-08-07 01:29:15,835 Thread-3007904656 ERROR upload: 3 Failures in a row or XML error for A0000001.xml, retcode = -2, we give up
2010-08-07 01:29:44,846 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
2010-08-07 01:29:44,846 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
2010-08-07 01:29:44,846 Thread-3007904656 WARN http: nmehl_connect_internal: connect failed to (ora:1158): Connection refused (error = 111)
2010-08-07 01:29:44,846 Thread-3007904656 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://ora:1158/em/upload/: retStatus=-1
this is the content of sysman log emagent.log*
2010-08-07 01:07:28,469 Thread-3020503952 <Upload Manager> Exceeded Max allowed Upload data - No of files: 114, Size of upload data: 64.885110MB, Pct(%) of Disk used: 8.53%, Disabling collections (00852)
2010-08-07 01:07:28,469 Thread-3020503952 Disable collector (00406)
2010-08-07 01:11:24,391 Thread-3007904656 target {orcl, oracle_database} is broken: cannot compute dynamic properties in time. (00155)
2010-08-07 01:11:24,391 Thread-3017354128 target {+ASM_ora, osm_instance} is broken: cannot compute dynamic properties in time. (00155)
2010-08-07 01:11:24,824 Thread-3007904656 enable collector (00407)
2010-08-07 01:11:26,322 Thread-3007904656 <Upload Manager> Exceeded Max allowed Upload data - No of files: 119, Size of upload data: 73.968864MB, Pct(%) of Disk used: 8.53%, Disabling collections (00852)
2010-08-07 01:11:26,322 Thread-3007904656 Disable collector (00406)
2010-08-07 01:15:49,209 Thread-3007904656 target {+ASM_ora, osm_instance} is broken: cannot compute dynamic properties in time. (00155)
2010-08-07 01:15:49,506 Thread-3007904656 enable collector (00407)
2010-08-07 01:15:50,838 Thread-3023653776 <Upload Manager> Exceeded Max allowed Upload data - No of files: 124, Size of upload data: 82.918961MB, Pct(%) of Disk used: 8.53%, Disabling collections (00852)
2010-08-07 01:15:50,838 Thread-3023653776 Disable collector (00406)
2010-08-07 01:16:09,370 Thread-3017354128 target {orcl, oracle_database} is broken: cannot compute dynamic properties in time. (00155)
2010-08-07 01:16:09,661 Thread-3017354128 enable collector (00407)
2010-08-07 01:16:10,995 Thread-3023653776 <Upload Manager> Exceeded Max allowed Upload data - No of files: 129, Size of upload data: 91.893702MB, Pct(%) of Disk used: 8.54%, Disabling collections (00852)
2010-08-07 01:16:10,995 Thread-3023653776 Disable collector (00406)
2010-08-07 01:19:49,712 Thread-3017354128 target {+ASM_ora, osm_instance} is broken: cannot compute dynamic properties in time. (00155)
2010-08-07 01:19:50,010 Thread-3017354128 enable collector (00407)
2010-08-07 01:19:51,346 Thread-3020503952 <Upload Manager> Exceeded Max allowed Upload data - No of files: 134, Size of upload data: 100.843798MB, Pct(%) of Disk used: 8.54%, Disabling collections (00852)
2010-08-07 01:19:51,346 Thread-3020503952 Disable collector (00406)
2010-08-07 01:20:09,721 Thread-3004754832 target {orcl, oracle_database} is broken: cannot compute dynamic properties in time. (00155)
2010-08-07 01:20:10,025 Thread-3004754832 enable collector (00407)
2010-08-07 01:20:11,520 Thread-3020503952 <Upload Manager> Exceeded Max allowed Upload data - No of files: 139, Size of upload data: 109.818539MB, Pct(%) of Disk used: 8.54%, Disabling collections (00852)
2010-08-07 01:20:11,520 Thread-3020503952 Disable collector (00406)
this is my listener
[oracle@ora bin]$ ./lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 07-AUG-2010 01:17:50
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 07-AUG-2010 00:42:51
Uptime 0 days 0 hr. 36 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/ora/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.20)(PORT=1523)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
any suggestions + solutions
thanks
Edited by: ORACLEZ on Aug 7, 2010 2:03 AM