Re: LINUX instance startup problem
Most modern versions of linux have shared memory/semaphore parameters set high enough that oracle can start (unless, of course, you have an exceptionally large SGA). (Note 187397.1) If this is a fresh install (in particular a download from OTN) of 8.1.7, locate the glibc-2.1.3-stubs.tar.gz patch from Oracle. (http://otn.oracle.com/software/products/oracle8i/htdocs/linuxsoft.html). There is also a good document entitled: Oracle RDBMS OTN Downloads: Files, Sizes and Directions (Note 209555.1) -- James Seema Singh wrote: Hi, I'm having problem during startup of instance on LINUX.I have oracle 8.1.7 on red hat. When I start instance it try to come upto this below lines background_dump_dest = user_dump_dest = core_dump_dest = after that I'm getting following message SVRMGR connect internal; Connected. SVRMGR startup; ORA-03113: end-of-file on communication channel SVRMGR connect internal; Password: ORA-03113: end-of-file on communication channel SVRMGR When I see semaphore and shared memory.Its locked.I'm unable to get into server manager without killing all shared mem process. Let me know how to fix this problem pl thx -seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Re: APPS 11i (Linux) question
Senthil Kumar D wrote: Hi Group, I'm installing apps 11.5.8 on Linux 8. Rapidwiz , first unzipping some 55 components. After 54th component is hanging and the unzip process is getting defunct. Anybody faced the same issue during the installation. Any help on this Reg. Thanks, Senthil. Yes. Basically, rapidwiz has decided that your unzip process has taken too long and killed it. So, you have two choices: 1. (This is the preferred choice) Download the newest version of the RapidWiz. The problem you are facing exists in the RapidWiz that ships on the media (and in the one that immediately followed it). It should be corrected in the newest release of RapidWiz. 2. (This can be somewhat confusing) Identify which files did not unzip completely (by culling through the log files) and unzip them manually. Personally, it's just alot easier to download the latest version of RapidWiz (The version of RapidWiz on the media is _ALWAYS_ out of date). As of today (19 June, 2003) the latest patch for RapidWiz is 2981384 (159M - Generic Platform) and contains RapidWiz version 11.5.8.18. You can determine your current version of RapidWiz by running the RapidWizVersion command. -- James = James J. Morrow mailto:[EMAIL PROTECTED] Senior Technical Consultant Nascent Systems Dallas, TX -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Re: Programming languages that make DBA's lives easier
Les Ayudo wrote: On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? In (my) order of importance: 1. SQL and PL/SQL 2. Whatever shell scripting language your environment supports (sh,ksh,csh,bash on Unix, typically, and the Windows Batch language if your database is on Windows) 3. Whatever language the applications you're supporting are written in. 4. Perl. Learning the local default scripting language for your environment (ksh or Windows Batch) should be extermely high on your list as you can't always be certain that Perl (or whatever your favorite happens to be) will be installed on a given system. If you're maintaining an Oracle Apps Environment, C would be a good one to learn (or at least familiarize yourself with) as even a basic knowledge of C can help you to troubleshoot the compile/link process used so commonly with the Applications. Also, if you don't know it and you work on a unix environment, I suggest you learn the basics of the vi editor. (It's also basically the only one that you can be certain to have). Emacs may be wonderful, but vi is _always_ there... -- James Nascent Systems, Inc. Senior Technical Consultant -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Re: The future DBAs?
Arup Nanda wrote: Fellow DBAs and other DBA wannabes, Ever wondered the best path into a DBA career? Microsoft offers a brilliant way. MSN Careers at http://editorial.careers.msn.com/articles/nofuture/ suggests some jobs are effectively dead, like farmers and sewing machine operators and how the experts in that field can progress to the next logical career move. Guess which profession's logical career move is database administrator? See the excerpt from the webpage here in the attachment as a picture. I just couldn't resist posting it here. May be they are referring to SQL Server DBAs? Arup Nanda Apparently this Susan Aaron (the author of the article) didn't even bother to read the job descriptions in her bls.gov links for the Order Clerk and Database Administrator positions. The bls.gov descriptions seem to show absolutely no link between the two positions. Oh, and apparently, all of the secretaries and Word Processors of the industrialized world have been replaced by voice recognition, OCR, or have otherwise been shipped overseas... who knew? (All the execs I know dictate to tape and fed-ex it to a sweatshop deep in outer mongolia... seems it's cheaper and faster...) Makes me feel terribly antiquated for typing things myself... I suppose I should fire up that room full of monkeys at typewriters... never know when you might need to write a Shakespeare play... -- James -- 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).
Re: Solaris vs Windows 2000
Mark Leith wrote: Firstly, can I say that any NT/2K administrator that feels they need to install Microsoft Office (or just Outlook), and feels they need to upgrade the web browser for a production Oracle database system should be shot on site! The same goes for things like IIS (Microsoft's integrated web server) as this again is a known security flaw.. Apache runs just fine on Win2K (Oracle installs it on the windows platform as well). The same also goes for Perl, and I believe Jared is most surely a Perl man! There is also no longer a 4 CPU limit on windows systems. This does of course depend upon the version of the Operating system that you buy, but Win2K Datacentre Server supports up to 16CPUs. (http://www.winntmag.com/Articles/Index.cfm?ArticleID=7597) I'll conceed the 4-cpu limitation is past. However, a search of various hardware vendor sites reveals: DELL: PowerEdge 8450 -- Max 8 Pentium III Xeon CPUs PowerEdge 7150 -- Max 4 Itanium CPUs PowerEdge 6600 -- Max 4 Xeon MP CPUs http://www.dell.com/us/en/biz/products/series_rkopt_perf_servers.htm http://www.dell.com/us/en/biz/products/series_pedge_servers.htm Hewlett-COMPAQard: HP lxr8500 series -- Max 8 Pentium III Xeon CPUs HP rx9610 series -- Max 16 Itanium CPUs http://netserver.hp.com/products/highlights_lxr8500.asp http://www.hp.com/products1/servers/rackoptimized/rx9610/index.html http://www.hp.com/products1/servers/operating/windows.html I'm kinda curious as to why they don't show any Itanium-based servers on the Windows Server page that scale beyond 4 CPUs. IBM: xSeries 360 -- Max 4 Xeon MP CPUs xSeries 440 -- Max 8 Xeon MP CPUs http://www.pc.ibm.com/us/eserver/xseries/ http://www.pc.ibm.com/us/eserver/xseries/x440.html Unisys, however, does make a 32-way box. ES7000 Series -- Max 32 Itanium 2 or Xeon CPUs http://www.unisys.com/products/es7000__servers/index.htm One thing I'm somewhat curious about. How much do you have to pay in terms of M$FT licensing for Win2000 Data Center on a 32-way box? (I can't seem to find published pricing out there... so I'm prone to believe that it may be heavily discountable). I stumbled across the following link a couple of weeks ago Jared, and book-marked it for later reading.. I still haven't managed to read it as yet, so can't comment, but it looks like it applies.. http://www.winface.com/article.html And yes, excellent article. Apart from the other URLs that you have already posted, I haven't seen any decent comparison sites out there. HTH Mark Now, as far as any NT/2000 admin that feels the need to install. Unfortunately, part of the big selling point of Windows as a server platform is that you don't need those expensive unix admins to run it. The theory being that any idiot can administer Windows NT/2000. As a result, many NT/2000 server installations *DO* end up with IIS, Outlook (or at least Outlook Express), Office, and other unnecessary garbage installed on it because the administrators either don't know better or simply don't care. Now, you know as well as I do that: 1) Nobody in their right mind wants any idiot doing it. 2) While any idiot can probably _do_ the job (to some extent) Even Windows takes a skilled administrator to properly setup and maintain. 3) The truly _GOOD_ NT/2000 admins are every bit as hard to find (if not harder because of the size of the talent pool) as a good Unix admin. And are (or at least should be) almost as expensive. -- James SNIP old posting -- 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).
Re: Solaris vs Windows 2000
Jared --
I tend to agree with your statements. Although, personally, I tend to think
that Windows NT/2000/XP is a wholly inappropriate environment for any enterprise
database. The general reasons I tend to choose to back my statements:
1. Scalability. (I'm sorry, clustering is an availability solution,
not a scalability one. If you can't grow beyond 4 CPUs [Intel's problem
more than M$FT's, here] and need to, then an Intel platform is not for
you.)
2. Managibility. I can do practically anything I need to on a unix box
over a 300bps modem, if necessary. (This omits, of course, inserting
media and hitting the power switch... oh, and installing oracle now that
they have this java-based installer... fortunately, that's not *that*
common of an occurance in ordinary maintenance)
3. Did I mention scalability? Most *nix platforms scale in a much more
linear fashion. (i.e. 2 cpu's are more likely to give you double the
performance on a RISC-based system than on an x86 based one.) Note:
I'm saying only that RISC systems tend to be *more* linear than x86
ones.
4. Supportability. (yeah, I know, not really a word). I've supported
Oracle on both (especially Oracle Applications). Personally, unix
platforms tend to provide much more useful information when something
does go wrong. The standard Microsoft error message of it's broke
doesn't really tell me anything useful.
5. Security. How many security flaws have been found in 'doze? And don't
even get me started on M$FT Look-out! (otherwise known as a security
hole that occasionally delivers mail). It's also nice that *nix
platforms are immune to all of the _really_common_ virii that hit the
news these days (Melissa, I Love You, etc.). (Not that *nix is truly
immune to virii... but the big-bad-ugly-ones you hear about tend to
exploit flaws in... hows that again? Right... Windows and Lookout...
Although it helps somewhat that the *nix security model tends to
compartmentalize things a bit more than windows does [by default]).
6. Do you *really* want all of the overhead of a tightly-coupled GUI on a
_server_?
Admittedly, Windows 2000 does appear to be far more stable than previous
versions. And the NT-derivatives don't tend to crash in a wholesale manner like
the Windows/386 derivatives ('95,'98,ME). But, personally, I should _NEVER_
have to reboot a machine to upgrade/patch a web browser.
-- James
==
James J. Morrow
Nascent Systems, Inc.
Dallas, TX
mailto:jmorrow;warthog.com
[EMAIL PROTECTED] wrote:
Dear List,
Believe me, I am not trying to rehash an old topic, start any
flame wars, nor look for supporting evidence for my admitted
bias toward unix operating systems.
Now that that's out of the way, what I am trying to do is find
objective material comparing the use of MS Windows 2000
Server on Intel HW to Solaris on Sun HW.
This is for an SAP implementation. We are currently running
SAP 4.0b on MS NT 4.0 SP 6, on Dell 4 CPU Servers. ( I forget
just which server )
As part of our process to upgrade the system to 4.6c and more
recent versions of Oracle ( like 8.1.7 ), we are trying to do a
comparison of the features, benefits and advantages of using
Win2k Server and Solaris.
Please don't refer me to such sites as www.kirch.net and
www.osdata.com. 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
Re: 20 Instances 1 Machine
Your biggest problem is not going to be physical RAM or disk space (either of those could simply be purchased large enough). However, you *will* encounter a problem with Shared Memory. 32-bit (and even 64-bit) operating systems have a finite amount of shared memory addressable for use by 32-bit applications (namely the RDBMS shipped with the Oracle Applications). This number is 1.7GBytes on HP/UX and, I think, 2GBytes on Solaris. This Shared Memory limitation is systemwide. The Oracle RDBMS uses shared memory heavily for major components of the SGA. As a result, if you're running a 32-bit version of Oracle, this number represents the sum of all SGA's running on that machine at the time. (So, at 500M/instance, you'll run out somewhere between 3 and 4 instances). Possible solutions would be: 1) Use a 64-bit version of the Oracle RDBMS as certified for your platform. A 64-bit version of Oracle would address shared memory from a much larger total pool (most likely an absurdly large number), thus avoiding this 32-bit Shared Memory problem. 2) Consider using something like Sun's System Domains to partition a big box into multiple virtual machines. Each of these Domains would have it's own shared memory pool. 3) Consider using seperate machines. Personally, I'd vote for seperate machines. I tend to prefer only one production system exist on any given host as it tends to eliminate much of the performance-oriented fingerpointing that is bound to come up. Additionally, running a large number of production instances on a single host can be alot like putting all of your eggs into one basket. It may be cheaper, but if something happens to that basket, everything's hosed. As far as hardware: Lots of disk, plenty of I/O channels, and plenty of CPUs. Without actually knowing the nature of your applications, I'd say you're probably looking in the SunFire 6800 or SunFire 15k range (if you're looking at Sun equipment). Post, Ethan wrote: I got a request to spec out a machine that could handle 20 separate Oracle instances on a single UNIX server. SGA should total about 500 MB per instance. We have some hosts here with 6-8 instances but never tried 20 before. Wondering what types of things I should be worried about, obviously having enough memory but are there any other limitations I can expect? Anyone had to do this? Thanks, Ethan -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: 11i installation ???
Leslie Lu wrote: Hi all, I purchased the Oracle 11i Release 5 (with 11.5.6 family packs) CD pack for Windows from Oracle online store. My first installed (Win2000) run out of space, and I cleaned the folders manually. When I got more space and installed again, I got: not all the dependencies for the component OEM common files 2.2.0.0.0 are found. Missing component Oracle.swd.jre 1.1.8.10.0. Looks like the manually cleanup didn't go well. What should I do now? Also, how long does the install take? One guy told me to install one product/one db at a time. Is this a good idea? Is demo db enough? Are there any Oracle 11i group/email list? I know, lots of questions. :-) Thanks! Leslie Bear in mind that Oracle Applications 11i has certain dependencies that are specific to the M$FT Windows NT/2000 platform. Most notably: Visual C++ 6.0 and MKS Toolkit (both of which are additional cost items, totalling between $600-$1000). There are several documents on metalink you may want to look at if you've had a failed install (on Windows... similar docs exist for Unix): DocID: 137200.1 Checklist when OUI Fails for Windows DocID: 143976.1 How to clean up a failed install of OA 11.5 on an NT Platform As far as how long the install takes: On Unix, once you've built your staging area, it can take upwards of 2-3 hours to do a full install of the VIS demo instance. Mostly determined by the speed of your system (CPUs/Memory/Disk). On NT, it can take a bit longer. Especially if you factor in the additional time required to install the prerequisites. (MS Visual C++, MKS Toolkit, GNUMake). And, of course, there are at least 5 reboots involved... (More if you're into patching things current...) -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: shutdown abort / startup restrict / shutdown vs. shutdown imm
April Wells wrote: Yes, I WHOLE heartedly agree, and we do a shutdown immediate now, but the point is... Oracle SUPPORT seems to be of the opinion that rather than trying to figure out what is 'wrong' we should just do a shutdown abort it 'Is a valid solution'. I'm guessing there IS a REASON it is doing this... and that it is only doing it in one of my three financials instances CONSISTENTLY... and NOT the one that was the source of the recent clone. ajw SNIP April -- Yes, this is a valid work-around. And, No, in _my_ opinion, this should not consider the problem solved. There is (obviously) a bug somewhere that is causing the instance to hang when you do a shutdown immediate. That bug should be addressed and/or corrected. I seem to remember a time when some of the conventional wisdom stated that you should ONLY do shutdown abort and NEVER do shutdown immediate. However, when I started digging into the whys of this statement, what I was able to come up with was a bug in a particular release of the Oracle RDBMS on HP/UX (I think it was 7.1.3, but I'm not sure). Interestingly enough, the DBA's I was speaking to that *SWORE* you should never do shutdown immediate were all on HP/UX. So, from my standpoint, (and the stated purpose of each of the shutdown commands), SHUTDOWN IMMEDIATE is the correct shutdown. Abort/Startup/Shutdown Normal *will* work in your situation as a valid work-around. However, the bug should still be investigated and corrected. Have you investigated pro-actively upgrading the RDBMS to a (slightly) more current version? (I'm not suggesting 9i here, but as I recall you're 8.1.7.3. I believe that an 8.1.7.4 exists, just maybe not on AIX). -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: (Fwd)
%2Fclearstation.etrade.com%2Fcgi-bin%2Fdetails%253FSymbol%253DORCL Seems to show ORCL mostly following NASDAQ. (sorry about the ugly URL) regards, ep | Original Message: | - | From: Tim Gorman Tim@SageLogix=2Ecom | Date: Mon, 15 Jul 2002 13:02:06 -0800 | To: ORACLE-L@fatcity=2Ecom | Subject: Re: McCain on Larry Ellison and Corporate Responsibility /=20 | Re: OT - unix | | Nope=2E | | I just thought that people are innocent until proven guilty=2E One=20 | thing about someone in Ellison's position is that it would be=20 | impossible for him to *ever* sell stock without having the unfounded | accusations you've quoted being hurled at him=2E So, are you saying=20 | that it is OK to throw such accusations around, when you don't know | anything about anything? Or is there further substantiation for what | you're saying? Does that mean he should never sell stock? Or should | he just live his life and ignore the critics? | | I respect and admire Sen=2E McCain as much as I respect and admire=20 | anyone, but he is not infallible and he (and his staff) can certainly | be off the mark=2E=2E=2E - Original Message - To: Tim Gorman Tim@SageLogix=2Ecom; ORACLE- L@fatcity=2Ecom Sent: Monday, July 15, 2002 10:49 AM unix Tim, It is my understanding that Oracle's stocks have gone up and down wildly several times=2E As you say, the only time I've heard that Larry Ellison cashed out before a plunge happened was the recent one that McCain brought up=2E I'm afraid I fail to see what you think people should conclude from all that=2E Are you saying that it is ok for stock holding workers and investors to get gigantically screwed just because Larry Ellison has only done it once? SNIP -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: Weird Windoze 'AT' Behavior
You may want to check a couple of things: 1. Be careful which editor you use. (Consider locating an old copy of the MS-DOS QEdit shareware program. It's small, and very clean). Or, use the DOS EDIT utility. (If you feel the need for a windows editor, notepad is probably your cleanest choice.) 2. DOS sometimes needs an end-of-file marker (Ctrl-Z). Some things won't recognize the last line without it. 3. Or, if you're a *nix bigot like me, install cygwin (http://www.cygwin.com). You'll get a unix-like cron utility as well as some decent scripting tools... Farnsworth, Dave wrote: I have Oracle 8.1.7 running on NT. I do cold backups nightly and have a batch file that is called by the NT 'AT' scheduler. I recently changed some lines of commands in the batch file and since then when the batch file is executed by 'AT' only the lines that I did not edit are executed. If I execute the batch file from the command prompt it works fine. I deleted the job from 'AT' and then entered it back in but still getting this odd behavior of only executing the commands that I did not edit. Our SA's know nothing about 'AT' so they are of no help. Has anyone else seen this odd behavior in the 'AT' function in Windoze? I know you find it hard to believe that something can be weird in Windoze. ;o) And yes, I am soon planning on learning RMAN and do hot backups. I have the 8i Backup and Recovery Handbook for my reading pleasure. I see the app that is being used going to a 24X7 schedule. Now it is only used during the day. Thanks, Dave -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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 Linux ... Production Strength ???
with Oracle datafiles). If you're not actively using this feature, then changes will get logged and that will tend to encroach on your usable space on the filesystem. 4. As you move towards production. Consider using a completely PRIVATE LAN connection between your Database Server and the NetApp Filer. (Ideally, directly wire using crossover cable, the 100BaseT interface on the Filer to a 100BaseT interface in your Database server. Have a seperate interface for both devices [db server filer] on the public net for regular access. Run *ALL* of the NFS traffic over the PRIVATE network). This way, your [relatively inefficient] NFS traffic won't have to compete with other traffic and the high amount of traffic generated by NFS won't impede your public network. I'd caution against saying well, we're on a switched network anyway because, regardless, the switch will incur additional workload handling that NFS traffic. Extra nics and crossover cable are, in the long run, cheap. Unfortunately, NetApp tries very hard to sell their product into the Oracle space. (sometimes too hard). While their product is amazing at things that NFS (or an NT file server) is good for, personally, I'll take locally-attached disk any day for my Oracle databases. But hey... When the only tool in your toolbox is a hammer, suddenly everything starts to look like a nail. -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: DOS Script for pop up question ?
Bob Robert wrote: All, I have a DOS batch file. In between this script, I would like to add user interactive question. Ex: Do you want to Continue [Y/N]? Once they hit Y, it will continue rest of the batch file. Could someone able to help me out as per the above requirement? Thanks, Bob Well, the simplest answer would be to use the Pause command. This assumes, of course, that you don't really care what key they press... simply: echo Hit Control-C to abort or... pause Will return: Hit Control-C to abort or... Press any key to continue I'm pretty sure that the DOS batch language doesn't have any get keystroke functionality built-in. However, the CMD language might. A search on google for dos cmd batch get (http://www.google.com/search?sourceid=navclientq=dos+cmd+batch+get) yields this link: http://www.simtel.iif.hu/pub/msdos/batchutl/ Which has a whole slew of MS-DOS based utilities. I'm sure one of them would have a little *.exe that would read a line or a character from stdin. Additionally, you could consider Cygnus for Windows (aka Cygwin) available through redhat.com. Cygwin is a Windows tool that gives you Unix functionality. Including some of the popular unix shells for scripting (Bash, Tcsh). This product (free, as in beer) provides the same functionality as the (much more expensive) MKS Toolkit (available from MKS Software... http://www.mks.com). The MKS toolkit is required for Oracle Applications 11i on MS Windows NT/2000. http://freshmeat.net/projects/cygwin/?topic_id=45%2C74 or http://cygwin.com -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: Jr.DBA, Mid level DBA, Sr.DBA
I beg to differ. All Real DBA's should be platform independent. (and if that platform comes from M$FT, they should probably be undergoing intense therapy). -- James [EMAIL PROTECTED] wrote: Better run like WIND!! All Real DBA's use HP. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 5/31/2002 11:01 AM AIX? Come on all really senior DBAs work on SUN (ducking and running broken field pattern :) ) --- Freeman, Robert [EMAIL PROTECTED] wrote: A few thoughts... SNIP Really Sr. DBA: Is busy installing the latest version of Oracle on AIX, and SNIP -- James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: So, What is a 'Production DBA'?
Peter Barnett wrote: We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of Production and Applications DBAs. The DBA group has loosely translated this into the group that is always on-call and the group that gets their weekends off. I would appreciate some input from those of you who are Production DBAs. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] Much of this may have already been said, but, here's my $0.02 ($0.012 after taxes): Generally, the term Applications DBA (note the plural form of Application there), refers to one who is concerned with the Oracle Applications (or Oracle Financials, or the Oracle Cooperative Applications, or the Oracle E-Business Suite, or whatever they're calling the bundle this week). That said, there is a pretty significant difference between an Applications DBA and a Regular DBA. Mostly, the Applications DBA would tend to do less of the data-modeling and, in some degree, less of the developer-handholding than a Regular DBA. Also, prior to the advent of a simple little trick they decided to give a complex-sounding name server-partitioning, the Regular DBA would probably have been much more familiar with the *newer* features of the RDBMS. (The Oracle Apps being such a behemoth that they generally don't (didn't) make use of many of those features). For example: Roles, Defined referential integrity constraints (relatively new to the Apps), partitioned tables/views, star schemas, replication, etc. Although, like anything, your degree of exposure to these features may somewhat depend on the systems you're supporting/implementing. Now, as to a Production vs. a Development DBA (Development probably being a more appropriate term in most cases). A Production DBA is generally more concerned with the overall availability and stability of the system (Backup/Recovery, Performance [identifying bad code and bashing the developer over the head with it], datafile placement, Failover, etc.). A Development DBA probably has more direct input into the design of the system (Normailzation, ERDs, tuning bad code before it goes into production). The Development DBA also probably has to/gets to deal with the Developers more frequently. So, IMHO, a good Production DBA would more likely have a Systems Administration background. While a good Development DBA would more likely have a Development background. And, a Great DBA should have some of both. -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: Financials Client question
Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] -- James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. McKinney, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: Remote DB Installation
First let me say, It *CAN* be done. Given the right set of circumstances. You will need: 1. Some way of displaying X-Windows 2. A telnet or ssh session into the box. In all likelyhood, there will be a firewall involved somewhere, so some form of TCP/IP tunnel (VPN) would probably be required. While you can run X over a wide-area network, it can be rather slow and painful. (And I'm betting the ping-times between the US and Central America probably aren't all that great). So, I'd strongly recommend that you use either VNC (freely available from ATT Labs) or PC/Anywhere to control a PC with X-Windows software (Exceed/Reflection) on it. (VNC and/or PC/Anywyere will make the slow line speed much more bearable). Oh, and obviously, you'll need the proverbial well-trained monkey to load the CD into the drive for you... KENNETH JANUSZ wrote: I have a possible opportunity to install an Oracle DB (8i or 9i) for a company located in Central America. I am located in the Minneapolis / St. Paul, MN area. What tools would I need to install this remotely from MN? The server would probably be Sun or HP unix. Thanks, Ken Janusz, CPIM -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. Arlington, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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: Cronjob misbehaving
Simon --
One of the things that many people (even some of the more experienced unix
types) tend to forget is that cron doesn't source the user's profile. This is
why a script might work just fine from the prompt, but fail when submitted
through cron.
So, the solution would be either:
a) Make sure your script sources the user's .profile
or, better yet:
b) Adopt a standard by which any script you may want to
possibly submit through cron defines the important environment
settings ($ORACLE_SID, $ORACLE_HOME, $PATH, etc.)
-- James
Simon Waibale wrote:
Hi all,
Thanx for all the good work U R doing for Oracle.
I have a misbehaving cronjob
-Cron Entry
0 5 * * * /usr/scripts/recompile.sh /ops/scripts/recompile.log 21
-recompile.sh
#!/bin/ksh
## Program name : recompile.sh
## Purpose : Recompile Invalid Database Objects for specified Shema in
FLAG
## Author : C.S Waibale Simon
## Date written : 2002-03-19
#for i in FLAGPASS CALLSPASS FLAGPASS CH1PASS CH2PASS CH3PASS ; do
#j:=1
#$i=${i:-$(crypt flag passwds |awk '{print $j}')
#done
SQLPLUS=/ops/product/817/bin/sqlplus
#Do not export the password variables !
FLAGPASS=${FLAGPASS:-$(crypt flag /usr/scripts/passwds |awk '{print $1}')}
CALLS_PASS=${CALLS_PASS:-$(crypt flag /usr/scripts/passwds |awk '{print
$2}')}
WHPASS=${WHPASS:-$(crypt flag /usr/scripts/passwds |awk '{print $3}')}
echo Recompiling Invalid Database Objects in the FLAG instance
#This can be sustitued with generic code
$SQLPLUS flag_calls/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
$SQLPLUS flag/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
$SQLPLUS flag_wh/$[EMAIL PROTECTED] @/ops/rom/recompile.sql
-recompile.log
Recompiling Invalid Database Objects in the FLAG instance
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
Message file sp1lang.msb not found
Error 6 initializing SQL*Plus
What could be broken ??
The script runs correctly from comand prompt.
---
+---+
C.S Waibale Simon
MTN-Uganda, 8th Floor UDB Building
Cell: +256 77-212655,http://mtn.co.ug
+---+
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Simon Waibale
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).
--
James J. Morrow E-Mail: [EMAIL PROTECTED]
Senior Principal Consultant
Tenure Systems, Inc.
Arlington, TX, USA
The reasonable man adapts himself to the world: the unreasonable man
persists in trying to adapt the world to himself. Therefore all progress
depends on the unreasonable man. -- George Bernard Shaw
--
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 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: lights?
There is something similar in Kansas City, MO. A church designed by Frank Lloyd Wright (on the Plaza) has a shaft of light projecting straight up from the roof. The shaft of light was part of the original design by FLW. However, at the time, the lights required to achieve the intensity and coherency required by the design would have weighed too much for the roof to support. About 10 years ago, they finally implemented the design using high-intensity halogens (which, of course, weigh significantly less). http://www.geocities.com/CollegePark/Campus/5886/ccc3.jpg [EMAIL PROTECTED] wrote: Rachel, From what I heard on NPR, they need to avoid blinding pilots and distracting migratory birds with the lights. It was rather awesome on tv. Please let us know how it looks in person. Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] -- James James J. Morrow E-Mail: [EMAIL PROTECTED] Senior Principal Consultant Tenure Systems, Inc. Arlington, TX, USA The reasonable man adapts himself to the world: the unreasonable man persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. -- George Bernard Shaw -- 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 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).
