ORA-03135 - Connection Lost Contact
May 4, 2013
Yesterday everethig was fine and I were able to connect / as sysdba
When í try it today sqlplus freez and I have to kill that session from other terminal.
When I try to connect as normal user, I am getting this error.
normal user
[oracle@oracle admin]$ sqlplus surad@evidence
SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 4 15:46:44 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-03135: connection lost contact
Process ID: 0
Session ID: 0 Serial number: 0
---
sysdba
[oracle@oracle admin]$ sqlplus /nolog
SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 4 16:01:09 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
SQL> connect / as sysdba
--> There are waiting .... solution is to kill that session.
----
[oracle@oracle admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 4 16:04:06 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
--> There are waiting .... solution is to kill that session.
View 17 Replies
ADVERTISEMENT
Aug 15, 2013
Since our upgrade from 10.2.0.4 to 11.2.0.3, we are experiencing occaisional overnight job failures throwing the ORA-03135 Connection lost contact errors. It doesn't happen often, but every once in a while. Even so, it is bugging me because I can't find anything wrong!
We have a dual server setup, with one IA64 HPUX 11.31 server hosting the database, and a second IA64 HP-UX 11.31 running all of the application code. I'm seeing errors in the Alert log that is pointing me to a specific cjq0 trace file, and the contents of that trace file are pretty much as follows:
*** 2013-08-15 02:05:45.541
Waited for process J001 to initialize for 107 seconds
*** 2013-08-15 02:05:45.544
Process diagnostic dump for J001, OS id=19302
-------------------------------------------------------------------------------
os thread scheduling delay history: (sampling every 1.000000 secs)
0.000000 secs at [ 02:05:45 ]
NOTE: scheduling delay has not been sampled for 0.312200 secs 0.000000 secs from [ 02:05:41 - 02:05:46 ], 5 sec avg
0.000000 secs from [ 02:04:46 - 02:05:46 ], 1 min avg
0.000031 secs from [ 02:00:45 - 02:05:46 ], 5 min avg
loadavg : 0.31 0.17 0.09
[code]....
There were jobs that completed successfully just prior to this failure, and subsequent jobs ran successfully as well. I'm stumped - not sure what's going on here. I have reviewed a lot of posts relative to the ORA-03135, and followed as many of the recommendations as I can, but I'm still seeing this errors periodically. Their frequency has not changed since I started applying these changes, so I know I haven't stumbled on the cause as yet.
View 1 Replies
View Related
Dec 28, 2012
I am using a database link from between oracle 10g enterprise & oracle 10g express edition on window based system.
We are getting below given error at one client system and others clients system is working fine..
ORA-02068: following server error from dblink name
ORA-03135: connection lost contact table name <tablename>
View 9 Replies
View Related
Oct 11, 2010
My application is using "Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" and Oracle 11g client v11.1.0.6.0.My application server runs continuously and checks for new requests. But problem occurs when I do not send any request to my server for 40-45 minutes i.e. server is idle or doing nothing except checking new incoming requests for those 40-45 minutes. After that if I try to connect my server by sending some request, it shows following error message and my server crashes:
Message String: ORA-03135: connection lost contact
Process ID: 7586034
Session ID: 61
View 9 Replies
View Related
Dec 7, 2012
I installed a server on a Linux server Oracle11.2.0.3 5.8 from 64 bits.The user who installed the Oracle software is "oracle" and belongs to oinstall and dba groups.
ID ORACLE
uid=503(oracle) gid=504(oinstall) groups=504(oinstall),505(dba),506(cvargas) context=user_u:system_r:unconfined_t
The software has been installed correctly and have been able to create two databases. As a requirement of the application, you must create an operating system user that launches processes.This user belongs to dba.But when trying to access Oracle via sqlplus gives this error:
-bash-3.2$ sqlplus davinci/xxxxxxx
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 7 23:22:40 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
However, if you connect using a network descriptor works correctly.
SQLPLUS DAVINCI/xxxx@tns_alias
So there must be a problem with access to local resources.This user has the same profile file variable (. Bash_profile)
View 6 Replies
View Related
Mar 29, 2011
I have successfully installed Oracle R12 on my machine but after rebooting I can not start.
This is what I did
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addlnctl.sh start listener
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
You are running addbctl.sh version 120.1
Starting the database VIS ...
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 29 21:02:42 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
addbctl.sh: exiting with status 9
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
[code]....
BTW I have not set $ORACLE_HOME, $ORACLE_BASE, $ORACLE_SID yet.
View 18 Replies
View Related
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
Jul 6, 2012
I am using Oracle 11g database. The situation is I need to run a batch process a fixed intervals and copy data into my table from a remote database using a DB Link. I have 3 tables,1. Original data Table, 2. Exported data Table, 3. Status table. All the data from the remote database will be loaded into the exported data table. As and when each copying is finished the status table will be updated with 'Y' if export is success and with 'N' if export is unsuccessful. When the exporting is over, then status table is checked, if all the status' is Y then the data from Exported data table will be copied into the Original data table after truncating all the rows of Original data table. If the status is N then the Original data table will be intact.
How to check whether the exporting was success for all the exported data ? what to do if the connection through the DB Link was lost during the exporting?
View 3 Replies
View Related
Jul 5, 2012
When I run the below query, the session got the below errors exactly after 1 hour. I checked profile, resource limit, and sqlnet.expire_time. The SQLNET.EXPIRE_TIME value is 10. Except expire time there is time limit in profile and resource. I dont know how this session is losting connection exactly after 1 hour. What could be the issue here and what else need to check it?
14:34:09 SQL> << DELETE query >>
ERROR:
ORA-03114: not connected to ORACLE
DELETE FROM amsoftinstall
[code]...
SQL> select * from V$RESOURCE_LIMIT;
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- ---------------------------------------- -------------------------
-------
processes 37 49 150 150
sessions 44 56 170 170
[code]...
SQL> select * from USER_RESOURCE_LIMITS;
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
[code]...
View 1 Replies
View Related
Jun 3, 2011
I'm trying to write a query where I grab the first contact created of an account. I've tried everything but I can't get this to work.
Here is the normal query we used to get the contacts from an account:
select
con.row_id,
con.created,
con.fst_name,
con.last_name,
con.email_addr
from s_contact con
join s_org_ext org
on org.row_id = con.pr_dept_ou_id
I've tried different variation of aggregate functions, but its not working.
View 5 Replies
View Related
Sep 23, 2013
how to write below query in pl/sql cursor. The help table has two associated tables, help_txt and help_id, which will have strings of data concatenated into one sales contact record. There are multiple lines of text per comment and multiple lines of resolution text at 40 characters per line. The key to the help_text table (id, date,seqno) is the main key to the help_txt table and help_id t table with a sequence added to each table
The formatted string will contain some text and variables with the comment lines (1-10 or more) concatenated first, followed by the resolution lines (1-10 or more). There will be multiple comment and multiple resolution lines. The Cust_Cmnt_Txt lines and the Resolved_Desc lines should be concatenated and formatted in the following string (% marks the variable string) :
'help taken ' %help.Taken_Dte 'received from the following source: ' %help.id. 'Remark Text: ' %help_text (where help_txt_Seq = 1) %help_text (where help_text_seq = 2-10 or more) 'Resolution: ' %help_id_Res_Txt.Resolved_Desc (where help_ID_Txt_Seq = 1) %help_ID_Res_Txt.Resolved_Desc (where help_id_Txt_Seq = 2-10 or more)
View 8 Replies
View Related
Oct 12, 2012
I know this question must have been asked several time. I just want to know the many ways in which we can have a DB up and running even if we do not have any backup of control file not even the trace of the same.
View 6 Replies
View Related
Sep 13, 2012
i was worked on oracle 11g.1, oracle data miner 11.1.0.4, sql developer 3.
unfortunately, after finishing my tables and models ,the hard disk damaged and was replaced with other.the oracle setup was not on system partition,it was on D:/ and i had windows backup for C, D partition. i restored oracle partition D which contains old oracle files and i installed oracle again but on partition F.
now....how can i restore tables and modules?
View 3 Replies
View Related
Mar 2, 2011
I have a question in Recovering the database.
E.g. Backup has done yesterday and today evening all files are lost (control, redologs, archive, etc.)
We are in 24/7 environment then how we need to recover the database?
View 4 Replies
View Related
Jul 1, 2010
recreate paramater file if you lost init.ora or spfile.ora
STEPS
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:ORACLEORA92DATABASEINITGPT2.ORA'
How to resolve ORA-01078 with LRM-00109 error?
For resolving these error, you should need to replace init.ora or spfile if you have backup of same files. If you don't have backup then go to alert.log and copy all parameters in one file and save as "init.ora". Modify same init.ora with some parameters which need single quotation mark " ' " like background_dump_dest,controlfiles,db_name and "dispatchers ......)". Connect as sysdba in SQL*Plus and execute command "create spfile from pfile=" or startup pfile or startup.
View 2 Replies
View Related
Jun 20, 2010
I am inserting data into database_A table from database_b using dblink,
INSERT INTO database_A@database_B SELECT * FROM student;
while inserting if we loss some records how can we recover those records.
View 11 Replies
View Related
Mar 24, 2011
While i'm trying some of fail over and switch over scenario's on my primary and standby db configuration. But suddenly i completely loss my standby db box, due to hardware failure. so now i'm not able to recover that box. It is almost non recoverable hardware failure to that box. My primary db is still up and running well. When i check the alert logs of primary db it has some errors related to standby db. Due to configuration it tries to sync the standby db, which is not possible to connect anymore. So my main question is how get rid of that errors/stop that errors from primary db. which parameter's i've to turn off in primary db. Herewith i'm giving some of initSID parameter of Primary db and a snap of alert log from primary db.
My primary db is in MAXIMUM AVAILABILITY mode. Snap from alert files
Errors in file /ora9isoft/odb/OH1/admin/wbdata/bdump/wbdata_lgwr_1248.trc:
ORA-12541: TNS:no listener
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Creating archive destination LOG_ARCHIVE_DEST_2: 'wbdata.wbhouse'
LGWR: Transmitting activation ID a043c21d
[code]....
View 9 Replies
View Related
Sep 14, 2012
Our system administrator upgraded from apex 4.1 to 4.2 last night. This morning, we no longer have the dev-toolbar at the bottom of the page when I run a page from Application Builder. Not sure where to look to sort that out.
View 5 Replies
View Related
Jan 9, 2013
how to take backup and recover of oracle database and which method is best for to protect our data from lost
View 3 Replies
View Related
Jul 11, 2013
The problem was describe:
- First time to execute: Using all indexes on 2 tables
- Second time to execute: Using only indexes on first table, full table scan on the other
- Third time to execute: Do FTS on both of tables.
Now, I show the objects and relate information here:
The Tables:
system@dbwap> select count(*) from my_wap.news_relation;
COUNT(*)
----------
272708
system@dbwap> select count(*) from my_wap.news_content;
COUNT(*)
----------
95092
system@dbwap> desc my_wap.news_content;
Name Null? Type
----------------------------------------------------- -------- ----------------
ID NOT NULL NUMBER(11)
SUBJECT NOT NULL VARCHAR2(500)
TITLE VARCHAR2(4000)
STATE NUMBER(1)
IMGPATH VARCHAR2(500)
ALIGN VARCHAR2(10)
[Code]....
View 7 Replies
View Related
Jul 7, 2011
i need to restore one dropped table which i mistakenly deleted from my UAT Server. My flashback was off also. How to recover the lost table by RMAN.
View 8 Replies
View Related
May 9, 2011
We are trying to restore a database to a cold backup DBID.However while our datafiles were backuped up for 6 months retention we found out subsequent delete obsolete command wiped out the Control file related to this backup piece..Now what is left with this backup piece is just datafiles..
Can we still recover the database with a subsequent controlfile autobackup for the same DBID.?
View 2 Replies
View Related
Nov 16, 2010
Lost Windows password? Forgot Windows password? Your PC was hacked? Therefore, it is a basic step for every Windows users to enhance the security of Windows password. In the networks, it is found that a number of user's passwords are easy to guess. Only the smallest groups are the most security conscious and select passwords that are mixed lowercase and uppercase letters, numbers and punctuation to create cryptic passwords. Adopting strong password is one of the most effective ways to ensure system security. Here are several methods for you to enhance the security of your passwords in Windows 7/2000/XP/Vista and so on. You'd better remember the methods below unless you want to reset Windows password from time to time.
1. Is random password a great password?
A common myth is that totally random passwords like Ht3&e#L%5d@$B are the best passwords. This is not true. While they may be strong passwords, they are usually difficult to remember, slow to type, and sometimes vulnerable to attacks against the password generating algorithm. It is easy to create passwords that are strong but much easier to remember by using a few simple techniques. For example, consider the password "Luck-73@Better?". This password utilizes uppercase and lowercase letters, two numbers, and three symbols. The password is 15 characters long and can be memorized with very little effort. Moreover, this password can be typed very fast. The portion"Luck" and "Better" alternate between left and right-handed keys on the keyboard, improving speed, decreasing typos, and decreasing the chances of someone being able to discover your password by watching you.
2. Create the long Windows password
Although a password may eventually be discovered through some means, it is possible to create a password that cannot be cracked in any reasonable time. If a password is long enough, it will take so long or require so much processing power to crack it. That is essentially the same as being unbreakable (at least for most hackers).
3. Create the Windows password constantly?
This may be good advice for some high-risk passwords, but it is not the best policy for every user. It is frustrating for a user to have to constantly think of and remember new passwords every 30 days. It may be better to focus on stronger passwords and better user awareness rather than limiting password age. A more realistic time for the common user may be 90-120 days.
4. Write down Windows password in a proper place
Sometimes it is necessary for some users losing and forgetting complex passwords easily to write down them somewhere proper. However, it is important to educate users on how to write down passwords properly. Obviously, a sticky note on the monitor is not a good idea, but storing passwords in a safe or even a locked cabinet may be sufficient.
5. 14 characters is the optimal password length
Each character that you add to your password increases the protection. Your passwords should be 8 or more characters in length; 14 characters or longer is the Optimal Password Length. Many systems also support use of the space bar in passwords, so you can create a phrase made of many words. It is not easier to forget and lose, as well as longer than a simple password, and harder to guess.
6. Try not to use the same Windows password for all accounts
Some users always make the same passwords for every account to make it easy to remember. In that case, when any one of them lost, your other information protected by that password will be in danger as well. It is serious to use different passwords for different systems and accounts.
7. Do not use some common words that other users maybe guess
Most of users prefer to use some common words to remember easily, for example, login name, birth date, driver's license, passport number, pets' name and other words contained their personal information someone knows. In that case, your Windows system will not be safe anymore. Moreover, do remember not to use some words spelled backwards, abbreviations, sequences or repeated characters and adjacent letters, such as, asdfgh, 123456, 888888, abcdef and so on.
You can smoothly use your Windows now because the strong and powerful Windows password is created successfully, Certainly, I believe that many users lost Windows password and forgot Windows password, then you need have to reset Windows password or recover Windows password. It is a big problem for plenty of Windows users that how to reset Windows password. how to recover Windows password and they are puzzled by resetting windows password, for instance, reset Windows 7 password, recover password Windows XP, remove Windows Vista password and other operating systems after they create the password with complex letters, numbers and symbols. However, it is unnecessary to worry and it is said that things will eventually sort themselves out. There are many ways to reset forgotten Windows password, including use windows password reset disk and windows password reset software, like Super Windows Password Reset, a professional windows password reset software which could enable you to logon to Windows smoothly without reinstalling system.
View 1 Replies
View Related
Dec 13, 2010
We are migrating a proc application as described below.
Old Env: UNIX
Old DB: Oracle 8i
New Env: Linux
New DB: Oracle 11g
New modules are successfully compiled in Linux environment. But we are facing issues in writing the output of VARCHAR datatype to a file.
find below the extract of code.
EXEC SQL BEGIN DECLARE SECTION;
varchar mcolmnvarchar[4];
EXEC SQL END DECLARE SECTION;
EXEC SQL DECLARE crs CURSOR FOR
SELECT NVL(colmn,' ') FROM table1
memset(mcolmnvarchar.arr,'�',4); //Was added for only Linux migration. Not present in unix env.
EXEC SQL FETCH c1 INTO :mcolmnvarchar;
cout << "Data at Stage one"<< mcolmnvarchar << endl;
mcolmnvarchar.arr[mcolmnvarchar.len]='�';
cout << "Data at Stage two"<< mcolmnvarchar << endl;
fprintf(fptr,"%-4s",mcolmnvarchar.arr);
Above code works absolutely fine in Unix env with Oracle 8i. But with Linux env & Oracle 11g it is not working. No compilation or run time errors. Data at Stage one prints the output of database properly. But after null terminator code, Data at Stage two statement prints without any value. Value is lost after null terminator code.
View 7 Replies
View Related
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
Nov 29, 2007
I have some problem connecting with the database. I have downloaded jdeveloper and oracle 10g express edition. I was trying to connect to the 10g express edition from j developer but i am unable to.
I right clicked on the application and then new in that. In that i choose database tier. there i gave my user id and password and changed the side to XE. and when i click on test connection it says IO exception: the network adapter could not establish the connection. I can even log in with the same user name and password in to the database home. I don't know whats the problem.
View 7 Replies
View Related
Mar 18, 2013
Currently weblogic has 120 concurrent connections to the database.There is a requirement to scale up the number ofconcurrent connections to 300.We have did some study and quite be quite sure that the current sga and pga is required. (the additional connections will be firing the same sql which is very well tuned.
However each additional connection to the database will take up additional memory just for the connection?Will is be using the memory in the PGA? Or outside the PGA for the connection overhead?We are not using MTS.
View 19 Replies
View Related
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
Jun 22, 2011
i am trying to insert records (with varchar2 fields) into mysql database from oracle through heterogeneous connection..but after insert, and when i query the inserted data which inserted in arabic, it appears as question marks '?????????'
the character set of oracle database is AR8MSWIN1256...and the character set of mysql database is UTF8...
is there any configuration to the heterogeneous connection that configure the character set ?
View 1 Replies
View Related
May 16, 2007
We have two database instances on the same server. One was left at 9.2.0.7 and one was upgraded to 10.2.0.3. Connecting externally (sqlplus '/as sysdba') to the 9.2.0.7 database is lightning fast. Connecting externally to the 10.2.0.3 database is very slow, comparatively speakiing. This is on an IBM AIX-5L (64-bit) machine. We are using "tnsnames".
View 10 Replies
View Related