Networking And Gateways :: ORA-12170 - TNS - Connect Timeout Occurred

Jan 24, 2012

I get below error when trying to connect to database server using

C:Documents and SettingsAdministrator>sqlplus jack/jack@DB_PROD

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 24 12:11:45 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12170: TNS:Connect timeout occurred

Enter user-name:

FYI,

The database i am trying to connect is 9.2.0.8.0 and the client that is installed in my machine is 10.2.0.1.0

Is problem with the database versions ?

View 5 Replies


ADVERTISEMENT

Networking And Gateways :: ORA-12170 / TNS / Connect Timeout Occurred

Jul 18, 2011

I was getting the following error when trying to connect development database.

sqlplus bala/test11@ORCL.SBC.COM
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 18 13:04:18 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:ORA-12170: TNS:Connect timeout occurred
Enter user-name:

But i am to connect this database through putty,toad at that time. But after sometime, i was able to connect the database.

View 4 Replies View Related

Networking And Gateways :: ORA-12170 / TNS / Connect Timeout Error

Jan 10, 2012

I installed my Oracle 10g R2 software in redhat linux installed in VMWare player in my laptop.

I am trying to connect to database from my laptop which has windows 7 installed

My goal is to connect to database installed in linux vmware from my laptop having windows7 OS..

I have installed Oracle instant client on windows 7,trying to make a connection to database but its giving me the following error when i tried...

sqlplus sqlplus scott/tiger@(description=(address_list=(
address=(protocol=TCP)(host=192.168.1.7)(port=1521)))(connect_data=(service_name=subhani)))..

ora-12170:TNS Connect TimeOut Error..

View 11 Replies View Related

Networking And Gateways :: FRM-92102 / A Network Error Has Occurred

Sep 28, 2011

when i try to open a our application i got this error

"FRM-92102: A network error has occurred. The Forms Client has attempted to reestablish its connection to the Server 5 time(s) without success."

View 1 Replies View Related

Networking And Gateways :: Cannot Connect To Database

Nov 2, 2011

I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files

tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myservername.domainname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
[code]....

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

View 19 Replies View Related

Networking And Gateways :: Connect Time Fail Over?

Mar 12, 2010

I would like to implement connect time fail over from my JDBC thin client. The client will try to first connect with dedicated connection mode, if the connection time crosses more than two seconds, then connection will be opened with shared mode. To implement this, I have put the following connection string in my JDBC URL. I am able to connect to database with this URL, however it seems fail over does not work. Is it because, my database listener is not configured with dynamic service registration. If I implement the dynamic service registration, is fail over going to work? Note, I want to fail over in the same database instance but with different listener.

(DESCRIPTION_LIST =
(FAILOVER = TRUE)
(LOAD_BALANCE = FALSE)

[Code].....

View 11 Replies View Related

Networking And Gateways :: TNS Could Not Resolve Connect Identifier Specified

Nov 4, 2010

I have a really strange problem connecting from a new client to an Oracle server, here are the points :

- There is no problem with DB server and its listener and all that as I am able to connect from other clients
- I have installed the oraclient on this machine ( it is a XP machine ) and copy/pasted the TNSNAMES.ORA from one of those correct PCs here and when I do a TNSPING is returns OK
- even when I open oracle net manager I see the TNS entries in there and when I test a connection thru it is says successfull
- BUT WHEN I USE SQL+ or TOAD or ODBC ( any of these) trying to make a connection using the exact same TNS entries it returns :

"ORA-12154: TNS:could not resolve the connect identifier specified"

- I have tried with both IP and Host name but no luck
- TNSNames.Ora and sqlnet.ora both are located here : oracleproduct10.2.0client_1NETWORKADMIN
- there is just one oracle home
- I have already uninstalled/installed oracle client
- These lines are included in Sqlnet.ora :
SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES)

I marked those entries in Sqlnet.ora and that made no diff in result, another thing : if I use easy connect method : sqlplus scott/tiger@<Servername>:1521/ORCL it does connect but using TNSNames still I can not get connected. so strange!!, seems somehow the TNS file even is not being picked or looked at !

View 2 Replies View Related

Networking And Gateways :: Unable To Connect To DB From Client

Dec 3, 2011

I was trying to connect to oracle 10g database from oracle 10g client. But unable to do so.

i am able to tnsping the db from client but unable to estatblish sqlplus connection. I get ORA-28547 error when i issue the command sqlplus hr/***@db1. ORA-1560 when the command sqlplus hr/*** is issued.

I have mentioned the listener and tnsnames.ora files

listener.ora
------------
[oracle@localhost admin]$ more listener.ora
# listener.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/netw
ork/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
[code]........

View 4 Replies View Related

Networking And Gateways :: Connect Remotely Database?

Jul 14, 2010

i have a inventory system and trying to connect remote database one by one throught two static ips. If first ip is not ping then go to 2nd ip only when open the login.fmx page

following examples are my tnsnames.ora

IP1.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.12)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

IP2.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 117.65.48.13)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

i am not understand what i write the code on-logon trigger

View 8 Replies View Related

Networking And Gateways :: Unable To Connect To OPMN

Jan 25, 2011

Getting Unable to connect to OPMN. Opmn may not be up while checking the status of instance.

View 2 Replies View Related

Networking And Gateways :: Unable To Connect To Database?

Feb 1, 2012

I am getting beloww error very frequently in database log and not able to connect to the database.

************************
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production
Time: 01-FEB-2012 18:00:34
Tracing not turned on.
Tns error struct:
ns main err 12535

TNS-12535: TNS:operation timed out
ns secondary err 12606
nt main err 0
nt secondary err 0
nt OS err 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.179.1.24)(PORT=65503))
WARNING: inbound connection timed out (ORA-3136)
Wed Feb 01 18:00:44 2012
*****************

View 2 Replies View Related

Networking And Gateways :: TNS - Could Not Resolve Connect Identifier Specified

Dec 29, 2012

I have both 10g and 11g installed in my machine.There are so many CI builds that runs without problems.For few builds which uses 10g, it throws errors as ,

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 27 01:18:52 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:

Only at a particular step, this is happening. After this,if some-other target is connecting to Oracle,it is able to connect.

View 5 Replies View Related

Networking And Gateways :: Can't Connect To Remote DB Listener

Jul 2, 2010

I have a database up and running (including listener) on machine A. From that machine, everything seems fine. However, when I try to connect to it from another machine (say, machine B) on the network, the connection cannot be established (exact message: connection to database failed: The Network adapter cannot establish the connection).

I can successfully ping machine A from machine B. The machine A db is a default install (ORCL).

Is it possible the DB listener is not configured properly to connect to remote clients? On machine B, I have oracle tools such as SQLPLUS, Oracle Net Manager, and Net Configuration Assistant.

View 31 Replies View Related

Networking And Gateways :: Unable To Connect To Database

Jun 27, 2011

am getting this message when am connecting to a database :

ora-12519:Message 12519 not found;product=RDBMS80 facility = ORA

am not getting this message all the time, sometimes am connected without any problem sometimes i get this message and i have to try again several times until am connected

i searched the net and my database provider guided me to this log URL.....

how to set my ORACLE_HOME environment variable.

View 9 Replies View Related

Networking And Gateways :: Connect Remote Database Without Providing SID?

Apr 5, 2010

i need to connect to a remote database located on a different server using sqlplus without using database name in connect string.

e.g. if mydb1 (located on another database server on network)

sqlplus username/password

i am able to do this on local database but not on the remote database

View 7 Replies View Related

Networking And Gateways :: Forms Not Connect On Remote Site

Sep 17, 2013

I have a strange problem of connecting Oracle Forms6i from our Remote site.actually we change our IP address of lease line, we connect to it.but when we connect locally,forms are running without any problem,but when we connect globally or from other sites it can't able to connect,even sql prompt and toad also connect from remote site,but when we try to connect forms(forms runtime) it gives error message(ORA-12203: TNS:unable to connect to destination).when we connect this application from local application(Forms) it can connect well but from globally it can't able to connect.

View 1 Replies View Related

Networking And Gateways :: ORA-12203 TNS - Unable To Connect To Destination

Oct 17, 2012

I install oracle database 11g and developer 6i on windows7 64bit server everything is working fine on the server and i install developer 6i on windows XP on client now i'm getting "ora-12203:TNS: unable to connect to destination" when trying to connect the server. i have check the TNSNAMES.ORA file the configuration is fine. then why i'm getting this message?

View 5 Replies View Related

Networking And Gateways :: Oracle Database Not Connect From Outside LAN Via Static IP

Nov 17, 2011

I have created two database one for production and another one for test.I created both database in shared_server mode(by using dbca),after than I did not change anything.My problem is when i connect to test database from outside lan through static ip its working well,but when i connect to production database which is not connected. I checked and compared two databases,then I find there are some changes in dispatcher and mts_ dispatcher parameters.And I used this query to check the shared_server status,

ie.select * from v$shared_server,

the output of this query is attached with this post.

View 8 Replies View Related

Networking And Gateways :: Using Putty To Connect To Oracle Database?

Jul 5, 2011

Do I need to install the Oracle client in order to use putty to connect to the database?

View 11 Replies View Related

Networking And Gateways :: ORA-12154 / TNS / Could Not Resolve Connect Identifier Specified

Dec 4, 2012

While connecting to Database through sqlplus as sysdba, error pop-up.

SQL> conn sysdba@disdevt
Enter password: *******
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
SQL>

but i am able to log-in to database through pl/sql developer. Since TNS is same for both.

View 6 Replies View Related

Networking And Gateways :: Fatal NI Connect Error 12638

Aug 10, 2008

I'm getting this information in sqlnet.log file lying at D:oracleoradatadatabase

Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclemaninder)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')) (CONNECT_DATA=(SID=maninder)(CID=(PROGRAM=d:oracleora92inORACLE.EXE)(HOST=SAI-E6C10175EE4)(USER=OraUser))))
[code]...

View 5 Replies View Related

Networking And Gateways :: Can't Connect To Sybase (ASA) Via Database Gateway

Sep 6, 2009

I'm trying to connect from Oracle 11g (11.2.0.1.0) to Sybase Adaptive Server Anywhere (9.0.2.3527). My Oracle environment is running on Linux Centos 5.3, the sybase database runs on a Windows Server.

All my attempts have failed so far - both through Oracle Database Gateway for Sybase and via Oracle Database Gateway for ODBC in combination with freeTDS. Using either way I'm ending up with apparently the same error:

ASA Error -611: Transact-SQL feature not supported

When I use db link created via dg4sybs (Oracle Database Gateway for Sybase) I get this:
SQL> SELECT * FROM aaa@hvx;
SELECT * FROM aaa@hvx
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

[code]....

When I use db link created via dg4odbc (Oracle Database Gateway for ODBC) and freeTDS driver I get this:

SQL> SELECT * FROM aaa@hvx1;
SELECT * FROM aaa@hvx1
*
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using

[code]....

It seems both drivers use Transact-SQL instructions which are then denied by ASA. I'm not familiar with Sybase products at all, but as far as what my googling revealed the Transact-SQL is only supported in Adaptive Server Enterprise (enterprise-class version of Sybase's database). I couldn't figure out if there's a way how to disable Transact-SQL in the driver configuration. how to connect from Oracle (10g or 11g) to Sybase Adaptive Server Anywhere?

View 3 Replies View Related

Networking And Gateways :: ORA-12154 - Could Not Resolve Connect Identifier Specified

Dec 26, 2008

I have oracle 10g and Developer suite installed locally in my system and I have edited my TNSNAMES.ora file and added a entry for VISLINUX(for both Developer suite and oracle DB TNSNAMES.ora files).

When I use TNSPING comand I get an error for the schemas APPDEV and VISLINUX.

D:Documents and SettingsBAR>tnsping appdev

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:22:57

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:DevSuiteHome_1
etworkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 70.63.134.203)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = APPDEV)))
VISLINUX = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 75.
182.87.181)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = VISLINUX) )
TNS-12533: TNS:illegal ADDRESS parameters

D:Documents and SettingsBAR>tnsping vislinux

TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2 - Production on 25-DEC-2
008 20:23:21

Copyright (c) 1997, 2003, Oracle. All rights reserved.

Used parameter files:
C:DevSuiteHome_1
etworkadminsqlnet.ora

TNS-03505: Failed to resolve name

and when I use TOAD to connect the schema's I get the following error ORA-12154:TNS:could not resolve the connect identifier specified

Here are the contents of my TNSNAMES.ora file

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = anvesh)(PORT = 1521))
(CONNECT_DATA =

[Code]....

View 4 Replies View Related

Networking And Gateways :: How To Connect To Database When LAN / USB Datacard Connection

May 12, 2011

when i am connecting to my database in command prompt,sql * plus editor is it successfully connecting to the database but not connecting with the oracle client OEM.

but after connecting the LAN it is not connecting and also in the case when i am connecting to the internet through the USB datacard it is not connecting with the oracle client OEM.

how can i connect to database when the LAN,USB datacard connection.

View 1 Replies View Related

Networking And Gateways :: ORA-12154 / Could Not Resolve Connect Identifier Specified

Mar 17, 2011

What works: There is a oracle database on the local network. I'm connecting to it through my web server on my pc (apache/php). I have installed "oracle_instantclient10". It works fine - i can connect to oracle db, queries are executed fine.

What doesnt work: I'm trieing to connect to the same oracle db from a Linux server, but i get the error:

ORA-12154: TNS:could not resolve the connect identifier specified

My linux server can connect to remote oracle db, because "nmap ORACLE_DB_MACHINE_IP -PN", gives me answer "1521/tcp open oracle". I have the same firewall allowance with my winXp pc.

I use the same "TNSNAMES.ORA" and "SQLNET.ORA" files on both: linux server, winXp pc. The only difference between winXp and linux machines is that winXp uses oracle instant client version 10.2, and linux uses version 11.2.

View 16 Replies View Related

Networking And Gateways :: Client Machines Unable To Connect DB?

Sep 2, 2011

Database is up and running and client machines able to do TNSPING; But when users try to connect the database thro SQL DEVELOPER, they are getting below information:

your database connection has been reset. Any pending transactions or session state has been lost.in the database server, SQLNET.ORA reads as below:

> more sqlnet.ora
AUTOMATIC_IPC = ON
names.directory_path = (TNSNAMES,EZCONNECT)
names.default_domain = world
name.default_zone = world
sqlnet.expire_time = 15sqlnet expire time shows 15 min.

normally this error willbe suppressed if user tried after some time. But now we get this error for more than 2 hrs.

View 1 Replies View Related

Networking And Gateways :: Client Connect Directly To Instance Rather Than During TNS?

Jun 20, 2010

1) I put attention that TNS write events into its log in too big frequency: ~ 10 time in second. I see that it is for every connection, but I assume that this no too good to performance.Is there some way to tell to TNS not to write event for every connection but only for errors?

2) May I to remove alert.log of DB? Or DB will make me problems with this?

3) How can I tell to my client connect directly to my instance rather than during TNS?

I have Oracle RAC 11g running on Red Hat 4 64 bit.

View 4 Replies View Related

Networking And Gateways :: How Connect-time Failover Is Setup

Mar 5, 2010

How connect-time failover is setup.

I am following lab instruction from my Oracle Admin Workshop book. The exercise is to create a 2nd listener to support connect-time failover. I have two listeners up and running. I connected the second listener using Static Database Registration in OEM, and then I started it.

When I looked in the listener.ora file, I was expecting to find the entries for FAILOVER=TRUE but it is not there. Both listeners are designed to connect to the same instance 'orcl'.

My questions:

1) Is the FAILOVER entry supposed to be done automatically when the second listener is created ? or is it always a manual entry ?
2) How can I test that it is working ?

View 7 Replies View Related

Networking And Gateways :: ORA-12154 TNS - Could Not Resolve Connect Identifier Specified

Mar 7, 2011

While connecting to oracle database, i'm getting

SQL> conn red_user/red@orcl
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Warning: You are no longer connected to ORACLE.

View 6 Replies View Related

Networking And Gateways :: ORA-12514 - TNS - Listener Does Not Currently Know Of Service Requested In Connect

Jan 25, 2010

im getting error ORA-12514.our prod db runs under default listener.nw i have configured another listener.if i try to connect from the loacl im grtting above error,bt im able to tnsping from the local system.

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved