Re: problem with log version
--- Mauricio Vélez <[EMAIL PROTECTED]> wrote:
> Hello everybody
>
> I'm trying to recover a full database from a hot
> backup.
> When I execute the following instruction:
>
> SQL> recover database using backup controlfile
> until cancel;
>
> Then I obtain the error ora-00331,
> This is the output:
>
> ORA-00279: change 1581950488 generated at 01/18/04
> 21:00:01 needed for thread 1
> ORA-00289: suggestion :
> C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC
> ORA-00280: change 1581950488 for thread 1 is in
> sequence #9537
>
> Specify log: {=suggested | filename | AUTO |
> CANCEL}
> C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC
> ORA-00331: log version 8.1.0.0.0 incompatible with
> ORACLE version 8.0.5.0.0
> ORA-00334: archived log:
> 'C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC'
>
> ORA-01547: warning: RECOVER succeeded but OPEN
> RESETLOGS would get error below
> ORA-01195: online backup of file 1 needs more
> recovery to be consistent
> ORA-01110: data file 1:
> 'F:\ORADATA\CAMBIOS\SYSTEM01.DBF'
>
>
> In the Oracle Documentation The solution to the
> error ora-00331 is to recover the database using the
> old software. The problem is tha I don't have the
> old software.
> Is there a way to change the log version or what can
> I do?
>
> Regards,
> Mauricio Vélez
Mauricio,
If I read this correctly, you have started up an
instance for an 8.1.x database using 8.0.5.x binaries.
Is there some reason that you do not want to open this
hot backupset as an 8.1.x database?
Is this your own testing, or is this a recovery
secenario in production?
Do you have a support contract with Oracle Support?
There are mechanisms via which you can downgrade a
database, but I believe that you have to have the
database in a consistent state (open) prior to
downgrading it.
Is it possible that you simply have the "compatible"
parameter set to 8.0.5 (by mistake) in the init.ora
and just need to restart the instance with compatible
set to "8.1.0.0.0" and retry recovery?
It could be that simple.
Run these and report back, please.
SQL> select * from v$parameter where
name='compatible";
SQL> select * from v$version;
Pd
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Drake
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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).
problem with log version
Hello everybody
I'm trying to recover a full database from a hot backup.
When I execute the following instruction:
SQL> recover database using backup controlfile until cancel;
Then I obtain the error ora-00331,
This is the output:
ORA-00279: change 1581950488 generated at 01/18/04 21:00:01 needed for thread 1ORA-00289: suggestion : C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARCORA-00280: change 1581950488 for thread 1 is in sequence #9537
Specify log: {=suggested | filename | AUTO | CANCEL}C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARCORA-00331: log version 8.1.0.0.0 incompatible with ORACLE version 8.0.5.0.0ORA-00334: archived log: 'C:\ORANT\ORADATA\CAMBIOS\ARCHIVE\09537.ARC'
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01195: online backup of file 1 needs more recovery to be consistentORA-01110: data file 1: 'F:\ORADATA\CAMBIOS\SYSTEM01.DBF'
In the Oracle Documentation The solution to the error ora-00331 is to recover the database using the old software. The problem is tha I don't have the old software.
Is there a way to change the log version or what can I do?
Regards,
Mauricio Vélez
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Re: Oracle Version 8 as read only
Hi Tims ideas are good but also take a cold backup of the database before the read only period starts so that even if someone manages to alter data it can be restored back to its previous state. By the way when you say read only does that apply to batch processes and general system ageing? - if so you need to ensure you back up after each batch run so it can be restored to a fixed position if someone manages to change anything. always remember "least privilege principle"!! hope this helps kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Version 8 as read only
Consider also using "ALTER USER xxx ACCOUNT LOCK" instead of changing the passwords... on 11/26/03 6:49 PM, Browett, Darren at [EMAIL PROTECTED] wrote: > Looks like that is what we will be doing, basically creating > a generic user with read-only privileges. All the current > users will have their password changed so they cannot access the > system. > > Darren > > -Original Message- > Sent: Wednesday, November 26, 2003 4:04 PM > To: Multiple recipients of list ORACLE-L > > > Darren, > Couldn't you just open the database with a user that has all the > necessary privileges revoked? > > -Original Message- > Browett, Darren > Sent: Wednesday, November 26, 2003 3:44 PM > To: Multiple recipients of list ORACLE-L > > We are in the process of upgrading our peoplesoft app, using an oracle > database of > 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 > database as readonly. > > I have read all the doc's but it appears I cannot open the database as > read only. Looks like > I could if the version was 8i. > > Does anybody have any pointers on how I could accomplish this. > > Thanks > > Darren. > > -- > Darren Browett P.Eng This > message was transmitted > Data Administrator using > 100% recycled electrons > Information and Communication Technology > City of Coquitlam > P:(604)927 - 3614 > E:[EMAIL PROTECTED] > > --- > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Version 8 as read only
Looks like that is what we will be doing, basically creating a generic user with read-only privileges. All the current users will have their password changed so they cannot access the system. Darren -Original Message- Sent: Wednesday, November 26, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Darren, Couldn't you just open the database with a user that has all the necessary privileges revoked? -Original Message- Browett, Darren Sent: Wednesday, November 26, 2003 3:44 PM To: Multiple recipients of list ORACLE-L We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was 8i. Does anybody have any pointers on how I could accomplish this. Thanks Darren. -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Version 8 as read only
You can't. Even if you were to set all possible tablespaces to READ ONLY, you'll find that it doesn't prevent folks from dropping objects. All you can do is restrict people to schemas/accounts which do not own any objects and do not have permissions to create any. That way, you can restrict them to CREATE SESSION, ALTER SESSION, and SELECT permissions only. on 11/26/03 4:44 PM, Browett, Darren at [EMAIL PROTECTED] wrote: > We are in the process of upgrading our peoplesoft app, using an oracle > database of > 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 > database as readonly. > > I have read all the doc's but it appears I cannot open the database as > read only. Looks like > I could if the version was 8i. > > Does anybody have any pointers on how I could accomplish this. > > Thanks > > Darren. > > -- > Darren Browett P.Eng This > message was transmitted > Data Administrator using > 100% recycled electrons > Information and Communication Technology > City of Coquitlam > P:(604)927 - 3614 > E:[EMAIL PROTECTED] > > --- > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Version 8 as read only
Darren, Couldn't you just open the database with a user that has all the necessary privileges revoked? -Original Message- Browett, Darren Sent: Wednesday, November 26, 2003 3:44 PM To: Multiple recipients of list ORACLE-L We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was 8i. Does anybody have any pointers on how I could accomplish this. Thanks Darren. -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Oracle Version 8 as read only
We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was 8i. Does anybody have any pointers on how I could accomplish this. Thanks Darren. -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: which oracle9i version is stable
Ends in 4? Unless you are trying to use Heterogeneous Services (HS) under 9.2.0.4 on an AIX 5L system. Then you are waiting for Oracle development to issue a patch. (Not that I am running into this situation or anything. And I'm not bitter :) FYI, 9.2.0.3 is the ONLY 9.2 version for AIX that HS currently works under. Kevin -Original Message- Sent: Thursday, October 30, 2003 12:30 PM To: Multiple recipients of list ORACLE-L With Oracle, quality always ends with the number 4. 6.0.38.4 7.3.4 8.1.7.4 9.2.0.4 Mladen Gogala <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> .net>cc: Sent by: Subject: Re: which oracle9i version is stable [EMAIL PROTECTED] .com 10/30/2003 04:54 AM Please respond to ORACLE-L In my experience, 9.2.0.4 is the best one so far. I don't think that you should be chosing versions based on 7.3.4 connectivity. On 2003.10.30 06:09, Jeroen van Sluisdam wrote: > Hi, > > I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because > we want to be able to connect with this version to oracle 7.3.4 db. > We started with 9.2 but found a known bug which prevented to connect to > oracle7.3.4. Any advice on which version of 9i to go to will be appreciated. > > Thnx, > > Jeroen > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Kevin Toepke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: which oracle9i version is stable
With Oracle, quality always ends with the number 4. 6.0.38.4 7.3.4 8.1.7.4 9.2.0.4 Mladen Gogala <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> .net>cc: Sent by: Subject: Re: which oracle9i version is stable [EMAIL PROTECTED] .com 10/30/2003 04:54 AM Please respond to ORACLE-L In my experience, 9.2.0.4 is the best one so far. I don't think that you should be chosing versions based on 7.3.4 connectivity. On 2003.10.30 06:09, Jeroen van Sluisdam wrote: > Hi, > > I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because > we want to be able to connect with this version to oracle 7.3.4 db. > We started with 9.2 but found a known bug which prevented to connect to > oracle7.3.4. Any advice on which version of 9i to go to will be appreciated. > > Thnx, > > Jeroen > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: which oracle9i version is stable
There is no version of 32 bit Oracle 9i for HP-UX 11. You have to use 64 bit Oracle binaries for HP Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Thu, 30 Oct 2003 06:49:25 -0800 I forgot to mention we will be running hp-ux11.11 64 bit, plan to run oracle also on 64 bit Jeroen -Oorspronkelijk bericht- Van: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED] Verzonden: Thursday, October 30, 2003 12:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: which oracle9i version is stable Hi, I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because we want to be able to connect with this version to oracle 7.3.4 db. We started with 9.2 but found a known bug which prevented to connect to oracle7.3.4. Any advice on which version of 9i to go to will be appreciated. Thnx, Jeroen _ Never get a busy signal because you are always connected with high-speed Internet access. Click here to comparison-shop providers. https://broadband.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: which oracle9i version is stable
I forgot to mention we will be running hp-ux11.11 64 bit, plan to run oracle also on 64 bit Jeroen -Oorspronkelijk bericht- Van: Jeroen van Sluisdam [mailto:[EMAIL PROTECTED] Verzonden: Thursday, October 30, 2003 12:09 Aan: Multiple recipients of list ORACLE-L Onderwerp: which oracle9i version is stable Hi, I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because we want to be able to connect with this version to oracle 7.3.4 db. We started with 9.2 but found a known bug which prevented to connect to oracle7.3.4. Any advice on which version of 9i to go to will be appreciated. Thnx, Jeroen
Re: which oracle9i version is stable
RH Linux 8.0 with 2.4.22 kernel built manually. On 10/30/2003 09:29:25 AM, laura pena wrote: > What platform are you running 9.2.0.4? > > Thanks > > Mladen Gogala <[EMAIL PROTECTED]> wrote: > In my experience, 9.2.0.4 is the best one so far. I don't think that you > should be chosing versions based on 7.3.4 connectivity. > > On 2003.10.30 06:09, Jeroen van Sluisdam wrote: > > Hi, > > > > I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because > > we want to be able to connect with this version to oracle 7.3.4 db. > > We started with 9.2 but found a known bug which prevented to connect to > > oracle7.3.4. Any advice on which version of 9i to go to will be appreciated. > > > > Thnx, > > > > Jeroen > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > - > 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). > > - > Do you Yahoo!? > Exclusive Video Premiere - Britney Spears Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: which oracle9i version is stable
What platform are you running 9.2.0.4? Thanks Mladen Gogala <[EMAIL PROTECTED]> wrote: In my experience, 9.2.0.4 is the best one so far. I don't think that you should be chosing versions based on 7.3.4 connectivity.On 2003.10.30 06:09, Jeroen van Sluisdam wrote:> Hi,> > I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because> we want to be able to connect with this version to oracle 7.3.4 db.> We started with 9.2 but found a known bug which prevented to connect to> oracle7.3.4. Any advice on which version of 9i to go to will be appreciated.> > Thnx,> > Jeroen>-- Mladen GogalaOracle DBA-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mladen GogalaINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? Exclusive Video Premiere - Britney Spears
Re: which oracle9i version is stable
In my experience, 9.2.0.4 is the best one so far. I don't think that you should be chosing versions based on 7.3.4 connectivity. On 2003.10.30 06:09, Jeroen van Sluisdam wrote: Hi, I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because we want to be able to connect with this version to oracle 7.3.4 db. We started with 9.2 but found a known bug which prevented to connect to oracle7.3.4. Any advice on which version of 9i to go to will be appreciated. Thnx, Jeroen -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
which oracle9i version is stable
Hi, I'm planning a migration to oracle9i. We are testing on 9.0.1.0 because we want to be able to connect with this version to oracle 7.3.4 db. We started with 9.2 but found a known bug which prevented to connect to oracle7.3.4. Any advice on which version of 9i to go to will be appreciated. Thnx, Jeroen
Re: how to find the installed version of oracle??
Hi Try looking in the $ORACLE_BASE/oraInstaller/installerActions.log (the file name is from memory, i am sure you will find it). Parse the file and all of the installed versions are listed towards the end. Also you can search the oraInventory directory, there is a sub-directory for each component with sub-directories for each version. You could connect to the database and query v$version. This issue was discussed recently (in the last few months) either in this group or the ORACLE-L list, search google for more info. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Patch Set 3 Version 9.2.0.4.0 for Linux x86 that makes use of a buffer overflow
Hi, is there any workaround concerning this: http://packetstormsecurity.nl/filedesc/oracle_ownage.c.html TIA gbWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger
RE: db version control - schemas, code
Title: RE: db version control - schemas, code I forgot to add to this message, I have requested permission to forward this presentation to others. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED]We have enough youth.How about a fountain of intelligence? -Original Message-From: Adams, Matthew (GECP, MABG, 088130) Sent: Thursday, October 16, 2003 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: db version control - schemas, code there was an excellent presentation by Mark Stock at SEOUC 2002 called Tag! Whose Code is it? about embedding versioning inside of Oracle objects. I'm reluctant to send it without getting approval from the copyright holder, but the authors e-mail address is [EMAIL PROTECTED] Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- From: Yosi Greenfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 16, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: db version control - schemas, code Hi All, Client would like me to propose a solution for managing schemas and code in their databases. There are several developers, each making changes to their own schema, and then there's test, qa, and production. There are both schema changes and code changes. Mostly schema changes though. Client would like software (scripts and/or packaged sw) AND a methodology. I've looked at the specs for Oracle Change Manager. Any experiences with that? Can anyone recommend a methodology and/or sw for this? Or articles/books? Thanks, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: db version control - schemas, code
Title: RE: db version control - schemas, code It's on their website, and it does look excellent. Thanks for the tip. Anyone ever use OEM Change Manager? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, October 16, 2003 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: db version control - schemas, code there was an excellent presentation by Mark Stock at SEOUC 2002 called Tag! Whose Code is it? about embedding versioning inside of Oracle objects. I'm reluctant to send it without getting approval from the copyright holder, but the authors e-mail address is [EMAIL PROTECTED] Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- From: Yosi Greenfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 16, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: db version control - schemas, code Hi All, Client would like me to propose a solution for managing schemas and code in their databases. There are several developers, each making changes to their own schema, and then there's test, qa, and production. There are both schema changes and code changes. Mostly schema changes though. Client would like software (scripts and/or packaged sw) AND a methodology. I've looked at the specs for Oracle Change Manager. Any experiences with that? Can anyone recommend a methodology and/or sw for this? Or articles/books? Thanks, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: db version control - schemas, code
There is a toll "schema manager " by quest . Have a look at that as well. I haven't used it though. -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 10:24 AM > Hi All, > > Client would like me to propose a solution for managing > schemas and code in their databases. There are several > developers, each making changes to their own schema, and > then there's test, qa, and production. > > There are both schema changes and code changes. Mostly > schema changes though. > > Client would like software (scripts and/or packaged sw) > AND a methodology. I've looked at the specs for Oracle > Change Manager. Any experiences with that? > > Can anyone recommend a methodology and/or sw for this? > Or articles/books? > > Thanks, > > Yosi > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yosi Greenfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: db version control - schemas, code
Title: RE: db version control - schemas, code there was an excellent presentation by Mark Stock at SEOUC 2002 called Tag! Whose Code is it? about embedding versioning inside of Oracle objects. I'm reluctant to send it without getting approval from the copyright holder, but the authors e-mail address is [EMAIL PROTECTED] Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- From: Yosi Greenfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 16, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: db version control - schemas, code Hi All, Client would like me to propose a solution for managing schemas and code in their databases. There are several developers, each making changes to their own schema, and then there's test, qa, and production. There are both schema changes and code changes. Mostly schema changes though. Client would like software (scripts and/or packaged sw) AND a methodology. I've looked at the specs for Oracle Change Manager. Any experiences with that? Can anyone recommend a methodology and/or sw for this? Or articles/books? Thanks, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: db version control - schemas, code
There is a company called Merant (www.merant.com) which is a maker of change management tool called PVCS. They have module for Oracle, which can compare schemas as well as store fmb files. As fo the methodology, company documentation is marked with "company confidential", which means that I'm not allowed to reveal its contents. On 10/16/2003 01:24:25 PM, Yosi Greenfield wrote: Hi All, Client would like me to propose a solution for managing schemas and code in their databases. There are several developers, each making changes to their own schema, and then there's test, qa, and production. There are both schema changes and code changes. Mostly schema changes though. Client would like software (scripts and/or packaged sw) AND a methodology. I've looked at the specs for Oracle Change Manager. Any experiences with that? Can anyone recommend a methodology and/or sw for this? Or articles/books? Thanks, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
db version control - schemas, code
Hi All, Client would like me to propose a solution for managing schemas and code in their databases. There are several developers, each making changes to their own schema, and then there's test, qa, and production. There are both schema changes and code changes. Mostly schema changes though. Client would like software (scripts and/or packaged sw) AND a methodology. I've looked at the specs for Oracle Change Manager. Any experiences with that? Can anyone recommend a methodology and/or sw for this? Or articles/books? Thanks, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
how to find the installed version of oracle??
Hi all, how do I find out the exact version of oracle installed (including the service pack). The server machine has Linux on it. Would like to do this programatically (using a shell script or C code). Thanks in advance. ShivaM DISCLAIMER: This e-mail contains proprietary information some or all of which may be legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail. If you are not the intended recipient, you must not use, save, disclose, distribute, copy, print or relay this e-mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shiva Maran INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ** how to check version and problems
Another way to is to install the 'opatch' utility (needs Perl;) and use 'opatch lsinventory'. - Kirti --- Pete Finnigan <[EMAIL PROTECTED]> wrote: > Hi, > > have a look at $ORACLE_BASE/oraInventory/logs/installActions.log. > hth > > kind regards > > Pete > -- > Pete Finnigan > email:[EMAIL PROTECTED] > Web site: http://www.petefinnigan.com - Oracle security audit specialists > Book:Oracle security step-by-step Guide - see http://store.sans.org for details. > > __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ** how to check version and problems
Hi, have a look at $ORACLE_BASE/oraInventory/logs/installActions.log. hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ** how to check version and problems
If you know about install.log, you should be easily able to find the version of installation from there. If no problem was reported during the installation then obviously the installation went fine. Regards Naveen -Original Message-From: A Joshi [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 11:35 PMTo: Multiple recipients of list ORACLE-LSubject: ** how to check version and problems Hi, How can I check the version for a installation without going into sqlplus. And to check if there are any problems with installation is it enough to check the install.log. Thank you. Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design softwareDISCLAIMER:This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.
** how to check version and problems
Hi, How can I check the version for a installation without going into sqlplus. And to check if there are any problems with installation is it enough to check the install.log. Thank you. Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: OAS version for Oracle8i
Thanks... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 7:14 PM > iAS or OAS 4.0.8.x? > > OAS came after OWS 3.0.1. > > The products work with previous versions of the db usually, but here is a > list of roughly what database was "current" at the time each web server was > released. > > OWS -- Oracle 7.3, last release was 7.3.4 > OAS -- Oracle 8.0, last release was 8.0.6 > iAS 1.0.2.x -- Oracle 8i, last release was 8.1.7. > iAS 9.0.2 -- Oracle 9i Release 2, last release is 9.0.2 > > The product compatibility matrix in Metalink is much more precise. > > Usually the "terminal" release is the more stable one per version. > > Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: setiady INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: OAS version for Oracle8i
iAS or OAS 4.0.8.x? OAS came after OWS 3.0.1. The products work with previous versions of the db usually, but here is a list of roughly what database was "current" at the time each web server was released. OWS -- Oracle 7.3, last release was 7.3.4 OAS -- Oracle 8.0, last release was 8.0.6 iAS 1.0.2.x -- Oracle 8i, last release was 8.1.7. iAS 9.0.2 -- Oracle 9i Release 2, last release is 9.0.2 The product compatibility matrix in Metalink is much more precise. Usually the "terminal" release is the more stable one per version. Patrice. -Original Message- Sent: Tuesday, July 22, 2003 7:44 AM To: Multiple recipients of list ORACLE-L Dear all, I am new to Oracle and I am trying to install OAS. Currently, I have Oracle8i personal edition on my PC and I would like to install OAS... but I can't figure out which version is suitable for the database.. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: setiady INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
OAS version for Oracle8i
Dear all, I am new to Oracle and I am trying to install OAS. Currently, I have Oracle8i personal edition on my PC and I would like to install OAS... but I can't figure out which version is suitable for the database.. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: setiady INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Using the 9i version of UTL_HTTP in 8i
Okay, I got the answer to the question - I tried compiling the 9i utl_http package in an 8i test database, and it failed conclusively. Any other options for using the HTTP 'POST' method in 8i? Thanks & regards, -Original Message- Sent: Thursday, July 17, 2003 12:04 PM To: [EMAIL PROTECTED] Dear all, Database: Oracle 8.1.7.4 Enterprise OS: HP-UX 11 We want to implement a stored proc that would send data to an http:// url using 'POST' method. The UTL_HTTP package in 8i doesn't support the POST method, while that in 9i does. We are now considering two options: 1. Install the 9i version of the package in the 8i database. If it works, this would be good, because we are planning to upgrade before 2004. 2. Use the code provided by Tom Kyte (with some modifications) in 'Oracle Expert one-on-one'. Will the 9i version of UTL_HTTP run without any trouble in 8i? How safe it is to do so? Will licensing be an issue here? Thanks & regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Using the 9i version of UTL_HTTP in 8i
Dear all, Database: Oracle 8.1.7.4 Enterprise OS: HP-UX 11 We want to implement a stored proc that would send data to an http:// url using 'POST' method. The UTL_HTTP package in 8i doesn't support the POST method, while that in 9i does. We are now considering two options: 1. Install the 9i version of the package in the 8i database. If it works, this would be good, because we are planning to upgrade before 2004. 2. Use the code provided by Tom Kyte (with some modifications) in 'Oracle Expert one-on-one'. Will the 9i version of UTL_HTTP run without any trouble in 8i? How safe it is to do so? Will licensing be an issue here? Thanks & regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: version control for pl/sql dev forms etc.
There is another product called "EDBA(Enterprise DBA)" by Platinum technology currently CA, which does the version control and comparison. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 16, 2003 7:13 AM > Rahul, > I believe you have just described Oracle Software Configuration Manager (SCM) for the Oracle Repository. It allows comparison of two forms or reports, also modules, tables, entities etc. It's versioning is at the object level and it's rigorous. Maggie > > Respectfully, > > Maggie Tompkins - DCII Integration > > Technology Services Organization - Kansas City > > Defense Finance and Accounting Service > > 816-926-1117 (DSN 465); [EMAIL PROTECTED] > > Back to the Beach! - ODTUG Conference > Loews Miami Beach Hotel, June 22-27 > Visit www.odtug.com for details. > > > -Original Message- > Sent: Monday, June 16, 2003 2:39 AM > To: Multiple recipients of list ORACLE-L > > > List, we are looking for a version control software for our application > code. All the code is > developed using dev6i, pl/sql. is there a product focused towards oracle > tools ? we are looking for > something which can compare two forms or reports!! and provide basic > check-in-out facility > > TIA > Rahul > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: rahul sharma > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net > -- > Author: TOMPKINS, MARGARET > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Arun Annamalai INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: version control for pl/sql dev forms etc.
Title: RE: version control for pl/sql dev forms etc. Oracle SCM 9i Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: rahul sharma [mailto:[EMAIL PROTECTED]] Sent: Monday, June 16, 2003 3:39 AM To: Multiple recipients of list ORACLE-L Subject: version control for pl/sql dev forms etc. List, we are looking for a version control software for our application code. All the code is developed using dev6i, pl/sql. is there a product focused towards oracle tools ? we are looking for something which can compare two forms or reports!! and provide basic check-in-out facility TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: version control for pl/sql dev forms etc.
Rahul, I believe you have just described Oracle Software Configuration Manager (SCM) for the Oracle Repository. It allows comparison of two forms or reports, also modules, tables, entities etc. It's versioning is at the object level and it's rigorous. Maggie Respectfully, > Maggie Tompkins - DCII Integration > Technology Services Organization - Kansas City > Defense Finance and Accounting Service > 816-926-1117 (DSN 465); [EMAIL PROTECTED] Back to the Beach! - ODTUG Conference Loews Miami Beach Hotel, June 22-27 Visit www.odtug.com for details. -Original Message- Sent: Monday, June 16, 2003 2:39 AM To: Multiple recipients of list ORACLE-L List, we are looking for a version control software for our application code. All the code is developed using dev6i, pl/sql. is there a product focused towards oracle tools ? we are looking for something which can compare two forms or reports!! and provide basic check-in-out facility TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: TOMPKINS, MARGARET INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
version control for pl/sql dev forms etc.
List, we are looking for a version control software for our application code. All the code is developed using dev6i, pl/sql. is there a product focused towards oracle tools ? we are looking for something which can compare two forms or reports!! and provide basic check-in-out facility TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Urgent: Need Oradim.exe for version 8.1.6
Thanx Jared, I have got the file, multiple times :-) Thanx for taking care to zipping it and sending it again, as the .exe one was quarantined by the email server. Its working now. Regards Naveen > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2003 6:09 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Urgent: Need Oradim.exe for version 8.1.6 > > > Crud! > > Sorry, replied twice to the list when I shouldn't have. > > D'oh! > > Jared > > > > > > "Naveen Nahata" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 06/11/2003 07:24 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Urgent: Need Oradim.exe for version 8.1.6 > > > I need the Oradim.exe for version 8.1.6 as its got corrupted. > > Can someone please zip it and send it to me? > > Regards > Naveen > > > -Original Message- > > From: Mark Richard [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, June 11, 2003 9:15 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: sql query optimization > > > > > > > > Hi, > > > > From what you have said the cost of distinct and the function call > > shouldn't be a big deal. I did wonder if you can use > > to_number with an > > appropriate mask to avoid the function call but it's > probably not even > > worth bothering. > > > > Simplifying the connect by sub-query will hopefully provide > > the boost you > > need. The concatenated index relates to my uncertainty about > > how Oracle > > can use them for recursive SQL. I did a simple test - creating the > > following indexes: > > > > 1) Unique index on child > > 2) Non-unique index on parent > > 3) Unique index on parent, child > > 4) Unique index on child, parent > > > > The table only had a handful of rows but Oracle chose to use > > index 1 and > > index 3 for the query instead of index 2. On a table of > > significant volume > > (I used to work on very large recursive SQL statements at > one point) I > > would suggest testing the indexing combinations to see what > > Oracle likes - > > then remove the rest. Also, the requirements are different > if you are > > traversing the tree in both directions - you seem to only be > > going down the > > tree. > > > > Good luck. > > > > > > > > > > > > > > Guang Mei > > > > > > <[EMAIL PROTECTED]>To: > > Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > > Sent by: cc: > > > > > > [EMAIL PROTECTED]Subject: Re: > > sql query optimization > > > > .com > > > > > > > > > > > > > > > > > > 11/06/2003 12:34 > > > > > > Please respond to > > > > > > ORACLE-L > > > > > > > > > > > > > > > > > > > > > > > > > > I just looked: > > > > [EMAIL PROTECTED]> select count(*) from arc where arctype in > > (299,300); > > > > COUNT(*) > > -- > > 56932 > > > > This is about 27% of the total rows, so I will test to move > > them into a > > new table tomorrow and this should help. I did test each part > > separatley > > and timed them and I found that the sub-query is probably the > > bottle-neck > > because > > "start ... connect by ..." requires walk the whole index to get all > > possible nodes > > (expensive). I can create this new table. > > > > > > > 2) Consider a concatenated index (perhaps termid, parenttermid or > > > parenttermid,termid - too early for my brain to remember > > without trying) > > > > > > > I don't know why concatenated index would help here, for > which part in > > where clause it would? > > > > > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>
Re: Urgent: Need Oradim.exe for version 8.1.6
Crud! Sorry, replied twice to the list when I shouldn't have. D'oh! Jared "Naveen Nahata" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/11/2003 07:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Urgent: Need Oradim.exe for version 8.1.6 I need the Oradim.exe for version 8.1.6 as its got corrupted. Can someone please zip it and send it to me? Regards Naveen > -Original Message- > From: Mark Richard [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 11, 2003 9:15 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: sql query optimization > > > > Hi, > > From what you have said the cost of distinct and the function call > shouldn't be a big deal. I did wonder if you can use > to_number with an > appropriate mask to avoid the function call but it's probably not even > worth bothering. > > Simplifying the connect by sub-query will hopefully provide > the boost you > need. The concatenated index relates to my uncertainty about > how Oracle > can use them for recursive SQL. I did a simple test - creating the > following indexes: > > 1) Unique index on child > 2) Non-unique index on parent > 3) Unique index on parent, child > 4) Unique index on child, parent > > The table only had a handful of rows but Oracle chose to use > index 1 and > index 3 for the query instead of index 2. On a table of > significant volume > (I used to work on very large recursive SQL statements at one point) I > would suggest testing the indexing combinations to see what > Oracle likes - > then remove the rest. Also, the requirements are different if you are > traversing the tree in both directions - you seem to only be > going down the > tree. > > Good luck. > > > > > > > Guang Mei > > > <[EMAIL PROTECTED]>To: > Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent by: cc: > > > [EMAIL PROTECTED]Subject: Re: > sql query optimization > > .com > > > > > > > > > 11/06/2003 12:34 > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > I just looked: > > [EMAIL PROTECTED]> select count(*) from arc where arctype in > (299,300); > > COUNT(*) > -- > 56932 > > This is about 27% of the total rows, so I will test to move > them into a > new table tomorrow and this should help. I did test each part > separatley > and timed them and I found that the sub-query is probably the > bottle-neck > because > "start ... connect by ..." requires walk the whole index to get all > possible nodes > (expensive). I can create this new table. > > > > 2) Consider a concatenated index (perhaps termid, parenttermid or > > parenttermid,termid - too early for my brain to remember > without trying) > > > > I don't know why concatenated index would help here, for which part in > where clause it would? > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> >Privileged/Confidential information may be contained in > this message. > If you are not the addressee indicated in this message >(or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly > notify the sender >by reply e-mail or by telephone on (61 3) 9612-6999. >Please advise immediately if you or your employer does not > consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>&
Re: Urgent: Need Oradim.exe for version 8.1.6
Oops, here it is again, zipped this time. I realized after sending the last one your email may filter out exe files. And then I realized I sent it to the list instead of you. Jared "Naveen Nahata" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/11/2003 07:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Urgent: Need Oradim.exe for version 8.1.6 I need the Oradim.exe for version 8.1.6 as its got corrupted. Can someone please zip it and send it to me? Regards Naveen > -Original Message- > From: Mark Richard [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 11, 2003 9:15 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: sql query optimization > > > > Hi, > > From what you have said the cost of distinct and the function call > shouldn't be a big deal. I did wonder if you can use > to_number with an > appropriate mask to avoid the function call but it's probably not even > worth bothering. > > Simplifying the connect by sub-query will hopefully provide > the boost you > need. The concatenated index relates to my uncertainty about > how Oracle > can use them for recursive SQL. I did a simple test - creating the > following indexes: > > 1) Unique index on child > 2) Non-unique index on parent > 3) Unique index on parent, child > 4) Unique index on child, parent > > The table only had a handful of rows but Oracle chose to use > index 1 and > index 3 for the query instead of index 2. On a table of > significant volume > (I used to work on very large recursive SQL statements at one point) I > would suggest testing the indexing combinations to see what > Oracle likes - > then remove the rest. Also, the requirements are different if you are > traversing the tree in both directions - you seem to only be > going down the > tree. > > Good luck. > > > > > > > Guang Mei > > > <[EMAIL PROTECTED]>To: > Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent by: cc: > > > [EMAIL PROTECTED]Subject: Re: > sql query optimization > > .com > > > > > > > > > 11/06/2003 12:34 > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > I just looked: > > [EMAIL PROTECTED]> select count(*) from arc where arctype in > (299,300); > > COUNT(*) > -- > 56932 > > This is about 27% of the total rows, so I will test to move > them into a > new table tomorrow and this should help. I did test each part > separatley > and timed them and I found that the sub-query is probably the > bottle-neck > because > "start ... connect by ..." requires walk the whole index to get all > possible nodes > (expensive). I can create this new table. > > > > 2) Consider a concatenated index (perhaps termid, parenttermid or > > parenttermid,termid - too early for my brain to remember > without trying) > > > > I don't know why concatenated index would help here, for which part in > where clause it would? > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> >Privileged/Confidential information may be contained in > this message. > If you are not the addressee indicated in this message >(or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly > notify the sender >by reply e-mail or by telephone on (61 3) 9612-6999. >Please advise immediately if you or your employer does not > consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<&
Re: Urgent: Need Oradim.exe for version 8.1.6
Here si oradim for 8.1..6.3 if you still need it. Jared "Naveen Nahata" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/11/2003 07:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Urgent: Need Oradim.exe for version 8.1.6 I need the Oradim.exe for version 8.1.6 as its got corrupted. Can someone please zip it and send it to me? Regards Naveen > -Original Message- > From: Mark Richard [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 11, 2003 9:15 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: sql query optimization > > > > Hi, > > From what you have said the cost of distinct and the function call > shouldn't be a big deal. I did wonder if you can use > to_number with an > appropriate mask to avoid the function call but it's probably not even > worth bothering. > > Simplifying the connect by sub-query will hopefully provide > the boost you > need. The concatenated index relates to my uncertainty about > how Oracle > can use them for recursive SQL. I did a simple test - creating the > following indexes: > > 1) Unique index on child > 2) Non-unique index on parent > 3) Unique index on parent, child > 4) Unique index on child, parent > > The table only had a handful of rows but Oracle chose to use > index 1 and > index 3 for the query instead of index 2. On a table of > significant volume > (I used to work on very large recursive SQL statements at one point) I > would suggest testing the indexing combinations to see what > Oracle likes - > then remove the rest. Also, the requirements are different if you are > traversing the tree in both directions - you seem to only be > going down the > tree. > > Good luck. > > > > > > > Guang Mei > > > <[EMAIL PROTECTED]>To: > Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent by: cc: > > > [EMAIL PROTECTED]Subject: Re: > sql query optimization > > .com > > > > > > > > > 11/06/2003 12:34 > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > I just looked: > > [EMAIL PROTECTED]> select count(*) from arc where arctype in > (299,300); > > COUNT(*) > -- > 56932 > > This is about 27% of the total rows, so I will test to move > them into a > new table tomorrow and this should help. I did test each part > separatley > and timed them and I found that the sub-query is probably the > bottle-neck > because > "start ... connect by ..." requires walk the whole index to get all > possible nodes > (expensive). I can create this new table. > > > > 2) Consider a concatenated index (perhaps termid, parenttermid or > > parenttermid,termid - too early for my brain to remember > without trying) > > > > I don't know why concatenated index would help here, for which part in > where clause it would? > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> >Privileged/Confidential information may be contained in > this message. > If you are not the addressee indicated in this message >(or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly > notify the sender >by reply e-mail or by telephone on (61 3) 9612-6999. >Please advise immediately if you or your employer does not > consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>> >
RE: Urgent: Need Oradim.exe for version 8.1.6
O/S ? 32 bit or 64 bit?? John -Original Message- Sent: 11 June 2003 15:25 To: Multiple recipients of list ORACLE-L I need the Oradim.exe for version 8.1.6 as its got corrupted. Can someone please zip it and send it to me? Regards Naveen > -Original Message- > From: Mark Richard [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 11, 2003 9:15 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: sql query optimization > > > > Hi, > > From what you have said the cost of distinct and the function call > shouldn't be a big deal. I did wonder if you can use > to_number with an > appropriate mask to avoid the function call but it's probably not even > worth bothering. > > Simplifying the connect by sub-query will hopefully provide > the boost you > need. The concatenated index relates to my uncertainty about > how Oracle > can use them for recursive SQL. I did a simple test - creating the > following indexes: > > 1) Unique index on child > 2) Non-unique index on parent > 3) Unique index on parent, child > 4) Unique index on child, parent > > The table only had a handful of rows but Oracle chose to use > index 1 and > index 3 for the query instead of index 2. On a table of > significant volume > (I used to work on very large recursive SQL statements at one point) I > would suggest testing the indexing combinations to see what > Oracle likes - > then remove the rest. Also, the requirements are different if you are > traversing the tree in both directions - you seem to only be > going down the > tree. > > Good luck. > > > > > > > Guang Mei > > > <[EMAIL PROTECTED]>To: > Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent by: cc: > > > [EMAIL PROTECTED]Subject: Re: > sql query optimization > > .com > > > > > > > > > 11/06/2003 12:34 > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > I just looked: > > [EMAIL PROTECTED]> select count(*) from arc where arctype in > (299,300); > > COUNT(*) > -- > 56932 > > This is about 27% of the total rows, so I will test to move > them into a > new table tomorrow and this should help. I did test each part > separatley > and timed them and I found that the sub-query is probably the > bottle-neck > because > "start ... connect by ..." requires walk the whole index to get all > possible nodes > (expensive). I can create this new table. > > > > 2) Consider a concatenated index (perhaps termid, parenttermid or > > parenttermid,termid - too early for my brain to remember > without trying) > > > > I don't know why concatenated index would help here, for which part in > where clause it would? > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>>
Urgent: Need Oradim.exe for version 8.1.6
I need the Oradim.exe for version 8.1.6 as its got corrupted. Can someone please zip it and send it to me? Regards Naveen > -Original Message- > From: Mark Richard [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 11, 2003 9:15 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: sql query optimization > > > > Hi, > > From what you have said the cost of distinct and the function call > shouldn't be a big deal. I did wonder if you can use > to_number with an > appropriate mask to avoid the function call but it's probably not even > worth bothering. > > Simplifying the connect by sub-query will hopefully provide > the boost you > need. The concatenated index relates to my uncertainty about > how Oracle > can use them for recursive SQL. I did a simple test - creating the > following indexes: > > 1) Unique index on child > 2) Non-unique index on parent > 3) Unique index on parent, child > 4) Unique index on child, parent > > The table only had a handful of rows but Oracle chose to use > index 1 and > index 3 for the query instead of index 2. On a table of > significant volume > (I used to work on very large recursive SQL statements at one point) I > would suggest testing the indexing combinations to see what > Oracle likes - > then remove the rest. Also, the requirements are different if you are > traversing the tree in both directions - you seem to only be > going down the > tree. > > Good luck. > > > > > > > Guang Mei > > > <[EMAIL PROTECTED]>To: > Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent by: cc: > > > [EMAIL PROTECTED]Subject: Re: > sql query optimization > > .com > > > > > > > > > 11/06/2003 12:34 > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > I just looked: > > [EMAIL PROTECTED]> select count(*) from arc where arctype in > (299,300); > > COUNT(*) > -- > 56932 > > This is about 27% of the total rows, so I will test to move > them into a > new table tomorrow and this should help. I did test each part > separatley > and timed them and I found that the sub-query is probably the > bottle-neck > because > "start ... connect by ..." requires walk the whole index to get all > possible nodes > (expensive). I can create this new table. > > > > 2) Consider a concatenated index (perhaps termid, parenttermid or > > parenttermid,termid - too early for my brain to remember > without trying) > > > > I don't know why concatenated index would help here, for which part in > where clause it would? > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>> > >>>>>>>>>>>>>>>>>> >Privileged/Confidential information may be contained in > this message. > If you are not the addressee indicated in thi
Re: Oracle Client Software Version
You can still use the 8i client. You _should_ plan and start upgrading your clients to 9i. If you were running TAF in 8iOPS, you should test TAF between the 8iclients and 9iRAC -- although it does work. Hemant At 01:15 PM 10-03-03 -0800, you wrote: We are in the process of moving from 8/8i to 9i RAC, and we have an 8i client installed on all our P.C's (600+) I have tested the 8i client against the 9i database and for a quick login/browse through the application(s) it seems to work with no problems. My question is, should I stay with the 8i client, or should I move to the 9i client before I upgrade/migrate the databases. Is there issues with regards to the client being out of sync with the database. Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Hemant K Chitale My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Oracle Client Software Version
We are in the process of moving from 8/8i to 9i RAC, and we have an 8i client installed on all our P.C's (600+) I have tested the 8i client against the 9i database and for a quick login/browse through the application(s) it seems to work with no problems. My question is, should I stay with the 8i client, or should I move to the 9i client before I upgrade/migrate the databases. Is there issues with regards to the client being out of sync with the database. Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: FW: oracle version
did u try the inventory logs ? Babu kommareddy sreenivasa To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED]cc: om> Subject: Re: FW: oracle version Sent by: [EMAIL PROTECTED] 03/05/03 01:09 PM Please respond to ORACLE-L Hi, I need it to check from O/S level. not from database level. can somebody give any hints. Thanks and Regards, Srinivas > > -Original Message- > From: Hatzistavrou John > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 05, 2003 3:19 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: oracle version > > > From sql : select * from product_component_version; > It can either be shown when logging into sqlplus > (check the headers). > > Kind Regards, > > > Hatzistavrou Yannis > Database Administrator > SchlumbergerSema > Phone ext. 478 > Email: [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, March 05, 2003 9:49 AM > To: Multiple recipients of list ORACLE-L > > Hello All, > > OS: Solaris > DB: Oracle > > Can somebody tell me how to know in what version or > patchset level the oracle home is ? > > when I go and see in $ORACLE_HOME, I couldn't find > whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some > other. > > How to know exactly at which version the > $ORACLE_HOME > is? > > Thanks and regards, > Srinivas > > __ > Do you Yahoo!? > Yahoo! Tax Center - forms, calculators, tips, more > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: kommareddy sreenivasa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > 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.net > -- > Author: Hatzistavrou John > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > 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 >
Re: FW: oracle version
Hi, I need it to check from O/S level. not from database level. can somebody give any hints. Thanks and Regards, Srinivas > > -Original Message- > From: Hatzistavrou John > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 05, 2003 3:19 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: oracle version > > > From sql : select * from product_component_version; > It can either be shown when logging into sqlplus > (check the headers). > > Kind Regards, > > > Hatzistavrou Yannis > Database Administrator > SchlumbergerSema > Phone ext. 478 > Email: [EMAIL PROTECTED] > > > -Original Message- > Sent: Wednesday, March 05, 2003 9:49 AM > To: Multiple recipients of list ORACLE-L > > Hello All, > > OS: Solaris > DB: Oracle > > Can somebody tell me how to know in what version or > patchset level the oracle home is ? > > when I go and see in $ORACLE_HOME, I couldn't find > whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some > other. > > How to know exactly at which version the > $ORACLE_HOME > is? > > Thanks and regards, > Srinivas > > __ > Do you Yahoo!? > Yahoo! Tax Center - forms, calculators, tips, more > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: kommareddy sreenivasa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > 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.net > -- > Author: Hatzistavrou John > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > 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). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version
select banner from sys.v_$version; will give u the version number santosh -Original Message- sreenivasa Sent: Wednesday, March 05, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version
>From sql : select * from product_component_version; It can either be shown when logging into sqlplus (check the headers). Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 05, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
oracle version
Hello All, OS: Solaris DB: Oracle Can somebody tell me how to know in what version or patchset level the oracle home is ? when I go and see in $ORACLE_HOME, I couldn't find whether it is 8.1.7.3 , 8.1.7.4 or 8.1.7.0 or some other. How to know exactly at which version the $ORACLE_HOME is? Thanks and regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
My inventory logs (19 files, 16.6 MB) do have a verbose record of OUI actions. Note: all the installation logs can be deleted to clean up space. Also, the inventory logs only record OUI actions. The Oracle 8.1.7.4.6 patch installation does not use OUI (the DBA manually copies many files into the Oracle Home), which does cause a mismatch between the inventory version and the actual version installed. On the OUI opening screen, the "Installed Products..." button can be used to display the current inventory. Thus, I was looking in the inventory folder trying to guess what OUI is using. Looking again, I found some more interesting folders: N:\Oracle\Inventory\PatchSets\oracle.server\8.1.7.4.1\1\resources N:\Oracle\Inventory\PatchSets\oracle.server\9.0.1.4.0\1\resources N:\Oracle\Inventory\PatchSets\oracle.server\9.2.0.2.1\1\resources The inventory folders does provide a way to quickly get an idea of the oracle server version(s) installed by OUI. Use the inst_loc registry key to find the inventory location, then look for "oracle.server" within "Components" and "PatchSets"; the included folders have the version numbers. Have Fun :) Rajesh Dayal wrote: Hi Chip, I am talking of log directory(N:\Oracle\Inventory\logs and not N:\Oracle\Inventory\components), where every Installer action is logged and not . This doesn't matter whether your Oracle.exe is replaced or not. All of your OUI actions will be logged with all the relevant information and typically the file names are of following format. installActions2003-01-21_12-01-02PM.log So if you put little extra effort digging these files (depending on size, timestamp etc.) you can find out what is last activity you performed on what ORACLE_HOME and so the precise patch level is also available there... And that YP-ZP I mean XP, I would really hate to see a Oracle Database on that ;-)... Cheers, Rajesh -Original Message- Sent: Thursday, February 27, 2003 11:59 AM To: Multiple recipients of list ORACLE-L In the registry "My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc" specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have no record of the patch (e.g. 8.1.7.4.6). Inside the inventory folder, "Components" and "Patches" have folders for components installed by OUI. For example, my inventory folder contains these folders: N:\Oracle\Inventory\Components\oracle.server\8.1.7.0.0\1\resources N:\Oracle\Inventory\Components\oracle.server\9.0.1.1.1\1\resources N:\Oracle\Inventory\Components\oracle.server\9.2.0.1.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\8.1.7.4.1\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.0.1.4.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.2.0.2.1\1\resources Note: the version numbers (folder names) do match my OUI installation of Oracle servers and patches. When using Windows XP Pro, the properties of oracle.exe is interesting - the version displayed near the top is 0.0.0.0, yet the "File Version" near the bottom of the dialog box does display the correct version. Wonder how Windows XP Pro finds the correct version, while Windows 2000 Pro can't see it. Have Fun :) Rajesh Dayal wrote: Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Chip INET: [EMAIL P
RE: Oracle version??
Hi Chip, I am talking of log directory(N:\Oracle\Inventory\logs and not N:\Oracle\Inventory\components), where every Installer action is logged and not . This doesn't matter whether your Oracle.exe is replaced or not. All of your OUI actions will be logged with all the relevant information and typically the file names are of following format. installActions2003-01-21_12-01-02PM.log So if you put little extra effort digging these files (depending on size, timestamp etc.) you can find out what is last activity you performed on what ORACLE_HOME and so the precise patch level is also available there... And that YP-ZP I mean XP, I would really hate to see a Oracle Database on that ;-)... Cheers, Rajesh -Original Message- Sent: Thursday, February 27, 2003 11:59 AM To: Multiple recipients of list ORACLE-L In the registry "My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc" specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have no record of the patch (e.g. 8.1.7.4.6). Inside the inventory folder, "Components" and "Patches" have folders for components installed by OUI. For example, my inventory folder contains these folders: N:\Oracle\Inventory\Components\oracle.server\8.1.7.0.0\1\resources N:\Oracle\Inventory\Components\oracle.server\9.0.1.1.1\1\resources N:\Oracle\Inventory\Components\oracle.server\9.2.0.1.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\8.1.7.4.1\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.0.1.4.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.2.0.2.1\1\resources Note: the version numbers (folder names) do match my OUI installation of Oracle servers and patches. When using Windows XP Pro, the properties of oracle.exe is interesting - the version displayed near the top is 0.0.0.0, yet the "File Version" near the bottom of the dialog box does display the correct version. Wonder how Windows XP Pro finds the correct version, while Windows 2000 Pro can't see it. Have Fun :) Rajesh Dayal wrote: >Hi Sunil, > The tragedy is that even if you logon to database, you may not find the precise >patch level from database. > The best location is orainventory/log directory. OK on MS machines >C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log >file from this location. > >HTH, >Rajesh >-Original Message- >Sent: Thursday, February 27, 2003 7:09 AM >To: Multiple recipients of list ORACLE-L > >List, > >Can Oracle version be determined based on size of Oracle.EXE file on >Windows? >I am looking for a valid way of determining the patch level without having >to log onto the database and check >v$instance. > >appreciate any feedback. > >Sunil Nookala >Dell Corp. >Austin, TX. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >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.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
>List, > >Can Oracle version be determined based on size of >Oracle.EXE file on >Windows? >I am looking for a valid way of determining the >patch level without having >to log onto the database and check >v$instance. > >appreciate any feedback. > >Sunil Nookala >Dell Corp. >Austin, TX. > What if the only differences are in DLLs ? Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
In the registry "My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\inst_loc" specifies the location of the inventory folder (defaults to C:\Program Files\Oracle\Inventory). Note: some Oracle patches do replace oracle.exe without using the Oracle Universal Installer (OUI) so the inventory would have no record of the patch (e.g. 8.1.7.4.6). Inside the inventory folder, "Components" and "Patches" have folders for components installed by OUI. For example, my inventory folder contains these folders: N:\Oracle\Inventory\Components\oracle.server\8.1.7.0.0\1\resources N:\Oracle\Inventory\Components\oracle.server\9.0.1.1.1\1\resources N:\Oracle\Inventory\Components\oracle.server\9.2.0.1.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\8.1.7.4.1\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.0.1.4.0\1\resources N:\Oracle\Inventory\Patches\oracle.rdbms\9.2.0.2.1\1\resources Note: the version numbers (folder names) do match my OUI installation of Oracle servers and patches. When using Windows XP Pro, the properties of oracle.exe is interesting - the version displayed near the top is 0.0.0.0, yet the "File Version" near the bottom of the dialog box does display the correct version. Wonder how Windows XP Pro finds the correct version, while Windows 2000 Pro can't see it. Have Fun :) Rajesh Dayal wrote: Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Chip INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
I just plugged through a "$ strings oracle" to see if the version information is in there anyplace. On an 8.1.7 kernel, I was surprised to find that version numbers all the way from 8.0.0 through 8.2.0 show up in the file. The string I was really looking for was "Oracle8i Enterprise Edition Release %d.%d.%d.%d.%d %s"--the release number is stored in five separate variables, which are printed through this printf format string... However, there are a couple of tricks you might engage. I just did this on my Linux system and found what version my kernel *thinks* it is: $ strace -s100 oracle 2>&1 | grep "Oracle.*Release" This strace command catches the kernel's write() call of the release number into a background trace file. You could also look at the background trace files if you wanted to conserve the overhead of invoking the oracle executable. The thing exit()s, so I think it's safe to run it this way, but you probably don't want the side effects of extra trace file writing, etc. I think peeking into the trace file is a possible solution for you, but then I'd take the wise advice of people of those on the list who might be able to prove that the kernel can actually lie about its own release number... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - RMOUG Training Days 2003, Mar 5-6 Denver - Hotsos Clinic 101, Mar 25-27 London -Original Message- Dayal Sent: Wednesday, February 26, 2003 11:49 PM To: Multiple recipients of list ORACLE-L Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 version??
Hi Sunil, The tragedy is that even if you logon to database, you may not find the precise patch level from database. The best location is orainventory/log directory. OK on MS machines C:\Program Files\Oracle\Inventory\logs. Go to this directory and check the latest log file from this location. HTH, Rajesh -Original Message- Sent: Thursday, February 27, 2003 7:09 AM To: Multiple recipients of list ORACLE-L List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Oracle version??
List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [Q] how to start "intelegent agent" on ORACLE 9.2 version?
Try %agentctl start Keith H. > -Original Message- > From: dist cash [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 1:39 PM > To: Multiple recipients of list ORACLE-L > Subject: [Q] how to start "intelegent agent" on ORACLE 9.2 version? > > > > We just upgraded the ORACLE from 8.1.7 to 9.2 on SUN server. > I tried to start up the "intelegent agent" on it and have > error happen. > > %lsnrctl dbsnmp_start > > LSNRCTL for Solaris: Version 9.2.0.2.0 - Production on 13-FEB-2003 > 12:14:41 > > Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. > > NL-00853: undefined command "dbsnmp_start". Try "help" > > > > I am pretty sure this command is correct. > > Does anyone know why? > > Thanks. > > > > > _ > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: dist cash > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Henry, Keith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [Q] how to start "intelegent agent" on ORACLE 9.2 version?
try agentctl start -Original Message- Sent: Thursday, February 13, 2003 1:39 PM To: Multiple recipients of list ORACLE-L We just upgraded the ORACLE from 8.1.7 to 9.2 on SUN server. I tried to start up the "intelegent agent" on it and have error happen. %lsnrctl dbsnmp_start LSNRCTL for Solaris: Version 9.2.0.2.0 - Production on 13-FEB-2003 12:14:41 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. NL-00853: undefined command "dbsnmp_start". Try "help" I am pretty sure this command is correct. Does anyone know why? Thanks. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Gorbounov,Vadim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [Q] how to start "intelegent agent" on ORACLE 9.2 version?
Title: RE: [Q] how to start "intelegent agent" on ORACLE 9.2 version? Agentctl start (from the command line...not in lsnrctl) -Original Message- From: dist cash [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Subject: [Q] how to start "intelegent agent" on ORACLE 9.2 version? We just upgraded the ORACLE from 8.1.7 to 9.2 on SUN server. I tried to start up the "intelegent agent" on it and have error happen. %lsnrctl dbsnmp_start LSNRCTL for Solaris: Version 9.2.0.2.0 - Production on 13-FEB-2003 12:14:41 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. NL-00853: undefined command "dbsnmp_start". Try "help" I am pretty sure this command is correct. Does anyone know why? Thanks. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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).
[Q] how to start "intelegent agent" on ORACLE 9.2 version?
We just upgraded the ORACLE from 8.1.7 to 9.2 on SUN server. I tried to start up the "intelegent agent" on it and have error happen. %lsnrctl dbsnmp_start LSNRCTL for Solaris: Version 9.2.0.2.0 - Production on 13-FEB-2003 12:14:41 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. NL-00853: undefined command "dbsnmp_start". Try "help" I am pretty sure this command is correct. Does anyone know why? Thanks. _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Version Controlling in Oracle database - Ideas ?
Title: RE: Version Controlling in Oracle database - Ideas ? Have you checked out Mark Stock's Presentation at the 2002 SEOUC conference entitled: TAG! Whose Code is it? Code Management & Data Encryption Should be available at www.seouc.org. Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Version Controlling in Oracle database - Ideas ? Looking for a solution to version controlling of database objects in Oracle. The scenario is like this: Multiple people simultaneously work on the same database object in TOAD. How can we implement a version controlling feature. Putting this in simple words, If X checks out a file from TOAD and Y needs to work on the same file (assuming they have the same privilege), Y should not be allowed to work on the object till X finishes working on it. We want to put a restriction on the database objects such that simultaneously no two users should be able to work it. Integrating VSS with TOAD was not acceptable since it would be file based(saving the .sqls). Qs. Is there any feature available in Oracle(with oracle 8.1.7) or any third party tool that does this ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: how to find the version ?
i found the solution shortly after i sent the mail.. runinstaller and it will show all the installed product with verions ;-)) On Tue, 11 Feb 2003 00:33:36 -0800, "rahul" <[EMAIL PROTECTED]> wrote : > list, my appologies for asking question regarding ias (solaris), but i > could not find any info regarding this on the net.. > > i'm on solaris, running ias, i'm new to this environment, and have been > asked to audit the setup !! to start, i simply want to find out the version > of forms/reports server !!.. could anyone point out the method ? > thanks and regards > > -rahul > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: rahul > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: how to find the version ?
i found the solution shortly after i sent the mail.. runinstaller and it will show all the installed product with verions ;-)) On Tue, 11 Feb 2003 00:33:36 -0800, "rahul" <[EMAIL PROTECTED]> wrote : > list, my appologies for asking question regarding ias (solaris), but i > could not find any info regarding this on the net.. > > i'm on solaris, running ias, i'm new to this environment, and have been > asked to audit the setup !! to start, i simply want to find out the version > of forms/reports server !!.. could anyone point out the method ? > thanks and regards > > -rahul > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: rahul > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
how to find the version ?
list, my appologies for asking question regarding ias (solaris), but i could not find any info regarding this on the net.. i'm on solaris, running ias, i'm new to this environment, and have been asked to audit the setup !! to start, i simply want to find out the version of forms/reports server !!.. could anyone point out the method ? thanks and regards -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Version Controlling in Oracle database - Ideas ?
This might get a better response from the TOAD development team themselves: http://groups.yahoo.com/group/TOAD http://groups.yahoo.com/group/toadbeta HTH! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, February 07, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Looking for a solution to version controlling of database objects in Oracle. The scenario is like this: Multiple people simultaneously work on the same database object in TOAD. How can we implement a version controlling feature. Putting this in simple words, If X checks out a file from TOAD and Y needs to work on the same file (assuming they have the same privilege), Y should not be allowed to work on the object till X finishes working on it. We want to put a restriction on the database objects such that simultaneously no two users should be able to work it. Integrating VSS with TOAD was not acceptable since it would be file based(saving the .sqls). Qs. Is there any feature available in Oracle(with oracle 8.1.7) or any third party tool that does this ? so send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Version Controlling in Oracle database - Ideas ?
Title: Message There is a product from CA (they got it when they bought out Platinum Technology) called SQL-Station. It is now a part of the Unicenter environment. It provides a cooperative development that includes versioning and deployment options. I've used it in an environment with 15 developers working on various pieces of a system without problems. It does code management through a database repository, and it has a code debugger and analyzer available. Rick Weiss -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 11:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Version Controlling in Oracle database - Ideas ? Is it available in the Market OR is there a special procurement Channel for it ? Any Details please , Links , Docs ? Thanks -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, February 07, 2003 11:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Version Controlling in Oracle database - Ideas ? I believe this feature coming in new TOAD ... its available in Beta though ... I think it is called 'Team Coding ... something' Another product is Oracle SCM ... Raj -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Version Controlling in Oracle database - Ideas ? Looking for a solution to version controlling of database objects in Oracle. The scenario is like this: Multiple people simultaneously work on the same database object in TOAD. How can we implement a version controlling feature. Putting this in simple words, If X checks out a file from TOAD and Y needs to work on the same file (assuming they have the same privilege), Y should not be allowed to work on the object till X finishes working on it. We want to put a restriction on the database objects such that simultaneously no two users should be able to work it. Integrating VSS with TOAD was not acceptable since it would be file based(saving the .sqls). Qs. Is there any feature available in Oracle(with oracle 8.1.7) or any third party tool that does this ? so send the HELP command for other information (like subscribing).
RE: Version Controlling in Oracle database - Ideas ?
Title: RE: Version Controlling in Oracle database - Ideas ? Is it available in the Market OR is there a special procurement Channel for it ? Any Details please , Links , Docs ? Thanks -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, February 07, 2003 11:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Version Controlling in Oracle database - Ideas ? I believe this feature coming in new TOAD ... its available in Beta though ... I think it is called 'Team Coding ... something' Another product is Oracle SCM ... Raj -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Version Controlling in Oracle database - Ideas ? Looking for a solution to version controlling of database objects in Oracle. The scenario is like this: Multiple people simultaneously work on the same database object in TOAD. How can we implement a version controlling feature. Putting this in simple words, If X checks out a file from TOAD and Y needs to work on the same file (assuming they have the same privilege), Y should not be allowed to work on the object till X finishes working on it. We want to put a restriction on the database objects such that simultaneously no two users should be able to work it. Integrating VSS with TOAD was not acceptable since it would be file based(saving the .sqls). Qs. Is there any feature available in Oracle(with oracle 8.1.7) or any third party tool that does this ? so send the HELP command for other information (like subscribing).
RE: Version Controlling in Oracle database - Ideas ?
Title: RE: Version Controlling in Oracle database - Ideas ? I believe this feature coming in new TOAD ... its available in Beta though ... I think it is called 'Team Coding ... something' Another product is Oracle SCM ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Version Controlling in Oracle database - Ideas ? Looking for a solution to version controlling of database objects in Oracle. The scenario is like this: Multiple people simultaneously work on the same database object in TOAD. How can we implement a version controlling feature. Putting this in simple words, If X checks out a file from TOAD and Y needs to work on the same file (assuming they have the same privilege), Y should not be allowed to work on the object till X finishes working on it. We want to put a restriction on the database objects such that simultaneously no two users should be able to work it. Integrating VSS with TOAD was not acceptable since it would be file based(saving the .sqls). Qs. Is there any feature available in Oracle(with oracle 8.1.7) or any third party tool that does this ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Version Controlling in Oracle database - Ideas ?
Looking for a solution to version controlling of database objects in Oracle. The scenario is like this: Multiple people simultaneously work on the same database object in TOAD. How can we implement a version controlling feature. Putting this in simple words, If X checks out a file from TOAD and Y needs to work on the same file (assuming they have the same privilege), Y should not be allowed to work on the object till X finishes working on it. We want to put a restriction on the database objects such that simultaneously no two users should be able to work it. Integrating VSS with TOAD was not acceptable since it would be file based(saving the .sqls). Qs. Is there any feature available in Oracle(with oracle 8.1.7) or any third party tool that does this ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: First version with multiple archiver processes?
No problem, Jeremiah. I never could open Peter's e-mails due to some error stating 'Your Digital ID name can not be found by the underlying security system'. I saw what he posted in your message. I was not aware of this Oracle7 'feature'... Sounds like an un-documented trick :) Thanks, - Kirti -Original Message- Sent: Thursday, February 06, 2003 3:39 AM To: Multiple recipients of list ORACLE-L Sorry Kirti, that was meant for Peter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 6 Feb 2003, Jeremiah Wilton wrote: > Kirti > > In v.7 the archiver is called ARCH. If 'archive log start to xxx' > starts another, what is it called? > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Wed, 5 Feb 2003, Peter Gram wrote: > > > Kirti > > > > From version 7.x you can manually start multiple archive processes by > > using the "archieve log start to " and the added > > processes wil die when there is no more redofiles to archive, but for > > permanent having multiple processes the answer is 8.1.3 :-) > > > > Deshpande, Kirti wrote: > > > > >I can think of 8.1.3. > > > > > >- Kirti > > > > > >-Original Message- > > >Sent: Wednesday, February 05, 2003 6:04 PM > > >To: Multiple recipients of list ORACLE-L > > > > > > > > >What was the first version of Oracle with the ability to start > > >multiple archiver processes? > > > > > >-- > > >Jeremiah Wilton > > >http://www.speakeasy.net/~jwilton > > > > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: First version with multiple archiver processes?
Sorry Kirti, that was meant for Peter. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 6 Feb 2003, Jeremiah Wilton wrote: > Kirti > > In v.7 the archiver is called ARCH. If 'archive log start to xxx' > starts another, what is it called? > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Wed, 5 Feb 2003, Peter Gram wrote: > > > Kirti > > > > From version 7.x you can manually start multiple archive processes by > > using the "archieve log start to " and the added > > processes wil die when there is no more redofiles to archive, but for > > permanent having multiple processes the answer is 8.1.3 :-) > > > > Deshpande, Kirti wrote: > > > > >I can think of 8.1.3. > > > > > >- Kirti > > > > > >-Original Message- > > >Sent: Wednesday, February 05, 2003 6:04 PM > > >To: Multiple recipients of list ORACLE-L > > > > > > > > >What was the first version of Oracle with the ability to start > > >multiple archiver processes? > > > > > >-- > > >Jeremiah Wilton > > >http://www.speakeasy.net/~jwilton > > > > > > > > > > > > > > > > > > > > > > -- > > Peter Gram, Miracle A/S > > Phone : +45 2527 7107, Fax : +45 4466 8856 > > mailto:[EMAIL PROTECTED] - http://MiracleAS.dk > > > > > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: First version with multiple archiver processes?
Kirti In v.7 the archiver is called ARCH. If 'archive log start to xxx' starts another, what is it called? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 5 Feb 2003, Peter Gram wrote: > Kirti > > From version 7.x you can manually start multiple archive processes by > using the "archieve log start to " and the added > processes wil die when there is no more redofiles to archive, but for > permanent having multiple processes the answer is 8.1.3 :-) > > Deshpande, Kirti wrote: > > >I can think of 8.1.3. > > > >- Kirti > > > >-Original Message- > >Sent: Wednesday, February 05, 2003 6:04 PM > >To: Multiple recipients of list ORACLE-L > > > > > >What was the first version of Oracle with the ability to start > >multiple archiver processes? > > > >-- > >Jeremiah Wilton > >http://www.speakeasy.net/~jwilton > > > > > > > > > > > > > > -- > Peter Gram, Miracle A/S > Phone : +45 2527 7107, Fax : +45 4466 8856 > mailto:[EMAIL PROTECTED] - http://MiracleAS.dk > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: First version with multiple archiver processes?
Kirti From version 7.x you can manually start multiple archive processes by using the "archieve log start to " and the added processes wil die when there is no more redofiles to archive, but for permanent having multiple processes the answer is 8.1.3 :-) Deshpande, Kirti wrote: I can think of 8.1.3. - Kirti -Original Message- Sent: Wednesday, February 05, 2003 6:04 PM To: Multiple recipients of list ORACLE-L What was the first version of Oracle with the ability to start multiple archiver processes? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
RE: First version with multiple archiver processes?
I can think of 8.1.3. - Kirti -Original Message- Sent: Wednesday, February 05, 2003 6:04 PM To: Multiple recipients of list ORACLE-L What was the first version of Oracle with the ability to start multiple archiver processes? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
First version with multiple archiver processes?
What was the first version of Oracle with the ability to start multiple archiver processes? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Sending Again: How to identify Report Builder version 6 and 6
I think 6.0.8.x is 6i ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Baswannappa, Shiva [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: Sending Again: How to identify Report Builder version 6 and 6i Hi Folks I am sending this question again as it is very crucial for me. Is there a way to identify Oracle Report Builder 6 and differentiate it from 6i? The version on my PC is 6.0.5.35 is this version considered as 6i? It is crucial for me since one of the client has report server which has problems running reports built using version 6i. Thanks in advance Regards Shiva Baswannappa Senior Developer Digital Consulting and Software Services Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you. This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Sending Again: How to identify Report Builder version 6 and 6i
Hi Folks I am sending this question again as it is very crucial for me. Is there a way to identify Oracle Report Builder 6 and differentiate it from 6i? The version on my PC is 6.0.5.35 is this version considered as 6i? It is crucial for me since one of the client has report server which has problems running reports built using version 6i. Thanks in advance Regards Shiva Baswannappa Senior Developer Digital Consulting and Software Services Phone: 281.243.2658 Fax: 281.243.2504 Web: http://www.dcss.com If the reader of this e-mail is not an intended recipient, you have received this e-mail in error and any review, dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error, please notify the sender immediately by return e-mail and permanently delete the copy you received. Thank you.
Re: Re: same sql: different db block gets in different oracle version
One reason for seeing more db_block_gets than you expect on a full segment scan is that every extent map block (of which the segment header block is just one) is accessed differently. If you have small extents and large objects, you may have overshoot the maximum extents allowed in the segment header block - so the 12 db_block_gets could indicate 2 extra map blocks. NOTE - Oracle 9 simply does not do 4 CU gets on map blocks. 8.14 CU gets per map block 9.22 CR gets per map block 9.02 gets, but can't remember if they are CU or CR Also - bigger tables => more map blocks may have been used Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 22 January 2003 15:47 version Jonathan Lewis, Thanks very much for your reply. Yes, in oracle 8i on sun solaris, the db block gets of fulltable scan is always 4block, no matter what the size of the table is. But in my tests in linux/817, it always show 12(8170 and 8172).I run the full scan again and again, but the value does not change. And another problem is why in oracle9i, there is no db_block_gets when doing full segment scan.I checked asktom.oracle.com, but unable to find the answer. And i also tested 9.0.1 on sun solaris , when very small, db_block_gets is 6,while larger tables(12K records from dba_tables), db_block_gets is 12. Scanning the segment header caused the current mode read,is it because of scanning the buffer pool head and getting the cache buffer chains latch in exclusive mode,and the buffer head will be moved the other end lru list? why scanning the other data block does not cause the current read? Sorry, I asked to much, and maybe they are meanless, but if possible, I still want to know. Sony kristanto, what kind of parameters do you think will affect the db_block_gets? I will post them. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: same sql: different db block gets in different oracle version
Cho, This is not unusual. I suspect your db_cache_size (or db_block_buffers) in 9.2 is more than db_block_buffers in 8.1. When you do a FTS, all the blocks are loaded into the buffers first time so 'db block gets' is a non zero value (it's the physical IO). The next time you do this, the blocks are found in the buffer already, so there is no physical IO, hence a zero value for 'db block gets'. However, your logical reads (consistent gets) should be the same and they are the same. In 817, run the query once again and see the 'db block gets' , it should be 0. If not then check if db_block_buffers is less than db_cache_size (or db_block_buffers) in 9.2. HTH. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 22, 2003 1:53 AM > Hi, dba friends: > > Look at the following test result, the first one is from oracle9.2, and the second is from the oracle 817. The table is same, and as you see, the execution path is the same. > But there is difference in statistics: db_block_gets, in oracle92, it is 0, and in oracle817, it is not. > And i noticed that in oracle8i, all sql that does only query with execution path full scan of table/index,there will always be db_block_gets, while in 9i, select won't make db_block_gets. > As tom said, db_block_gets is increased when data is accessed for update, how does this query generate this statistics? > > > ORA92> select count(*) from abc; > > COUNT(*) > -- > 1 > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=1) >1 0 SORT (AGGREGATE) >2 1 TABLE ACCESS (FULL) OF 'ABC' (Cost=6 Card=1) > > Statistics > -- > 0 recursive calls > 0 db block gets > 27 consistent gets > 0 physical reads > 0 redo size > 379 bytes sent via SQL*Net to client > 503 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > > ORA817> select count(*) from abc; > > COUNT(*) > -- > 1 > > Elapsed: 00:00:00.26 > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE >1 0 SORT (AGGREGATE) >2 1 TABLE ACCESS (FULL) OF 'ABC' > > Statistics > -- > 0 recursive calls > 12 db block gets > 28 consistent gets > 24 physical reads > 0 redo size > 367 bytes sent via SQL*Net to client > 425 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > > > Regards > zhu chao > msn:[EMAIL PROTECTED] > www.happyit.net > www.cnoug.org(China Oracle User Group) > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: chao_ping > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: same sql: different db block gets in different oracle version
Jonathan Lewis, Thanks very much for your reply. Yes, in oracle 8i on sun solaris, the db block gets of fulltable scan is always 4block, no matter what the size of the table is. But in my tests in linux/817, it always show 12(8170 and 8172).I run the full scan again and again, but the value does not change. And another problem is why in oracle9i, there is no db_block_gets when doing full segment scan.I checked asktom.oracle.com, but unable to find the answer. And i also tested 9.0.1 on sun solaris , when very small, db_block_gets is 6,while larger tables(12K records from dba_tables), db_block_gets is 12. Scanning the segment header caused the current mode read,is it because of scanning the buffer pool head and getting the cache buffer chains latch in exclusive mode,and the buffer head will be moved the other end lru list? why scanning the other data block does not cause the current read? Sorry, I asked to much, and maybe they are meanless, but if possible, I still want to know. Sony kristanto, what kind of parameters do you think will affect the db_block_gets? I will post them. Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-01-22 00:33:00 ,you wrote£º=== >Tablescans in Oracle 8 start with 4 current >gets (db block gets) on the segment header >block - in Oracle 9 tablescans start with >2 consistent gets on the segment header. > >I can't tell you why you have 12 current gets >rather than 4 - but if the tests aren't identical, >the physical reads and extra current gets may >be related to delayed cleanout on a first read. > > > >Regards > >Jonathan Lewis >http://www.jlcomp.demon.co.uk > >Coming soon a new one-day tutorial: >Cost Based Optimisation >(see http://www.jlcomp.demon.co.uk/tutorial.html ) > >Next Seminar dates: >(see http://www.jlcomp.demon.co.uk/seminar.html ) > >England__January 21/23 >USA_(CA, TX)_August > > >The Co-operative Oracle Users' FAQ >http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > > > >-Original Message- >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 22 January 2003 07:42 > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: same sql: different db block gets in different oracle version
Check your setting parameter for db_block_gets and compare between oracle9.2 and oracle817. Is it equivalent setting parameter ? > -Original Message- > From: chao_ping [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, January 22, 2003 1:54 PM > To: Multiple recipients of list ORACLE-L > Subject: same sql: different db block gets in different oracle > version > > Hi, dba friends: > > Look at the following test result, the first one is from oracle9.2, > and the second is from the oracle 817. The table is same, and as you see, > the execution path is the same. > But there is difference in statistics: db_block_gets, in oracle92, > it is 0, and in oracle817, it is not. > And i noticed that in oracle8i, all sql that does only query with > execution path full scan of table/index,there will always be > db_block_gets, while in 9i, select won't make db_block_gets. > As tom said, db_block_gets is increased when data is accessed for > update, how does this query generate this statistics? > > > ORA92> select count(*) from abc; > > COUNT(*) > -- > 1 > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=1) >1 0 SORT (AGGREGATE) >2 1 TABLE ACCESS (FULL) OF 'ABC' (Cost=6 Card=1) > > Statistics > -- > 0 recursive calls > 0 db block gets > 27 consistent gets > 0 physical reads > 0 redo size > 379 bytes sent via SQL*Net to client > 503 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > > ORA817> select count(*) from abc; > > COUNT(*) > -- > 1 > > Elapsed: 00:00:00.26 > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=CHOOSE >1 0 SORT (AGGREGATE) >2 1 TABLE ACCESS (FULL) OF 'ABC' > > Statistics > -- > 0 recursive calls > 12 db block gets > 28 consistent gets > 24 physical reads > 0 redo size > 367 bytes sent via SQL*Net to client > 425 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > > > Regards > zhu chao > msn:[EMAIL PROTECTED] > www.happyit.net > www.cnoug.org(China Oracle User Group) > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: chao_ping > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: same sql: different db block gets in different oracle version
Tablescans in Oracle 8 start with 4 current gets (db block gets) on the segment header block - in Oracle 9 tablescans start with 2 consistent gets on the segment header. I can't tell you why you have 12 current gets rather than 4 - but if the tests aren't identical, the physical reads and extra current gets may be related to delayed cleanout on a first read. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 USA_(CA, TX)_August The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 22 January 2003 07:42 >Hi, dba friends: > > Look at the following test result, the first one is from oracle9.2, and the second is from the oracle 817. The table is same, and as you see, the execution path is the same. > But there is difference in statistics: db_block_gets, in oracle92, it is 0, and in oracle817, it is not. > And i noticed that in oracle8i, all sql that does only query with execution path full scan of table/index,there will always be db_block_gets, while in 9i, select won't make db_block_gets. > As tom said, db_block_gets is increased when data is accessed for update, how does this query generate this statistics? > > >ORA92> select count(*) from abc; > > COUNT(*) >-- > 1 > >Execution Plan >-- > 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=1) > 1 0 SORT (AGGREGATE) > 2 1 TABLE ACCESS (FULL) OF 'ABC' (Cost=6 Card=1) > >Statistics >-- > 0 recursive calls > 0 db block gets > 27 consistent gets > 0 physical reads > 0 redo size >379 bytes sent via SQL*Net to client >503 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > >ORA817> select count(*) from abc; > > COUNT(*) >-- > 1 > >Elapsed: 00:00:00.26 > >Execution Plan >-- > 0 SELECT STATEMENT Optimizer=CHOOSE > 1 0 SORT (AGGREGATE) > 2 1 TABLE ACCESS (FULL) OF 'ABC' > >Statistics >-- > 0 recursive calls > 12 db block gets > 28 consistent gets > 24 physical reads > 0 redo size >367 bytes sent via SQL*Net to client >425 bytes received via SQL*Net from client > 2 SQL*Net roundtrips to/from client > 0 sorts (memory) > 0 sorts (disk) > 1 rows processed > > >Regards >zhu chao >msn:[EMAIL PROTECTED] >www.happyit.net >www.cnoug.org(China Oracle User Group) > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
same sql: different db block gets in different oracle version
Hi, dba friends: Look at the following test result, the first one is from oracle9.2, and the second is from the oracle 817. The table is same, and as you see, the execution path is the same. But there is difference in statistics: db_block_gets, in oracle92, it is 0, and in oracle817, it is not. And i noticed that in oracle8i, all sql that does only query with execution path full scan of table/index,there will always be db_block_gets, while in 9i, select won't make db_block_gets. As tom said, db_block_gets is increased when data is accessed for update, how does this query generate this statistics? ORA92> select count(*) from abc; COUNT(*) -- 1 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=6 Card=1) 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' (Cost=6 Card=1) Statistics -- 0 recursive calls 0 db block gets 27 consistent gets 0 physical reads 0 redo size 379 bytes sent via SQL*Net to client 503 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed ORA817> select count(*) from abc; COUNT(*) -- 1 Elapsed: 00:00:00.26 Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 1 0 SORT (AGGREGATE) 2 1 TABLE ACCESS (FULL) OF 'ABC' Statistics -- 0 recursive calls 12 db block gets 28 consistent gets 24 physical reads 0 redo size 367 bytes sent via SQL*Net to client 425 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processed Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN new version myths
Find, but someone else can admin them. ;) Jared On Friday 10 January 2003 11:30, Rachel Carmichael wrote: > couldn't hurt on the last two at least :) > > --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > > Rachel, > > > > do you think we need following lists created ... > > > > * oracle-l-overheard > > * oracle-l-debunking-myths > > * oracle-l-help-idiot > > > > Raj > > __ > > Rajendra Jamadagni MIS, ESPN Inc. > > Rajendra dot Jamadagni at ESPN dot com > > Any opinion expressed here is personal and doesn't reflect that of > > ESPN Inc. > > > > QOTD: Any clod can have facts, but having an opinion is an art! > > > > > > -Original Message- > > Sent: Friday, January 10, 2003 1:29 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Okay, from a friend within Oracle University (someone whose knowledge > > I > > trust).. > > > > 1. There are NO plans to eliminate the use of the RMAN Repository! > > As has > > been correctly surmised by some readers Oracle is attempting to make > > it > > easier to use rman without a repository but it is not going away. It > > is > > expected that large shops with a heavy Oracle investment would > > continue to > > use the Repository, but smaller shops may consider the complexity a > > burden. > > > > The Oracle instructor that said the RMAN repository was going away > > was > > either > > a. misunderstood > > b. wrong. > > c. both of the above > > This > > > e-mail message is confidential, intended only for the named > > recipient(s) above and may contain information that is privileged, > > attorney work product or exempt from disclosure under applicable law. > > If you have received this message in error, or are not the named > > recipient(s), please immediately notify corporate MIS at (860) > > 766-2000 and delete this e-mail message from your computer, Thank > > you.*2 > > > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN new version myths
couldn't hurt on the last two at least :) --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > Rachel, > > do you think we need following lists created ... > > * oracle-l-overheard > * oracle-l-debunking-myths > * oracle-l-help-idiot > > Raj > __ > Rajendra JamadagniMIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of > ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > > -Original Message- > Sent: Friday, January 10, 2003 1:29 PM > To: Multiple recipients of list ORACLE-L > > > Okay, from a friend within Oracle University (someone whose knowledge > I > trust).. > > 1. There are NO plans to eliminate the use of the RMAN Repository! > As has > been correctly surmised by some readers Oracle is attempting to make > it > easier to use rman without a repository but it is not going away. It > is > expected that large shops with a heavy Oracle investment would > continue to > use the Repository, but smaller shops may consider the complexity a > burden. > > The Oracle instructor that said the RMAN repository was going away > was > either > a. misunderstood > b. wrong. > c. both of the above > > > This > e-mail message is confidential, intended only for the named > recipient(s) above and may contain information that is privileged, > attorney work product or exempt from disclosure under applicable law. > If you have received this message in error, or are not the named > recipient(s), please immediately notify corporate MIS at (860) > 766-2000 and delete this e-mail message from your computer, Thank > you.*2 > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN new version myths
Title: RE: RMAN new version myths Rachel, do you think we need following lists created ... * oracle-l-overheard * oracle-l-debunking-myths * oracle-l-help-idiot Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Subject: RMAN new version myths Okay, from a friend within Oracle University (someone whose knowledge I trust).. 1. There are NO plans to eliminate the use of the RMAN Repository! As has been correctly surmised by some readers Oracle is attempting to make it easier to use rman without a repository but it is not going away. It is expected that large shops with a heavy Oracle investment would continue to use the Repository, but smaller shops may consider the complexity a burden. The Oracle instructor that said the RMAN repository was going away was either a. misunderstood b. wrong. c. both of the above This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RMAN new version myths
Okay, from a friend within Oracle University (someone whose knowledge I trust).. 1. There are NO plans to eliminate the use of the RMAN Repository! As has been correctly surmised by some readers Oracle is attempting to make it easier to use rman without a repository but it is not going away. It is expected that large shops with a heavy Oracle investment would continue to use the Repository, but smaller shops may consider the complexity a burden. The Oracle instructor that said the RMAN repository was going away was either a. misunderstood b. wrong. c. both of the above __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: 8.1.7 with *what* version of Portal??
Add one more thing, you need to make sure to install oracle jvm and intermedia before you install the portal. otherwise, portal won't work without these feafures. Joan Hemant K Chitale wrote: > > Portal is part of iAS. iAS 1.0.2.X, preferably 1.0.2.2.2, runs Portal > 3.0.9.X.X [base version 3.0.9.8.0] > against a database running 8.1.7.X > > I'm not sure if iAS 2.x which has been renumbered to iAS 9.0.2 runs against > 8.1.7. I believe it should. > > To answer your question, you'd need to install Portal from iAS. This > installs the Apache/Jserv, and > portal product files in the Apache ORACLE_HOME and Portal database schema > into the database, > which should be running from a seperate ORACLE_HOME, even if on the same > server. > Hemant > > At 05:38 PM 27-12-02 -0800, you wrote: > >we have 8i (8.1.7.1) running at our shop and one of our developers wants > >to use WebDB (what I understand is now "Portal"). in checking OTN and > >other places, I can't figure out what version of Portal (or WebDB) I > >should be installing, nor where I can get it. > > > >can anyone tell me what version I should be trying to install, where I can > >get it and where any resources on installation and configuration might be > >located? > > > >it is my understanding that Portal is a collection of packages that work > >with our existing database and doesn't need anything extra. is that also > >truy? aside from the raw 8i database, will I need to install anything > >else (yes, we have apache running ok)? > > > >Deb > >Carbide Systems Group > > > > > > > > > >_ > >Protect your PC - get McAfee.com VirusScan Online > >http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Oracle Developer > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >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). > > Hemant K Chitale > My web site page is : http://hkchital.tripod.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hemant K Chitale > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: 8.1.7 with *what* version of Portal??
Portal is part of iAS. iAS 1.0.2.X, preferably 1.0.2.2.2, runs Portal 3.0.9.X.X [base version 3.0.9.8.0] against a database running 8.1.7.X I'm not sure if iAS 2.x which has been renumbered to iAS 9.0.2 runs against 8.1.7. I believe it should. To answer your question, you'd need to install Portal from iAS. This installs the Apache/Jserv, and portal product files in the Apache ORACLE_HOME and Portal database schema into the database, which should be running from a seperate ORACLE_HOME, even if on the same server. Hemant At 05:38 PM 27-12-02 -0800, you wrote: we have 8i (8.1.7.1) running at our shop and one of our developers wants to use WebDB (what I understand is now "Portal"). in checking OTN and other places, I can't figure out what version of Portal (or WebDB) I should be installing, nor where I can get it. can anyone tell me what version I should be trying to install, where I can get it and where any resources on installation and configuration might be located? it is my understanding that Portal is a collection of packages that work with our existing database and doesn't need anything extra. is that also truy? aside from the raw 8i database, will I need to install anything else (yes, we have apache running ok)? Deb Carbide Systems Group _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle Developer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
8.1.7 with *what* version of Portal??
we have 8i (8.1.7.1) running at our shop and one of our developers wants to use WebDB (what I understand is now "Portal"). in checking OTN and other places, I can't figure out what version of Portal (or WebDB) I should be installing, nor where I can get it. can anyone tell me what version I should be trying to install, where I can get it and where any resources on installation and configuration might be located? it is my understanding that Portal is a collection of packages that work with our existing database and doesn't need anything extra. is that also truy? aside from the raw 8i database, will I need to install anything else (yes, we have apache running ok)? Deb Carbide Systems Group _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle Developer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Cross version SNAPSHOT/MATERIALIZED VIEW replication
Our current master is 8.1.6.3 as is our Snapshot database. However, at some time in the future our master database will be upgraded to 8.1.7.4. Our options are to stay with 8.1.6.3, upgrade to 8.1.7.4, or upgrade to 9.1.2. We can do this either before or after the master's upgrade. So our possible configurations are: MASTERSLAVE 8.1.6.3 8.1.7.4 8.1.6.3 9.1.2 8.1.7.4 8.1.6.3 8.1.7.4 8.1.7.4 8.1.7.4 9.1.2 These will be upgrades in place. Also, our customers are using a variety of methods to access the snapshot database including SQLNet and ODBC. I don't think that the OS environments are an issue but the master is on a DEC/Alpha UNIX box and the snapshot is on a Win2K box. Has anybody done this (upgrades in place for any of the master/slave pairs) and, if so, did you run into any issues? Any input will be gratefully accepted in the spirit in which it is offered. We are RTing the FMs for all they're worth but the upgrade in place is treated as a non-issue (which I suspect is not the case) and I'd rather hear from someone who has actually done it. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Is the personal version of RH 8.0 good for Oracle 9.2?
In a seminar about three months ago they told us that the advance server version does not contain anything that you can not put together yourself by downloading and compiling. But - this is a lot of hard work. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, December 11, 2002 7:24 PM > Any limitations on the personal version or lack of features that exist in > the pro/advanced server version that will impact Oracle. > > -Original Message- > Sent: Wednesday, December 11, 2002 11:37 AM > To: [EMAIL PROTECTED]; Khedr, Waleed > > > Why not? > > -- > Lyndon Tiu > > > Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>: > > > Thanks > > > > Waleed > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Khedr, Waleed > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Is the personal version of RH 8.0 good for Oracle 9.2?
Sounds good. Will do. Thanks, Waleed -Original Message- Sent: Wednesday, December 11, 2002 1:00 PM To: Multiple recipients of list ORACLE-L The biggest impact to Oracle will be the available glibc libraries which Oracle uses. These ibraries are all pretty much standard in all recent Linux distros. I have Oracle 9.2i on RH 8.0 and Mandrake 9.0 and things look fine to me. Personal version is simply a reference to the packaging. Everything is still in there. Whatever that's not in there you can down load from www.rpmfind.net -- Lyndon Tiu Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>: > Any limitations on the personal version or lack of features that exist in > the pro/advanced server version that will impact Oracle. > > -Original Message- > Sent: Wednesday, December 11, 2002 11:37 AM > To: [EMAIL PROTECTED]; Khedr, Waleed > > > Why not? > > -- > Lyndon Tiu > > > Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>: > > > Thanks > > > > Waleed > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Khedr, Waleed > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Is the personal version of RH 8.0 good for Oracle 9.2?
The biggest impact to Oracle will be the available glibc libraries which Oracle uses. These ibraries are all pretty much standard in all recent Linux distros. I have Oracle 9.2i on RH 8.0 and Mandrake 9.0 and things look fine to me. Personal version is simply a reference to the packaging. Everything is still in there. Whatever that's not in there you can down load from www.rpmfind.net -- Lyndon Tiu Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>: > Any limitations on the personal version or lack of features that exist in > the pro/advanced server version that will impact Oracle. > > -Original Message- > Sent: Wednesday, December 11, 2002 11:37 AM > To: [EMAIL PROTECTED]; Khedr, Waleed > > > Why not? > > -- > Lyndon Tiu > > > Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>: > > > Thanks > > > > Waleed > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Khedr, Waleed > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > 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: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Is the personal version of RH 8.0 good for Oracle 9.2?
Any limitations on the personal version or lack of features that exist in the pro/advanced server version that will impact Oracle. -Original Message- Sent: Wednesday, December 11, 2002 11:37 AM To: [EMAIL PROTECTED]; Khedr, Waleed Why not? -- Lyndon Tiu Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>: > Thanks > > Waleed > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Is the personal version of RH 8.0 good for Oracle 9.2?
Why not? -- Lyndon Tiu Quoting "Khedr, Waleed" <[EMAIL PROTECTED]>: > Thanks > > Waleed > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > 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: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Is the personal version of RH 8.0 good for Oracle 9.2?
Thanks Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 9i Version Statistics
Jacques - I wonder if he was referring to STATSPACK in Oracle Version 9i? OpenWorld has a presentation on that. The other idea is that 9i has schema versioning, where users can check out a table, make changes to it, and then you can merge the changes back together.. Look under Database Workspace Management. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, December 09, 2002 1:14 PM To: Multiple recipients of list ORACLE-L I had a colleague ask me about "Oracle 9i Version Statistics". I couldn't see anything about that on Metalink, 9.2 / 9.0 new features guide, or through a Google search. Is there such a thing or did the colleague misread the name of a new feature? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
