Networking And Gateways :: Frequent Disconnection Between Client And Database?

Mar 12, 2010

We are using Oracle 10g on linux 64 bit, client is on XP, using Oracle sql developer to connect to database through vpn, we have only allowed access to 1521 port of database

Client is frequently disconnecting

Initially client connected, then start disconnecting after 20 minutes.

Client side sqlnet.ora has following entry
SQLNET.AUTHENTICATION_SERVICES = (NTS)

Client side Tnsnames.ora has following entry

dd12 =
(DESCRIPTION =
(ADDRESS_LIST =

[Code]....

Following entry in Listener.ora

# listener.ora Network Configuration File: /home/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

[Code].....

No error in listener.log in database.

Receive following error in sqlnet.log in database

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for Linux: Version 10.2.0.3.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.3.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.3.0 - Production
Time: 11-MAR-2010 16:25:16
Tracing not turned on.
Tns error struct:
ns main err 12535
TNS-12535: TNS:operation timed out
ns secondary err 12560
nt main err 505
TNS-00505: Operation timed out
nt secondary err 110
nt OS err 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.14.0.31)(PORT=3934))

View 9 Replies


ADVERTISEMENT

Networking And Gateways :: Oracle 10g Client Not Getting Connected To Database

Jun 28, 2006

I am facing difficulty in connecting Oracle 10g client to Oracle 10g database. Both the machines are in windows xp with service pack-2. The following observations are made in server machine

1. The loopback test of the server is successful.
2. One net service name created in the server end.
3. Database connection is successful with above service name.
4. tnsping <server ip address> is successful

The tnsnames.ora file of the server is

# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0db_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

CONTRACT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.0.28.42)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cam)
[code]........

the sqlnet.ora file of the server is

sqlnet.ora Network Configuration File: C:oracleproduct10.2.0db_1NETWORKADMINsqlnet.ora
# Generated by Oracle configuration tools.

# 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)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SQLNET.INBOUND_CONNECT_TIMEOUT = 30

The listner.ora file of the server is

listener.ora Network Configuration File: C:oracleproduct10.2.0db_1NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.0.28.42)(PORT = 1521))
)

When I am connecting the 10g database with 10g client I am getting ORA-12170 error.

Attempting to connect using userid: nss
The test did not succeed.
ORA-12170: TNS:Connect timeout occurred

There may be an error in the fields entered,or the server may not be ready for a connection. How to configure this connectivity.

The client side tnsnames.ora file is as given below

# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0client_1NETWORKADMIN nsnames.ora
# Generated by Oracle configuration tools.

CONTRACT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 80.0.28.42)(PORT = 1521))
)
[code]......

The sqlnet.ora file of the client side is

sqlnet.ora Network Configuration File: C:oracleproduct10.2.0client_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.

# 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)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

View 13 Replies View Related

Networking And Gateways :: Client And Database Server On Same Machine?

Mar 26, 2013

I have client and database on same machine, when I will connect to the instance , it will use IPC, suppose If I will use connection string then which process will handle this request?

View 2 Replies View Related

Networking And Gateways :: Database Connection From Server To Client

Jul 15, 2010

I have one query related to database connection from server to client.I have one database in the server and I want to connect from client.I set the tnsnames in client system as follows.

BAM240T_EARTH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 10.154.119.103)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = BAM_240T.ipdc.com)
)
)

The database name is : BAM_240T.ipdc.com

Sqlnet.ora entry is

NAMES.DIRECTORY_PATH= (TNSNAMES)
NAMES.DEFAULT_DOMAIN= ipdc.com

When I connect to server I m getting the following error.

$ tnsping BA240T_EARTH

TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 15-JUL-2010 15:45:35

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

Used parameter files:
/opt/oracle/product/10.2.0/db/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

View 16 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 :: Connecting A Client To Oracle?

Aug 15, 2010

Im trying to connect a benchmarking application (benchmark factory) from my windows 32bit laptop to Oracle on my linux desktop.

When connecting I am supplying the following details: (im getting the error: ORA 12170 : TNS connect timeout occurred)

User/Schema : matt
Password: ****
Host: 192.168.1.9
Port: 1521
SID: orcl
Connect as : SysDBA
Connect Using: Instant Client (selected from a drop down)
----------------------------------------------------

when i use the following command:

tail -100 /home/matt/app/matt/diag/tnslsnr/localhost/listener/alert/log.xml

i get these results:

[matt@localhost ~]$ tail -100 /home/matt/app/matt/diag/tnslsnr/localhost/listener/alert/log.xml
host_addr='127.0.0.1'>
<txt>15-AUG-2010 23:26:29 * service_update * orcl * 0
</txt>
</msg>
<msg time='2010-08-15T23:26:36.708+01:00' org_id='oracle' comp_id='tnslsnr'

[code]....

I have been told client is not getting to the listener because listener is only listening on 127.0.0.1.

unless & until DB server is configured with a routable IP#, no remote client will succeed.

View 7 Replies View Related

Networking And Gateways :: Connecting 32 Bit Client On 64 Bit Server

Feb 15, 2011

I am having difficulty in making the 32 bit Oracle client connection to an existing 64 bit DB. The 64 bit SQL*Plus will connect just fine, but when trying to configure the 32 bit client I can never get a successful TEST of the connection. It always returns "No TNS Listener". I have tried several things, but may be way off base. To name a couple ...

1) Stopped the 64 bit listener so my 32 bit listener can use Port 1521 ... no success
2) Tried naming the 32 bit listener to LISTENER32 to not conflict with the original LISTENER name ... no success

If there is a documented way to make this work, I would surely like to be pointed to the "how to" of this item. I need this as a commercial application I have that connects to the DB requires the 32 bit client.

View 1 Replies View Related

Networking And Gateways :: Client To Server Connection?

May 11, 2010

When i connect from client to server the client looks up for the host address and port number in tnsnames.ora and connect to it via listener.ora in server.Where does pga and sga come into picture here?

Also what is the role of sqlnet.ora in client?What will happen if i specify a different port for the instance in tnsnames.ora and listener.ora?

View 4 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 :: Listener Could Not Hand Off Client Connection

Nov 25, 2010

TNS-12518: TNS:listener could not hand off client connection
TNS-12571: TNS:packet writer failure
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Linux Error: 104: Connection reset by peer

View 1 Replies View Related

Networking And Gateways :: TNS 12537 - Connection Closed On Client Side

Jan 12, 2011

I am getting below error while tnsping from client

C:Program FilesMicrosoft Visual Studio 9.0VC>tnsping xpcdev

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 12-JAN-2011 21:35:03

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.102)(PORT = 1524))) (C
xpcdev)))
TNS-12537: TNS:connection closed

on server side listener is up also I am able to tnsping without any error.

contents from sqlnet.ora

Quote:NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10i

I am getting below error on listener log file

Quote:12-JAN-2011 10:04:56 * 12546
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied

View 9 Replies View Related

Networking And Gateways :: Database Link From 11g To 10g?

Jul 5, 2012

I am trying to create a database link from the 11g database to the 10g database using:

create database link ORCL10R2 connect to <username10g> identified by <password10g> using <db10g>;

It Returns

Database link created.

select sysdate from dual@ORCL10R2 returns error:
ERROR at line 1:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

what changes I need to make to tnsnames and listener at both servers.

View 8 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 :: How Many Listener Supported In One Database

May 30, 2010

How many listener we can have in one database? How many users can be support by one listener?

View 3 Replies View Related

Networking And Gateways :: Controlling Database Access?

Nov 22, 2010

i want to restrict particular ips ,for that i specified

TCP.VALIDNODE_CHECKING= YES
AND
TCP.INVITED_NODES=(IPADDRESS)

in sqlnet.ora file but whenever i connect to database from the particular specified IPADDRESS , the database allows the connection to happen ( doesnot restrict it),

View 1 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 :: Connecting To Database Outside Network?

Feb 14, 2011

i want to connect to a database that is out side my network and my application is running on forms 6i and database version is 10g .

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 :: Database Link Is Not Working

Feb 15, 2010

Database version:10.2.0.3
Operating System:Microsoft Windows XP

I have two database TEST and TEST2 on same windows machine. In TEST database i have created one database link that access one schema in other TEST2 database. but when i passed select command to access object in TEST2 through Database link it is hanging indefinitely.

command that i have used to create Database link: create database link scott connect to scott identified by tiger using 'TEST2'

This is sqlnet.ora Entry:

SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
TNSNAMES.ORA entry:
TEST2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SSIPL-LAPTP-052)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
[code]....

View 3 Replies View Related

Networking And Gateways :: Create A Database Link?

Mar 11, 2010

I am trying to create a database link using this syntax:


CREATE PUBLIC DATABASE LINK remote
USING 'remote';

where 'remote' is the service name. It creates it successfully giving the message "External database Created"

Note: I am doing using TOAD

But when i am trying to query something like

select * from scott.employee@remote

it gives an error:
ORA-12154: TNS:could not resolve the connect identifier specified

But the 'remote' db entry exists in the tnsnames.

View 14 Replies View Related

Networking And Gateways :: Connecting Developer 6.0 To 10G Database

Mar 19, 2010

Can currently connect to a 9.2.0.1 database using Oracle Developer 6.0 with the following connect string:

C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@GMS3B.TEST.COM[/email]

I don't believe it is using the TNSNAMES.ora entry for this, because when I take it out of there it still connects. I create a 10.1.0.5 database and copied the tables,etc to there. But I'm having problem connecting, getting "ORA-12154:TNS Could not resolve service name". Tried the following:

C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST[/email]
C:orantBINifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST.TEST.COM[/email]

I did add the entry for the 10G database to TNSNAMES.ora:

NJZTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = njzainettest.test.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = njztest)
)
)

I new to this, but my guess is the other entry had the full path name..and this SERVICE_NAME does not. But then again I don't believe it looks at the TNSNAMES file. This NJZTEST is the 2nd instance on the NJZAINETTEST machine.

View 6 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 :: Database Link Not Working Between Oracle 9i And 11g

May 20, 2011

I'm trying to connect Oracle 11g database from Oracle 9i database, by creating dblink on Oracle 9i database. But my session got hang while i perform this. Here i'm giving the steps i followed on my both the database. Here Oracle 9i database is my source db and Oracle 11g is my target db.

Following steps/setting on Oralce 11g Database

SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE

SQL> alter user SSA identified by SSA;

User altered.

Password File recreted on Oracle 11g Database Server

[oracle1@dev11g dbs]$ orapwd file=/backup/ora11gsoft/odb/OH1/dbs/orapwwbdata
ignorecase=n password=dev entries=5

Following steps performed on Oralce 9i Database

DROP DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM";
CREATE DATABASE LINK "SSA11G.SSA_DB1.WBTEA.COM"
CONNECT TO SSA
IDENTIFIED BY SSA
USING 'DEVDATA.DEV11G';

Database link created.

SELECT * FROM SSA.SSMASTER@SSA11G;

And the hangs for ever.

View 4 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 :: Database Link Failing With ORA-28500?

Mar 3, 2011

Attempting to create Database Link which talks to SQL Server 2008R2 system

Database: 11.1.0.7 Oracle Standard Edition
Server: Windows Server Enterprise, Service Pack 2 (2008)

I do not have the Oracle Gateway product installed, as this was not configured on my working 10G system.

I tried configuring the link with both the SQL Server ODBC Driver (GMSRES) and the SQL Server Native Client 10.0 (GMSGAS). Returning errors when SQL command is executed.

Everything tests out fine (tnsping, listener configured OK, test connect in Database Link setup). When SQL statement is executed it fails.

Setup:

1. Created ODBC Driver (GMSRES). This tested successfull.
Created SQL Native Driver (GMSGAS). This tested successfull.

2. Created initiGMSRES.ora file C:Oracleproduct11.1.0db_1hsadmin folder.

HS_FDS_CONNECT_INFO = GMSGAS
HS_FDS_TRACE_LEVEL = OFF
HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P15
HS_FDS_CONNECT_INFO = GMSRES
HS_FDS_TRACE_LEVEL = OFF
HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P15

3. Created listener.ora entry:

LISTENERGMS =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=WALL-ALIGN-01.testsystem.com)(PORT=1522))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

[code]....

View 2 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 :: Objects Referring To Database Links

Jul 21, 2011

how to find out what are all the objects referring to particular database links in database?

View 6 Replies View Related

Networking And Gateways :: Find List Of Database Links?

Jul 2, 2011

There is a user account called 'BALA' in my database.I want to find out the database links that uses this 'BALA' account.

View 2 Replies View Related







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