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