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.
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
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)
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.
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?
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
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)
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.
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.
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.
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]....
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.
- 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)
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.?
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.
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.
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.
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.
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 ?
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".