Re: problem with log version

2004-01-20 Thread Paul Drake
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&#

problem with log version

2004-01-20 Thread Vélez
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 incompati

Re: Oracle Version 8 as read only

2003-11-27 Thread Pete Finnigan
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

Re: Oracle Version 8 as read only

2003-11-26 Thread Tim Gorman
> 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

RE: Oracle Version 8 as read only

2003-11-26 Thread Browett, Darren
esoft 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 h

Re: Oracle Version 8 as read only

2003-11-26 Thread Tim Gorman
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 ho

RE: Oracle Version 8 as read only

2003-11-26 Thread nelson flores
ng 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 accom

Oracle Version 8 as read only

2003-11-26 Thread Browett, Darren
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 versio

RE: which oracle9i version is stable

2003-10-30 Thread Kevin Toepke
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 th

Re: which oracle9i version is stable

2003-10-30 Thread Brian_P_MacLean
cc: Sent by: Subject: Re: which oracle9i version is stable [EMA

RE: which oracle9i version is stable

2003-10-30 Thread M Rafiq
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

RE: which oracle9i version is stable

2003-10-30 Thread Jeroen van Sluisdam
: 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

Re: which oracle9i version is stable

2003-10-30 Thread Mladen Gogala
> 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 o

Re: which oracle9i version is stable

2003-10-30 Thread laura pena
27;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 appreci

Re: which oracle9i version is stable

2003-10-30 Thread Mladen Gogala
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 -- Auth

which oracle9i version is stable

2003-10-30 Thread Jeroen van Sluisdam
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 wi

Re: how to find the installed version of oracle??

2003-10-20 Thread Pete Finnigan
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

Patch Set 3 Version 9.2.0.4.0 for Linux x86 that makes use of a buffer overflow

2003-10-19 Thread Gunnar Berglund
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

2003-10-16 Thread Adams, Matthew (GECP, MABG, 088130)
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

RE: db version control - schemas, code

2003-10-16 Thread Yosi Greenfield
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, 0

Re: db version control - schemas, code

2003-10-16 Thread AK
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 solutio

RE: db version control - schemas, code

2003-10-16 Thread Adams, Matthew (GECP, MABG, 088130)
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 au

Re: db version control - schemas, code

2003-10-16 Thread Mladen Gogala
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 a

db version control - schemas, code

2003-10-16 Thread Yosi Greenfield
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. Cli

how to find the installed version of oracle??

2003-10-16 Thread Shiva Maran
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

Re: ** how to check version and problems

2003-07-31 Thread Kirtikumar Deshpande
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:[EMAI

Re: ** how to check version and problems

2003-07-31 Thread Pete Finnigan
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. -- Pl

RE: ** how to check version and problems

2003-07-30 Thread Naveen Nahata
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

** how to check version and problems

2003-07-30 Thread A Joshi
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

2003-07-22 Thread setiady
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 IN

RE: OAS version for Oracle8i

2003-07-22 Thread Boivin, Patrice J
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- Se

OAS version for Oracle8i

2003-07-22 Thread setiady
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.orafa

RE: Using the 9i version of UTL_HTTP in 8i

2003-07-16 Thread Charu Joshi
wo 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 wi

Using the 9i version of UTL_HTTP in 8i

2003-07-16 Thread Charu Joshi
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

Re: version control for pl/sql dev forms etc.

2003-06-16 Thread Arun Annamalai
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 &g

RE: version control for pl/sql dev forms etc.

2003-06-16 Thread Jamadagni, Rajendra
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

RE: version control for pl/sql dev forms etc.

2003-06-16 Thread TOMPKINS, MARGARET
isit 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

version control for pl/sql dev forms etc.

2003-06-15 Thread rahul sharma
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

RE: Urgent: Need Oradim.exe for version 8.1.6

2003-06-11 Thread Naveen Nahata
> 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 > > >

Re: Urgent: Need Oradim.exe for version 8.1.6

2003-06-11 Thread Jared . Still
gt; 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] > Se

Re: Urgent: Need Oradim.exe for version 8.1.6

2003-06-11 Thread Jared . Still
lease 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

Re: Urgent: Need Oradim.exe for version 8.1.6

2003-06-11 Thread Jared . Still
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

RE: Urgent: Need Oradim.exe for version 8.1.6

2003-06-11 Thread Hallas, John, Tech Dev
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

Urgent: Need Oradim.exe for version 8.1.6

2003-06-11 Thread Naveen Nahata
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

Re: Oracle Client Software Version

2003-03-17 Thread Hemant K Chitale
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 R

Oracle Client Software Version

2003-03-10 Thread Browett, Darren
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

Re: FW: oracle version

2003-03-05 Thread babu . nagarajan
cc: om> Subject: Re: FW: oracle version

Re: FW: oracle version

2003-03-05 Thread kommareddy sreenivasa
s 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 > Sch

RE: oracle version

2003-03-05 Thread Santosh Varma
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

RE: oracle version

2003-03-05 Thread Hatzistavrou John
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.

oracle version

2003-03-05 Thread kommareddy sreenivasa
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_HO

Re: Oracle version??

2003-02-27 Thread Chip
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 OU

RE: Oracle version??

2003-02-27 Thread Rajesh Dayal
ver\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 num

RE: Oracle version??

2003-02-27 Thread Stephane Faroult
>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 Nook

Re: Oracle version??

2003-02-27 Thread Chip
le.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 bo

RE: Oracle version??

2003-02-26 Thread Cary Millsap
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 Ent

RE: Oracle version??

2003-02-26 Thread Rajesh Dayal
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

Oracle version??

2003-02-26 Thread Sunil_Nookala
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

RE: [Q] how to start "intelegent agent" on ORACLE 9.2 version?

2003-02-13 Thread Henry, Keith
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? >

RE: [Q] how to start "intelegent agent" on ORACLE 9.2 version?

2003-02-13 Thread Gorbounov,Vadim
snmp_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.

RE: [Q] how to start "intelegent agent" on ORACLE 9.2 version?

2003-02-13 Thread Chris Stephens
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

[Q] how to start "intelegent agent" on ORACLE 9.2 version?

2003-02-13 Thread dist cash
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.

RE: Version Controlling in Oracle database - Ideas ?

2003-02-11 Thread Adams, Matthew (GECP, MABG, 088130)
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

Re: how to find the version ?

2003-02-11 Thread rahul
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 th

Re: how to find the version ?

2003-02-11 Thread rahul
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 th

how to find the version ?

2003-02-11 Thread rahul
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 for

RE: Version Controlling in Oracle database - Ideas ?

2003-02-10 Thread Jesse, Rich
-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

RE: Version Controlling in Oracle database - Ideas ?

2003-02-10 Thread Weiss, Rick
ry 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

RE: Version Controlling in Oracle database - Ideas ?

2003-02-07 Thread VIVEK_SHARMA
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

RE: Version Controlling in Oracle database - Ideas ?

2003-02-07 Thread Jamadagni, Rajendra
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 _

Version Controlling in Oracle database - Ideas ?

2003-02-07 Thread VIVEK_SHARMA
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

RE: First version with multiple archiver processes?

2003-02-06 Thread Deshpande, 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

Re: First version with multiple archiver processes?

2003-02-06 Thread Jeremiah Wilton
-- > 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 > > p

Re: First version with multiple archiver processes?

2003-02-06 Thread Jeremiah Wilton
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 pr

Re: First version with multiple archiver processes?

2003-02-06 Thread Peter Gram
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 ca

RE: First version with multiple archiver processes?

2003-02-05 Thread Deshpande, Kirti
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

First version with multiple archiver processes?

2003-02-05 Thread Jeremiah Wilton
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

RE: Sending Again: How to identify Report Builder version 6 and 6

2003-01-31 Thread Jamadagni, Rajendra
, 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 se

Sending Again: How to identify Report Builder version 6 and 6i

2003-01-31 Thread Baswannappa, Shiva
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

Re: Re: same sql: different db block gets in different oracle version

2003-01-22 Thread Jonathan Lewis
_(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,

Re: same sql: different db block gets in different oracle version

2003-01-22 Thread Arup Nanda
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 ar

Re: Re: same sql: different db block gets in different oracle version

2003-01-22 Thread chao_ping
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, bu

RE: same sql: different db block gets in different oracle version

2003-01-22 Thread Sony kristanto
ist 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,

Re: same sql: different db block gets in different oracle version

2003-01-22 Thread Jonathan Lewis
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 c

same sql: different db block gets in different oracle version

2003-01-21 Thread chao_ping
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

Re: RMAN new version myths

2003-01-12 Thread Jared Still
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-

RE: RMAN new version myths

2003-01-10 Thread Rachel Carmichael
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 > ___

RE: RMAN new version myths

2003-01-10 Thread Jamadagni, Rajendra
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

RMAN new version myths

2003-01-10 Thread Rachel Carmichael
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

Re: 8.1.7 with *what* version of Portal??

2002-12-30 Thread Joan Hsieh
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

Re: 8.1.7 with *what* version of Portal??

2002-12-28 Thread Hemant K Chitale
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

8.1.7 with *what* version of Portal??

2002-12-27 Thread Oracle Developer
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

Cross version SNAPSHOT/MATERIALIZED VIEW replication

2002-12-16 Thread Thomas Day
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 poss

Re: Is the personal version of RH 8.0 good for Oracle 9.2?

2002-12-11 Thread Yechiel Adar
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

RE: Is the personal version of RH 8.0 good for Oracle 9.2?

2002-12-11 Thread Khedr, Waleed
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, Walee

RE: Is the personal version of RH 8.0 good for Oracle 9.2?

2002-12-11 Thread Lyndon Tiu
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

RE: Is the personal version of RH 8.0 good for Oracle 9.2?

2002-12-11 Thread Khedr, Waleed
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, W

Re: Is the personal version of RH 8.0 good for Oracle 9.2?

2002-12-11 Thread Lyndon Tiu
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

Is the personal version of RH 8.0 good for Oracle 9.2?

2002-12-11 Thread Khedr, Waleed
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 -

RE: Oracle 9i Version Statistics

2002-12-09 Thread DENNIS WILLIAMS
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

  1   2   3   >