| status AGENT UNREACHABLE [message #305471] |
Mon, 10 March 2008 19:58  |
nandha
Messages: 10
Registered: March 2008
|
Junior Member |
|
|
Hi,
OEM status shows the AGENT UNREACHABLE for three configurations out of 14 configurations.
The error is given below.
EM Configuration issue. /opt/oracle/product/10.2.0/db_1/intrl-diag-db.dgosvc-priv.com_diagint not found.
the above path is the oracle home path for the database and the agent is installed under /opt/oracle/agent10g.
Even the emctl status agent throws error. How to resolve this issue.
Thanks,
Nandha.
|
|
|
|
|
|
| Re: status AGENT UNREACHABLE [message #305757 is a reply to message #305636] |
Tue, 11 March 2008 21:57  |
nandha
Messages: 10
Registered: March 2008
|
Junior Member |
|
|
Hey Hristo,
After the day light saving time the agent is unreachable and after looking at the emctl status and setting the TZ status Iam unable to connect to the repository server database through sqlplus to execute the below recommendations by the oracle.
emctl resetTZ agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Updating /opt/oracle/agent10g/sysman/config/emd.properties...
Successfully updated /opt/oracle/agent10g/sysman/config/emd.properties.
Login as the em repository user and run the script:
exec mgmt_target.set_agent_tzrgn('intrl-diag-db.dgosvc-priv.com:3872','Etc/GMT+8')
This can be done for example by logging into sqlplus and doing
SQL> exec mgmt_target.set_agent_tzrgn('intrl-diag-db.dgosvc-priv.com:3872','Etc/GMT+8')
so help me out.The OEM runs on a separate server on which OMS is configured. When I tried connecting to sqlplus, I cannot able to connect as sysdba.
Since the DBA who configured OEM has left the job and I had joined monday. I am the only DBA and have to sort out this issue.
Thank you for the support.
|
|
|
|
|
|
| Re: status AGENT UNREACHABLE [message #306087 is a reply to message #305820] |
Wed, 12 March 2008 14:56 |
nandha
Messages: 10
Registered: March 2008
|
Junior Member |
|
|
Hristo,
I connected to the OEM and executed the query by connecting to the repository database by giving the OS login credentials and schema username(SYSMAN) and password credentials.
Now the statistics have changed.
Where as still I could not able to connect to the repository database through sqlplus.
The error is given below.
/opt/oracle>sqlplus "/as sysdba"
SQL*Plus: Release 10.1.0.4.2 - Production on Wed Mar 12 12:46:04 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name: sysman@EMREP
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
The tnsnames.ora has the following entry.
EMREP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nessman)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = emrep)
)
)
Is there any thing to be coonfigured or looked into to resolve the issue.
Thanks,
Nandha.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
