Oracle ORA-03135 on connect

When I am attempting to connect to a remote 9i DB from a UNIX host with a 10.2 UNIX client, I get a ORA-03135 if I uses a particular general users credentials. However is I connect with system account or even another non privileged I can connect without an error. Does anyone have an idea of what is ...

Oracle ORA-03135: connection lost contact Error

My Application access data from Oracle 10g. Applications hangs when update/delete a specific row in a table. After few minutes application terminates with ORA-03135 error. Rest of application works fine which access around 150+ tables.If i connect to My Client database server. This works fine. After ...

Oracle ORA-03135: connection lost contact

I want to make DB link from Oracle 10g R2 DB to Sybase using ODBC (note the platform Windows 2003 server SP1 and both on the same machine named server ), the steps i followed ,1- I defined the ODBC on windows and connected successfully named "odbcloc"2- I created the .ora file under <oracle_home ...

Oracle ORA-03135: connection lost contact (10gR2) on RedHat 3ES

We are having an issue with a new installation of Oracle 10gR2 on a RedHat Enterprise 3ES server. After twenty minutes or so of idle connectivity, we are losing connections to the database with the following error: ORA-03135. So, I looked this up in the Error Messages doc and got this:ORA-03135: con ...

Oracle ORA-03135: connection lost contact

Using Oracle 10g (10.2.0.1.0) on OpenSuse 10.1 in a Microsoft Virtual Pc 2007 beta virtual machine. .Net application using OracleDataAccess (ODP.NET).Doing about 1,000,000 select statements over the space of about an hour to do a process that merges a large amount of data into a large amout of data. ...

Oracle ORA-03135: connection lost contact (Solaris 10 x86)

I installed 10g in Solaris 10 x86, when I try to connect to the database from another machine the terminal frozes and later spawns a ORA-03135 error, it doesn't even enter the db, the tnsping is succesful. I can log in locally in the Solaris server without problem (sqlplus system@orcl). I've checked ...

Oracle ORA-03135: even after adding sqlnet.expire_time = 10 in sqlnet.ora file

i am facing this error of ORA-03135I have also modified my sqlnet.ora with the following entry sqlnet.expire_time = 10,I am working on a remote oracle server, i get this error whenever i compile large Stored Procedure filesKindly help me to resolve the issueThanks in advance ...

Oracle ORA-03135: connection lost contact

Good morning experts.$ sqlplus test/test@db1 SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 6 15:58:31 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-03135: connection lost contact Enter user-name:   $ $ lsnrctl services db1 LSNRCTL for Solaris: Version 10.2.0.1.0 ...

Oracle ORA-03135: connection lost contact

I have a script to load the data using SQL Loader which is running from the application server and fails after inserting some records with the following err:SQL*Loader-643: error executing INSERT statement for table XR.GR_BLOCKORA-03135: connection lost contactSQL*Loader-643: error executing INSERT ...

Oracle ORA-03135 (lost connection) after collector start

After installing either AV 10.2.2.0 or 10.3.0 and associated agent of same version, collectors die. Excerpt from DBAUD_Collector log file:INFO @ '25/07/2008 16:41:37 -5:00': ***** Recovery done OKINFO @ '25/07/2008 16:41:37 -5:00': ***** Initialization done OKINFO @ '25/07/2008 16:41:37 -5:00': **** ...

Oracle ORA-03135?

I am getting following error frequently in my application side.. how to over come thisORA-03135 connection lost contact ...

Oracle ORA-03135 : connection lost contact

My dabase version is 11.1.0.7.0 with RAC , on solaris 5.10.From my local desktop, when i keep my sqlplus connection idle for 2 hrs , i get the error ORA-03135 : connection lost contact.I do not have the sqlnet.ora file either on my local desktop or on my database server. Also the user i a connecting ...

Oracle ORA-03135: connection lost contact

friends!I am facing this problem "ORA-03135: connection lost contact" once a week. I have checked the network status and found no issue on network side. My sqlnet.ora file has these parameters:NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)SQLNET.INBOUND_CONNECT_TIMEOUT = 60INBOUND_CONNECT_TIMEOUT_LISTE ...

Oracle ORA-03135: connection lost contact

friends!I am facing this problem "ORA-03135: connection lost contact" once a week. I have checked the network status and found no issue on network side. My sqlnet.ora file has these parameters:NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)SQLNET.INBOUND_CONNECT_TIMEOUT = 60INBOUND_CONNECT_TIMEOUT_LISTE ...

Oracle ORA-03135: connection lost contact

I'm getting error as "ORA-03135: connection lost contact" when i run some insert from client(remote). i'm not getting the error immediately. may be after 3HRS.. during the 3hour period the session was in server for only 40mins. but if i execute same query in server directly it takes around 50mins to ...

Oracle ORA-03135: connection lost contact

I encountered the error : ORA-03135: connection lost contact if i leave the connection on for > 30 mins (or so i think)I am actually accessing the data via a dblink.Please advise where i could check to see if it's a settings issueTks & rgds ...

Oracle ORA-03135 at heavy load

ora 11g, x64, no firewal, no proxy, GigabitEth.... Looks like the ora does not server the new connection at heavy load. The server have more permanent connection never have a problem. But one connection periodic (~10sec) check the server heatl. For this connections the ora sometimes reject the conne ...

Oracle OEM Grid "Failed to connect to database instance: ORA-03135

Did anyone know why we get the error in the OEM grid:Failed to connect to database instance: ORA-03135: connection lost contact (DBD ERROR: OCISessionBegin).We checked the listener and it is running fine. Can someone advice where to look? ...

Oracle java.sql.SQLException: ORA-03135: connection lost contact

In the whesphere portal i foun a lot of "ORA-03135: connection lost contact" errors but i cant find this error in the oracle client or oracle database.Oracle Client 10.2.0.1Oracle RDBMS 10.2.0.3 -- in Rac with 3 nodesI have a fragment of the trace: [20-NOV-2009 23:38:52:338] --- TRACE CONFIGURATION ...

Oracle ORA-12545: Connect failed because target host or object does not exist

When I try to connect Oracle (residing on a NT box) using sqlplus (sqlplus datarx_dev/datarx_dev@datarx) from the client installed on a Linux server I get connected to the Oracle instance.Now I tried to connect to Oracle using the following code in Java (JDK 1.3.1):import java.sql.*;public class Oci ...

Oracle ORA-12154: TNS:could not resolve the connect identifier specified

I am unable to connect to oracle using connection identifier.os : windows 2000 serverdb : 10.1.0.2.0when i am trying to connect oracle using connection identifier it is throughing the following error:"ORA-12154: TNS:could not resolve the connect identifier specified"when i am tryin to connect oracle ...

Oracle ORA-12545:connect failed because target host or object not exist

I am getting this error message when i want to connect oracle by using internet explorer browser.ORA-12545:connect failed because target host or object not existI already started services: oracleservicesSID,OracleOraDb10g_home1TSNListener,and OracleOraDb10g_home1HTTPServer ...

Oracle ora -07445 with ora-03135 error

Sorry for asking questiob about this generic error, i shouldd contact oracle support for this. But for some tecnical reason metalink SR request page is offline. May be i get some help from you guys.For last three days i have been getting ora-07445 error at same time, by going through the trace file ...

Oracle Restore 11g controlfile - ORA-03135: connection lost contact

HiI am restoring 11g RAC db to single instance on a different server.Here is what I get:rman target / catalog rman/rman@rcatRecovery Manager: Release 11.1.0.7.0 - Production on Wed Oct 29 18:05:50 2008Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database (not started)con ...

Oracle Getting Error ORA-03135: connection lost contact

I've followed the various steps to setting up the HS connection (Oracle APEX to MS SQL SERVER 2005)However when I attempt to "select 'x' from tabley@RemoteConn" it immediately gives me the following error: SQL> select 'x' from tabley@RemoteConn;select 'x' from tabley@RemoteConn*ERROR at line 1:OR ...

Oracle RAC connection issue with ora-03135

I have a client 11.2 in 64 bit window 2008 that out of our domain and try to connect to 4 nodes RAC database in 64 bit liinux DB by VPNI got below error asSQL> connect xx/xxx@saleERROR:ORA-03135: connection lost contactProcess ID: 0Session ID: 0 Serial number: 0 I can ping each node from client a ...

Oracle Help - ORA-03135: connection lost contact

I was running the scripts for loading the data into my database through the sql*plus. The client (sql*plus) is on the same machine where the database is installed. So there is no network in the picture. After running the script for more than 6 hours, I got with the following error..ERROR at line 2:O ...

Oracle Error ORA-02068,ORA-03135,ORA-06512 in Streams

I am new to Streams. Actually we are trying to replicate the data between 2 databases and we are using streams for this.But we are getting the below error in DBA_PROPAGATION table. ORA-02068: following severe error from TINFOT3ORA-03135: connection lost contactORA-06512: at "SYS.DBMS_AQADM_SYS", lin ...

Oracle ORA-12516 error in PHP application on Win XP SP2

After a fresh Oracle10gXE installation on Win XP i tried the "anyco.php" script out of the "2 Day Plus PHP Developer Guide" and yes it first runs fine, but if I reload the script in any browser for about 20 times I get this error:Warning: oci_connect() [function.oci-connect]: ORA-12516: TNS : le pro ...

Connect Oracle 10g and OWB to SQL Server 2005 in Windows XP

I am unable to create a working connection between Oracle 10g and a SQL Server database. I have followed the instructions in several sources, but when I attempt to connect to the MSSQL database through SQL Plus or SQL Developer, I get the ORA-03135 error. I set up a non-Oracle location in OWB and th ...

Oracle ORA-24315: tipo de atributo no válido

i´m in dead line trying to resolve ORA-24315i´m using Centos 5apache 2.2php5 oracle 10gwhen I try to connect to my db always get that messageWarning: oci_connect() [function.oci-connect]: ORA-24315: tipo de atributo no válido in /var/www/html/conexion_estadisticos.php on line 3Could not connect t ...

Oracle ORA-00942: table or view does not exist

I have installed Oracle database 9.2.0.1.0After installation ...i tried to connect froma java class using scott/tiger@oracle it was successfullAfter that i created one user TEST with paasword TEST in SYSTEM table space with temporary table space TEMPand connected from sqlplus > conn test/test@ora ...

I want to connect Oracle DB via sqlplus as user root,how to do?

I try to connect Oracle DB via sqlplus as usr root,but the following error occur:# sqlplus SQL*Plus: Release 8.0.4.0.0 - Production on ÐÇÆÚÎå 4ÔÂ 4 17:2:34 2003(c) Copyright 1997 Oracle Corporation. All rights reserved.Enter user-name: systemEnter password: passwordERROR:ORA-01034: ORACLE no ...

Oracle ORA-10044

Just after an update in table, i insert new data in the database.But an error message appear : ORA-10044 free lists undo operations.My insert query work well alone.The cursor is of course close after the update and open again for the insert.What can i do ?Note : I work white OCI under oracle 8 ...

Oracle ORA-27101 shared memory realm does not exist

While I reboot the server and try to connect oracle, it saysORA-27101 shared memory realm does not exist. I have to shutdown abort and bring up the database manually every time.Then it works fine.Can anybody help me? ...

Oracle ORA-27101 shared memory realm does not exist

While I reboot the server and try to connect oracle, it saysORA-27101 shared memory realm does not exist. I have to shutdown abort and bring up the database manually every time.Then it works fine.Can anybody help me? ...

Oracle ORA-12801: error signalled in parallel query server

A client of ours is using our reporting tool, Impromptu 6, to report from an Oracle 8.1.6 database connecting with Net8. He has built a simple report which displays a single item from a single table but it fails with:-Query Server Error"ORA-12801: error signalled in parallel query server"Error numbe ...

Oracle ORA-07320

a UNIX application (server process) want4s to connect to a oracle database (7.3.4) running on the same machine. The following error occures:SVRMGR> connectUsername: ORA-01034: ORACLE not availableORA-07320: smsget: shmat error when trying to attach sga.SVR4 Error: 13: Permission deniedSVRMGR> ...

Oracle ORA - 4043 error

HiI am using OCI on Oracle 8.1.6 and am facing a compiling error in my code while using the OCI API OCIDescribeAny(). On calling OCIErrorGet(), I am getting the following error code.ORA - 4043 object geocode (this is one of the tables in my database) not found.Can anybody please help me out with thi ...

Oracle ora-03106

My company is using visual c++ 6.0 and Rogue wave dbtools as the interface to connect oracle 8.1.6 database. When we do some stress test ( continues to insert and select data from DB ), we always meet ora-03106 error, I have tried to restart the DB and checked the NLS setting on both client and DB s ...

Oracle ORA-22292: Cannot open a LOB in read-write mode without a transaction

We are having a problem writing lobs via jdbc (OCI) on Oracle 8.7.1.3. We are getting the following error sporadically with the java code below. We are performing a SELECT FOR UPDATE which should be starting a transaction, before writing to the lob. The wierd thing is we get the ORA-22292 error spor ...

Oracle ORA-22292: Cannot open a LOB in read-write mode without a transaction

We are having a problem writing CLOBs via jdbc (OCI) on Oracle 8.7.1.3. We are getting the error below sporadically which is caught in the java code following. We are performing a SELECT FOR UPDATE which should be starting a transaction, before writing to the lob. The wierd thing is we get the ORA-2 ...

Oracle ORA-12560: TNS:protocol adapter error

I tried to use PHP connect to Oracle 8.1.7 DB. Oracle is installed on Windows 2000 and PHP 4.2.2 & Apache 2 are installed on Win NT4. Oracle database run very good. PHP & Apache too. But when use OCI8 library (in Window NT) to connect Oracle by PHP, a error message apear following:_oci_open_ ...

Oracle ORA-12516

I am trying to run multiple oracle client (weblogic application server using oci-jdbc) instances on one machine (under stress) connecting to single oracle db instance which is running on a separate machine. when I start the clients, i get this oracle ORA-12516:TNS:listener could not find available h ...

Oracle ora 12154 error trying to create database

I'm getting the infamous ora 12154 - TNS could not resolve connect identifier error.My computer is running windows 2000 pro in standalone mode (not connected to a network).I used the oracle 10g install program to install the software without the database and everything went fine.I then used the assi ...

Unable to connect Oracle DBD Error

I am using Perl to connect Oracle database. OS is Linux and I use to connect two different database depends upon the TWO_TASK environment variable. TWO_TASK values may be 'saph_db1' or 'saph_db2', and both the databases are Oracle9i Enterprise Edition Release 9.2.0.5.0. Both database are residing in ...

Oracle ORA-12514

Thanks for your suggestion, finaly i had created database by Manually starting ORACLE Service. But another suggestion is giving error on your suggested following step:- Select the members tab (which for a server also lists the machine name)Name: Administrator and Active Directory Folder: MSUM.local/ ...

Oracle ORA-03134: Connections to this server version are no longer supported?

i want to connect oracle version 10.1.0.0(client version) to oracle version 8.1.5.0(server version); this error "ORA-03134: Connections to this server version are no longer supported" will be occured. how to solve this problem please give me example with steps. ...

Oracle ORA-27101: shared memory realm does not exist

I installed OracleExpress on a windows 2003 server. Right after the installation, I was able to create and use a database. Then, after the first reboot, the database didn't start automatically, but after SQL> connect /SQL> startupthings worked fine again. Now, after a third reboot, this trick ...

Oracle ORA-24314 : Service handle not initialized

i am installing oracle 9i enterprise on windows 2003 enterprise.after software installation, when i was trying to create the database manually,1. i cannot connect oracle, stating ORA-24314 : Service handle not initializedi am using following commandsqlplus " / as sysdba"2. also, i am not being able ...