Database Scanner - Any good?
Hi, My company has bought a product called Database Scanner from Internet Security Systems (ISS). I have a meeting on Wednesday to see how it can be used for our databases including Oracle. Does anyone have any experiences or knowledge to share on this product? Thanks in advance.. Regards, Mike. Oracle DBA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike 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: 32-bit RMAN Catalog and networker interoperating with 64-bit
Title: RE: Purely for your amusement Paula, We Use: Catalog on Solaris 2.7 64bit with8.1.7.4 using 32bit oracle. Targets are Solaris 2.7 64bit, solaris 8 64bit all with 32bit Oracle 8i. AlsoNT and W2K. Only one target (solaris 864bit) is a legato client. The legato admin machine is W2K. No problems for us. Rman is very particular , so do restore tests on anything you set up. - Mike. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: 28 February 2003 22:45To: Multiple recipients of list ORACLE-LSubject: RE: 32-bit RMAN Catalog and networker interoperating with 64-bit Anyone done this before? Seems like it should work.
RMAN Upgrading to 8.1.74. Voices in my head.
RMAN (non)compatability, Recently I ran into a problem myself: o Target DBs (NT W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2 (backups controlled from here using cron). o Test recovery scenarios completed OK (Voice in head says, 'NEW TO RMAN, GOTTA TEST!). o A couple of months ago some NT DBs were upgraded to 8.1.7.4 but RMAN did not complain! o Last week a restore of an 8.1.7.4 datafile was required but RMAN kept giving an error including the text: ...PLS-00302: Component 'LOCKFORCKPT' must be declared... (voices in head says, Got that CV up to date?) Solution: Luckily - we still had nightly cold backups that we hadn't got around to stopping yet! So I was able to do a full cold restore (Also luckily only a test DB) Voice in my head says to me, 'MIKE THIS IS YOUR WARNING - UPGRADE RMAN CATALOG BEFORE A LIVE DATABASE GOES SCREWY!' I upgraded RMAN catalog DB to 8.1.7.4 and issued the upgrade catalog command. SOMETIMES INCOMPATIBILITY WILL LET YOU BACK UP BUT NOT RESTORE! (Voice in head asks, 'RMAN - What is it good for, huh?'. There's an RMAN compatibility matrix on metalink (a bit confusing) and a note that is quite clear regarding 8.1.7.4. I've lost the doc ids but a search will find them. - Mike. -Original Message- Sent: 18 February 2003 04:14 To: Multiple recipients of list ORACLE-L We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Upgrading to 8.1.74. Voices in my head.
Dennis, Ah, you know that never occurred to me. I'll check it out. Thanks. - Mike. -Original Message- Sent: 18 February 2003 14:04 To: Multiple recipients of list ORACLE-L Mike - Did you consider doing a recovery using just the control file? It might sound odd, but even if you are doing a catalog backup, the backup information is still stored in the target database's control file. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 18, 2003 3:54 AM To: Multiple recipients of list ORACLE-L RMAN (non)compatability, Recently I ran into a problem myself: o Target DBs (NT W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2 (backups controlled from here using cron). o Test recovery scenarios completed OK (Voice in head says, 'NEW TO RMAN, GOTTA TEST!). o A couple of months ago some NT DBs were upgraded to 8.1.7.4 but RMAN did not complain! o Last week a restore of an 8.1.7.4 datafile was required but RMAN kept giving an error including the text: ...PLS-00302: Component 'LOCKFORCKPT' must be declared... (voices in head says, Got that CV up to date?) Solution: Luckily - we still had nightly cold backups that we hadn't got around to stopping yet! So I was able to do a full cold restore (Also luckily only a test DB) Voice in my head says to me, 'MIKE THIS IS YOUR WARNING - UPGRADE RMAN CATALOG BEFORE A LIVE DATABASE GOES SCREWY!' I upgraded RMAN catalog DB to 8.1.7.4 and issued the upgrade catalog command. SOMETIMES INCOMPATIBILITY WILL LET YOU BACK UP BUT NOT RESTORE! (Voice in head asks, 'RMAN - What is it good for, huh?'. There's an RMAN compatibility matrix on metalink (a bit confusing) and a note that is quite clear regarding 8.1.7.4. I've lost the doc ids but a search will find them. - Mike. -Original Message- Sent: 18 February 2003 04:14 To: Multiple recipients of list ORACLE-L We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike 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: iAS 903 902 install
Barbera, I, too have not touch iAS in the real world. I was on the 9iAS R2 Oracle course 2 weeks ago though (thew!!). I remember the instructor saying that the proper releases are 901 and 902. 904 will be out in spring 2003. The version 903 is not a full release and contains just parts of 9iAS that may be needed to install over 902. Sorry but I can't remember what reasons there may be for needing 903 so check thoroughly. -Original Message- Sent: 17 January 2003 15:40 To: Multiple recipients of list ORACLE-L List: I'm touching iAS for the first time ever. I don't understand even basic stuff about it. The install I have includes 9.0.2 and 9.0.3. The install says 9.0.3 is the first J2EE 1.3 compatible release of Oracle9iAS. ..blah blah.. Oracle9iAS 9.0.3 contains only the J2EE and Web Cache Installation Type of Oracle9iAS and is compatible with Oracle9iAS 9.0.2 infrastructures for clustering, management, and security. Do I need to install 9.0.2 and then install 9.0.3 on top of it to get everyting I need? We're currently in an evaluation phase. Developers want iAS to deploy forms, portal, and build apps with java. I have 9.0.3 installed, but don't really understand what I have, and we're not able to launch a form. Thanks for any help! (This is the most frustrating, confusing product I've ever seen) Barb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Which side of the road?
For some Friday afternoon reading on what country drives on which side of the road and reason for it follow this link: http://www.travel-library.com/general/driving/drive_which_side.html I had half an idea but the site is a good read, in a sad trivia kind of way! Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jenner Mike 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-L at UKOUG
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Solaris vs Windows 2000
. The information at www.kirch.net is dated and applies to NT, not Win2k. osdata.com is a nice site, but doesn't really offer comparisons, just information on each OS. There is quite a bit of material available at www.microsoft.com. Try: http://www.microsoft.com/windows2000/server/evaluation/compare/ PC Mag has a nice article comparing different platforms for use as a webserver: http://www.pcmag.com/article2/0,4149,6615,00.asp They actually chose IBM running Windows 2000. Windows 2000 is in use here as a server platform for one database that is used as the backend to a rather troublesome application. The Win2k server is running Oracle 8.1.6.2. The database has been bounced 2 or 3 times in the last year. Once was to clear up a strange but non-fatal problem with Oracle. That was back in July, the previous system restart had been in December 2001. Server and database were up without interruption for 7 months. Though I prefer Solaris, I'm having a difficult time coming up with many valid reasons for recommending it over Win2k. A few that I do have: Sun service is superior to Dell service. They've proven this to us. ( We have other Sun machines in house ) Sun scales better. At least on 32 bits. We're at 4 CPU's. If we need to go past that I would think we should go with Sun. I don't know about Win2k Advanced Server, as it is a 64 bit platform, and I think the licensing would go up quite a bit. I welcome all objective comparisons of Solaris and Win2k Server, whether your own thoughts, or a link or links to articles you are aware of. Thanks, Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: oracle or mssql
List, I'm always keen to refresh on database comparisons so thanks for everyone's pointers. I'm surprised Oracle doesn't make more of an issue about their locking and concurrency methods (i.e. redo/rollback/undo). MSSQL seems to deal with it in two ways: Default: readers and writers prevent writers from accessing data until they are finished with it! Other method: no control, you just get dirty reads! Anyone got anything to add to this? Or am I wrong? - Mike. -Original Message- Sent: 24 October 2002 17:29 To: Multiple recipients of list ORACLE-L As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002 11:48 PM goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] Verzonden:woensdag 23 oktober 2002 20:51 Aan: Multiple recipients of list ORACLE-L Onderwerp:RE: oracle or mssql Xenix is history now...SCO itself stopped it sometime in 1990 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 23 Oct 2002 09:02:19 -0800 XENIX maybe. : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Is MSSQL server available on UNIX? -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 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). _ Get faster connections -- switch to MSN Internet Access! http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City
O/T - Disk IOs
Can anyone direct me to a method or tool for checking I/O on filesystems. the problem lies with matching up device names given by iostat to filesystem mount point names given by df. I.e. iostat -xdn extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device . 0.6 2.5 23.0 20.1 0.0 0.00.0 14.1 0 4 c3t5d4 3.0 2.1 22.1 17.4 0.0 0.10.0 11.6 0 3 c2t4d0 3.0 1.5 22.1 17.1 0.0 0.00.18.3 0 2 c1t0d0 . (or iostat -x shows devices as 'ssd34'.) I have Solaris 2.7 , veritas volume manager with non journalled filesystems. I'm afraid that I have not been able to keep up with Unix sys admin skills since I looked after SunOS 4.1.3 , HP-UX 9.7/10 and Apollo DomainOS workstations. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Backup Strategy - Informal Survey
An export with data will probably cause more headaches than it solves in large DBs. A logical export without data will also have limited use. It is quick to do and small but I suggest may be invaluable for various tasks. Mike Jenner Database Administrator -Original Message- Sent: 20 September 2002 15:53 To: Multiple recipients of list ORACLE-L Robert, I don't do exports of our large production systems mainly due to the fact that I'd have to export them to tape and getting that much quite time, so as not to bump in to an ORA-01555 or have someone else hit a rollback segment issue, is impossible. Consequently two hot backups a week are the norm around here we guard out archived redo logs very well. Now I do take exports of selected tables before they get modified or mass changed so that we have a point in time to go back to if all hell breaks loose. Dick Goulet Reply Separator Author: Freeman; Robert [EMAIL PROTECTED] Date: 9/20/2002 6:13 AM I'd like to pose a question to you all and get your response. If you are running a database that is larger than 250GB, what place in your backup strategy does a logical export have? Do you do logical exports at all, and if so with what frequency? Do you feel that logical exports are an important part of your backup/recovery strategy? Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Moving to UK - what are Oracle contracts like?
in this message are those of its author only and do not necessarily represent those of The Woolwich and or any other members of the Barclays Group and are intended solely for the use of the individual or entity to whom they are addressed. The sender may not be authorised to give financial advice, and nothing in this message should be construed as offering such advice. The message may contain privileged and confidential information and you may not copy, distribute or take any action in reliance on it. If you have received this email in error please notify the Information Security Manager at [EMAIL PROTECTED] Replies to this email may be monitored for operational or business reasons. Woolwich plc. Registered in England Number : 3295699. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bishop Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Large enqueue waits.
Rob, Jared, all, By the time I was able to investigate, the problem had disappeared. No blocking locks and nothing unusual in v$session_wait by that time. I guess I'll set up an automatic script to run perhaps every 10 mins that checks and logs this sort of thing. Unless anyone knows if this is remembered internally.. Mike Jenner Database Administrator -Original Message- Sent: 10 June 2002 16:23 To: Multiple recipients of list ORACLE-L Did you look to see if you had any blocking locks occurring at this time? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features Mastering Oracle8i Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Monday, June 10, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi to you all, High enqueue locks. This morning before I got to work there were a group of users who appeared to be hanging at times when they should have been performing updates to certain tables. I tracked it down to what I suspect is high enqueue lock times. [details are below. I don't normally see enqueue high in v$session_event or v$system_event]. I've used Steve's scripts enqueue_locks.sql and enqueue_stats.sql but they don't tell me anything that I can understand :-( By now the sessions that were affected have logged out or been terminated, so I can't put a 10046 level 8 trace on them. Can I see what the enqueue waits were referring to? Thanks in advance, Mike. Details of findings: 1 select event, s.username , time_waited/100,total_waits, total_timeouts 2 from v$session_event e, v$session s 3 where s.sid= e.sid 4 and time_waited 100 5 and event like '%enq%' 6* order by time_waited desc ; Total Event USERNAME TIME_WAITED/100 Waits Timeout -- -- --- - --- enqueueA 5498.45 17871787 enqueueB 3505.52 11401140 enqueueC 3303.44 10781071 enqueueD209.8969 69 enqueueE 63.2921 21 enqueueF 16.1714 4 6 rows selected. and using Steve's resource_waiters script: SQL @resource_waiters Event name [buffer busy waits] enqueue SID PROGRAMTIME_WAITED AVERAGE_WAIT -- --- All Disconnected Sessions 7720431 306.021346 78 f45run@scc-corp01 (TNS V1-V2)2098920989 ARC0 oracle@scc-corp01 (ARC0) 2 .25 1 select * from v$system_event 2 where time_waited 0 3* order by time_waited desc ; Total Time Waitd Average Event Waits Timeout In Hndrds Time - - --- --- --- SQL*Net message from client # 0 3271701695 30.397 rdbms ipc message 1875169 819790 422614554 225.374 slave wait 2213312 ### 167923522 75.870 pipe get 260819 249480 126637278 485.537 pmon timer 277326 27729385337384 307.715 smon timer 2783277685322173 30658.345 enqueue 25297 25128 7741422 306.021 db file sequential read48265252 0 5125270 .106 io done 820132 22440 2847667 3.472 db file scattered read 1677976 0 1585987 .945 log file parallel write 575601 2 1276956 2.218 log file sync3474011089 922192 2.655 Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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
Large enqueue waits.
Hi to you all, High enqueue locks. This morning before I got to work there were a group of users who appeared to be hanging at times when they should have been performing updates to certain tables. I tracked it down to what I suspect is high enqueue lock times. [details are below. I don't normally see enqueue high in v$session_event or v$system_event]. I've used Steve's scripts enqueue_locks.sql and enqueue_stats.sql but they don't tell me anything that I can understand :-( By now the sessions that were affected have logged out or been terminated, so I can't put a 10046 level 8 trace on them. Can I see what the enqueue waits were referring to? Thanks in advance, Mike. Details of findings: 1 select event, s.username , time_waited/100,total_waits, total_timeouts 2 from v$session_event e, v$session s 3 where s.sid= e.sid 4 and time_waited 100 5 and event like '%enq%' 6* order by time_waited desc ; Total Event USERNAME TIME_WAITED/100 Waits Timeout -- -- --- - --- enqueueA 5498.45 17871787 enqueueB 3505.52 11401140 enqueueC 3303.44 10781071 enqueueD209.8969 69 enqueueE 63.2921 21 enqueueF 16.1714 4 6 rows selected. and using Steve's resource_waiters script: SQL @resource_waiters Event name [buffer busy waits] enqueue SID PROGRAMTIME_WAITED AVERAGE_WAIT -- --- All Disconnected Sessions 7720431 306.021346 78 f45run@scc-corp01 (TNS V1-V2)2098920989 ARC0 oracle@scc-corp01 (ARC0) 2 .25 1 select * from v$system_event 2 where time_waited 0 3* order by time_waited desc ; Total Time Waitd Average Event Waits Timeout In Hndrds Time - - --- --- --- SQL*Net message from client # 0 3271701695 30.397 rdbms ipc message 1875169 819790 422614554 225.374 slave wait 2213312 ### 167923522 75.870 pipe get 260819 249480 126637278 485.537 pmon timer 277326 27729385337384 307.715 smon timer 2783277685322173 30658.345 enqueue 25297 25128 7741422 306.021 db file sequential read48265252 0 5125270 .106 io done 820132 22440 2847667 3.472 db file scattered read 1677976 0 1585987 .945 log file parallel write 575601 2 1276956 2.218 log file sync3474011089 922192 2.655 Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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 connection
Title: RE: oracle connection I've recently encountered 3113 error e-o-f on com channel, and I followed it through, using trial and error, to the setting of ORA_NLS33. Oracle 8.1.6 installed on Solaris and Dev 1.6.1 installed separately. We started getting the errors and need to specify ORA_NLS33=/hmis11/oracle/1.6.1/ocommon/nls/admin/data explicitly for our server side scripts. After speaking to Oracle support on this, it seems they had the vague suggestion: set it to what works ! - Mike. Database Administrator -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: 04 June 2002 20:14To: Multiple recipients of list ORACLE-LSubject: RE: oracle connection Are you using MTS or dedicated connection? If MTS, first do a client trace, if that turns up nothing, just for kicks try adding (SERVER=dedicated) to your client tnsnames.ora file and see if allows you to log in by bypassing MTS. -Original Message- From: Danisment Gazi Unal (ubTools) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 2:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: oracle connection Hi, It's another bad error to diagnose. But, there should be a good note for ora-3113 at metalink. Also, If Oracle can not know that a process is being terminated, there will be no trace for this error. Because Oracle will not have a chance to dump trace file. regards... Alexandre Gorbatchev wrote: "End of communication channel" is common message when server process is terminated. You may take a look at alert.log on server-side to see what could cause it to terminate. It's often there. Also trace file for that session on the server. -- Alexandre - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:08 PM hai all. my database connection has a problem. when user start to establish connection... an error returns "End of communication channel". So no user can log in. I've already checked the status of listener , reinstall net8 component, trace file. Seems those are oke. what should i do ? thanks rgds fico -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Softhome - Fico INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev 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). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) 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: Legato oracle module.
Thanks to all tips, I'll think about it. I may chose to do my own, as per Sujatha's suggestion. At least I know where I stand, should disaster hit the machine. Mike Jenner Database Administrator C.P.S. Southampton City Council. [EMAIL PROTECTED] 02380 833985 -Original Message- Sent: 29 May 2002 01:23 To: Multiple recipients of list ORACLE-L Hi Mike, I've been using the Legato/RMAN combination for a couple of years now. The recovery catalog resides on the Legato Backup server. Once all the database backups finish, we then do a cold backup of the recovery catalog database straight to tape. I don't know what others do, but this if you can afford downtime for your recovery catalog db this is probably the best way to do it. If you have enough disk space on your server, you actually don't need the Legato plugin. Just dump the backups to disk and get the normal Legato Networker server backup pick them up onto tape. Regards, Sujatha -Original Message- Sent: Wednesday, 29 May 2002 12:23 AM To: Multiple recipients of list ORACLE-L Hi everybody, I've taken responsibility of a couple of Oracle systems on NT (in addition to my nice Solaris DBs). I'm setting up Legato to do the backups online using the Legato Networker Oracle Module. After checking the Legato docs, it seems that the only way of using this module is by integrating it with RMAN. is this right? Now, I'm sure that RMAN can do a good and flexible job. I've played with it a little but I don't like the meeesssyyy way of backing up the RMAN catalog. In the Legato docs , there's a section that warns you : Preparing For Disaster . Ensure that your RMAN Recovery catalog is being backed up regularly. . Doesn't this imply that you need to perform the catalog backup outside legato yourself?, so why did we buy it in the first place? I know you could create another catalog to perform cross catalog backups but that all sounds far to complicated and error prone. Anyone have any tips for me? [I'm much happier with my online backup scripts on Unix that I've been using and tweeking for years.] Mike. Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
Legato oracle module.
Hi everybody, I've taken responsibility of a couple of Oracle systems on NT (in addition to my nice Solaris DBs). I'm setting up Legato to do the backups online using the Legato Networker Oracle Module. After checking the Legato docs, it seems that the only way of using this module is by integrating it with RMAN. is this right? Now, I'm sure that RMAN can do a good and flexible job. I've played with it a little but I don't like the meeesssyyy way of backing up the RMAN catalog. In the Legato docs , there's a section that warns you : Preparing For Disaster . Ensure that your RMAN Recovery catalog is being backed up regularly. . Doesn't this imply that you need to perform the catalog backup outside legato yourself?, so why did we buy it in the first place? I know you could create another catalog to perform cross catalog backups but that all sounds far to complicated and error prone. Anyone have any tips for me? [I'm much happier with my online backup scripts on Unix that I've been using and tweeking for years.] Mike. Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
Rollback usage.
All, Thanks to those who reassured me and pointed me in the right direction regarding 'dbv' wrongly reporting corrupt rollback blocks after a 7 to 8 migration. For those interested: This is bug 1359160. My initial metalink search did not show related notes for some reason but I've found them now. Question though, after shrinking the system rbs, the fix is to access each rollback segment to convert it's header to V8 format however I cannot get the first rbs extent corrected. Is there a reason for this and does anyone have a solution. Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
System datafile corruption.
Guys, I have a system datafile that returns dbv errors for a SYSTEM datafile. The fault has existed for a long time undiscovered so recovery from backup is not possible. The database still does not exhibit any problems except for dbv! The errors are all 'Block Type = Undo data block', so I assume the fault is in the system rollback segment. I'm sure I can't drop/recreate the SYSTEM rbs, so does anyone have any suggestions apart from a full export and import? Dbv extract is below: Block Checking: DBA = 67108870, Block Type = Undo data block ERROR: Undo Block Corrupted. Error Code = 2008 ktu4ubck: size(108) of undo record #1 corrupted. UNDO BLK HEADER: xid: 0x.08a.0151 seq: 0x198 cnt: 0x4d irb: 0x4d icl: 0x0 flg: 0x000 0 Rec Offset | Rec Offset | Rec Offset | Rec Offset | Rec Offset --- 0x00 0x1fe8 | 0x01 0x1f80 | 0x02 0x1f2e | 0x03 0x1ee0 | 0x04 0x1e76 . . 0x4b 0x027c | 0x4c 0x0212 | 0x4d 0x01b0 Hex dump: 0x000b6b94(+): 00 0a 00 10 00 3c 00 10 00 02 00 00 2a 11 00 00 . . 0x000b6bf4(+0060): 00 9d 00 00 78 bc 01 00 grep 'Block Type' dbv_log | wc -l 127 Regards, Mike Jenner Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
Legato backup.
Hey, just to confirm what I think is obvious... For an oracle database to be backed up on NT with Legato: you need to either; shutdown, cold backup via legato, startup, or online backup mode and legato's Oracle database extension, [or some sort of strategy involving oracle export]. And to verify... legato's backup an in-use file extension used to backup oracle database datafiles that have not been shutdown... will not give a viable backup ??? A department that has not paid for my section's DBA services has just phoned up with restore problems with a database backed up in this manner! If someone could confirm the obvious, I would be grateful. Regards, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Connecting INGRES using database link
) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Set Time Zone
Mike,
Here's a thing you may well be able to modify slightly to your
requirements. It will be useful only for running the application through
Unix. The following is taken from the .profile of an account I set up here
in 1999 to test Y2K.
Hope it helps
- Mike J.
echo
echo ' Enter new date required in format ddMON'
echo
read newdate
hours=`sqlplus -s user/password EOF
set pagesize 0 linesize 499 feedback off echo off verify off;
define date='$newdate';
select (trunc(sysdate) - to_date('$newdate','DDMON')) * 24 from
dual;
EOF`
if test `echo $hours | grep -c 'ORA-'` -ne 0
then
echo $hours
exit 1
else
hours=`echo $hours | sed 's/^ *//g'`
# echo INFO: hours set to $hours
TZ=GMT${hours};export TZ
date2=`sqlplus -s user/password EOF
set pagesize 0 linesize 499 feedback off echo off scan off;
select to_char(sysdate,'DD MON HH24:MI.SS') from dual;
EOF`
fi
echo INFO: UNIX Environment Variable TZ set to $TZ
echo INFO: hours set to $hours
echo INFO: Oracle Sysdate set to $date2
# env
echo
echo OK to continue and use this date for this application session?
[y/n]\c
read dummy
if [ $dummy != ]; then
if [ $dummy = y -o $dummy = Y ]; then
echo
else
echo
echo Bye,then
sleep 3
exit
fi
fi
echo RUNNING with $date2
sleep 5
# start application here...
---
Mike Jenner.
Database Administrator,
Southampton City Council,
02380 833985
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 03:15
To: Multiple recipients of list ORACLE-L
Can't , not in 8i.
9i has introduced a TIMEZONE datatype where time can be reported offset by
the UTC+/- offset.
You'd have to build the logic in your application to increment/decrement
the sysdate, depending
on the user/client location (use a lookup table for location and
timezone-offset) when fetching
the sysdate.
SYSDATE would always return the date on the server where the database
instance is running.
Hemant
Mike T [EMAIL PROTECTED]12/12/2001 10:50 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group)
Subject: Set Time Zone
Hi Gurus,
How can I set up a time zone for each region that connect on
SAME Database 8i
Case: Database in NewYork. Clients in San Franciso, Paris ..
When they use select sysdate from dual ; ( on Client or server side )
They should see their local time .??
Thanks in advance
Tran
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike T
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).
[This e-mail is confidential and may also be privileged. If you are not the
intended recipient, please delete it and notify us immediately; you should
not copy or use it for any purpose, nor disclose its contents to any other
person. Thank you.]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jenner Mike
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 DBA help.
Lalit, Firstly, you should consider creating seperate instances for developement and live data usage. It's bad practice to have any kind of uncontrolled access to live databases such as developers (or even DBAs), no matter how good they are - sooner or later it will cause problems. To define 'types' of privilege and access rights to different users, you can use ROLES. Basically you can assign privs such as SELECT to various table to a role name 'CASUAL' (for example) and so on. Your 'users' should not create or own any database object such as tables, therefore any default tablespace you assign them will not hold data. Generally I create a tablespace called 'USERS' and set this as defualt TS for all users. The application objects and data will be available to the users via privilages via the Roles and possibly via public synonyms. Your questions are very general so I hope this helps. Regards, Mike. -Original Message- Sent: 07 December 2001 09:55 To: Multiple recipients of list ORACLE-L Assume that you are starting a new database and that you need to start adding user to this database. There are three basic types of users: developers (who can create basically all objects in the database), data processors (who can insert data into a given set of tables -CUSTOMER and ORDER TABLE as well as updates these tables) and casual user (who can view data from the INVENTORY and PARTS table). Assume also that every day there may be an unpredictable number of users to be added to the different types of categories. As a DBA, what can you do to make the task of adding user a little bit simpler? Would we assign developers and data processors to the same table space? Why or why not? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lalit Batra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Max number of sessions
Title: Max number of sessions Yuval, If you mean to estimate how you canpush the database to it's limit, I saw some demos the other day ofa simulation tool by a company called Simulus. The tool allows you to alteraspects such as H/W config,data and parameters. This may be useful to you. Regards, Mike. -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]]Sent: 04 October 2001 19:16To: Multiple recipients of list ORACLE-LSubject: Max number of sessions Hi, I would like to find out how to compute/estimate the maximum number of sessions a db can handle. Preferably based on the init.ora params sessions and processes, size of sga, size of ram, the /etc/system params etc. This is for a db running using MTS. TIA Yuval.
RE: How to select and display 10 records at a time from a table u
set pagesize 10 set pause on select ... enter return to display next page of results. - Mike. -Original Message- Sent: 29 August 2001 09:55 To: Multiple recipients of list ORACLE-L using sql query Dear DBA Gurus, How do I select and display 10 records at a time from a table using sql query only? Thanks and Regards, Ranganath DISCLAIMER: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Subex Systems Limited. www.subexgroup.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: !! *Very* important Oracle-L message !!
containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Problem connecting to a db
If the account has had TWO_TASK variable set , then I think this will also produce this error. Check/unset TWO_TASK and retry. - Mike. -Original Message- Sent: 17 July 2001 15:06 To: Multiple recipients of list ORACLE-L Logged on as administrator (NT4). Then in svrmgrl: connect internal/oracle Or : connect internal (prompted for password): oracle Same error message either way. Tried it several times, I don't *think* it is being typed wrong... Steven. -Original Message- Gramolini Sent: 17 July 2001 14:41 To: Multiple recipients of list ORACLE-L How is the user logged on to the server before trying to run svrmgrl? I always log on as oracle. hth, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 8:30 AM I have someone on a remote site who is having problems connecting to a db in server mgr as internal. connect internal should work, but it replies with insufficient privileges, I must be missing something. Does anyone have a suggestion what this could be? OS is NT 4, using Oracle 8.1.6 standard and they are logged on to NT as administrator. Thanks, Steven. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i Open Day (UK Listers)
I recieved the offical invite on my doormat this morning. I was wonderring whether to go and I see that it starts at 13:00+ which means I can still go the work in the morning. If I decide to go then a get-together /drinks would be great. - Mike. -Original Message- Sent: 29 June 2001 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have actually registered for the 9i Open Day? I think it would be a great chance to get together for a quick drink and put faces to Signatures :) Thoughts? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: * I'm Looking for an Oracle Financials DBA for Miami,
Contract rates are lower as well as permanent salaries and there is none of the 'extra job security' applied to contractors. However I work close to home and the out of hours requirements are minimal, so I'm happy. - Mike. -Original Message- Sent: 20 June 2001 17:37 To: Multiple recipients of list ORACLE-L and the UK. I have pretty much upped my salary by about 225% since I left. One of Her Majestys Disloyal servants :-) -Original Message- Sent: 20 June 2001 16:36 To: Multiple recipients of list ORACLE-L Ron Rogers schrieb: I don't doubt that there are openings available in the Govt sector. The pay scale for Govt workers is notoriously lower that the open market. I had a job offer to work for the Dept of Natural Resources in GA but I could not handle the $20K pay cut. ROR mª¿ªm Hi, thank you for your replies... and yes, it's the same in Germany, Govt. jobs are paid poorly here, too. | Regards, | | Stefan Jahnke | | @:D2 Vodafone, Abt.: FIBM | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke 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 information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: * I'm Looking for an Oracle Financials DBA for Miami,
the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [OT] Jobs in UK
Alex. There have been more taxes and restrictions applied to UK IT contractors in the last year or so prompting more people than usual to move outside the UK for work. This has prompted the UK to grant more visas to non British IT workers. I don't know about the qualifications or details for gaining UK working visa status, try searching the web for UK passport agency ,visa etc.. I've worked in the US and UK and, as always, job availability dramatically varies on actual location. However there is still a demand for quality IT experience, including Oracle DBAs. The main (only in my opinion) site is www.jobserve.com Have fun. - Mike. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 19:58 To: Multiple recipients of list ORACLE-L Hi fellows, Sorry for the offtopic but I had been in UK last week and my friends from there told me that there is a shortage of IT professionals and , that if you really got the skills , is very easy to migrate and find a job. But none of my friends are IT professionals and I don´t know how much they know from this market. So I wish to know , if possible , from the IT professionals working in UK if it is really easy to find a job and migrate ? What are the governamental restrictions ? How much we can earn in a year of work ? Where I can find more information about immigration to UK ? TIA, Antonio Belloni -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: Rollback Segments
Isn't the concept of a private RBS only applicable to parallel server setups? - Mike. -Original Message- Sent: 09 May 2001 16:21 To: Multiple recipients of list ORACLE-L Hi all, This brings me to a stupid question then. What is the true difference between a public and a private rollback segment? Because if I just think about it like a normal human being I would think that if a user made a Private rollback segment then only that user could use it, but of course I know that can't be the case. Kev -Original Message- Sent: Wednesday, May 09, 2001 10:26 AM To: Multiple recipients of list ORACLE-L Nixon, While SET TRANSACTION can be used to assign a rollback segment to a transaction, it cannot be assigned exclusively to that transaction as you have found. The ability to assign a rollback segment to a transaction and make it read-only for all others is something I've wanted myself for many years, and I know it's been on the official 'wish list' of requested changes by IOUG for some time. Maybe 9i? Anyone know? Jared On Wednesday 09 May 2001 01:40, [EMAIL PROTECTED] wrote: Hi All, Here is my environment; NT v4 Db Oracle Workgroup v8.1.6 Rollback Segments SEGMENT_NAME OWNER TABLESPACE_NAME -- -- -- SYSTEM SYSSYSTEM RBS0PUBLIC RBS RBS_P1 SYSRBS RBS_P2 SYSRBS RBS_P3 SYSRBS RBS_P4 SYSRBS RBS_P5 SYSRBS Is it possible to assign one public rollback segment explicitly to one particular transaction? I tried using SET TRANSACTION USE ROLLBACK SEGMENT but other users I found out can still use it. So, I guess the best alternative is to set that RB segment to OFFLINE after using and set ONLINE before executing the SET TRANSACTION ... Do you know how it can be done inside Forms? Thanks in advance! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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 UPU, named user or site license?
Hi, Question, particularly to UK list members, A couple of months ago I recieved a quote from Oracle for some aditional products and I was quoted prices based on UPUs. (diag pack and tuning pack for Oracle standard edition) I thought that named user was the only pricing method. Are UPUs and named user licenses both available nowadays? Alternatively, we have oracle in 3 separately licensed installations with another one on the way. Before I get the runaround from oracle, does anyone have recent experiences to share about site wide licenses? Thanks, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is MetaWink Doing Another Rip Van Winkle???
Hmmm, The site support.oracle.com is running Apache/1.3.12 (Unix) ApacheJServ/1.0 on unknown. The site support.oracle.co.uk is running Oracle_Web_Listener/4.0.8.2EnterpriseEdition on Solaris. -Mike -Original Message- Sent: 15 March 2001 20:56 To: Multiple recipients of list ORACLE-L From a previous post. see: http://uptime.netcraft.com/up/graph/?host=name_you_want_do_know_about ROR mm [EMAIL PROTECTED] 03/15/01 01:36PM Does anyone know what hardware it (doesn't) run on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: OEM - Tunning Pack, Diagnostic Pack....
Hi, I was quoted ?15,000 plus yearly support for tuning pack + diag pack. This was for 2 DBA seats but I think they based it on UPUs since they checked my platform and CPU figures. Anyway It was too expensive for my site. You would think that Oralce would price the product low to encourage easier database tuning and maintenance, which would improve product performance and image. - Mike. -Original Message- Sent: 13 March 2001 08:31 To: Multiple recipients of list ORACLE-L As far as I am aware, the pricing for OEM is per seat, so whoever uses the product will have to be licensed. Also remember that base OEM is free. Clint * Clinton S. Naud * Head systems administration * Tel: 011 685 4304 * Fax: 011 685 4303 * Cell: 082 377 1726 * E-mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 13, 2001 9:46 AM To: Multiple recipients of list ORACLE-L That is not what they told us (starts to be very tricy)! It seems, that for the OEM, licence is based on the number of users. Since we have only few DBA. we thought (at the begining of the story) that this shouldn't cost so much money. Soon we discovered it is not so. Who is right (now this licencing things start to be VERY complex)? Sonja -Original Message- Sent: Monday, March 12, 2001 7:21 PM To: Multiple recipients of list ORACLE-L Oracle has prices for this product based not on users (at least server part - OMS) but on power units. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Clinton Naude Sent: Monday, March 12, 2001 6:30 AM To: Multiple recipients of list ORACLE-L Subject: RE: OEM - Tunning Pack, Diagnostic Pack Yes, its a great set of products every DBA should use. You would however not want to give each user on the floor a copy, it would be a total waste of money. Clint * Clinton S. Naud * Head systems administration * Tel: 011 685 4304 * Fax: 011 685 4303 * Cell: 082 377 1726 * E-mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, March 12, 2001 1:05 PM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
Oratab and ORACLE_HOME.
Hi, Here's a question that's been bugging me.. If I've got Oracle DBMS installed on /oracle/product/8.1.5 and Designer 2k installed on /oracle2/1.6.1 Which one do I set my ORACLE_HOME to? and which location goes in my oratab file? Whichever one I set, I guess I need both locations in my PATH but what order? [I'm on Solaris 2.7 if anyone cares] Thanks, Mike. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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: On-Call - terms, conidtions and perks!
Sean, Interesting point and getting more valid all the time, as you say. I've worked in places where : 1) there was a laptop/pager provided but no renumeration (7 years ago, I was a junior DBA - didn't know any better!) 2) Rota of call out with (UK pound equivalent of) $6 per weekday, $8 Saturday, $10 Sunday with mobile phone and laptop and pay for any time worked over 1 hour. 3) On-call requirements with mobile phone. renumeration = 1 hour's pay for each 24 hour day of cover (wekday or weekend) plus pay from leaving home to getting home when it was necessary to be at work. I think that 1) above is unacceptable in todays financial requirements for 24/7. Somtimes arranging my life arround a possible call-out made $6-10 per day did not seem worth it but I'm a contractor so it was part of the job when I took it. If I were an employee being asked to provide on-call cover, option 3 plus laptop is pretty much the minimum I would look for. - Mike. -Original Message- Sent: 08 February 2001 10:41 To: Multiple recipients of list ORACLE-L Hi Folks, Our company has inidicated it's heading for 24 x 7 operation. So informal talks are taking place about the new "challenges" this brings regarding having staff on call to support IT systems. I would very much appreciate your feedback if you are in an on-call environment as to what the terms, conditions, and perks (if any) you get for same. Some specific information I'm looking for is: - How frequently are you on-call and for how long and to cover what hours. e.g. one week a month from 22:00 - 06:00. - What tools are you given to support this process. e.g. pager, laptop for remote dial-in, cell phone. - Whats the procedure if you "get the call". Do you dial in initially to try to resolve, that failing go on site, in other words the escalation process - What renumeration or other benefits do you get for being on call. - Are there additional 'benefits' if you are called whilst being on call. I'll treat any replies where requested with strict confidentiality. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http:\\groups.yahoo.com/group/Oracle-OCP-DBA "They tell me nothing, but expect me to know everything!" -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike 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).
