Re: Oracle EM and PL/SQL developer unable to connect to DB
From: yanamandra <venu.yanamandra_at_gmail.com>
Date: Sun, 1 Feb 2009 00:39:33 -0800 (PST)
Message-ID: <b083cab9-4b7c-4344-ba1c-1f5058066e2f_at_e1g2000pra.googlegroups.com>
On Jan 31, 8:54 pm, Ora_DBA <sanjaydharmadhik..._at_gmail.com> wrote:
> On Jan 31, 10:34 am, Ora_DBA <sanjaydharmadhik..._at_gmail.com> wrote:
>
>
>
>
>
> > 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.
>
> I also made sure that the ports on the linux machine ( 1158 and 1521 )
> are open.
>
> When I use TNSPing command from my PC, it returns an error.
>
> C:\Documents and Settings\sdharmadhik2>tnsping asndb
>
> TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production
> on 31-JAN-
> 009 10:52:18
>
> Copyright (c) 1997, 2005, Oracle. All rights reserved.
>
> Used parameter files:
> C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST
> = EBEST-1.
> wbc.csi.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
> (SERVICE_NA
> E = asndb)))
> TNS-12560: TNS:protocol adapter error- Hide quoted text -
>
> - Show quoted text -
Date: Sun, 1 Feb 2009 00:39:33 -0800 (PST)
Message-ID: <b083cab9-4b7c-4344-ba1c-1f5058066e2f_at_e1g2000pra.googlegroups.com>
On Jan 31, 8:54 pm, Ora_DBA <sanjaydharmadhik..._at_gmail.com> wrote:
> On Jan 31, 10:34 am, Ora_DBA <sanjaydharmadhik..._at_gmail.com> wrote:
>
>
>
>
>
> > 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.
>
> I also made sure that the ports on the linux machine ( 1158 and 1521 )
> are open.
>
> When I use TNSPing command from my PC, it returns an error.
>
> C:\Documents and Settings\sdharmadhik2>tnsping asndb
>
> TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production
> on 31-JAN-
> 009 10:52:18
>
> Copyright (c) 1997, 2005, Oracle. All rights reserved.
>
> Used parameter files:
> C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST
> = EBEST-1.
> wbc.csi.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
> (SERVICE_NA
> E = asndb)))
> TNS-12560: TNS:protocol adapter error- Hide quoted text -
>
> - Show quoted text -
if you are sure that the EM server is listening, make sure the clients can connect to the ports on the server too. use the command: "telnet <SERVER_IP_OR_NODE_NAME> <PORT_NUMBER> " to see if you are able to connect from the client. check your sqlnet file to see if there is any domain name restriction set in your installation. check if the tnsnames.ora has the correct SID that matches the GLOBAL_DBNAME in the listener.ora file on the server.
let us know what you find out! Received on Sun Feb 01 2009 - 02:39:33 CST