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


ADVERTISEMENT

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 :: 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 :: Connection Time Out On Log File Of App Server

Jul 4, 2011

I have a JBOSS aplication server connect to database. When I tested on local, everything was ok. But when i test on real system , have a message "connection time out" on log file of app server while Oracle db still active. I viewed OEM, the system is executing the query :

"SELECT a.path songFilePath, a.BEAT beat from vp_song a, mst_my_album b "+
"where "+
"a.BEAT = b.BEAT "+
"and b.my_album_id IN "+
"(select my_album_id from (select my_album_id, ROW_NUMBER() OVER
(order by my_album_id asc) "+
"R from mst_my_album where msisdn = ?) WHERE R BETWEEN ? and ?)";

But this query is not very hard.

View 4 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 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 :: Using Oracle Connection Manager

Dec 4, 2011

I was trying to connect to a remote database from my client machine. Client machine runs a jsp code to connect to the database and execute a query. I have got oracle jdbc on my machine but still unable to connect to the database.

When checked in Google, i found that oracle connection manager has to be used to connect to the database from jdbc if the web server and database reside on different physical servers. But couldn't gather any further information regarding download and installation.

I do not have oracle connection manager on my system. I read in internet that it is shipped along with oracle 11g software. But i am not sure if that was the case in earlier version as well.

My question is where should i install oracle connection manager? (on database server or client machine) and is it possible to download and install only the connection manager as a stand alone so that i can connect to database from application?

View 3 Replies View Related

Networking And Gateways :: TNS-12537 / Connection Closed

Oct 1, 2013

I am getting the error TNS-12537. In the SQLnet.ora file, if no IP Address is listed everything works fine and the listener starts without any issue. But one of the Security requirements we have is, we need to list all the client IP address on the SQLNet.ora file. I checked the Windows Firewall services and it is disabled.

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
M:>tnsping proditg
TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 01-OCT-
013 10:31:14
Copyright (c) 1997, 2011, Oracle. All rights reserved.

[code].....

View 9 Replies View Related

Networking And Gateways :: ORA-12537 TNS Connection Closed

Mar 19, 2013

I am facing ora - 12537 TNS connection closed issue while I am trying to login into database.I have installed Oracle database 11g on windows 7 premium OS.

View 13 Replies View Related

Networking And Gateways :: Connection Between Oracle And Mssql?

Jul 11, 2013

i have 2 instances (one on Oracle 11g and the otherone Mssql) i was asked to make a link between both.

btw i need excecute a procedure from Oracle against Mssql tables.

View 3 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 :: TNS - Listener Not Given SID - Access To Oracle 10g ODBC Connection?

Aug 25, 2010

ODBC--call failed.TNS:listener was not given the SID in CONNECT_DATA (#12504)

TNSname sets the SID. SQL*Plus is able to connect from the client Windows XP Proff using the same name. Access, on the same client, uses the same Oracle driver to connect successfully to other Oracle databases. These other databases show equal tnsname (different name and SID...)

ODBC Data Source Administrator configures the database and the test connection is successful.

Cannot set up a link from Access to the Oracle database. At some point, I have created a new Access database and it did let me connect, view the list of tables, and set up links to several tables, but the next day I could not open any of the tables and the complain was: ODBC--connection to 'MYDB' failed.

It seems that SQL*Plus passes correctly the SID from the TNSname but ODBC, when invoked from Access, does not. Yet, ODBC does it right for other databases.

View 12 Replies View Related

Networking And Gateways :: Setting Up Connection Between Oracle Developer And Database?

Feb 6, 2011

setup the connection between oracle developer and database.

i found the file called tnsnames.ora however, i cant open it. i dont know if i need to choose a program to open it or download extension for it.

View 12 Replies View Related

Networking And Gateways :: Connection Fail Two Database With Identical Sid Name On Different Hosts

Feb 18, 2013

My production database server is cloned for test environnement . I kept the same name of SID for both environnement but on different hosts.

I got error when try to connect to test database : TNS:protocol adapter error.

Below the the TNSNAMES.ORA files:

----- production host ---

HOFL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asus-sol)(PORT = 1521))

[Code].....

View 10 Replies View Related

Networking And Gateways :: Network Adapter Couldn't Establish Connection

Oct 7, 2011

im failing to connect im this error- status:failure-lo exception:The network adapter could not establish the connection.

View 8 Replies View Related

Networking And Gateways :: ORA-02019 / Connection Description For Remote Database Not Found

Jun 11, 2011

I created database link from bala1 database of bala user with the following command.

CREATE DATABASE LINK maddy CONNECT TO P10 IDENTIFIED BY secret554
USING 'MADDY.WORLD';

my aim is to create a dblink to access 'maddy' database objects from bala1 database.

I gave select * from v$database@MADDY.WORLD in bala user and it throwed error.

ORA-02019: connection description for remote database not found

View 5 Replies View Related

Networking And Gateways :: Unable To Connect To ORACLE ODA 11g - JDBC Connection Error

Aug 21, 2013

I am not able to connect to ORACLE ODA 11g. but using sqlplus its getting connected with below credential.

URL------------------- jdbc:oracle:thin:sacblmdbuser/sacblmdbuser@10.66.12.229:1521:OVPINHA
Oracle JDBC driver loaded ok.
Unable to create connection
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647296)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

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 :: 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 :: 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 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 :: 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 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 :: Two Different Listeners In Same Server

Jan 24, 2005

I´m working with Oracle 9.2.0 / HP-UX and I need to configure two different listeners for the same server using different IP address.

View 12 Replies View Related

Networking And Gateways :: Restart Server And Nothing Changes

Mar 28, 2011

My client get the error Ora-12514 when he tries to connect to the db.Well;

1) we restart the services: "OracleServiceOrcl" and listener but nothing changes
2) We restart the server and nothing changes
3) We checked the dump and he was done on March,26th. No db export yesterday. Is there any link with the clock change of this week-end (location of the server: France)?
4) The lsnrctl services listener command run successfully but it doesn't mention the instance ORCL.

View 12 Replies View Related

Networking And Gateways :: Oracle Gateway For MS SQL Server

Mar 11, 2013

I want to connect ORACLE-11gR2 that is on linux with an MS sql server. DO i need to use some third party drivers like easy soft ? Can i configure the database gateway without any third party drivers ?

Secondly if my oracle is on linux, can i configure the gateway on a seperate windows machine(that will connect to linux oracle and ms sql server) as i have found the gateway installation setup only for windows version.

View 3 Replies View Related

Networking And Gateways :: Listener Could Not Listen Ora 11 XE Server

Mar 10, 2012

I have installed on my local machine the Ora 11 XE server and the client. Its okay. I can logon from the OAS normally.

However, when I try to connect from my Php application, the messages that comes is: 'ORA-12154: TNS:could not resolve service name'.

View 9 Replies View Related

Networking And Gateways :: TRACE LEVEL SERVER Off?

Apr 6, 2012

I am having 11.2.0.1.0 database with windows2k3 OS. For ORA-609 error i have started server side tracing by adding TRACE_LEVEL_SERVER=16,TRACE_LEVEL_DIRECOTRY=D:TRACE,and DIAG_ADR_ENABLED=off in sqlnet.ora file and i reload the listener.

Now i want to stop tracing so i have tried TRACE_LEVEL_SERVER=off but it wouldnot work. After that i remove TRACE_LEVEL_SERVER=16,TRACE_LEVEL_DIRECOTRY=D:TRACE from sqlnet.ora file and reload the listener but trace file generation is going on D:TRACE. stop server side tracing.

View 2 Replies View Related

Networking And Gateways :: Oracle Golden Gate For SQL Server

Mar 11, 2013

Currently we are loading data from oracle to sql server through oracle 11g gateway. during running scripts most of the queries takes a long time to complete. Because of this performance issue, we want to configure oracle golden gate to move data from oracle to sqlserver. whats the difference between oracle gateway & oracle golden gate? both are performing same functionality?

View 1 Replies View Related







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