ODP.NET :: Application UnhandledException Not Caught When Using Oracle-connection

Oct 18, 2012

i have a Windows Forms .Net 2.0 App which defines AppDomain.CurrentDomain.UnhandledException handler.When an app thread throws an exception this exception is caught or handled by this method.

The problem is that if i define an OracleConnection, open and close it and then the thread throws the exception this is not handled and app finishes...

Why i can't handled this threads exceptions if i use OracleConnection?

Here is the simple app code example:

program.cs
[STAThread]
static void Main()
{
AppDomain.CurrentDomain.UnhandledException += CurrentDomain_UnhandledException;
Application.ThreadException += Application_ThreadException;
Application.SetUnhandledExceptionMode(UnhandledExceptionMode.ThrowException);

[code].....

View 0 Replies


ADVERTISEMENT

OLE DB :: Establish Connection To Oracle With Application In Win 7?

Jan 11, 2013

I have an application in VB6 that connects to an Oracle Database 10g with Oracle native ole db but win7 can not make the connection with a standard user, only makes the connection to a user with administrator permissions. The error that shows the application's rubbish eg @, H, etc.. only rare characters.

View 7 Replies View Related

Server Administration :: Transaction Recovery - Lock Conflict Caught And Ignored?

Apr 20, 2011

I am facing following message with alertlog file. It appearing much frequently and filling alertlog file.

Transaction recovery: lock conflict caught and ignored

View 2 Replies View Related

SQL & PL/SQL :: Time Calculation - Make Varchar To Timestamps But Caught With Round Up / Down?

Apr 12, 2011

calculating values of A & B

(both these fields a_std and a_time are coming as varchar from the parent table in a cursor.(basically they are time period and actual arrival time respectively)

i was juggling with the attempt to make varchar to timestamp or date..but caught with Round up /Round down)

Formula ->

A = Round down [A_TIME - A_STD]
B = Round up [A_TIME) - 10 minute + A_STD]

where

A_TIME VARCHAR2(8) N Time (Format" HH:MM AM/PM") eg "3:50 PM"
A_STD VARCHAR2(5) N Standard time (Format" HH:MM") eg "1:00"

Allowed values for A & B after round up/down = multiple of 10 ( 11:00,11:10,11:20 etc.)

View 10 Replies View Related

Application Net Connection Is Taking 30 To 40 Minutes

Jul 20, 2012

In one of my application oracle net connection is taking 30 to 40 ms(tnsping servicename),but in actual connection is always taking more than 45 ms, and my application requirement is below than 10 to 20 ms.

And can i use any other connection method like hostname, ezconnect etc.

View 7 Replies View Related

Java Application - Connection Reset During Insert

Jun 6, 2012

I have a java application (jdk 6) that use a db oracle 11g with ojdbc6.jar version 11.2.0.1.0 on linux.

Sometimes (one or two cases on 11k sql insert on table in one day) I obtain, the error:

java.sql.SQLRecoverableException I/O Error: Connection reset
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:866)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1259)
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1469)
oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.ja
va:389)
...

View 1 Replies View Related

Application Express :: Install A Development-environment / No Connection From Client

Feb 28, 2013

i'm trying to install a development-environment. The production- and testing-environmens are working, but i have problems with the development.

I installed Oracle 10g XE 10.2.0.1.0 and Apex 4.1.1.00.23 on my Oracle VM Virtual Box (Windows 7 Professional 64 bit).

127.0.0.1:8080/apex works from the Virtual Box.

192.168.11.42:8080/apex (the IP in my network) and 192.168.11.42:8080 work either from the Virtual Box.

But it doesn't work from other clients in my network. So far i tried exec dbms_xdb.setlistenerlocalaccess(false).

View 2 Replies View Related

SQL & PL/SQL :: Oracle Connection On XP

Dec 25, 2010

I have installed ORACLE 11g on RHEL-4, where the RHEL is installed on VM.ORACLE is working fine on RHEL but i am not able to connect oracle on my XP.

View 1 Replies View Related

Connection To Oracle 11GR2

Jul 15, 2013

How to connect to database with windows authentication:

OS system: 2008 R2 windows
oracle : 11.2.0.3

sqlnet.ora set to NTS.

also user is created on database externally "domain/username"

i want to connect to the database with my windows account!

View 4 Replies View Related

Oracle Connection Manager

Apr 30, 2013

I've a problem with Oracle Connection Manager and I've read the Oracle topic about it at URL.....but it doesn't work well...This is an image describes the diagram I want to configure URL.....

The IP for each machine is
Database Server : 192.168.0.150
Proxy Server : 192.168.0.153
client : 192.168.0.159

And these are the files for each machine.

1.Proxy server has 1 file

cman.ora
CMAN=
(CONFIGURATION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.153)(PORT=1521))
(RULE_LIST=
[code]....

2.Database server has 3 file, and for each one I've added some lines as following

tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
[code].....

3.Finally the client has 2 files

tnsnames.ora
orcl=
(DESCRIPTION=
(SOURCE_ROUTE=YES)
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.153)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.150)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl))
[code]....

ORA-12154: could not resolve the connect identifier specified: where I actually define my DB service (orcl) in the tnsname.ora...The output is showen here URL.....

View 1 Replies View Related

ODP.NET :: Oracle Connection From Pool?

Jun 22, 2012

How do i test if a OracleConnection came from the pool or was created for the first time?

View 2 Replies View Related

Forms :: Connection Between 6i And Oracle Database 11g

Jun 8, 2011

I´m just having a problem whit the connection between Oracle Forms 6i and Oracle Database 11G. Is just when i login to the database schema i cant log in using Forms.

TNS Names its already configured, No problems when i log in using Toad and using the TNS Names from Developer's 6i tool. I can log in just when i change the schema(user) password from the database (thats the rarest thing) and log into the application.

So whenever i want to login to the application i must to change the schema password, i need to use it directly.

View 2 Replies View Related

Windows :: Error Regarding Oracle Connection?

May 20, 2013

error regarding oracle connection

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oradb As String = "Data Source=CallTaxi; UserName = SCOTT; Password=TIGER ;"
Dim conn As New OracleConnection(oradb)
conn.Open()
Dim cmd As New OracleCommand

[code]...

Error msg:
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception.

View 1 Replies View Related

Forms :: Oracle 10g And Database Connection

Aug 8, 2011

Toady i have installed oracle forms 10g and oracle 10g db when i run my form it gives me this error how can i resolve it

"ora-12154 tns could not resolve the connect identifier specified"

View the image below:

Here are the values in forms 10g tns

# tnsnames.ora Network Configuration File: C:DevSuiteHome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
[code].......

and here the values of forms 10g SQLnet

# sqlnet.ora Network Configuration File: C:DevSuiteHome_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
(description =
# (address=(protocol=tcp)(host=localhost)(port=1383))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(connect_data=(rpc=on))
)

What changes should i make to overcome this problem.

View 1 Replies View Related

Long And Short Connection In Oracle?

Feb 6, 2013

what's long connection and short connection in Oracle ?

View 4 Replies View Related

Windows :: Oracle Connection Not Working?

Jun 23, 2012

I'm having great difficulty connecting to two separate databases on my PC. Here are the details.

c:>echo %TNS_ADMIN%
C:TNS_ADMIN
#C:TNS_ADMIN nsnames.ora
XE =
(DESCRIPTION =

[code]...

View 22 Replies View Related

Utl-tcp Connection - Oracle Generic Network Error?

Aug 26, 2010

I have a client program that needs to communicate with another server program. My client program is implemented in PL/SQL using utl_tcp running on Oracle 9 while the server program is a 3rd party software running on Windows server 2003.

Basically my client program needs to send a request to the server, waits for the response (wait for the incoming string which ended /w chr(3) ) and then acknowledge (sending chr(6) ).

My problem is that if I wait for the chr(3) and then acknowledge. My send routine (l_sent := utl_tcp.write_text (g_conn, p_content) will raise a Oracle generic network error. It seems like the connection is closed. I checked /w the vendor and they said it might be I am taking too long to response ( I question timeout is the problem). I have also attempted to change my read routine from read_line to read_raw but it only make things worst. I cannot even read the complete string. At least with read_line, I can read back the entire string.

My current work around is to send out the ack before I receive the chr(3) (which is not recommended by our vendor).

View 5 Replies View Related

Client Tools :: Oracle Connection To SQL Server

Mar 2, 2011

I am using dg4msql to connect to SQL server from Oracle(10.2.0.4, with AIX 5.3).

#from my laptop sqlplus (10.2.0.2)

SQL>select count(*) from table1@mssql; #works
SQL>select * from table1@mssql; #ERROR

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]String data, right truncation
{01004}[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}

#from my laptop, TOAD
Both queries works fine.

i have compared

"select * from nls_session_parameters;" values , TOAD and sqlpus gives same result.

View 3 Replies View Related

Precompilers, OCI & OCCI :: Oracle Connection Not Getting Closed

Apr 26, 2010

I have Multi-threaded application using pro*c to connect to oracle.

I am using the following piece of code to create a connection to oracle database and preserver the context of created connection.

struct sqlca * tempSqlca = new sqlca;
struct sqlca & sqlca = * tempSqlca;
EXEC SQL BEGIN DECLARE SECTION;
SQL_CONTEXT localContext;

[code].....

I am using the following piece of code to close the connection to the oracle database, I am using the context created in the previous step and passing it to the below code(connection.context)to release the connection.

if (connection.context == 0 || connection.ca == 0)
return true;
// Multithreading: get the communication area of the context
struct sqlca & sqlca = *(connection.ca);
EXEC SQL BEGIN DECLARE SECTION;

[code].....

When the above code is executed there is no exception thrown but the connection is not getting close. I am using the V$SESSION system views to monitor the connection created.

I there anything I am missing in my code for the connection closing to fail.

View 1 Replies View Related

Client Tools :: Oracle SQL Developer Connection

Feb 1, 2011

I have installed Oracle 11g R1 and have problem in connecting Oracle SQL Developer.

I have given user name: ora; pswd: ora.

In command prompt it works fine if I gave as below.
uid: ora as sysdba
pswd: ora

But when I am trying to connect to Oracle SQL Developer it says TNS listener does not know SID.

So I reinstalled this since i have doubt on myself whether I made mistake first time. Also I have doubt whether the un installation completely clears all the files from Registry. - What should I do to clear all the files from registry when un-installing.

1] What is SID. Is it session ID. If so how to find it.
2] Is there any way to confirm the values such HOST NAME: localhost, PORT: 1521, SID: (By default it has 'xe') which I gave for data base connection are correct.

I tried with SID value:135 (I got this value by executing [Select distinct sid from V$mystat;])

3] Is there any editor for practicing sql & pl sql queries. where I can download it.

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

Security :: Windows Authentication And Connection In Oracle?

Jul 15, 2013

I have been using oracle based database security but company now wants to handle with windows authentication.I have windows os 2008 R2 and oracle 11.2.0.3.

I also have set up the SQLNET.AUTHENTICATION_SERVICES= (NTS).I created user with create user "domainusername" identified Externally! but now how can i connection from application to database!

View 1 Replies View Related

Enterprise Manager :: Connection Of Oracle Server With EM

Apr 5, 2011

I am trying to connect my oracle server with enterprise manager. But i have no network connection. What will be the probable listener config. ?

View 2 Replies View Related

Security :: Creating Oracle Database Connection

Feb 26, 2013

Just installed the new 2.0.8 version. Its been a while I am interested on using PM for our company.The problem I have is creating an Oracle DB connection. When I create a new Oracle DB connection, and test it, Steps 3 and 4 fail.What is strange is that I followed the following procedure in PM 1.9-825 and worked fine. I am wondering if something changed in the new PM 2.0.8 version (I noticed that php_oci8.dll was commented out in php.ini).

Oracle Version is 10GR2
PM installed on clean XP sp3

1. Got a new Windows XP SP3 PC
2. Installed PM 2.0.8
3. Edited php.ini and uncommented [PHP_OCI8] and extension=php_oci8.dll
4. Installed oracle instant client “instantclient-basic-win32-10.2.0.5” in c:oracle
5. Installed oracle instant client “instantclient-sqlplus-win32-10.2.0.4” in c:oracle
6. Added c:oracle in PATH environment variable
7. Created ORACLE_HOME = c:oracle environment variable
8. Added TNS_ADMIN = c: environment variable
9. Copied working tnsnames.ora file into c:
10. Rebooted.
-------------------------------------
1. Tried sqlplus connection to my oracle db and worked.
2. Launched PM
3. Created a new process
4. Created a new DB connection as follows:
a. Engine:Oracle
b. Server:192.168.xxx.xxx
c. Database name: my_name (where my_name appears in tns_names.ora)
d. Username:my_username
e. Password:my_password
[code]....

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

Server Administration :: Database Connection Failure - Oracle Not Available

May 28, 2010

I'm getting the error messaage:

Database Connection failure. Reason: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory

I'm not an Oracle expert, but I have research a little and seems that the SID could be wrong or that the DB is down, in fact I have already checked trhe server but everything seems normal to me.

View 3 Replies View Related

Server Administration :: Oracle Database Connection Error

Mar 5, 2013

While after connecting to server via my userid( its an externally id) ,after setting ORACLE_HOME and SID, while entering sqlplus / command,its not connecting.Error am getting is:-

ERROR:
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
HP-UX Error: 22: Invalid argument

Attaching output session.

View 16 Replies View Related

Client Tools :: Connection From Oracle SQL Developer To MS SQL Server

Jun 8, 2010

I'd like to make a connection from Oracle SQL Developer to a MS SQL Server DB. How can I do that?

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Oracle RAC Private Connection Fail

Feb 7, 2013

I would like to know that when the private network in oracle rac down, which is the preferable node in the cluster (cluster of 2 nodes) to takeover the cluster.

Can I set/get the failover policy to point to one node in the cluster?

View 8 Replies View Related

Connection String To Connect Remote Oracle DB Using IP Address

Jul 23, 2012

I have sample windows C# application to connect remote Oracle DB(Enterprise edition SQ L plus).

Want to connect remotely without installing oracle client on local system.

View 13 Replies View Related







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