RE: DISASTER RECOVERY with Continous Access
] (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: Orr, Steve 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 -- 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: Bellow, Bambi 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 -- 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: Spears, Brian 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: Mandar A. Ghosalkar 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.4 interim patch management strategy
Hello All, There are 188 interim patches after 8.1.7.4 patchset. I know that 8.1.7.4 is the last patchset. 1. What methods/strategy do you'll have for installing patches on a 8.1.7.4 64 bit hp-ux 11.11 database? 2. Is there opatch for 8.1.7.4? AFAIK opatch is only for 9i. 3. Should one install all the applicable patches (around 180 individual patches)? pessimistic (wait for the bug to hit and db to crash) optimistic (install applicable patches) 4. How to manage the interdependencies between these 180 individual patches? 5. Can we create a hp unix patch depot like thing for all these oracle patches? pls dont advise putting an enhancement request and upgrading to 9i/10i :-) Thanks, Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandar A. Ghosalkar 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: Read SQL Server from Oracle
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96544/admi n.htm#169283 -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 1:27 PM To: Multiple recipients of list ORACLE-L Subject: Read SQL Server from Oracle I need to be able to read SQL Server tables from an Oracle procedure. Can anyone point me in the right direction for info? Ron Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: Mandar A. Ghosalkar 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: LOV on Forms 6i to be populated with data from SQL Server 2000 ta
Title: Message use heterogeneous services + odbc/oledb and you could create a synonym for a sqlserver table. no need for any gateway product. -Original Message-From: Baswannappa, Shiva [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 2:21 PMTo: Multiple recipients of list ORACLE-LSubject: LOV on Forms 6i to be populated with data from SQL Server 2000 ta Hi Gurus I have a unusual request from one of new clients. I have an application that is 100% Oracle forms 6i, and reports 6i and DB 8.1.7 running on W2K platform. Clients wants to know whether he can populate aLOV onOracle form with data from one of the columns of a table in SQL Server 2000. Is there a way to achieve this with something like database link, dynamic link, etc... Appreciate any help or lead or direction to documentation in regard Thanks in advance Regards Shiva Baswannappa Life Sciences Business UnitDigital Consulting Software Services, Inc._? Phone: 281.243.2658Fax: 281.243.2504Web: 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: OEM jobs on Win2K
When a OEM export job is created, the agent on the database server runs the exp utility through a tcl script. same for rman. on the database server you should find a rman.tcl file. after executing the export job i run the following tcl commands through the same oem export job. file rename -force f:/oracle/admin/btps/exp/btps_bt_rows.dmp f:/oracle/admin/btps/exp/btps_bt_rows_[clock format [clock seconds] -format %a].dmp file rename -force f:/oracle/admin/btps/exp/btps_bt_rows.log f:/oracle/admin/btps/exp/btps_bt_rows_[clock format [clock seconds] -format %a].log this is required because i cannot specify a time format in the export file name parameter. HTH Mandar -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 12:24 PM To: Multiple recipients of list ORACLE-L Subject: OEM jobs on Win2K Hi all. I've just entered the world of Oracle on Windows. My first question regards the mechanism used to run jobs that are created using OEM.How does OEM execute RMAN, or export, for example? Thanks Paul Baumgartel __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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: Mandar A. Ghosalkar 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).
HP-UX Installation questions for 8i/9i on a HP-UX 11/11i on RP7400
Installation requirements for 8i/9i on a HP-UX 11/11i on RP7400 Do we need to install Ansi C developers module on HP-UX, if i am not going to use Pro*C? Do we need to install Microfocus Cobol module on HP-UX, if i am not going to use Pro*cobol? Do u'll use onlineJFS (Veritas Filessystem) which allows online Filesystem changes without unmounting? HP-UX comes with default base JFS which is a stripped down version of veritas file system without online filesystem changes. Thanks, Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandar A. Ghosalkar 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: HP-UX Installation questions for 8i/9i on a HP-UX 11/11i
Dick, you are right. i don't need Ansi C or Microfocus cobol if i am not using Pro*C or Pro*Cobol. the bundled C compile is sufficient for oracle installation. but i am not sure about OnlineJFS and HpUX Disk Mirroring license base vxfs is good enough, if extra features not required. but maybe i need Disk mirroring for the internal disks for root and swap. i would have two internal 18GB Hot Plug Ultra SCSI Low Pro Drive. is this enough for the root/swap for hp 11i. is mirroring required for the internal disks? do we need extra license for that? is glanceplus a necessity for passive standby database server? any additional hp 11i software required? any inputs? thanks Mandar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 1:00 PM To: Mandar A. Ghosalkar; Multiple recipients of list ORACLE-L; [EMAIL PROTECTED] Subject: Re:HP-UX Installation questions for 8i/9i on a HP-UX 11/11i Mandar, I'm going to include my HP-UX GURU on to the reply so that he can comment about the JFS as he feels appriopriate. As for trhe MicroFocus Cobol, NO you don't need it. Ansi C can become another matter. If your going to use any exernal procedures you will need it as well as certain options to the RDBMS, so in general I would say yes. Dick Goulet Reply Separator Subject:HP-UX Installation questions for 8i/9i on a HP-UX 11/11i on Author: Mandar A. Ghosalkar [EMAIL PROTECTED] Date: 3/19/2003 12:24 PM Installation requirements for 8i/9i on a HP-UX 11/11i on RP7400 Do we need to install Ansi C developers module on HP-UX, if i am not going to use Pro*C? Do we need to install Microfocus Cobol module on HP-UX, if i am not going to use Pro*cobol? Do u'll use onlineJFS (Veritas Filessystem) which allows online Filesystem changes without unmounting? HP-UX comes with default base JFS which is a stripped down version of veritas file system without online filesystem changes. Thanks, Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandar A. Ghosalkar 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: Mandar A. Ghosalkar 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: HP-UX Installation questions for 8i/9i on a HP-UX 11/
Dick, base vxfs is good enough, if extra features not required. if the business allows regular downtimes, and if not 24x7x365 then online filesystem changes not reqd. but maybe i need Disk mirroring for the internal disks for root and swap. i would have two internal 18GB Hot Plug Ultra SCSI Low Pro Drive. is this enough for the root/swap for hp 11i. 2*18gb is enough for OS and swap (after searching in hp docs) is mirroring required for the internal disks? mirroring of OS is reqd for a good night sleep :-) do we need extra license for that? yes, license reqd for MirrorUX from HP is glanceplus a necessity for passive standby database server? it would be on prod server. and i would like the standby server to have the same config as the primary. so i would end up buying that too. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 2:13 PM To: Mandar A. Ghosalkar; Multiple recipients of list ORACLE-L; [EMAIL PROTECTED] Subject: Re:RE: HP-UX Installation questions for 8i/9i on a HP-UX 11/ Jeff, Care to put your 2 cents in? Dick Goulet Reply Separator Subject:RE: HP-UX Installation questions for 8i/9i on a HP-UX 11/11i Author: Mandar A. Ghosalkar [EMAIL PROTECTED] Date: 3/19/2003 1:24 PM Dick, you are right. i don't need Ansi C or Microfocus cobol if i am not using Pro*C or Pro*Cobol. the bundled C compile is sufficient for oracle installation. but i am not sure about OnlineJFS and HpUX Disk Mirroring license base vxfs is good enough, if extra features not required. but maybe i need Disk mirroring for the internal disks for root and swap. i would have two internal 18GB Hot Plug Ultra SCSI Low Pro Drive. is this enough for the root/swap for hp 11i. is mirroring required for the internal disks? do we need extra license for that? is glanceplus a necessity for passive standby database server? any additional hp 11i software required? any inputs? thanks Mandar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 1:00 PM To: Mandar A. Ghosalkar; Multiple recipients of list ORACLE-L; [EMAIL PROTECTED] Subject: Re:HP-UX Installation questions for 8i/9i on a HP-UX 11/11i Mandar, I'm going to include my HP-UX GURU on to the reply so that he can comment about the JFS as he feels appriopriate. As for trhe MicroFocus Cobol, NO you don't need it. Ansi C can become another matter. If your going to use any exernal procedures you will need it as well as certain options to the RDBMS, so in general I would say yes. Dick Goulet Reply Separator Subject:HP-UX Installation questions for 8i/9i on a HP-UX 11/11i on Author: Mandar A. Ghosalkar [EMAIL PROTECTED] Date: 3/19/2003 12:24 PM Installation requirements for 8i/9i on a HP-UX 11/11i on RP7400 Do we need to install Ansi C developers module on HP-UX, if i am not going to use Pro*C? Do we need to install Microfocus Cobol module on HP-UX, if i am not going to use Pro*cobol? Do u'll use onlineJFS (Veritas Filessystem) which allows online Filesystem changes without unmounting? HP-UX comes with default base JFS which is a stripped down version of veritas file system without online filesystem changes. Thanks, Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandar A. Ghosalkar 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: Mandar A. Ghosalkar 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: Mandar A. Ghosalkar INET
RE: DBV
dbv is not crashing my 7.3.4.3.1 instance on hp-ux 10.2 :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: DBV Dan, That must be new for 9i, since my 8.1.7 docs say it is an offline utility. I remember hosing an entire 7.3 test database years ago when I first ran DBV on it while it was up and open - can't remember the errors, but the DB was unusable. One of the (too) many times I learned to read the docs more carefully. :-( Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Daniel W. Fink [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L .com [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: DBV 02/26/2003 01:54 PM Please respond to ORACLE-L Yes, you can. It may report that a block is influx if the block is being written while dbv is looking at it. If you encounter this error, run it again. If it does not report the same block, you are in the clear. As with any i/o intensive process, run it off-hours. Dan Fink Breno A. K. Magnago wrote: Hi, Can I use the program DBV on a production datafile (read and write), without take offline the tablespace ? -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] -- 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: Mandar A. Ghosalkar 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 backup with MULTIPLE CHANNELS ......
also check Maximum Jobs per client. you will find this setting in the Netbackup preferences window (Netbackup Java console). -Mandar -Original Message- From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup with MULTIPLE CHANNELS .. Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga 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: Mandar A. Ghosalkar 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: Netbackup client configuration info
Excluding files: i hv a file on my client, which lists oracle database files not to be backedup (?) by other file backup jobs. i use hot for oracle. the file name defines for which job (earth_os ) it is applied /usr/openv/netbackup/exclude_list.earth_os check this link for excluding files from a backup http://ftp.support.veritas.com/pub/support/products/NetBackup_BusinesServer/246734.pdf Includes: includes are specified in the job command as an option or in their *nice* slow java gui. -Mandar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Netbackup client configuration info Hello everyone, For Tivoli (TSM) backups there is a file called inclexcl on each backup client, which lists the directories which are included and excluded for backup..(along with their management classes)..I was wondering if there is a similar file in netbackup configuration which can give the similar information. The idea is to find out which dir/files are getting backed up and their correspponding retention for any netbackup client.. Appreciate any information anyone can provide on this.. Thanks Mohammed Ahsanuddin Oracle DBA -- 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: Mandar A. Ghosalkar 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).
AUTORAID and VA7100 disk arrays for rp7400
Hi, i am in the process of defining the specs for a rp7400. a lil overwhelmed by the storage offerings from HP. i wanted to know if any of ull hv any inputs regarding a disk array. we currently hv a Model 30/FC disk array with 9gig drives. I am looking for a similar or the next higher configuration disk array from HP. Any inputs regarding VA7100 disk array or corresponding competetive disk aray from HP/competitor? cache size 256/512/1024 MB? dont know which to go. thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. faster smaller drives. the va7100 product specs on HP site mention more about AutoRAID (which is dynamic 0+1 or 5 configuration on the fly). any inputs on AutoRAID for Oracle database files. hv ull used 0+1 h/w configuration on VA7100? am i talking sense? a good article to read, especially page 4 http://www.hp.com/products1/storage/products/disk_arrays/infolibrary/hp_va_and_san_virtualization.pdf any inputs related to configuring a rp7400 are invited. my initial specs based on my current k570 is below. current k570 (7.3.4) 4 * 200Mhz 2 gn ram specs for rp7400 (8i/9i) 4 * 550MHz 6 Gb ram and i thought it was easy. take a few procs add ram add few disks, (Baaam!) make sound and license and u hv a server. but look into a detailed partlist and configuration options at https://www.e-solutions.hp.com/shop/cgi-bin/sweetspot.cgi Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandar A. Ghosalkar 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: AUTORAID and VA7100 disk arrays for rp7400
Michael, a dumb question. does this stops me from using VA7100 with 0+1 or are u talking about going some other disk array product? Thanks Mandar -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 12:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: AUTORAID and VA7100 disk arrays for rp7400 Apologies to all for shouting, but ... DO NOT USE AUTORAID! ** *** *** * I used an AutoRaid system when I was at Petco. Performance was el-sucko. There was more I/Os happening in the disk array (by observing the disk lights) than was being caused by the application and database. Plus, when the AR system Raid 0+1/5 mode, where some blocks are kept in a RAID 0+1 area and some are kept in a RAID 5 area, the array got so busy swapping one for another that it was virtually useless. Fiber channel (FC-10) works ok, Clariion (by EMC) works Ok, heck, even JBOD works better than AutoRaid. Just my 2¢ worth. Cheers, Mike -Original Message- Sent: Thursday, January 23, 2003 11:35 AM To: Multiple recipients of list ORACLE-L Hi, i am in the process of defining the specs for a rp7400. a lil overwhelmed by the storage offerings from HP. i wanted to know if any of ull hv any inputs regarding a disk array. we currently hv a Model 30/FC disk array with 9gig drives. I am looking for a similar or the next higher configuration disk array from HP. Any inputs regarding VA7100 disk array or corresponding competetive disk aray from HP/competitor? cache size 256/512/1024 MB? dont know which to go. thinking of going for 18GB 15k rpm rather than 36GB 15K rpm. faster smaller drives. the va7100 product specs on HP site mention more about AutoRAID (which is dynamic 0+1 or 5 configuration on the fly). any inputs on AutoRAID for Oracle database files. hv ull used 0+1 h/w configuration on VA7100? am i talking sense? a good article to read, especially page 4 http://www.hp.com/products1/storage/products/disk_arrays/infol ibrary/hp_va_and_san_virtualization.pdf any inputs related to configuring a rp7400 are invited. my initial specs based on my current k570 is below. current k570 (7.3.4) 4 * 200Mhz 2 gn ram specs for rp7400 (8i/9i) 4 * 550MHz 6 Gb ram and i thought it was easy. take a few procs add ram add few disks, (Baaam!) make sound and license and u hv a server. but look into a detailed partlist and configuration options at https://www.e-solutions.hp.com/shop/cgi-bin/sweetspot.cgi Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Mandar A. Ghosalkar 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: question about rman
Title: question about rman even in netbackup and ebu configuration, the hot backup starts only when the hot backup job is kicked by the netbackup schedular and not while in queue. The only problem is when the hot backup is started, mutiple netbackup jobs are created and queued for each tablespace. for ex, i hv 2 drives and i do parallel=2 in ebu, so two jobs are created simultaneously for 2 diff tablespaces. when one tablespace job (one dynamically created netbackup job) is finished, the next tablespace is put in hot and a seperate job is created and fired. now i hv say 15 tablespaces, and during this whole process my other operating system os files job is kicked in, it would create multiple jobs dynamically for each mount point. so tablespace1 hot started tablespace2 hot started tablespace1 hot complete tablespace3 hot started /u01 job queued tablespace2 hot complete /u01 job started this runs for 5 hrs tablespace3 hot complete .. .. so by the time hot backup finishes its early morning. solution: schedule job with proper timings and prioritise them. my 2 cents (sorry no change), my 1 penny :) -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21, 2003 1:17 PMTo: Multiple recipients of list ORACLE-LSubject: RE: question about rman even if that is true (which is news to me and might cause some consideration for our oltp databases...maybe) we won't be able to predict when the database will go down in the case of a cold backup. ...which we can't live with here. ...loads are scheduled for certain times throughout the night. even in the oltp environment, this might cause a performance degradation if the backups start after our call centers are open for business. thanks for the info though. i'll do some checking for omniback. -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21, 2003 2:37 PMTo: Multiple recipients of list ORACLE-LSubject: RE: question about rman Correct me if I am wrong, but I thought the backup software will only initiate the RMAN backup once your server has reached the top of the queue and it is ready to be written to tape. At least that's what happens with Legato. Regards, Sujatha -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Wednesday, 22 January 2003 7:05 AMTo: Multiple recipients of list ORACLE-LSubject: RE: question about rman The problem is that if we try and backup to tape, we have to wait in the queue. Depending on what is already there, we may have to wait a number of hours before RMAN has the opportunity write data to the tape. Believe me, we have tried to devise ways to predict when we could actually write to tape but the sys admin has stated over and over that he has no control over when a tape is available due to the queueing. In a cold backup this implies unacceptable downtime. In a hot backup it means that the database will be backed up over a very long period of time. So if we first backup to disk and then let omniback take the data to tape whenever it gets around to it, we'll still be able to due a recovery through RMAN if the necessary files are on tape (a place that RMAN is unaware of). note: obviously we are going to have to test this but i'd like to know that it is possible before i go through the trouble of coordinating something with the sys admins. thank you. -Original Message-From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21, 2003 1:31 PMTo: Multiple recipients of list ORACLE-LSubject: RE: question about rman I guess my first question is why not just backup to tape through the Omniback MML layer? Or, if you prefer to go to disk you can backup to disk with RMAN and then backup the backupset to tape through the MMLwith RMAN again. If you try to restore from an RMAN backup, and the required backup pieces are not there, RMAN will let you know. HTH, Robert Robert G. FreemanTechnical Management ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's everywhere that I am!)Author of several books you can find on Amazon.com! -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21, 2003 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: question about rman I could test this myself but that would require coordination with the system administrators and they always seem to think their time is too
RE: Netbackup [#2]
well this is old topic. but wanted to correct a few things. Backup exec can delete(purge) archive logs based on date. Create purge jobs and see to it that directories (junction points are preserved if all files from a directory are deleted). you dont hv to write a windows script to do this. As far as netbackup agent is concerned, it is used alongwith ebu/rman to backup/restore files, so it is needed for oracle hot backups. for colds it is optional. if you want cold w/o agent then you could write a script to shutdown and then use bpbackup to send the oracle files to tape. btw i havnt found a purge job feature in netbackup. -Mandar -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 3:43 AM To: Multiple recipients of list ORACLE-L Subject: Re: Netbackup [#2] Since no one else replied I will give you my experience: (Backupexec for oracle 816 on NT/2000) We are working with it and got backup speed up to 300MB per minute. There are some limitations: 1) Backupexec does not delete archive logs. We wrote a script that marked all existing archive logs before starting the backup and delete all the marked logs after the backup. 2) When restoring to a different machine, Backupexec creates a folder for each tablespace and restore the datafiles to this folder. You need to move the datafiles to their place in order to start the database. 3) Backupexec does not do recovery. You need to restore the archive logs that you think you need and then do recovery yourself. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 18, 2002 12:23 PM Is no-one out there using NetBackup???. Without wishing to sound rude I'll assume a non-response indicates an affirmative to that OR that you're all too busy to voice an opinion ;) -Original Message- Sent: Thursday, November 14, 2002 15:04 To: 'List, OracleDBA [Fatcity]' Howdy Folks, Would appreciate feedback on experiences, positive :) or negative :(, folk have had using Veritas NetBackup product for DB recovery, especially in DR scenarios. There is an Oracle agent but so far all it appears to me to be is a glorious scheduler of your own RMAN scripted jobs!. Feedback on features I may have missed with agent would also be appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandar A. Ghosalkar 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
RE: warehouse builder's dependance on oem job system.
Title: RE: warehouse builder's dependance on oem job system. Chris, if its a plsql job then tcl wrapper script in oem would be same. but your runtime parameters could be diff. As others have mentioned, u could just run package.main, just verify that the package has been configured with the right runtime parameters in OWB. btw when use the method (forgot that name for passing parameters ) "=" u need now worry about parameter position. -Mandar -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Friday, December 13, 2002 8:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: warehouse builder's dependance on oem job system. wow. thank you. i will be testing this in the afternoon but before i do, i have one more question. we have ~50 jobs we would like to cron instead of submit to oem. so my question is, are these tcl arguments in the same order and of the same # for every job? or is there some way to determine the order and position they should be when executing the package? thank you so much for your help. -Original Message- From: Mandar A. Ghosalkar [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 8:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: warehouse builder's dependance on oem job system. Chris, the parameters 3,2,50,1000,50,wb,10 are used inside the oem-owb job tcl script as set p_oper_mode [lindex $parList [incr parList_i]] set p_audit_level [lindex $parList [incr parList_i]] set p_num_errors [lindex $parList [incr parList_i]] set p_commit_frequency [lindex $parList [incr parList_i]] set p_bulk_size [lindex $parList [incr parList_i]] set p_purge_group [lindex $parList [incr parList_i]] set p_percentage [lindex $parList [incr parList_i]] and then the package.main is called try the following. i would recommend testing this on the test server before putting it on prod :-) sqlexec C40_ADMIN_CUSTOMER_MAP.Main(p_operating_mode = 3, p_audit_level = 2, p_max_errors = 50, p_commit_frequency = 1000, p_bulk_size = 50, p_job = 'wb'); -Mandar Original Message- Sent: Thursday, December 12, 2002 1:09 PM To: Multiple recipients of list ORACLE-L here is the tcl that was generated: "-r" "3,2,50,1000,50,wb,10" "-c" "WE8MSWIN1252" the package that is generated is quite long. i have absolutely no idea how to read the tcl. if you could point me somewhere, i could try and figure it out myself. any help is appreciated. attached is the package code if you are willing to take a look... (for some reason my computer associates .pls extensions with real audio) -Original Message- Sent: Tuesday, December 10, 2002 1:11 PM To: Multiple recipients of list ORACLE-L Chris, All the owb etl jobs are packages and if you have configured it right, then you could the execute the package_name.main procedure to run the etl process. your best best would be to read the tcl script and the associated parameters for the owb-oem job. You could paste the tcl and the parameters here to help u more. -Mandar -Original Message- Sent: Tuesday, December 10, 2002 9:31 AM To: Multiple recipients of list ORACLE-L ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running the jobs manually through owb. for obvious reasons we need to be able to schedule these jobs. the only way (that i know of) to schedule the owb jobs is to deploy them to entreprise manager. the problem is that our oem is VERY unreliable and seems to be related to bugs. we are running oem v9.2 and oracle ee v9.2. when jobs are scheduled through oem, they run sometimes and hang others. this is unexceptable. so my question is: does anyone know of a way to trap the commands that oem sends to the database? the obvious solution would be to just cron execution of the packages owb generates inside the database. this doesn't work though because owb generates funky code that takes parameters, whose values i don't know, for logging purposes. hopefully i explained the situation well enough. any ideas??i'd like to get rid of the dependance on oem. oem sucks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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
RE: Capacity Planning -- Expecting the DB growth !!!
Title: Blank so how r u gonna do it? 1 business object = n number of rows in m different tables + indexes if regular day then x number of business objects are created if holiday then y number of business objects are created and are u going to considering the historical growth ofdatabase objects during regular and holidays? do u hv tablespace space consumption for the last couple of yrs to get a good graph and extrapolate (?) it. -Mandar -Original Message-From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 6:19 PMTo: Multiple recipients of list ORACLE-LSubject: Capacity Planning -- Expecting the DB growth !!! Hello All, I am currently working on capacity planning of the database , expecting the database size based on the business object ,sales ( Historical data). I am not sure about the approach I am following . I believe there might be some better approach followed in some shop to estimate the DB size ,even by considering events like "thanks giving" , "holiday season" and all. Also I have to automate this process. Would like to know some best suggestions you always have in this forum. Would youhelp me in identifying some formulae. Any kind of documentation will be a great help !!! Thanks in advance, Madhu
RE: warehouse builder's dependance on oem job system.
true they hv default values, but i think the Chris's runtime parameters are diff than his default values. ill try to give another look at it come monday. -Original Message- From: Scott Canaan [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: warehouse builder's dependance on oem job system. I run the jobs via cron, without any parameters and we don't have any problems. If you look at the parameter list, you'll find that most (if not all) have default values anyway. I have been running them via cron for months without any issues, other than the fact that we can't multitask. Mandar A. Ghosalkar wrote: Chris, the parameters 3,2,50,1000,50,wb,10 are used inside the oem-owb job tcl script as set p_oper_mode [lindex $parList [incr parList_i]] set p_audit_level [lindex $parList [incr parList_i]] set p_num_errors [lindex $parList [incr parList_i]] set p_commit_frequency [lindex $parList [incr parList_i]] set p_bulk_size [lindex $parList [incr parList_i]] set p_purge_group [lindex $parList [incr parList_i]] set p_percentage [lindex $parList [incr parList_i]] and then the package.main is called try the following. i would recommend testing this on the test server before putting it on prod :-) sqlexec C40_ADMIN_CUSTOMER_MAP.Main(p_operating_mode = 3, p_audit_level = 2, p_max_errors = 50, p_commit_frequency = 1000, p_bulk_size = 50, p_job = 'wb'); -Mandar Original Message- Sent: Thursday, December 12, 2002 1:09 PM To: Multiple recipients of list ORACLE-L here is the tcl that was generated: -r 3,2,50,1000,50,wb,10 -c WE8MSWIN1252 the package that is generated is quite long. i have absolutely no idea how to read the tcl. if you could point me somewhere, i could try and figure it out myself. any help is appreciated. attached is the package code if you are willing to take a look... (for some reason my computer associates .pls extensions with real audio) -Original Message- Sent: Tuesday, December 10, 2002 1:11 PM To: Multiple recipients of list ORACLE-L Chris, All the owb etl jobs are packages and if you have configured it right, then you could the execute the package_name.main procedure to run the etl process. your best best would be to read the tcl script and the associated parameters for the owb-oem job. You could paste the tcl and the parameters here to help u more. -Mandar -Original Message- Sent: Tuesday, December 10, 2002 9:31 AM To: Multiple recipients of list ORACLE-L ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running the jobs manually through owb. for obvious reasons we need to be able to schedule these jobs. the only way (that i know of) to schedule the owb jobs is to deploy them to entreprise manager. the problem is that our oem is VERY unreliable and seems to be related to bugs. we are running oem v9.2 and oracle ee v9.2. when jobs are scheduled through oem, they run sometimes and hang others. this is unexceptable. so my question is: does anyone know of a way to trap the commands that oem sends to the database? the obvious solution would be to just cron execution of the packages owb generates inside the database. this doesn't work though because owb generates funky code that takes parameters, whose values i don't know, for logging purposes. hopefully i explained the situation well enough. any ideas??i'd like to get rid of the dependance on oem. oem sucks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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
RE: warehouse builder's dependance on oem job system.
Chris, the parameters 3,2,50,1000,50,wb,10 are used inside the oem-owb job tcl script as set p_oper_mode [lindex $parList [incr parList_i]] set p_audit_level [lindex $parList [incr parList_i]] set p_num_errors [lindex $parList [incr parList_i]] set p_commit_frequency [lindex $parList [incr parList_i]] set p_bulk_size [lindex $parList [incr parList_i]] set p_purge_group [lindex $parList [incr parList_i]] set p_percentage [lindex $parList [incr parList_i]] and then the package.main is called try the following. i would recommend testing this on the test server before putting it on prod :-) sqlexec C40_ADMIN_CUSTOMER_MAP.Main(p_operating_mode = 3, p_audit_level = 2, p_max_errors = 50, p_commit_frequency = 1000, p_bulk_size = 50, p_job = 'wb'); -Mandar Original Message- Sent: Thursday, December 12, 2002 1:09 PM To: Multiple recipients of list ORACLE-L here is the tcl that was generated: -r 3,2,50,1000,50,wb,10 -c WE8MSWIN1252 the package that is generated is quite long. i have absolutely no idea how to read the tcl. if you could point me somewhere, i could try and figure it out myself. any help is appreciated. attached is the package code if you are willing to take a look... (for some reason my computer associates .pls extensions with real audio) -Original Message- Sent: Tuesday, December 10, 2002 1:11 PM To: Multiple recipients of list ORACLE-L Chris, All the owb etl jobs are packages and if you have configured it right, then you could the execute the package_name.main procedure to run the etl process. your best best would be to read the tcl script and the associated parameters for the owb-oem job. You could paste the tcl and the parameters here to help u more. -Mandar -Original Message- Sent: Tuesday, December 10, 2002 9:31 AM To: Multiple recipients of list ORACLE-L ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running the jobs manually through owb. for obvious reasons we need to be able to schedule these jobs. the only way (that i know of) to schedule the owb jobs is to deploy them to entreprise manager. the problem is that our oem is VERY unreliable and seems to be related to bugs. we are running oem v9.2 and oracle ee v9.2. when jobs are scheduled through oem, they run sometimes and hang others. this is unexceptable. so my question is: does anyone know of a way to trap the commands that oem sends to the database? the obvious solution would be to just cron execution of the packages owb generates inside the database. this doesn't work though because owb generates funky code that takes parameters, whose values i don't know, for logging purposes. hopefully i explained the situation well enough. any ideas??i'd like to get rid of the dependance on oem. oem sucks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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: warehouse builder's dependance on oem job system.
Title: warehouse builder's dependance on oem job system. Chris, All the owb etl jobs are packages and if you have configured it right, then you could the execute the package_name.main procedure to run the etl process. your best best would be to read the tcl script and the associated parameters for the owb-oem job. You could paste the tcl and the parameters here to help u more. -Mandar -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002 9:31 AMTo: Multiple recipients of list ORACLE-LSubject: warehouse builder's dependance on oem job system. ok, here's the situation: we are loading our warehouse via etl processes generated by warehouse builder (owb). we went live with this a little over a week ago. up to this point we have been running the jobs manually through owb. for obvious reasons we need to be able to schedule these jobs. the only way (that i know of) to schedule the owb jobs is to deploy them to entreprise manager. the problem is that our oem is VERY unreliable and seems to be related to bugs. we are running oem v9.2 and oracle ee v9.2. when jobs are scheduled through oem, they run sometimes and hang others. this is unexceptable. so my question is: does anyone know of a way to trap the commands that oem sends to the database? the obvious solution would be to just cron execution of the packages owb generates inside the database. this doesn't work though because owb generates funky code that takes parameters, whose values i don't know, for logging purposes. hopefully i explained the situation well enough. any ideas??i'd like to get rid of the dependance on oem. oem sucks
RE: BackupExec Oracle
Title: BackupExec & Oracle oh one more thing i failed to mention, recovery is a real pain. it will restore files with a very scre*** up names. it removes all backslashes and makes one whole big filename. u then need to do some surgery on it. it is not as simple as ebu/rman. i think they r doing this purposely bcos they would like us to purchase netbackup instead of the cheaper scaled down product backupexec. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, November 25, 2002 11:12 AMTo: Multiple recipients of list ORACLE-LSubject: BackupExec Oracle Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas. (Read: Nothing has been written to tape lately. Thanks, Guys) I was also notified that "effective immediately" Veritas BackupExec is the software we are using. Any gotchas/experiences/comments from people who have used Backup Exec and the associated Oracle utility? Do you trust BackupExec to fire your rman backups, complete correct rman restores, etc.? I have shied away from writing directly to tape in the past but don't have the luxury of disk for rman backups anymore. I'm on Windows 2000 sp2, Oracle version 8.1.7.2 Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey and Terrible Perl Coder. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
RE: BackupExec Oracle
we use backupexec 8.6 and it does not lock oracle files on NT4 or win2k. if u use the purge options and create a archivelog purge job and u hv some antivirus s/w like norton, then the access times get messed up and backupexec is not able to pick up files properly. netbackup uses rman/ebu. backupexec does not use rman/ebu. it has its own oracle agent which puts tablespaces in backup mode and takes them out. pretty reliable and i hv tested out the recoveries. a scheduled windows u just need to make sure that admins keep enough tapes in the dlt's. the only problems i face is that the backup job is waiting for more tapes. the only drawback is commandline and reporting aspect. in netbackup on unix i could use available_media script and find out how much is the tape used. i hv yet to figure this out in backupexec. -Mandar -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 12:52 PM To: Multiple recipients of list ORACLE-L Subject: RE: BackupExec Oracle If you're using BackupExec to backup the server's filesystems as well as the Oracle DB, make sure it does NOT hit your database files directly. Some Winders admins don't understand that it'll lock the datafiles, redos, controlfiles, etc from the instance, causing all sorts of icky recovery scenarios. At least a few years ago, it locked them under NT 4.0. I don't know if this behavior has changed (or is possible to change under NuTFutS) in newer versions. Good luck! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, November 25, 2002 2:12 PM To: Multiple recipients of list ORACLE-L Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas. (Read: Nothing has been written to tape lately. Thanks, Guys) I was also notified that effective immediately Veritas BackupExec is the software we are using. Any gotchas/experiences/comments from people who have used Backup Exec and the associated Oracle utility? Do you trust BackupExec to fire your rman backups, complete correct rman restores, etc.? I have shied away from writing directly to tape in the past but don't have the luxury of disk for rman backups anymore. I'm on Windows 2000 sp2, Oracle version 8.1.7.2 Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey and Terrible Perl Coder. Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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: OT: Getting data out of DB2...any DB2 DBAs out there?
). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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).
wrong financial calendar for an open period in 10.7 NCA
Hello Guys, i have posted this in Oracle apps mailing list also. We have a situation here. We have an Open Period for Oct defined as 01/oct/02 to 30/oct/02. We posted AP with no problems. While importing the sales from a different application(non-oracle) into GL we received errors in the journal import concurrent program. Since the Oct end date is wrong, we found 3 different options infront of us to get this problem solved. 1. Oracle Supported way. Create different set of books and consolidate. Yuck 2. Oracle unsupported way. Rollback the entries for Oct. Correct calendar. repost entries. This has to be tested on the test instance first. 3. Oracle unsupported way. Since the entries in the GL Interface have not been posted yet, change the 31/oct/02 transactions to reflect 30/oct/02 and reimport the entries. This has to be done for sales/credits/payroll which use non-oracle applications. Tar has been raised with metalink. I was wondering if any of ull have gone through this situation and would appreciate your inputs. Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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: Theory v Practice
3 yrs after ur developers code the VB app, the original team vanishes(they start working on .net .. or maybe java) The new team even after going through the docs and vb application libraries, forget the right joins and insert invalid data/update rows in the master without taking care of the details/ delete some master records, etc. What next happens at the call center of ur company ? Believe me there would always be a legitimate need (not hack) to correct some data using sql*plus like tools. At that point you would need to depend on RI. -Mandar -Original Message- From: Craig Healey [mailto:C.Healey;hhsuk.com] Sent: Wednesday, October 23, 2002 10:45 AM To: Multiple recipients of list ORACLE-L Subject: Theory v Practice The developers working on our new VB app are also responsible for setting up the Oracle DB behind it. The app is for an order entry/despatch/warehouse system with 5 million customers and 1000 orders per day. We have nearly 400 tables. They are not planning on using primary keys/secondary keys, as they say they will handle all the constraints via VB. I only have a theoretical knowledge of database design, which says this is very wrong. Is the Oracle system being used as anything more than an expensive file system? In real world scenarios, is this a common practice? Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) ** * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Craig Healey 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: Mandar A. Ghosalkar 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: Opinions on BR scenarios
How would i specify this sleep command in a 7.3/ebu/nbu configuration? checking ebu docs.. -Original Message- From: Fink, Dan [mailto:Dan.Fink;mdx.com] Sent: Wednesday, October 23, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: Opinions on BR scenarios Under this scenario, you have 2 options 1) Incomplete recovery to 2:10:30. Since there are no tablespaces in backup mode, this is possible. 2) Do a complete recovery to the point of failure at 2:15:30. Of course, if the failure was manual (oops, I dropped a table in production), then this is not a valid recovery because it would return you to the state immediately following the failure. Also consider this scenario: Well after the backup has completed, it is determined that data has been logically corrupted and the database needs to be recovered to the point in time immediately prior to the corruption. If the corruption occurred at 02:15:30, the only option is to perform an incomplete recovery to 02:10:59. I looked in my notes from the Oracle8 Internals Seminar and this is the explanation. Incomplete recovery is not allowed during a hot backup (while ts was in hot backup mode). Because the high scn is not recorded (in the datafile), the recovery logic does not know how to perform a recovery. The first time when incomplete recovery is possible is at the checkpoint immediately following the end of hot backup mode (which may be delayed in some releases). Does this make sense? -Original Message- Sent: Wednesday, October 23, 2002 3:45 PM To: Multiple recipients of list ORACLE-L Dan, What you intend to say is that if the database crashed at say 2:15:30, you can do an incomplete recovery upto say 2:10:30, right? Why cant I do a complete recovery ? or what stops me from doing an incomplete recovery until 2:15:25? Raj snip 02:00 1st tablespace begins backup 02:10 1st tablespace ends backup 02:11 2nd tablespace begins backup 02:21 2nd tablespace ends backup 02:22 3rd tablespace begins backup 02:32 3rd tablespace ends backup etc. You could then perform an incomplete recovery until 02:10:01 - 02:10:59 or 02:21:01 - 02:21:59, etc. snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan 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: Mandar A. Ghosalkar 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: ETL architecture
and how are they going to connect to the database on server B? are they using odbc? millions of inserts using odbc over the network? -Original Message- From: paquette stephane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Subject: ETL architecture Hi, On all DW project I've been, the ETL tool was on the database server containing the DW database. On the current project, the architecture team has decided that the ETL tool (Data Junction) will be on its own server (Windows) to service all projects needing ETL processing. We are the first client of this approach. All sources will ftp their files on the unix box where the staging/data integration database is. So that means that the the ETL tool on server A will read the files and the reference tables from server B, process that on server A and insert the cleansed data on server B. Somewhere I'm not confortable with that approach. Any comments ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Mandar A. Ghosalkar 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: Session Data Unit and tcp.nodelay
are they similar 1700 sql statements differing by literals. if ur db is 8.x can u use cursor_sharing? hv u tried 10046 tracing? myabe the parse time for these 1700 sql is more than the perceived tcp gain u r trying to achieve. -Original Message- From: Schauss, Peter [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 1:05 PM To: Multiple recipients of list ORACLE-L Subject: Session Data Unit and tcp.nodelay We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships between parts. We are having some performance problems which seem to point to the database access. With sql tracing turned on, we determined that one of the operations in question used more than 1700 sql statements. The consultant we work with is suggesting that we try to improve the Net8 throughput either by seting tcp.nodelay or by adjusting the size of the Session Data Unit. A quick look at the Net8 manual suggests that both of these could potentially improve throughput by forcing packets to be sent out sooner instead of blocking several requests/responses together. Does anyone have any experience with these settings? Any suggestions as to what settings to try as a start? Thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter 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: Mandar A. Ghosalkar 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: Cache hit ratio?
If u r not kidding then attend hotsos clinic. r u sure u r not kidding can u catch the session which is not performing as it should from the end users perspective? get the top 5 wait events for that session. -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: Cache hit ratio? Hi One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I have noticed after week again cache hit ratio became low. Can u please suggest what other things I can do to fix this problem? Thx -Seema _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Mandar A. Ghosalkar 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).
Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-UX 11
Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar 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 trace file question
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: Mandar A. Ghosalkar 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: Mass inserts from TCL ?
Title: Mass inserts from TCL ? Hi Thomas, hv u checked oratcl? metalink note 1017044.6 -Mandar -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 5:23 PMTo: Multiple recipients of list ORACLE-LSubject: Mass inserts from TCL ? I have a programmer inquiring as to the viability of having up to 10-15 concurrent client sessions inserting orders that would contain anywhere from 100 to 6000 order line items each via TCL. The orders are generated from a browser client and the whole shebang has to be real-time. They initially planned on a loop within the TCL code, each line item being an individual insert into the order items table via a stored procedure. I'm still eliciting requirements, for instance, does the whole order need to commit or can they accept a partial order, and so forth. I'm not familiar with TCL at all, so if anyone has extensive experience in it, I would appreciate if you could share some programming techniques or ideas as to how to perform, if possible, some form of batch processing, rather than up to 6000 individual calls to the stored procedure. Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages'
RE: ArcServe 2000 Agent for Oracle
Jared, i hope u hv taken care of veritas nbu licenses. the resellers try to apply 1 Oracle agent license for each database instance instead of 1 license for each server machine. -Mandar -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 2:23 PM To: Multiple recipients of list ORACLE-L Subject: Re: ArcServe 2000 Agent for Oracle The ArcServe agent has a tendency to login to your database and never logout, eventually eating up all your processes or logins if you don't keep an eye on it. It also tries to backup TEMPORARY tablespaces by putting them in backup mode, generating an ORA-3217 in the process. FYI: We're replacing it this month with Veritas Net Backup. Jared On Sunday 01 September 2002 19:38, Jahan Shanai wrote: Hi, We are planning to use ArcServe 2000 Agent for Oracle to take Hot Backup of our one of the databases. I was wondering whether anybody encountered any issue? Thanks for youe feebback in advance. Jahan Environment: ArcServe 2000 Agent for Oracle Windows 2000 SP2 Oracle 8.1.7.2.1 Standard Edition Attention: = This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. If you are not the intended recipient, you are notified that any use, dissemination, or copying of any part of this e-mail message and accompanying data, is prohibited. If you have received this e-mail message in error, please notify us immediately and delete this e-mail message from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is there a way to determine which record was entered in last
If u r 9i, then create table t1 (c1 number) ; set serveroutput on; declare v1 number; begin insert into t1 values(1) returning c1+10 into v1; dbms_output.put_line(v1); end; more at http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a90125/statements_914.htm#2079891 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Subject: Is there a way to determine which record was entered in last Hi, I have records that have same key fields(PK was disabled) but other fields are different. Is there a way to determine which record was inserted in last. I do not think rowid would guarantee it. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
off topic - How to find used and free capacity on a DLT IV tape
Hello Guys, I am testing some backup scripts on a dlt library and trying to run manual backups. mc -p /dev/dltrobotics -s S15 -d D1 backup -f /dev/rmt/4m -i /prod1 -v Is there any easy way (other than keeping track of files being copied to tape) to find out space left on the tape(uncompressed/compressed)? I am using a Maxell DLT IV 40/70 tape on a HP DLT 7000. Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dbms_application_info package tips/horror stories
Hello guys, I am trying to implement a standard for my developers to use dbms_application_info package. I ran a 10046 trace against the package and i dont see much of load on the server. Would like to know any tips/horror stories associated with dbms_application_info. Just want to take precautions before we change all of ur apps. We hv tons of shell script jobs, cscripts, forms3, delphi, mid tier apps floating around our 7.3.4 databases. btw i am gonna use the esteemed Steven Feuerstein's variation of a wrapper for the package. Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
off topic - t1 line performance monitoring tool
Hello Listers, We have two t1 lines between two of our sites and facing some network performance issues. other than basic tools like tracert, do ull know about any network monitoring tools specific to t1 line issues. thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ids and passwords for application users
Title: RE: Ids and passwords for application users trying to understand how oracle 9i proxy authentication work. is anyone using it? -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Monday, July 29, 2002 4:28 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Ids and passwords for application users I always preferred the option of having a userid for each person, because it makes it easier to match session to user. When you say userid "dwilliams" locking a table you know who to call, but if you see userid "app_user" you have to do some extra work to track the person down. >From a developer point of view, it's easier to determine the name of the logged in user (use built-in "user" function) than it would be to find out the machine name / application name (select * from v$session). If you have only one username with a password hard-coded in the application, how do you plan on hiding the password from the user, or changing the password if it becomes compromised? -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Peter - Go with option #1 unless you relish a career as an Oracle security officer. With option #1 the developers can create some administrator screens. Unless security is really, really critical. -Original Message- I am in the process of designing a small database which may have as many as 250 to 300 users. We are reaching a stage where we need to decide how we will control access to this database. As I see it we have two options: 1. Provide a single hidden login for the entire application and control access to the applicaiton itself either by "roll your own" security or using the operating system (UNIX) controls. 2. Create ids for the users in Oracle and grant them access to the necessary tables using roles. Any opinions or alternate suggestions? Peter Schauss
RE: Cursor Sharing| Soft Parsing
we have a lot of delphi and forms3 apps and Session_Cached_Cursors is zero for my database (7.3.4). I am thinking of setting the above parameter to 50. Also would monitor the stat 'session cursor cache hits' before and after setting the parameter. Do i need to increase/decrease any other parameter with this change? btw found this bug [BUG:931820] Direct Load Fails When Session_Cached_Cursors is larger than 0 Pls advise if i am on a wrong track. Thanks Mandar -Original Message- Sent: Thursday, July 25, 2002 11:49 AM To: Multiple recipients of list ORACLE-L When a SQL execution is requested the Shared SQL is first examined to see if the statement is in memory. The first time SQL is processed it goes through a hard parse, the most expensive parsing operation. A hard parse performs the following: checking syntax; validating all database objects referenced, (tables and columns); naming translation, (synonyms); authenticating user privileges on all tables and columns; producing a SQL execution plan via the optimizer; hashing and storing the parsed statement in the Shared SQL Area. If the SQL statement is found in the Shared Pool then a soft parse may be performed in an attempt to use a shareable cursor. There are three types of soft parses: 1) The first time a SQL statement is found in the shared pool Oracle performs name translation, user authentication, and adds the user to the authentication list. 2) On the second soft parse name translation does not need to be performed but user authentication does just in case user privileges were changed since the last execution.; 3) An entry is created for the session's cursor cache and future cursor CLOSEs are ignored. Once in the session cursor cache the SQL statement does not need to be reparsed. This gives a significant performance boost! Giving credit where due: The above was inspired from pages 277-280 in Scaling Oracle8i by James Morle. Steve Orr Bozeman, Montana -Original Message- Sent: Wednesday, July 24, 2002 11:08 PM To: Multiple recipients of list ORACLE-L Importance: High Please define soft parsing. Oracle needs to check that the user submitting a SQL statement has permissions to run it. It has to do this every time a statement is run, bind variables or not. I thought the processing of the statement to check permissions to be soft parsing. But, perhaps I'm misinformed. When cursor-sharing converts a statement to use bind variables it would save on hard parsing, if a match were found the pool; also, it could lessen the number of statements present in the pool. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: flexfield for Supplier's email address in 10.7NCA
John Are you looking at a form that already has a ff that you can modify? The Delpi program querying this will have to deal with the right ATTRIBUTEnn column (I think) on the view that results from the DFV. I need the Payables clerk to enter the email address for a Supplier. So i am talking about the Supplier Entry form APXVDMVD (ver 8.6.165). There is a DFF square bracket indicator just below the Tax Registration Number on my 10.7 NCA client with forms 4.5.10.13.0 But clicking on it does not invoke a popup page(bcos no DFF has been defined for that form). Although we have a test db instance on diff sever from the production, both of them share the same midtier. We have different urls to access the prod and test apps. but there are few folks who are worried that while testing with DFF, we corrupt the midtier forms, because they saw a COMPILE button on a FlexField setup form. Also here we try to avoid outside consultants, so the burden lies on me to find a solution. -Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Netbackup BusinessServer ver 3.3/3.4/4.5 on HP-UX 10.2
Last try -Original Message- Sent: Tuesday, July 23, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Hello Listers, We are about to call veritas for a netbackup businessserver solution for our databases on hp k570 10.2 boxes A Veritas Vendor is proposing Netbackup BusinessServer 4.5 on hp 10.2 Any of ull implemented ver Netbackup BusinessServer ver 3.3/3.4/4.5 on HP-UX 10.2 ? Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
flexfield for Supplier's email address in 10.7NCA
Anyone using a flexfield for Supplier's email address in 10.7NCA AP? We want to record an email for the Supplier which we can use to send PO. But we are on MSOB and to upgrade to 11i would take some time. Reading the manuals on Flexfields, but if someone has any tricks, pls let me know. Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: flexfield for Supplier's email address in 10.7NCA
John, Thanks for caution. btw we need a descriptive flexfield with minimal validation. also the email entered by the Payables Clerk would be queried and processed by an external homegrown delphi app, so i am not sure what Custom code in 10.7 u r referring to. i do hv a test database which i can break. came to know that we do pay membership fees to OAUG. just need to find who is NOT using the OAUG resources and get the login info. just listened to the flexfield class on ilearning. need to learn more about FlexBuilder. Would appreciate any links other than manual :) on descriptive flexfields. -Mandar -Original Message- Sent: Wednesday, July 24, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Mandar, Anyone using a flexfield for Supplier's email address in 10.7NCA AP? We want to record an email for the Supplier which we can use to send PO. But we are on MSOB and to upgrade to 11i would take some time. Reading the manuals on Flexfields, but if someone has any tricks, pls let me know. Are you sure you are the one who is asked to do this? This should fall under the realm of a 'Functional' person. And what about the Custom code that will be required to process this field? That will be the realm of a 'Technical' person (read Developer in Apps-ese). Changing Flexfields is not a trivial issue and is certainly not something a 'normal' DBA should do... And you _have_ to stick to the Apps guidelines, which are numerous. In other words, this is like asking a automobile driver to modify the blueprints of a car. This is not to discourage you, but maybe the Organization should get someone who has to fill these roles... More details at www.oaug.org and of course the manuals! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Want to know about a carpenter who built a bridge with two sticks and three nails? Write me for details! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Netbackup BusinessServer ver 3.3/3.4/4.5 on HP-UX 10.2
Hello Listers, We are about to call veritas for a netbackup businessserver solution for our databases on hp k570 10.2 boxes A Veritas Vendor is proposing Netbackup BusinessServer 4.5 on hp 10.2 Any of ull implemented ver Netbackup BusinessServer ver 3.3/3.4/4.5 on HP-UX 10.2 ? Thanks Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
faster refreshes of Datamarts;Shareplex;ETL;Asynchronous Replication
Hello guys, i was wondering if any of ull use Quest Shareplex for Datawarehouse ETL and/or Reporting instance. i am creating a data mart/reporting instance. The source database is a 7.3.4 on HP-ux 10.2 The destination(development) is 9i on Win2k. Still not figured out the platform for 9i (production). 1. has anyone used Shareplex to transfer logs from 7.3.4 to 9i on different platforms. 2. i havent worked with replication. are there sites which use readonly snapshots for creating reporting databases between different db versions. is it feasible and recommendable? 3. i am going to use direct path exp and also try to get exp compiled as single task. are there any success stories by making exp as single task. 4. The developers want to try out asynchronous replication on few of our large tables. any tricks ull use to refresh reporting/datamarts having different versions. if the source had been 8/9 i would hv tried PEL or transportable tablespaces, but with 7.3.4 as sources i am short of ideas. TIA Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: listener configuration on HP serviceguard clusters
Title: listener configuration on HP serviceguard clusters
Matt,
i hv 2
nodes in hp mc/sg non-ops config. each hving production instances. also each
providing failover for other node.
:(
7.3.4 on 10.2
each
has it own listner listener_${ORACLE_SID}
Node
1:
listener: LISTENER_SID1 on 1555
Node
2:
listener: LISTENER_SID2 on 1556
We use package address(name) in the
listener.ora
When failover happens for either node onto
standby node, cant u start different listener for each failedover instance.
hth
Mandar
-Original Message-From: Adams, Matthew (GEA, MABG,
088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 11,
2002 2:15 PMTo: Multiple recipients of list
ORACLE-LSubject: listener configuration on HP serviceguard
clusters
If anybody out there is using HP ServiceGuard for
non-OPS/RAC, I would be interested to know how you
configure the listeners. Do you use the machine IP
address or the package address in the listener.ora (or
do you not have a listener.ora and use dynamic
registration)
One of the sys admins here instists that the following
scenerio will not work.
three nodes - two with one package each (containing
Oracle) and one standby node.
When the first package fails over to the standby node, it
starts a listener using no listener.ora file, allowing
the instances to dynamically register. When the
second package fails over to the standby node, it does
not start a listener.
All client tnsnames.ora files use package names for
HOST.
Do the instances in the second package register successfully
with the listener and can clients connect to
them?
Matt Adams - GE Appliances -
[EMAIL PROTECTED] Enter any 11 digit prime number
to continue.
SAN - Oracle - Pitfalls - Adv/Disadvantages??
Hello Guys, any guys here who have SAN. We are inviting a SAN vendor for possible solutions for our enterprise. i am unaware about how SAN would affect me as DBA. Also we are thinking about how we can use OS level block replication between two database servers located in different cities(SF and LA). any suggestion about pitfalls? TIA Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Diagnostic and Tuning Packs
, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Diagnostic and Tuning Packs
Jared, I can start OEM Change Manager 9.0 and edit a table rename script, add my own custom code and let oem run that as a job, or copy the sql and run it from sql*plus. Mandar -Original Message- Sent: Monday, May 13, 2002 1:44 PM To: [EMAIL PROTECTED] Cc: Mandar A. Ghosalkar All the events in OEM 2.2 and 9 use tcl scripts. Also u can use OS script and create ur own events scripts. Mandar, That may be so, but that doesn't give you access to the scripts that OEM generates to accomplish the change. As for writing my own TCL ( ugh ), if I have to write it myself anyway, I don't need OEM. Jared Mandar A. Ghosalkar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/13/2002 01:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Diagnostic and Tuning Packs Jared, All the events in OEM 2.2 and 9 use tcl scripts. Also u can use OS script and create ur own events scripts. for eg, i have an oem job which does a logical export for my unix and windows oracle databases and then fire a tcl script to change the export filename to add the timestamp. Also the change propogation is implemented as scripts which u can modify and copy them to write ur own. Also, Dennis, in 9i oem Performane Manager u can hv Statspack style reports. The Performance Data Report collection option allows you to collect a set of data that is similar to the Oracle STATSPACK utility. the only drawback i found was of version compatibility. In our enterprise (7.3,8.0,8.1,9.0) i becomes a headache sometimes maintaing the agents, management servers and consoles. Mandar -Original Message- Sent: Monday, May 13, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Kimberly, The difference was that OEM gave push buttons only. If the change operation failed, there was no access to the underlying scripts. Quest gives you that access, which can be very important in the case of failures. OEM is strictly a black box, or at least it was when we looked at it. Maybe it's changed since then? Jared Kimberly Smith [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/12/2002 01:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle Diagnostic and Tuning Packs And I normally don't disagree with you Jared but in this case I must. I evaluated both quite extensively just a month or so ago. They both give you the same type of control really, just in a slightly different format. OEM's was actually easier to use with no prior instruction. Both are push button per say. Just a different look at the push buttons. I actually would have probably used Quests in the end but their pricing structure can at times be a little brutal, even compared to Oracle's OEM. I would have been perfectly happy to take OEM. In the end we are getting neither cause of budget issues. Embarcadero's was disappointing at best. It provided very little mechanism for flexibility. -Original Message- Sent: Sunday, May 12, 2002 11:08 AM To: Multiple recipients of list ORACLE-L I will have to respectfully disagree with that, at least in part. There is a big difference between change management in OEM tools and Quest tools, Quest's tools being much better. The OEM tools are push button, just like MicroSlush garbage. Meaing: The OEM tools do no give you near the control over managing change and synching schemas across databases that Quest's tools allow. Having said that, I don't use either. Had I a need for serious change management though, Quest would win hands down. Jared On Sunday 12 May 2002 06:43, Yechiel Adar wrote: Hello Peter We did a comparison between quest tools and OEM. The bottom line was that all these tools gives you about the same functionality and there is no BIG difference between them. Our manager got a better deal from Oracle so we bought these packs. We hope to start implementing them this quarter. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 10, 2002 5:58 PM Are these addons to OEM worth buying? Thanks Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
