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
ADVERTISEMENT
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
Dec 5, 2011
I have recently installed Oracle Express 10g Server on my local PC. I can successfully connect to this while bypassing the TNSNAMES from SQLTools, I can't however connect to this from Forms 10g or while using SQLTools with TNSNAMES. How do I configure my TNS names to use this server?
View 2 Replies
View Related
Jul 13, 2012
connecting two oracle database in two different server.I installed Oracle 10g XE in both system.Both system act as Server.I need to connect both server using database link concept.
how to use the tnsnames,ora and listener.ora file for connecting both system.
View 39 Replies
View Related
May 24, 2011
Connecting Oracle to SQL Server via database link.
I am trying to connect from Oracle 10G to a SQL Server database. I have looked at the manual and i will admit that i am finding the documentation quite difficult to follow. There seems to be several options to use but none of the documentation describe how each option works.
As an example, i have been given the following information on the database i need to connect to (i.e. the SQL Server database)
- Username
- Password
- Database Name [lets assume the database name is data_extract]
To connect the above i made the following changes
$ORACLE_HOME/hs/admin/inithsodbc.ora
---------------------------------------
HS_FDS_CONNECT_INFO = data_extract
HS_FDS_TRACE_LEVEL = 0
$ORACLE_HOME/network/admin/tnsnames.ora
---------------------------------------
sqlserver.db =
(DESCRIPTION =
[code]....
Note: In listener.ora, i only added the last SID_DESC entry. I then went on and created the database link as shown below
create database link sqlservdb using 'sqlserver.db';
When i try to access a table i get the following error
sqlplus> select * from TESTTABLE@sqlservdb;
select * from TESTTABLE@sqlservdb
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from ORASQLSERVER
A couple of things i am not sure of:
- Where do i specify the username and password to access the sql server from the oracle db to the sql server db
- Having read around on the internet, i can see some people refering to a DSN datasource. I am told that the information that i have is all i need. Is this correct or do i need something else?
- The sid i specified in inithsodbc.ora and tnsnames.ora is actually the sql server database. Is this correct?
View 10 Replies
View Related
Aug 8, 2006
I know how to create a database link between two oracle servers, but problem is that SID is same for both servers, Is there any other way to connect two servers without using only 'SID' ..here are TNSNAMES.ORA FILE i HAVE
D.w=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL = TCP)
(HOST=ff.ffc.pic.com)
(PORT = 1521)
[code].......
Is there any other way rather that this
Create database link a connect to username identified by password using 'SID';
Any alternative like using SID.A.w or how I can differentiate these two SID s.
View -1 Replies
View Related
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
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
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
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
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
Apr 22, 2010
i got to find out the users hostname who are connecting to database through remote,i tried with v$session bt it is showing null values in the terminal column.how to find out ?
View 8 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Apr 2, 2013
We are having oracle 9i as database and migrating to sql server 2008. Our oracle 9i database connects to another oracle databases and these databases are having different oracle version(9.2.0.8.0, 9.2.0.7.0,10.2.0.5.0,11.2.0.2.0,9.2.0.6.0,10.2.0.4.0,8.1.7.4.0 )
I do have two queries :
1) how to connect from Sql server 2008 R2 to different Oracle databases
2) How will other oracle databases connect to Sql server 2008 R2 database
View 2 Replies
View Related
May 1, 2011
I configure exadata + 2 switch between application server and and exadata. And we have problem to connect to switch and load balancing between Ethernet switch to exadata.
We might end up that is 'How about remove ethernet switch and directly connect to exadata?' I don't know which idea comes up with Ethernet gigabit switch between application server and exadata, exadata might be gigabit.
but from application server to ethernet switch is still 100M network, it is only fast in that load, other load is still 100m , it might useless. and about load balancing, exadata is RAC cluster node, exadata is doing load balancing, why we want another load balancing feature of ethernet switch?
Is it good idea to have dual switch between application server and exadata? exadata iti is what might be pro and con of this setting? exadata is handled by oracle support team, but dual switch is only cared by application operation team, so if something wrong with switch, nobody except operation team can manage .
View 1 Replies
View Related
Feb 6, 2012
I've below questions about my raised topic.
1. How would I know whether I'm running Shared Server or Dedicated Server?
2. How to configure Shared Server?
3. How to configure Dedicated Server?
4. How Can I use both these connection types with one database?
I mean one session with dedicated and one with shared at the same time.
View 5 Replies
View Related
Dec 5, 2011
where can i download the oracle gateway for sql server? i can't find the download web site .
View 4 Replies
View Related
