Re: Port access cancelling

2002-06-14 Thread Hemant K Chitale
(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: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Re: Oracle 9.0.1.3 or 9.2.0? -- planned 9.0.1 and 9.2.0

2002-06-14 Thread Hemant K Chitale
Check Note 190435.1 on MetaLink. [It is under Upcoming Oracle Product Desupports]. At 09:41 AM 13-06-02 -0700, Charlie Mengler wrote: I just went to Metalink viewed the desupport notices. I did not see where any 9i version is listed. Where did you find the notice for 9iR1? Hemant K Chitale

Re: Wait event problems

2002-06-13 Thread Hemant K Chitale
is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL

Re: !ls from sqlplus

2002-06-13 Thread Hemant K Chitale
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Oracle 9.0.1.3 or 9.2.0?

2002-06-13 Thread Hemant K Chitale
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: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

9iRelease2 Upgrade Alert -- PLSQL objects referencing 8i database

2002-06-12 Thread Hemant K Chitale
Bookmark Fixed font Go to End Doc ID: Note:189914.1 Subject: Recompilation of PLSQL may fail after Upgrading to Oracle9i (ORA-3113 in UTLRP)

Fw: DB upgrade problems from 8.1.7.3 to 8.1.7.4

2002-06-11 Thread Hemant K Chitale
FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: Re:RE: Oracle and Tru64

2002-06-05 Thread Hemant K Chitale
was that the Alpha processor was priced so high, few people would buy it and, therefore, Digital could never achieve economies of scale. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, 05 June, 2002 2:09 AM Peter

Re: Re[2]: Oracle and Tru64

2002-06-04 Thread Hemant K Chitale
Tru64 = 5.0 being desupported for new releases of 9i is OK. We are upgrading our Tru64 installations from 4.0F to 5.1/5.1A along with the database upgrades to 9iRelease2. But Tru64 on Alpha, as such, will continue for some more years. Hemant K Chitale - Original Message - To: Multiple

Re: Oracle Migration Questions

2002-06-04 Thread Hemant K Chitale
in which case you must do an ALTER DATABASE RENAME FILE before you OPEN the database]. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, 04 June, 2002 7:18 AM Migrating 35 Oracle 8.1.7.1 instances, all on external EMC disk, from

Oracle Alert on Upgrades to 9.2.0.1

2002-06-04 Thread Hemant K Chitale
Corruption / Internal Errors Possible after Upgrading a Database to Oracle 9.2.0.1It is vital that you read this alert if upgrading to Oracle 9.2.0.1 from an earlier release Versions Affected This problem affects Oracle databases upgraded from pre-9.0.1 to 9.0.1.X and then to 9.2.0.1.

Re: Oracle and Tru64

2002-06-04 Thread Hemant K Chitale
will NOT be ported to Itanium. It will be HPUX that will go to Itanium. The years 2006 and 2011 are sufficiently far in the future : Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, 03 June, 2002 11:53 PM Stephane, Hemant Below

Re: Oracle and Tru64

2002-06-03 Thread Hemant K Chitale
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-30 Thread Hemant K Chitale
So you got a performance improvement by *disabling* DirectIO (ie, by setting _tru64_directio_disabled=TRUE) ? Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, 30 May, 2002 3:48 AM I joined in on this thread a little bit

Used CBO with Oracle Apps 11.0.3 / 8.1.7

2002-05-29 Thread Hemant K Chitale
Oracle Applications 11.0.3 specifies that OPTIMIZER_MODE be set to RULE. Apps R11 was originally developed against 8.0.x (8.0.4). Has anyone changed the OPTIMIZER_MODE to CHOOSE after upgrading the database to 8.1.7 ? Hemant K Chitalehttp://hkchital.tripod.com

Re: so when did you switch from NT to unix for oracle

2002-05-28 Thread Hemant K Chitale
Unfortunately, I, and all of us, have seen the Pentium processors in MS-NT/2K. The general opinion of Pentium/P4 is in the context of MS operating systems. And these don't perform as well as *nix. Hemant K Chitale - Original Message - From: Mogens Nørgaard

Re: so when did you switch from NT to unix for oracle

2002-05-26 Thread Hemant K Chitale
. I don't know how good Online Backups are on NT. Hemant K Chitale http://hkchital.tripod.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, 25 May, 2002 4:33 AM 1) Not pulling any legs. That's what we run. 2) We have a few reasons

Re: 8.1.7.2.0 Supported on Digital Tru64 Unix ver 5.1 ?

2002-05-26 Thread Hemant K Chitale
The 8.1.7.2.0 Patchset for Tru64 was withdrawn and replaced by the 8.1.7.2.1 Patchset. You would be applying the patchset on top of an 8.1.7.0.0 or 8.1.7.1.0 or 8.1.7.1.0B installation. 8.1.7 is certified on Tru64 5.1 Hemant K Chitale - Original Message - To: Multiple recipients

Re: changing db name

2002-05-26 Thread Hemant K Chitale
for the new SID name]. Changing the databse name requires the CREATE CONTROLFILE SET DATABASE newname and the new name as the db_name= in the initSID.ora file. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, 25 May, 2002 3:08

Re: --- re OpenVMS/Tru64/HPUX/etc

2002-05-24 Thread Hemant K Chitale
, might go from PowerPC to Itanium]. Hemant K Chitale http://hkchital.tripod.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, 24 May, 2002 1:43 AM Hermat - We are on Tru64 and I couldn't be more pleased. However, I believe that HP/Compaq has

Re: altering next extent

2002-05-24 Thread Hemant K Chitale
Is the batch job doing a TRUNCATE table ? Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, 24 May, 2002 8:08 PM Hi, It isn't a local managed tablespace problem because I'm still on 7.3.4 db Besides that I'm changing

Re: so when did you switch from NT to unix for oracle

2002-05-24 Thread Hemant K Chitale
No way ! You're pulling a lot of legs [and hurting a lot of egos who take pride in pointing out that NT is _not_ an enterprise-class platform, me included]. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, 24 May, 2002 8:00

Re: Oracle feature

2002-05-24 Thread Hemant K Chitale
I second, and third, and fourth that. Actually, I don't have to spend too much time with Support for RDBMS issues. It is the new-fangled technologies -- iAS, Portal, iFS, Intermedia that I am not comfortable with Support about. Hemant K Chitale - Original Message - To: Multiple

Re: ORA-2085

2002-05-23 Thread Hemant K Chitale
I'd never have thought that this was possible in Advanced Replication Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, 23 May, 2002 12:48 AM At last something that I have experience in. Just do the following

Re: 8.1.7.4

2002-05-23 Thread Hemant K Chitale
Nope. .4 is supposed to be the last PSR (patchset release) for 8.1.7 Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, 23 May, 2002 4:33 AM I hear that .5 is right around the corner. Vinny --- Ruth Gramolini

Re: Rename Column in 9iR2

2002-05-23 Thread Hemant K Chitale
An upgrade wouldn't cost anything. It would be free as part of your support contract. Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, 23 May, 2002 2:41 AM Kevin, I appreciate your testing efforts. Now to convince

Re: patchset 8.1.7.3 or 8.1.7.4

2002-05-23 Thread Hemant K Chitale
The patchsets _are_ cumulative. You can go direct from 8.1.7.0 to 8.1.7.3 or to 8.1.7.4 [we normally don't go to the latest patchset level but wait a few weeks or a couple of months to see that no major issues are reported with the latest patchsetlevel]. Hemant K Chitale - Original

Re: Rename Column in 9iR2

2002-05-23 Thread Hemant K Chitale
The bane of trying to keep up with technology. But why OpenVMS and not Tru64, then. We have a large number of Tru64 Oracle Databases (we do have OpenVMSs for Promis databases used in manufacturing, I believe). Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE

Re: SHARED POOL SIZE

2002-05-21 Thread Hemant K Chitale
NO, THERE IS NO WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN (sic) THE DATABASE below 9i. Please don't use All-Caps. I remember the first time I used All-Caps on a NewsGroup about 7 or 8 years ago, I was roundly berated. Hemant K Chitale - Original Message - To: Multiple

<    1   2   3   4