Windows :: Connection From Client To Server?

Apr 21, 2013

I Develop Application with C# . I want to connect from Client to Server.

my connection string is ""Data Source=192.168.100.50:1521/XE;User Id=system;Password=system;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2;""

When exectue this Connection on Server ، all things OK but when execute on Client this error accure :

"Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. The type initializer for 'OracelExperss' threw an exception"

View 1 Replies


ADVERTISEMENT

Client Tools :: TOAD 9.1 - Show Windows By Connection?

Jan 21, 2008

TOAD 8.6.1 has an option of showing windows by connection. It is useful when there are multiple connections and, choosing one of these, all windows that belong to other connections are minimized.

Its icon looks like this:

Does TOAD 9.1 have the same option? I'm unable to locate it in options, toolbar customizations or elsewhere.

TOAD 9.5 Release Notes document says that "'Connection list' dropdown button has been restored and can be added to the Toad toolbar.". If I understand it correctly, it says that previous version didn't have that dropdown button, but 9.5 does.

In another words ... 9.1 might not have it at all.

View 3 Replies View Related

Performance Tuning :: Oracle (HP-UX) Connection Very Slow From Windows Client?

Jun 18, 2012

I have an Oracle database (9.2.0.7) installed on a HP-UX server.When trying to access this database from another HP-UX or Linux server, connection is fine. But when trying to connect from a Windows based client, connection is very slow (almost 1 minute to return the result of a 'select count(*)' like query, which is immediate from the Linux client).

Here are some facts I can add :

- Clients and servers are on the same network segment (it is not a network matter)

- No matter which client version I use, there no difference

- I tried to know what happens on the Oracle server when performing my sample query using tusc command : the result is that the server is performing exactly the same actions when sending my query from a Linux client or a Windows client

- The only relevant difference seems to be the client OS

View 13 Replies View Related

Client Tools :: ORA-06413 - Connection Not Open Error Oracle On 64-bit Windows

Jul 11, 2013

I have newly installed Oracle 11g R2 64 bits to window 8 PRo 64 bits. Able to connection successfully Oracle NEt Configuration Assistant service name.

But when I try to connect it Toad 9.6 32 bits its show error message

ORA-06413: Connection not open

View 5 Replies View Related

Client Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit

Jul 20, 2012

Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?

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

Networking And Gateways :: Client To Server Connection?

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

Networking And Gateways :: Database Connection From Server To Client

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

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

Server Administration :: Database Down - Listener Could Not Hand Off Client Connection

Apr 12, 2013

Unable to connect to database getting below error

sqlplus sys/oracle@server_name/orcl

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 12 11:07:15 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-12518: TNS:listener could not hand off client connection

Below is alertlog entry

Completed: alter database open
Thu Apr 04 17:06:19 2013
db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this

[code]...

View 6 Replies View Related

Oracle Database Server / Client Connection Settings Between Office And Home

Jul 3, 2010

Suppose my oracle database server IP is 128.1.1.100 in the office & the internet static IP is 115.118.33.100 is on that server. I want to retrieve the data by using oracle forms & report from my home's computer having different internet IP 115.118.33.25 on my home's computer.

what would be the settings on my home's computer for the same. i mean tnsname.ora file or any other setting.

View 5 Replies View Related

Windows :: Different Versions Of Oracle Between Server And Client?

Apr 11, 2012

I'd like to know if it's possible to install a client with Windows 7 (64bits) can be installed with Oracle 11gR2 (32 bits) when the server is still with Oracle 10.1.0.2 ?

View 1 Replies View Related

Windows :: Oracle Client On W2K8 Server

Jan 28, 2011

I have installed an application suite (AppX) on Windows 2008 Server which has both Windows applications and a web GUI element (ASP.NET running through IIS 7.5).

The Windows apps are in both VB and .NET and compiled specifically for x86 (due to COM component dependencies). I have installed the "Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4)Enterprise/Standard Edition for Microsoft Windows Vista, Windows Server 2008, Windows 7" Oracle Client on the Windows 2008 Server.

After installation AppX windows modules all worked fine with the Oracle Db but the Web Application was getting the following error:

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

After a bit of research I found a few articles suggesting setting up the ORACLE_HOME directory in the Windows Environment variables. So I tried setting up the ORACLE_HOME environment setting and had some success as the AppX web application worked fine! However, the Windows apps of AppX were now broken and returning the error:

System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
at System.Data.OracleClient.OciEnvironmentHandle..ctor(MODE environmentMode, Boolean unicode)
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
[code].........

So I am struggling to get both the Windows and Web App both working on the same Windows 2008 Server.

View 2 Replies View Related

Windows :: No Connection When Specifying Database Name

Jul 21, 2010

I have an issue with an Oracle 9 database where I can connect if I do not specify a database to connect to but when i do specify one i get an error. For example, my database is called WEB. If i open sqlplus and type connect username/password it will connect fine. If I type connect username/ password @web I get an error.The full error that appears in the log is:

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error

I have checked the tns entries and listener file and both are fine. Here are the entries:
TNSNAMES:

WEB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = web)
)
)
[code]....

View 3 Replies View Related

Windows :: Unable To Install Oracle 10g Client On 64bit Windows 2008

Jul 16, 2008

We have a .NET application on windows server 2008 32bit using the stored procedures on an Oracle 10g environment. We are trying to deploy the .NET application onto a 64bit x86 Windows server 2008.

We face an error trying to install the x64 version of the Oracle 10g client on windows 2008. The error we get is Problem signature:

Problem Event Name: APPCRASH
Application Name: javaw.exe

Is the x64 version of the Oracle 10g client certified for Windows 2008? Has anyone successfully installed the 64bit version of the oracle client on win2008?

We have a workaround in place with 32 bit version of the client running with the 32 bit version of the .NET application on x64 win2008. However to maximize the infrastructure we need to use the 64 bit version or we would have to turn to MSSQL Server .

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

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

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

Client Tools :: 2 Sessions For One Connection?

Oct 30, 2010

why are there in the Administration --> --> Session 2 entries for 1 database connection (here with benthic golden).But if I login in a browser, there is only 1 entry for this database connection

View 3 Replies View Related

Listener Could Not Hand Off Client Connection

Nov 20, 2012

I am having Oracle 11g (Release 11.2.0.2.0) running on Windows Server 2007 SP2. I am trying to connect to this server from my system using SQL Plus command prompt. (Dedicated - redirect (client and server are on different computers)

I am getting an error: TNS-12518: TNS:listener could not hand off client connection.

When I checked the listener log in the server machine, these were the errors:
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 203: Unknown error

tnsname.ora entry in the client side(my system)
BAM = (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = md1svcvwm01)(PORT = 1521))
)
[code]...

From the command prompt, I use sqlplus bamtest10/bamtest10@BAM to connect where in I am getting the errors.

View 4 Replies View Related

Client Tools :: How Can Isqlplus Available For Windows Client

Sep 23, 2010

I have an Oracle server on CentOS 5.4, I can visit isqlplus on server, but I can't visit isqlplus on a windows client. ping works between server and client. I remember client doesn't need to install software via isqlplus, but I am not pretty sure.

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

Client Tools :: Setting Up New Connection - Failure Status

Oct 8, 2011

i tried installing oracle sql developer in my laptop and i have problem in setting up a new connection.. Which server am suppose to connect or what's the host no.: i entered the following:

connection name:sethu
username:sethu
password:sethu
connection type:basic and role:default
hostname:localhost
port:1521
SID:xe
and when i give test...

the error shown is "status:failure-test failure: IO Error: The Network could not establish the connection".

View 6 Replies View Related

Connection To Database From Sqlplus Client Refuse ORA-03135

Sep 23, 2012

I am using oracle 10.2.0.3 in AIX

From client machine , i m not able to connect, it raise error

sqlplus t24/t24@pbldr

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 23 16:21:46 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-03135: connection lost contact

Note : after restart the listener only one time I can able to login to database next time raise above error.

View 3 Replies View Related

Client Tools :: Not Able To Make ORA Connection Through Macro In Excel

Mar 15, 2012

i have windows 7 on machine. When i am trying to connect to oracle client using macros from excel like

OraSession = CreateObject("OracleInProcServer.XOraSession")

its giving me error saying "activex component cant create the object."

View 3 Replies View Related

Networking And Gateways :: Listener Could Not Hand Off Client Connection

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

Client Tools :: Shortcut To Get Select Connection Dialog Box In SQL Developer?

Jul 8, 2011

Is there a shortcut to get the Select Connection Dialog box in SQL Developer?

Every time I need to execute a Query I have to use the mouse to change the Connection, if there is any Shortcut then that would be easier for me to wotk with.

View 8 Replies View Related

Client Tools :: IO Error - The Network Adapter Could Not Establish The Connection

Oct 1, 2012

I am getting the following error when trying to connect from sql developer, I can connect through command prompt and sqlplus to scott schema.

Error :
-------
An error was encountered performing the requested operation.
IO Error : The Network Adapter could not establish the connection

Vendor code 17002

Login details used in sqldeveloper
----------------------------------
Host name : 192.168.2.2
Port : 1521
service name : orcl

View 1 Replies View Related

Client Tools :: How To Set Connection Property Oracle.jdbc.thinLogonCapability

Sep 25, 2013

how to set connection property "oracle.jdbc.thinLogonCapability"

View 3 Replies View Related

ORA-12523 - Listener Couldn't Find Instance Appropriate For Client Connection

Aug 13, 2013

emca -repos create - ran clear
emca -config dbcontrol db - failed with following:

SEVERE: Error Loading TransX:Listener refused the connection with the following error:
ORA-12523, TNS:listener could not find instance appropriate for the client connection

lsnrctl status
*************************************************************************
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
Start Date 13-AUG-2013 15:39:06
Uptime 0 days 0 hr. 26 min. 42 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
[code]....

View 2 Replies View Related







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