ODP.NET :: Exception Occurring When Connecting To 11g Database Using 10g ODAC

Sep 12, 2012

We've got a 32 bit .Net windows application which uses ODAC 10g (1.x) to connect to a 10g database on the backend. Things work fine in this deployment.

We're in the process of setting up a new development machine. This machine has ORACLE 11g (64 bit) installed on it. We're running into issues connecting the the database.

This is the code block we're using to connect to the database:
=======================================
string dataString = "user id=xxx;password="xxx";data source=localhost:1521/ORCL";
using (OracleConnection oraconn = new OracleConnection(dataConn))
{
oraconn.Open();
Oracle.DataAccess.Client.OracleCommand cmd = new OracleCommand(sOraSQL, oraconn);
[code]........

We get an exception on the "oraconn.Open()" command.

The output window in VS2010 shows this:
-----------------------------------------------------------
A first chance exception of type 'Oracle.DataAccess.Client.OracleException' occurred in Oracle.DataAccess.dll

The oraconn variable looks like:
-------------------------------------------
- oraconn {Oracle.DataAccess.Client.OracleConnection} Oracle.DataAccess.Client.OracleConnection
+ base {Oracle.DataAccess.Client.OracleConnection} System.ComponentModel.Component {Oracle.DataAccess.Client.OracleConnection}
ConnectionString "user id=xxxxx;password="xxxxxx";data source=localhost:1521/ORCL" string
ConnectionTimeout 15 int
DataSource "localhost:1521/ORCL" string
[code]........

The details of the exception are:
---------------------------------------------
- ex {""} System.Exception {Oracle.DataAccess.Client.OracleException}
+ [Oracle.DataAccess.Client.OracleException] {""} Oracle.DataAccess.Client.OracleException
+ Data {System.Collections.ListDictionaryInternal} System.Collections.IDictionary {System.Collections.ListDictionaryInternal}
HelpLink null string
[code].........

To reiterate, in our original deployment (10g database with 10g (1.x) ODAC, we can connect fine with the database. It's with the new setup (11g database with 10g(1.x) ODAC) that we are having issues. We've previously been able to deploy on client machines which were using ORACLE 11g. To accomplish this, we had to make sure that the password was inclosed in quotes (").

What is going on here? What should we be looking at? How do we go about debugging fixing this?

View 1 Replies


ADVERTISEMENT

Client Tools :: Connecting Directly To Required Database (not Test Database)

Feb 17, 2012

we have a production database 'X'. Now i have created a test database 'T' and did'nt configured another listener to it! The issue is when i cam connecting to oracle through sqlplus i am directly connecting to Test database 'T' but not the production database 'X'----ofcourse i can login to production DB afterwards. but initially i want to access the production database 'X'.

View 15 Replies View Related

Installation :: Oracle 11g Software And ODAC

Aug 25, 2013

I am starting work in creating database application using oracle with vb.net I install Oracle XE 11g R2 ,  it work very well ,  but i need to connect oracle with vb.net ,  I download '' ODTwithODAC1120320_32bit''  but when I try to install it I get this message ' ODAC for oracle server 11.2.0.3.0 can only be installed over an existing oracle database server 11.2.0.3.0 ' what should I install ?

View 11 Replies View Related

ODP.NET :: Is ODAC Free For Oracle10g User

Aug 6, 2012

My company brought Oracle10g server some years ago. I've noticed that ODAC support Linq and could be used to connect Oracle 10g.

Can we use ODAC 11.2 Release 4 (11.2.0.3.0) with Oracle Developer Tools for Visual Studio for commerical use due we already purchased Oracle 10g server?

View 1 Replies View Related

ORACLE - While Connecting To Database?

Dec 8, 2010

I am building the Oracle on RHEL 5(on Virtual machine with fixed disk space). I could install, after configuring and tried to connect to the database using "sqlplus system" on the command prompt(logged in as root), I get the following error message:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

View 2 Replies View Related

Windows :: Is 64-bit Oracle Data Access Components (ODAC) Possible For 9i

Jan 27, 2013

I want to connect to oracle in windows server2008-64 bit by Microsoft OLE DB provider for oracle..is 64-bit Oracle Data Access Components (ODAC) possible for oracle9i?

View 3 Replies View Related

Sqlplus Error While Connecting To Database?

Mar 13, 2013

after connecting to database using username and password , i get below error message connection is established and able to work asusal,

Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
select 'Welcome to database: ' || name from v$database
*
ERROR at line 1:
ORA-00942: table or view does not exist

View 8 Replies View Related

How To Limit Users From Connecting To Database

Aug 14, 2012

i have a database nd only 10 users must allowed to access db at any point of time and sessions per user must be 1.that is only 10 users must be able to access the database.

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

Heterogeneous Connectivity :: Connecting From 9.2.0.8 Database On AIX To MS SQL 2008R2?

May 30, 2013

We have a requirement to connect from 9.2.0.8 database on AIX to MS SQL 2008R2 .

Source :
----------
Oracle : 9.2.0.8 (64 bit)
OS : AIX - 4.3.3.0/5.3.0.0 (64-bit)

Target :
----------
MS SQL : 2008R2
OS : Windows 2008 (64-bit)

1] Can we use - Database Gateway for SQL Server for the above set up ? If so , does this require a separate license ?

2] Where Do we need to install the "Database Gateway for SQL Server " -- soruce or target server ?

3] Is there any other solution apart from using "Database Gateway for SQL Server " ?

View 1 Replies View Related

Application Express :: Exception Handling Pl Packages And APEX Exception Handler

Oct 7, 2013

APEX 4.2Oracle 11g Database We are using the standard exception handler that was introduced in APEX 4.1, and we have code in packages & procedures in the database (following proper processes of keeping code in the database where possible).  When an exception is found in the procedures/ packages/functions, should the APEX application level exception handler catch any errors that occur or should they be handled in the package/procedure/function they occurred in? Why I ask if, we right now have exception handling code in the pl/code bodies BUT they write their errors to the same table that Apex's Exception handler does, but the errors are NOT presented to the user using the APEX exception handling mechanism.

View 2 Replies View Related

Forms :: Implement Exception Handling In Exception Block Of A Trigger

Oct 10, 2011

I have to implement exception handling in the exception block of a trigger, Quote:exception

when ora_java.java_error then
message( 'Unable to call out to java, ' || ora_java.last_error );
ORA_JAVA.CLEAR_EXCEPTION;

when ORA_JAVA.EXCEPTION_THROWN then
ex := ORA_JAVA.LAST_EXCEPTION;
message( Exception_.toString(ex));
-- lv_exception := Exception_.getMessage(ex);

I get an error for the line: 'message( Exception_.toString(ex));'I have imported the java classes FException et IObject with their methods.

I have to create a Web Service Client, so I wonder if the paragraph Quote:when ORA_JAVA.EXCEPTION_THROWN then ex := ORA_ JAVA. LAST_ EXCEPTION; is mandatory.

View 2 Replies View Related

Data Guard :: Error While Connecting Standby Database

Apr 19, 2011

During data guard configuration i have receive an error while connecting to stanby database from primary database rman prompt.

rman target sys/srk786@orcli
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Apr 19 09:59:26 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCLI (DBID=3754068166)
RMAN> connect auxiliary sys/srk786@stnd
[code]....

View 1 Replies View Related

Forms :: Connecting To Other Database User Inside A Form

Mar 8, 2012

I have a problem concerning change of the connection inside a form. I have this code in when validate item trigger

LOGOUT ;
LOGON ('FIFES_HN','FIFES_HN@PRD_253');
MESSAGE (GET_APPLICATION_PROPERTY(USERNAME));
MESSAGE (GET_APPLICATION_PROPERTY(USERNAME));
MESSAGE (:DAILY_TRX_CONT.ORG_ID);
[code].........

how the last message is 'FIFES_HN' it show be 'SIFESD'

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

Windows / .NET :: Connecting To Oracle Database Using ODBC Driver

Jul 16, 2012

I'm using following connection string: +connectionString="Driver={Oracle ODBC Driver};Server=someDb;Uid=useruidr;Pwd=password"+

when I call method "Open" on "OdbConnection" I get following exception: +ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified+

"someDb" is specified correctly in tsnames.ora,
"...client" and "...clientin" are added to PATH environmental variable
ORACLE_HOME is set to "...client"

I have Oracle Client 11.2.0.3.0 installed
Operating system is Windows 7 32 bit

When I change Driver to "Microsoft ODBC for Oracle" it works fine. However I want to use Oracle ODBC Driver.

View 2 Replies View Related

Server Utilities :: Import Program Without Connecting With Database User

Sep 19, 2011

I want to know if it is possible, to run IMP program without connecting with database user , for example :

imp '/ as sysdba' file=f.dmp fromuer=u1 touser=u2 log=flog.log

that permits to perform scripts without passwords in.

View 8 Replies View Related

Networking And Gateways :: Connecting Oracle To SQL Server Via Database Link?

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

Data Guard :: Broker Connecting To Standby Database Fails?

Jun 4, 2013

I checked lots of pages but I'm not able to find a solution für my problem. I already set up a primary and a standby database (prim = ALPHA1 / standby = ALPHA2). After enabling my dgmgrl configuration I got two errors:

DGM-17016: failed to retrieve status for database "alpha2"
ORA-16664: unable to receive the result from a database

The dg log from ALPHA1 says:

06/04/2013 16:06:57
Site alpha2 returned ORA-16664.
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration alphadgb Warning ORA-16607
Primary Database alpha1 Success ORA-00000
Physical Standby Database alpha2 Error ORA-16664

While the dg log from ALPHA2 (standby) says:

06/04/2013 16:43:28
SPFILE is missing value for property 'LogArchiveFormat' with sid='ALPHA2'
Warning: Property 'LogArchiveFormat' has inconsistent values:METADATA='arch_ALPHA2_%S_%t_%r.arc', SPFILE='(missing)', DATABASE='arch_ALPHA2_%S_%t_%r.arc'
Failed to connect to remote database alpha1. Error is ORA-12514
Failed to send message to site alpha1. Error code is ORA-12514.

How can I solve this issue? Every type of tnsping is successfull. The sqlplus login from the primary to the standby database works, the other way round works too! Therefore the tnsnames and listener data seems to be correct.

My configuration for ALPHA1 (primary db):
---------------------------------------------------------------
Listener
---------------------------------------------------------------
LISTENER_ALPHA1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

[code]....

View 3 Replies View Related

Precompilers, OCI & OCCI :: Connecting To Oracle Database With Instant Client 11.01.06

Mar 19, 2009

connecting to an oracle db with the instant client 11.01.06. I can connect to the db via other tools like sqldbx or SqlTools 1.5 which are also using oci. So now I tried it with c++ using Visual Studio 2005 SP1.

First I tried this

Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
try{
con=env->createConnection("user","pwd","//servername:ip/mydb");
}

and got following error: "the attribute OCI_ATTR_USERNAME is greater than the maximum allowable length of 255".

So I tried:

Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
try{
con=env->createConnection("user","pwd","tnsservice-name");
}

where tnsservice-name is the name I specified in the tnsnams.ora, and which I used with the other tools working fine -> same error.My username is only 4 long, so I thought it might have something to do with the string. So I tried:

Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
string user="user";
string passwd="pwd";
string db="tnsservice-name";
try{
con=env->createConnection(user,passwd,db);
AfxMessageBox("sucess");
}

now it returned the error "TNS:connect descriptor too long". Can't have anything to do with the .ora file, since it worked fine for the other tools. Plus it didn't matter if I renamed the .ora file or removed it from the TNS_ADMIN directory..So I searched a little more for a solution and so an example, where the the last argument is missing. So I tried

string user="user";
string pwd="pwd";
Environment* env=Environment::createEnvironment(Environment::DEFAULT);
Connection* con=NULL;
try{
con=env->createConnection(user,pwd);
}

It returns: "TNS: protocol Adapter error" which I somehow can understand, since the adapter doesn't know to wich db to connect.I also tried to use some frameworks like soci or otl but was never able to compile them... (link errors, unknown data types etc...).

View 1 Replies View Related

Networking And Gateways :: Find Out Users Hostname Who Are Connecting To Database Remotely

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

EMCA Error - Database Unavailable Exception?

Jun 7, 2012

I have installed Oracle 11gR2 on Windows 7 professional. I created a DB and a listener also.No issues there; I can connect to the DB with sqlplus and SQL Developer.when I try to configure dbcontrol on this DB, it fires errors;

--------------------------------------------------------------------------------------------
C:Windowssystem32>emca -config dbcontrol db

STARTED EMCA at Jun 7, 2012 2:20:15 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: ORA112
Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableExcep

[code]...

How this can happen?

View 3 Replies View Related

Mobile Server :: Connecting To Oracle Database Mobile Manager Workspace Using The Browser

Jul 3, 2013

I Have installed the oracle database 11g, the oracle database mobile server and i use Glassfish as the application server. Everything is fine i have tested the mobile server configuration using Oracle mobile server workbench the mobile server runs  but when i want to connect to the mobile manager workspace via the browser using

[URL].......

I have a server error HTTP 404- The requested resource () is not available .

View 6 Replies View Related

Forms :: While Connecting 6i With Oracle 9i Database / Forms Closed Immediately

Oct 4, 2011

when I try to connect my forms 6i with oracle 9i database, forms stop working and closed immediately at the meanwhile tnslsnr also stop working. This problem also persists in forms runtime.

View 6 Replies View Related

Got Ora-12528 While Connecting To Sys As Sysdba?

May 18, 2010

I got ORA-12528 while i was connecting sys as sysdba from remote machine to theinstance which is started in nomount mode. Although tnsping for that instance is working.

View 2 Replies View Related

Getting Error While Connecting To One Node

May 23, 2013

I have recently installed ORACLE 11gr2 rac. After installation i am not able to connect to one node i am getting the below error

<msg time='2013-05-23T10:25:24.660+05:30' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DPDCNSFDB1'
host_addr='172.18.132.51'>
<txt>TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
IBM/AIX RISC System/6000 Error: 32: Broken pipe

My Tns connects to only one node.And i tried to connect using the virtual IP but not able to connect. TNS poing works fine.

View 1 Replies View Related

Connecting Oracle 8 To SQL Server

Dec 5, 2011

I'm trying to make a connection to sql server from an ORACLE 8.0.4 (I know, it's ancient) but can't seem to get it to work. I've read a lot of articles on the internet regarding the Heterogeneous Services but just can't get it to work on my system. Therefor I tried an example on connecting to an Excel workbook I found on another forum [URL] but that gives me the same problem as with connecting to sql server.

Here is what I've got:
initFRUIT.ora
CODEHS_FDS_CONNECT_INFO = SPONGE
HS_FDS_TRACE_LEVEL = OFF
LISTENER.ORA
CODESTARTUP_WAIT_TIME_LISTENER = 0

[code]....

One thing I noticed is that I do not have an hsodbc.exe file in my \bin, should it be there?
(I also tried Tgmsql80 in stead of hsodbc as program in Listener, resulting in an extended time of testing the connectivity but with the same result)

Is there any way I can test parts of the connection to limit the location of the problem? (e.g. does the listener get to the TNS)

View 2 Replies View Related

Connecting To Oracle Table With VB 6.0?

Jul 31, 2004

sample code to connect to Oracle table using VB6.0, as well as code to populate the table and to access a particular record in the table.

Asuming userID is 'MyID' and Password is 'MyPass', Server Database is 'Mydata'.

View 2 Replies View Related

Error While Connecting To RMAN?

Oct 23, 2012

I am trying to connect rman target / from windows

Microsoft Windows [Version 5.2.3790]
� Copyright 1985-2003 Microsoft Corp.
C:\>set ORACLE_SID=PRODDB
C:\>set ORACLE_HOME=C:\oracle\product\10.2.0
C:\>rman target /
Message file RMAN<lang>.msb not found
Verify that ORACLE_HOME is set properly
C:\>sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

View 2 Replies View Related







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