Networking And Gateways :: Accessing MS-ACCESS From Oracle Using Heterogeneous Service Agents

Nov 13, 2011

I have a requirement wherein I need to access the MS ACCESS database table from Oracle Client.I have created ODBC data source and have configured tnsnames.ora and listener.ora for the same. As a next step I am trying to configure HS init file for hsodbc connection but couldn't find the directory hs in $ORACLE_HOME (<ORACLE_HOME>hsadmininit******.ora). Any patch that needs to be applied for hsodbc connection in the server.

View 3 Replies


ADVERTISEMENT

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 :: Connect To SQL Server From Oracle Using Heterogeneous Services?

Mar 11, 2011

I was trying to connect to SQL server from Oracle using Oracle heterogeneous services (HS).But I found that I do not have HS installed on my system. It was mentioned in Oracle website that we need to run 'caths.sql' script under the path $ORACLE_HOME/rdbms/admin.

But I do not have any such folder(rdbms) in my $ORACLE_HOME.What does it mean? And how can I install HS alone on my system(Since I already have oracle)

View 4 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 :: ORACLE Error 12154 Encountered - Could Not Resolve Service Name

May 13, 2013

I have overwritten tnsnames.ora file with newone. In new tnsnames.ora file I have added new host string, remaining all unchanged.

after that, when trying to connect using sqlplus(from windows machine, sqlplusw.exe), working fine. But when trying to connect through putty getting error.

ORA-12154: TNS:could not resolve service name

for the same reason my scheduled cron tab can not run export backup. cron tab error is

EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
EXP-00000: Export terminated unsuccessfully

I am suspecting problem may be due to file accessing permission related issue. But cant solve it. Current tnsnames.ora files permission is

# ls -l admin
total 112
-rw-r--r-- 1 oracle oinstall 14661 Apr 26 2002 libnk59.exp
-rw-r--r-- 1 oracle oinstall 643 Apr 26 2002 libnk59.imp
-rw-r--r-- 1 oracle oinstall 5728 Apr 26 2002 libnrad9.exp

[code]....

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 :: 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 :: What Does Status UNKNOWN Mean For A Service

May 26, 2010

I get this error when I try to connect to this database service as another user. I can connect to it as sys without any problem and the database is up.

And when I check to see whether the listener is running for that service, using lsnrctl status command, it shows that the service is UNKNOWN. What does this status mean?

> sqlplus usera/password@prod
SQL*Plus: Release 9.2.0.5.0 - Production on Tue May 25 14:50:35 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect

descriptor

/home/oracle> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 25-MAY-2010 22:56:22
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xxx)(Port=1521))
STATUS of the LISTENER

[code]....

View 8 Replies View Related

Networking And Gateways :: ORA-12154 / TNS - Could Not Resolve Service Name

Dec 18, 2003

I installed Oracle 9i under W2K with preconfigured DB (SID=ORCL), after that I intalled Oracle developer suite and everything is OK but, When I created second DB (SID=SUMM), I get "ORA-12154: TNS:could not resolve service name" when I tried to connect with :

SQL> connect sys/oracle@summ as sysdba

NB: I have no problem when I use

SQL> connect sys/oracle@orcl as sysdba

Below, are my SQLNET.ORA, TNSNAMES.ORA, LISTENER.ORA files

# SQLNET.ORA Network Configuration File: C:oracleora90networkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

[code]....

View 39 Replies View Related

Networking And Gateways :: ORA-12154 / TNS / Could Not Resolve Service Name

May 15, 2013

What I'm trying to do Establish a remote connection to an Oracle 9i R2 9.2.0.8.0 database using "Oracle Provider for OLEDB 9.2.0.7.0" (I was unable to find an 9.2.0.8.0 equivalent) on a Windows Server 2008 R2 64-bit machine.

My configuration

sqlnet.ora
# SQLNET.ORA Network Configuration File: D:oracleora92
etworkADMINsqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = B81DCS.COM
SQLNET.AUTHENTICATION_SERVICES= (NTS)

[code]....

View 21 Replies View Related

Networking And Gateways :: ORA-12154 - TNS - Could Not Resolve Service Name?

May 14, 2013

My database is oracle 9i when try to connect oracle database using putty to AIX server like..

$ sqlplus

SQL*Plus: Release 9.2.0.8.0 - Production on Wed May 15 09:50:01 2013

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: sys@testdb as sysdba
Enter password: (given password)

(then showing the following Error message)

ERROR:
ORA-12154: TNS:could not resolve service name

But I try to connect using SQLPlus window then it is successfully connected also if i try to connect using command line window like..

C:>sqlplus /

Enter user-name: sys@testdb as sysdba
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
JServer Release 9.2.0.8.0 - Production

SQL> select name from v$database;

NAME
---------
TESTDB

then it is also successfully connected to database..what is the problem .

my TNSLISTENER.ora file is

# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

SINGERDB =
(DESCRIPTION =
(ADDRESS_LIST =

[code]....

View 7 Replies View Related

Networking And Gateways :: ORA-12518 Tns - Listener Does Not Currently Know Of Service?

Jan 31, 2013

ORA-12518 Tns: Listener does not currently know of service

from application server using client 10g to connect our database.This problem happens only in application server and we tried from another server we can connect to database easily but problem only in application server.

this error since TNSNAMES and network are properly hosted since there no network disconnection betwwen database server and application server.

View 1 Replies View Related

Networking And Gateways :: ORA-12154 TNS - Could Not Resolve Service Name?

Dec 24, 2010

My server database is not connected today whenever I try to connect it. It was working properly till yesterday but today morning when I came to office and want to connect with server then my database server show the message "ORA-12154 TNS: could not resolve the service name" and not connected.

View 9 Replies View Related

Networking And Gateways :: ORA-12154 / TNS - Couldn't Resolve Service Name

May 19, 2010

I can able to login to the database through an user A. But when I try login as B,I am getting the follwing error. ORA-12154: TNS:could not resolve service name...I am using the following method.

1. Login to the database server via putty.
2. sqlplus A/****

for the user A,the step2 is working fine. But the same step is failing for the user B.And the user B is trying to connect to the database from the same server as the user A logged in to the database successfully.

db01: sqlplus B/*****
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 19 13:12:52 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name

Enter user-name: I don't know why this error is coming for a particular user only.

View 21 Replies View Related

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

Nov 18, 2012

I am getting the following error.

C:>sqlplus sys/oracle@duptest as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 18 17:58:22 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Enter user-name:

My tnsnames.ora is as follows:

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

DUPTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-LRTU6C15D75.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = duptest.localdomain)
[code]....

The command completed successfully

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

Networking And Gateways :: ORA-12504 / TNS Listener Not Given SERVICE-NAME In CONNECT-DATA

Oct 4, 2011

I am trying to connect to Oracle 11g using ODBC.I created a data source name from Admistrative Tools->ODBC Data Sources.I selected Oracle in OraClient11g_home1 as the driver. I tested the connection and it was succesful.I tried to connect from visual studio. I used the Data Source as Microsoft ODBC Data SOurce. Selected my DSN from drop down (LORAC). I gave the user name and password and got the followign errors:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

This is my tnsnames.ora located in C:oracleproduct11.1.0client_1
etworkadmin directory.
# tnsnames.ora Network Configuration File: C:oracleproduct11.1.0client_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
LORAC =
(DESCRIPTION =

[code]...

When i do tnsping LORAC, i get OK. When I do tnsping of the other service name i get Failed. However when I try to connect to that service from Visual studio I get a differnt set of errors:

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

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

I had assumed that as the test connection from ODBC Administrator had worked I would be able to connec to my database from viusal studio. Is there something wrong in my tnsnames.ora? The content or its directory location?

View 8 Replies View Related

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

Feb 9, 2010

I have oracle 11g on windows xp. I can connect to oracle by SQL Plus without any problem, but when i want to connect to oracle by Toad or SQuirrel i see this error:

PTM Coding: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

my listner.ora and tnsnames.ora come below:

listner.ora:
# listener.ora Network Configuration File: C:appKiarashproduct11.1.0db_1
etworkadminlistener.ora
# Generated by Oracle configuration tools.

[Code].....

View 4 Replies View Related

Networking And Gateways :: TNS Listener Service Won't Start After Changing (Logon As) Setting

Mar 22, 2010

One of our requirements is to secure the listener and other Oracle services by running them as a local OS account rather than as LocalSystem on the server.

I created a local OS account (assume it's named oracleuser), assigned it to the User and ORA_DBA groups on the server, and then I went to the Local Policies and added oracleuser to "Deny log on locally" and "Log on as a service".

I opened up the Services utility and stopped the four Oracle services we have running (OracleMTSRecoveryService, xxx_home1iSQL*Plus, xxx_home1TNSListener, and OracleServiceMYDB). I changed the "Log on as" for each service to oracleuser with its password (copied and pasted so I know there are no typo's), and restarted the services.

All the services except the listener started up. Attempting to start the listener caused the following error:

"The xxx_home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

I tried rebooting the server and had the same result.For now just the listener service has been switched back to logging in as LocalSystem while the other services continue to use the local OS account and the database seems stable, but I do need to figure this out.

View 2 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 :: Which Listener Is Needed To Access ASM Database

Mar 11, 2010

I am have installed oracle 11.2.0 in redhat linux 5.4. I have respectively 2 oracle homes. so total 2 listener files in 2 oracle homes. For accessing one database.Which listener i need to use ? Also if i am going to enterprise manager which listener file. I have to configure.

View 5 Replies View Related

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 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 :: 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







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