Oracle ORA-12170: TNS:Connect timeout occurred

I am getting ORA-12170 while connecting to remote database.

Please help

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
=======================================================================
host_a:/home/siebel > 
host_a:/home/siebel > sqlplus scott/tiger@dbtwo
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 21 08:45:41 2010
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
 
Enter user-name:

Oracle ORA-12170: TNS:Connect timeout occurred

I want to learn oracle, so few days back i downloaded oracle10g and installed on my home computer.I have PL/SQL developer client on the same home computer.I created my database and everything was working fine and from yesterday when i try to login using PL/SQL developer i get ORA-12170: TNS:Connect ...

Oracle ORA-12170: TNS:Connect timeout occurred

I am on Oracle 10.2.0.1.0 (Windows XP server). The sqlplusw client is also on the same box. I can connect without giving the database name locally. However, when I give the db name, I get the TNS timeout error. SQL> connect gill/gillbertConnected.SQL> connect gill@orclEnter password: ********E ...

Oracle ORA-12170:TNS:Connect timeout occurred

Hi, I am no longer able to log into SQL Plus. I get the error message above. I think the problem comes from my comtputer being renamed. Can someone help me? ...

Oracle ORA-12170: TNS:Connect timeout occurred

We are experiencing the following error with a C# application trying to connect to our Oracle Database: ORA-12170: TNS:Connect timeout occurred at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object sr ...

Oracle ORA-12170: TNS:Connect timeout occurred

I am trying to connect to database which is on the other server, but I am getting below error.I made an entry to tnsnames.ora, but still I am getting this error./opt/oracle/product/10.2.0.5/network/admin> vi tnsnames.ora "tnsnames.ora" 56 lines, 5189 characters LAB2=(DESCRIPTION=(ADDRES ...

ORA-12170: TNS:Connect timeout occurred ON Oracle RAC 11g

I have an Oracle Database 11g Release 11.1.0.6.0 in a Real Application Cluster enviroment.When I try to connect from local machine to local instance I have not problem:sqlplus *******/*****SQL*Plus: Release 11.1.0.6.0 - Production on Fri Feb 13 09:38:58 2009Copyright (c) 1982, 2007, Oracle. All righ ...

Oracle SQLPlus connection returns ORA-12170: TNS:Connect timeout occurred

I've installed the instant client but on conneting the database with SQLPlus I get the ORA-12170 error: Background that requires instant client:I'm working on a customers product-data-management system that is installed inside a virtual machine (VMWare). The database used is 10g (10.2.0.1.0), operat ...

Oracle "ORA-12170 TNS: connect timeout occured" from remote computer

I have installed oracle XE on windows XP with Service pack 2. It works fine on my computer. I have also installed XE client on another computer in the network. But whenever I try to connect from the client computer I get following error:Error:ORA-12170 TNS: connect timeout occured. ...

Oracle ORA-12170:TNS:Connect timeout occoured.

i had installed Oracle10.2.0.3 client version for Vista.& the repective server is installed on Vista on other machine.when i m trying to set Local Net Service Name Configuration by providing all necessary inforamation like1.Service name.2.Protocol no.3.Host name.then i m getting "ORA-12170:TNS:C ...

Oracle ORA-12170: TNS Connect timeout occured

I am running 10.2.0.1.0 on windows XP prof. SP2I am able to do all functionalities with this instance in the server. But When I tried to connect from my client which is a 10g client (full), I am getting timeout error. I have the IP address listed in hosts file. In my sqlnet.ora I don't have anything ...

Oracle ORA-12170 TNS: Connect timeout occured

after installing application server, I get the following:Your database configuration files have been installed in C: while other components selected for installation have been installed in C:\OraHome_1. Be cautious not to accidentally delete these configuration files.Oracle Application Server 10g (1 ...

Oracle ora-12170 TNS:connect timeout occured

HiI have Oracle 10g database on a XP pc and it is working fine. Now I have installed Oracle 10g client on a Vista pc. When I try to connect to the database on the XP pc from the Vista (client) pc, I get the following error : Ora-12170 TNS:connect timeout occured.I added the following parameters to m ...

Oracle ORA-12170 TNS:Connect Timeout occured

We are getting the following error meaasge while trying to run application from the client system.ORA-12170 TNS:Connect Timeout occuredI searched the solutions in the goolge they say that this is network problem, but we are able to ping the server from the client system.OS : Windows Server 2008 64 b ...

Oracle ORA-12170: TNS Connect timeout occured

I am unable to connect to Oracle server from my local machine. I had created proper TNS and all. Following error is displayed:"ORA-12170: TNS Connect timeout occured"I am unable to connect through TOAD as well as through SQL Plus, but I am able to ping the server machine.What could be the reason? ...

Oracle Logging in Oeacle SQL*Plus (ORA-12170: TNS: Connect timeout occured) ...

I installed recently Oracle 10g. When I try to log in, with the account and password setup[ earlier, I get the message "ORA-12170: TNS: Connect timeout occured". Do I need to specify a Host String" at Log On? Should I un-install and re-install the software again? ...

Oracle Error ORA-12170 TNS Connect timeout occured

i have installed oracle 10g 10.2.0.3 on windows vista and i would start the sql *plus it gives error Error ORA-12170 TNS Connect timeout occured.any thing regarding this? ...

Oracle ORA-12170: TNS:Connect time out Occurred

Hi, When i am trying to connect to the db installed on the system through toad, i am getting this error. When i try to login through sql plus, i am able to connect. Can you please help me to connect through toad also. ...

Oracle Handling the ORA-12170: TNS:Connect timeout in a procedure

DB Version: 10.2.0.1.0We have a procedure which fetches data from different databases via db links.The SP code looks likes select count(*) into v_cnt from FN_SCHEMA.account_hdr@FN_PROD where is_archived = 0; Last time when this procedure was run, FN_PROD DB was down because of an issue. So, the proc ...

Oracle Handling the ORA-12170: TNS:Connect timeout in a procedure

Post moved to:http://forums.oracle.com/forums/thread.jspa?threadID=1092339&stqc=trueEdited by: John_75 on Jun 28, 2010 9:33 AM ...

Oracle ORA-12170: TNS Connection Timeout

I searched several posts on this but nothing was helpful. Any help would be greatly appreciated, thanks in advance.I installed Oracle 10G database and client on my Windoxs XP SP2 laptop. I did install the Microsoft loopback adapter and Oracle database installed with no warnings. I am able to connect ...

Oracle ORA-12170 :TNS: connection timeout occured

I could not connect database. whenever I am going to connect using sql*plus I am gettingerror ora-12170:TNS: connection timeout occured.I am using oracle database 10gr2.please help me.. ...

Oracle Ora 12170: TNS Connect time out

hiI am using oracle 10g.operating system windows xp.i could connect to server using toad without any problem.But when i tried to connect through my vb.net application i received following error "ora 12170 tns connect timeout occurred". I am facing this problem from about 5 hours i have restarted the ...

Oracle TNS:Connect timeout occurred

HiWhen i connect to production to UAT using tns, then its working fine. Tnsping and ping are also working but when i use dblink to connect to production and execute a select query it takes 3to4 mins and after that i get TNS:Connect timeout occurred. I still cant figure out what might be the problem. ...

Oracle ora 12170 tns delai

I have a problem connecting my client to a the ORCL database on a small lan in my lab, first i get a timeout ORA-12170, after that i figured out that i am using a firewall , so i deactivated it , so it works fine.my question is how could i keep my firewall on and achieve the connection, since i am w ...

Oracle client problems TNS connect timeout

I have been trying to connect the free trial and beta versions of Benchmark Factory by quest software on my 32bit windows laptop to my linux desktop running oracle....With the help of people on here I have verified that my Oracle Database should allow inbound connections http://forums.oracle.com/for ...

Oracle ORA-12505: TNS:listener does not currently know of SID given in connect

I'm working on 11.1.0.7.0 Database I'm getting below error.Not able to resolve trying lot of resolving method.The resolving method I adopted are:1)TNSPING:tnsping orclTNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 23-JUN-2010 13:38:40Copyright (c) 1997, 2007, Oracle. All rights reser ...

Oracle ORA-12560: TNS:protocol adapter error when trying to connect

hopefully somebody can help me out... the problem i'm having is connecting to the scott/tiger database. i keep getting : "ORA-12560: TNS:protocol adapter error" when trying to connect to it. it worked previously, but i unistalled oracle 8i personal and reinstalled it. now it doesn't let me connect. ...

Oracle ORA-12203: TNS: unable to connect to destination

I use a db oracle version 8.0.5, that has been installed for me by someone else. I was working on a database made by someone else and i should alter it. I tried to delete the existing database (after a reverse engineering and having saved the stored data elsewhere) and make a new one, but when i try ...

Oracle ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Anybody knows this oracle error?ORA-12505: TNS:listener could not resolve SID given in connect descriptor) This error happen while connecting to Oracle Manager using user 'sys' or 'system'. I was able to connect without specifying a 'service'.I am using Oracle 8.0.5 for NT. OracleTNSlistener is up a ...