RE: Veritas Backup Question
Teresita, You've gotten some good comments...even a quick tutorial on backups. My recommendation to you (especially if you don't have any backups at all) is that until you're more familiar with the tools you have that you should initially avoid the complexities of incremental backups and immediately arrange for a regular cold (database down) backup. Minimally this should include all datafiles, control files, online redologs, and archived redologs (you didn't say whether or not you are in archivelog mode). But don't stop with these files. Check documentation CD. It will have a section on backup and recovery. Kip |Hi!! |My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just |to make queries, funtions some updates and create indexes or tables, that |all. |Now I am in a little difficult situation, here we have a DBA that do not |have much experience. He has been working with Veritas NetBackup 4.5 for |Windows for three moths with out results. We still can not make a backup of |our data bases. |The situation is that because of that my boss make me work with him in this |task, of course I don't know anything about the issue and my priority for |tomorrow is to make and investigation of how other people make their backups |with Veritas. |Our DBA explain us that it was a way that he saw in a book, first make a |complete backup of our databases on Sunday then from Monday thru Wednesday |made a incremental backup, then from Thursday thru Saturday make another |incremental backup, but this one will be done from the last incremental |backup of Wednesday to the day we are. |- |--- |--- | - | -- | -- | Complete backup |1 2 34567 |1-Monday |7- Sunday |I am really lost in this task because the person that is suppose to teach |about Veritas is really reluctant , but my boss what results. |If any one can help me telling was is the better way to do a backup using |Veritas that will be great. I also need to learn Veritas so if you have any |page or document that can help I will appreciate it. |We really need to make this work because in the last weeks we are having |troubles with our server, with out explication it gets crushes. |I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 |and |And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server |with Windows 2000 SP4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Disk capacity planning
Hi Rhojel, You've had some responses that go beyond your forecasting question. I'll go the simple-minded route here. Maybe there is some canned software out there that will do it but it seems vendors stay away from forecasting future growth. Maybe this is to avoid being held accountable for faulty results (probably shouldn't trust my answer either...). Anyway, I was taught that the first rule of forecasting is that the forecast will be wrong. This doesn't mean you shouldn't forecast the growth of your database. It just means that you need to follow your forecast on a regular basis and note variances (ie: significant changes to growth rates) and ask questions. A spike in growth can be a development boo-boo, new functionality, growth in business, or something else. A simple approach is to track (at least monthly...depending on your comfort zone) the physical size of tablespaces and actual data and calculate net changes in size between your forecasting periods (eg: Month). Summarize this and calculate the average rate over time (eg: Year). Given the average rate and the last rate, you can forecast your growth using both rates over some horizon (1 year? 2 years?) and compare it to your available diskspace. You should be able to identify when you'll run out...but don't assume this will be correct. Also track significant events that may have driven growth. And if there is a major difference between the average growth rate and the last growth rate...it's analysis time. There are fancier forecasting methods like exponential smoothing and so on but the simple approach might get you started. But you need to keep testing results to see if your situation has changed. The above would be a fairly simple spreadsheet. Kip Bryant |Hi everyone! |Can anybody point me to any good documentation regarding disk capacity |planning? Sharing your experience or approach will also give me so much |help. I'd like to know other people's approach on forecasting the growth |of their databases particularly on determining the (growth) rate of disk |space usage and on deciding when to add and how many disk to add on an |Oracle server. |Thanks in advance. |Best Regards, |Rhojel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Documenting databases
Don't know if this has been mentioned or if it does enough of what you're looking for but you can pick up something called RDA (remote diagnostic agent) from Oracle that'll give you an overview of OS setup, Network, performance (very high level), and RDBMS info. And the result is web-a-fied which might please your manager. I forget whether I found this in metalink or technet... Kip |The internal stuff can be documented with OraSnap. |Just google for it. It's free, detailed, and easy to setup and automate. |Jared |[EMAIL PROTECTED] |Sent by: [EMAIL PROTECTED] | 12/09/2003 03:34 PM | Please respond to ORACLE-L |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |cc: |Subject:Re: Documenting databases |Dan, |That's a good idea for documenting structures inside the database. |However, my database manager wants more high level info: database name / |host, oracle version, listeners, applications that use it, cron job |descriptions and times, main schemas and what they are used for, lists of |developers names that access the databse, etc... |Alan | Daniel Hanks | [EMAIL PROTECTED]To: Multiple |recipients of list ORACLE-L [EMAIL PROTECTED] | c.com cc: | Sent by: Subject: Re: Documenting |databases | [EMAIL PROTECTED] | .com | 12/09/2003 04:09 | PM | Please respond to | ORACLE-L |On Tue, 9 Dec 2003 [EMAIL PROTECTED] wrote: | Recently our database manager has asked us to do the unthinkable | document our databases! To make matters worse, and without our input, |he | went ahead and created a schema and put it in an Access database (using | tables to make it look like a speadsheet). Either we use his idea or |come | up with something else. | So, I thought I'd ask everyone on the list how you do it. Text |files? | In a database (oracle, or other)? Spreadsheets? What are the pros and | cons? Etc | |How about in each database itself. |COMMENT ON TABLE|COLUMN tab|tab.col IS '...' |comes to mind. It's simplistic, yes, but at least you don't have to |remember where you put your documentation... |HTH, |-- Dan | | Daniel Hanks - Systems/Database Administrator | About Inc., Web Services Division | |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Daniel Hanks | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). Content-type: text/html; charset=us-ascii brfont size=2 face=sans-serifThe internal stuff can be documented with OraSnap./font br brfont size=2 face=sans-serifJust google for it. nbsp;It's free, detailed, and easy to setup and automate./font br brfont size=2 face=sans-serifJared/font brfont size=2 face=sans-serifbr /font br br br table width=100% tr valign=top td tdfont size=1 face=sans-serifb[EMAIL PROTECTED]/b/font brfont size=1 face=sans-serifSent by: [EMAIL PROTECTED]/font pfont size=1 face=sans-serifnbsp;12/09/2003 03:34 PM/font brfont size=2 face=sans-serifnbsp;/fontfont size=1 face=sans-serifPlease respond to ORACLE-L/font br tdfont size=1 face=Arialnbsp; nbsp; nbsp; nbsp; /font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; To: nbsp; nbsp; nbsp; nbsp;Multiple recipients of list ORACLE-L lt;[EMAIL PROTECTED]gt;/font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; cc: nbsp; nbsp; nbsp; nbsp;/font brfont size=1 face=sans-serifnbsp; nbsp; nbsp; nbsp; Subject: nbsp; nbsp; nbsp; nbsp;Re:
Re: OT California
Check your Latin...that's Gubernator... |How, in the world, did a man with such a poor taste in movies |build such a huge company like Oracle Corp? No wonder that Arnie |has become a guvernator of CA. BTW, has anyone here seen the |Demolition Man? It's not an Arnie movie, but the scene with the |Schwartzenegger presidential library got completely new meaning. |On 10/16/2003 01:09:32 PM, Boivin, Patrice J wrote: | I found this quote in Sillicon Valley News: | | Q U O T E D | | I'd just like to say for the record, 'Commando' is one of my | favorite | movies. | -- Oracle Chairman and Chief Executive Larry Ellison offers some | thoughts on | Arnold Schwarzenegger, California's governor-elect. | (ref. | http://www.siliconvalley.com/mld/siliconvalley/business/columnists/gmsv/7011 | 848.htm ) | | I wonder what's happening in California for Oracle Corp, HP's CEO is | part of | Arnold's transition team, but not much comment about Oracle in that | state. | I know about the contract controversy, maybe that's why we didn't | hear | much. | | Patrice. | | -- | Please see the official ORACLE-L FAQ: http://www.orafaq.net | -- | 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). | |Mladen Gogala |Oracle DBA |Note: |This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. |Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Mladen Gogala | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Desupport of RBO
OK, dumb question. Does this mean the rule hint won't be possible? Application I support mostly uses CBO but there have been cases where we had to resort to RBO hint. 'course it'll be some time before we can consider v10... Kip |Hi Jared, |haven't seen it, too. But the fact |was spreaded over the newsgroups. |We still have some 3rd party apps that don't use |*any* feature above Oracle 7 (well, almost). Queries with |the RULE hint where it's not necessary. |But if we change a thing, support will be lost. |So we decided to rewrite the whole app. |Lucky me: enough work for the next years. |Greetings, |Guido | [EMAIL PROTECTED] 07.10.2003 01.34 Uhr |First time I've seen this note: 189702.1 |Jared |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Guido Konsolke | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Offshore protests
While I wouldn't say I was anti-union, when I worked unionized jobs (construction, teaching, civil service) a long time ago -- it was like working for two bosses. If you disagreed with the union you had no recourse and were likely to experience problems if you did. And you really don't want to live through a strike. kip |Have any DBA's ever been sued for malpractice? |I used to belong to a union. One day the union told us to go on strike, |and we did. |22 years later, we're still on strike. I'm sure we'll be going back to |work any day now. Then I can quit this temporary IT career I've been |working at for 22 years now. |Unions suck, IMHO. Worst career move I ever made was joining a union. |--Walt | -Original Message- | From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] | Sent: Monday, September 22, 2003 11:15 AM | To: Multiple recipients of list ORACLE-L | Subject: Re: RE: Offshore protests | | | dba union could be considered a trust. doctors tried doing it | and because they are 'independent businesses' its not a union | its a trust. they did it to fight high mal-practice suits. | | | | From: Orr, Steve [EMAIL PROTECTED] | Date: 2003/09/22 Mon PM 12:34:40 EDT | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | Subject: RE: Offshore protests | | But do we have to beat up people who refuse to join... | Or make an offer they can't refuse. ;-) | | -Original Message- | Sent: Monday, September 22, 2003 10:00 AM | To: Multiple recipients of list ORACLE-L | | | Definitely steel workers. We are being left to sweat in dark and we | frequently get burnt by fire. | | -- | Mladen Gogala | Oracle DBA | | | | -Original Message- | From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On | Behalf Of KENNETH JANUSZ | Sent: Monday, September 22, 2003 11:30 AM | To: Multiple recipients of list ORACLE-L | Subject: Re: Offshore protests | | | The labor unions would definitely be interested. Teamsters, | Steel Workers, AFSME? | | Ken Janusz, CPIM | | - Original Message - | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | Sent: Monday, September 22, 2003 10:09 AM | | |We could make a splash by organizing a DBA union. I'm | sure that all |heads | on |the Capitol Hill |would turn when both members show up with banners, | demanding better |pay | for |starved database |administrators. What do you think, should we mandate 9i OCP for |joining | the |union? If we were |in London, we could have a permanent beer table at the | White Heart pub |(or is it the Sphere?). We might even encounter Harry Purvis and |exchange the union stories. | |-- |Mladen Gogala |Oracle DBA | | | | -Original Message- | From: [EMAIL PROTECTED] | [mailto:[EMAIL PROTECTED] On Behalf | Of DENNIS WILLIAMS | Sent: Monday, September 22, 2003 10:45 AM | To: Multiple recipients of list ORACLE-L | Subject: Offshore protests | | | Looks as if tech workers are learning the basics of | protesting. | | | http://informationweek.com/story/showArticle.jhtml?articleID=15000146 | | | Dennis Williams | DBA, 80%OCP, 100% DBA | Lifetouch, Inc. | [EMAIL PROTECTED] | -- | 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 | -- | Please see the official ORACLE-L FAQ: http://www.orafaq.net | -- | Author: Orr, Steve |INET: [EMAIL PROTECTED] | | Fat City Network Services-- 858-538-5051 http://www.fatcity.com | San Diego, California-- Mailing list and web | hosting services | | - | To REMOVE yourself from this mailing list, send an E-Mail message | to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in | the message BODY, include a line containing: UNSUB ORACLE-L | (or the name of mailing list you want to be removed from). You may | also send the HELP command for other information (like subscribing). | | | -- | Please see the official ORACLE-L FAQ: http://www.orafaq.net | -- | Author: [EMAIL PROTECTED] | 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
RE: The Coming Job Boom
Picked up the text of the article on another listserv... This appears in the latest edition of Business 2.0: (its subscription, so Ive included the entire article inline rather than a link): The Coming Job Boom Forget those grim unemployment numbers. Demographic forces are about to put a squeeze on the labor supply that will make it feel like 1999 all over again. By Paul Kaihla, September 2003 Issue Judy Reed is a buyer in a buyer's market, and frankly, that has its advantages. The vice president for human resources at Stratus Technologies, a Maynard, Mass., maker of high-reliability servers, Reed never lacks for attention at parties and dinners in this employment-starved economy. When she does post a job, she gets four times the volume of responses she got three years ago, and some job seekers even follow up with Christmas cards. If she wanted to, she could fill every opening at a salary 15 percent below the going rate -- as, in fact, many of her competitors do. But that's one advantage Reed won't take. She recently hired an engineer with more than 10 years' experience for nearly six figures -- the same wage she paid at the height of the bubble. Reed isn't just being kind. She asserts that any other course of action is asking for trouble down the road. The buyer's market we're in now is temporary, she warns. Maybe it'll last another year or two. And then? Companies that haven't taken care to build worker loyalty, she says, will find themselves in the same predicament as in 1999 and 2000. At this particular moment in economic history, that is quite a statement. Two million workers have been downsized or displaced since the recession of 2001. At 6.2 percent, the national unemployment rate is the highest it's been in nine years, and the number of new jobless claims has sat above 400,000 for 20 weeks. To base hiring policy today on the prospect of a return to the tight labor market of 1999 seems not just counterintuitive -- it defies the evidence of one's own eyes. But Reed isn't alone. Executives at Cigna (CI), Intel (INTC), SAS, Sprint (PCS), Whirlpool (WHR), WPP (WPPGY), and Adecco (the world's largest placement firm) have told Business 2.0 that they, too, worry that the supply of labor is about to fall seriously short of demand. Former treasury secretary and current Harvard University president Larry Summers regards a skilled labor shortage as all but inevitable. Economists like former Deputy Secretary of Labor Edward Montgomery and Sigurd Nilsen, the director of education, workforce, and income security in the General Accounting Office, have issued warnings to the same effect. And in April the country's largest and most influential industrial trade group, the National Association of Manufacturers (NAM), added its voice to the chorus. The association released a white paper based on research by labor economist Anthony Carnevale, former chairman of President Clinton's National Commission for Employment Policy, that forecast a skilled worker gap that will start to appear the year after next and grow to 5.3 million workers by 2010 and 14 million 10 years later. (Including unskilled workers, the gaps will be 7 million in 2010 and 21 million in 2020.) By comparison, what employers experienced in 1999 and 2000 was a minor irritation, Carnevale says. The shortage won't just be about having to cut an extra shift. It will be about not being able to fill the first and second shift too. This will occur, he adds, without any heroic growth rates or bubblelike economic anomalies; all it will take is a return to the economy's long-term growth rate of 3 to 3.5 percent a year. The cause of the labor squeeze is as simple as it is inexorable: During this decade and the next, the baby boom generation will retire. The largest generation in American history now constitutes about 60 percent of what both employers and economists call the prime-age workforce -- that is, workers between the ages of 25 and 54. The cohorts that follow are just too small to take the boomers' place. The shortage will be most acute among two key groups: managers, who tend to be older and closer to retirement, and skilled workers in high-demand, high-tech jobs. To see the demographic time bomb in microcosm, just count the gray heads around your own office. At Sprint, for example, half of the 6,000 field and network technicians are over 50. At Cigna Systems, about a quarter of the 3,400 IT workers will pass 55 this decade. And at Cary, N.C., software maker SAS, more than a quarter of the staff will be eligible to retire by this decade's end. The company's VP for human resources, Jeff Chambers, says this group is filled with veteran designers and engineers, many of them architects of the company's most successful products. It doesn't take a rocket scientist to see what's going on, he says. Existing staff are going to start getting out soon, and the feeder pool just isn't coming up. If you're responsible for the workforce, you'd better ask
RE: Nature of Oracle-l has changed
Well...I made the transition from development to DBA when we initially got SAP'd (1993) partly because it looked interesting, partly because I was the only one on the development staff who bothered to dig into the technical end of things and...partly because management at the time had this overly optimistic assumption that they wouldn't need programmers after they dumped all the in-house applications and dinosaur software packages. There was also the assumption that client-server systems would require fewer people to support. Hah! Through various mergers, divestments, acquistions, and so on -- neither of these assumptions have proven to be true. The panacea of packaged software may have changed things...but in my experience it has mostly been tool changes. And, OK, I guess it could be argued that my job is more system integrator than traditional DBA now...whatever the heck that is...but this has tended to be my role regardless of title I was given. ;-) Kip Bryant |There is another thing happening: companies are more and more relying on |canned, |off the shelf applications, in a hope to become compliant with present |standards. |That has dramatically cut down the number of needed developers, because if |you don't |have to develop your general ledger, payroll, CRM and HR software, you only |need |IT staffers to monitor production. |That is why I think that Jonathan Lewis is wrong in his Practical |Databases when he talks |about DBA being a repository of knowledge. No, the role of the DBA today |is the one |of a crane operator: just get the darned thing going, buddy. DBA is a |mechanic that |fixes database when it's slow, and that's it. The business role of IT is no |longer |to be at the forefront of the organization, but to keep thins running and do |what |business people tell them to do. Companies are no longer doing development |are leaving |cooking to the cooks and software development to the big software companies. |One of the reasons is also the culture clash among very well educated, |liberal and hippie |computer geeks and somewhat less educated old school drill sergeant type |managers who want |everybody to be at their desks at 7:30, cleanly shaven, no jeans, no surf |naked Dilbert |T-shirts or I am a DMCA circumvention device T-shirts. Basically, what I'm |noticing is |sort of returning to the roots cultural movement where business management |no longer |wants to tolerate the laid back IT culture. When cost cutting decisions are |made, IT people |are the 1st to go. They stil need DBA's because they'd better have somebody |monitoring |their multi-TB databases, but development is no longer necessary. IT |applications |are going to be as standardized as a stapler, so there is less and less need |for development. |Friends, we're dinosaurs, a dying breed. I'm considering a career of a |second |hand car salesman or a real estate agent. |-- |Mladen Gogala |Oracle DBA |-Original Message- |Stephane Paquette |Sent: Friday, August 22, 2003 10:29 AM |To: Multiple recipients of list ORACLE-L |That's why my post on historic tables and views seem lonely ;-) |Stephane |-Original Message- |Jared Still |Sent: Friday, August 22, 2003 2:19 AM |To: Multiple recipients of list ORACLE-L |Has anyone else noticed? |Not so long ago, we saw quite a few more questions about |such things as data modeling, application security architecture, physical |database design, and Oracle Designer |Not so much anymore. |Do you think it's because there are so few development projects taking |place? Seems like in house development died with the dot bomb and has not |begun to recover. |I know at my place of employment there is very little development, but that |is due more to the size and nature of this place, as |well as the management. ( they don't like in house development :( ) |Now I spend my days with stuff like making NetBackup work with Oracle, |migrating SAP all over the place and keeping things running. |Not that we haven't always done those things, but I miss some not having a |good development project. Ah, to do some real |data modeling again. |Just some food for thought. |Jared |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Jared Still | 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: Stephane Paquette | INET: [EMAIL PROTECTED] |Fat City Network
Re: GREAT SCOTT!! 1.21 GIGAWATTS!!
Tanel, A co-location site is a service provider that sells space to companies for their systems so one large physical site could be hosting the servers of dozens and dozens of companies. Picture one really huge computer room filled with rows of cages and each cage houses servers for one company like Ebay, Lycos, etc. Kip | It's situations like this that make me love collocations. We basically | get to be part of a co-op that pays someone else to worry about power, | fire and physical security. |Sorry, I'm not a native english speaker, but what the heck does collocation |mean? |Tanel. |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Tanel Poder | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix root account remote access
I don't know if the following applies to all varieties of unix... Not being able to telnet in directly as root is just default behaviour. This could be changed...but some would say this is a bad idea. There must be someone at the server end with root access. In order for your account to be able to su, your account must be in the system group in /etc/group (on the host or via NIS). Kip |Log into the server with a regular account and execute su - |Supply root's password when prompted. |Allan | -Original Message- | From: M.Godlewski [mailto:[EMAIL PROTECTED] | Sent: Thursday, July 17, 2003 7:10 PM | To: Multiple recipients of list ORACLE-L | Subject: Unix root account remote access | List, | I want to install Oracle on a UNIX system no sys admin on board |yet, so I get to set up the system with the Oracle account etc. |Unfortunately, I can not log into the root account remotely. I get a |non console message. Is there a way to allow remote root connections? | _ | Do you Yahoo!? | The New Yahoo! Search |http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com - |Faster. Easier. Bingo. |__ |This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] Content-type: text/html; charset=us-ascii !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEADTITLEMessage/TITLE META http-equiv=Content-Type content=text/html; charset=us-ascii META content=MSHTML 5.50.4923.2500 name=GENERATOR/HEAD BODY DIVSPAN class=089555212-18072003FONT face=Arial color=#ff size=2Log into the server with a regular account and execute su -/FONT/SPAN/DIV DIVSPAN class=089555212-18072003FONT face=Arial color=#ff size=2Supply root's password when prompted.nbsp; /FONT/SPAN/DIV DIVSPAN class=089555212-18072003FONT face=Arial color=#ff size=2/FONT/SPANnbsp;/DIV DIVSPAN class=089555212-18072003FONT face=Arial color=#ff size=2Allan/FONT/SPAN/DIV BLOCKQUOTE style=MARGIN-RIGHT: 0px DIV/DIV DIV class=OutlookMessageHeader lang=en-us dir=ltr align=leftFONT face=Tahoma size=2-Original Message-BRBFrom:/B M.Godlewski [mailto:[EMAIL PROTECTED] BRBSent:/B Thursday, July 17, 2003 7:10 PMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B Unix root account remote accessBRBR/FONT/DIV DIVList,/DIV DIVnbsp;/DIV DIVI want to install Oracle on a UNIX system no sys admin on board yet, so I get to set up the system with the Oracle account etc.nbsp; Unfortunately, I can not log into the root account remotely.nbsp; I get a non console message.nbsp; Is there a way to allow remote root connections?/DIV DIVnbsp;/DIV DIVnbsp;/DIV P HR SIZE=1 Do you Yahoo!?BRA href=http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com;The New Yahoo! Search/A - Faster. Easier. Bingo./BLOCKQUOTE/BODY/HTML P__br This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]br /P -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why does it take so long to write archive logs
Hi Patrice, I would never use NFS for the primary archive logs. I was only thinking about the second optional destination (LOG_ARCHIVE_DEST_2). I don't think 7.3 supported being able to write archive logs to multiple destinations. I'm running 8.1.7.4. Kip |I don't know about 9i, but in 7.3 Oracle Support told me they don't certify |or support setups where archived logs are written to NFS mounts if you are |using NFS bundled into the UNIX OS. |I asked which OS... they said every one, including Digital, HP and Sun. |They said that if I insisted on using NFS mounts, I had to use a |connection-based NFS from a 3rd party vendor, which means more $$ to spend. |So we do not use NFS mounts for archived logs. |: ) |Patrice. |-Original Message- |Sent: Monday, July 07, 2003 10:14 PM |To: Multiple recipients of list ORACLE-L |Hi John, |Were you also using optional on the secondary, nfs mounted destination? |Did your DB eventually grind to a stop waiting for the secondary to complete |(I'm assuming yes)? I'm considering this sort of thing for a DR setup to |eliminate the traffic jam effect that might be caused by an ftp script run |through cron. This is for an outsourced DR solution with no standby DB. |I |managed to talk them into an archive collecter server at the outsourcer. |I've seen problems with WAN (even LAN) NFS mounts where the file is complete |but apears locked by another process on the hosting server (VMS)... I've |always assumed bandwidth but I wonder whether a busy server could cause |something similar... |Kip Bryant ||I had a similar problem on 9.2 and, just as you describe, I could watch the ||file on the remote location and the byte count would show the whole file ||was there but the alert log file would not show the archive complete for ||as long an one hour. When it did finally complete, the byte count on the ||remote file did not change. I worked with Oracle for several month before ||they finally convinced me it was a network problem. I do not really know ||anything about networks so I cannot really help you but our Unix admin guys ||made some changes in the network and the problem went away. Sorry, I ||cannot give you more info because we were also in the process of changing ||out a lot of hardware including network hardware so there is no magic ||parameter I can tell you to change. Just talk to your network gurus and ||hopefully, they can figure it out. ||HTH, ||John ||-Original Message- ||Sent: Monday, July 07, 2003 3:34 PM ||To: Multiple recipients of list ORACLE-L ||Hello everyone, ||We have an 8.1.7.4 on HP-UX 11.0 OPS database that uses 200mb archive logs ||with 3 archive log destinations, the first destination is local to the ||machine which is mandatory, the second destination is a filesystem ||accessible via nfs which is optional and the third destination is a remote ||standby database accessible via a vpn which is also optional. We have 10 ||archive processes to take care of the writing of the archives. Both the ||local destination and nfs mounted filesystems are on a HP XP256 storage ||device. ||This morning there was a process running that would update a table that is ||used for a catalog of parts. The process was producing archive logs, but |the ||archives were taking around 10 minutes to write. During the process we |would ||see the file created with the expected byte count of the file within the ||first minute, but the timestamp of the file would indicate access for the ||next ten minutes. ||We have two other 8.1.7 databases that are setup in a similar manner (that ||are not OPS) that have 2 destinations, one local and the other being sent |to ||a remote standy database. We are not seeing the same type of issue with the ||archive logs. ||Can someone point me in the direction of either information or advice about ||why the archives may be taking so long to write? ||Is it that we have 3 destinations and it waits until all 3 destinations are ||taken care of? ||Why does the archive log file appear to be modified even though the byte ||count hasn't changed? ||TIA, ||Bryan Rodrigues ||Elcom, Inc. ||Oracle DBA ||-- ||Please see the official ORACLE-L FAQ: http://www.orafaq.net ||-- ||Author: Rodrigues, Bryan || 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: John Carlson || INET: [EMAIL PROTECTED] ||Fat City Network Services
RE: Why does it take so long to write archive logs
|Oracle says it is not their problem. They are waiting for the confirmation |that the file is written. It is written just like any sequential file. It |does not pre-allocate and then load the data. |Yes, the database would stop after it had rolled through all log groups and |could not continue until the oldest one finished archiving. We would see |where other logs would archive just fine while one was taking forever. We |have 8 log groups. So, for example, it would archive 1,2,and 3 then 4 would |just sit there while it archived 5,6,7,8,1,2,3 and then the db would hang. |It has taken over an hour for it to free up sometimes. This happened where |the two machines were sitting side by side with a GigE connection between |them writing to local disks as well as to a remote machine with a NetApp |storage connection. It didn't seem to matter what the device was, just that |it was archiving to another machine. As a work around, we turned off |automatic archiving and used scripts to copy the archive logs. And yes, we |had them set as optional and I believe that is why it let us continue to use |up the other logs but once it wrapped around it could not continue. Even with optional? Arrrggh! Guess I'm not reading the documentation correctly (LOG_ARCHIVE_DEST_N and LOG_ARCHIVE_MIN_SUCCEED_DEST default 1) or perhaps it just hasn't actually failed by taking too long... hmmm... Kip |John |-Original Message- |Sent: Tuesday, July 08, 2003 10:25 AM |To: Multiple recipients of list ORACLE-L |John, |Did Oracle give you any idea as to what Oracle was doing to the archive log |files, while it was waiting for the hardware/network issues to be resolved? |I understand that the redo log information is written the archive log file, |but does Oracle create a file with the correct size allocated and then put |the information into it or does it create the file, write all the |information into it and then update a byte within the file with a check |digit to ensure the file is complete? |TIA, |Bryan |-Original Message- |Sent: Monday, July 07, 2003 7:34 PM |To: Multiple recipients of list ORACLE-L |I had a similar problem on 9.2 and, just as you describe, I could watch the |file on the remote location and the byte count would show the whole file was |there but the alert log file would not show the archive complete for as long |an one hour. When it did finally complete, the byte count on the remote |file did not change. I worked with Oracle for several month before they |finally convinced me it was a network problem. I do not really know |anything about networks so I cannot really help you but our Unix admin guys |made some changes in the network and the problem went away. Sorry, I cannot |give you more info because we were also in the process of changing out a lot |of hardware including network hardware so there is no magic parameter I can |tell you to change. Just talk to your network gurus and hopefully, they can |figure it out. |HTH, |John |-Original Message- |Sent: Monday, July 07, 2003 3:34 PM |To: Multiple recipients of list ORACLE-L |Hello everyone, |We have an 8.1.7.4 on HP-UX 11.0 OPS database that uses 200mb archive logs |with 3 archive log destinations, the first destination is local to the |machine which is mandatory, the second destination is a filesystem |accessible via nfs which is optional and the third destination is a remote |standby database accessible via a vpn which is also optional. We have 10 |archive processes to take care of the writing of the archives. Both the |local destination and nfs mounted filesystems are on a HP XP256 storage |device. |This morning there was a process running that would update a table that is |used for a catalog of parts. The process was producing archive logs, but the |archives were taking around 10 minutes to write. During the process we would |see the file created with the expected byte count of the file within the |first minute, but the timestamp of the file would indicate access for the |next ten minutes. |We have two other 8.1.7 databases that are setup in a similar manner (that |are not OPS) that have 2 destinations, one local and the other being sent to |a remote standy database. We are not seeing the same type of issue with the |archive logs. |Can someone point me in the direction of either information or advice about |why the archives may be taking so long to write? |Is it that we have 3 destinations and it waits until all 3 destinations are |taken care of? |Why does the archive log file appear to be modified even though the byte |count hasn't changed? |TIA, |Bryan Rodrigues |Elcom, Inc. |Oracle DBA |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Rodrigues, Bryan | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services
RE: Why does it take so long to write archive logs
Hi John, Were you also using optional on the secondary, nfs mounted destination? Did your DB eventually grind to a stop waiting for the secondary to complete (I'm assuming yes)? I'm considering this sort of thing for a DR setup to eliminate the traffic jam effect that might be caused by an ftp script run through cron. This is for an outsourced DR solution with no standby DB. I managed to talk them into an archive collecter server at the outsourcer. I've seen problems with WAN (even LAN) NFS mounts where the file is complete but apears locked by another process on the hosting server (VMS)... I've always assumed bandwidth but I wonder whether a busy server could cause something similar... Kip Bryant |I had a similar problem on 9.2 and, just as you describe, I could watch the |file on the remote location and the byte count would show the whole file |was there but the alert log file would not show the archive complete for |as long an one hour. When it did finally complete, the byte count on the |remote file did not change. I worked with Oracle for several month before |they finally convinced me it was a network problem. I do not really know |anything about networks so I cannot really help you but our Unix admin guys |made some changes in the network and the problem went away. Sorry, I |cannot give you more info because we were also in the process of changing |out a lot of hardware including network hardware so there is no magic |parameter I can tell you to change. Just talk to your network gurus and |hopefully, they can figure it out. |HTH, |John |-Original Message- |Sent: Monday, July 07, 2003 3:34 PM |To: Multiple recipients of list ORACLE-L |Hello everyone, |We have an 8.1.7.4 on HP-UX 11.0 OPS database that uses 200mb archive logs |with 3 archive log destinations, the first destination is local to the |machine which is mandatory, the second destination is a filesystem |accessible via nfs which is optional and the third destination is a remote |standby database accessible via a vpn which is also optional. We have 10 |archive processes to take care of the writing of the archives. Both the |local destination and nfs mounted filesystems are on a HP XP256 storage |device. |This morning there was a process running that would update a table that is |used for a catalog of parts. The process was producing archive logs, but the |archives were taking around 10 minutes to write. During the process we would |see the file created with the expected byte count of the file within the |first minute, but the timestamp of the file would indicate access for the |next ten minutes. |We have two other 8.1.7 databases that are setup in a similar manner (that |are not OPS) that have 2 destinations, one local and the other being sent to |a remote standy database. We are not seeing the same type of issue with the |archive logs. |Can someone point me in the direction of either information or advice about |why the archives may be taking so long to write? |Is it that we have 3 destinations and it waits until all 3 destinations are |taken care of? |Why does the archive log file appear to be modified even though the byte |count hasn't changed? |TIA, |Bryan Rodrigues |Elcom, Inc. |Oracle DBA |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Rodrigues, Bryan | 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: John Carlson | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED
RE: SAP Hands SAP DB over to MySQL
Everybody is under cost pressures these days, right? Recently my boss required that I attend a few webinars hosted by Microsoft to hear their line on TCO because he didn't want the choice of our next platform to be a technical decision (we're on Tru64 unix). I don't think I'll be encouraged to consider MySQL, postgre sql, linux, etc anytime soon for mission critical apps but who knows? SAP has been sparring with Oracle for at least the past 10 years. SAP's success has helped Oracle sell their product which I guess is irksome to SAP since they see Oracle as a competitor. At one point, SAP was encouraging new customers to select Informix. Now it seems to be DB2 and/or SAP DB... At sapteched this year, their analysis of the database market was that it was at a point where features had become a commodity but commodity pricing hadn't happened yet...but that it would. They were calling Oracle/IBM/Microsoft the dominant options and then comparing them with SAP DB. I don't recall any talk about MySQL, postgresql... Kip |Okay, I've got a question for you people knowledgeable in SAP. Who would |trust their financial and payroll data to MySQL? I'm not saying this to |knock MySQL. It is just that your financial and payroll data is among your |most valuable data in the corporation. Only recently was a transaction |capability added to MySQL, and that was more of an add-on. I manage |several databases and my company even makes modest use of MySQL. But of |those databases, the financial and payroll data would be the LAST database I |would convert to something like MySQL. I'm just curious what is the big |incentive in MySQL is. |Dennis Williams |DBA, 80%OCP, 100% DBA |Lifetouch, Inc. |[EMAIL PROTECTED] |-Original Message- |Sent: Wednesday, May 28, 2003 5:50 PM |To: Multiple recipients of list ORACLE-L |Maybe it is just so they can continue to say they're not a database |company |(insert sound of condescension) to emphasize their focus on applications |excellence in the veiled jabs they continue to make at Oracle. On the |other |hand, I can't imagine they would give up development control because they do |make a specialized version of SAP DB for object oriented programming |(they say they couldn't find a product that worked correctly...). |Kip ||I dunno. Though both want to make a profit ( and rightly so ) SAP ||doesn't seem to have the same mercenary mentality that MS has. ||Jared ||Orr, Steve [EMAIL PROTECTED] ||Sent by: [EMAIL PROTECTED] || 05/28/2003 11:52 AM || Please respond to ORACLE-L ||To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ||cc: ||Subject:RE: SAP Hands SAP DB over to MySQL ||Reminiscent of the M$/Sybase partnership? ||-Original Message- ||Sent: Wednesday, May 28, 2003 11:40 AM ||To: '[EMAIL PROTECTED]' ||At http://www.sapdb.org/7.4/pdf/sapdb_letter.pdf SAP offers |clarification: ||SAP: ||Contrary to erroneous press reports, SAP AG has not given up any rights ||concerning the SAP DB code base nor handed over or even sold SAP DB to ||MySQL AB. ||SAP: ||SAP AG remains responsible for ongoing development and support. ||CNet: ||MySQL will take over most of the development of SAP DB. ||-Original Message- ||Sent: Wednesday, May 28, 2003 12:01 PM ||To: Multiple recipients of list ORACLE-L ||Importance: High ||The past few months I've been wondering when MySQL would start ||putting pressure on Oracle in the same way that Linux is putting ||pressure on MS. ||Maybe sooner than you think: ||http://news.com.com/2100-1012_3-1010522.html?tag=fd_top ||Jared ||-- ||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: Orr, Steve || INET: [EMAIL PROTECTED] ||Fat City Network Services-- 858-538-5051 http://www.fatcity.com ||San Diego, California-- Mailing list and web hosting services ||- ||To REMOVE yourself from this mailing list, send an E-Mail message ||to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in ||the message BODY, include a line containing: UNSUB ORACLE-L ||(or the name of mailing list you want to be removed from). You may ||also send the HELP command for other information (like subscribing). ||-- ||Please see
RE: SAP Hands SAP DB over to MySQL
Patrice, No argument but I report to the applications side instead of the technical side these days and where the budget comes from is murkily out of both sides. My boss doesn't really have insight into how a change in platform would impact me and my staff or the technical group I work closely with. Kip |They don't want the choice to hardware, OS and software to be a technical |decision? |Why not? TCO is part of technical decision-making, is it not? |Sometimes they decide before input from below then try to force a solution |on the tech people. |In that kind of world, the firm which is best at marketing to non-technical |people wins. |Patrice. |-Original Message- |Sent: Thursday, May 29, 2003 2:25 PM |To: Multiple recipients of list ORACLE-L |Everybody is under cost pressures these days, right? Recently my boss |required |that I attend a few webinars hosted by Microsoft to hear their line on TCO |because he didn't want the choice of our next platform to be a technical |decision (we're on Tru64 unix). I don't think I'll be encouraged to |consider |MySQL, postgre sql, linux, etc anytime soon for mission critical apps but |who |knows? |SAP has been sparring with Oracle for at least the past 10 years. SAP's |success has helped Oracle sell their product which I guess is irksome to SAP |since they see Oracle as a competitor. At one point, SAP was encouraging |new |customers to select Informix. Now it seems to be DB2 and/or SAP DB... At |sapteched this year, their analysis of the database market was that it was |at |a point where features had become a commodity but commodity pricing hadn't |happened yet...but that it would. They were calling Oracle/IBM/Microsoft |the |dominant options and then comparing them with SAP DB. I don't recall any |talk |about MySQL, postgresql... |Kip ||Okay, I've got a question for you people knowledgeable in SAP. Who would ||trust their financial and payroll data to MySQL? I'm not saying this to ||knock MySQL. It is just that your financial and payroll data is among your ||most valuable data in the corporation. Only recently was a transaction ||capability added to MySQL, and that was more of an add-on. I manage ||several databases and my company even makes modest use of MySQL. But of ||those databases, the financial and payroll data would be the LAST database |I ||would convert to something like MySQL. I'm just curious what is the big ||incentive in MySQL is. ||Dennis Williams ||DBA, 80%OCP, 100% DBA ||Lifetouch, Inc. ||[EMAIL PROTECTED] |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SAP Hands SAP DB over to MySQL
Maybe it is just so they can continue to say they're not a database company (insert sound of condescension) to emphasize their focus on applications excellence in the veiled jabs they continue to make at Oracle. On the other hand, I can't imagine they would give up development control because they do make a specialized version of SAP DB for object oriented programming (they say they couldn't find a product that worked correctly...). Kip |I dunno. Though both want to make a profit ( and rightly so ) SAP |doesn't seem to have the same mercenary mentality that MS has. |Jared |Orr, Steve [EMAIL PROTECTED] |Sent by: [EMAIL PROTECTED] | 05/28/2003 11:52 AM | Please respond to ORACLE-L |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |cc: |Subject:RE: SAP Hands SAP DB over to MySQL |Reminiscent of the M$/Sybase partnership? |-Original Message- |Sent: Wednesday, May 28, 2003 11:40 AM |To: '[EMAIL PROTECTED]' |At http://www.sapdb.org/7.4/pdf/sapdb_letter.pdf SAP offers clarification: |SAP: |Contrary to erroneous press reports, SAP AG has not given up any rights |concerning the SAP DB code base nor handed over or even sold SAP DB to |MySQL AB. |SAP: |SAP AG remains responsible for ongoing development and support. |CNet: |MySQL will take over most of the development of SAP DB. |-Original Message- |Sent: Wednesday, May 28, 2003 12:01 PM |To: Multiple recipients of list ORACLE-L |Importance: High |The past few months I've been wondering when MySQL would start |putting pressure on Oracle in the same way that Linux is putting |pressure on MS. |Maybe sooner than you think: |http://news.com.com/2100-1012_3-1010522.html?tag=fd_top |Jared |-- |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: Orr, Steve | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). |-- |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: 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: TNS name lookup failure with SAP
---BeginMessage--- Hi Russ, When you run R3trans -d, it creates a trans.log file in the current directory. This will help you debug this. Errors in that log file can be used to look up possible problems in SAP's OSS. On the app server I assume you've edited the .dbenv hidden files and are setting the correct environment. Are services set up correctly? What does listener.ora look like? Are you sure it is able to find tnsnames.ora? Kip Bryant |Help! |I ftp'ed the oracle client libraries from one system to another, with a |totally different SID. I renamed and edited all the profiles for the user |ID's, but the client software cannot seem to communicate with the server. |The error messages appear to indicate a TNS name lookup failure, but |everything looks right to me. Can anyone spot the problem? | This is unfortunately an SAP install, so TNSPING is not available. ...meaning Oracle stuff is not mounted so you can't run svrmgrl, sqlplus, tnsping? What about ../network/admin for tnsnames.ora? |The R3trans -d fails with a no connect possible |SQLNET.LOG | |Fatal NI connect error 12545, connecting to: | (DESCRIPTION=(SDU=32768)(CONNECT_DATA=(SID=QA1)(GLOBAL_NAME=QA1.WORLD) |(CID=(PROGRAM=)(HOST=sapdv1)(USER=qa1adm))) |(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=QA1.WORLD)) |(ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=sapqa1)(PORT=1527 | VERSION INFORMATION: |TNS for HPUX: Version 8.0.5.0.0 - Production |Unix Domain Socket IPC NT Protocol Adaptor for HPUX: Version |8.0.5.0.0 - | Production | Time: 29-JAN-03 20:27:38 | Tracing not turned on. | Tns error struct: |nr err code: 12206 |TNS-12206: Message 12206 not found; No message file for product=NETWORK, |facility=TNS |ns main err code: 12545 |TNS-12545: Message 12545 not found; No message file for product=NETWORK, |facility=TNS |ns secondary err code: 12560 |nt main err code: 515 |TNS-00515: Message 515 not found; No message file for product=NETWORK, |facility=TNS |nt secondary err code: 216 |nt OS err code: 0 |TNSNAMES.ORA on server |*** |extproc_connection_data = | (DESCRIPTION = |(ADDRESS = (PROTOCOL = IPC)(KEY = oracle_sid)) |(CONNECT_DATA = (SID = extproc)) | ) |oracle_sid = | (DESCRIPTION = |(ADDRESS = (PROTOCOL= TCP)(Host= sapqa1)(Port= 1521)) |(CONNECT_DATA = (SID = oracle_sid)) | ) |QA1.WORLD= | (DESCRIPTION = |(SDU = 32768) |(ADDRESS_LIST = |(ADDRESS = | (COMMUNITY = SAP.WORLD) | (PROTOCOL = TCP) | (HOST = sapqa1) | (PORT = 1527) |) |) |(CONNECT_DATA = | (SID = QA1) | (GLOBAL_NAME = QA1.WORLD) |) | ) |TNSNAMES.ORA on client machine |*** |QA1.WORLD= | (DESCRIPTION = |(SDU = 32768) |(ADDRESS_LIST = |(ADDRESS = | (COMMUNITY = SAP.WORLD) | (PROTOCOL = TCP) | (HOST = sapqa1) | (PORT = 1527) |) |) |(CONNECT_DATA = | (SID = QA1) | (GLOBAL_NAME = QA1.WORLD) |) | ) -- 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). ---End Message---
RE: Take Care of your DBAs
Montana is a bit of a drive from California but where do I sign up? If you add mountain biking, my sons would come along... Kip Bryant |Although I might resemble that remark, I still welcome the opportunity to |take fellow DBA's on a hike/hunt/fish expedition in Big Sky country. But you |have to bring your own pepper spray and bear bells |Rick Weiss |-Original Message- |Sent: Wednesday, January 29, 2003 3:30 PM |To: Multiple recipients of list ORACLE-L |Lisa - Some of us became DBAs because we realized we would never be able to |feed our families on our physical abilities. |Dennis Williams |DBA, 40%OCP |Lifetouch, Inc. |[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] |-Original Message- |Sent: Wednesday, January 29, 2003 3:55 PM |To: Multiple recipients of list ORACLE-L |I used to play Ping Pong with the sysadmins and the app architect... aahh, |the glory dotcom days when I could bring my dog to work :) |Most of the dba's I have met are not into physical activity and exercise. |-Original Message- |mailto:[EMAIL PROTECTED] ] |Sent: Wednesday, January 29, 2003 2:49 PM |To: Multiple recipients of list ORACLE-L |shooting hoops? Just out of curiosity, how many people on the list have a |group of DBAs at their company that they shoot hoops with? |Some good points, some odd ones. I'll echo Patrice's sigh (as someone who |enjoys both parts of the job). |Jay |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Weiss, Rick | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Important - Oracle Pricing on Standby/DR/Failover databases
Hi, I've missed some of this thread so apologies if this has been touched on already. The info-from-Oracle below refers to Backup/Failover/Standby. Backup : We're OK. Failover: Hmm. Tru64 cluster. Think we're OK based on what I read... Standby : I was shot down on this one because the DR site that would have been used has political problems with corporate plus there was the perception that ongoing costs would be too high to warrant it. Long story so I'll stop... Which leads me to my question: what if DR is to be at Sungard or IBM or elsewhere and the recovery system won't actually exist (ie: this is not a standby solution) until there is a disaster or when the recovery process is being tested. BTW they are assuming 1 day to reconstruct production (I think this is incredibly optimistic). Maybe the stuff below is clear to others but...does my company have a licensing issue with this direction that they don't know about? Kip Bryant |Tony, |Good to see your fingerprints here! |I had always gone on the theory that I would need at least two of the |licenses, one for production and one for the standby server. I hadn't |thought about one for the DR site, on the theory, that since DR was up |and running ONLY when production was not, it was the same software. I |had had that information from my Oracle sales reps as well. |Now it seems I'll have to go back to my IT operations people and have |them verify that we are in compliance with the licensing. Or that they |are ready to fight it. We do have an overall company license (Sony is a |fairly large user) so I don't know how that affects our licensing as |well. |I hadn't realized that as an Oracle DBA I also had to be a lawyer! |Rachel |--- [EMAIL PROTECTED] wrote: | Hi All | | For those sites with either a standby, DR or failover database, | the following information is very important to you. You could be in | breach of Oracle's Licensing agreement and could cost you $100,000s | if not millions $$ | | (Read the summary at the end if you want to skip the details) | | In the last issue of Select, I wrote that with Oracle's new | Failover policy you now need not purchase two sets of Oracle licences | (one for the production server and the other for the Standby server) | if the standby server was not activated for more than 10 days in a | calender year. | | This was based on the following information I received | FAILOVER POLICY | | Oracle recognizes that customers may require very infrequent and | limited use | of their failover server. To address this use, we are modifying the | current | failover policy, which currently requires a full use of the Database | on any | failover server. Effective today, Oracle allows Oracle Database | licensed | users to load the database in main memory on an unlicensed spare | computer | for up to a total of ten separate days in any given calendar year. | Any use | beyond the right granted in the previous sentence must be licensed | separately. | | | | | | So, in this instance if you have DataGuard, it implies that | failing over to the 2nd box while the primary is down is OK | with one license. Right? WRONG. | | Since the article, Oracle has come out with more clarifications | as a lot of people were querying about the definitions and | legalities. | | The confusion is with the definition of STANDBY vs FAILOVER. | | Here is an extract of a correspondence from Oracle: | There have been a number of changes recently to our policies and | licencing requirements for backup/standby databases. This email is | to clarify the new policies. | | The following is on page 19 of the current Software Investment Guide, | which can be downloaded from eSource and oracle.com: | | Backup/Failover/Standby - Oracle differentiates between 3 methods of | database recovery: | Backup - In this type of recovery, database files of the primary | database are stored on tape media. In this type of environment, | Oracle permits customers to store a back up copy of the database data | on storage devices, such as tapes, without purchasing additional | licenses. | Failover - In this type of recovery, nodes are configured in | cluster; the first installed node acts as a primary node. If the | primary node fails, one of the nodes in the cluster acts as the | primary node. In this type of environment, Oracle permits licensed | Oracle Database customers to run the Database on an unlicensed spare | computer for up to a total of ten separate days in any given calendar | year. Any other use requires the environment to be fully licensed. | Additionally, the same metric must be used when licensing the | databases in a failover nvironment. | Standby - In this type of recovery, a copy of the primary database is | maintained on a separate server at all times. These systems are | configured for disaster recovery purposes. If the primary database | fails, the standby database is activated to act as the new primary
RE: Important - Oracle Pricing on Standby/DR/Failover databases
Hi Tom, Contracts not signed but I believe there is a proposal that has an allowance for 8 or 10 hours of testing beyond the restore time with extra charges for running longer. Oh, and I did manage to get them to include a place to collect archived redo logs (which were originally going to be collected at that out-of-favor datacenter I'm stationed at). Sounds like I need to avoid any solution that might require any Oracle software for this at the DR end. As far as how long we would need to run at the DR site...hmmm...working with that 10 day number and guessing that it would take a really major hit on the corporate datacenter (meaning massive physical damage) to move all services to the DR site... My WAG at this would be 1 to 3 days to build up the environment at the DR site and a minimum of a week to get the corporate datacenter running again. And this is really optimistic since the plan has the corporate technical staff at the DR site getting things going. So in reality there could easily be a weeks delay before anyone (outside their VAR) is onsite picking up the pieces. So I think we would easily go beyond that 10 day number. This is just speculation at this point... Kip PS: I think we all know about accepting free legal advice. I think your point is well taken, though. I've been told that there is some statistic that says the likelihood that you would use a DR site is very, very small. You not use it for just any ol' hiccup. |Kip, |in your situation (as I understand it), I think would fall into the |following scenario: |Don't ask and don't tell. |clearly, you are not intending on running your production system at your |data recovery site. your intent is to use the site to (as you said): test |recovery to make sure it can work - and - when necessary, use it to rebuild |your database. (how long would the database run on this site until you can |rebuild your server?) |now, back to my Don't ask and don't tell. |if you ask Oracle if you need a license - can we all guess what they will |say? |Of *course* you should pay us for this. |but realistically, I wouldn't even tell them about it because your intent is |not to defraud them out of money. |listen to me providing legal advice! I am not a lawyer, but I play one on |TV. |hope this helps. |Tom Mercadante |Oracle Certified Professional |-Original Message- |Sent: Thursday, January 16, 2003 12:40 PM |To: Multiple recipients of list ORACLE-L |Hi, |I've missed some of this thread so apologies if this has been touched on |already. The info-from-Oracle below refers to Backup/Failover/Standby. |Backup : We're OK. |Failover: Hmm. Tru64 cluster. Think we're OK based on what I read... |Standby : I was shot down on this one because the DR site that would have | been used has political problems with corporate plus there was |the | perception that ongoing costs would be too high to warrant it. | Long story so I'll stop... |Which leads me to my question: what if DR is to be at Sungard or IBM or |elsewhere and the recovery system won't actually exist (ie: this is not a |standby solution) until there is a disaster or when the recovery process is |being tested. BTW they are assuming 1 day to reconstruct production (I |think |this is incredibly optimistic). Maybe the stuff below is clear to others |but...does my company have a licensing issue with this direction that they |don't know about? |Kip Bryant ||Tony, ||Good to see your fingerprints here! ||I had always gone on the theory that I would need at least two of the ||licenses, one for production and one for the standby server. I hadn't ||thought about one for the DR site, on the theory, that since DR was up ||and running ONLY when production was not, it was the same software. I ||had had that information from my Oracle sales reps as well. ||Now it seems I'll have to go back to my IT operations people and have ||them verify that we are in compliance with the licensing. Or that they ||are ready to fight it. We do have an overall company license (Sony is a ||fairly large user) so I don't know how that affects our licensing as ||well. ||I hadn't realized that as an Oracle DBA I also had to be a lawyer! ||Rachel ||--- [EMAIL PROTECTED] wrote: || Hi All || || For those sites with either a standby, DR or failover database, || the following information is very important to you. You could be in || breach of Oracle's Licensing agreement and could cost you $100,000s || if not millions $$ || || (Read the summary at the end if you want to skip the details) || || In the last issue of Select, I wrote that with Oracle's new || Failover policy you now need not purchase two sets of Oracle licences || (one for the production server and the other for the Standby server) || if the standby server was not activated for more than 10 days in a || calender year. || || This was based on the following information I received || FAILOVER POLICY
RE: Orawomen
I can relate to this. I have two sons and both have told me that based on what my work life seems like they would never pursue an IT career. Things could change over time, of course, as the reality of making a living sets in. My undergraduate and graduate degrees have absolutely nothing to do with computers or anything remotely technical and yet here I am with decades of computer work experience. And, by the way, even as a male I was never encouraged in High School to pursue a profession. So far as I can tell they didn't see much potential in me. It irks my English teacher wife no end that I earn almost twice what she does...and she was the one with exceptional grades and lots of encouragement. Not bragging. I think she's worth a lot more than what she's paid. Kip |Just asking .. I'm told that the number of Americans (by which I mean kids |born in the States) entering technical fields of all types is declining. |Could the decline of the number of women in IT entering IT be a part of that |trend? |For that matter, I wasn't really called on much in school (and glad for it, |I wasn't usually paying attention), nor did my teachers encourage me that I |can recall for anything in particular. Yet, here I am, earning a living |doing computer stuff. |If 'girls' (or boys, see para 1) aren't encouraged in technical matters, |perhaps it's a problem beyond the scope of an overworked and underpaid |teachers? Please note, I speak as a father of six and the husband of an |(former) educator. |~brian |-Original Message- |Sent: Wednesday, January 08, 2003 7:39 AM |To: Multiple recipients of list ORACLE-L |I think that within the population of women in IT, the number of female |Oracle DBAs is increasing. However, in general, the number of women |entering IT is decreasing. That is, the number of women who are |encouraged to become DBAs or developers or network admins or sys admins |is decreasing. |I've noticed (I have a friend with a 13 year old son and a 16 year old |daughter) that the schools are not encouraging girls to go into science |or math. There have been studies done that show that teachers in those |fields tend to call on the girls in the class less and spend less time |helping them understand the subjects. |My opinion only |Rachel |--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: | Recently this list had a discussion of female Oracle DBAs. The | consensus was | that the numbers were increasing, which I view as a good thing. Here | is an | article with industry statistics saying that the number of women in | IT is | decreasing. | http://itmanagement.earthweb.com/career/article.php/1564501 | Any theories? | | Dennis Williams | DBA, 40%OCP | Lifetouch, Inc. | [EMAIL PROTECTED] | -- | Please see the official ORACLE-L FAQ: http://www.orafaq.net | -- | Author: DENNIS WILLIAMS | INET: [EMAIL PROTECTED] |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Brian Dunbar | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Orawomen
Don't get me wrong. I never said anything about it being harder than any other way of making a living. They, being kids, just see the early AM calls or calls on holidays and so on and say no way. My own father-in-law who worked for IBM for 25+ years couldn't understand why I would get a call on a Sunday when having dinner at his house (Can't it wait until Monday??). Kip |Agreed. |Igor Neyman, OCP DBA |[EMAIL PROTECTED] |- Original Message - |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |Sent: Wednesday, January 08, 2003 2:08 PM | I'm curious. Does everyone here think the IT profession is hard? Does | everyone think that being a DBA is harder than say, a teacher, or a sales | clerk, or something else? | | I don't understand the attitude. Or maybe I'm just lucky. The IT field |is | wide-open for everyobe to find a niche where they are comfortable. | | And it is certainly a better field than nursing (hours, pay and exposure |to | multyitude of diseases suck!), teaching (while working with most kids |would | be fun, the pay is tough and the hard-luck kids are tougher), retail |(wanna | work in Home-Depot?). | | While some damagement is tough to work with, I think the field is | interested, challenging and always interesting. And the pay is better |than | most. | | Tom Mercadante | Oracle Certified Professional | | | -Original Message- | Sent: Wednesday, January 08, 2003 12:27 PM | To: Multiple recipients of list ORACLE-L | | | I can relate to this. I have two sons and both have told me that based on | what | my work life seems like they would never pursue an IT career. Things |could | change over time, of course, as the reality of making a living sets in. |My | undergraduate and graduate degrees have absolutely nothing to do with | computers or anything remotely technical and yet here I am with decades of | computer work experience. | | And, by the way, even as a male I was never encouraged in High School to | pursue | a profession. So far as I can tell they didn't see much potential in me. | It | irks my English teacher wife no end that I earn almost twice what she | does...and she was the one with exceptional grades and lots of | encouragement. | Not bragging. I think she's worth a lot more than what she's paid. | | Kip | | |Just asking .. I'm told that the number of Americans (by which I mean | kids | |born in the States) entering technical fields of all types is declining. | |Could the decline of the number of women in IT entering IT be a part of | that | |trend? | | |For that matter, I wasn't really called on much in school (and glad for |it, | |I wasn't usually paying attention), nor did my teachers encourage me that |I | |can recall for anything in particular. Yet, here I am, earning a living | |doing computer stuff. | | |If 'girls' (or boys, see para 1) aren't encouraged in technical matters, | |perhaps it's a problem beyond the scope of an overworked and underpaid | |teachers? Please note, I speak as a father of six and the husband of an | |(former) educator. | | |~brian | | | |-Original Message- | |Sent: Wednesday, January 08, 2003 7:39 AM | |To: Multiple recipients of list ORACLE-L | | | |I think that within the population of women in IT, the number of female | |Oracle DBAs is increasing. However, in general, the number of women | |entering IT is decreasing. That is, the number of women who are | |encouraged to become DBAs or developers or network admins or sys admins | |is decreasing. | | |I've noticed (I have a friend with a 13 year old son and a 16 year old | |daughter) that the schools are not encouraging girls to go into science | |or math. There have been studies done that show that teachers in those | |fields tend to call on the girls in the class less and spend less time | |helping them understand the subjects. | | |My opinion only | | |Rachel | | |--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: | | Recently this list had a discussion of female Oracle DBAs. The | | consensus was | | that the numbers were increasing, which I view as a good thing. Here | | is an | | article with industry statistics saying that the number of women in | | IT is | | decreasing. | | http://itmanagement.earthweb.com/career/article.php/1564501 | | Any theories? | | | | Dennis Williams | | DBA, 40%OCP | | Lifetouch, Inc. | | [EMAIL PROTECTED] | | -- | | Please see the official ORACLE-L FAQ: http://www.orafaq.net | | -- | | Author: DENNIS WILLIAMS | | INET: [EMAIL PROTECTED] | |-- | |Please see the official ORACLE-L FAQ: http://www.orafaq.net | |-- | |Author: Brian Dunbar | | 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 |
Away on a trip
This is an automatic reply message from Kip Bryant. I am on plant shutdown and will not be actively checking my email from December 21 until January 6th, 2003. I will be checking my mail sporadically. If you need a quick response to your email before January 6th, please get in touch with Shashi Thadaka or John Pham, who will either be able to answer your question directly, or will get you in touch with the proper person. If you send more email to me, you will not receive another automatic reply. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Something that might be of use
| -Original Message- | GUI's are evil. | | Sure, blinking LEDs are much more better. | |Especially when the admins are epileptic. Hopefully none of us are looking for the Andromeda strain... |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Stephen Lee | 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).
Away on a trip
This is an automatic reply message from Kip Bryant. I am attending a conference in New Orleans and will not be checking my email from Nov 9 until Nov 18. If you need a response to your email before Nov 18, please get in touch with Shashi Thadaka, John Pham or Roland Davies, who will either be able to answer your question directly, or will get you in touch with the proper person. If you send more email to me, you will not receive another automatic reply. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: System Tablespace and Autoextend
I use AUTOEXTEND and it has been extremely helpful to me in managing growth. However, my policy is not to use autoextend for SYSTEM, rollback tablespace, or temp tablespace. SYSTEM (for me) is relatively stable. The only time I have significant growth in SYSTEM is during an upgrade. For rollback and temp tablespaces, I don't want to throw away diskspace on unreasonable or abnormal usage. If I grow these spaces, I've made certain that it is necessary. Kip Bryant |FWIW I'd go with Dennis here. I don't like AUTOEXTEND on the SYSTEM |tablespace. |(In fact I'm not overenamoured of AUTOEXTEND on any datfile, except maybe on |dev and sandbox databases). |If the SYSTEM tablespace isn't used for rollbacks (apart from the SYSTEM |rollback) or temporary segments and the auditing information is written to |it's own tablespace then I can't think of a set of circumstances that would |cause the SYSTEM tablespace to rapidly fill up. |System upgrade/migrations are the exception to this rule but in general a |DBA would plan ahead for those occasions anyway. |-Original Message- |Sent: Thursday, November 07, 2002 4:29 PM |To: Multiple recipients of list ORACLE-L |I've been running with autoextend on (though limited to 2Gig) and never had |a problem. |-Original Message- |Sent: Thursday, October 24, 2002 5:26 PM |I run my SYSTEM tablesaces in autoextend, and have for some time. I run them |that way from the point of database creation and have never had a problem. |There were some problems with autoextend in earlier versions of 8 (and I |think they managed to migrate to early 8i versions as well) with 2GB |boundaries, but those have all been corrected. |RF |Robert G. Freeman - Oracle OCP |Oracle Database Architect |CSX Midtier Database Administration |-Original Message- |Sent: Thursday, October 24, 2002 4:46 PM |Sam - | I haven't made the system tablespace autoextend because I can't easily |recover the space if it overextends. I would rather take the risk that |something hits an error from a lack of space in the system tablespace. With |other tablespaces you can always rebuild the tablespace if you need to. |Dennis Williams |DBA, 40%OCP |Lifetouch, Inc. |[EMAIL PROTECTED] |-Original Message- |Sent: Thursday, October 24, 2002 1:27 PM |Hello All, |I have heard several times that if the SYSTEM tablespace runs out of space |and needs to autoextend (assuming autoextend is turned on for the data |file), then you run the risk of the database crashing and of data dictionary |corruption. I have never personally encountered this problem, so I have no |experience on what actually does happen. |I looked in metalink for documents on this, but turned up nothing. Does |anybody have experience on the dangers of allowing the SYSTEM tablespace to |autoextend and also any documents on Metalink or OTN that describe this |problem? |We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle |versions are running on Windows NT (or Windows 2000). |Thanks for any feedback. |Sam Bootsma, OCP |[EMAIL PROTECTED] |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Hately, Mike (NESL-IT) | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Misinformation Ranting
Steve, There is a listserv for SAP. Go to http://www.sapfaq.com - member services - Technical support forums. You want to subscribe to at least BASIS. For myself, I rarely use SAPDBA because it didn't work on the first system I worked on (VMS). SAP has it's own data dictionary, umm, repository which carries where tables should be (according to SAP, anyway) so I'm not sure what you mean by wrong tablespace. I know it feels like having one hand tied behind your back but there is a fair amount of information collected by SAP that you will find useful. Classes would be useful... Kip |Jared, |I recently started a job that uses SAP on Oracle 8.1.7 and the only word |that describes my day is frustration. Are there any SAP do's and don'ts |you can recommend? |From my brief experience, I should use SAPDBA to add tablespaces or check |stats. Other than that I use sqlplus/scripts for everything else. |When the system does have performance problems, it's really tough to isolate |the problem because there's 400 users sharing 100+ connections and they're |all SAPR3. |the other irritating problem is on the BW system, tables get dropped and |recreated in the wrong tablespace. I know there has to be screen (or table) |that maps objects to tablespaces, but haven't found it. |Any tips you have would be appreciated. |Thanks, |Steve |- Original Message - |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |Sent: Tuesday, September 10, 2002 3:28 PM | RANT | | I've just spent 30 minutes with our SAP administrator trying to | convince her that we really don't need to reorganize the tables | in our production SAP database. | | Due to some misinformation in an Oracle Press book, 'Oracle Unleashed' | I think, she is equating number of extents with fragmentation. | | The text she referred me to is in fact discussing 'migrated rows' though | that term is never used. She has become convinced that if the | extents allocated for tables are not all in contigous space, some | very nasty fragmentation will occur. | | I tried taking it down to disk and explaining that an OLTP system with | hundreds of users won't really see much benefit from this, but she | wasn't really ready for that. :) | | Her concern is that there are 29000 extents in an index tablespace. | This might have something to do with there being 3400 indexes in | said tablespace. | | Total 'wasted' ( honeycomb ) space in this 250 gig DB is 20 meg. Not | much to gain there. | | The text of the book states that you should expect a '10 to 20 percent | performance increase' by reorganizing the tables/indexes. No data to | back it up of course. | | This is on a database that performs very well most of the time, outside | of a couple of custom reports that run too long. No complaints from | users about slowness. | | Arrghhh! | | I just had to vent to the list, cuz there's no one here that understands. | | \RANT | | Jared | | -- | 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: Steve Perry | INET: [EMAIL PROTECTED] |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 |San Diego, California-- Public Internet access / Mailing Lists | |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Misinformation Ranting
Hi Steve, Don't have BW system but I do have a new APO system which has some BW stuff in it. Developers tend to be clueless about table settings. In se11, display a table and look at technical settings. This has classification information that can have some bearing on where things go and also parameters which affect initial and next extent sizes which are controlled by tables igora and tgora. Also look at txn se14 (Database utility). It has storage parameters. Kip |Thanks. |I'll take a look at it. as far as tables in the wrong tablespace, I meant |that tables/indexes/partitions (on our BW system) get dropped into sapr3's |default tablespace and not into FACTD/I or ODSD/I. I've altered the indexes |to have a default for the partitions, but I still have to go through and |clean it up. At other times, part of rerunning a cube process is to drop |everything and reload it, which puts some of them in the wrong tablespace. |The developers clicking the buttons claim they don't know why, so I'm on |my own researching it. I know I'm not the first to run into this problem. |I've checked OSS, but haven't had much luck. |Thanks again, |Steve |- Original Message - |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |Sent: Wednesday, September 11, 2002 12:29 PM | Steve, | | There is a listserv for SAP. Go to http://www.sapfaq.com - member |services - | Technical support forums. You want to subscribe to at least BASIS. For | myself, I rarely use SAPDBA because it didn't work on the first system I |worked | on (VMS). SAP has it's own data dictionary, umm, repository which |carries | where tables should be (according to SAP, anyway) so I'm not sure what you | mean by wrong tablespace. I know it feels like having one hand tied |behind | your back but there is a fair amount of information collected by SAP that |you | will find useful. Classes would be useful... | | Kip | | |Jared, | | |I recently started a job that uses SAP on Oracle 8.1.7 and the only word | |that describes my day is frustration. Are there any SAP do's and don'ts | |you can recommend? | |From my brief experience, I should use SAPDBA to add tablespaces or check | |stats. Other than that I use sqlplus/scripts for everything else. | |When the system does have performance problems, it's really tough to |isolate | |the problem because there's 400 users sharing 100+ connections and |they're | |all SAPR3. | |the other irritating problem is on the BW system, tables get dropped and | |recreated in the wrong tablespace. I know there has to be screen (or |table) | |that maps objects to tablespaces, but haven't found it. | |Any tips you have would be appreciated. | | |Thanks, | |Steve | | | |- Original Message - | |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | |Sent: Tuesday, September 10, 2002 3:28 PM | | | | RANT | | | | I've just spent 30 minutes with our SAP administrator trying to | | convince her that we really don't need to reorganize the tables | | in our production SAP database. | | | | Due to some misinformation in an Oracle Press book, 'Oracle Unleashed' | | I think, she is equating number of extents with fragmentation. | | | | The text she referred me to is in fact discussing 'migrated rows' |though | | that term is never used. She has become convinced that if the | | extents allocated for tables are not all in contigous space, some | | very nasty fragmentation will occur. | | | | I tried taking it down to disk and explaining that an OLTP system with | | hundreds of users won't really see much benefit from this, but she | | wasn't really ready for that. :) | | | | Her concern is that there are 29000 extents in an index tablespace. | | This might have something to do with there being 3400 indexes in | | said tablespace. | | | | Total 'wasted' ( honeycomb ) space in this 250 gig DB is 20 meg. Not | | much to gain there. | | | | The text of the book states that you should expect a '10 to 20 percent | | performance increase' by reorganizing the tables/indexes. No data to | | back it up of course. | | | | This is on a database that performs very well most of the time, outside | | of a couple of custom reports that run too long. No complaints from | | users about slowness. | | | | Arrghhh! | | | | I just had to vent to the list, cuz there's no one here that |understands. | | | | \RANT | | | | Jared | | | | -- | | 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
RE: Misinformation Ranting
Hi, Your SAP administrator apparently hasn't read up on all the documentation that SAP provides on this topic. I assume she it not a DBA. About the only thing that SAP docs will do is encourage reorganizing fragmented indexes. And if for some reason you don't know how to identify fragmented indexes, they will show you how. Unfortunately, there are people floating around who can say they are SAP certified in Oracle on Unix but don't actually know much about Oracle. I actually interviewed a consultant who claimed to have such a certificate who had no idea what an SGA was. One of the questions I ask in an interview is something like is it really necessary to reorganize and how do you decide this?...just to see what kind of a reaction I get... Kip Bryant |RANT |I've just spent 30 minutes with our SAP administrator trying to |convince her that we really don't need to reorganize the tables |in our production SAP database. |Due to some misinformation in an Oracle Press book, 'Oracle Unleashed' |I think, she is equating number of extents with fragmentation. |The text she referred me to is in fact discussing 'migrated rows' though |that term is never used. She has become convinced that if the |extents allocated for tables are not all in contigous space, some |very nasty fragmentation will occur. |I tried taking it down to disk and explaining that an OLTP system with |hundreds of users won't really see much benefit from this, but she |wasn't really ready for that. :) |Her concern is that there are 29000 extents in an index tablespace. |This might have something to do with there being 3400 indexes in |said tablespace. |Total 'wasted' ( honeycomb ) space in this 250 gig DB is 20 meg. Not |much to gain there. |The text of the book states that you should expect a '10 to 20 percent |performance increase' by reorganizing the tables/indexes. No data to |back it up of course. |This is on a database that performs very well most of the time, outside |of a couple of custom reports that run too long. No complaints from |users about slowness. |Arrghhh! |I just had to vent to the list, cuz there's no one here that understands. |\RANT |Jared |-- |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: Brooks, Russ | INET: [EMAIL PROTECTED] |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 |San Diego, California-- Public Internet access / Mailing Lists | |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: runInstaller
My ignorant 2 cents. I have an x-terminal so I thought, No problem... After using the new installer 3 or 4 times, I would much rather have the old line mode installer. For me the resource problem is the xterm. My servers have no problem running this stuff. But when I crank this dog up from from xterm, the xterm's lights dim...I can't touch any of the other open windows or even move them around, I actually can't fix the tiny fonts (information on this didn't apply), and the gui controls are funky (technical term) and not very, um, responsive. I know a lot of this is probably due to inadequate memory on the xterm (which I can't do anything about at the moment)...but so far I fail to see the value added. The motif gui worked better for me too if I chose to use it. I guess I'll have to break down and get an x-windows client for my PC...it, of course, has lots of memory. On a more positive note, I do remote installs too but haven't tried this from home yet...meaning I've done both local and remote installs (ie: across our WAN) at work and the remote installs didn't seem to be any worse than the local installs. Kip Bryant |1) Production shop, obviously your not installing Oracle that much. But a |development shop is regularly installing Oracle. It would seem that people |with a command line background appreciate the power, flexibility, speed, |and therefore crave a command line installer. While people with a GUI |background appreciate the comfort of GUI. Click your radio buttons, click |Next. Click Help if your stuck, etc. |2/3) Yes, Java is everywhere for a reason. But real cross platform |developmentPerl(hoping for that free book from Jared..(grin)) |-Original Message- |Sent: Wednesday, July 10, 2002 12:24 PM |To: Multiple recipients of list ORACLE-L |All this ranting is nice but consider the following: |1) You do not install oracle on a server so much. |In fact, in our shop this is done by the technical |people, not the DBA. The DBA got the machine with |oracle already installed and just build the database. |2) When you have to do cross platform development |Java is the tool to save on resources. |3) Any machine that's need to run a production database |should be strong enough to run Java ok. |Yechiel Adar (not an oracle employee) |Mehish |- Original Message - |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] |Sent: Wednesday, July 10, 2002 5:08 PM | Me thinks this was done to check off some boxes to indicate that Oracle is | easy to install and maintain (OEM). These are boxes that SQL Server had | checked off (I guess) for a long time, and Oracle didn't. And Oracle can | check the Java box a few dozen times now. Oracle is now easier for your | (in)experienced IT shop to setup and maintain., Oracle sales guy rants |and | raves. And you don't need to pay for those over-priced experienced DBAs | anymore!!!, he exclaims. CIOs eyes glaze over... | | I am getting tired of W2K, and yearn to get back to Solarisor any |*NIX. | Sigh. | | -Original Message- | [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, July 09, 2002 6:24 PM | To: Multiple recipients of list ORACLE-L | | | Oh the system does. That's a given. There is no need to java-fy | everything. There was a perfectly good working installer. Not everyone | wants to jump through the hoops of setting up xservers and watching all |your | RAM consumed by the JRE. | | Perl and Perl TK are multi-platform, small footprint, etc. OEM 1.6 still | had mostly Tcl/TK pieces and parts and ran fast and reliably. Not so for | OEM 2.x. Give me a command line back for installs. That's not too much |to | ask, right? | | Scott Shafer | San Antonio, TX | 210-581-6217 | | | -Original Message- | From: Ray Stell [SMTP:[EMAIL PROTECTED]] | Sent: Tuesday, July 09, 2002 4:48 PM | To: Multiple recipients of list ORACLE-L | Subject: Re: runInstaller | | | | You might look at silent mode install, Note:73510.1 | | I have found that on really hot machines oui is a screamer. It could be | your system needs a facelift. | | | | | On Tue, Jul 09, 2002 at 12:47:19PM -0800, |[EMAIL PROTECTED] | wrote: | What I wouldn't give for ./orainst /c right now. | | RANT | | Where is the productivity and ease of use of the #$%^#@ OUI when it | takes | hours and hours just to load up all the java crap! Piece of garbage |is | enough to make me want to go back to 7.3.4 - and shoot the idiot who | thought | up java... | | /RANT | | Thankyou. I feel better about hating 9iAS now. | | | Scott Shafer | San Antonio, TX | 210-581-6217 | | | -- | 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
Re:RE: Oracle and Tru64
I never saw Ultrix but have heard other horror stories on this list and elsewhere. My first exposure to Dec was in '93 on the brand new Alpha's running openVMS. 64 bit and VLM long before any other vendor (and long before Oracle supported 64 bit, unfortunately)...and if the DEC wire-heads I worked for were right, a superior implementation of RISC architecture. Later on, we had to migrate our application to OSF which very soon after was renamed DEC Unix...which COMPAQ marketing renamed TRU64. Very fast and reliable. Now I get to do another platform migration in my spare time... Kip Bryant |Guess we had different experiences. OSF was being |replaced in favor of digital unix when I started my |sys admin days on DECs. They were also Oracle's |preferred platform at the time. Things have changed a |lot since then. |--- [EMAIL PROTECTED] wrote: | Peter, | | Please allow me to disagree. I came from the | USAF with a very deep love for | DEC hardware and software (VAX/VMS), only to be VERY | disappointed by them when I | was presented with DEC Ultrix. Their straying into | the Unix world was a real | nightmare. First off their sales folks over sold | the capabilities of the | 5000/240 workstation. A database server it was not. | Ultrix was a failure right | out of the gate. That monster combination was a | guarantee that I would get a | page every night that it was here and the server a | re-boot. It finally took me | three years to get a Ultrix tech to admit that they | had not implemented a | TCP_KEEP_ALIVE capability into Ultrix and that I | would never see it. At that | time the only path was to upgrade to an Alpha with | OSF-1 which was crashing on a | daily basis. Oracle back then recommended a cold | backup of the database twice a | day. One of the soccer dads whose's daughter was on | the same team as mine was a | DEC/Compaq employee. His recommendation was to stay | away from OSF at all costs. | He was one of the lucky ones when Compaq sold off | the CASE tools operation. Oh | how I would have loved moving back onto a VAX, but | DEC was not interested in | that platform any more and HP's 9000 platform was | not only cheaper to acquire | and support, but faster and more capable as well. | We benchmarked a DEC Ultrix | box specifically tailored by DEC to database work | against an HP9000 that 'just | happen to between owners'. The DEC was a multi | processor unit, stuffed with | every bite of RAM it could hold, multi scsi ports | with load balancing on their | (at that time) best disk system and a custom Oracle | install with a highly tuned | (by DEC engineers) Ultrix kernel. We passed then a | dmp file with 1 million rows | of data for two tables and 4 SQL scripts to run | against the data. Took them all | day to get the results. Did the same test with the | HP that had minimal RAM, one | scsi port and only the internal drives and a default | Oracle install and only | that tweaking of the HP kernel in Oracle's install | manual. Same test ran in 4.5 | hours hands down. I left DEC behind at that time, | never to return. As of | today, I love the HP's I have to work with. I do | not believe them to be | outclassed anywhere and that they do outclass all in | terms of reliability and | dependability. I must admit to really enjoying a | server platform that does it's | job day in and day out for months or years without | so much as a burp. I'm sure | that part of that are three very good SA's, but the | hardware/OS speaks for | itself as well. | | I did not shed one tear when DEC fell to Compaq, | and will not now that | Compaq is falling to HP. I am sure that the good of | DEC/Compaq will find it's | way into HP-UX as well as the HP9000 series. So | we've only good things to look | forward to. | | Dick Goulet | | Reply | Separator | Author: Peter Barnett [EMAIL PROTECTED] | Date: 6/4/2002 8:08 AM | | It's a shame that Digital had such good computer | scientists and such lousy marketing. Digital Unix | and | the AlphaServer were the most stable Unix boxes in | the | world. Compaq never did understand the gem it | purchased and HP will never admit that their current | generation of hardware was outclassed by Digital 10 | years ago. | | All good runs must come to an end. It is just too | bad | that the end is an execution by technical nitwits. | | | --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: | Stephane, Hemant |Below is the official word that I pulled off | HP's | website. It is | straight PR material, so read between the words as | you choose. As I recall, | Compaq had already decided not to build the | next-generation Alpha chip | before the merger arose. If you are interested, I | would suggest that you | attend the HP roadshow when it comes to a city | near | you and ask them the | hard questions yourself. Having worked for a | computer manufacturer in the | past, I can assure you
RE: So, What is a 'Production DBA'?
I know I'm probably going to regret replying to this thread. I'm one of those people who spent years as a programmer...and wound up somewhere in between applications and tech support because I couldn't get the tech support I needed. When we got SAP'd in '93, I finally gave in to becoming a so-called DBA to keep the legacy systems running (not Oracle based) AND keep the SAP project afloat. So I'm probably one of those SAP babysitters. I would love to be able to hire a development or applications DBA (we also have non-SAP Oracle databases) but the skill set I need in an individual to actually reduce my work load is much broader than the typical Oracle development or applications person. I know there can be exceptions, of course, but I haven't found development or applications people to be too concerned about the context in which a database lives let alone know what IT auditors would be looking for. I mean, the role I play doesn't seem to have any technical boundaries because, again, anything that can impact the application (be it SAN, OS, network, presentation layer, security, hardware, maybe even Sun spots...) is of concern to me. On the other hand, a DBA without an understanding of the demands put on developer/applications people is a problem, too. Or maybe I needed to whine a bit because I've been up at 2am and 5am a couple of days in a row. Sleepless in California, Kip Bryant |I'd take that pay differential thing with a grain of salt. |The definitions for Production DBA's, Apps, DBA's, and Development DBA's are |merely organizational interpretations. Each organization custom creates |these titles so PHB's can put labels on people. |In many cases a production DBA is merely a database babysitter and a |Development/Apps DBA requires higher skills for the overall architecture. In |other cases an apps DBA may just be someone who knows how to maintain a |particular 3rd party application but their knowledge of the database engine |is suspect. I once knew an HR Database Administrator, AKA Apps DBA, who |knew nothing about databases but lots about some weird, off the wall, |non-mainstream, proprietary HR application. This person's skills were not |marketable but their title was. ;-) |Aspiring chief cook and bottle washer, |Steve Orr |-Original Message- |Sent: Thursday, May 30, 2002 10:06 AM |To: Multiple recipients of list ORACLE-L |Thanks to all who responded. The debate on the list |is just as lively as the one around the water cooler. |I did like the response about a 50% pay differential |for production DBAs. That will make the bosses hair |stand on end! |--- Peter Barnett [EMAIL PROTECTED] 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] |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Orr, Steve | INET: [EMAIL PROTECTED] |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 |San Diego, California-- Public Internet access / Mailing Lists | |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Begin backup fails sporadically
Hi, I'm leaning towards parallel execution, now. I just haven't proven it yet. I now think it is merely a procedural problem with operations. I just haven't figured out what that procedural problem is...yet. Thanks, Kip Bryant |Hi, |You're problem might be that your backup software is doing things |in parallel. We use Omniback here and it happened here also. |Hth, |Jeroen |-Oorspronkelijk bericht- |Van: Peter Gram [mailto:[EMAIL PROTECTED]] |Verzonden: vrijdag 26 april 2002 10:03 |Aan: Multiple recipients of list ORACLE-L |Onderwerp: Re: Begin backup fails sporadically |Hi Kip |When you next time have this problem check the v$backup table to verify |that the file is not in backup mode, if this is tha case you |proberly have to log a iTAR with support. |[EMAIL PROTECTED] wrote: |Version is 8.0.6.3.0 | |I have several databases using the exact same set of generic backup |scripts. |The script that puts all tablespaces into backup mode is generated |automatically and done correctly. Same is true for the script which takes |all |the tablespaces out of backup mode. The problem I am facing is that when |this |script is invoked, one (and only one) of these databases occasionally has |problems. Some tablespaces are successfully put into backup mode and some |say | |ORA-01146: cannot start online backup - file 15 is already in backup |ORA-01110: data file 15: ' datafile name ' | |The only things that would make sense to me is if two of these scripts were |running in parallel or if the prior day had some weird problem. Neither of |these seem to be the case. The only thing that seems to straighten things |out |is to runs these scripts manually. | |Ideas? | |Regards, |Kip Bryant | |-- |/regards |Peter Gram |Mobil : +45 2527 7107 |Fax : +45 4466 8856 |Miracle A/S |Kratvej 2 |2760 Måløv |http://miracleas.dk |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Peter Gram | 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: Jeroen van Sluisdam | INET: [EMAIL PROTECTED] |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 |San Diego, California-- Public Internet access / Mailing Lists | |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Begin backup fails sporadically
Version is 8.0.6.3.0 I have several databases using the exact same set of generic backup scripts. The script that puts all tablespaces into backup mode is generated automatically and done correctly. Same is true for the script which takes all the tablespaces out of backup mode. The problem I am facing is that when this script is invoked, one (and only one) of these databases occasionally has problems. Some tablespaces are successfully put into backup mode and some say ORA-01146: cannot start online backup - file 15 is already in backup ORA-01110: data file 15: ' datafile name ' The only things that would make sense to me is if two of these scripts were running in parallel or if the prior day had some weird problem. Neither of these seem to be the case. The only thing that seems to straighten things out is to runs these scripts manually. Ideas? Regards, Kip Bryant -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MySQL vs. Oracle database
SAP official history is at http://www.sapdb.org/history.htm
Amusingly, they have blanked out what SAPDB was originally called. Of
personal interest to me is the Cincom connection in that I worked with their
software for much of the 80's...
Kip Bryant
|Um, no, not really.
|SAPDB is Sybase, pure and simple.
|Jared
|On Thursday 18 April 2002 12:21, Gordon, Emery {PDBI~Palo Alto} wrote:
| There is a new alternative. SAPDB is open source but supported by SAP. Whan
| used outside of SAP applications it is free but charged when used inside of
| SAP. The support is from a major software company and the features are much
| closer to the Oracle feature set.
|
| Emery Gordon
|
| -Original Message-
| Sent: Wednesday, April 17, 2002 12:32 PM
| To: Multiple recipients of list ORACLE-L
|
|
|
|
| -- Weaver, Walt [EMAIL PROTECTED]
|
| I don't think you're wrong. MySQL gets dissed frequently on this list,
| but it's really a nice little product. IMHO it's much closer to Oracle
| than Access.
|
| It works well for us. Doesn't scale like Oracle, but works well.
|
| In some ways it scales better than Oracle. For load+query
| (a.k.a., warehouse) operations it can be faster than
| Oracle because it doesn't get tangled up with rollbacks,
| etc. On systms with many instances it also can be much
| simpler to administer.
|
| --
| Steven Lembark 2930 W. Palmer
| Workhorse Computing Chicago, IL 60647
| +1 800 762 1582
|--
|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:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Re[2]: MySQL vs. Oracle database
Plus, I had some experience with a Supra-ized Cincom database. It was a
nightmare. We wound up reverting to their more primitive (but stable)
database - Total. There was a newer pass at Supra in the early '90s that
was supposed to turn a Total database into a relational database and this
looked promising...but I moved on to the Oracle world...
Kip Bryant
|Knowing what I do about SAP support I'd not want to get into a project with
|SAPDB! Those good German engineers would chew your head off when calling tech
|support. Whatever caused the error MUST be your fault!
|Dick Goulet
|Reply Separator
|Author: [EMAIL PROTECTED]
|Date: 4/22/2002 9:30 AM
|SAP official history is at http://www.sapdb.org/history.htm
|Amusingly, they have blanked out what SAPDB was originally called. Of
|personal interest to me is the Cincom connection in that I worked with their
|software for much of the 80's...
|Kip Bryant
||Um, no, not really.
||SAPDB is Sybase, pure and simple.
||Jared
||On Thursday 18 April 2002 12:21, Gordon, Emery {PDBI~Palo Alto} wrote:
|| There is a new alternative. SAPDB is open source but supported by SAP. Whan
|| used outside of SAP applications it is free but charged when used inside of
|| SAP. The support is from a major software company and the features are much
|| closer to the Oracle feature set.
||
|| Emery Gordon
||
|| -Original Message-
|| Sent: Wednesday, April 17, 2002 12:32 PM
|| To: Multiple recipients of list ORACLE-L
||
||
||
||
|| -- Weaver, Walt [EMAIL PROTECTED]
||
|| I don't think you're wrong. MySQL gets dissed frequently on this list,
|| but it's really a nice little product. IMHO it's much closer to Oracle
|| than Access.
||
|| It works well for us. Doesn't scale like Oracle, but works well.
||
|| In some ways it scales better than Oracle. For load+query
|| (a.k.a., warehouse) operations it can be faster than
|| Oracle because it doesn't get tangled up with rollbacks,
|| etc. On systms with many instances it also can be much
|| simpler to administer.
||
|| --
|| Steven Lembark 2930 W. Palmer
|| Workhorse Computing Chicago, IL 60647
|| +1 800 762 1582
||--
||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:
| INET: [EMAIL PROTECTED]
|Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California-- Public Internet access / Mailing Lists
|
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be removed from). You may
|also send the HELP command for other information (like subscribing).
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author:
| INET: [EMAIL PROTECTED]
|Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California-- Public Internet access / Mailing Lists
|
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be removed from). You may
|also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RE: How do you audit a DBA?
Move to Germany. They actually have to come up with a justification for NOT taking vacation! Kip |I want to be required to take 2 weeks vacation. | -Original Message- | From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] | Sent: Thursday, August 23, 2001 3:37 PM | To: Multiple recipients of list ORACLE-L | Subject: Re:RE: How do you audit a DBA? | | | Dick, | | Actually, many states are work at will -- which means the | company can fire | you because. No reason, just because. | | The idea of sending the DBA off on a training course -- NYS | has a similar | concept in the state banking laws. Anyone working for a | state-chartered bank | who has more than 2 weeks of vacation is required to take two weeks | consecutively, those with 2 weeks or less have to take a | week. The theory | is, if you are cooking the books it should come to light in | that time | period. | | Rachel | |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Anderson, Brian | INET: [EMAIL PROTECTED] |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 |San Diego, California-- Public Internet access / Mailing Lists | |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: OFA (Optimal Flexible Architecture) in practice
This was my memory as well. I thought separating archive, redo, indexes, data and so on predated OFA. Also, I read through the comments pretty quickly but I thought Oracle discouraged the use of symbolic links for data files. I've seen this done without trouble but isn't there some potential error that this might trigger? Seems to me there was some traffic on the list for this a while back... Ready to be wrong, Kip |IMHO I think you all have got the reasons for OFA somewhat backwards. Back in |the older days one had one and only one version of Oracle running on a |particular machine at one time. This made upgrading/migrating or running a new |version in test while the older one was still running production absolutely |impossible or at least very difficult. The idea around OFA is that you have one |or more Oracle home directories off of Oracle base and all of your data files |elsewhere. Now when it comes time to upgrade you just shutdown, backup the |datafile area, move a couple of init or cfg files, startup, run the scripts |required, shutdown backup the same directory(s) again. |Dick Goulet |Reply Separator |Author: Tim Gardner [EMAIL PROTECTED] |Date: 7/5/2001 5:15 PM |Does anyone use OFA as their company standard? If so, are there any |complaints about it's structure? For example, the commingling of |different database subdirectories under a given mount point? | |e.g.. | |/u02/oradata/db_name1/userdata01.dbf |/u02/oradata/db_name2/userdata01.dbf |/u03/oradata/db_name1/userdata02.dbf |/u03/oradata/db_name2/userdata02.dbf | |You cannot cd to a given subdirectory, ls -ltR | more to see all the |datafiles associated with a given database. Instead, from / you |have to ls -ltR | grep db_name1 to scan the full file system. Seems |like there should be a better way. | |Any input, pro or con, is appreciated. |Linda, |The point of OFA is to spread out the database over different drives |for performance reasons. For example, you might want to separate |indexes from data. Would what you are proposing allow for multiple |drives? |Tim |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: Tim Gardner | INET: [EMAIL PROTECTED] |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 |San Diego, California-- Public Internet access / Mailing Lists | |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.com |-- |Author: | INET: [EMAIL PROTECTED] |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 |San Diego, California-- Public Internet access / Mailing Lists | |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(or the name of mailing list you want to be removed from). You may |also send the HELP command for other information (like subscribing). -- 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).
security alert sqlnet
Maybe people have already seen this: Oracle users urged to patch holes in Oracle8i Vulnerabilities have sparked concerns about denial-of-service attacks and exposure to malicious code in the standard and enterprise editions of Oracle Corp.'s Oracle8i database that could place companies' data at risk. http://computerworld.com/nlt/1%2C3590%2CNAV47_STO61802_NLTpm%2C00.html ...anyone had a chance to evaluate this? Kip -- 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).
