Oracle EM and PL/SQL developer unable to connect to DB
Date: Sat, 31 Jan 2009 07:34:46 -0800 (PST)
I installed Oracle 10gR2 on Linux machine (CentOS Release 5). This machine uses DHCP protocol.
I can't use EM from my PC to connect to the database.
I made sure that the Entrprise Manager is up and running on the Linux machine.
emctl status dbconsole
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved. Oracle Enterprise Manager 10g is running.
Dropped and recreated EM repository using emca deconfig/config commands.
Unlocked the syman account.
Edited the entries in emoms.properties for the encrypted password.
Stopped and restarted EM using emctl start/stop dbconsole command.
But still the EM can't connect to the DB.
I understand that this problem could be DHCP related. If so, is there a work-around?
Also, I can not connect to the DB on the Linux machine using PL/SQL developer on my PC. I get ORA-12560 TNS Protocol adapter error.
I made sure that the entry in my tnsnames.ora file on the PC is same as the one in the tnsnames.ora file on the Linux machine. On Linux machine, I can connect to the DB using SQLPlus.
I stopped and restarted the listener on the linix machine.
What else should I check?
Thanks in advance. Received on Sat Jan 31 2009 - 09:34:46 CST