testing RMAN == 2 databases in 1 Machine
Dear Listers , I want to try using RMAN in just 1 machine with 2 databases ( client and target ) . I have followed every single step in manual , but there's always error ... Do we must run RMAN in 2 machines ? Thank a lot in advance : ) =bambang= Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan 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).
EXP-00003: no storage definition found for segment
Hi there, I have some problems to export any table, so it seems, of my Oracle 7.3.4 database. I run into the following error: EXP-3: no storage definition found for segment (name, num) Cause: Export could not find the storage definitions for a cluster, index, or table. Anybody out there who can give me a hint or workaround to export my entire database? Further explanations: I think this behavior is not caused by bug 182656. Because of this bug, the index for a primary or unique key constraint is created in a schema that is different from the table's schema. Export expects these indexes to be owned by the table owner. If it cannot find them in the owner's schema, it errors out with EXP-3. But there is definitely no index created in a schema that is different from the table's schema. Therefore the following Workarounds gives no result: - Run the export as SYS. - Disable the primary or unique key constraint, do the export, and then re-enable the constraint. - Drop the primary or unique key constraint, recreate it in the table owner's schema, and then run the export. This will actually fix the problem for the table involved. Best regards Henrik Bachmannmailto:[EMAIL PROTECTED] B.I.M.-Consulting Magdeburghttp://www.bim-consulting.de/ D-39108 Magdeburg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bachmann, Henrik 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).
Entity Relationship diagrams
Dear DBA Gurus, I have around 30 tables for which the columns, datatypes, size of each datatype, referential integrity constraints is decided. I need to draw E-R diagram linking each table with one or many tables. I am looking for a tool which will draw the diagram for me if I provide the column names, its datatypes, referential integrity constraints etc. Is there any free tool which will do this for me? If not, how do I do this? Any URLs or links or documents will be very much helpful. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [EXP-00003: no storage definition found for segment]
hi Bachman, I wonder how you could have an index that is out of your schema,you mean you built it with another user? Anyway,the workaround you wrote would do it. did you try the command prompt for export instead of using the Gui at the server? I got used to command prompts than GUI tools on the server and they are great. here is the command for the export. "exp73 userid=username/password@connect_string file=your_file_name tables=your_table_name,another_table_name,...etc". I have used exp73 because you said you are using ORacle 7.3. I issue this command from the client (if you have installed on this client the designer 2000 tool). when importing: "imp73 userid=username/password@connect_string file=your_file_name from_user=the_old_user_name to_user=the_new_user_name" these are working very fine with me. Good luck Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MOHAMMAD AMER 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: Free Java dba monitoring tool and Java source code
Hi, in my opinion, Jared is only partly right. PL/SQL is a handy procedural language extension to plain SQL. Since SQL derives from the family of declarative languages (by the way, what happened to all the research in the late 80s/ early 90s about hooking up PROLOG engines to RDBMSs ? AFAIK, the major withdraw was execution speed of logical queries ...), but the three together (SQL,PL/SQL and Java) give you a great opportunity to use the OO paradigm within the Oracle engine (or at least you're getting closer to it ;). This might be valuable for developer databases, since they won't have to set up a complete 3-Tier infrastructure just in order to test drive their stuff (besides from within the IDE). I don't know about the usability for production databases (yet), since it might be too messy to monitor and tune stuff once you have both the database and the application running mixed altogether within the DB. I know that a lot of this is done with PL/SQL, but I personally think it's clearer to distinguish between the data and the application unless you run some administrative things. Just my 2 Cent ... "Sam P. Roberts (ZADCO ITIS)" schrieb: Dear List To quote Jared recently 'And if you are wondering 'Should I learn Java?', the answer is 'definitely', as it is capable of many things that PL/SQL is not.' I have to totally agree with him and I think DBA's can enhance their profile by becoming competent in the technology. As part of my masters dissertation I have developed an SQL monitoring tool using Java/JDBC/thin drivers that allows the DBA to see who is taking up the resources currently in a database. The default is physical reads but any statistic can be selected. It displays like Instance manager but gives added functionality that it will extract the SQL that is running currently and allow you to Explain it online. You can sort the session data, kill sessions, etc.. It is a good tool especially if you suddenly get a dip in performance and need to quickly find which process is taking up all the resources. It is also good for ad-hoc monitoring. I know there are better/professional tools out there but not all companies can afford them,this is free and has been built in limited time. I work for an oil company and we have no monitoring tools, we had to rely on our own scripts. Most importantly I will give the source code to all that give me comments on the tool. This is not at all a commercial venture, purely academic. Plus if you want to learn about Java/JDBC this can be an invaluable asset/starting point as you know the subject well and you can see how the tool has been built. The tool is thin client - i.e. no oracle client installation necessary All you need to do is download Java 1.3 from Sun. If you e-mail me offline I will send you my website address where you can download (396kb-takes no time). There is also a link to the sun site for Java 2 download (this takes a little longer as its ABOUT 30MB).But it has all the latest swing classes and is the latest version. As an ex Cobol programmer in the 80's, Java is a wonderfully elegant language to learn and once studied is not as difficult as imagined (I imagined anyway). Sam -Original Message- Sent: Tuesday, March 27, 2001 12:21 AM To: Multiple recipients of list ORACLE-L Oracle has repeatedly stated that PL/SQL is not going away. One good reason for this is that PL/SQL is highly optimized for DML in the database. Java is not, and will not likely ever be as efficient PL/SQL for manipulating large amounts of data. At least IMO. OOP has many benefits, but large scale DML is not one of them, at least not yet. PL/SQL will be around for awhile yet. And if you are wondering 'Should I learn Java?', the answer is 'definitely', as it is capable of many things that PL/SQL is not. Jared On Thu, 22 Mar 2001, Jeff Cox wrote: Dear List, I haven't really seen a question on this list regarding SQLJ, and it makes me wonder how many people on this list actually use SQLJ. A DBA friend of mine told me that eventually SQLJ will replace PL/SQL in preference, and I wanted to know the truth regarding his statement - so who better to ask than the experts of this list? What have you heard, or better yet, what is your opinion of SQLJ? Is SQLJ the future? Will PL/SQL die a slow death? Can you do everything in SQLJ that you can do in PL/SQL? Cheers, Jeff Cox IPS-Sendero Scottsdale, AZ -- Regards, Stefan Jahnke BOV AG @:D2 Vodafone, Abt.: FIBM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
Re: Entity Relationship diagrams
Hi, You can try a software from embarcadero , perhaps www.embarcadero.com , ( if I'm not wrong spell it ) ... or go to www.platinum.com to download Erwin ... hth, bambang Bambang Setiawan "Ranganath K" [EMAIL PROTECTED] 04/17/01 03:50PM Dear DBA Gurus, I have around 30 tables for which the columns, datatypes, size of each datatype, referential integrity constraints is decided. I need to draw E-R diagram linking each table with one or many tables. I am looking for a tool which will draw the diagram for me if I provide the column names, its datatypes, referential integrity constraints etc. Is there any free tool which will do this for me? If not, how do I do this? Any URLs or links or documents will be very much helpful. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan 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).
AW: [EXP-00003: no storage definition found for segment]
Hi ... -Ursprngliche Nachricht- Von: MOHAMMAD AMER [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 17. April 2001 10:51 An: Multiple recipients of list ORACLE-L Betreff: Re: [EXP-3: no storage definition found for segment] hi Bachman, I wonder how you could have an index that is out of your schema,you mean you built it with another user? Yes I mean that. This could be the reason for bug 182656 (Source: Oracle) Anyway,the workaround you wrote would do it. did you try the command prompt for export instead of using the Gui at the server? Yes of course. [Snip] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bachmann, Henrik 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: Entity Relationship diagrams
hi, ya there are tools which can do this work for you. one such tool i know is Platinum ERwin, but i don't know whether it's free or not. but what i feel is u can get some trial version of it. try getting some more info about how to get it. but one thing i tell u, it's really a good tool. i've used it, it's handy and easy to use. it has tools for reverse and forward engineering. bye, saurabh - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 2:20 PM Dear DBA Gurus, I have around 30 tables for which the columns, datatypes, size of each datatype, referential integrity constraints is decided. I need to draw E-R diagram linking each table with one or many tables. I am looking for a tool which will draw the diagram for me if I provide the column names, its datatypes, referential integrity constraints etc. Is there any free tool which will do this for me? If not, how do I do this? Any URLs or links or documents will be very much helpful. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh Sharma 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: Meeting at IOUG
Me too, Me too!!! ROR mm Ron Rogers DBA OCP Georgia Lottery Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Don't Let Microsoft's Claim of Superior Database Security Fool
Geez, enough of the political debates! Let's get back to the business at hand. Here's an announcement from our favorite vendor: Don't Let Microsoft's Claim of Superior Database Security Fool You In a clever attempt to turnaround its weak security image, Microsoft issued a press release touting it's superior database security after undergoing C2 certification. Don't let the outdated C2 certification mislead your customers. Here is how you can respond to Microsoft's misleading claim of having the most secure database over Oracle: Microsoft Press Release: "Of the current version enterprise databases from Oracle Corp., IBM Corp. and Microsoft Corp., only SQL Server 2000 has achieved a C2 or higher rating from the National Security Agency (NSA), making it a National Security Agency Trusted Product." Oracle Response: Microsoft has finally joined the security evaluation club, only they are using yesterday's standard. No one does "Orange Book" evaluations any more. We got our first Orange Book C2 certificate for Oracle7 in April 1994 The NSA stated years ago that Orange Book was 'dead'. That is why the current release of the Oracle database has not undergone C2 certification. The Orange Book has been superseded by the internationally recognized, ISO standard Common Criteria and all leading edge products are currently being evaluated by this new standard. What database vendor received the first Common Criteria certificate for commercial database? Oracle. This is nothing more than the usual marketing drivel from Redmond, the folks that bring millions of users the weekly Internet Information Server (IIS) security patch. How many ecommerce web sites running the Microsoft platform have had their customers' credit card numbers compromised and exposed? The public has lost count. Why is this important? Internet security is a top concern for C-level executives due to the risks involved. A single security breach can result in financial loss, public distrust, and even imprisonment. See the alarming statistics: An estimated $1.6 trillion was lost last year worldwide due to downtime associated with Internet security breaches (InformationWeek) 2 out of 3 U.S. corporations, government agencies, financial institutions, medical institutions and universities acknowledged financial losses last year due to computer security breaches (Computer Security Institute Survey March 2001) $276.5 million lost by Europeans in 2000 due to online credit card fraud from poor Web-site security and security breaches (European Union) Customers need assurance that the Internet infrastructure maintaining their critical data is well protected. Third party, independent security evaluators such as the TCSEC, ITSEC, and the Common Criteria, to name a few, should give your customers confidence that the products they purchase have been thoroughly tested for security assurance. Your customers can trust Oracle, the only vendor with 13 security evaluations of its database server. See scorecard below: Database Server Products Security Evaluation Oracle IBM Microsoft TCSEC, level B1 1 0 0 TCSEC, level C2 1 0 1 ITSEC, levels E3/F-C2 3 0 0 ITSEC, levels E3/F-B1 2 0 0 Russian Criteria, levels III, IV 2 0 0 Common Criteria, level EAL-4 3 0 0 FIPS-140, level 2 1 0 0 Total 13 0 1 A detailed list of certifications for individual Oracle server products can be found at the Oracle security evaluations web site. For more information about the terminology on the chart, download the Oracle white paper, Computer Security Criteria: Security Evaluations and Assessment. What other security advantages does Oracle have over competitors? Security assurance does not stop with independent evaluations. An internet infrastructure requires multiple layers of security processes to ensure that exploitation or failure of one mechanism does not compromise sensitive data. Oracle integrates unique, multiple layers of security processes within the database to ensure the overall protection and privacy of your most valuable asset - information. See feature comparison below: Database Feature Comparison Feature Oracle9i IBM UDB SS 2000 Virtual Private Database Yes No No Label Security Yes No No Selective Data Encryption Yes(IBM Platforms only) No Fine-grained auditing Yes No No The Internet Platform Security Services address both technology and methodology meeting the end-to-end security requirements of an e-business. Our security services ensure that security policies and system components such as firewalls, intrusion detection systems, web servers, application servers and data servers, are themselves secure and interact with each other reliably. What press or publications support Oracle's strong security? Oracle, IBM
Re: How does dropping a partition affect the rest of the table?
If your indexes are local then no problem . If the indexes are global you 'll have to rebuild them . --- [EMAIL PROTECTED] a crit: I've looked through the on-line documentation on dropping partitions but I have not seen the following question specifically addressed: How does dropping a date-range partition affect the rest of the table/partitions? I read that if I drop a partition with a global partitioned index that the entire global index will need to be rebuilt but that's about all I've seen about the affect on the other partitions. Can I drop an unneeded partition on the fly? What is the effect on performance of the rest of the table? Does anything need to be brought offline before I drop the desired partition? Thanks in advance to all you knowledgable partitioners. Cherie Machler Gelco Information Network -- 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). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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).
NYTimes.com Article: Myth-Matched Nations
This article from NYTimes.com has been sent to you by [EMAIL PROTECTED] a reasonable response to an unreasonable email / advertisement ---\ Let NYTimes.com Come to You Sign up for one of our weekly e-mails and the news will come directly to you. YOUR MONEY brings you a wealth of analysis and information about personal investing. CIRCUITS plugs you into the latest on personal technology. TRAVEL DISPATCH offers you a jump on special travel deals and news. http://email.nytimes.com/email/email.jsp?eta5 \--/ Myth-Matched Nations FOREIGN AFFAIRS By THOMAS L. FRIEDMAN A quasi-independent public opinion is developing in China, and we need to take it seriously. http://www.nytimes.com/2001/04/17/opinion/17FRIE.html?ex=988510658ei=1en=99608578329c7273 /-\ Visit NYTimes.com for complete access to the most authoritative news coverage on the Web, updated throughout the day. Become a member today! It's free! http://www.nytimes.com?eta \-/ HOW TO ADVERTISE - For information on advertising in e-mail newsletters or other creative advertising opportunities with The New York Times on the Web, please contact Alyson Racer at [EMAIL PROTECTED] or visit our online media kit at http://www.nytimes.com/adinfo For general information about NYTimes.com, write to [EMAIL PROTECTED] Copyright 2001 The New York Times Company -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT Re: Do not belive MUSH and your POPCORN goverment so much
Eric - I couldn't agree with you more! Well said! [EMAIL PROTECTED] 04/16/01 10:10PM Celebrate the entreprenurial spirit: http://www.popcornfork.com/ excerpt: --- "CAUTION Ordering and using the POPCORN FORK will automatically cancel your membership in the FLAT WORLD SOCIETY! You may be ridiculed, and put upon by the less enlightened. Your best friends may drop you like a dirty sock when they see you enjoying Popcorn and other snacks with this instrument of cleanliness. But the up side is that you won't leave fingerprints visible to the naked eye. Your computer keyboard will be neat and clean. Opportunity's won't slip through your fingers. You will be hailed by some [Me] as a "Popcorn Pioneer" Thank you for your support." --- OT: The whole *point* of the USA originally WAS to build a capitalist "empire" based on a (religiously) "destined" vision of freedom from tyrants (morally corrupt kings and churches, then later the whole line of stupid "enlightened" nationalist/absolutist dictators like Napolean) that controlled their country's economies. This is clearly explained in a very large number of books by prominent social scientists and legitimate historians. If you would take the time to educate yourself you would understand that the traditions behind american culture are as unlikely to fundamentally change (as has been the case at least since the civil war in the 1500s in england) as is the case in China. "Many forms of Government have been tried, and will be tried in this world of sin and woe. No one pretends that democracy is perfect or all-wise. Indeed, it has been said that democracy is the 'worst' form of Government except all those others that have been tried from time to time." Sir Winston Churchill http://www.cp-tel.net/miller/BilLee/quotes/Churchill.html "You can trust the Americans to do the right thing, after they have tried every other alternative. " - Winston Churchill, 1941 If you think anyone here (except stupid liberals) is going to let a bunch of pissy tyrant-atheist-communists (that are in the line of people that have HATED whites for 5000 years) take those traditions away, you are a truly stupid dba (certifiable). The current government in China attempts to legitimize its dysfunctionality, incompetence and abuse of its own people's freedoms and needs by referring to "european imperialism", but in typically sick fashion, conveniently ignores the fact that it is responsible for the death for 10 of millions more people than the european imperialists ever imagined possible. The functional loss of an entire people (Tibet) whose culture (mysticsm/compassion/altruism) inherently demonstrates the vast falsehoods and fraudulency of socialism-atheism is one of the most horrid and tragic cases of genocide on the planet. Unless they have had the absolute cr*p beaten out of them first, the american people will never give up their freedom groveling in front of pissy tyrants, liars or thieves (including the Beijing hardliners). http://www.vr.net/~herzogbr/kafka/beforethelaw.htm regards, ep On 16 Apr 2001, at 14:50, Robert Chen wrote: Date sent: Mon, 16 Apr 2001 14:50:20 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] You will not hesitate to think that US is the strongest Country in this world. At least I am the only survive in this msg board. Sigh! It's difficult to achieve anything without support. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Gene Sais 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: Meeting at IOUG
Title: RE: Meeting at IOUG I'm going to be there (I better, I'm supposed to be giving four presentations) Also, for anyone in the central Ohio area, on thursday the Ohio Oracle Users group will be meeting at which Gaja and I will both be presenting. See www.ooug.org for more details R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Murali Vallath [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 10:31 PM To: Multiple recipients of list ORACLE-L Subject: Meeting at IOUG Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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: testing RMAN == 2 databases in 1 Machine
No, I backup databases on 3 machines using rman. Our recovery catalog database is on our production machine and I backup my production databases on that machine. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 3:20 AM Dear Listers , I want to try using RMAN in just 1 machine with 2 databases ( client and target ) . I have followed every single step in manual , but there's always error ... Do we must run RMAN in 2 machines ? Thank a lot in advance : ) =bambang= Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Entity Relationship diagrams
I do not know of any good modeling tool for free, they all charge $$$. I found it a bit strange that you have all the physical layout done then want to do an entity- relationship diagram after... --- Ranganath K [EMAIL PROTECTED] a crit: Dear DBA Gurus, I have around 30 tables for which the columns, datatypes, size of each datatype, referential integrity constraints is decided. I need to draw E-R diagram linking each table with one or many tables. I am looking for a tool which will draw the diagram for me if I provide the column names, its datatypes, referential integrity constraints etc. Is there any free tool which will do this for me? If not, how do I do this? Any URLs or links or documents will be very much helpful. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Temporarily Renaming the sgadefSID.dbf File
Good Morning! Just wanted to thank everybody for their responses and excellent feedback. Renaming the file worked like a charm. This allowed me to create the controlfile of the new database and bring it up w/o any problems. Now I know :-) Steve -Original Message- From: Morrow, Steve Sent: Tuesday, April 10, 2001 3:36 PM To: '[EMAIL PROTECTED]' Subject: Temporarily Renaming the sgadefSID.dbf File Hi All, Trying to clone our PROD to a test database on the same machine for testing our 734--8i upgrade, and of course we're encountering the "can't-start-the-new-without-shutting-down-the-old" database problem (ie, ORA-9782 on the CREATE CONTROLFILE command). We've worked around this in the past by scheduling a time to bring down PROD. I know that this is the safest, most reliable way (besides NOT doing this on a production box...but I have no choice), but believe it or not, I actually saw a reference on a Metalink forum to rename the sgadefSID.dbf file, start up the new database, then rename the file to its original name. Obviously sgadef gets created at instance startup as a memory map, but it doesn't look like it's used for anything after that (it's certainly doesn't seem to be written to). I do know that you can get an octal dump of the file to determine the shared memory ID for whatever reason. Everything else I've heard/seen about this file has pretty much said DON'T TOUCH IT!!! But if the instance only uses it at instance startup, is there any harm in renaming it temporarily to get the other database up? If so...why? And have any of you tried renaming or deleting the file in your cloning (or other) efforts? Did it blow up, or work? TIA, Steve _ Steve Morrow IT/Tech Support University of South Florida phone: 813-974-5519 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morrow, 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).
weird bitmap error
Scenario: AIX, 8.1.6.3. Cognos cube building going on. select count(*) from ft_sales, shows up 0 rows, its using a bitmap index out of the explain plan. I force full table scan or force to use other bitmap index, or PK(normal index) and it comes back with correct count(20+ million). Anyone seen anything like this before? thanks, joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Do not belive BUSH and your army goverment so much
Maybe you should mention how much better China is than the US to all the Chinese people willing to risk their lives crossing the Pacific in cargo holds in search of a better life here. -Original Message- Sent: Monday, April 16, 2001 4:21 PM To: Multiple recipients of list ORACLE-L right now, I understand US people also just belive TV or news. The news always controlled by goverment or service for the goverment. This fact is for sure that US is high-handed and arbitrary. US army fly to all over the world and control all the world. I hate this but I feel so frustrated that US army is No.1 in this world and all over the world can not even say a "NO" to US. Right now, I know many US people do not understand Chinese, Chinese do love peace very much. Many things, these days, China are better than US now. You should go and have a look in China. Do not be so stupid and arbitrary. Do not belive BUSH and your army goverment so much. When the army is so good, they want to invade China or some other coutries. I hate China does not have good people rights. But I hate US is so impolite when they know they will win on every army fight. What I have forcasted are becoming true now. When BUSH was selected as president. I forcasted he would make many bad things and use his army. Today I forcast he will invade China more and put all Chinese in extreme misery. He will because he is the people who care too much about army...He do not care about high-tech, you are losing your good salary now...You have lose you stock options. Just one more fact, yesterday I watched the TV, the announcer used intimidatory voice that made very unhappy, "fuck you", I growl to the TV. Just because you have the No.1 army so you can do all the things? Sorry for this post because it is not about ORACLE. If US and China finish the relationship, at least 10% more of you will lose your job. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:20 PM They ought to learn flying their bikes from ET.. leave fighter plane flying to others.. -Kirti -Original Message- From: Eric D. Pierce [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: stupid DBA Well, according to the stereotype, they aren't very good drivers, so maybe it was inevitable. ep [EMAIL PROTECTED] 04/14 6:15 PM How was it mean? Considering how well they seem to do their job, it would be a heck of a lot easier to become a Chinese fighter pilot than a nurse. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chen 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: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem opening Oracle Forms
I have installed Oracle Developer/2000 on my machine. When I try and open up Forms I get an error message: Message file C:\ORACLE_HOME\DBS\FMCUS.MSB not found. I looked for the file in that directory and it is definitely not there. Any ideas? Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric 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: index query
You could use the alter index rebuild option. This keeps the old index available for queries until the new index has been created. You just need to make sure you have double the space of the object you are rebuilding when using this technique. James --- Seema Singh [EMAIL PROTECTED] wrote: Hi Dbas I have following query regarding index. 1)how to defragment the index except export/drop/create/import option 2)I have seen my index tablespace it is growing fast as compare to data tablespace even. Please advice what I do. Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: james ellis 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: Meeting at IOUG
I will be there also. Sandra Arnold DBA Strategic Staffing Solutions -Original Message- Sent: Tuesday, April 17, 2001 7:55 AM To: Multiple recipients of list ORACLE-L Me too, Me too!!! ROR mm Ron Rogers DBA OCP Georgia Lottery Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arnold, Sandra 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: Materialised view
Here is the MV log and the MV, it's generating an ORA-12032 when trying a refresh fast. create MATERIALIZED VIEW log on sp_ect_etat_contrat with primary key (ECt_ID_PRODUIT, ECt_CD_SERIE , ECt_CD_SOURCE , ECt_CD_AGENCE , ECt_CD_APPORTEUR , ECt_BT_ENCOURS, ECt_CD_ETAT, ECt_BT_VEP, ECt_BT_RPP , ECt_BT_NANTISSEMENT , ECt_MT_VALEUR_ACQUISE) including new values ; create materialized view admindba.sp_aec_agg_etat_ctr nologging build deferred refresh fast on demand with primary key enable query rewrite as select count(*) compte, count(ECt_MT_VALEUR_ACQUISE) compte_MT_VALEUR_ACQUISE, ECt_DT_ALIM , ECt_ID_PRODUIT, ECt_CD_SERIE , ECt_CD_SOURCE , ECt_CD_AGENCE , ECt_CD_APPORTEUR , ECt_BT_ENCOURS, ECt_CD_ETAT, ECt_BT_VEP, ECt_BT_RPP , ECt_BT_NANTISSEMENT , sum(ECt_MT_VALEUR_ACQUISE) somme_ECt_MT_VALEUR_ACQUISE from admindba.sp_ect_etat_contrat group by ECt_DT_ALIM , ECt_ID_PRODUIT, ECt_CD_SERIE , ECt_CD_SOURCE , ECt_CD_AGENCE , ECt_CD_APPORTEUR , ECt_BT_ENCOURS, ECt_CD_ETAT, ECt_BT_VEP, ECt_BT_RPP , ECt_BT_NANTISSEMENT ; --- Ranganath K [EMAIL PROTECTED] a crit: Hi Stephane, Could you send me the Create materialized view statement so that I can have a look at it. Regards, Ranganath -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of paquette stephane Sent: Friday, April 13, 2001 7:55 PM To: Multiple recipients of list ORACLE-L Subject: Fwd: Materialised view I've sent that mail days ago with no feedback, Oracle Support hasn't been able help, anybody ? On Oracle 816/Solaris 5.7, I'm trying to refresh fast a mview without success: ORA-12032. It's a mview with single table aggregate, I've followed all the restrictions in the doc (I'm having a mview log, count is present,... ) I can refresh force but it's doing a complete not a fast refresh. Why ? = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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).
Ability for non DBA user to kill session.
All, Is there a method forallowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Oracle Deployment Engineer (DBA) with Unix Sys Admin
Top-notch company in Denver, Colorado needs an Oracle Deployment Engineer (DBA) who has Unix Systems Administration experience. This organization is not particularily a "button-down" company. The selected candidate will plan and coordinate installations or upgrades of software, provide database layouts, provide configuration planning and performance tuning of customer's system. This position requires travel up to 50%. Local candidates preferred but will consider others. *Requirements: -Selected candidate must have at least 2 years with SUN Admin or HP Sys Admin and Oracle DBA experience. -Must have shell scripting and logical volume experience. -Willingness to travel up to 50% -Looking for assertive, enthusiastic candidates -U.S. citizenship or permanent residency This position is with a Great company offering: * Base salary up to 90K..D.O.E. * The opportunity to become a key member of the team. * Very Interesting project work NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States or need sponsorship. For immediate consideration, please send your resume as an attachment to: Bill Law, Oracle Placement Specialist OraStaff, Inc. Ph: 1-800-549-8502-Please do not call if you need sponsorship Email: [EMAIL PROTECTED] Please use job code:One/Denver/Deploy/Linda We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiitiondescribed above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle's ftp site
Anybody know where oracle has moved (hidden) their ftp address now? What doesn't work: ftp://external-ftp.us.oracle.com ftp://209.246.5.40 ftp://205.227.44.220 ftp://oracle-ftp.oracle.com In case it helps, the error I get says "An error occurred reading the contents of the folder. Make sure the file name is valid and you have permission to access the location specified. Details: The connection with the server was reset." Thanks for any help, Margaret Murray -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret 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:Don't Let Microsoft's Claim of Superior Database Security
Tim, I'll agree, as I remember it the C2 security spec was a farse compared to todays reality. OH, BTW, the first NSA approved database for Confidential and higher data was "Trusted Oracle7". All of the others were only certified for "For Official Use" and lower data. And back in 92 Sql*Server was only 'allowed' for non-mission data within the USAF. Long story, same ending. The only regret, it gives Larry Ellison more reason to keep the cost high. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How does dropping a partition affect the rest of the table?
Stephane, Thanks for your reply. Cherie paquette stephane stephane_paquette@To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.com cc: Sent by: Subject: Re: How does dropping a partition affect the rest of the [EMAIL PROTECTED] table? 04/17/01 08:40 AM Please respond to ORACLE-L If your indexes are local then no problem . If the indexes are global you 'll have to rebuild them . --- [EMAIL PROTECTED] a crit: I've looked through the on-line documentation on dropping partitions but I have not seen the following question specifically addressed: How does dropping a date-range partition affect the rest of the table/partitions? I read that if I drop a partition with a global partitioned index that the entire global index will need to be rebuilt but that's about all I've seen about the affect on the other partitions. Can I drop an unneeded partition on the fly? What is the effect on performance of the rest of the table? Does anything need to be brought offline before I drop the desired partition? Thanks in advance to all you knowledgable partitioners. Cherie Machler Gelco Information Network -- 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). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: stupid DBA
Michael Sun wrote: Peace on earth and de-fragmented Oracle database everywhere. "Peace on earth" was the password from the movie called "Dr. Strangelove", in my opinion one of the best movies ever made. De-fragmented databases are not an issue any more now that we have locally mismanaged tablespaces. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: Urgent - Migration
Thanks for all!! I applied the patch 8.1.6.3.0 and everything was right! Again, thank you! --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- Gilberto Gampert Universidade de Passo Fundo Administrador de Banco de Dados Passo Fundo - RS - Brazil [EMAIL PROTECTED] http://www.upf.tche.br --=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=--==--=--=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gilberto Gampert 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).
current transaction in oracle
hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula 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:32bit v. 64bit Oracle
Since we're talking 32 VS 64 bit, anybody know when Oracle 817 64 bits we'll be available on Solaris ? Oracle.store only shows Oracle 816 64 bit for Solaris. If you do not need to adress a huge SGA, what are the benefits are running Oracle 64bit instead of Oracle 32 bit ? --- [EMAIL PROTECTED] a crit: Connie, 1st, can you have a 32 and 64 bit database on the same machine: Yes we've got two machines working that way with no problems. 2nd, Can you migrate from 32 to 64 bit: Yes via exp/imp. I've tried just mounting the database files with the 64 bit executables the errors are not pretty. It would appear that Oracle does not like the control file the database file headers. Dick Goulet Reply Separator Author: Connie Milliken [EMAIL PROTECTED] Date: 4/12/2001 7:00 PM Can you upgrade an Oracle 8.0.5 32bit database on HPUX11 to Oracle 8.1.6 64bit? Is is possible to have 8.0.5 32 bit and 8.1.6 64 bit on the same box if the box is 64 bit? If you wanted to restore a copy of production to dev and production was 64 bit and dev was 32bit, would you still be able to do the restore (using Veritas Netbackup)? What are the advantages of being 64 bit versus 32 bit? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken 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). ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle's ftp site
ftp://oracle-ftp.oracle.com [EMAIL PROTECTED] 04/17/01 11:00AM Anybody know where oracle has moved (hidden) their ftp address now? What doesn't work: ftp://external-ftp.us.oracle.com ftp://209.246.5.40 ftp://205.227.44.220 ftp://oracle-ftp.oracle.com In case it helps, the error I get says "An error occurred reading the contents of the folder. Make sure the file name is valid and you have permission to access the location specified. Details: The connection with the server was reset." Thanks for any help, Margaret Murray -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret 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: William Beilstein 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).
URGENT: Hot Standby Graceful failover and failback
Good morning everyone, HELP! HELP!!! It's very early in the morning and I'm still struggling with the Oracle Hot Standby - 8.0.5 and 8I. ARGH! Ok, I got the failover going. I can activate the standby database and use it as a normal database. But when I try to turn it into a standby database again and then reactivate it again, it errors out on me. Oracle Support just tells me that I'm not supposed to use it this way. HUH? I'm not trying to put it back in standby mode so I can recover from the original primary database! I want to put it back in standby mode to similulate a total primary site loss. And always have a standby database to activate. Ok, I may be rambling on a bit here. Very tired. So here's what I've done so far: 1. create a hot standby from a primary database 2. activate the hot standby 3. shutdown the new primary and made a backup of the new primary database 4. restart the new primary, created a table and create a standby controlfile 5. shutdown the new primary 6. restore from backup created in step 3, and replaced the current control files with the standby controlfiles created from stop 4 7. mounted the database in standby mode again 8. tried to activate the new standby database but it failed with ORA-1152 and ORA-1110 complaining that the system.dbf is not restored from a sufficiently old backup. Argh! How do we have a continuous failover and failback scenario? Any help would be greatly appreciated. I've just discovered Lawrence To's article on Graceful Switch Over and Switch back as well. The following from page 11 scares me: "Graceful switchover and switchback are not possible when the production database's online redo logs are not accessible. A graceful switchover and switch back is NOT possible whenever a production database or standby database executes one of the following: - alter database open resetlogs or - alter database activate standby database (which does an implicit resetlogs operation)" HUH??? There are certainly times when we have to do a resetlogs. One of the problems our Unix boxes have at the moment is a redo log corruption so there are not choices but to resetlogs. So what does this all mean? That if we resetlogs we can't ever have continuous failover and failback? ARGH!! What am I dealing with here! I need a holiday from this crazy scenario! Ok, please let me know if you've had any success with what I'm describing here. Am I aiming for the impossible? Surely not! Thanks, Leng. = Leng Kaing - [EMAIL PROTECTED] AUSOUG-VIC : http://www.ausoug.org/vic/ _ http://movies.yahoo.com.au - Yahoo! Movies - Now showing: Dude Where's My Car, The Wedding Planner, Traffic.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Leng=20Kaing?= 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:NYTimes.com Article: Myth-Matched Nations
Regrettably I don't recognize the e-mail address, but then I don't recognize too many of them. At any rate, and I do want to keep this short, That's one very good article with words of wisdom for BOTH sides in this war of words. Am I upset with China, no not really. I think the leadership could have been more compliant with international law. Surely they had the right to restrict where that Navy crew ventured on the island, but I don't think they should have demanded an apology right off the bat. They should also have already allowed us access to the aircraft for repairs allowed it to leave, preferably under the control of the crew that brought it in. We did as much for a Russian Bear many years ago. Is not "what is good for the goose also good for the gander"? I regret that the pilot, Wang Wei, did not make it back (GOD give him eternal peace), but I place the blame for that in his lap. He had control of that fighter, and it was his poor judgment that caused the trouble, not anyone else's. Fighter jocks as I recall are somewhat brash people. I know of a couple of incidents that fall into the same category committed by US pilots, like the sky car accident in Italy. Now whereas I really don't want a political discussion to run amok on an Oracle list: Robert, lighten up. You've expressed your opinion, somewhat in a poor location. Some of us agree with you, some don't. That's life. But at least we will always give you the chance to speak your mind. BTW: My compliments to the remainder of the members of the list. No one that I read really flamed Robert or tried otherwise to silence him. Bravo!! Dick Goulet -- 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: Ability for non DBA user to kill session.
Lee, In short, you can't achieve this within Oracle domain short of granting ALTER SYSTEM to user in question or going via PL/SQL procedure owned by other, more protectedschema. However, a tool like TOAD will provide similar capability for you - a user is capable to "cancel" long running queries. I'm guessing that is the desired goal in any case. HTH, Gary Weber -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of lerobe - Lee RobertsonSent: Tuesday, April 17, 2001 11:26 AMTo: Multiple recipients of list ORACLE-LSubject: Ability for non DBA user to kill session. All, Is there a method forallowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
RE: Oracle's ftp site
ftp://external-ftp.us.oracle.com ftp://205.227.44.220 ftp://oracle-ftp.oracle.com These worked for me. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] -Original Message- From: Murray, Margaret [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Subject: Oracle's ftp site Anybody know where oracle has moved (hidden) their ftp address now? What doesn't work: ftp://external-ftp.us.oracle.com ftp://209.246.5.40 ftp://205.227.44.220 ftp://oracle-ftp.oracle.com In case it helps, the error I get says "An error occurred reading the contents of the folder. Make sure the file name is valid and you have permission to access the location specified. Details: The connection with the server was reset." Thanks for any help, Margaret Murray -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret 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: 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).
Re: Meeting at IOUG
I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Meeting at IOUG
I'll be there too! It will be my first visit to IOUG and I'm looking forward to meeting the many folks who have contributed to my knowledge [and amusement] through this List. Even though I don't often post questions, your advise to others have been very useful. Keep up the good work. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 9:15 AM I will be there also. Sandra Arnold DBA Strategic Staffing Solutions -Original Message- Sent: Tuesday, April 17, 2001 7:55 AM To: Multiple recipients of list ORACLE-L Me too, Me too!!! ROR mm Ron Rogers DBA OCP Georgia Lottery Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arnold, Sandra 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: Bill Gentry 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).
db and apps migration
I will be upgrading our database and application server from 8.0.5.2.1 and 11.0.2 to Oracle 8.1.6 and Applications 11.5.3. I understand from reading the upgrade manuals as well as confirming from Oracle support that the database must have a db_block_size of 8k or larger. We are currently setup with a 2k block size which means that we must re-build the database with an 8k or larger block size and the only why of doing that is via exp/imp. Can anyone share their experience with exporting and importing a large database with thousands of objects? We have about 35k objects in the database and a concern of mine is all the invalid objects that could appear after the import. Are there some key areas I can look at to help reduce the time to import as well as limiting the number of invalid objects? thanks in advance...roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson 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: stupid DBA
Michael, I disagree strongly w/ your comments about a peacefully defragemented Oracle database. See the article called "How to Stop Defragmenting and Start Living". Mike From: "Michael Sun" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: stupid DBA Date: Mon, 16 Apr 2001 16:40:48 -0800 Not to add fuel to fire, and I DO wish we kill trees (or electrons) on more enjoyable subjects than geopolitics or racism, however, I have the following to say, as a person of chinese ancestry. 1) As a member of an ethnic group that is still subjected to discrimination in today's America, I denounce every type of racial hatred and discriminatin, be it in the form of KKK's burning crosses or chinese bigotry against other racial groups. I don't fight hate with hate. It is simply wrong. 2) i do NOT agree with a lot of things Chinese government does, and I suspect most chinese people don't either. At least they don't have the right to claim representation from us because they were not free and lawfully elected by the Chinese people in the first place. 3) That, however, doesn't give anybody the right to ridicule me, or chinese people in general, whenever the government acts silly and goofy. Peace on earth and de-fragmented Oracle database everywhere. Michael - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, April 13, 2001 6:45 PM Stupid "BUSH" time! Stupid US people select Bush as president. Stupid DBAs. Stupid job mkt. Stupid software Engineer! I am considering to change to be a nurse associate or something like that. Best wishes! Yours sincerely, Robert Chen ___ Cisco Certified Network Associate Oracle Certified Professional DBA SUN Certified Java Programmer SUN Certified Solaris7 System Administrator SUN Certified Solaris7 Network Administrator - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Friday, April 13, 2001 3:20 PM Hi Kevin, The Database Cache Assistant works fine till it reaches the last part where it tries to export some User data.. The error which it gives is "Unable to export User privileges" and then it fails and moves onto installing other components, I tried to install Oracle DB 8.1.7 and Oracle 9iAS on the same server. The configuration reaches the last part of the Database Cache configuration screen. Moreover once I sucessfully installed Oracle 8.1.6 DB and Oracle 8iAS (Earlier version) on the same server.. Thanks.. Sushant --- Kevin Tsay [EMAIL PROTECTED] wrote: What's the problems you have ? --Kevin -Original Message- Sent: Thursday, April 12, 2001 3:55 PM To: Multiple recipients of list ORACLE-L Hi all, Has anybody installed Oracle Database Cache of Oracle 9iAS sucessfully.. Thanks in advance... Sushant --- TARUN SHARMA [EMAIL PROTECTED] wrote: Hi, Yes u can install oracle 8i DB and 9iAS on the same machine. On Wed, 11 Apr 2001, Seema Singh wrote: Hi DBAs Can I install Db server and Oracle9iAS on same M/C. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: TARUN SHARMA 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
OT - Performance impacts with column and table aliases in SQL Ser
Hello all, I know, I know - An Oracle list. However some of us work with many databases (our shop has Oracle, SQL Server, Adabas, and Sybase), so maybe someone on this list can help. The subject line should give enough info to delete the message if you hate the 'other' databases. I was asked recently if alasing all columns and tables in SQL statements in stored procedures has any performance impacts. I've never noticed any problems using aliases, nor have I seen any reference to performance hits due to using aliases. The app is an MS component design thing in which all the database calls are made from the data tier (VB) to stored procedures in SQL Sever. Any thought on this? Mike Lanteigne The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
server sizing
in gaining knowledge about oracle I've been introduced to some concepts, components, and concerns and I'd like to get some general feedback. so, in general how big of a deal is server design? what would you use as criteria for decision making, like the need for multiple controllers and drive/file system configurations. my background is with ms-sql/nt and we're looking at migrating/upgrading to oracle/nt. we've had success with raid 5 via a single controller with multiple channels. I've been to the oracle dba pt 1a and have been exposed to oracle architecture; we never had such concerns so I have no basis of comparison. our instructor and classmates, while knowledgeable, were more developers than system engineers; whereas we'll be more system engineers/administrators than developers. what kinds of metrics/performance should I be looking at, considering, and shooting for from the start? right now we have about 100 users and a 20G DB which *will* increase to probably 300 users and 40G to 50G DB; on average we're looking at about thirty thousand transactions over an 11 hour period; again that'll probably increase to 70,000 to 80,000 transactions over an 11 hour period. reads/writes/queries/indexes, their size and speed, and other such processing metrics, were never a concern. === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Streeter, Lerone A LBX 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: Ability for non DBA user to kill session.
Create a procedure as SYS (or someone else powerful) which does the 'alter system' and then grant just the proc to the user hth connor --- lerobe - Lee Robertson [EMAIL PROTECTED] wrote: All, Is there a method for allowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Ability for non DBA user to kill session.
I don't think you can kill yourself anymore, at least in 8.1.6. Even as a DBA, Oracle wouldn't let me off myself... Note to ALL: ENOUGH WITH THE POLITICAL CLAPTRAP ALREADY!!! [EMAIL PROTECTED] 04/17/01 11:26AM All, Is there a method for allowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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: Ability for non DBA user to kill session.
Hello, Li, I believe, stored procedure is the best and simplyest way for this purpose. There is nothing wrong giving ALTER SYSTEM to _procedure owner_. End user will be limited to execute this procedure only, and will not require ALTER SYSTEM for him/herself. Best regards, Vadim Gorbounov Oracle DBA -Original Message-From: lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 17, 2001 11:26 AMTo: Multiple recipients of list ORACLE-LSubject: Ability for non DBA user to kill session. All, Is there a method forallowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
rman change delete
how to automate CHANGE BACKUPSET key DELETE ? Any ideas? I'm trying to obtain the backupset key with LIST BACKUPSET, and then, i'll need to make some script to build a rman script with several CHANGE BACKUPSET DELETE statements. Am i wrong? Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Claudio Roca 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: 9iAS -- Boxes on which to run
My experience is that 9iAS requires 1G RAM to run well. More if you want IFS... Given that the typical inexpensive Intel box is capped at 4GB and Microsoft won't let you use more than 3GB (2.5 realistically) on a 4GB machine, or half of your real RAM if you have less than 4GB, and that a typical Oracle DB will want 1 or more GB to perform well, you're out of RAM before you start. Blame it on the JVM... "Eric D. Pierce" wrote: On 13 Apr 2001, at 17:12, [EMAIL PROTECTED] wrote: To: [EMAIL PROTECTED] Copies to: [EMAIL PROTECTED] Date sent: Fri, 13 Apr 2001 17:12:54 -0500 And where did you get the info on 8.1.7 and Forms Server not being able to be on the same NT / W2K machine? Oracle tech support. They were clear (my recollection of verbal phone conversion) that as of 8.1.7, "middle tier" stuff would not run on the same NT server box as the database. They said that I needed to read the (latest?) "middle tier" white papers to understand the new (as of 8.1.7) "middle tier web architectural" issues, which they said are "complex". :) Unfortunately I haven't had time yet. This was in the context of a conversation about a new Win2k server that we are setting Oracle8 up on, and I wanted to know if it was still going to be possible to run the next equivalent to WebDB on the same box as the database. I then siad that it sounded like I was going to have to convert our old Netware3 server to NT (Win/2000) in order to test the 8.1.7 and later "middle tier" web stuff. They said that was correct. so, it was specific answer, not just some general info. Since the documentation you have apparently doesn't cover the issue, you probably ought to call Oracle tech support. I am about to try to install 9iAS on my W2K box at home. I already have 8.1.7 EE, Forms 4.5/5.0/6i, and tons of other stuff installed. I've read through the install guide, the various release notes, etc and never came across that. But, if it is so, I don't intend to waste a perfectly good day trying to get things to work. ya. please let me know what you find out. ep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Further OT: Dr. Strangelove
Or was it "Purity of Essence" Protect your bodily fluids. If you don't get the President on the phone, you'll have to answer to the Coca-Cola Company. A GREAT MOVIE. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] Michael Sun wrote: Peace on earth and de-fragmented Oracle database everywhere. "Peace on earth" was the password from the movie called "Dr. Strangelove", in my opinion one of the best movies ever made. De-fragmented databases are not an issue any more now that we have locally mismanaged tablespaces. -- -- 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).
Re: current transaction in oracle
COLUMN address NOPRINT COLUMN username FORMAT a12 BREAK ON address SKIP 1 SELECT a.address ,sql_text ,osuser ,username FROM v$sqltext a ,v$session s WHERE s.SQL_ADDRESS = a.ADDRESS AND s.status = 'ACTIVE' AND s.type !='BACKGROUND' ORDER BY a.ADDRESS ,a.piece; http://www.itsystems.lv/gints/dba_selects.htm#s2 Gints Plivna srinivas aradhyulaTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ahvsrinivas@cc: yahoo.com Subject: current transaction in oracle Sent by: root@fatcity. com 01.04.17 18:06 Please respond to ORACLE-L hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula 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: current transaction in oracle
Try select * from sys.v_$sqlarea Anthony -Original Message- Sent: Tuesday, April 17, 2001 11:07 AM To: Multiple recipients of list ORACLE-L hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula 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: Hsu, Anthony C., ,CPMS 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: Free Java dba monitoring tool and Java source code
Hi Sam, As part of my masters dissertation I have developed an SQL monitoring tool using Java/JDBC/thin drivers that allows the DBA to see who is taking up the resources currently in a database. This is not at all a commercial venture, purely academic. Plus if you want to learn about Java/JDBC this can be an invaluable asset/starting point as you know the subject well and you can see how the tool has been built. I'd love to see your Java Oracle DBA Open Source tool, up on a public internet site somewhere for download! :-) Some other Java-Oracle type Open Source links you might want to look at, to help further your own work, are: Apache JServ = http://java.apache.org/jserv/index.html DB Prism, Java/Oracle servlet engine = http://www.plenix.com/dbprism/doc/Home.html Tomcat (replacement for JServ) = http://jakarta.apache.org/tomcat/index.html jDBA, another Java Oracle DBA tool = http://www.jdba.org ViennaSQL, Java/Oracle SQL tool = http://vienna.sourceforge.net jDBA may the one you're most interested in, but using Java as the programming language for Open source projects, including Oracle ones, is growing rapidly in popularity! :-) Hope this is of some use 8) Rgds, AndyD = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan 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).
(Fwd) Tar # 1339336.996:run all on one win2000 box: OEM, DB, Forms Web server?
Larry folks, It's taking OWS a while to clarify/answer on the question of running db/oem/forms-server on one NT servre box (originally submitted friday 13th). regards, ep --- Forwarded message follows --- Date sent: 17 Apr 01 10:14:44 To: [EMAIL PROTECTED] Your TAR has been updated and is in XFR (transfer) status. This status indicates that the original group that received your TAR is not the one best suited to handle your problem. The TAR is in the process of being assigned to an analyst in the correct group. Someone from that group will be in contact with you regarding this TAR as soon as it is assigned. If you have resolved the issue in this TAR, please close this TAR using MetaLink ( TARs - TAR Search - Click on the TAR Description link - Close TAR ). The fastest way to create, update and view your TARs is via MetaLink. Simply logon at: http://www.oracle.com/support/metalink/login/ Once you are logged in, select the 'TARs' button on the menu to your left. If you do not already have an account, signing up is easy. Simply go to: http://metalink.oracle.com/register/plsql/registration.step_1 and have your email address and CSI ready to create your accoun --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: URGENT: Hot Standby Graceful failover and failback
I think you may be trying to do a little too much with the current standby architecture. Oracle now has product called Data Guard that will let you do what you want. I've only read the docs on Data Guard, but supposedly you can switch primary and standby database, and switch back without re-creating anything. Good luck Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original Message- From: Leng Kaing [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 12:10 PM To: Multiple recipients of list ORACLE-L Subject: URGENT: Hot Standby Graceful failover and failback Good morning everyone, HELP! HELP!!! It's very early in the morning and I'm still struggling with the Oracle Hot Standby - 8.0.5 and 8I. ARGH! Ok, I got the failover going. I can activate the standby database and use it as a normal database. But when I try to turn it into a standby database again and then reactivate it again, it errors out on me. Oracle Support just tells me that I'm not supposed to use it this way. HUH? I'm not trying to put it back in standby mode so I can recover from the original primary database! I want to put it back in standby mode to similulate a total primary site loss. And always have a standby database to activate. Ok, I may be rambling on a bit here. Very tired. So here's what I've done so far: 1. create a hot standby from a primary database 2. activate the hot standby 3. shutdown the new primary and made a backup of the new primary database 4. restart the new primary, created a table and create a standby controlfile 5. shutdown the new primary 6. restore from backup created in step 3, and replaced the current control files with the standby controlfiles created from stop 4 7. mounted the database in standby mode again 8. tried to activate the new standby database but it failed with ORA-1152 and ORA-1110 complaining that the system.dbf is not restored from a sufficiently old backup. Argh! How do we have a continuous failover and failback scenario? Any help would be greatly appreciated. I've just discovered Lawrence To's article on Graceful Switch Over and Switch back as well. The following from page 11 scares me: "Graceful switchover and switchback are not possible when the production database's online redo logs are not accessible. A graceful switchover and switch back is NOT possible whenever a production database or standby database executes one of the following: - alter database open resetlogs or - alter database activate standby database (which does an implicit resetlogs operation)" HUH??? There are certainly times when we have to do a resetlogs. One of the problems our Unix boxes have at the moment is a redo log corruption so there are not choices but to resetlogs. So what does this all mean? That if we resetlogs we can't ever have continuous failover and failback? ARGH!! What am I dealing with here! I need a holiday from this crazy scenario! Ok, please let me know if you've had any success with what I'm describing here. Am I aiming for the impossible? Surely not! Thanks, Leng. = Leng Kaing - [EMAIL PROTECTED] AUSOUG-VIC : http://www.ausoug.org/vic/ __ ___ http://movies.yahoo.com.au - Yahoo! Movies - Now showing: Dude Where's My Car, The Wedding Planner, Traffic.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Leng=20Kaing?= 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: Lanteigne, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 32bit v. 64bit Oracle
Stephen, Last time I checked Metalink (couple of weeks ago), 8.1.7 64-bit status was "projected" with Sun Sparc Solaris. I filled out a TAR asking when it will be certified, and they told me to check Metalink (even offered me walk me though the web pages)! Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original Message- From: paquette stephane [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Subject: Re:32bit v. 64bit Oracle Since we're talking 32 VS 64 bit, anybody know when Oracle 817 64 bits we'll be available on Solaris ? Oracle.store only shows Oracle 816 64 bit for Solaris. If you do not need to adress a huge SGA, what are the benefits are running Oracle 64bit instead of Oracle 32 bit ? --- [EMAIL PROTECTED] a crit : Connie, 1st, can you have a 32 and 64 bit database on the same machine: Yes we've got two machines working that way with no problems. 2nd, Can you migrate from 32 to 64 bit: Yes via exp/imp. I've tried just mounting the database files with the 64 bit executables the errors are not pretty. It would appear that Oracle does not like the control file the database file headers. Dick Goulet Reply Separator Author: Connie Milliken [EMAIL PROTECTED] Date: 4/12/2001 7:00 PM Can you upgrade an Oracle 8.0.5 32bit database on HPUX11 to Oracle 8.1.6 64bit? Is is possible to have 8.0.5 32 bit and 8.1.6 64 bit on the same box if the box is 64 bit? If you wanted to restore a copy of production to dev and production was 64 bit and dev was 32bit, would you still be able to do the restore (using Veritas Netbackup)? What are the advantages of being 64 bit versus 32 bit? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken 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). ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Lanteigne, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman change delete
All of the items are in the tables which underlie the views. Just use sql to delete the items you want. Just be careful! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:51 PM how to automate CHANGE BACKUPSET key DELETE ? Any ideas? I'm trying to obtain the backupset key with LIST BACKUPSET, and then, i'll need to make some script to build a rman script with several CHANGE BACKUPSET DELETE statements. Am i wrong? Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Claudio Roca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: current transaction in oracle
set pagesize 1000 spool actual SELECT SID, TYPE, STATUS, USERNAME, SQL_TEXT, EXECUTIONS, LOCKWAIT, SERVER, OSUSER, PROCESS, MACHINE, TERMINAL, PROGRAM FROM V$SQLAREA, V$SESSION WHERE V$SESSION.SQL_ADDRESS = V$SQLAREA.ADDRESS(+) AND V$SESSION.SQL_HASH_VALUE = V$SQLAREA.HASH_VALUE(+) ORDER BY SID / spool off [EMAIL PROTECTED] 04/17/01 01:25PM Try select * from sys.v_$sqlarea Anthony -Original Message- Sent: Tuesday, April 17, 2001 11:07 AM To: Multiple recipients of list ORACLE-L hi, i am looking for a sql statement which can tell me the current sql running in oracle. TIA Srinivas __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: srinivas aradhyula 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: Hsu, Anthony C., ,CPMS 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: Tim Sawmiller 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).
ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army gov
*** ADMIN WARNING *** Please do not continue ANY discussions about China or the recent aircraft collision incident in this mailing list. There have been quite a few off-topic posts of late, but this is *FAR* off-topic, and is not appropriate for this list. If you want to continue this discussion, contact the original poster directly in private E-mail, or go to a public discussion board elsewhere. Members of this list who continue to respond to the list about such topics risk losing their posting privileges, or perhaps even removal from the list. This is not an attempt to censor any ideas or thought, but rather to keep this list focused on the topic it was set up for, and for which members expect it to be used. There are plenty of appropriate public forums where you can discuss this matter; this is not one of them. thanks, bruce [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bruce Bergman 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: Meeting at IOUG
Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan 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: Meeting at IOUG
Title: RE: Meeting at IOUG I should have know Rachel would get picky. Yes, I mean this Thursday, April 19th, 2001 R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: Meeting at IOUG just to clarify, that's THIS Thursday, right? Not the last day of IOUG :) From: Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Meeting at IOUG Date: Tue, 17 Apr 2001 05:50:50 -0800 I'm going to be there (I better, I'm supposed to be giving four presentations) Also, for anyone in the central Ohio area, on thursday the Ohio Oracle Users group will be meeting at which Gaja and I will both be presenting. See www.ooug.org for more details R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Murali Vallath [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 10:31 PM To: Multiple recipients of list ORACLE-L Subject: Meeting at IOUG Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 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: server sizing
Lerone, My opinion is that your database on an NT platform will not scale as well as you may hope. You are talking about adding 100-150% more data and tripling your users to 300. I would strongly recommend going to a Unix platform for your database. Also, if the database is going to grow that much...it is likely a write intensive application that would perform better on something other than RAID5...maybe RAID0+1. Certainly there are servers that can handle this load...on NT, but if you are going to that large a server...why not go Unix and increase your performance (I know, an NT box costs less...but if cost isn't an issue!?!). That's just my opinion...and I actually started my IT career as an NT Admin! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, April 17, 2001 12:35 PM To: Multiple recipients of list ORACLE-L in gaining knowledge about oracle I've been introduced to some concepts, components, and concerns and I'd like to get some general feedback. so, in general how big of a deal is server design? what would you use as criteria for decision making, like the need for multiple controllers and drive/file system configurations. my background is with ms-sql/nt and we're looking at migrating/upgrading to oracle/nt. we've had success with raid 5 via a single controller with multiple channels. I've been to the oracle dba pt 1a and have been exposed to oracle architecture; we never had such concerns so I have no basis of comparison. our instructor and classmates, while knowledgeable, were more developers than system engineers; whereas we'll be more system engineers/administrators than developers. what kinds of metrics/performance should I be looking at, considering, and shooting for from the start? right now we have about 100 users and a 20G DB which *will* increase to probably 300 users and 40G to 50G DB; on average we're looking at about thirty thousand transactions over an 11 hour period; again that'll probably increase to 70,000 to 80,000 transactions over an 11 hour period. reads/writes/queries/indexes, their size and speed, and other such processing metrics, were never a concern. === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Streeter, Lerone A LBX 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: Meeting at IOUG
HEY! :) Just don't want anyone to be disappointed is all From: "Adams, Matthew (GEA, 088130)" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Meeting at IOUG Date: Tue, 17 Apr 2001 10:45:37 -0800 I should have know Rachel would get picky. Yes, I mean this Thursday, April 19th, 2001 R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: Meeting at IOUG just to clarify, that's THIS Thursday, right? Not the last day of IOUG :) From: "Adams, Matthew (GEA, 088130)" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Meeting at IOUG Date: Tue, 17 Apr 2001 05:50:50 -0800 I'm going to be there (I better, I'm supposed to be giving four presentations) Also, for anyone in the central Ohio area, on thursday the Ohio Oracle Users group will be meeting at which Gaja and I will both be presenting. See www.ooug.org for more details R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Murali Vallath [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 10:31 PM To: Multiple recipients of list ORACLE-L Subject: Meeting at IOUG Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Meeting at IOUG
I nominate Monday evening. That way those of us who don't know anyone will have more familiar faces the rest of the week (especially at the big bash on Tuesday). I don't have a clue where to meet. IOUG veterans any suggestions? Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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: Entity Relationship diagrams Qdesigner using same engine as P
its using the same engine as powerdesigner. whats the gimmick behind this. Story 1. Hack Bill Gates Larry Ellisons bank accounts. 2. Buy Oracle DB source licence from Oracle. 3. Write a Search and Replace globally (s/Oracle/FreeOracle/g) 4. Market FreeOracle Just Daydreaming... -Mandar -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 10:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: Entity Relationship diagrams Here's another to add to the list... and guess what - GASP - it's from Quest!! Another one to add to their growing "Supermarket Shopping List"! I'm getting the scent of CA/Platinum here.. -- Quest Software Announces Release of QDesigner(tm) to Round-Out Comprehensive Development Suite of Products PR News April 16 2001 04:52AM PT QDesigner Provides Efficient Database Analysis, Design and Construction IRVINE, Calif., April 16 /PRNewswire/ -- Quest Software, Inc. (Nasdaq: QSFT), a leading provider of application management solutions, today announced the release of QDesigner(tm), an innovative database design tool that enables users to efficiently manage the process of application design from data and object modeling to code generation, resulting in an enormous time savings for the designers. QDesigner accelerates database design and construction processes through the use of advanced Entity/Relationship (ER) modeling techniques that include the ability to "draw" database models, displaying an actual diagram of the design before it is applied. QDesigner also allows designers, developers and DBAs to visualize database components, so they can collaborate and share ideas on how the database should be structured while it is being designed. "Recently, customers have been asking for more functional database design solutions," said Marshall Senk, vice president of marketing for Quest Software. "With QDesigner, we are ready to meet that demand. We believe the technology that QDesigner provides will allow IT resources to be more efficiently deployed in the database design function. It not only rounds-out Quest's development suite of products, but also provides users with an advanced design and modeling tool." QDesigner automates the process of creating and changing the application components and underlying database structures and is especially useful in environments where applications are utilized by many business units and developed and supported by different portions of the IT organization. "I've been a database administrator and data architect for ten years and have used other design tools, but QDesigner is the first ER tool I've found that provides such comprehensive design and analysis capabilities," said Donna Maser, database administrator for the Celltech Group, one of Europe's largest biopharmaceutical companies(1). "QDesigner delivers all the positive features of its competitors and more. It is the first product of its kind that can provide me with usable code directly from the model I lay out." QDesigner joins Quest Software's solutions for SQL developers, SQL Navigator and TOAD, which have been designed to enhance the productivity of users and their applications by providing tools for designing, developing, testing and impact analysis. QDesigner is now generally available with pricing starting at $995 per server. More reasonable than ERWin as well I should think.. Regards Mark -Original Message- stephane Sent: Tuesday, April 17, 2001 02:41 To: Multiple recipients of list ORACLE-L I do not know of any good modeling tool for free, they all charge $$$. I found it a bit strange that you have all the physical layout done then want to do an entity- relationship diagram after... --- Ranganath K [EMAIL PROTECTED] a crit: Dear DBA Gurus, I have around 30 tables for which the columns, datatypes, size of each datatype, referential integrity constraints is decided. I need to draw E-R diagram linking each table with one or many tables. I am looking for a tool which will draw the diagram for me if I provide the column names, its datatypes, referential integrity constraints etc. Is there any free tool which will do this for me? If not, how do I do this? Any URLs or links or documents will be very much helpful. Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail
Re: Meeting at IOUG
Margaritas? I'm there :) Ari D Kaplan wrote: Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan 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: SuzyV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army
Title: RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army gov Wow, I guess Jared was fired, eh? ;- == -Original Message- == From: Bruce Bergman [mailto:[EMAIL PROTECTED]] == Sent: Tuesday, April 17, 2001 2:29 PM == To: Multiple recipients of list ORACLE-L == Subject: ADMIN: Off-Topic (was: RE: Do not belive BUSH == and your army == gov == == == *** ADMIN WARNING *** == == Please do not continue ANY discussions about China or == the recent aircraft == collision incident in this mailing list. There have == been quite a few == off-topic posts of late, but this is *FAR* off-topic, == and is not appropriate == for this list. If you want to continue this discussion, == contact the == original poster directly in private E-mail, or go to a == public discussion == board elsewhere. Members of this list who continue to == respond to the list == about such topics risk losing their posting privileges, == or perhaps even == removal from the list. == == This is not an attempt to censor any ideas or thought, == but rather to keep == this list focused on the topic it was set up for, and == for which members == expect it to be used. There are plenty of appropriate == public forums where == you can discuss this matter; this is not one of them. == == thanks, == bruce == [EMAIL PROTECTED] == == == -- == Please see the official ORACLE-L FAQ: http://www.orafaq.com == -- == Author: Bruce Bergman == INET: [EMAIL PROTECTED] == == Fat City Network Services -- (858) 538-5051 FAX: == (858) 538-5051 == San Diego, California -- Public Internet access / == Mailing Lists == - == --- == To REMOVE yourself from this mailing list, send an E-Mail message == to: [EMAIL PROTECTED] (note EXACT spelling of == 'ListGuru') and in == the message BODY, include a line containing: UNSUB ORACLE-L == (or the name of mailing list you want to be removed == from). You may == also send the HELP command for other information (like == subscribing). ==
Anyone out there using CA/Platinum's PR_OEE Tool?
Title: Anyone out there using CA/Platinum's PR_OEE Tool? I'd like to ask a question of you offline ( only b/c it is likely an extremely niche-y product. ) TIA, Ross
RE: OPS waits
O.P.S. Setup in Benchmark Runs :- -- 2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6 3rd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6 Transaction Volume - ALL the Following 4 Sets Fired CONCURRENTLY(At the SAME Time) :- 1) From 1st Digital APP Server (Digital) onto 1st DB Server - 9,000 Transactions using 350 Concurrent Processes fired 2) From 1st APP Server (Digital) onto 2nd DB Server - 9,000 Transactions using 350 Concurrent Processes fired 3) From 2nd APP Server ( SUN )onto 1st DB Server - 7,000 Transactions using 250 Concurrent Processes fired 4) From 3rd SUN APP Server ( SUN ) onto 2nd DB Server - 7,000 Transactions using 250 Concurrent Processes fired TOTAL = 16,000 Transactions Fired on EACH DB Server using 600 Concurrent processes Grand Total (Overall Picture)= 32,000 Transactions using 1200 Concurrent Processes report.txt :- SVRMGR Rem System wide wait events for non-background processes (PMON, SVRMGR Rem SMON, etc). Times are in hundreths of seconds. Each one of SVRMGR Rem these is a context switch which costs CPU time. By looking at SVRMGR Rem the Total Time you can often determine what is the bottleneck SVRMGR Rem that processes are waiting for. This shows the total time spent SVRMGR Rem waiting for a specific event and the average time per wait on SVRMGR Rem that event. SVRMGR select n1.event "Event Name", 2 n1.event_count "Count", 3 n1.time_waited "Total Time", 4 round(n1.time_waited/n1.event_count, 2) "Avg Time" 5from stats$event n1 6where n1.event_count 0 7order by n1.time_waited desc; Event Name Count Total TimeAvg Time - - - SQL*Net message from client5997869 22790881838 row cache lock 51420 1009555 19.63 buffer busy due to global cache 125239984724 7.86 PX Idle Wait 3034592902195.42 enqueue 39427558395 14.16 global cache cr request 224608251426 1.12 global cache lock null to x 55634240560 4.32 latch free 170235172573 1.01 global cache lock open x 46776124447 2.66 Qs. Do these Waits' VALUES seem Excessive ? If so What may be Done to Overcome them ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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: Meeting at IOUG
Anybody knows what is a Pleasure Island event? Alex Hillman -Original Message- Sent: Tuesday, April 17, 2001 2:54 PM To: Multiple recipients of list ORACLE-L Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
Re: Meeting at IOUG
sounds good to me any others? From: Ari D Kaplan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Meeting at IOUG Date: Tue, 17 Apr 2001 10:53:57 -0800 Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Service does not start
Hi! I'm having a problem with Oracle on Win2k here. I can't start Oracle by using the Management Console (i.e. start the windows Service). The Service remains in the status "starting" but never goes to "started". Then I can't even stop the service again. Not with the tool neither with the command line. I can start the database using SVRMGRL / SQLPLUS, but the Windows Service still doesn't start. Seems weird to me. Any ideas? This is 8.1.6.3.0 on Win2k Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army
Bruce runs fatcity Jared monitors this particular list no one was fired From: "Mohan, Ross" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your "army" Date: Tue, 17 Apr 2001 11:15:32 -0800 Wow, I guess Jared was fired, eh? ;- == -Original Message- == From: Bruce Bergman [mailto:[EMAIL PROTECTED]] == Sent: Tuesday, April 17, 2001 2:29 PM == To: Multiple recipients of list ORACLE-L == Subject: ADMIN: Off-Topic (was: RE: Do not belive BUSH == and your "army" == gov == == == *** ADMIN WARNING *** == == Please do not continue ANY discussions about China or == the recent aircraft == collision incident in this mailing list. There have == been quite a few == off-topic posts of late, but this is *FAR* off-topic, == and is not appropriate == for this list. If you want to continue this discussion, == contact the == original poster directly in private E-mail, or go to a == public discussion == board elsewhere. Members of this list who continue to == respond to the list == about such topics risk losing their posting privileges, == or perhaps even == removal from the list. == == This is not an attempt to censor any ideas or thought, == but rather to keep == this list focused on the topic it was set up for, and == for which members == expect it to be used. There are plenty of appropriate == public forums where == you can discuss this matter; this is not one of them. == == thanks, == bruce == [EMAIL PROTECTED] == == == -- == Please see the official ORACLE-L FAQ: http://www.orafaq.com == -- == Author: Bruce Bergman == 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). == _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Meeting at IOUG
I'm a first timer too. Monday night sounds good. Jim Howerton Senior Oracle DBA University of Alabama at Birmingham Health System Information Services e: [EMAIL PROTECTED] v: 205-934-9111 f: 205-934-0632 [EMAIL PROTECTED] 4/17/01 10:41:39 AM I'll be there too! It will be my first visit to IOUG and I'm looking forward to meeting the many folks who have contributed to my knowledge [and amusement] through this List. Even though I don't often post questions, your advise to others have been very useful. Keep up the good work. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 9:15 AM I will be there also. Sandra Arnold DBA Strategic Staffing Solutions -Original Message- Sent: Tuesday, April 17, 2001 7:55 AM To: Multiple recipients of list ORACLE-L Me too, Me too!!! ROR mm Ron Rogers DBA OCP Georgia Lottery Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arnold, Sandra 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: Bill Gentry 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: James Howerton 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).
fwd: 20 Differences Between Oracle on NT and Oracle on Unix
Doc ID: Note:45967.1 Subject: 20 Differences Between Oracle on NT and Oracle on Unix Type: FAQ Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 02-JUL-1997 Last Revision Date: 09-APR-2001 20 DIFFERENCES BETWEEN ORACLE ON WINDOWS NT AND ORACLE ON UNIX == PURPOSE === This note enumerates the 20 most obvious differences between (Oracle on) Unix and NT. SCOPE APPLICATION === This note is directed towards dba's and system engineers with either a moderate knowledge of (Oracle on) NT or Unix. RELATED NOTES = [NOTE:46001.1] : Oracle and the Windows NT memory architecture [NOTE:46053.1] : Windows NT Memory Architecture Overview 1. AVAILABILITY Windows NT has been existence since 1993. It runs on two processor architectures: Intel X86 (needs Pentium) and Digital Alpha AXP. The Windows NT operating system is only available from Microsoft. UNIX has been in existence since 1972: previous versions did exist, but they were written in PDP assembly language, rather than C. UNIX runs on most hardware architectures and versions are supplied by many vendors, most notably Sun, HP, IBM, Digital, Sequent, Data General, NCR and SCO. 2. SECURITY Windows NT 3.5 has been evaluated successfully at U.S. Department of Defense C2 security level (TCSEC class C2 rating). A utility on the Windows NT Resource kit, C2 Configuration/Security Manager, reports the state of compliance of the relevant features, such as whether the last username is displayed at logon. As of 2000.07.25 NT 4.0 does not have a TCSEC class C2 rating. For Microsoft's own statement about this, see: http://www.microsoft.com/NTServer/security/exec/feature/c2_security.asp Some specialised UNIX variants support the B1 level of security. 3. USER INTERFACE Windows NT has a common graphical user interface across architecture types. The interface changed between NT 3.51 and NT 4.0 from Windows 3.11 style to Windows 95/98 style. Many UNIX versions have an X-Windows type of user interface, the appearance varying between flavours. Linux in particular offers a number of GUI interfaces, including Windows look-alikes. However, most UNIX commands are still character mode terminal based. 4. NUMBER OF DISK DRIVES Windows NT is limited to using drive letters A-Z, though use of raw partitions can allow disks to be divided up into smaller sections (see question 17). UNIX has no built-in limitation on number of disk drives. 5. BACKGROUND PROCESSING AND BATCH JOBS NT only has the AT command. An easier-to-use GUI version may be found on the Resource Kit. UNIX has more sophisticated job control mechanisms. 6. RECOMPILATION NT applications only require recompiling if moved to a different architecture, e.g. Intel to Alpha. UNIX applications require recompiling if moved to a different platform, e.g. HP to IBM RS/6000. They also need recompiling for different UNIX releases on the same platform. 7. SCALABILITY Standard Windows NT currently scales effectively to four CPUs, though some manufacturers have recently announced eight-way systems. UNIX scales to at least 64 CPUs. 8. NUMBER OF SESSIONS Windows NT supports only a single interactive GUI session, unless Microsoft Terminal Server, RAS or a third-party tool is used. UNIX supports hundreds of interactive GUI or character mode sessions. 9. APPLICATION AVAILABILITY Several thousand applications are available specifically for Windows NT. It can also run many of the thousands of 16-bit Windows applications. Third-party products allow some UNIX applications to be run, though the greatest interest is the other way, enabling Windows NT applications to run under UNIX variants, especially Linux. Some public domain software is available for Windows NT. There are many thousands of UNIX applications on the market. A large amount of public domain software is also available. Emulation software, available for many flavours of UNIX, allows many 16-bit Windows applications to be run. 10. FILESYSTEM TYPES AND CAPABILITIES Windows NT supports two filesystems - FAT and NTFS. Oracle software and datafiles can be installed on either type, with the following provisos: Security - FAT filesystem has no file-level security - Once a user is connected to the NT server, they have full access to any FAT file (i.e. they can delete or overwrite the file) - NTFS filesystem has file-level security Once a user is connected to an NT server, they must then have access to a file to be able to access it. NT files can only have a single
Re: Meeting at IOUG
No offence to anyone but I enjoy being the designated driver. I have a good sense of humor and a great time at any get-together. Any location that the group can centrally find is ideal. ROR mm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: server sizing
I'm envisioning various levels of raid just wanted to get something out quick for some feedback. for example, I'm thinking the data files, redo logs, arc log, and control files would be on differently combined disks. of course some file system recovery and redundancy is desired, but to what level should we go? currently we've got a raid1 set w/ O/S and documents, raid5 with hot spares for our existing mssql DB, and the logs on separate raid5 set; wanted raid1 for mssql logs but other issues arose and we had to go w/ raid5. this is very functional and suits our needs, failure coverage, low processor utilization, etc. but with oracle I'd be very worried about running on a similarly built platform. I didn't even mention raw partitions, which were stressed as being a better scenario. they offered the suggestion of multiple controllers with database files spread across drives and controllers, this method of "striping" being an alternative to raid. I wasn't too comfortable with the thought of a server w/ raw partitions and no hardware redundancy/recovery implementation, but the performance/functionality benefits were highly praised. so I thought maybe a mix, some raid10 or 01. maybe a raid1 set containing O/S, arc, and control files, a number of raid0 sets with redo logs stripped across them, and a raid5 set with the data files. then there's the issue of storage, what capacity to shoot for as well as memory; currently we've got 1.2Gs of RAM and I'd shoot for at least twice that. why NT? familiarity and comfort. we've asked and everyone doted on oracle's ability to run on NT just as well as *nix and being that we have 0 *nix boxes mgmt of course wanted NT. we looked for support in having oracle on *nix but found none and accepted the offering. thanks for the feedback. I'm hoping some others will offer suggestions or comments, support, or horror stories to help me in gathering information. I don't know if the additional processing will burden the system based on drive configuration/file system choices. I don't know if a couple of controllers or several will be required, just trying to get an idea of what exists. we haven't purchased any hardware yet but we need to get an idea soon. thanks again for the feedback, and forgive my ramblings. === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 2:59 PM To: Multiple recipients of list ORACLE-L Lerone, My opinion is that your database on an NT platform will not scale as well as you may hope. You are talking about adding 100-150% more data and tripling your users to 300. I would strongly recommend going to a Unix platform for your database. Also, if the database is going to grow that much...it is likely a write intensive application that would perform better on something other than RAID5...maybe RAID0+1. Certainly there are servers that can handle this load...on NT, but if you are going to that large a server...why not go Unix and increase your performance (I know, an NT box costs less...but if cost isn't an issue!?!). That's just my opinion...and I actually started my IT career as an NT Admin! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Tuesday, April 17, 2001 12:35 PM To: Multiple recipients of list ORACLE-L in gaining knowledge about oracle I've been introduced to some concepts, components, and concerns and I'd like to get some general feedback. so, in general how big of a deal is server design? what would you use as criteria for decision making, like the need for multiple controllers and drive/file system configurations. my background is with ms-sql/nt and we're looking at migrating/upgrading to oracle/nt. we've had success with raid 5 via a single controller with multiple channels. I've been to the oracle dba pt 1a and have been exposed to oracle architecture; we never had such concerns so I have no basis of comparison. our instructor and classmates, while knowledgeable, were more developers than system engineers; whereas we'll be more system engineers/administrators than developers. what kinds of metrics/performance should I be looking at, considering, and shooting for from the start? right now we have about 100 users and a 20G DB which *will* increase to probably 300 users and 40G to 50G DB; on average we're looking at about thirty thousand transactions over an 11 hour period; again that'll probably increase to 70,000 to 80,000 transactions over an 11 hour period. reads/writes/queries/indexes, their size and speed, and other such processing metrics, were never a concern. === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Streeter, Lerone A
RE: Meeting at IOUG
Pleasure Island is one of the Disney resorts From: "Hillman, Alex" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Meeting at IOUG Date: Tue, 17 Apr 2001 11:28:21 -0800 Anybody knows what is a Pleasure Island event? Alex Hillman -Original Message- Sent: Tuesday, April 17, 2001 2:54 PM To: Multiple recipients of list ORACLE-L Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan 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
RE: Oracle Service does not start
See note 132086.1 on Metalink. -Original Message- Sent: Tuesday, April 17, 2001 3:02 PM To: Multiple recipients of list ORACLE-L Hi! I'm having a problem with Oracle on Win2k here. I can't start Oracle by using the Management Console (i.e. start the windows Service). The Service remains in the status "starting" but never goes to "started". Then I can't even stop the service again. Not with the tool neither with the command line. I can start the database using SVRMGRL / SQLPLUS, but the Windows Service still doesn't start. Seems weird to me. Any ideas? This is 8.1.6.3.0 on Win2k Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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: Kuan, Amy M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT: Hot Standby Graceful failover and failback
Hello Leng, 1. create a hot standby from a primary database 2. activate the hot standby 3. shutdown the new primary and made a backup of the new primary database 4. restart the new primary, created a table and create a standby controlfile 5. shutdown the new primary 6. restore from backup created in step 3, and replaced the current control files with the standby controlfiles created from stop 4 7. mounted the database in standby mode again 8. tried to activate the new standby database but it failed with ORA-1152 and ORA-1110 complaining that the system.dbf is not restored from a sufficiently old backup. I thought you were supposed to do a hot backup of a new primary and restore it to the old primary. After that, mount the old primary as a new standby. Argh! How do we have a continuous failover and failback scenario? Any help would be greatly appreciated. I've just discovered Lawrence To's article on Graceful Switch Over and Switch back as well. The following from page 11 scares me: "Graceful switchover and switchback are not possible when the production database's online redo logs are not accessible. A graceful switchover and switch back is NOT possible whenever a production database or standby database executes one of the following: - alter database open resetlogs or - alter database activate standby database (which does an implicit resetlogs operation)" HUH??? There are certainly times when we have to do a resetlogs. One of the problems our Unix boxes have at the moment is a redo log corruption so there are not choices but to resetlogs. So what does this all mean? That if we resetlogs we can't ever have continuous failover and failback? Yes, it is correct. If you reset logs or loose the redo logs, forget about "graceful switchover". ARGH!! What am I dealing with here! I need a holiday from this crazy scenario! Ok, please let me know if you've had any success with what I'm describing here. Am I aiming for the impossible? Surely not! I am sorry to admit, but you are :-) So far at 8.1.7 we have only the "graceful switchover", awfully well described in Lawrence To's article. HTH, Michael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Netrusov 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: Meeting at IOUG
I'm open at 8 monday evening. Sounds good to me. Terry Ari D Kaplan wrote: Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan 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: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
Re: Meeting at IOUG - LOCATION CONFIRMATION
Since I started this thread. Let me call for a closer. I think this suggestion is great. Let confirm this. Murali Vallath Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 17 Apr 2001 10:53:57 -0800 Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan 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: Meeting at IOUG
What is a "... Island" event? Looks like my e-mail system does not like first word. Alex Hillman -Original Message- Sent: Tuesday, April 17, 2001 2:54 PM To: Multiple recipients of list ORACLE-L Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City
RE: Meeting at IOUG
thanks, but what the activities will be? Alex Hillman -Original Message- Sent: Tuesday, April 17, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Pleasure Island is one of the Disney resorts From: "Hillman, Alex" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Meeting at IOUG Date: Tue, 17 Apr 2001 11:28:21 -0800 Anybody knows what is a Pleasure Island event? Alex Hillman -Original Message- Sent: Tuesday, April 17, 2001 2:54 PM To: Multiple recipients of list ORACLE-L Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan 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
Re: Meeting at IOUG
I love a good margarita (or two). Sounds like a good idea. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:53 PM Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Stephen Andert [EMAIL PROTECTED] 04/16 8:15 PM don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali Vallath" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meeting at IOUG Date: Mon, 16 Apr 2001 18:30:43 -0800 Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Stephen Andert 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: Ari D Kaplan 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
Metalink error
Please forward tuning suggestions for the following problem to Oracle Support. It looks like they may still need a little help with Metalink! Gary Tue, 17 Apr 2001 21:02:34 GMT ORA-04031: unable to allocate 2550012 bytes of shared memory ("large pool","unknown object","session heap","bind var buf") DAD name: plsql PROCEDURE : ml2_gui.startup USER : gsibd2 URL: http://web120.us.oracle.com:80/metalink/plsql/ml2_gui.startup PARAMETERS : ENVIRONMENT: PLSQL_GATEWAY=WebDb GATEWAY_IVERSION=2 SERVER_SOFTWARE=Oracle HTTP Server Powered by Apache/1.3.12 (Unix) ApacheJServ/1.1 mod_perl/1.24 GATEWAY_INTERFACE=CGI/1.1 SERVER_PORT=80 SERVER_NAME=web120.us.oracle.com REQUEST_METHOD=GET QUERY_STRING= PATH_INFO=/metalink/plsql/ml2_gui.startup SCRIPT_NAME=/metalink REMOTE_HOST= REMOTE_ADDR=208.168.16.140 SERVER_PROTOCOL=HTTP/1.0 REQUEST_PROTOCOL=HTTP REMOTE_USER= HTTP_CONTENT_LENGTH= HTTP_CONTENT_TYPE= HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0) HTTP_HOST=metalink.oracle.com HTTP_ACCEPT=*/* HTTP_ACCEPT_ENCODING=gzip, deflate HTTP_ACCEPT_LANGUAGE=en-us HTTP_ACCEPT_CHARSET= HTTP_COOKIE=ORA_UCM_AGID=%2fMP%2f8MrVGNK%40Uk%40q%3f%3fBlBoFS Authorization=Basic Z3NpYmQyOmRiaXNnMg== HTTP_IF_MODIFIED_SINCE= HTTP_REFERER= -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kirsh, Gary 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).
Strange Oracle8 varchar2 behaviour.
I am connected to an Oracle8 Database on Windows NT SP5, we have a table with a column of datatype varchar2(4), however its length is reported as 5. Any reason/s as to why this is happening? I have done a describe and a select of the table below. Any help would be appreciated. Thanks, Susan. Connected to: Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production SQL desc instruments NameNull?Type --- INSTR_ID VARCHAR2(18) INSTR_NUMBER VARCHAR2(4) INSTR_RECEIVEDDATE DATE INSTR_ACTIVE CHAR(1) INSTR_DESCRIPTIONVARCHAR2(500) INSTR_AMENDRREVOCREFNO VARCHAR2(10) INSTR_FILENETID VARCHAR2(15) INSTR_TYPE VARCHAR2(4) INSTR_TRANSIDVARCHAR2(18) INSTR_VERIFIED CHAR(1) INSTR_VERIFIEDDATE DATE INSTR_PAYMENTCHAR(1) SQL select instr_id, instr_number, LENGTH(INSTR_NUMBER) 2 from instruments 3 where instr_id like 'BS19981972%'; INSTR_ID INST LENGTH(INSTR_NUMBER) -- BS199819720046 D 005 BS199819721057 D 005 BS199819722068 D 005 BS199819723079 D 005 BS199819724080 D 005 BS199819725091 D 005 BS199819726002 D 005 BS199819727013 D 005 BS199819728024 D 005 BS199819729035 D 005 10 rows selected. SQL SQL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Susan Trumpet 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: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army
Title: RE: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army Yes, but who watches the watchdogs? G == -Original Message- == From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] == Sent: Tuesday, April 17, 2001 4:06 PM == To: Multiple recipients of list ORACLE-L == Subject: RE: ADMIN: Off-Topic (was: RE: Do not belive == BUSH and your == army == == == Bruce runs fatcity == == Jared monitors this particular list == == no one was firednow, shut the hell up. ==
move schema away from system table space
Hi All, I need to move a user/schema away from the system tablespace to a newly created user tablespace. Could somebody point me to the references on how to do the job? Since a production server is running off the schema, is it possible to do the move without having to shut down the server? Thanks a lot. WL __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lwm 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: Meeting at IOUG
On Tue, 17 Apr 2001,Hillman, Alex scribbled on the wall in glitter crayon: -Anybody knows if one need to rent a car there? - -Alex Hillman if you are staying at the host hotels, then no... you can get anywhere on the disney property via bus and fairly quickly. if, lik me, you are staying at a different disney hotel, you can still use the bus system to get around, but they don't start running until 9AM so to get to the morning stuff, you'll need to take a taxi. -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You forgot to do your backup 16 days ago. Tomorrow you will need that version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: warning glitches netiquette/ RE: ADMIN: Off-Topic (was: R
Title: In retrospect, I should have made my wink alot larger.Maybe like: ;- well, that's about all for now. Those rotten Republican, F-8 flying, Chinese, Microsoft lovers can all go to heck in a handbasket! == -Original Message-== From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]== Sent: Tuesday, April 17, 2001 4:17 PM== To: Multiple recipients of list ORACLE-L== Subject: warning glitches "netiquette"/ RE: ADMIN:== Off-Topic (was: RE:== Do not belive MUSH and your "popcorn"== Comrads, amigos kindred beings in this universe, (and/or other temporal/spatial/mystical/imaginal realities),== Well... no, er... maybe who knows.? Bruce is the guy that owns Listguru/Fatcity. Oracle-L is== only one of== many lists operated by Listguru/Fatcity. Jared moved== Oracle-L to== Listguru/Fatcity a while ago, so Oracle-L is== (conceptually?) still== "owned" by Jared, but he relies on Bruce to enforce list== policies. Sorta like "logical" database design and "physical"== database design. Besides the more or less usual list rules (for== unmoderated lists)== that were carried over from the "old" Oracle-L== (@suny.edu) days, and== a few things along the lines of his own personal== preferences/etc.== (the more or less defunct ban on politically incorrect== humor), Jared== is going to develop and promulgate list rules/policies== in conjunction== with the requirements feedback of the== owner/administrator (Bruce)== of the system hosting the list. Having been involved (as "moderator", "owner", etc.) for several== years in a variety of different lists, some of which get quite== controversial, and having been threatened with lawsuits== when people== get really upset over such silly garbage on such lists, I have== noticed that even when a list== administrator/owner/moderator calls a== thread off, it can sometimes takes hours, or even a few== days, for it== to actually stop. In some cases this isn't necessarily because people are== flaunting the== rules and continuing to violate the administrator's warning, but== because they are just responding to earlier messages,== having not yet== seen (or perhaps even received in the case of mail== delivery lags on== some systems) the warning from the administrator yet. regards,== ep On 17 Apr 2001, at 11:15, Mohan, Ross wrote:== Wow, I guess Jared was fired, eh?== == ;-== ...== --== Please see the official ORACLE-L FAQ: http://www.orafaq.com== --== Author: Eric D. Pierce== 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: 32bit v. 64bit Oracle
Last I heard from Oracle was May 4th for release of 64-bit 817 for Solaris. HTH Gerardo -Original Message- Sent: Tuesday, April 17, 2001 8:15 AM To: Multiple recipients of list ORACLE-L Since we're talking 32 VS 64 bit, anybody know when Oracle 817 64 bits we'll be available on Solaris ? Oracle.store only shows Oracle 816 64 bit for Solaris. If you do not need to adress a huge SGA, what are the benefits are running Oracle 64bit instead of Oracle 32 bit ? --- [EMAIL PROTECTED] a crit: Connie, 1st, can you have a 32 and 64 bit database on the same machine: Yes we've got two machines working that way with no problems. 2nd, Can you migrate from 32 to 64 bit: Yes via exp/imp. I've tried just mounting the database files with the 64 bit executables the errors are not pretty. It would appear that Oracle does not like the control file the database file headers. Dick Goulet Reply Separator Author: Connie Milliken [EMAIL PROTECTED] Date: 4/12/2001 7:00 PM Can you upgrade an Oracle 8.0.5 32bit database on HPUX11 to Oracle 8.1.6 64bit? Is is possible to have 8.0.5 32 bit and 8.1.6 64 bit on the same box if the box is 64 bit? If you wanted to restore a copy of production to dev and production was 64 bit and dev was 32bit, would you still be able to do the restore (using Veritas Netbackup)? What are the advantages of being 64 bit versus 32 bit? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken 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). ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Molina, Gerardo 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: move schema away from system table space
1. Export the user's schema ( exp help=y ) 2. issue in sqlplus: drop user_name cascade; 3. then remake the user with the new table space as the default tablespace ( all permissions there - none elsewhere ). 4. imp the user from the export dump with ignore=y regards - john f. lewis -Original Message- Sent: Tuesday, April 17, 2001 3:50 PM To: Multiple recipients of list ORACLE-L Hi All, I need to move a user/schema away from the system tablespace to a newly created user tablespace. Could somebody point me to the references on how to do the job? Since a production server is running off the schema, is it possible to do the move without having to shut down the server? Thanks a lot. WL __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lwm 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: John Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: server sizing
And I'm just in the mood for a ramble, too... We stayed with NT too, because we have the sysadmins and engineers already. I have a DB that sounds a lot like yours and it's running just fine on a dual p400 with a mirror for redo and archive log and a raid5 for the data files. The real problem with NT is the memory cap. I couldn't get 4GB at the time of purchase, so we can't use Enterprise server to skew the memory divide, and NT is gobbling up half of my 2GB server. That's fine for 100 users, but as we edge up we're having to reduce buffer cache to avoid paging, which is bad (although admittedly it's not affecting performance yet). When the buying freeze lifts I'll recommend the 4GB upgrade. It wouldn't be so bad, except I had to install the Java engine for this one, and it's taking a good quarter gigabyte. I haven't found the RAID5 to be an operations hazard, though, except in maintenance tasks. Large imports, tablespace reorgs, index rebuilds and sweeping updates suffer but so far the small stuff the application sends in is absorbed by the cache and runs just fine. Of course I'm only running about 10-20 write transactions a minute on the DB in question. If that picks up I'll be back to the funding well for more external arrays. I (personally) would just buy more or better equipment if I needed the small boost that raw partitions would give -- I like the hardware RAID and the OS backup utilities too much to go the raw route. Using more volumes is still a good idea, if you can get them on different controllers, but for goodness' sake don't bother partitioning a RAID. More than 2 channels on a controller may challenge your cache size or bus speeds, so multiple controllers is still a good idea if you can saturate 2 channels. Raid 0+1 makes a difference over raid 5 if you have room in the rack for that many drives, and I'll certainly be doing that if the projects that want the SAN pan out. I keep everything redundant (no raid0) on this class of box, though -- too many things can go wrong, and losing your redo log volume takes your database down. That reminds me of a story -- Last month one of my engineers noticed a warning light that indicated one of the redundant power supplies in a storage array had gone out. He jiggled the power cable. It was the wrong one... The database files were taken offline by that, but it was night and the DB was quiet and fortunately that array had only half of the OS/logging mirror for that server, so Oracle recovered after a quick shutdown-replace-reboot cycle. You specified an upper bound of about 2 transactions per second, which should be doable with an NT system with 300 users. If you go much beyond 300 - 500, however, you'll probably start running into memory/networking performance limits on NT. In general, you should consider UNIX systems for optimum performance. NT has too many little gotchas like the lack of memory and process control. Some, like limits on total memory and practical problems with number of controllers, are related to the Intel architecture so you'll need to look past Linux, although Linux can be a good half-step when your NT boxes start underperforming. In moving to Linux you'd get more available RAM and less OS overhead, but you'll have to completely re-learn system administration and then do it again (incrementally) when you hit the architecture limits, as Linux on other-than-intel architectures is not supported by Oracle. So if there's money I'd look at starting on NT since it's an easy step up, but plan on developing or buying some Sun engineers (or HP, or other) by the time you're ready for those upper limits. They can take you to Ludicrous Speed, but for us mere mortals NT is a good starting point. "Streeter, Lerone A LBX" wrote: I'm envisioning various levels of raid just wanted to get something out quick for some feedback. for example, I'm thinking the data files, redo logs, arc log, and control files would be on differently combined disks. of course some file system recovery and redundancy is desired, but to what level should we go? currently we've got a raid1 set w/ O/S and documents, raid5 with hot spares for our existing mssql DB, and the logs on separate raid5 set; wanted raid1 for mssql logs but other issues arose and we had to go w/ raid5. this is very functional and suits our needs, failure coverage, low processor utilization, etc. but with oracle I'd be very worried about running on a similarly built platform. I didn't even mention raw partitions, which were stressed as being a better scenario. they offered the suggestion of multiple controllers with database files spread across drives and controllers, this method of "striping" being an alternative to raid. I wasn't too comfortable with the thought of a server w/ raw partitions and no hardware redundancy/recovery implementation, but the performance/functionality benefits were highly praised. so I thought maybe a mix, some raid10 or 01.
RE: Ability for non DBA user to kill session.
Hi All, Further to that, it is necessary to use DBMS_SQL or native dynamic SQL for this as PL/SQL does not support ALTER SYSTEM directly. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 18 April 2001 3:37 To: Multiple recipients of list ORACLE-L Create a procedure as SYS (or someone else powerful) which does the 'alter system' and then grant just the proc to the user hth connor --- lerobe - Lee Robertson [EMAIL PROTECTED] wrote: All, Is there a method for allowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but all of these appear to rely on granting the alter system role to the user. Oracle 8.0.5.0.0 Compaq Tru64 4.0f Regards Lee Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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 Adams 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: move schema away from system table space
Best way is to use export/import utilities. This can be done with server on line and you will get all table data if done at quite time when table is not being updated. See Oracle Backup and Recovery Guide for info on exp/imp. PA -Original Message- Sent: Tuesday, April 17, 2001 3:50 PM To: Multiple recipients of list ORACLE-L Hi All, I need to move a user/schema away from the system tablespace to a newly created user tablespace. Could somebody point me to the references on how to do the job? Since a production server is running off the schema, is it possible to do the move without having to shut down the server? Thanks a lot. WL __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lwm 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: Patricia Ashe 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).
Java Programmer just getting started with Oracle......
Hello. I'm new to Oracle and am looking for some "guru" guidance on some resources to tap in order to get up to speed (preferrably quickly). I'm a Java programmer looking to start getting into building applications backended by Oracle. I am comfortable with Java (including JDBC) and SQL. I have experience with other database systems (Progress, PostgreSQL, MySQL) but am a total newbie to Oracle. I'm not looking to become an Oracle DBA but as an application programmer there is certainly some level of DBA skills needed as well as an overall understanding of how the backend system works in order to do my job affectively. I recently read and did all associated exercises in the "Oracle8i for Linux Starter Kit" which definitely gave me a nice overview and hands on practice of using the Oracle system. The book was good as a "starter kit" (just as the title states) and now I am looking to get some more depth. My questions to the list are: 1. How much of an "Oracle DBA" do I need to be in order to write affective applications using Oracle and Java? 2. Any good books that you would recommend (that you have read)? I have thought that my next purchase would be "Oracle DBA 101": http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0072121203vm= or "Oracle Essentials: Oracle8 and Oracle8i": http://www.oreilly.com/catalog/oressentials/ I am assuming that after getting somewhat more familiar with Oracle and the basics of Oracle Administration, a good book to move on to would be the big fat Wrox Press book on Oracle8i Application Programming: http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=1861004842vm= Any advice or comments that you can offer would be greatly appreciated. Thanks. --tom. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tom panzarella 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).
(Fwd) Tar # 1339336.996:run all on one win2000 box: OEM, DB, Forms web server
Larry folks, Still not sure what it all means! They don't seem to be able to answer specifically on Forms *Server* for some reason. I'll continue asking tomorrow. regards, ep --- Forwarded message follows --- 1339336.996 Open Date 14-APR-01 00:45:05 Support Identifier xxx Last Update 17-APR-01 20:08:12 Product Oracle Server - Enterprise Edition Product Version 8.1.7 Platform MS Windows 2000 Abstract run all on one win2000 box: OEM, DB, Forms web server ? Resolution History 14-APR-01 00:45:06 GMT ... ### Please describe your problem:### Can all three run on one win2000 box: OEM, DB, Forms web server ? What I need is a statement elaborating on the same issues as raised in tar #123 1449.996 My recollection of what I was told on the phone during discussion of the issues in tar #123 1449 .996 was that as of db v 8.1.7, it is not possible torun the db and forms web server on the same win2000 box. I hope I'm not confusing something, e.g., what was actually said previously was that you [*]can't[*] run the db v 8.1.7 and *OEM* on the same win2000 box. Please provide info on pertinent notes, white papers, etc., if possible. Thanks! Eric email:[EMAIL PROTECTED] (or phone 916-278-7586 if that is easier/ more appropriate) ### If you are receiving errors, please list exact error messages and text:### giant juicy chocolate chip peanut butter cookies!!! ... ### What is the impact to your business becauseof this problem? ### planning Contact me via : E-mail - [EMAIL PROTECTED] --- 14-APR-01 01:26:16 GMT I think for the forms server / database running on the same box , the best group to talk to would be the forms group. xfr dataserver - forms --- 15-APR-01 06:07:51 GMT Forms 6.0.8.10.3 (Patch 1), 6.0.8.11.3 (Rel 2), 6.0.8.12.1(Patch 3A), 6.0.8.13, (Patch 4) are certified for windows 2000. forms 6.0.8.12.1 (Patch 3) has been withdrawn for the 8.1.7 database. The check any other certified products for oracle you can go to metalink.oracle.com Then go to product lifcycle and certifications the verify and product certifications for any platform. @scl --- 16-APR-01 19:03:12 GMT New info : Uh can somone explain how that "answer" was related to the original question (see subject line), or what it means otherwise? Better yet, please look up the name of the analyst who called me on tar #1231449.996, and have her contact me again to clarify the issue. Thanks, Eric email: [EMAIL PROTECTED] ph# (916) 278-7586 --- 17-APR-01 15:21:34 GMT Your tar has been assigned to an analyst --- 17-APR-01 18:50:28 GMT OEM 2.2 and 8.1.7 enterprize editions can live together on the same machine in the same Oracle_home. Developer 6i can reside on the same machine but has to be installed into a seperate oracle home. Intelegent agent comes with 8.1.7 and does not need to be installed from OEM. Hope this helps. --- 17-APR-01 19:33:08 GMT New info : Thanks for letting me know that OEM and DB can run on the same box. I don't think I would want to run Developer6i (to develop a form) on the same server box, but I would want to use the "webified" version of such a form on the same box. So, part of the original question remains: can the Forms *web* server run on the same box as DB (/or OEM)? In the previous tar, I was told (verbally) that it is *not* possible to run the equivalent of WebDB and DB8.1.7on the same box, but I wanted "written" clarification of that point. As you might notice if you read the previous tar on this subject, I'm not currently using these products (and therefor may not be using the precise terminology that Oracle Tech Support is comfortable with), we are doing design and capacity planning for a small application, and I want to know if I will need more than one NT server to implemented a "webified" database/forms implementation, v8.1.7. My recollection is that with DB8.1.6, and earlier, with WebDB/etc., it was possible to run on one server box, but that as of DB8.1.7, the product that replaces WebDB (OiAS) can *NOT* run on the same box as the DB/OEM. I need some oneto tell me if that is correct, or not, or to request additional clarification. Thanks, Eric email: [EMAIL PROTECTED]
Re: Locally Managed Tablespaces
Patricia, FWIW, We have been using them for several months now and have not seen anything negative as a result. We decided to start using them for all new tablespaces and we add a new set of tablespaces every month to accomodate our partitioning strategy. Our biggest databases that we are doing this with are over 200MB on Compaq Tru64. Database version was 8.1.6.0 and we have moved to 8.1.6.2 with no noted problems. Good luck. Stephen [EMAIL PROTECTED] 04/17 4:35 PM I am interested in some statistics on Oracle locally managed tablespaces. I have been looking for any bugs or negative info about them. Are they in use at alot of sites? Seems like all the information I have come across is positive. Which is great! But maybe they aren't being used at alot of sites. Can I hear about experiences from others on this list? how many sites are actually using them? I have several databases that I am getting ready to go production soon and would like to create the tablespaces as locally managed, but need more statistics. PA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Patricia Ashe 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: Stephen Andert 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).
Synonym on Standby Database
Has anyone tried to use their standby database as a read-only database through db links and mapped to synonyms? I'm having problems creating one (12145 e.g.) and am now wondering whether it is even possible. This is to alleviate the downtime in the event of single table failures in production and have the app point to the standby for reading while we fix it. The application is coded to transparently handle the write errors. [EMAIL PROTECTED] _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Lau 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: ADMIN: Off-Topic (was: RE: Do not belive BUSH and your army
On Tuesday 17 April 2001 12:15, Mohan, Ross wrote: Wow, I guess Jared was fired, eh? ;- Hardly. Of course, I must consider the source of this comment. Jared -- 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).