Hi Folks!!!
I have installed my current version of Oracle 11 g last year and it was working absolutely fine till yesterday. I do not have idea about what went wrong and EM started behaving weird.
I am getting following error :
Database Instance: orcl |
 |
| Enterprise Manager is not able to connect to the database instance. The state of the components are listed below. | | Page Refreshed | | Oct 3, 2013 2:55:00 PM IST | |  |
|
|
| Database Instance | |
|
|
| | Host | | | | Port | | | | SID | | | | Oracle Home | | | C:\app\admin\product\11.2.0\dbhome_1 |
|
| |
|
|
| | Listener | |
| | | Status | | | | Host | | | | Port | | | | Name | | | | Oracle Home | | | C:\app\admin\product\11.2.0\dbhome_1 |
| | Location | | | C:\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN |
| | Details | | |
|
|
|
| | | Agent Connection to Instance | |
| | | Status | | | | Details | | ORA-28547: connection to server failed, probable Oracle Net admin error (DBD ERROR: OCISessionBegin) |
|
|
|
|
Following are some results :
C:\Users\admin>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 03-OCT-2013 15:18:26
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Start Date 03-OCT-2013 14:33:00
Uptime 0 days 0 hr. 45 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
Listener Log File c:\app\admin\diag\tnslsnr\admin-PC\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
C:\Users\admin>emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://localhost:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...The requested service has already been started.
More help is available by typing NET HELPMSG 2182.
TNSNAMEs.ORA
# tnsnames.ora Network Configuration File: C:\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = orcl)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
LISTENER.ORA file
# listener.ora Network Configuration File: C:\app\admin\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\admin\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\app\admin
Kindly help. This issue has wasted my whole day and I have tried almost everything on google's search results. But all went invain.
As I am beginner, some of the posts were bouncers for me
TIA
Priyanka Joshi