RE: ORA-1410 on interMedia Text Index
I was getting ORA-600 [12700] when I upgraded a 734 text database to 817. Ended up having to apply the latest patchset, I think it was 8172, to finally fix the problem. Has something to do with buffer cache corruption when Intermedia is trying to sync the index. The index loses its pointer to the row. Never got the ORA-1410 though. I have no idea if they have a patch for 816. If you contact Oracle, they will want you to analyze the base table and all the indexes and send them the trace file on the ORA-600. -Original Message- Sent: Wednesday, September 12, 2001 7:40 PM To: Multiple recipients of list ORACLE-L Hi, 8.1.6.0.0 on Win2k with interMedia Text index on table of 4 million CLOB documents. It's been in stable operation for over 8 months, with approx. 70,000 documents being added daily, approx. 10,000 deleted daily, and a sync of the index each day. We started getting ORA-1410 invalid ROWID for Contains queries and ORA-600 [12700] errors in the Alert log. This happened a few days after we altered the DR$index$R table to Cache Reads for its Data LOB column. Metalink Bug 1668041 indicates that changing Cache Reads to just Cache for the DR$...$R table solved the problem for an 8.1.7. WinNT DB. Has anyone else experienced this? I'm rebuilding the index now (for the 2nd time this week! - takes 7.25 hours) and want to know if this fix will work. Thanks for any advice or suggestions. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
817 Intermedia on AIX
Is there anyone else out there running version 8172 Intermedia on AIX 4.3? We recently upgraded a text database from 734 to 817 and started getting either ORA 3113 or ORA 600 [12700] errors on iMedia queries. Upgraded to 8172 because Oracle said it contained a patch for this bug, but the second business day after the upgrade, we're back to the ORA 600 [12700] error. One doc on Metalink says it may be caused by corrupted indexes, but analyze comes back clean. It also says it could be from heavy update query activities against the same set of data. I suppose I could just tell them to stop doing that, but I was hoping for some other solution. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE 816 ON WIN2000
The installer hung at network configuration, but I think it's because we launched the installer remotely through a Terminal Services window. The database service does not come up automatically even though it says the service is started. A patch is available for this, but I have not applied it yet. -Original Message- Sent: Friday, April 20, 2001 12:25 PM To: Multiple recipients of list ORACLE-L Hi List , I am supposed to install oracle 816 on win2K ( I knowI should go for real OS !! ) I am very much of a UNIX bigot and I am looking for any pitfalls and things I should look out for . TIA . Regards, RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do not belive BUSH and your army goverment so much
Maybe you should mention how much better China is than the US to all the Chinese people willing to risk their lives crossing the Pacific in cargo holds in search of a better life here. -Original Message- Sent: Monday, April 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L right now, I understand US people also just belive TV or news. The news always controlled by goverment or service for the goverment. This fact is for sure that US is high-handed and arbitrary. US army fly to all over the world and control all the world. I hate this but I feel so frustrated that US army is No.1 in this world and all over the world can not even say a "NO" to US. Right now, I know many US people do not understand Chinese, Chinese do love peace very much. Many things, these days, China are better than US now. You should go and have a look in China. Do not be so stupid and arbitrary. Do not belive BUSH and your army goverment so much. When the army is so good, they want to invade China or some other coutries. I hate China does not have good people rights. But I hate US is so impolite when they know they will win on every army fight. What I have forcasted are becoming true now. When BUSH was selected as president. I forcasted he would make many bad things and use his army. Today I forcast he will invade China more and put all Chinese in extreme misery. He will because he is the people who care too much about army...He do not care about high-tech, you are losing your good salary now...You have lose you stock options. Just one more fact, yesterday I watched the TV, the announcer used intimidatory voice that made very unhappy, "fuck you", I growl to the TV. Just because you have the No.1 army so you can do all the things? Sorry for this post because it is not about ORACLE. If US and China finish the relationship, at least 10% more of you will lose your job. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:20 PM They ought to learn flying their bikes from ET.. leave fighter plane flying to others.. -Kirti -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: stupid DBA Well, according to the stereotype, they aren't very good drivers, so maybe it was inevitable. ep [EMAIL PROTECTED] 04/14 6:15 PM How was it mean? Considering how well they seem to do their job, it would be a heck of a lot easier to become a Chinese fighter pilot than a nurse. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Service does not start
See note 132086.1 on Metalink. -Original Message- Sent: Tuesday, April 17, 2001 3:02 PM To: Multiple recipients of list ORACLE-L Hi! I'm having a problem with Oracle on Win2k here. I can't start Oracle by using the Management Console (i.e. start the windows Service). The Service remains in the status "starting" but never goes to "started". Then I can't even stop the service again. Not with the tool neither with the command line. I can start the database using SVRMGRL / SQLPLUS, but the Windows Service still doesn't start. Seems weird to me. Any ideas? This is 8.1.6.3.0 on Win2k Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Services and Oracle Startup - WIN2000
It's a bug. Refer to note 132086.1 on Metalink. -Original Message- Sent: Monday, April 02, 2001 10:31 AM To: Multiple recipients of list ORACLE-L I have this small situaltion I try to start my database from command line in win2k , I get the following error C:\svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. ORA-12560: TNS:protocol adapter error SVRMGR exit Server Manager complete. C:\ But , If I go to services and start the service for starting the database I get this C:\svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SVRMGR connect internal Password: Connected. SVRMGR select * from v$database; select * from v$database * ORA-01034: ORACLE not available But If I do a startup from command line in win2000 it's starts and looks perfect . SVRMGR SVRMGR startup ORACLE instance started. Total System Global Area419173644 bytes Fixed Size 70924 bytes Variable Size 110940160 bytes Database Buffers308084736 bytes Redo Buffers77824 bytes Database mounted. Database opened. SVRMGR SVRMGR exit Server Manager complete. Any ideas why it's doing this. I have all my required varibles set in my system. Rk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).