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


ADVERTISEMENT

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

Server Administration :: Error / Network Adapter Could Not Establish The Connection

Jan 27, 2010

I have installed oracle 10g XE on my machine. And my machine's ip address is 10.10.50.50.

username:system
password:xxx
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.50.50)(PORT =1521))

[code]....

I was able to connect to the above server from my machine.But when i was trying to connect the above server from my neighbours system i am getting an error Network adapter could not establish the connection.

Note:when i ping the ip address 10.10.50.50 from my negihbours system in the command prompt

Reply from 10.10.50.50:bytes=32
Reply from 10.10.50.50:bytes=32
Reply from 10.10.50.50:bytes=32
Reply from 10.10.50.50:bytes=32

View 10 Replies View Related

SQL & PL/SQL :: Generic Application Error

Jan 10, 2013

In order to display non-english characters properly in Business Objects reports, We have changed the NLS_LANG parameter at BO server level from ENGLISH_UNITED KINGDOM.WE8MSWIN1252 to AMERICAN_AMERICA.AL32UTF8

After this change non-english characters are coming properly but some of our existing reports started giving below error after this change.

A database error occured. The database error test is: (CS) "Error on Fetch: Generic Application exception" (WIS 10901).

View 5 Replies View Related

Network Adapter Could Not Establish The Connection In SQL Developer

Aug 25, 2010

I have installed oracle 11g in my personal laptop, when i open the sql developer and try creating the new connection. am getting "The network adapter could not establish the connection".

View 2 Replies View Related

Enterprise Manager :: Network Adapter Could Not Establish Connection

Feb 25, 2011

I am trying to create a secure connection and getting the following error. I have tested the password via sqlplus and it works just fine.

oracle[/u01/app/oracle] emctl config emkey -repos -sysman_pwd
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.

enter repository password..Invalid Password caught Exception java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

View 2 Replies View Related

Networking And Gateways :: Network Adapter Couldn't Establish Connection

Oct 7, 2011

im failing to connect im this error- status:failure-lo exception:The network adapter could not establish the connection.

View 8 Replies View Related

Export/Import/SQL Loader :: Impdp Network Mode Can Use Bequeath Connection?

Feb 12, 2013

I'm going to import a single database using FS to a RAC on ASM both are in same server running oracle 11.2.0.3. So I was wondering if can I use network link mode of impdp without setting up a listener using 10gb Ethernet interface ?

I don’t want to incur the overhead of the tcp network layer because both DB single and Rac are on the same server.

View 4 Replies View Related

To Write Generic Way Of Oracle 10g PL / SQL Code

Dec 14, 2010

I Would like to delete a records based on the parent / child relationship. So I would need to delete a record from parent table , first delete inner most child record then other child then master. To write generic way of Oracle 10g PL/SQL code.

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

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

ORA-28547 / Connection To Server Failed - Probable Oracle Net Admin Error

Jul 7, 2012

DB 10.2.0.4

After running shut abort it is giving below error while trying to connect sqlplus.

ORA-28547: connection to server failed, probable Oracle Net admin error

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

Networking And Gateways :: Unable To Connect To ORACLE ODA 11g - JDBC Connection Error

Aug 21, 2013

I am not able to connect to ORACLE ODA 11g. but using sqlplus its getting connected with below credential.

URL------------------- jdbc:oracle:thin:sacblmdbuser/sacblmdbuser@10.66.12.229:1521:OVPINHA
Oracle JDBC driver loaded ok.
Unable to create connection
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647296)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

View 2 Replies View Related

Networking And Gateways :: FRM-92102 / A Network Error Has Occurred

Sep 28, 2011

when i try to open a our application i got this error

"FRM-92102: A network error has occurred. The Forms Client has attempted to reestablish its connection to the Server 5 time(s) without success."

View 1 Replies View Related

Server Utilities :: Exclude View In IMPDP Using Network Link Giving Error

Jan 14, 2011

I am using below command to import a schema using network link. Command is :

impdp system directory = IMP_DIR schemas = XYZ network_link = PQR remap_schema = XYZ:XYZ exclude=view: "= 'XYZ.VW_ACCEPTDETAILS'"

This command is giving below error

LRM-00116: syntax error at 'view:' following '='

When I have tried Like in place of '=' sign i.e. EXCLUDE = VIEW:"LIKE '%VW_ACCEPTDETAILS%'" , it gives me below error:

UDI-00014: invalid value for parameter, 'exclude'

View 4 Replies View Related

SQL & PL/SQL :: Select French Characters Generic Entire Schema

Nov 17, 2010

I need to select all names that can possibly have ether accents or french characters what is the easiest way?

View 1 Replies View Related

Networking And Gateways :: Generic Connectivity And Transparent Gateway

Dec 2, 2010

We are planning on interfacing Oracle to SQL server connectivity, I'm researching on how to create a dblink to SQL server 2005. I'm a little confused between Generic connectivity and Transparent Gateways..

I think Transparent Gateway is not free and needs to be licensed, is it better in terms of performance? Also, do I need to configure this gateway on a seperate server?

I think Generic connectivity can be configured on the same Oracle database server itself.. but I see there could be some performance issues with it..

We are running on Oracle 10.2, looks like HSODBC is not available in 10g?

View 2 Replies View Related

Ora-06413 Connection Not Open Error

Jul 13, 2013

I have Oracle 11g XE and Toad installed on Windows 7 64-bit machine. I am able to connect to database from Oracle's SQLPLUS. But when connecting from TOAD i am getting ora-06413 connection not open error.

View 1 Replies View Related

Error Database Connection Closed?

Jan 29, 2013

I am gettting error message databse connection closed itried

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

[code]...

View 10 Replies View Related

Forms :: Java Timeout Connection Error?

Mar 30, 2012

This error keeps on comming in my welogic forms server window many often....can any one tell me why it is so ?

<Error> <oracle.forms.servlet> <FRM-91230> <fatal
error in runtime process: timeout on connection to Java client>

View 2 Replies View Related

Server Utilities :: SQLLDR Connection Error?

Aug 25, 2012

The SQLLDR fails with connection error:

SQLLDR userid=userid/passwd@vpl01 control=OtherType.ctl log=OtherType.log bad=OtherType.bad
SQL*Loader: Release 11.2.0.1.0 - Production on Sat Aug 25 13:32:42 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]

If I provide full connection string, it gives syntax error:

sqlldr userid/passwd@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orasrv)(PORT=1526))(CONNECT_DATA=(SID=vpl01))) control=OtherType.ctl log=OtherType.log bad=OtherType.bad
LRM-00116: Message 116 not found; No message file for product=ORACORE, facility=LRM

[code]...

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

but it doesn't work if supplied following command:sqlplus userid/passwd@vpl01

SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 25 13:32:14 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:

Even tnsping vpl01 gives error:
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 25-AUG-2012 09:14:40
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:

[code]...

View 4 Replies View Related

Oracle Database 11.2.0.3 On RHEL 6.1 - OS Network Configuration

Jul 11, 2012

we are running Oracle database 11.2.0.3 on RHEL 6.1.

Should we join the above machine to an existing Windows 2003 (Active Directory) Domain? or Configure it as a standalone Server?.

View 9 Replies View Related

Oracle Restart / Change Network Interface Name

Oct 18, 2013

Oracle Restart 11.2.0.3 w/ASM. To improve redundancy we're planning to change the network configuration in our Oracle Restart environment from using 1 LAN interface to a bonded interface consisting of 2 interfaces.So the change will be from using "eth0" to using "bond0" consisting of "eth0" and "eth1". Are there any changes that must be done in the Oracle Restart configuration to reflect these changes?

View 7 Replies View Related

TNS-12560 Protocol Adapter Error / Connection Closed

Aug 25, 2010

I'm using Oracle 11. I'm currently having some problem to start my Oracle database after database restore, hence unable to start my SAP application too.

> lsnrctl start
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 25-AUG-2010 23:49:20
Copyright © 1991, 2007, Oracle. All rights reserved.
Starting /oracle/PRD/102_64/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
HPUX Error: 29: Illegal seek

View 3 Replies View Related

Enterprise Manager :: Error / Server Connection Failed

Sep 14, 2013

I have configured OEM and is up and running but, I am getting below error message when open the OEM URL.

Error Message:

Secure Connection Failed / an error occurred during a connection to rhel6:1158.

The page you are trying to view can not be shown because the authenticity of the received data could not be verified.

View 2 Replies View Related

Is Oracle Client Install On Network Location Supported

Nov 29, 2010

I've looked in several places, OTN, Google, various DBA forums to figure out if the way we have a client installed on a network drive is supported by Oracle - short of asking them if it's supported.

The configuration we have is a full 10g R2 client installed on a network drive, and the various environment variables (Oracle_Home, TNS_ADMIN, etc.) point to that network location for use by client machines (I'm also trying to see if the Instant client is supported on a network location as well.) We've had this set up for years which has served us well.

A co-worker remembers years ago that this set up wasn't supported, Oracle 8 or so was his thought as to what version was used then. Another coworker at an Oracle conference asked this same question and was told that it was supported, however we can't find any documentation to that effect.

Now the question arises as to whether or not using a client installed on a networked drive is a supported configuration for 10g R2 or higher, and if so, where it would be documented.

We are in the process of changing network topology and are reviewing whether this configuration is still the right thing for us or if clients should be installed locally to where they are used.

View 2 Replies View Related

Database Access Error - Listener Refused Connection With ORA-12505 - TNS?

Jul 29, 2013

I am using oracle 11g client library on Linux 64bit machine and trying to connect to oracle database using jdbc thin driver.The url format what I am trying to use is:

jdbc:oracle:thin:@IP address:port:service_nameWhen service_name = orcl :

I am able to connect with the above syntax. But when the service_name is having . e.g service_name = orcl.177.39.45, with the above format I get the above error.

 If I change the URL syntax to following, it works

jdbc:oracle:thin:@IP address:port/service_name  

But both seems to be valid syntax.So I would like to undestand the reason behind the same. When service_name is having ".", why ":"  does not work and "/"  works and when the service_name is without " ." , 1st format works. Is there any specific reason behind same? 

View 6 Replies View Related

Client Tools :: Closed Connection Error After Procedure Debug In SQL Developer

Feb 25, 2011

Oracle Database: Oracle 11g Version: 11.1.0.6.0
Tool: Oracle SQL developer. Version : 1.1.3

Problem:
After completing debug of procedure from SQL Developer, whenever I try to compile that procedure or execute any query from the SQL worksheet, I get the closed connection error message. However I can debug that procedure for any number of times. Any other activity for that database connection gives closed connection error.

View 2 Replies View Related

Security :: Network Data Encryption Between Oracle Client And Server On Unix?

Jun 4, 2010

We have an application that fetches and writes data into oracle database through pro c. oracle datyabase is on another server.

We are storing some secure information into oracle database so we want to encrypt the data sent by our aplication into oracle database.We do not want to use SSL(i.e certificates) and also do not want to make use of Advance Security Option available in oracle and also do not want to make any changes in sqlnet.ora file on server side.

achieve encryption of traffic between our application and Oracle database?

View 13 Replies View Related







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