RE:
Hi Niall, We´ve already tried this. Anyway , thanks for your help. Antonio "Niall Litchfield" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> .pipex.com> cc: Sent by: Subject: RE: [EMAIL PROTECTED] 28/05/2003 21:14 Please respond to ORACLE-L Yeah like I know forms or 9iAS, right Have you tried a UNC path eg \\serverb\sharename\form_name.fmx in place of the drive mapping. In general for an app server you wouldn't generally wish to rely on a logged in users environment. Cheers Niall > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 28 May 2003 16:30 > To: Multiple recipients of list ORACLE-L > Subject: > > > We have two servers: Server A running iAS ; Server B running > IDS 9 and serving files. > > We map one drive from server B to server A and we are trying > to access the forms on the remote driver: > http://host:port/forms90/f90servlet?form=f:\form_name.fmx But we receive an error saying that the servlet could not read the form file. If we copy the file from f:\ to a local drive , ie , c:\temp , the form can be executed succesfully. We are aware of a known bug issue in the old OAS that prevent using forms apps running on remote drivers . but we think that it could (and should) be fixed on iAS. Does anyone facing the same problem or trying to do something similar on IAS ?? Both server are running Win2K. Thanks in advance, Antonio Belloni -- 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: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message
Re: Oracle Financials and IBM/AIX Platforms
Hi Thomas, We are running Oracle Applications Release 11.5.8 on an RS6000 F80 with 4 procs , 8 Gb RAM and 12 x 9.1 Gb , RAID 01 , SSA disks. Both application and database are on the same machine. The database have almost 50 Gb and there are aprox. 50 concurrent users , using four modules: GL , AP , INV and PO. We´ve migrated this environment from an RS6000 F50 recently and the performance increased a lot. We´ve been running Oracle Applications on IBM machines since release 10.7 and the performance and scalability are very good. I don´t know the size of your database or the number of users that your´re planning to support , but the P650 (2-to8 way , 2-to-64Gb RAM , up to 587.2 GB internal storage) is a mid-range solution and I think it can support high mission-critical applications easily with performace and scalability (I don´t work for IBM :- ). HIH, Antonio Belloni "Mercadante, Thomas F"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED]cc: te.ny.us>Subject: Oracle Financials and IBM/AIX Platforms Sent by: [EMAIL PROTECTED] 28/05/2003 15:56 Please respond to ORACLE-L All, Anybody running Oracle Financials on an IBM/AIX platform? I've been asked for opinions on running the latest version on an IBM P650 platform running AIX. This would be just for the database itself. Any suggestions for required memory/disk? I know I need to provide more info (like how many users etc), but I'm just looking for a thnumbs up/down on the hardware for now. thanks Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem running form app in 9iAS
We have two servers: Server A running iAS ; Server B running IDS 9 and serving files. We map one drive from server B to server A and we are trying to access the forms on the remote driver: http://host:port/forms90/f90servlet?form=f:\form_name.fmx But we receive an error saying that the servlet could not read the form file. If we copy the file from f:\ to a local drive , ie , c:\temp , the form can be executed succesfully. We are aware of a known bug issue in the old OAS that prevent using forms apps running on remote drivers . but we think that it could (and should) be fixed on iAS. Does anyone facing the same problem or trying to do something similar on IAS ?? Both server are running Win2K. Thanks in advance, Antonio Belloni -- 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).
[no subject]
We have two servers: Server A running iAS ; Server B running IDS 9 and serving files. We map one drive from server B to server A and we are trying to access the forms on the remote driver: http://host:port/forms90/f90servlet?form=f:\form_name.fmx But we receive an error saying that the servlet could not read the form file. If we copy the file from f:\ to a local drive , ie , c:\temp , the form can be executed succesfully. We are aware of a known bug issue in the old OAS that prevent using forms apps running on remote drivers . but we think that it could (and should) be fixed on iAS. Does anyone facing the same problem or trying to do something similar on IAS ?? Both server are running Win2K. Thanks in advance, Antonio Belloni -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AIX question
Hi, For SCSI drivers: lsdev -C | grep hdisk hdisk0 Available 00-01-00-0,0 2.2 GB 16 Bit SCSI Disk Drive hdisk1 Available 00-01-00-1,0 2.2 GB 16 Bit SCSI Disk Drive the third field represents location (controller) and SCSI id , where: 00-01-00- = Controller 0,0 = SCSI id For SSA drivers: lsdev -C | grep pdisk pdisk7 Available 1A-08-HS01-06-P SSA160 Physical Disk Drive pdisk8 Available 1A-08-P SSA160 Physical Disk Drive The third field is the controller ID , where 1A-08 = Controller ID -HS01-06-P = Enclosure identification and disk position in the loop , if you are using an external SSA disk array. -P = SSA internal loop to obtain information about controller: lsdev -C | grep 1A-08 | grep -v disk HIH, Antonio Belloni Boyle Candi <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> ens.com> cc: Sent by: Subject: Re: AIX question [EMAIL PROTECTED] 21/02/2003 16:35 Please respond to ORACLE-L And, though I'm not sure if you need root to run it, I remember smitty was a wonderful little menu-driven tool for finding such information. And you hit a key combo that would show you the actual command for future reference. You'll have to forgive the vagueness, it's been quite some time since I had to use AIX. (Ah, the party we had when they took that RS6000 out of here) -Candi On Fri, 2003-02-21 at 13:39, Gene Sais wrote: > Everything in IBM land is 'ls...' something. I think lscfg should give > you more info, not sure of all the switches. > Gene > > >>> [EMAIL PROTECTED] 02/21/03 12:19PM >>> > > > AIX 4.3.3 > Can anyone tell me if there's a command to determine what volumes/disks > are on each controller? > > I'm way out of my element here but the SA for this system is scarce. > > Thanks for any suggestions, and have a great weekend everyone > > Lisa Koivu > Oracle Database Administrator > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > Office: 954-935-4117 > Fax:954-935-3639 > Cell:954-683-4459 > > "The sender believes that this E-Mail and any attachments were free of > any virus, worm, Trojan horse, and/or malicious code when sent. This > message and its attachments could have been infected during > transmission. By reading the message and opening any attachments, the > recipient accepts full responsibility for taking proactive and remedial > action about viruses and other defects. The sender's business entity is > not liable for any loss or damage arising in any way from this message > or its attachments." > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- > Author: Koivu, Lisa 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 othe
Re: Installing 8.1.7 on a machine with an existing 9.0.1 installation
Hi, There´s a bug about your problem reported on Metalink. According to the bug report , you cannot install any 8i product on NT/W2K after 9i been already installed. To solve the problem you can use Universal Installer 2.0.1 , found at the Oracle 9.0.1 bundle. If you have access to Metalink check notes 172096.1 , 183939.1 and bug report 2019978. HIH, Antonio Belloni Stefan Jahnke v.de>cc: Sent by: Subject: Installing 8.1.7 on a machine with an existing 9.0.1 installation [EMAIL PROTECTED] 14/11/2002 08:13 Please respond to ORACLE-L Hi everybody I'm about to throw my laptop out of the window (I'm on Win2k). I have an existing 9.0.1 installation (server and developer tools like designer and jedevelop). That works. Now I need to install an additional 8.1.7. If I run the installer from 8.1.7, it tells me that the component oracle.swd.jre 1.1.8.10.0 is missing while checking the dependencies (after you decide the installation type, before the list of available products/options is displayed). Checking the components in the stage directory, it shows that it is really missing. Next try was to install 8.1.7 using the 9.0.1 installer. Installation works, but hangs at the end ... great. Next try was to take the oracle.swd.jre 1.1.8.10.0 component from 9.0.1 (where it exists) and copy it to the 8.1.7 stage and to create the property files. No success. Any ideas, or do I have to remove everything, then install 8.1.7 first, folowed by 9.0.1 and the developer tools. That would be very diappointing. Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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: 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: AIX related
Hi Vladimir, To find number of procs: # lsdev -C | grep proc To find amount of physical memory: # lsattr -l sys0 -E or # lsdev -C | grep mem and to each memory board # lsattr -l mem0 -E HIH, Antonio Belloni Stephane Faroult <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: AIX related 02/09/02 12:08 Please respond to ORACLE-L > Vladimir Barac wrote: > > Hi! > > How to find out number of CPU's and ammount of RAM on AIX machine? > > Thanks, > Vladimir For the number of CPUs the most portable command I have found is SQL> select value from v$parameter 2 where name = 'cpu_count'; I wish there were the same thing for memory ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: 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: Any do's and dont's for a 9i oracle installation on RedHat Linux
Hi Ray, I have Oracle 8.1.7 and 9.0.1 running on an Suse 7.2 box configured with ext3 file systems. Both instances are working properly and without major issues. Suse 7.2 comes along with a variety of file systems , including ReiserFS , ext3 , ext2 , Aix´s JFS and other that I can´t recall now. Regards, Antonio Belloni Ray Stell <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L u><[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: Any do's and dont's for a 9i oracle installation on RedHat Linux 29/08/02 10:38 Please respond to ORACLE-L Not on the oracle topic: RH is pretty insecure out of the box. If you don't take steps to lock it down the machine will be compromised within the hour in our experience. There are some good web pages out on the steps that need to be taken: http://www.sans.org/newlook/projects/bastille_linux.htm http://www.sci.sdsu.edu/People/Bill/basic_sec.html I'd suggest the use of iptables: http://www.cs.princeton.edu/~jns/security/iptables/ That said, I have a screaming 8.1.7.4 server running on RH 7.1. I am unhappy with the oracle support matrix for RH, however. It seems to have stalled a 7.1. I'm thinking of giving SuSE 7.2 a run since it is supported, hoping the ext3 filesystem is there. RH7.1 only has ext2. The seemed to be pushing the RH advanced server with 9i, which seems like a real Redmond, WA thing. On Thu, Aug 29, 2002 at 02:08:19AM -0800, Docherty, Heather wrote: > I am installing RedHat Linux and oracle 9i on two RM servers. > > I have never run Linux before. I usually run HP L-class or Sun Sparc > servers with 8/8i. > > I would welcome emails with tips anybody has for avoiding anything I don't > know that I should be avoiding yet, if you see what I mean! > > OT: Does anyone know why running startx, after boot-up to a Linux text > prompt, causes the shutdown -r to hang the box and not reboot? > > Heather > Napier University > Edinburgh, Scotland > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Docherty, Heather > 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). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: EXP-00010 HELP
Hi, You can´t export intermedia schema (CTXSYS) due to metadata and licensing issues. If you wish to copy your database , you must rebuild the intermedia schema. Refer to Metalink´s doc id # 65116.996 for more information. HIH, Antonio Belloni "Bernard, Gilbert" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] cc: Subject: EXP-00010 HELP 18/04/02 15:23 Please respond to ORACLE-L This is a valid user in database but not to export somebody has any idee o solve it. /sscedre/data/spcedw/admin/export[oracle]# exp userid=system/manager file=CTXSYS.dmp log=CTXSYS.log owner=CTXSYS Export: Release 8.1.7.2.0 - Production on Thu Apr 18 17:43:10 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.2.0 - 64bit Production Export done in WE8ISO8859P15 character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) About to export specified users ... EXP-00010: CTXSYS is not a valid username or not an exportable username Export terminated successfully with warnings. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: Ron Rogers 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: Bernard, Gilbert 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: 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, i
Locally Managed Tablespaces
Hi, Anyone using LMT for rollback segments ? Any issues , suggestions , ... ? TIA, Antonio Belloni -- 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).
Re: Linux command to display total disk capacity
Hi, To see the size of all disks and partitions (SCSI and IDE): PHS7:/proc $ cat partitions major minor #blocks name 8 02202244 sda 8 12200873 sda1 8164406935 sdb 8174401778 sdb1 8324406935 sdc 8334401778 sdc1 3 0 14668416 hda 3 11951866 hda1 3 2 1 hda2 3 5 128488 hda5 3 6 12586896 hda6 3649770544 hdb 365 1 hdb1 3699767457 hdb5 sda = size of the first SCSI disk. sda1 = size of the first partition on the sda disk. hda = size of the first IDE disk. hda = size of the first partition on the ide disk. HIH, Antonio Belloni "Marin Dimitrov" To: Multiple recipients of list ORACLE-L @sirma.bg> cc: Sent by: Subject: Re: Linux command to display total disk [EMAIL PROTECTED]capacity m 05/03/02 13:13 Please respond to ORACLE-L - Original Message - > Does someone know what command can be used to display total capacity of disk > drive? I can use command "df -k" but it breaks partitions apart so I have > to add them up. I need command just display a total. > for an IDE drive do: cat /proc/ide/xxx/capacity ...where xxx is the disk drive u're interested in (hda, hdb,...). The size returned is in 512b blocks for SCSI it's not that easy hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov 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: 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: Slight OT : Size of MS SQLServer Databases
Mark, Thank you very much for you help. Regards, Antonio Belloni "Mark Leith" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity.Subject: RE: Slight OT : Size of MS SQLServer com Databases 28/01/02 13:40 Please respond to ORACLE-L Hi Antonio If the database is only 20-30 gig, then I don't think that you'll have any problems with SQLServer managing this - it's not "large" in real terms. If you already know Oracle then (IMHO) the learning curve for SQLServer will be fairly easy going (I've trained on both in this order too, and found it *very* easy to pick up). This is not to say that there won't be an outlay for training though.. You can connect an apache server to a SQLServer database (AH HA! This is freeware though ;P Even though it's bundled with Oracle..). You can't program with VBScript if you don't use IIS, but you aren't using this on your Oracle side of things, and it probably adds more to the learning curve.. Database connectivity to a SQLServer database through Apache is handled with the Perl DBI module, and the relevant DBD:: module. Note that DBD::Sybase is probably the way to go to get to SQLServer. They both share a common code base, and the Sybase driver is reputed to work better than the SQLServer one. Check out: http://www.apache-asp.org/faq.html#How%20is%20databc9095df5 You can also use Tomcat as well AFAIK, and it most probably sets up in the same way as Apache. I'd still push to go with MySQL though personally, it performs better, it's free, and you can run it on a LINUX server with Apache and the Perl DBD::MySQL module just as easily.. Just my £0.02 - but hey, what do I know! ;P HTH Mark -Original Message- [EMAIL PROTECTED] Sent: 28 January 2002 15:30 To: Multiple recipients of list ORACLE-L Hi Mark, It will be a tipically B2C site. We estimate the size on 20-30 Gb and number of concurrent users depends of the sucess of the site. >From all the companies that we have contact and are using SQLServer , the biggest production database was 8 Gb. Being an Oracle shop and considering the costs of training/implementation/installation we think that it is our best option in the commercial databases arena. Management is only considering the price to buy a new software/a new Oracle license. That´s why we are so worried about adopting SQLServer to this project and we want stress all the possibilities and see if it´s able to scale if the database/application grows fast. Another concerning is about the application server. SQLServer will run only in winNT/2000/XPpro. Will we be able to run a different application server than IIS and connect to the database ? Thanks for your help, Antonio Belloni PS.: We are big fans of free software and known the potential of the architecture, but it´s totally out of question in this shop. Kind of "Free software here ?! No way It´s serve only nerds and hackers purposes...". Management..tsk,tsk,tsk. "Mark Leith" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity.Subject: RE: Slight OT : Size of MS SQLServer com Databases 28/01/02 10:00 Please respond to ORACLE-L "if u consider SAP DB then u may take a look at http://www.sap.com/solutions/technology/benchmark/HTML/SD_2_tier_4x.htm which contains some outdated benchmarks for SAP R/3 running on different databases and u'll see that SAP DB outperforms
RE: Slight OT : Size of MS SQLServer Databases
Hi Mark, It will be a tipically B2C site. We estimate the size on 20-30 Gb and number of concurrent users depends of the sucess of the site. >From all the companies that we have contact and are using SQLServer , the biggest production database was 8 Gb. Being an Oracle shop and considering the costs of training/implementation/installation we think that it is our best option in the commercial databases arena. Management is only considering the price to buy a new software/a new Oracle license. That´s why we are so worried about adopting SQLServer to this project and we want stress all the possibilities and see if it´s able to scale if the database/application grows fast. Another concerning is about the application server. SQLServer will run only in winNT/2000/XPpro. Will we be able to run a different application server than IIS and connect to the database ? Thanks for your help, Antonio Belloni PS.: We are big fans of free software and known the potential of the architecture, but it´s totally out of question in this shop. Kind of "Free software here ?! No way It´s serve only nerds and hackers purposes...". Management..tsk,tsk,tsk. "Mark Leith" <[EMAIL PROTECTED]> Sent by: cc: root@fatcity.Subject: RE: Slight OT : Size of MS SQLServer com Databases 28/01/02 10:00 Please respond to ORACLE-L "if u consider SAP DB then u may take a look at http://www.sap.com/solutions/technology/benchmark/HTML/SD_2_tier_4x.htm which contains some outdated benchmarks for SAP R/3 running on different databases and u'll see that SAP DB outperforms MS SQL in some configurations" I think that Antonio was actually trying to *SAVE* money - not spend *more* ;) Another option to look at (and very popular for web backend databases and is *free*) is MySQL. I am currently working on a project for our web site that involves MySQL with PHP, and Perl with the DBD::MySQL module, and have to say for *our* needs this set up seems like it is more than enough.. I guess the ultimate question to ask (and I haven't seen this yet) is how big do you want the database to be? What is the projected size of this database? How many concurrent users do your foresee having? There has been talk of SQLServer taking up to a terabyte of data, spread across a clustered Win2K environment (no I have no link, or reference, but can remember this posted on a web site *somewhere* out there). But this means spending BIG-TIME just on the kit to host it.. What do you *need* to achieve? Mark -Original Message- Dimitrov Sent: 28 January 2002 11:45 To: Multiple recipients of list ORACLE-L > > Please , correct me if I am wrong , but as far as I know , Personal Oracle > is single-user. It´s intend to be a desktop database. > maybe u could consider some free databases? of course the performance, functionality and the ease of use won't be comparable to MS SQL but many sites use such databases quite successfully if u consider Postgres SQL and take a look at http://www.pgsql.com/user_gallery/ u'll see production databases ranging from 10GB to 150GB if u consider SAP DB then u may take a look at http://www.sap.com/solutions/technology/benchmark/HTML/SD_2_tier_4x.htm which contains some outdated benchmarks for SAP R/3 running on different databases and u'll see that SAP DB outperforms MS SQL in some configurations hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. &quo
RE: Slight OT : Size of MS SQLServer Databases
Hi Patrice, Please , correct me if I am wrong , but as far as I know , Personal Oracle is single-user. It´s intend to be a desktop database. Thanks for you help , anyway. Antonio Belloni "Boivin, Patrice J" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]<[EMAIL PROTECTED]> mpo.gc.ca> cc: Sent by: Subject: RE: Slight OT : Size of MS SQLServer [EMAIL PROTECTED] Databases 27/01/02 16:05 Please respond to ORACLE-L Did you ever consider purchasing Personal Oracle? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: 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).
Slight OT : Size of MS SQLServer Databases
Hi, We are evaluating databases to our web site and the candidates are Oracle and MS. We already have Oracle running on our production environments , but , mainly a cost-based decision , management don´t want to buy Oracle to the web site. So , we want to know how big are the MS databases out there. Thanks in advance, Antonio Belloni -- 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).
RE: limit user CPU usage
If you are using 8i , you can setup Resource Manager. For more info about this subject see Oracle Administrator´s Guide. HIH, Antonio Belloni "Carle, William TTo: Multiple recipients of list ORACLE-L (Bill), <[EMAIL PROTECTED]> ALINF" cc: <[EMAIL PROTECTED]Subject: RE: limit user CPU usage om> Sent by: root@fatcity. com 15/01/02 16:30 Please respond to ORACLE-L Hi, You can set up a profile to set resource limits and have the user use that profile. This is explained in the Oracle Administrator's Guide. Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 15, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Hi, Guys, Is there some parameters or user-profile prometers in Oracle can limit user CPU usage? I mean, make specific user or all users use less CPU, I has a SQL query that use 100% CPU. I know the SQL is bad, but before developer change it, Is there something I can do? Any suggestion will be highly appreciated. My environment is Oracle8.1.6 on Win2000. Thanks, Kevin Wang -- 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).
Sqlnet dead connection detection (DCD)
Hi, We´ve setup DCD , using SQLNET.EXPIRE_TIME = 5 in sqlnet.ora , but it´s not working. The dead connections are not being disconnected. Is there any further configuration or issue to care about ? Oracle = 8.0.5.1 running with MTS OS = AIX 4.3 Net8 Thanks, Antonio Belloni -- 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).
Oracle Terminal
Hi, We need to disable PrintScreen key on Oracle Forms/Reports. Does anyone know how to setup this in Oracle Terminal ?? TIA, Antonio Belloni -- 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).
Re: linux for oracle
Hi, We have several Oracle 8.1.6 databases running on Slackware 7 (kernel 2.2.13 , glibc 2.1) boxes and everything is working perfectly. The uptime of one of the "servers" is almost 300 days. HIH, Antonio Belloni Paul Drake <[EMAIL PROTECTED]>@fatcity.com on 17/08/2001 14:21:32 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: other mailing lists ORACLE-LINUX-L its at fatcity SuSE-Oraclee-mail: [EMAIL PROTECTED] Micheal Hasenstein of SuSE Linux mentioned on the SuSE-Oracle list "Even the very latest 2.4 kernel is not as stable as 2.2.19.SuSE." So I'd recommend SuSE 7.1 with a 2.2.19 kernel for Oracle 8.1.7 and SuSE 7.2 with a 2.4.7 kernel for Oracle 9i. It really depends upon what filesystem and logical volume manager (if any) you want to use. They both Linux (RH and SuSE) - and you can add on or upgrade the components as you desire. The trick is - if you're going to use it in production - how to remain in an "Oracle supported configuration" (which is a very fuzzy matter). hth, Paul Jon Walthour wrote: > > Uma: > > >From what I've seen and used myself, SuSE seem to be officially endorsed distro. I've heard of people installing on RedHat, but I've also heard (especially concerning 9i) that it is a pain in the a__ to get working--if at all. > > Jon Walthour > > > > From: "Rao, UmaSankara S (CAP)" <[EMAIL PROTECTED]> > > Date: 2001/08/17 Fri AM 08:23:37 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: linux for oracle > > > > Hi Gurus, > > > > Can u please tell me the most stable version of Linux on which I can install > > Oracle 8i? > > > > Thanks in advance > > Uma > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rao, UmaSankara S (CAP) > > 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: Jon Walthour > 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: Paul Drake 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: 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).
Triggers in 8.1.6
Hi, I found the following in the Oracle Application Developer´s Guide: >>Do not create recursive triggers. For example, creating an AFTER UPDATE >>statement trigger on the Emp_tab table that itself issues an UPDATE >>statement on Emp_tab, causes the trigger to fire recursively until it has >>run out of memory. So , there is no more "Table is mutating..." errors ?? How does oracle guarantees the integrity on the table ?? TIA, Antonio Belloni -- 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).
RE: OT RE: 24 x 7 on NT?
Hi, The GUI is nice and very productive , but how an OS could pretend to be 24x7 when if you change configuration you must restart the computer. Regards, Antonio Belloni "Sherman, Edward" <[EMAIL PROTECTED]>@fatcity.com on 26/06/2001 19:42:48 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: It isn't monochrome anymore... Really! :-) http://www.themes.org/php/pic.phtml?src=shots/990462645.jpg -Original Message- Sent: Tuesday, June 26, 2001 6:12 PM To: Multiple recipients of list ORACLE-L Oooh...wow! Quick, maybe we should run out and convince 90% of the business world that their entire infrastructure is a complete and udder pipe dream and that the idea of trying to simplify our lives with the GUI is also just a big fat waste of time. Then everyone can get rid of their computers that have windows and Unix can take over the world. Yeah...archaic coding at a monochrome terminal..jeez the future looks so bright KK :) * * * * * Freedom of Information Act Notice * * * * * The information in this email is subject to the record protection mandated by 5 United States Code 552(b)(4) and relevant judicial opinions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Edward 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: 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: 9i On Linux
Hi, But Larry Ellison said that Oracle requires less hardware , network infrastructure and IT professionals. <:-0 Regards, Antonio Belloni "Joe Raube" <[EMAIL PROTECTED]>@fatcity.com on 15/06/2001 18:02:27 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: >From Linux release notes: http://otn.oracle.com/docs/products/oracle9i/pdf/9i_lin_relnotes.pdf The following requirements must be met to perform a typical Oracle9i software installation. Memory: A minimum of 512 MB of is required to install Oracle9i Server. A minimum of 512 MB is required to install Oracle9i Management and Integration. A minimum of 128 MB is required to install Oracle9i Client. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 15, 2001 4:20 PM > Can any of you just confirm that Oracle 9i requires 500M of memory on Linux? > > Thank, > > Waleed > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: 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: Re: OT - Wrap-up of 'Serious Question ' - now book idea - hig
Yeah , I think that family is the most "sacrificed" part. If I would write a book , I would have to do it in my free times ( evenings , nights , weekends ) , and usually this is the time that I have to spend with my wife and kid. Regards, Antonio Belloni "Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>@fatcity.com on 11/06/2001 10:15:57 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: hig I haven't written it yet :), but Don G. and I have talked about writing it together a couple of times. The only thing stopping me from the attempt is the how much time it'll take me away from my kids. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. > -Original Message- > From: Paul Drake [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 09, 2001 9:30 PM > To: Multiple recipients of list ORACLE-L > Subject: WAS: Re: OT - Wrap-up of 'Serious Question ' - now > book idea - > high > > > [EMAIL PROTECTED] wrote: > > > > Hi Jim, > > > > I have an idea for a book. I don´t know if it has been > written before , but > > I think that it would be very useful to a lot of people. > > > > Oracle High Availability: > > - Recovery scenarios (The author could put scripts to > backup archive logs , > > tips about archiving , recovering , how Oracle process > instance recovery , > > case studies , etc...); > > - Stand-by Databases (concepts , implementations , pitfalls > , etc...); > > - OPS (concepts , implementations , pitfalls , etc...); > > - Replication (as a tool to keep another database in sync > with production > > databases); > > - Hardware concepts (redundancy , RAID controllers , > clusters , SANs , > > etc...); > > - Tips & Techniques for a 24 x 7 x 365 environment > (administration , online > > backups , archiving , change manegement , etc...); > > - It could have a chapter with an overview or introduction > about Oracle 9i > > Real Application Clusters. > > > > If is there a book similar , sorry about the waste of time > , and , please , > > could you give me the name of this book ?? > > > > Regards, > > Antonio Belloni > > > > Antonio, > > A book covering some of this material already exists: Oracle > 24x7 Tips & > Techniques > > http://www.osborne.com/oracle/index.html > http://www.bookpool.com/.x/sshhpzr290/sm/0072119993 > > I'm not making a recommendation either way - I read the book some time > ago, and thought it was good, but that was many books ago. My > standards > are likely to have risen - then again - I might get alot more > out of it > the second time thru. > > Chapter 19 is available online at the osborne site - "Builing a > Real-World Arsenal". > > > A book covering some of the Backup and Recovery material would be > Oracle 8i Backup and Recovery Handbook - Velpuri - which has no less > than 22 case studies listed. > (Just don't expect to get any good NT backup scripts there). > > > In general, your best bet is to stick to the papers published in this > area - as you are much more likely to find individual topics discussed > in a white paper format that are recent enough to be useful. So much > high-avail material is platform-dependent - it would be difficult to > assemble something across all platforms - and fit it into a > single book. > > Tim Gorman's paper on High-Avail - > http://www.evergreen-database.com/TD_HA.pdf > > You ask about: > > - It could have a chapter with an overview or introduction > about Oracle 9i > > Real Application Clusters. > > I would suggest visiting the IOUG.org site. > Here is one paper as an example - #114 > "An Introductiono to High Availability Solutions" by Brian McGraw > Okay - its only introductory - but you have to start somewhere. > > > (no surprise here) - I would also recommend searching Metalink > http://metalink.oracle.com/ > here are some examples from the Technical Library for high avail > > Failover Issues and Limitations [Connect-time failover and > TAF] 97926.1 > 8.0.x-8.1.x: Sample config for Transparent Application 69745.1 > Dead Connection Detection Explained 2061476.6 > > > Do you want someone to simply re-use the Oracle Documentation on the > subject, or get advice from someone that has actually used > the product? > It seems to me that you won't see a book on such things until > 12 months > after it has been released - while you might see individual papers
RE: OT - Wrap-up of 'Serious Question (believe it or not)...'
Hi Jim, I have an idea for a book. I don´t know if it has been written before , but I think that it would be very useful to a lot of people. Oracle High Availability: - Recovery scenarios (The author could put scripts to backup archive logs , tips about archiving , recovering , how Oracle process instance recovery , case studies , etc...); - Stand-by Databases (concepts , implementations , pitfalls , etc...); - OPS (concepts , implementations , pitfalls , etc...); - Replication (as a tool to keep another database in sync with production databases); - Hardware concepts (redundancy , RAID controllers , clusters , SANs , etc...); - Tips & Techniques for a 24 x 7 x 365 environment (administration , online backups , archiving , change manegement , etc...); - It could have a chapter with an overview or introduction about Oracle 9i Real Application Clusters. Of course , someone would ask "Why don´t you write it yourself ??". 1st : I have a 1-year old baby to take care , and I can´t let all the duties ( and happiness :- ) to my wife; 2nd : I take care of 15 databases on my daily job and none of them is 24 x 7 x 365. So , I don´t feel comfortable to write about the matter; 3rd : My English isn´t good. If is there a book similar , sorry about the waste of time , and , please , could you give me the name of this book ?? Regards, Antonio Belloni "Hawkins Family" <[EMAIL PROTECTED]>@fatcity.com on 09/06/2001 11:05:21 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Yes, but this leads to virtual hang-over which is a very good thing... ^ Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 501 Pearl Drive St. Louis, MO 63376 (636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (personal) ^ -Original Message- Aschenbrenner Sent: Friday, June 08, 2001 6:33 PM To: Multiple recipients of list ORACLE-L I think I've had too many virtual beers. I'm getting a virtual buzz Alan -Original Message- Sent: Friday, June 08, 2001 3:46 PM To: Multiple recipients of list ORACLE-L Always glad to spread some semi-on-topic humor on Fridays. It helps me out of the daily drone mode... By Monday, I'll be back to my serious, helpful, wannabe-guru self! Cheers, everyoneand another round of virtual Guiness on me! Jim > > Oh god Jim, this is the best laugh I have > had in days! > > Thank you, thank you, thank you! > > Jared ( still laughing ) > > On Friday 08 June 2001 08:47, Jim Hawkins wrote: > > > > > "Hidden Parameter, Crouching Developer - or How I Learned to Love the > > Larry" directed by Jim Hawkins. > > > > Starring (not in order of importance): > > *Larry Ellison as God > > *Bill "Shrek" Thater as The Enforcer (a gentle assassin with a > > compassionate heart) > > *Ross Mohan as Hannibal (speedo-wearing cannibal) > > *Rachel Carmichael as The Goddess (a do-good angel caught between Heaven > > and Hell) > > *Jared Still as Charlie (the voice behind the chair) > > > > And anyone else that wants a part, just let me know. Haven't built a > > story-line yet, but wht could possibly go wrong with this winning > > combination film? > > > > But seriously, sorry about this post - it's Friday, I'm in a good mood, and > > have my databases all running so well, that I could spend 15 minutes typing > > this email. > > > > Virtual Guiness Stout to all on the list, compliments of my new film > > company. > > > > Jim > > -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins 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: Alan Aschenbrenner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
OT: Oracle price politics
Hi, Few days ago someone posted a link to a newsletter about the slashing of the prices of Oracle products in Japan and that Larry Ellison would announce price reductions that will apply worldwide. Someone can send me the link ?? TIA, Antonio Belloni -- 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).
Re: How to drop unique index
Hi, Did you try : SQL> drop index index_name ; ?? HIH, Antonio Belloni "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>@fatcity.com on 30/05/2001 05:50:25 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Hi Gurus, I tried to drop unique index using "ALTER TABLE table_name DROP UNIQUE (column_name);" unsuccessfully. How should I drop the unique index ? Please advise. Thanks. SQL> SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_NAME COLUMN_NAME -- -- -- U_SPYADH_2 SPY_ADHOC_PAYMENT STDNAME SQL> SELECT INDEX_NAME,TABLE_OWNER,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_OWNERTABLE_NAME UNIQUENES -- -- U_SPYADH_2 SPYSPY_ADHOC_PAYMENT UNIQUE SQL> ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME); ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP UNIQUE (STDNAME) * ERROR at line 1: ORA-02442: Cannot drop nonexistent unique key SQL> ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2; ALTER TABLE SPY.SPY_ADHOC_PAYMENT DROP CONSTRAINT U_SPYADH_2 * ERROR at line 1: ORA-02443: Cannot drop constraint - nonexistent constraint Regds, New Bee -Original Message- From: Manivannan.M [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: catrep.sql Hi It will be there under $ORACLE_HOME/rdbms/admin regards, Manivannan.M -- On Tue, 29 May 2001, Timajo, Joel - Equicom wrote: > hello oracle gurus! > > i just tried a default installation of oracle 8.0.6 to our hp-unix machine. > i followed step by step the procedures as stated in the oracle installation > guide. my problem is when it comes to the step (pp 4-2 of the installation > guide) that says run the catrep.sql. where can i find this sql script? > > thanks! > oracle newbie > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manivannan.M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: 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).
[OT] Jobs in UK
Hi fellows, Sorry for the offtopic but I had been in UK last week and my friends from there told me that there is a shortage of IT professionals and , that if you really got the skills , is very easy to migrate and find a job. But none of my friends are IT professionals and I don´t know how much they know from this market. So I wish to know , if possible , from the IT professionals working in UK if it is really easy to find a job and migrate ? What are the governamental restrictions ? How much we can earn in a year of work ? Where I can find more information about immigration to UK ? TIA, Antonio Belloni -- 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).
