Networking And Gateways :: How To Set Oracle Gateways 11g For Mssql

Feb 21, 2010

I want connect mssql in oracle by orale Gateways 11g

my environment:
windows Wista
oracle 11.1.0.7.0
Oracle Database Gateways 11.1.0.7.0
SQL SEVER2008

these soft in one computer.

my steps :

1. set initdg4mssql.ora
2.set listener.ora
3. set tnsnames.ora
4.start lsnrctl
5.use SYSTEM/ORACLE@DZCDB

logined. create dblink and test.

but it's error. i want to know where is the error.

View 1 Replies


ADVERTISEMENT

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 :: Unable To Test Dblink Between Oracle XE And MSSQL?

Jul 30, 2013

i have created a dblink between oracle and mssql and tried testing the link its giving me below error.

SQL Error: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified {IM002}
ORA-02063: preceding 2 lines from MSSQL
28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:"
*Cause: The cause is explained in the forwarded message.
*Action: See the non-Oracle system's documentation of the forwarded message.

I have checked the dsn data source i have created, i am able to test the DSN successfully.

View 2 Replies View Related

Networking And Gateways :: MS Access To Oracle DB

Jul 13, 2010

I have an Access DB which I'm using to connect to an Oracle DB at work. There are several Oracle DB's that I can connect to using Access but this one I'm not able to connect to. I get the Oracle error ORA-25153 Temporary Table Space is empty.

I don't have the ability to make changes to the Oracle DB only to read and query.

View 1 Replies View Related

Networking And Gateways :: ISP Concept In Oracle?

May 29, 2012

what is ISP concept in Oracle10g???

View 2 Replies View Related

Networking And Gateways :: Two Oracle Installs 10G And 11G

Jun 6, 2011

We're deploying a new product release however this build uses Oracle 11G. We want to perform a side by side install for testing purposes. These are low usage systems so installing another Oracle build will not hinder the system.

We intend to test for a couple of weeks and migrate data, then uninstall the 10G. I'm in the process of installing 11G now, the 10G is up and running. I don't want to impact the 10G install. I'm installing 11G in /home/oracle/oracle11G directory. I would like to use 1 Listener.ora file. I've broken down the install bellow.

10G
SID "processing"
Oracle home /home/oracle/oracle10g
/mnt/Oracle/Oracle10GData
/mnt/Oracle/OracleRedoLog

11G
SID "processing11G"
Oracle home /home/oracle/oracle11g
/mnt/Oracle/Oracle11GData
/mnt/Oracle/Oracle11GRedoLog

I've copied the listener.ora file bellow.

LISTENER_PROCESSING =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST= X (PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.2)(PORT = 1521))
[code].......

LISTENER_PROCESSING2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = X (PORT = 1522))
[code]......

Do I need to specify the databasename for Processing2? Also the front end boxes (managers) are two different servers so Processingweb1 and processingweb2.

View 1 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 :: Oracle Heterogeneous Services

Mar 13, 2010

I have following file setup for Oracle heterogeneous services for MS Access. I also need to add one more dsn for MS Excel.

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = MyConn
HS_FDS_TRACE_LEVEL = 0

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

Note: MyConn is for MS Access that I cretaed.

Can we use like this

HS_FDS_CONNECT_INFO = MyConn1, MyConn2,etc.

View 3 Replies View Related

Networking And Gateways :: Does Oracle 10.2.0.4.0 Supports Ipv6

Sep 15, 2012

We have Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit on AIX 5.3.Just want to know few things mentioned below

1.Compatibility status of 10.2.4 with ipv6?

2.Next Version supporting IPv6 (in case current version doesn't support).

3.Prerequisites/dependencies for implementation of IPv6 (this may be some specific functionality required from NW, specific OS version etc.)

4.Tasks to be done for the implementation of IPv6.

5.Procedure to change from ipv4 to ipv6.

View 2 Replies View Related

Networking And Gateways :: Port Forwarding In Oracle 10g

Sep 8, 2012

i want to online my oracle 10g database but when i make connection string then i don't know what the port i set. I set default port 1521 but it not work on client site .

View 4 Replies View Related

Networking And Gateways :: Connecting Two ORACLE Servers

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

Networking And Gateways :: Listener For Oracle HS Not Starting?

Mar 16, 2011

I am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.

-----------------------------------------------------------------
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is D:oracleproduct10.2.0db_1
etworkadminlistener.or
a
Log messages written to D:oracleproduct10.2.0db_1

[code]..

Contents of my listener.ora file are below
--------------------------------------------------------------
LISTENERSQLODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=

[code]...

View 1 Replies View Related

Networking And Gateways :: How To Increase Oracle SQL*Net Performance

Nov 25, 2011

One of my MOD_PLSQL based Oracle APEX Application is running on the web. I have almost 1000 web users to access the Application where at least 250-300 users are always on line. In Oracle EM web interface When run ADDM I see suggestions "Investigate the cause of SQL*Net more data to client" or something like this. and I am getting complains about poor server response. Here are my configuration of the system:

Database Server Host: DBServer (Oracle Database 10.2.0.3)
HTTP Server Host: OraHTTP (Oracle Companion CD 10g)

DADS.conf HTTP Server configuration
MOD_PLSQL database access for web clients.

How can I increase database connection performance?

View 6 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 :: 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 :: ORACLE Disconnect Every 5 Mins

Jul 11, 2012

Recently I came across a problem that 'ORACLE Client Side Disconnect every 5mins in app server' these days.

Situation: We have 3 APP servers, which was configured the same OS and ORACLE Client version and 1 DB server. 2 app servers ORACLE Client Side Disconnect every 5mins.but it's ok in another App server.

1. both Oracle SQL PLUS and PLSQL have this problem.
2. SQLNET.EXPIRE_TIME is the same for 3 APP
3. 2 APP server are virtual machine and balance server
3. APP servers : OS: 2003 Server ORACLE 9i
DB server : ORACLE 11g
4. I don't think it's DB server problem because one App server hasn't this problem

View 5 Replies View Related

Networking And Gateways :: Access Remote Oracle DB / VB-10G?

Jul 30, 2012

I'm using Vb and DB Oracle 10G.

What are the steps for connect oracle DB through internet.

View 10 Replies View Related

Networking And Gateways :: Connectivity Between MS-Access And Oracle SQL

Feb 3, 2011

I am currently using Oracle 10.2.0.1 version, in a single PC (test server) and MS-Access (2003) in it.

I was trying to use the logic of HS ODBC connectivity, but when i try to select the table from the MS-Access i am getting the following error.

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

to create the successful connection between the MS-ACCESS and ORACLE. I just need to read some data from MS-ACCESS on a monthly base from a particular table.

View 1 Replies View Related

Networking And Gateways :: Mysql Oracle Integration

Sep 25, 2013

I need to created DB link between oracle (10g on linux) and mysql 5.0 to configure a job to fetch data after every hour. I need solution that does not involve:

ODBC Connection
Oracle GateWay
Golden Gate

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

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 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 :: 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 :: Oracle 9i To Sql Server 2008 R2 Migration?

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

Networking And Gateways :: ERROR ORA-01034 ORACLE Not Available - Not Started?

Jul 30, 2002

ERROR : ORA-01034 ORACLE not avaiable.....

All Services are running (Start)....but Local Database is not opening ?

How i can got my data in Local DATABASE ?

View 39 Replies View Related

Networking And Gateways :: Oracle Net Services Configuration Failed

Jul 10, 2008

when iam running netca on oracle llg iam getting the following error..[wstdba@ora11g ~]$ netca

java.io.FileNotFoundException: /oraeng/app/oracle/product/11.1.0/app/oracle11g/cfgtoollogs/netca/netca_OraDb11g_home1-0802284PM3437.log (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
at oracle.net.ca.NetCA.main(Unknown Source)

Oracle Net Services configuration failed. The exit code is -1...All my services are up and running..

View 2 Replies View Related

Networking And Gateways :: Connecting Two Oracle Database In Different Server?

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

Networking And Gateways :: Where To Download The Oracle Gateway For Sql Server

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

Networking And Gateways :: Configure HSODBC On HP-UX 11.23 For Oracle Database 10g?

May 23, 2011

We want to configure HSODBC on HP-UX 11.23 for Oracle Database 10g R2 in order to establish a DB link from Oracle to Netezza.We have installed the ODBC Drivers too..Currently we have not done any configurations and we go via an AIX box to establish a link.We want to get rid of the AIX box and instead establish directl link towards netezza from HP-UX Box.

Does Oracle support have some guidelines or steps to setup HSODBC on Oracle database 10g r2 residing on HP-UX 11.23 towards Netezza?

View 1 Replies View Related







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