OFS and MSCS
To implement OFS, Oracle 9i Database, on W2K do you need to implement MSCS too? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Hiding passwords
So the story goes like this. We're a NT/W2K shop. We have various scripts that run DB related jobs but these are in plain text and we'd like to "hide" these passwords in some way to allow scripts to run but the passwords not be "visible" to potential prying eyes. Has anyone cracked this one yet. I've had a trawl around MetaLink but found nothing of substance. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
RE: OT- Start a process after oracle on Win 2K
Peter, An option you might want to investigate writing your script command file, using the W2K resource kit utility, (can't think of it's name right now, to convert it to a service. Set service to startup automatically and then create a dependency on Oracle service for this new service to prevent it starting a head of Oracle. Haven't tried above myself but as with lots of MS stuff the theory is there ;) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] >>From: [EMAIL PROTECTED] >> Date: Tue, 1 Apr 2003 22:28:28 +1000 >> Subject: OT- Start a process after oracle on Win 2K >> >>Hi >>Slightly OT >>I have a couple of programs that need to be run after Oracle has started >>and want to run them without a user logging in. >>The likely place seems to be in the scheduled tasks running at startup or >>as a program under the local run key in the registry. >> >>The processes are a couple of scripts and I would envisage running them as >>a batch file >>What is best? 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.net -- 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).
RE: Sizing databases
>>From: Paulo Gomes <[EMAIL PROTECTED]> >> Date: Thu, 13 Feb 2003 12:04:56 - >> Subject: Sizing databases >> >>Hi people >>Need some to fresh size a new database (9iR2, or other). >>Any one happens to know were i can get such tool??? >>Please >>Paulo Gomes I don't believe there is a "one size fit's all" tool for sizing a database. If the DB is being used as a backend for an application then the application vendor may be able to provide assistance. Otherwise it's affected by such parameters as volumes of data and possibly rought cut sizing using largest row as a barometer. Also try "sizing oracle database" as search string in google!!! HTH, - 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.net -- 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).
RE: AT command ??
>> From: Janet Linsy <[EMAIL PROTECTED]> >> Date: Thu, 13 Feb 2003 13:59:04 -0800 (PST) >> Subject: AT command ?? >> >>Hi all, >> >>Can anyone give me some examples of AT command in >>windows? Thank you! >> >>Janet C:>AT 00:00 /every:T,W,TH,F,S cmd /c "F:\Oradba\b73\cold_backup.cmd" Schedules command file to run at midnight Tue to Sat. C:>AT 16:15 cmd /c "F:\Oradba\b73\cold_backup.cmd" Schedule command file to run at 16:15 today. C:>AT -? Help on AT command. C:>AT \\server List scheduled jobs on server HTH, - 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.net -- 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).
RE: Newbie to Oracle DBA
fidential 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.net -- 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).
RE: Disaster Recovery
>> From: "Farnsworth, Dave" <[EMAIL PROTECTED]> >> Date: Thu, 6 Feb 2003 09:55:51 -0600 >> Subject: RE: Disaster Recovery >> >>>>-I'm thinking some type of crib sheet with useful commands for that DR >>>>-situation might be useful too. >> >>This is one of my main ways that I survive, I really like cheat sheets. Also have a $50 bill in the folder to go buy beer >>afterwards, you'll need it. ;o) Yo Dave, Any chance you might send me a copy of your cheat sheet. If you send it snail mail and a $50 bill get's stuck to it I don't mind ;) - 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.net -- 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).
Re: Disaster Recovery
>> From: =?iso-8859-1?q?Connor=20McDonald?= <[EMAIL PROTECTED]> >> Date: Thu, 6 Feb 2003 23:25:17 + (GMT) >> Subject: Re: Disaster Recovery >> >>You'll want to ensure that any other files that used >>in conjunction with the database are backed up with >>their locations well-noted. >> >>- listener config files >>- parameter files >>- stored parameter file >>- oracle password files >> >>etc etc Hi Connor, Forgot to mention that our backup scripts also includes backups of the above but thanx for the reminder in any case. - 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.net -- 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).
Disaster Recovery
We're in the process of updating our DR plan and adding some more detail !. So I've been racking the auld grey matter and trying to identify a list of useful hardcopy documents which would be really useful for DR. The type of documents you store in a folder at home and bring along should the sh#t hit the fan. What I've come up with so far is: [1] Over view diagram of server showing disk config details and locations of various key database files. This doc also includes high level server spec and IP info. [2] Relevant Technical Operating Procedures. [3] Log forms for DB restore and backup. [4] List of dirs per server included in tape backup schedule. [5] List of backups per server including info on backup dirs and locations of log files. [6] List of scheduled jobs on each server, time, freq, command line to submit. [7] Copy of DR plan and Technical manual for primary production system on CD. The following get backed up disk-to-disk T,W,Th,F,S and are included on tape incremental: Binary and text dumps of control file. Script which creates dynamic script to run offline database backups. Disk to disk backup of database. Archived redo logs. I'm thinking some type of crib sheet with useful commands for that DR situation might be useful too. So what else would you as a DBA like to have in this folder to support a smooth and efficient as possible DR?. Oh yeah our SLA is that we recover DB as was at time of last working day (M-F) backup. - 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.net -- 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).
RE: Error extensions in the alrtXXX.log
>> From: Denham Eva <[EMAIL PROTECTED]> >> Date: Fri, 24 Jan 2003 11:03:47 +0200 >> Subject: Error extensions in the alrtXXX.log >> >>Hello List, >> >>Pls help, I am busy playing with a Perl script which I want to read through >>the error log file each day and mail me when an error has occurred. >>I have already created the part that will be backing up the alrtXXX.log to >>another file. So that it starts afresh each morning. >>OK here are the obvious ones I personally can remember, please let me know >>of others that I can scan for. >> >>ORA- >>PLS- >>Errors >>IMP- A few others that might be worth considering for inclusion are: TNS- TRC cannot checkpoint (?) exceeded crash recovery corrupt warn fail HTH, BTW, was not aware that PLS- or IMP- type errors messages could get populated into ALRT log! - 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.net -- 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).
RE: over-normalized?
>>From: "Saira Somani" <[EMAIL PROTECTED]> >> Date: Thu, 23 Jan 2003 10:59:33 -0500 >> Subject: over-normalized? >> >>Is there such thing as an over-normalized database design? >>What defines over-normalization? And what are its consequences? (Other >>than the obvious degraded database performance and lots of tuning) >> >>I hear rumblings that our ERP system is over-normalized. >> >>Just curious, Following sites might provide some info of use: http://www.fmsinc.com/tpapers/datanorm/ http://cpcug.org/user/access/Presentations/Normalization/index.htm http://www.cc.utexas.edu/cc/dbms/utinfo/relmod/normal1.html http://www.tdan.com/i001fe02.htm http://www.doxa.ro/DOCS/SY_PERFORMANCE/1088.htm - 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.net -- 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).
RE: BMC's Patrol
>> From: "KENNETH JANUSZ" <[EMAIL PROTECTED]> >> Date: Thu, 23 Jan 2003 13:42:39 -0600 >> Subject: BMC's Patrol >> >>Is anyone using BMC's Patrol tool on their Oracle DB? If so, what do = >>you like / dislike about it? Any problem areas? Customer support from = >>BMC? FWIW, the local BMC folks here wanted to charge us consultancy time to evaluate their product so we didn't evaluate it! - 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.net -- 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).
Insufficient quota problem
Recently we've had three of our 8.1.7 databases on W2K servers crash with messages similar to below in relevant alert logs: ORA-00202: controlfile: '' ORA-27091: skgfqio: unable to queue I/O OSD-04006: ReadFile() failure, unable to read from file O/S-Error: (OS 1453) Insufficient quota to complete the requested service. Instance was terminated by CKPT. I've had a good trawl through Metalink and basically the postings suggest it's down to one of following: [1] Quota management enabled on disks. [We don't have!] [2] Possibly running low on physical and/or virtual memory. Nothing written to event logs on servers to indicate this was the case. If anyone else out there experienced the same problem AND managed to eliminate it I would appreciate your feedback. Heck, I'm open to suggestions on troubleshooting this one. - 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.net -- 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).
RE: [Q] SMON take too much time to clean up?
>>From: "dist cash" <[EMAIL PROTECTED]> >> Date: Wed, 15 Jan 2003 07:23:54 -0500 >> Subject: [Q] SMON take too much time to clean up? >> >>we have ORACLE 8.1.7 on NT server and this erver only run ORACLE >>application. Sometime the server will have 100% CPU usage form 20 minutes >>to couple hours. In that time No one can login or do anything. We guess >>the problem come from SMON, but all of the tablespaces pct_increase is 0 >>(except SYSTEM). The only thing I can guess is SMON clean the Temporary >>Tablespace (our temporary tablespace define as dicrionary Temporary >>temporary tablespace). Does their has way to reduce or avoid this >>problem? If you have not already looked at the following MetaLink Doc's might be of use/interest re above: 164768.1 116236.1 61997.1 118883.1 76438.1 HTH, - 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.net -- 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).
RMAN - GUI or CLI?
Apart from potential ease of use, are there any "compelling" reasons to use RMAN via some form of GUI interface over CLI?. I believe RMAN can be managed! via OEM. Does anyone know if there is an associated financial cost to implement this and once implemented what advantages does it provide compared to RMAN CLI?. Does anyone have a favourite and trusted 3rd party application which they use to manage RMAN?. - 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).
oraperf.dll issue
8.1.7.1.1 - W2K SP2 we're getting warning messages in the Event Viewer as follows. >>The data buffer created for the "Oracle8" service in the "C:\WINNT\system32\oraperf.dll" library is not aligned on an >>8-byte boundary. This may cause problems for applications that are trying to read the performance data buffer. Contact the >>manufacturer of this library or service to have this problem corrected or to get a newer version of this library. It's related to the Windows performance monitor but aside from that I have no idea what it is or how to address it. Does anybody have idea what this is, or the effect of it on the system if any? Can we ignore this warning or should we act on it? Any answers or suggestions are greatly 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).
RE: Monitoring Tool Evaluation methodology
Hi there, If you are interested I can send you a word document which I used to select and evaluate an Oracle monitoring tool solution which might be useful for adapting to your needs. We're an NT/W2K site. BTW, we choose Quest I/Watch as our solution. Did not come across eHurkha product during our evaluation. HTH, - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] >>From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] >>Sent: Thursday, November 28, 2002 5:44 PM >>To: Multiple recipients of list ORACLE-L >>Subject: Monitoring Tool Evaluation methodology >> >> >>We are evaluating a monitoring Tool (eGurkha) for Unix/NT/Oracle monitoring >> >>What features should be Looked into while Evaluating ? >>Are there any Best practices for doing this kind of Evaluation ? >>Any Comments on this tool in particular by any who might have used this >>tool ? >> >>etc.. 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).
Oracle policy document
Hi Folks, We've recently started to partake in development of a quality manual for our site. Part of this will be an IT Policy Document which will in turn have a section on "Oracle Policy". My initial thoughts are that it will include sections on: - Security (including Audit Trails) - Projects - Configuration & Installation - Data loading - Backup & Recovery If anyone has a similar type of Oracle policy document they would be willing to share I'd appreciate it, or if you have any constructive input as to "areas" which should be included, or if you know of any useful sources for material for same pleez let me know. With thanks in advance :) - 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).
RE: Oracle OS level security
Jared, Very interested in the "thread" you hypothetical raised. I'm working in a pharamceutical site which is subject to FDA and other regualtions part of which is the whole buisness of audit trails. We has a Standard Operating Procedure which states that whilst DBA's have a access to data they will not change it. A recognition of the DBA's capabilties but stating on paper company trust they will "behave" themselves. On a more practical point with NT/W2K Oracle audit trail can be set to write audit trail records to the event logs. DBA's can be prevented from changing the event logs. So now it would take at least 2 people to instigate a fraud. Hey this might foster even better relations between DBA's and SA's ;) Just my 2 cent worth :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] >> From: [EMAIL PROTECTED] >> Date: Tue, 26 Nov 2002 14:40:24 -0800 >> Subject: Oracle OS level security >> >>Dear list, >> >>Let me toss a hypothetical situation at you. etc. etc. 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).
RE: Slightly OT - Who would you take with you...
> -Original Message- > Sent: Monday, November 25, 2002 4:05 PM Robert, I can dig where you are coming from with your request. The replies it generated were worth a read too. In them there were some good points re the relative usefulness of an archive and the difficulty of trapping those true nuggets which reflect usually hard won experience in a sometimes hidden or obscure corner of Oracle. When I started on the list I used to hardcopy postings I deemed useful. Hardcopy 'cos like you I didn't really have "soft space" for them. I gave up in disillusionment from trying to find a way to file and more importantly be able to quickly retrieve these hardcopies by using some sort of keyword lookup. I used to number the hardcopy and log it in a spreadsheet with key words against it. This spreadsheet functioned as my index to articles! So now I'm curious as to how you are/were planning to lookup a topic or issue. Something as simple as search all mails for word "X"?. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] > To: Multiple recipients of list ORACLE-L > > > Board - > > If you had to choose the 10 top posters here at > Oracle-L who provided the > biggest input and > knowledge, who would they be? Who are the top 10 > Oracle Guru's on this news > group? I'm asking because my mailbox is FULL, and I > have to trash a large > amount of the stored stuff thats here. I'm going to > archive some of it to > CD, but I have limited space, so I want to archive > those people who are > constantly offering the most insightful advice (I > know it's available > online, but I'm not always online and it's nice to > be able to search these > emails for targeted content). > > Anyone want to take a crack at a list? You are > welcome to email me private > if you are afraid you would hurt someone's feelings. > I'd be happy to compile > the lists and report back to the group the overall > answers, but all email to > me will be treated as strictly confidential. > > > Robert > > > Robert G. Freeman - Oracle OCP 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).
instance shutdown problem ? (please help)
John, Off the top of my head. Is correc tinit.ora being used and are Control files in expected locations? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] >>From: john <[EMAIL PROTECTED]> >> Date: Sat, 23 Nov 2002 15:21:26 -0800 (PST) >> Subject: instance shutdown problem ? (please help) >> >>ver 8i NT4.o >>all services have been set to automatic and start fine >> >>however the NT Event Viwer and the oracle "alert.log" >>show that the instance being shutdown just after the >>box boots up. >> >>how do we rectify this problem ? >> >>below is from the alert.log >> >>ORA-205 signalled during: alter database mount exclusive.. >>Shutting down instance (abort) >>License high water mark = 5 >>Instance terminated by USER, pid = 144 >>--- >>please note: the shutdwon was not initiated by any admin >>or user but done by the system itself after the box boots >>up. 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).
Reserving memory
[Saga Start] Recently on one of our production servers (W2K) the Oracle.Exe was consuming 99%-100% CPU and users were unable to create new sessions, getting ORA-12500 error. Even via server console we could not get a SQL*Plus or SVRMGR connection. Tried to shutdown DB using ORADIM but that returned TNS-12560 error. Bottom line we were forced to stop OracleService. Unfortunatley performance was so bad we were unable to determine which Oracle process was causing issue. We have our suspicions however =:-0 [Saga finish] So we're wondering if there is a way, when using dedicated server for session connections of "reserving" some memory to facilitate a connection to database to try a more elegant shutdown (assuming that it would work)? If there is another way of shutting down in such a scenario lets hear about that too! - 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).
Netbackup [#2]
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).
NetBackup
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).
Named users! - final clarification
Thanks folks for your replies on my initial query. Just to clarify by example, how many named user licences would I need for a database with following users. Forgetting minimum purchase requirements I suspect it's 3 is this correct? USERNAME -- SYS SYSTEM OUTLN DBSNMP BLOGSJ LARSONG GATESB - 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).
Shutdown/Startup user
Does anyone know if it is possible to create a user who only has rights to Shutdown a database?. I'm thinking about scenario that if the password for this user were ever compromised, e.g. seen in a script then worst case scenario would be database might be shutdown. Indulge me on this please as I acknowledge that a shutdown could be source of major revenue loss. This is been driven by requirement to have a script to cleanly shutdown a database potentially outside hours when DBA is not on site. If anyone has any other practical suggestions for management of this requirement I'd appreciate hearing them too. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - 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).
RE: Shutdown Immediate
Ravi, FWIW, Some random thoughts/ideas: Most likely not the case, and not wishing to cast any aspersions to you, but I take it SYS is not using SYSTEM as temporary tablespace!. Perhaps a large batch process needs to be rolled back before shut down? If you use DBMS_JOB apparently "stuck" tasks on same could be source! Check to see if one or more of Oracle's background processes are eating away CPU time which might provide a clue I take it you've had a look around MetaLink? PS: When you do find the cause please post solution to the list to enlighten us :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] >>From: Ravi Kulkarni <[EMAIL PROTECTED]> >> Date: Sat, 5 Oct 2002 02:01:58 -0400 >> Subject: Shutdown Immediate >> >>Gurus, >> >>Solaris8/Oracle 8173-32bit. >>Shutdown abort works but Shutdown immediate hangs. Startup Normal is fine. >>No special entries in Alert log regarding smon/pmon >>activities-postStartup/During Shutdown. All DB Sessions/connections >>cleaned/killed before shutdown. Tried several times. >> >>Any Hints? >> >>TIA, >>Ravi. 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).
8.1.7 patch it up?
I'm administering a number of production databases (mixture of standard and enterprise editions) most of which are version 8.1.7.0.0 on Windows NT and 2000. All are functioning fine and I have no issues. I'm considering patching (to 8.1.7.4) some if not all databases and just want to know if this is an absolute must if all systems are currently running fine. In other words does "if its not broken, don't fix it" apply? Also, I'm considering implementing RMAN in the near future and am wondering if there are significant issues with this on the unpatched 8.1.7 database. - 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).
RE: DBA place in the business
Hi Peter, FWIW, in our org (pharmaceutical manufacturing) the DBA role sits in the Information Technology section of the Business Systems & Information Technology Department. Senior DBA reports to IT Manager who in turn reports to Chief Information Officer (CIO). The CIO is a senior manager who reports to the the General Manager. I have quite a detailed formal job description for the DBA role too. Let me know if you'd like a copy. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] >> From: "Robson, Peter" <[EMAIL PROTECTED]> >> Date: Thu, 26 Sep 2002 09:18:13 +0100 >> Subject: DBA place in the business (was RE: DBA work load) >> >>I've found the thread on DBA workload valuable and interesting. It endorses >>points made repeatedly over the past years, basically the highly variable >>nature of the job. >> >>This variability is giving us a small problem. Our dba work (shared between >>two of us) tends to function in the background, and of course because we do >>it so damn well (!!), our impact on the running of the organisation is >>pretty low. Kind of 'reverse exception' effect, if you will. >> >>There is now a desire to formalise the role of the dba function within the >>organisation, and nobody has the first idea of how to define, in an >>organisational / structural sense just how the dba role slots in. I'm >>talking about organsiational charts, herarchies etc, that sort of thing. Not >>just across the org, but particularly within the IT domain too. >>Specifically, dba impacts from the low-level hardware side, right up to >>application development, with everything in between. And that already spans >>several existing lines of management responsibility. Our problem has added >>spice as we are (trying) to operate a matrix management system, which >>repeatedly throws up intriguing political dimensions. >> >>Anybody ever been down this particular route? >> >>Any thoughts much appreciated, >> >>peter >>edinburgh 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).
ODBC limits
I'm trying to get information of the limitations of ODBC drivers, specifically Oracle's and Microsoft's drivers for Oracle. Things like maximum no. of records they can fetch etc. As I know very little about ODBC (which might be reflected in the nature of my question) I hope I'm asking a sensible question. I'm asking as there are some developers here who are getting a variety of error messages when dealing with large volumes of data from 8.1.7 DB into MS-Access. I'm trying there to ascertain where the problem lies, i.e. is it the driver, MS-Access, combination of both of these, or it's Microsoft what do you expect!!! Any (non-flame) feedback to useful web sites, white papers etc would 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).
RE: DBA work load
Must say I liked Inka's notion of calling all interested parties with details, though it could be income threatening =:-0 Maybe a compromise would be to agree some type of SOP for such situations and have the "interested callers" list put in there. I mean if they are so keen to know first thing next morning... OTOH, why not send a summary e-mail to interested parties and tell them you'll fill in any "gaps" when you have caught up on lost time. If the problem has been resolved, details of how are of a mainly historical nature anyhow - right? Tim: Can you give me the ISBN's to some of your novels. What!!! You haven't written any yet! - A waste of talent ;) Thanks for the homour in any case. PS: The BDBAFH has gone right over my head. My psyche is suggesting it's profane. What does it stand for? - 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).
RMAN implementation strategy
Hi Folks, We're planning to implement RMAN as part of our B&R solution and by extenstion also as part of our DR solution. I've been trying to locate information on how best to configure RMAN across our organisation. For example it's advised you place catalog on separate server to production server. So server A might house catalog for server B and vice versa. But in a DR scenario where both servers could be destroyed there are I 'suspect' potential implementations on overall MTTR depending on configuration. Is it then perhaps better to locate all catalogs on a dedicated server which ideally would be replicated somehow to eliminate it as a singal point of failure. Also we have a requirment to be able to potentially recover data as far back as 7 years. These are currently comprised of monthly backups taken out of regular cycle and archived off site. I'm thinking it might be an idea to set up a two catalogs, one for regular monthly cycle and another to record these monthly archives as the maintenace of the catalog might be cumbersome trying to ensure the montlhy archive data records do not get accidentally deleted. I've had a trawl across the Web courtesy of Google but did not find any papers which appear to deal with these type of issues. The RMAN User's Guide and Reference does not appear to address them either. Your feedback/comments or references to papers would be much appeciated!. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - 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).
RE: Index table last update?
> From: "Stephane Faroult"<[EMAIL PROTECTED]> > Date: Wed, 11 Sep 2002 11:24:50 UT > Subject: RE: Index table last update? > >>- Original Message - >>From: "O'Neill, Sean" <[EMAIL PROTECTED]> >>Sent: Wed, 11 Sep 2002 03:13:21 >>Is there a way to determine when an index table was >>last updated?.=0D > >The answer is the same as with heap tables. > >Regards, > >Stephane Faroult >Oriole Stephane, Totally confused by your reply. Could you give me a 101 explanation pleez. Regards, - Sean 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 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).
Index table last update?
Is there a way to determine when an index table was last updated?. - 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 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).
Missed digests
Due to probs with e-mail servers I missed digests 204 - 207 inclusive from Oracle-L. Any chance someone subscribed digest mode with a back catalog ;) could send them on to me please?. It's a bit too slow to review all via web page. - 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 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).
B&R solutions
Can anyone advise what the most popular solutions are being used nowadays for database backup and recovery. I would imagine that RMAN is a cornerstone of most, if not all solutions. Anyone out there using Galaxy CommVault?. Would seasoned folk be so kind as to state what solutions (Oralce and or 3rd party) they have found to be a robust tried and tested solution. - 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 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).
ANALYZE question
Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - 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 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).
What you've always wanted to know about Oracle DBAing
I'm doing some research into questions Oracle DBAs would like to find answers/solutions to but for some reason, no time, bumped to a lower priority etc. they have not had time to find out. If you have a list of such (Oracle DBA related!) questions, restrict to your top 10 where necessary, I'd appreciate folk sending them directly to me. So whether you be a newbie or go back as far as Oracle 6 (or earlier!) dredge your memory banks and send 'em on. - 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 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).
Troubleshooting ORA-01410
So this application running on an 8.1.7 database, NT4, has a utility supplied by vendor which when run by one of our apps people is reporting an ORA-01410 (invalid ROWID). Given our "history" with the vendor in question I have some doubts about the application =:-0 In relation to same I have a few queries: [1] Would an Export of the database report problems if above issue existed in database?. A full export is currently taken each night and completing without any warnings. [2] Is dbverify any good to troubleshoot this type of error?. I currently run a dbverify on Offline backups of the data files in question and no errors are being reported. Granted this is on a "copy" of the datafiles but I ran a test before where I corrupted a datafile, took a copy, and the dbverify reported problem with copy so I assume my logic is good here?. [3] If I run ANALYZE TABLE xxx VALIDATE STRUCTURE CASCADE on offending table is output reported to screen? I have not run it yet as the DB itself is "busy" a lot of the time and above is rcommended for quite time due to prevention of Selects, Inserts, Updates and Deletes on object. [4] What other methods could be used to troubleshoot this problem?. As I mentioned I have doubts about the vendor supplied application and would like to prove one way or the other if some data corruption exists or not! Any help with above would be much 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 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).
Slow disk-to-disk - [W2K OT]
I've a script that until last Friday had been taking approximately 1 hour to take an Offline disk-to-disk backup of one of our databases. Now it's taking 2.5 hours. We've ruled our virus scanning software as a potential culprit. Basic Config is is a Compaq server W2K SP1 connected to a Compaq SAN. The target and source disks are both in the SAN. Xcopy is being used to perform disk-to-disk. OK pretty off topic but just in case anyone has any bright ideas or has experienced someting similiar I'd appreciate feedback. - 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 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: Senior DBA position - Dublin, Ireland
>> From: Rachel Carmichael <[EMAIL PROTECTED]> >> Date: Tue, 28 May 2002 07:23:46 -0700 (PDT) >> Subject: Re: Senior DBA position - Dublin, Ireland >> >>oh so tempting but I know England's restrictions on bringing in >>pets, what are Ireland's? Rachel, I'd guess fairly similar or possibly stricter, but then again it would probably depend on the "pet" ;) 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 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).
Senior DBA position - Dublin, Ireland
Before any public outcry I checked in with, and got permission, from list moderator to make this posting!!! Acknowledging we're geographically remote for most members of this list. (but maybe some other Irish based folk are here too!) My company, location North County Dublin, Ireland, has a vacancy for a full time permanent position for a Senior DBA. If anyone is interested check out Recruitment section of www.organon.ie No applications to me please, use directions from web site! - 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 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 on (Ssshhh NT)
>> From: Robertson Lee - lerobe <[EMAIL PROTECTED]> >> Date: Tue, 21 May 2002 15:42:19 +0100 >> Subject: RE: Oracle on (Ssshhh NT) >> >>Thanks Rachel, this will be (for this year anyway) on Oracle 8 (not even 8i, >>don't ask !!!) As you're stuck with Oracle 8 I'd recommend the following book which I believe is out of print but which you may be able to find via used books site: Oracle8 & Windows NT Black Book ISBN: 1-57610-248-3 Published by Coriolis. Following Oracle8 NT papers may also be of interest: http://www.nyoug.org/tune8nts.pdf http://www.nyoug.org/ora8winnt.pdf http://www.dbatoolbox.com/WP2001/nt2000/tips_techniques.pdf Following site might also be of use: http://www.ipass.net/~davesisk/oont_main_menu.htm HTH, - 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 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).
DBA Studio - Used (M) query
Can someone please tell me how the value displayed in the "Used M" column is calculated/dervied. I'm running DBA Studio (stand alone) and I'm trying to relate it back to DBA view data. Any help would be much 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 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).
Server upgrade NT4 -> W2K Oracle implications
We have an 8.1.7 SE database on a server which is currently NT4 SP6. The System Admin group wish to upgrade the server to W2K and propose doing so by recreating the C: partitition. Our Oracle software resides on E: (same physical disk) and database files on other disks/partitions. Are there any implications for the Oracle software and database for this upgrade. Are there any steps I need to take pre or post OS upgrade?. In particular I'm wondering about implications for the registry. Any advice/help would 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 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).
Online redo sizing and parameters
I'm looking to resize our online redo logs for a particular app and am somewhat confused about the appropriate settings. The current config is 4 groups (2 members each) of 5Mb size. We cycle through a daily average of 750 logs in a 22 hour period. During a more intensize daily batch window of 5 hours there is an average of 100 per hour switches i.e. two thirds of switches are occuring during the batch window. I'm planning to resize the online redo logs to 120Mb based upon rationale of 500Mb per hour in batch window and 4 groups. So switching will happen apporox every 15 minutes. Some Oracle documentation suggests 1 switch per hour is best and others one switch every 30 minutes. So question 1: Does this proposed resize make sense? Our current log_checkpoint_interval = 10,000 which means a checkpoint at approx 39Mb given it's a Win 2k OS with it's OS block size of 4096. So question 2: Does it make sense to leave this setting as is and have approx 3 checkpoints per each redo (timewise every 5 minutes) or is there a better value and why? (Support suggested setting to zero, i.e. effectively ignore!). The log_checkpoint_timeout is currently 1800. Support suggested setting this to zero but the reference manual suggests that this should not be done!. So final question: What would the best value be given the log_checkpoint_interval would probably have a checkpoint every 5 minutes using heavy processing?. Your considered opinions/input re above would be much 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 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).
Licences for testing
We're planning to set-up some "test" servers here and I'm wondering what the "practice" is out there regarding licences for same. This is only for short term testing and to "try out" various DR scenarios etc. I'd guess there's an "Oracle" view which would be if you install on server you pay a licence, (correct?). Is there some workaround for this?. All creative ideas welcome :) - 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 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).
Thanks for ERD replies
Thanx to all who replied on my ERD query. Much appreciated :) Seán O' Neill Database Administrator Business Systems & IT Department Ext. 459 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 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).
ERD generation tool
Can anyone please recommend/advise on NT/W2K compliant solutions which can generate ERD's by interogating the DB. - 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 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).
ora-470
Oracle 8.1.7, W2K SP1. This AM instance terminated by PMON due to error 470 detected in background process. List archive showing no matches and MetaLink articles don't seem to match either. "Slim" entries for problem in PMON and CKPT trace files. Nothing in SMON, LGWR or DBW0. Anyone got any experience of this problem, what causes it and most importantly how to prevent re-occurence =:-0 - 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 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 versions for W2K
Anyone out there sucessfully running Oracle 7.3.3 and/or 8.0.5 on W2K?. - 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 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).
Dedicated process memory - NT
I'm trying to get a handle on the amount of memory allocated to a dedicated server process using NT. From having examined manuals to to begin with the terminology seems to be inconsistent. There appear to be interchangeable references to PGA and UGA and also to Dedicated Server Process memory and Shadow Process Memory. Are these pairs one in the same?. Anyway apart from my personal confusion re previous I'd like to find out what memory is allocated on a server confgured to use dedicated server process. From Appendix B in the 8i Rel 2 Win NT Admin manual I though it would be 335K. However I have "heard" that in reality this is actually 2Mb. Can anyone give me the fact's please and reference sources for same too pleez!. - 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 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: ORA-00600 errors
>> From: John Dunn <[EMAIL PROTECTED]> >> Date: Mon, 25 Feb 2002 16:01:54 - >> Subject: ORA-00600 errors >> >>can anyone tell me waht these errors might mean? >> >>Errors in file /u01/app/oracle/admin/vaddev/udump/vaddev_ora_6942.trc: >>ORA-00600: internal error code, arguments: [17172], [0], [], [], [], [], [], >>[] >>Thu Feb 21 03:10:56 2002 >>Errors in file /u01/app/oracle/admin/vaddev/bdump/vaddev_snp2_10163.trc: >>ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], >>[] John, There is info for the 17090 error on MetaLink. Navigate as follows: Top Tech Docs> Data Server> Database Administration> ORacle Internal Errors. Which will point you to Note 153788.1 "ORA-600 Argument Lookup" HTH, - 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 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).
Options instead of ODBC + MS-Access [Slightly? Off-topic]
A developer here has put together a reporting package which uses ODBC to interface to an 8.1.7 DB on W2K server and utilises MS-Access on client to extract data and generate nice GUI final presentation of data. The data extracted has various computations performed. The developer has asked what other Oracle or 3rd party options might be used to realise the same end results perhaps in a more efficient manner. Their concern is that as data volumes grow the performance will degredate substantially. Anyone any ideas?. - 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 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).
Anyone using COMMVAULT
If anyone on the list is using the Commvault product for B&R + DR of their databases I'd appreciate hearing feedback on same. Backchnnel is OK unless you want to share with list. We're "considering" it here in a NT/W2K environment. - 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 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).
Cluster query
So our Sys Admins bods are talking about clustering using Compaq kit for W2K based server with an 8.1.7 DB. I take it we're talking implementing OPS from the DBA POV?. Are there other possibilites?. Anyone any experience with above mentioned H/W and S/W care to share hard won experience, gotcha's etc... and no quips about Unix instead of NT pleez cos that ain't gonna change =:-0 Can anyone recommend any useful sources of info via web sites, White papers etc. Hope I'm not being too vague and asking too big a question! - 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 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: Recovery case studies
>> From: "shashi_cs" <[EMAIL PROTECTED]> >> Date: Mon, 11 Feb 2002 22:17:38 +0530 >> Subject: Recovery case studies >> >>Hi folks >> >>Does anyone have a good document providing step-by-step various database recovery scenerios ? >> In addition to Velpuri B&R book, "Oracle DBA Checklists" Pocket Reference from O'Reilly could be useful and also I'd recommend what I consider a really useful paper by Howard J. Rogers on B&R which you can download from the B&R article section of www.vampired.net HTH, - 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 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: Installing 8i on Windows 2000 Server / Pentium 4
>> From: "David McVeigh" <[EMAIL PROTECTED]> >> Date: Wed, 13 Feb 2002 17:24:26 +1000 >> Subject: Installing 8i on Windows 2000 Server / Pentium 4 >> >>I know there have been issues installing 9i on P4 boxes, but does anyone kn= >>ow why I would not be able to start the 8.1.7 Oracle Installer on W2K after= >> getting the initial splash screen? The splash screen disappears and after = >>a few seconds, the CD drive winds down. >> >>The 8.1.5 CD I have works OK. The installer starts normally. >> >>I know the hardware and the CD media I'm using are good, as they work OK wi= >>th other media / devices. >> >>I'm wondering if I need to upgrade or change the Java Environment on this b= >>ox? >> >>cheers >>David McVeigh Readme for bug number 1507768 A copy of OUI 1.7.1.10.0 is being provided to be used in a work around for installing on Pentium 4 processors. 1. unzip the patch 2. unjar the contents 3. Go to the directory .\cd\Disk1\stage\Components\oracle.swd.jre\1.1.7.30/1\DataFiles\Expan ded\jre\win32\bin\symcjit.dll rename symcjit.dll to symcjit.dll.ori 4. Invoke OUI and install OUI to disk cd ./cd/Disk1/stage/win32/setup.exe 5. Use the installed OUI to install the RDBMS Invoke OUI from the start menu, and install RDBMS software. HTH, - 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 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).
Recovery scenario query
We perform disk-to-disk offline backups on a nighlty basis. Database is running in archived log mode. Due to space contraints (don't ask =:-[ ) we are currently forced to backup only some of the data files. The data files excluded belong to specific schema owners and are not being updated, or so I'm informed =:-0. I'm trying to get my head around what the recovery implications are if some of the data files not backed up have being updated and a recovery is required?. I expect it depends on what the recovery scenario is. So whats worst case scenario and what would my options, if any be?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - 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 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).
Archive log dest full
So yesterday the archive log dest disk filled up on one of our prduction systems causing the Oracle DB to halt as it's supposed to. Disk space was tight and there was a bit of data loading done. Anyhow I freed up disk space on relevant drive and proceeded to server console to press the OK button to allow archiving to restart. However, the console was locked by a PC Anywhere session which prevented me from getting to the console window with archive dest full message. Anyhow ended up having to bounce the database. Apart from throttling the user who set the PC anywhere lock on the console and insisting it not be done again I'm wondering did I have any other options apart from a database bounce to overcome this problem?. Oracle 7.3.3, 8.0.5, 8.1.7 NT4, W2K - 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 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: Deleting files on w2k
>> From: "Koivu, Lisa" <[EMAIL PROTECTED]> >> Date: Fri, 30 Nov 2001 14:48:55 -0600 >> Subject: Deleting files on w2k >> >> >>I'm trying to test out backup and recovery on w2k. However, I can't remove >>or rename a file while the database is running! It says "file in use". >> >>Am I missing something or is there a way to force this? Lisa, As has been mentioned NT/W2K is only brill at putting locks on files which can prove to be a real pain in the ... Anyhow apart from advice offered to date I'd add there are some useful free utilities to be found at www.sysinternals.com which can be used to identify whats got locks on what files. If for nothing more than curiosity. Also take a look at the Resource Kit utilities. I have experienced W2K asserting a file is in use by another process and not being able to figure out what that process was or how to kill it's "lock". HTH, - Sean 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 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: Deleting Oracle8 on NT(cleaning Oracle8)
>> From: "Raghu Kota" <[EMAIL PROTECTED]> >> Date: Mon, 03 Dec 2001 15:57:04 + >> Subject: Deleting Oracle8 on NT(cleaning Oracle8) >> >>Hi Friends, >> >>I need to clean Oracle8 database size 3Gb on one of my NT server, Is it >>possible that shutdown the database and delete all datafiles and all >>directories??? Or Is there any other way to clean all files and >>directories?? I appreciate all suggestions and responses. See MetaLink Doc IDs: 75061.1 or 74790.1 HTH, - Sean 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 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).
Audit vs Logminer
8i Database, W2K server. Apps team looking for audit trail functionality. I've outlined the pros and cons of Oracle Audit vs using Logminer to extract audit info from archived redo logs as below: - Archiving of Redo Logs will be carried out in any case. - All required auditing data as far as I can determine would be captured in redo logs. - Using Logminer to investigate them looks like it would be more difficult than using Oracles Auditing features. - Introducing Oracle Auditing has limited functionality and has a performance overhead. - Oracle auditing would require programming of triggers to capture before and after values which in turn has another potential performance hit. - Oracle audit data needs to be monitored and requires additional management time. I've not used Oracle Auditing or Logminer so the above is based upon some reading I've done. If I've missed any important points please give me feedback on same. Also anyone any opinions, or better still experience, as to which is better from performance POV. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- 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 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: DBA CHECKLIST
Grace, Free sources: = www.orapub.com Technical Papers section #115 Oracle DBA Checklist Thomas B. Cox wrote a paper called "Database Administration Mautrity Model". This is IMHO rleated to DBA checklists. I have version 1.1 but only as hardcopy. It does not appear to be accessible now from his homepage at Geocites. Maybe someone else on the list can help you with this. Cost sources: = "Oracle DBA Checklists", published by O'Reilly ISBN: 0-596-00122-3 "Oracle DBA 101" ISBN: 0-072-121203 has a chapter "What we do daily" - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] >> From: "grace" <[EMAIL PROTECTED]> >> Date: Thu, 15 Nov 2001 12:34:08 +0800 >> Subject: DBA CHECKLIST >> >>hi, >> >>is there a dba checklist to know a dba does? >> >>Best regards, >> >>Grace Lim >>Suy Sing Comm'l Corp. -- 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 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).
IP Address Change
Our network folk have informed me that they are going to have to change the scope of IP addresses at our site and hance the IP addresses of our servers will change. We don't use Oracle names or MTS. We're all NT/W2K servers and use DNS. Are there any gothca's I need to be aware of. Our TNSnames and Listener files use the host name and not specific IP addresses. I've had a browse around MetaLink and have not ID'ed any problems thus far but more experienced feedback would be appreciated. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- 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 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: [Q] what difference between count(0), count(1) and count(*)
>--- aaa aaa <[EMAIL PROTECTED]> wrote: >> Can anyone tell me what is difference between : >> >> select count(*) ... from .. >> >> select count(0) ... >> >> select coun (1) ... >> select count(2) ... For other insights take a look at http://www.oracledba.co.uk/tips/count_speed.htm There is also some fun to be had with using select count(*) from within a PL/SQL programming unit then when selecting from SQL*Plus. See MetaLink Doc ID: 1013985.102 I have an e-mail from an Oracle exponent which contains stats showing that the various count() theories are in fact just legend and that your session performs the same amount of work no matter which method you choose. Where this leaves us all is... BTW: If you're into Oracle trivia see can you find out how and where the DUAL table got it's name. PS: What's your name. Anonymity is not a pre-requisite around here AFAIK. - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- 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 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).
Free space puzzle
TS is showing 100% used in DBA Studio. DBA_DATA_FILES is showing MAXBLOCKS, MAXBYTES values corresponding to filesize of 2000M which was what tablespace was originally created with. Subsequently altered to 4000M with ALTER DATABASE DATAFILE '' AUTOEXTEND ON MAXSIZE 4000M. I'm puzzled as to why the DBA views do not reflect the 4000M. Can anyone explain what I'm overlooking please? - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] Oracle 8.1.7 - W2K -- 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 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).
Norad Feedback
Any folk on this list using Norad products from Bradmark for DB monitoring etc. I'd like to hear from you if you are as to what you like/dislike etc. about them. There are some members of this list who market this product so if you want to be discrete please contact me directly. Thanks in advance, - Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] (I tried posting this on Oct 15th but I don't believe it made it to the list. Apologies if it did.) -- 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 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: Disk layout
>> From: "Steven Hovington" <[EMAIL PROTECTED]> >> Date: Wed, 3 Oct 2001 14:33:52 +0100 >> Subject: Disk layout >> >>Could anyone please point me towards documentation which discusses optimum >>disk layouts for Oracle databases. Some other useful sources: http://www.ipass.net/~davesisk/oont_config_bpft.htm http://www.geocities.com/Colosseum/1190/oracle/ORACLE_NT_CONFIG.pdf This one contains other references! Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Controlling disk space usage
Wondering what folk out there do to manage disk space usage by tablespaces. Is it common/bad practice to have MAXSIZE unlimited and/or MAX_EXENTS set to a value which if reached would be larger than disk capacity and therefore regular observation of space is required, or is there a better way to do this? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
DBA assessment - slightly OT
If you were to choose 10 questions to evaluate the competency of a DBA what would they be given that the result would be their competence would be rated as of the following: - TERRIBLE (I would not let them within 100 miles of a database) - FAIR (I'd show them some basic admin, but do it myself, they've a lot to learn yet) - GOOD (I'd let them do some basic admin stuff by themselves but monitor their performance regularly) - VERY GOOD (I'd let them handle practically all admin type work and mentor them as required) - EXCELLENT (Hell, they could teach me a trick or too!) Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Preventing user access
If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the "enable restricted session" functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out. Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: Physical access to servers for maintenance
Some comments and queries interspersed below. >> From: Steven Lembark <[EMAIL PROTECTED]> >> Date: Tue, 25 Sep 2001 09:18:05 -0500 >> Subject: Re: Physical access to servers for maintenance >>Simplest method would be to say "no we don't need it now, what is the >>pager number of someone we can use if we do need things done?" Make >>a point of paging them every time you need something from the shell, >>day or night. That person will, I'm sure, be happy to compile a list >>of the trivial things they've been forced to do that the DBA should have >>done for themselves at 3am... Like your thinking on this Steven :) >> From: "Thater, William" <[EMAIL PROTECTED]> >> Date: Tue, 25 Sep 2001 10:20:42 -0400 >> Subject: Re: Physical access to servers for maintenance >>if the server >>crashes and you have to restart the DB without VNC or PC Anywhere running, >>how do you do that? William, I would expect the Sys Admins to restart the server. The DB(s) should subsequently come up. Am I missing something in what you wish to convey? My conclusion based upon what I've read on this thread was that installs were raised as the primary flag for local physical access but that even this can be worked around if necessary. So what tools are people using for "remote" administration?. Perhaps to be more specific if you're on LAN but have no phyisical access to server and then same for WAN and then over PSTN. Do you use different tools for remote admin in these different scenarios, i.e. distance and bandwidth limitations force use of different tools?. Anyone any feedback on experiences of PocketDBA product?. Anyone any "bad press" or gotchas about VNC? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: Alert log from Remote client
Nirmal, Perhaps the replies re AlertView have answered your question. AFAICR it requires FTP service to be running. You did not specify your Operating System. Do you simply want to view the Alert logs and Trace files for the various databases or be alerted if an error appears in Alert Log or a new trace file is created?. Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King >> From: Nirmal Kumar Muthu Kumaran <[EMAIL PROTECTED]> >> Date: Tue, 25 Sep 2001 12:19:57 +0300 >> Subject: Alert log from Remote client >> >>Hi guru's >> >>Suppose that, i'm managing serveral database from a single client. >> >>In that case, how can i find out the alert log/trace files from the client. >> >>Any ideas pls. -- 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 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).
Maxbytes - 7.3.3
Can anyone tell me please what view(s) on Oracle 7.3.3 I can use to identify the equivalent MAXBYTES (datafile size set to umlimited) as per DBA_DATA_FILES on 8i? Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
2nd DBA or ? - THANX!
Thanx to all you folk who replied on this matter. The humour, satire, paranoia etc. in replies was worth the posting. The 2nd DBA vote won by a large majority. Now to convince damagament Sean :) Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
2nd DBA or ?
I've been presented with an opportunity to justify requirements for a 2nd DBA at our site. As I see it there are an number of paths this presents: 1 - Justify and get a 2nd DBA. Pro's: Gives me more time to get involved in other projects as a senior DBA. Holidays and attendance at courses and seminars etc. easier to take 2 - Outsource this role and activate it when required and justify putting money into investing in software and/or hardware to allow a single DBA function to required levels. Pros: New tools etc. to learn and broader experience gained. More bargaining power if required. I'd like to hear your feedback on which path you'd be inclined to take and why?. Also if going it alone what you'd look for software in hardware and other areas. Currently 6 NT servers, 10 databases and expanding... Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: Looking for 24 X 7 Design Considerations
>> From: "Tracy Rahmlow" <[EMAIL PROTECTED]> >> Date: Mon, 17 Sep 2001 08:37:30 -0500 >> Subject: Looking for 24 X 7 Design Considerations >> >>We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that do >>not have a 24x7 restriction. Now, management is looking to bring in new >>products that will need to be 24X7. They are looking for costs to determine >>the viability of such a decision. I have no 24x7 experience and am looking for >>ideas or options to consider. [At least initially they are stating there can >>be no downtime for maintenance (upgrades/reorgs)] Tracy some other possible sources of info are: Oracle 24x7 Tips and Techniques 0-07-211999-3 High availability Tips, Trick and Techniques for E-Commerce and other mission... from http://www.speakeasy.org/~jwilton/oracle.html Some other papers at: http://www.evdbt.com/library.htm HTH, Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: The DBA in the IS organization
I wrote: So what perks if any do you get for being called in on a Saturday?. The longer I hang around in this DBA field the more it seems to be like a "vocation" ;) Rachel Replied: >> From: "Rachel Carmichael" <[EMAIL PROTECTED]> >> Date: Mon, 17 Sep 2001 13:07:08 + >> Subject: Re: The DBA in the IS organization >> >>Perks for being a DBA? You jest. >> >>If you do your job right, and nothing goes wrong, they don't understand why >>they need you and why they pay you what they do. >> >>If something goes wrong, they get upset because why didn't you know it was >>going to happen and fix it to begin with? >> >>Okay, for real: I get thanks from people when I make their stuff work fast >>(the best comment from a programmer was "Rachel, now it flies like the >>wind!"), thanks from end users when I dig the data out for them or >>straighten out the mess that the programmers made. >> >>And I like what I do. Hhhhm. Rachel seems to me you've found your vocation in life ;) I like to separate perks from vocation, unless of course they happen to be one in the same!!! Now back to my Oracle afternoon prayer book.. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
7 step guide to constructing a Disaster Recovery Plan
The site below contains a 7 step guide to constructing a Disaster Recovery Plan. Enjoy =:-0 http://www.w2knews.com/rd/rd.cfm?id=091301-SevenDRPsteps Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
The DBA in the IS organization
>> From: "Farnsworth, Dave" <[EMAIL PROTECTED]> >> Date: Sat, 15 Sep 2001 05:49:20 -0500 >> Subject: The DBA in the IS organization >> >>I am wondering how my fellow DBA's fit into their IS organization. My >>situation is this. I was hired just a little over a year ago as a DBA but >>my official title is network programmer. Except for some job scripting I >>have not done any coding. I am the only DBA for 5 Oracle databases and 4 >>SQL Server installations. Currently my boss is the head of development. I >>work with the developers and with the network admins equally. I sometimes >>feel a bit of a conflict with me being under the developers. I have been >>thinking about approaching the VP of IS about having me be under him rather >>than being under development. I feel I need to have equal footing with the >>development managers and with the network admins. Right now I am kind in >>limbo with no real authority. >>So anyway, I am just wondering where you fit in your organization and what >>is the appropriate place for the DBA. >>And yes I got called into work. Sucks to be me today. :o) FWIW, I as the only DBA report directly to the IS Manager. We don't do much in-house development preferrring to purchase OTS solutions. We have 2 folk managing the Network and Server Admin one of whom reports directly to the IS Manager. We have some information analysts who also report directly to the IS Manager. We're an NT house. I have local admin rights on servers which host Oracle databases 6 in all with 10 databases. I share an office with the NT admin folk. I would have thought that you being separate from developers from a reporting point of view would be an advantage. Being amoung them is an advantage in that you might get to raise matters of concern before they go too far down the line. I would think you'd need autonomy to defend amoungst other topics issues relating to database performance potentially with developers and/or adminstrators. So what perks if any do you get for being called in on a Saturday?. The longer I hang around in this DBA field the more it seems to be like a "vocation" ;) Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: Backup & Recovery Scenarios
> From: Sujatha Madan <[EMAIL PROTECTED]> > Date: Wed, 5 Sep 2001 16:38:42 +1000 > Subject: Backup & Recovery Scenarios > >Hi, > >I want to test and learn more about backups and recovery's. > >Does anyone have a list of backup/recovery scenarios that I can test??? In addition to what has already been posted the following "Backup & Recovery" paper by Howard J. Rogers should also be of interest. A copy of same can be found at: http://www.vampired.net/articles/php/backup.php HTH, Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Veritas feature disable - Slightly OT
I know this is probably a case of RTFM BUT, BUT, BUT, if it is relatively simple to answer please do. The tape backup software here is Veritas Backup Exec which is managed by someone else (job demarcation!). I don't use it or have experience of it. We've had the odd occurrence of SIDs crashing because the software was accessing say a Control file when Oracle wanted to use it. I've provided a list of locations of files that don't need to go to tape as we do disk-to-disk backups but some times the tape backup configurations get messed up and files creep back into sequence. I've heard there is a way to configure Veritas software so that it won't put a lock on a file which would cause Oracle SID to crash. So at long last my question is how do you configure it to do so? Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Correct DBVERIFY logic?
I'm not sure if I have my logic correct here so I'm asking list advice. I run DBVERIFY utility on files which have been backed up to (1) Check they backed up successfully and (2) To check if the orignal file was free from corruption at time of backup. Does (2) above make sense?. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Disaster recovery
>>I have to document our Oracle databases for the case where I'm e.g. hit by the proverbial bus. So if you DBA folk were to >>come on site to pick up the tab and start managing our databases what information would you like to be able to refer to, to >>allow you get up to speed as quickly as possible with our set-up. Rachel and Bruce, thanx for your input on this. Some points ya'll made I had not considered. I'm sure there are more. Come on folks let's hear your input on this. I'll publish a list to the list when it looks as though all avenues have been explored!. Changed the title (originally "Picking up the tab") to possibly attract more attention, hope the ethics council don't mind =:-0 Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Picking up the tab
I have to document our Oracle databases for the case where I'm e.g. hit by the proverbial bus. So if you DBA folk were to come on site to pick up the tab and start managing our databases what information would you like to be able to refer to, to allow you get up to speed as quickly as possible with our set-up. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Pathname for Spool - [NT]
Can anyone tell me if it is possible to specify a pathname using NT to a file with SQL*Plus spool command if the pathname contains a space. For example if I want to spool output of a SQL*Plus session to t:\oracle\output\system check\free_space.log can this be done. I've tried enclosing the pathname in " " and ' ' but that don't do it, it gives same error message as for no "" or '': SP2-0333: Illegal spool file name: "t:\oracle\scripts\system checks\free_space.log" (bad character: ' ') I'm hoping that I won't be stuck with having directory names with no spaces, arrrggghh. (and puhhleezze no comments about on Unix yada, yada, yada) Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Precise
Is no-one on this list using Precise SQL or Precise Pulse?. Has anyone "heard" of them or evaluated them?. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Precise Pulse, SQL
Would appreciate feedback, good or bad, from those on the list using Precise/Pulse and Precise/SQL. From those who "looked" at it but did not go for it, why not? Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: cleaning up oracle homes on NT
>> From: "Boivin, Patrice J" <[EMAIL PROTECTED]> >> Date: Wed, 01 Aug 2001 07:38:51 -0300 >> Subject: cleaning up oracle homes on NT >> >>Andrea asked about removing NT services. >> >>What about Oracle homes? The Oracle Universal Installer appears to be >>doing a poor job of cleaning those up when we de-install Oracle software. FWIW see MetaLink Doc ID: 75061.1 Subject: WINNT: Cleaning All Oracle Products From a Machine. Also the Instalation Guide for 8i Rel3 {A85302-01) Chp 8 Deinstalling Oracle Components and Services. I have not tried removing a single home myself but if I were to try I'd be using these as starting points. Bottom line I don't know if a single Oracle home can be removed but I suspect it could given the way the registry is set-up to handle multiple homes. HTH, Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: Help, processes won't die
>> From: [EMAIL PROTECTED] >> Date: Wed, 1 Aug 2001 12:01:40 -0400 >> Subject: Help, processes won't die >> >>I need some assistance ASAP. Our nightly batch process seems to have hung >>up for some strange reason (ok no biggie my boss says kill it and start it >>again). The problem is I have killed the processes both in oracle (sid, >>serial#) and also in unix. Now I can't see the processes in unix but in >>oracle they have a status of killed but are still holding the resources. My >>thinking is telling me the pmon is not waking up or not doing it's job. How >>can one manually tell a process to wake up. Any help will be greatly >>appreciated. >> >>OS Solaris 7 >>Oracle 8.0.6.3 FWIW, this was posted to this list in Jan, and I can't tell you if this works or not as I've never had recourse to use it so if you care to roll the dice ;) to wake up PMON: SVRMGR>select pid from v$process p, v$bgprocess b where b.paddr = p.addr and name='PMON'; PID --- 2 1 row selected SVRMGR>oradebug wakeup 2 Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
grants to schema query
Hope there is not an obvious answer to this. I want to grant UPDATE priv to all objects in a schema to a user. Do I need to grant to each object or can I somehow wildcard all the objects?. What are my option(s)?. I'd appreciate example grant statements! Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Evaluation questions
I'm still slogging away at selection process of DB monitor tool. I'm now at stage where I'm compiling a list of specific tasks I'd like to take the contenders through and score them on same. E.G. Can package alert if Oracle DB goes down? Can package alert if Control File extends? I'd appreciate your feedback on what you think the monitor package should be able to do, ya know those things you want to know about before anyone else does!. I'm particularly fishing for events that might be a bit more obscure yet still useful to monitor. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: using ora & dbf as datafile extensions
Saurabh, My views are that I tend to use datafile extentions to reflect the type of tablesapces I use in the file or the file type: For example: .DBF for datafile .RBS for Rollback .ARC for Archived redo logs (can confuse Winzip utility on Windoze) .RDO for Online Redo .CTL for control file In terms of conversion or upgrades they should not matter AFAIK as physical and logical storage are separate in Oracle. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King > From: "Saurabh Sharma" <[EMAIL PROTECTED]> > Date: Tue, 31 Jul 2001 12:44:03 +0530 > Subject: using ora & dbf as datafile extensions.. > >hi all, > >is there any problems using different filetypes for various datafiles in = >the same database. >i mean using some files as .dbf extension while some as .ora > >i'm using system, rbs, temp, oemrep as .dbf, while the one i creted = >later are using .ora extension. >does it cause any problem in conversion or upgradation. > >any views. Saurabh Sharma -- 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 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 pricing
Someone mentioned a site licence in their post. I did not know Oracle do site licences, a sales rep told me they didn't. Is this still the case?. My experience of local area sales folk is that they don't seem to be too concerned about business. They are so slllooo at responding to RFIs etc. Is there an independent source for checking out licence options?. If there are any Oracle certified partners out there in Ireland lurking about contact me back channel to make yourself known to me, though I'm not promising any business. I don't know who you are yet 'cos I'm still waiting for a list of you from Oracle!!! As for the audit gig, what annoys me is that when we buy a licence we get demands to pay invoice for same pronto but we don't get any confirmation of the licence any other way. It seems to be on a database somewhere or other but I don't know if I should have a piece of paper for same with a specific licence number, start date and expiriation date of licence, licence type, support terms etc. I can hear echos of team music to SHAFT... =:-0 Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: Some other Oracle list
Hi ???, As has been pointed out this list is probably as good as it gets. However, if you have the time to keep up with more than one list then the following are other options for you to explore and also learn from. You can sign up to lists from following web sites: www.voug.org www.lazydba.com Also you can subscribe to ORACLE-L at [EMAIL PROTECTED] and ORACLE-DB-L at [EMAIL PROTECTED] There are also loads of discussion groups available via Web sites, but you need to visit them to review postings. And there are other sites that send you newsletters relating to Oracle. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King >>-- >> >> From: =?iso-8859-1?q?Pablo=20ksksksk?= <[EMAIL PROTECTED]> >> Date: Wed, 25 Jul 2001 22:11:33 +0200 (CEST) >> Subject: Some other Oracle list >> >>I'd like to subscribe to another list too. >> >>Does anyone know if there's some other list as good as >>this one? -- 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 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).
Data Load Options - summary - final feedback
Thanx to all who responded on my query about Data Load options. I've tried to summarise below. To try and put a lid on it I'd appreciate feedback on gaps, any corrections and obs on data volume metrics. Low volume = <10Mb Medium volume = >10Mb <100Mb High Volume = >100Mb Option Volume DataData Source Ease of use (includes learning curve) --- -- -- - SQL Script Low Simple External Simple SQL Loader Medium, HighSimple External ??? Import Medium Complex Oracle Moderate UTL_FILE??? Complex ??? ??? DB Link ??? ??? Oracle ??? ODBC from MS Access Medium ??? External ??? Pro*C ??? ??? ??? Difficult Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
Securing passwords in scripts
I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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).
8i vs 8 B&R Book
I have a copy of the "Oracle8 Backup and Recovery" book but now there is an 8i edition of the book. Anyone been able to compare the 2 books and if so can you opinion as to whether it is worth purchasing the 8i version. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- 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 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: Starting Oracle services remotely (Win2K)
Mark, RCMD from the Resource Kit for NT4, and presumably for W2K, might provide a solution. I have not used it myself so can't comment on it's operation etc. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King > From: "Mark Leith" <[EMAIL PROTECTED]> > Date: Tue, 24 Jul 2001 10:57:04 +0100 > Subject: Starting Oracle services remotely (Win2K). > >Hi all, > >Has anybody come across a way of starting the Oracle services (or indeed any >service) on a Win2K box remotely from another Win2K machine? > >I would be interested in your insight if you have.. -- 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 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).