OT : Basic Critical O.S. Values that Trigger Problem Alert
Hi We are Trying to make a General Document to be forwarded to Customers which should allow them to know when they are performing far below normal At the Operating System Level we are trying to Identify Practical Critical Values which when below respective Threshold Limits which would give the alert about a potential problem . We are Looking for these in Areas of :- 1) Network Thruput 2) Memory Utilization 3) Swap Utilization 4) IO Utilization Would apreciate actual Commands used (preferably those Generic across different O.S.) respective Critical Threshold Limit Values for the Above EXAMPLE For Network thruput Between APPLICATION Server machine Database Server Machine what , by experience , are the parameters their respective Minimum threshold Values which would let us know that there is a Severe problem therein ? NOTE - We have generally been measuring this by Manually ftping a Big File , about 100MB , between APP DB Server machines , noting the thruput Displayed in (kbytes/s) on Completion Converting this Value to Mega Bits / Second (i.e. MBPS) . If this Value is Less than 40MBPS for a 100 MBPS Cable we know there is a PRoblem with Network Bandwidth. Miscellaneous - Some Threshold Limits known to us :- Command - vmstat 5 3 Virtual Memory Statistics: (pagesize = 8192) procs memorypagesintr cpu r w u act free wire fault cow zero react pin pout in sy cs us sy id 3 1K 34 266K 84K 32K 811M 132M 339M 635 193M0 188 28K 1K 16 7 77 3 1K 33 267K 84K 32K 410 71 151 0 1310 494 2K 4K 4 2 93 3 1K 36 269K 82K 32K 5459 1720 807 0 30160 471 3K 4K 37 5 58 1) Utilization of CPU due to Operating System (Internal) Operations (%sy) Exceeding Utilization due to user Applications (%us) 2) Average Wait of CPU for IO to Complete (%wio) Greater than () 30 % [ From sar Command ] 3) Utilization of CPU due to Operating System (Internal) Operations (%sy) 30 % 4) CPU Utilization - If Total CPU Utilization Consistently Near 0% Idle Or further Coupled with any of the following :- a)Abnormally High Wait for IO ( 30 %) [ From sar Command ] b)Abnormally High Operating System CPU Utilization ( 30 %) c)Abnormally High Run Queue [r (3 * Number of CPUs)] THANKS -- 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).
open cursors problem
Hi everyone, I am running EJB under weblogic 5.1 jdbc 2.0, and when I last checked the database the number of open cursors was 564. I know 8.1.7 has a cap of 750 open cursors after which the db will crash. Since this is the first time I have faced this problem I would be grateful if anyone could point out what could be the possible areas that could cause this problem ( other than the logical one of not closing cursors once they have been opened and used !). any help here would be appreciated. thank you, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'Mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RAC related info
Hi, everyone! Does anybody have links related to 9i RAC on Tru unix? Advices, trick'n'tips, FAQ's, case studies... Beside technet and metalink, of course. Thank you in advance, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-07217 sltln: environment variable cannot be evaluated
Hi, I am getting the following error while connecting to sqlplus. ORA-07217 sltln: environment variable cannot be evaluated I have set the export ORACLE_BASE=/ora export ORACLE_HOME=$ORACLE_BASE/817 export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib what can be the problem.. regards, vijay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vijaya Chander V.S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-07217 sltln: environment variable cannot be evaluated
Hi Is the ORACLE_HOME really 817 (I usually have 8.1.7) Jack Vijaya Chander V.S To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] srinivasa_v@infocc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) sys.com Subject: ORA-07217 sltln: environment variable cannot be evaluated Sent by: [EMAIL PROTECTED] 29-07-2002 11:19 Please respond to ORACLE-L Hi, I am getting the following error while connecting to sqlplus. ORA-07217 sltln: environment variable cannot be evaluated I have set the export ORACLE_BASE=/ora export ORACLE_HOME=$ORACLE_BASE/817 export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib what can be the problem.. regards, vijay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vijaya Chander V.S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and
Changing the character set of a database
Hi , We presently have a database with "EE8ISO8859P2" character set . Can I change it to the US7ASCII char set? Learnt from the documentation that if the current character set is a subset of the character set you want to change to , Oracle does allow that. But the question is whether US7ASCII is a subset of "EE8ISO8859P2" TIA.. Regards Niamath
Re: Install Oracle 8i on Windows XP?
Eric, thank you for your illuminating notes on the reason they hate us. blowing steamJust two points: 1)A few days ago a bomb explode in India killing 50 people. I did not heard ANY remarks from anybody condemning this. 2) All the people who cry for the Palestinians and demand they should have their own country does not give a shit about the Curds (for example) who are in worse condition. The Europe countries are basing their policy on Jew hating. /blowing steam Yechiel AdarMehish ISRAEL - Original Message - From: Eric D. Pierce To: Multiple recipients of list ORACLE-L Sent: Monday, July 29, 2002 7:03 AM Subject: Re: Install Oracle 8i on Windows XP? Absurd. Your intention from the beginning was to be a snobby jerk. http://www.weeklystandard.com/Content/Public/Articles/000/000/001/102gwtnf.asp Among the Bourgeoisophobes Why the Europeans and Arabs, each in their own way, hate America and Israel. by David Brooks 04/15/2002, Volume 007, Issue 30 AROUND 1830, a group of French artists and intellectuals looked around and noticed that people who were their spiritual inferiors were running the world. Suddenly a large crowd of merchants, managers, and traders were making lots of money, living in the big houses, and holding the key posts. They had none of the high style of the aristocracy, or even the earthy integrity of the peasants. Instead, they were gross. They were vulgar materialists, shallow conformists, and self-absorbed philistines, who half the time failed even to acknowledge their moral and spiritual inferiority to the artists and intellectuals. What's more, it was their very mediocrity that accounted for their success. Through some screw-up in the great scheme of the universe, their narrow-minded greed had brought them vast wealth, unstoppable power, and growing social prestige. Naturally, the artists and intellectuals were outraged. Hatred of the bourgeoisie became the official emotion of the French intelligentsia. Stendhal said traders and merchants made him want to "weep and vomit at the same time." Flaubert thought they were "plodding and avaricious." Hatred of the bourgeoisie, he wrote, "is the beginning of all virtue." He signed his letters "Bourgeoisophobus" to show how much he despised "stupid grocers and their ilk." Of all the great creeds of the 19th century, pretty much the only one still thriving is this one, bourgeoisophobia. Marxism is dead. Freudianism is dead. Social Darwinism is dead, along with all those theories about racial purity that grew up around it. But the emotions and reactions that Flaubert, Stendhal, and all the others articulated in the 1830s are still with us, bigger than ever. In fact, bourgeoisophobia, which has flowered variously and spread to places as diverse as Baghdad, Ramallah, and Beijing, is the major reactionary creed of our age. This is because today, in much of the world's eyes, two peoples--the Americans and the Jews--have emerged as the great exemplars of undeserved success. Americans and Israelis, in this view, are the money-mad molochs of the earth, the vulgarizers of morals, corrupters of culture, and proselytizers of idolatrous values. These two nations, it is said, practice conquest capitalism, overrunning poorer nations and exploiting weaker neighbors in their endless desire for more and more. These two peoples, the Americans and the Jews, in the view of the bourgeoisophobes, thrive precisely because they are spiritually stunted. It is their obliviousness to the holy things in life, their feverish energy, their injustice, their shallow pursuit of power and gain, that allow them to build fortunes, construct weapons, and play the role of hyperpower. And so just as the French intellectuals of the 1830s rose up to despise the traders and bankers, certain people today rise up to shock, humiliate, and dream of destroying America and Israel. Today's bourgeoisophobes burn with the same sense of unjust inferiority. They experience the same humiliation because there is nothing they can do to thwart the growing might of their enemies. They rage and rage. Only today's bourgeoisophobes are not just artists and intellectuals. They are as likely to be terrorists and suicide bombers. They teach in madrassas, where they are careful not to instruct their students in the sort of practical knowledge that dominates bourgeois schools. They are Muslim clerics who incite hatred and violence. They are erudite Europeans who burn with humiliation because they know, deep down, that both America and Israel possess
RE: Substraction SQL query
Hi Manoj, Again thanks a lot for your help! Regards, Jonny [EMAIL PROTECTED] wrote: i/p data-table : x_tests_sum timestamp2150 7/26/02 1:13:47 AM 2162 7/26/02 1:15:01 AM2170 7/26/02 1:16:27 AM2200 7/26/02 1:20:34 AM Solution :select a.s_sum - b.s_sum s_sum,a.timestampfrom x_test a,x_test b where (a.s_sum b.s_sum)and b.s_sum =(select max(s_sum)from x_testwhere s_sum a.s_sum) or rownum = 1o/p data :s_sum timestamp0 7/26/02 1:13:47 AM12 7/26/02 1:15:01 AM8 7/26/02 1:16:27 AM30 7/26/02 1:20:34 AM-Original Message-From: jonny99delmont [mailto:[EMAIL PROTECTED]]Sent: Friday, July 26, 2002 7:13 PMTo: ORACLE-LCc: jonny99delmontSubject: Substraction SQL query File: Substraction SQL query.HTM ! ! Get a bigger mailbox -- choose a size that fits your needs.http://uk.docs.yahoo.com/mail_storage.html
RE: Changing the character set of a database
Niamath, Metalink has a technical note (119164.1) which shows which character sets are valid for the ALTER DATABSE CHARACTER SET command. This indicates that you won't be able to change the character set. Regards, Mike Hately, Oracle DBA -Original Message-From: Niamath [mailto:[EMAIL PROTECTED]]Sent: 29 July 2002 11:08To: Multiple recipients of list ORACLE-LSubject: Changing the character set of a database Hi , We presently have a database with "EE8ISO8859P2" character set . Can I change it to the US7ASCII char set? Learnt from the documentation that if the current character set is a subset of the character set you want to change to , Oracle does allow that. But the question is whether US7ASCII is a subset of "EE8ISO8859P2" TIA.. Regards Niamath This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.
Oracle Version Numbers Explained
There was some discussion recently (in the thread on Apache and iAS) on version numbers of Oracle and how confusing they have become. Here is a document that explains the version numbers, at least for the RDBMS. It lost it's authorship along the way, so forgive me for not crediting it. If you have ever wondered what an Oracle release number really means; included below is the break down and how to find out what you are running via a query against a Data Dictionary view. It has changed a little starting with Release 9.2. For the Release number: 9.2.0.1.0 , the significance of each number (reading from left to right) is shown below: Number Significance__ 9 1 Major database release number 2 1 Database maintenance release number 0 1 Application server release number 1 1Component specific release number 0 1Platform specific release number ( Starting with release 9.2, maintenance releases of Oracle are denoted by a change to the second digit of a release number. In previous releases, the third digit indicated a particular maintenance release.) Major Database Release Number This is the most general identifier. It represents a major new edition (or version) of the software that contains significant new functionality. Database Maintenance Release Number This digit represents a maintenance release level. Some new features may also be included. Application Server Release Number This digit reflects the release level of the Oracle9i Application Server (Oracle9iAS). Component Specific Release Number This digit identifies a release level specific to a component. Different components can have different numbers in this position depending upon, for example, component patch sets or interim releases. Platform Specific Release Number This digit identifies a platform specific release. Usually this is a patch set. Where different platforms require the equivalent patch set, this digit will be the same across the effected platforms. How to Check Your Current Release Number: To identify the release of the Oracle database server that is currently installed and to see the release levels of other Oracle components you are using, query the Data Dictionary view PRODUCT_COMPONENT_VERSION. Here is a sample query. (Yes, the old instructor part of me wants your Sql*Plus session to be readable, so included are 3 Sql*Plus commands before the query since each of these column widths are 65.:-) ) COL PRODUCT FORMAT A40 COL VERSIONFORMAT A15 COL STATUS FORMAT A15 SELECT * FROM PRODUCT_COMPONENT_VERSION; PRODUCTVERSION STATUS --- --- NLSRTL 9.2.0.1.0 Production Oracle9i Enterprise Edition 9.2.0.1.0 Production PL/SQL 9.2.0.1.0 Production TNS for Solaris: 9.2.0.1.0 Production Optionally, you can query against the V$VERSION view to see component-level information as well. (Other product release levels may increment independently of the database server.) Regards, Chris Gait -- 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: open cursors problem
WHAT! A cap of 750 open cursors in the database? Where did you hear that? -Original Message- Sent: Monday, July 29, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Hi everyone, I am running EJB under weblogic 5.1 jdbc 2.0, and when I last checked the database the number of open cursors was 564. I know 8.1.7 has a cap of 750 open cursors after which the db will crash. Since this is the first time I have faced this problem I would be grateful if anyone could point out what could be the possible areas that could cause this problem ( other than the logical one of not closing cursors once they have been opened and used !). any help here would be appreciated. thank you, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'Mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Toepke, Kevin 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).
Replication - truncate not propagating
Hi! I have noticed something... Deletes are propagating from master site to the snapshots. Everything works like charm, as it is supposed. But... truncate of master table IS NOT seen in snapshot table. I don't really expect snapshot to be truncated, of course, but I expect it to be empty (trunace is essentially delete). So, is this bug or feature? What is logic behind it, if it is feature?
import question
Hi, We are importing a large amount of data and uit is generating a huge amount of redo..is there any way of avoiding this- unfortunately this is on an 8.0.6 database?? Any help/advice would be appreciated!! Rgds FAwzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Are you qualified?
$35k only! That wouldn't even PAY for all the certifications they request! -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of ltiu [EMAIL PROTECTED] Sent: Sunday, July 28, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: Are you qualified? It did not mention how much is the pay? How much should this type of job pay though? ltiu On Sunday 28 July 2002 08:18, Gesler, Rich wrote: no way! It's all mine...you'll have to find this gem yourself ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Install Oracle 8i on Windows XP?
Please end this thread and/or take it off the list... Thank you. --- Yechiel Adar [EMAIL PROTECTED] wrote: Eric, thank you for your illuminating notes on the reason they hate us. blowing steam Just two points: 1) A few days ago a bomb explode in India killing 50 people. I did not heard ANY remarks from anybody condemning this. 2) All the people who cry for the Palestinians and demand they should have their own country does not give a shit about the Curds (for example) who are in worse condition. The Europe countries are basing their policy on Jew hating. /blowing steam Yechiel Adar Mehish ISRAEL __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: open cursors problem
I think the problem is that that's the value in the init.ora file for his database, NOT the limit of Oracle itself. According to the docs, the maximum number of open cursors you can allow in 8.1.7 AND 9.2 is 1 to 4294967295 (4 GB -1). And that limit is for each individual user, not cumulative total for the database. so the crash may be that the parameter is set to 750 in the initialization file for that database, in which case, if you hit it then you need to raise that number in the init.ora and bounce the database. If that's not the problem, then I would seriously review my code. Why ANY individual user would have that many open cursors in a single session is something to check. Usually means the app is written not to clean up after itself. There IS a limit to how much memory you can use before the machine hangs itself with constant swapping. I had one like that in 7.3.4, the programmers never bothered to explicitly close the cursors when done, they let it default to when the session was ended, the end users would click open new sessions without closing down old ones. We finally set open_cursors to 1000 and let it fail, to teach the end-users to close windows. Why didn't the programmers rewrite the code? Damagement there decided that the programmers knew better than the DBA about how things should work in conjunction with the database. And, of course, fixing bad code doesn't show as progress on status reports. --- Toepke, Kevin M [EMAIL PROTECTED] wrote: WHAT! A cap of 750 open cursors in the database? Where did you hear that? -Original Message- Sent: Monday, July 29, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Hi everyone, I am running EJB under weblogic 5.1 jdbc 2.0, and when I last checked the database the number of open cursors was 564. I know 8.1.7 has a cap of 750 open cursors after which the db will crash. Since this is the first time I have faced this problem I would be grateful if anyone could point out what could be the possible areas that could cause this problem ( other than the logical one of not closing cursors once they have been opened and used !). any help here would be appreciated. thank you, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'Mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Toepke, Kevin 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Creating a **DEFAULT** database
Title: RE: Creating a **DEFAULT** database Are you trying to connect as the Oracle software owner? Also, what's the OS? -Original Message- From: Mranalini Shetty [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 27, 2002 7:44 AM To: Multiple recipients of list ORACLE-L Subject: Re: Creating a **DEFAULT** database Hi, Forgot to mention the error msg that I get on connecting using just the username -- ORA-01034: ORACLE NOT AVAILABLE Thanks and Regards, Mranalini Mranalini Shetty wrote: Hi, Our new database is behaving a little strange. Both our Oracle Server and Client are on the same machine but while connecting through the Client I need to specify username@database_name. The same does not happen when I run sqlplus, sqlplus scott/tiger works. The variable ORACLE_SID is appropriately set, it's pointing to the new database name. The new database is mounted and the listener services are up. Someone kind of hinted that the database is created as a remote database. Can I check what it currently is ... I mean a default one / remote. We didn't face this problem with the old database. On comparing the initSID.ora files we found that the new database did not have the db_domain name set. We tried setting this in the init file (was done after the database was created). Would help if I got some hint on where and what to look for. Thanks and Regards, M Shetty -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mranalini Shetty INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mranalini Shetty INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Replication - truncate not propagating
Vladimir, When a table is truncated, its snapshot log is also truncated. If the PURGE SNAPSHOT LOG option is specified, the snapshot log is purged along with the master table. If you specify the PRESERVE SNAPSHOT LOG option or no option, the information in the master table's snapshot log is preserved, but current ROWID snapshots can use the log for a fast refresh only after a complete refresh has been performed. This is the default. Alessandro Guimares - Original Message - From: Vladimir Barac To: Multiple recipients of list ORACLE-L Sent: Monday, July 29, 2002 5:23 AM Subject: Replication - truncate not propagating Hi! I have noticed something... Deletes are propagating from master site to the snapshots. Everything works like charm, as it is supposed. But... truncate of master table IS NOT seen in snapshot table. I don't really expect snapshot to be truncated, of course, but I expect it to be empty (trunace is essentially delete). So, is this bug or feature? What is logic behind it, if it is feature?
RE: Are you qualified?
sounds like a new project manager - Rachel, is this the guy you are dealing with? ;) -Original Message- Sent: Monday, July 29, 2002 9:03 AM To: Multiple recipients of list ORACLE-L $35k only! That wouldn't even PAY for all the certifications they request! -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of ltiu [EMAIL PROTECTED] Sent: Sunday, July 28, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: Are you qualified? It did not mention how much is the pay? How much should this type of job pay though? ltiu On Sunday 28 July 2002 08:18, Gesler, Rich wrote: no way! It's all mine...you'll have to find this gem yourself ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to FULLY audit a schema?
Title: Message I have one main schema (ldgadmin) in my database (9.0.1.3)that I want to FULLY audit. I want to know everything about itinserts, grants, connects, everything. I have already run the following commands: sql audit all by ldgadmin; sql audit all privileges by ldgadmin; When I look at sys.aud$ I see most of my commands are audited, yet, when I grant all on ldgadmin.emp to ldgtest I don't see a record. I must not be fully auditing the schema. Anyone know what I am missing? Thanks, Tom
Select Query - Help required
Gurus, Please read the following problem and help me if you have any solution. Select product_id from tname where id = 2; Product_ID -- A B C D But I want the output as follows: Select product_id from tname where id = 2; Product ID - ABCD. Thanks in advance. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: open cursors problem
Gavin - This topic came up a few weeks ago on this list. It that case the Oracle limit being reached was the number of processes. The answer was that connection pooling is configured in weblogic properties. The three parameters to review are: initialCapacity, maxCapacity, capacityIncrement. Separately I am sending you the document where I captured the entire discussion. You can also find documents at http://www.weblogic.com. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 29, 2002 2:38 AM To: Multiple recipients of list ORACLE-L Hi everyone, I am running EJB under weblogic 5.1 jdbc 2.0, and when I last checked the database the number of open cursors was 564. I know 8.1.7 has a cap of 750 open cursors after which the db will crash. Since this is the first time I have faced this problem I would be grateful if anyone could point out what could be the possible areas that could cause this problem ( other than the logical one of not closing cursors once they have been opened and used !). any help here would be appreciated. thank you, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'Mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: open cursors problem
Dennis William sent me a mail containing the discussions on this same topic a couple of weeks back. That discussion layed the blame a bit on the database config parameters in the weblogic properties file like initialCapacity, maxCapacity, capacityIncrement Is this really the case ? or just developer error of not closing the prepared statements ? Gavin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 6:43 PM I think the problem is that that's the value in the init.ora file for his database, NOT the limit of Oracle itself. According to the docs, the maximum number of open cursors you can allow in 8.1.7 AND 9.2 is 1 to 4294967295 (4 GB -1). And that limit is for each individual user, not cumulative total for the database. so the crash may be that the parameter is set to 750 in the initialization file for that database, in which case, if you hit it then you need to raise that number in the init.ora and bounce the database. If that's not the problem, then I would seriously review my code. Why ANY individual user would have that many open cursors in a single session is something to check. Usually means the app is written not to clean up after itself. There IS a limit to how much memory you can use before the machine hangs itself with constant swapping. I had one like that in 7.3.4, the programmers never bothered to explicitly close the cursors when done, they let it default to when the session was ended, the end users would click open new sessions without closing down old ones. We finally set open_cursors to 1000 and let it fail, to teach the end-users to close windows. Why didn't the programmers rewrite the code? Damagement there decided that the programmers knew better than the DBA about how things should work in conjunction with the database. And, of course, fixing bad code doesn't show as progress on status reports. --- Toepke, Kevin M [EMAIL PROTECTED] wrote: WHAT! A cap of 750 open cursors in the database? Where did you hear that? -Original Message- Sent: Monday, July 29, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Hi everyone, I am running EJB under weblogic 5.1 jdbc 2.0, and when I last checked the database the number of open cursors was 564. I know 8.1.7 has a cap of 750 open cursors after which the db will crash. Since this is the first time I have faced this problem I would be grateful if anyone could point out what could be the possible areas that could cause this problem ( other than the logical one of not closing cursors once they have been opened and used !). any help here would be appreciated. thank you, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'Mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Toepke, Kevin 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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:
Transfering data from DB2 to Oracle
We have an application which will require us to reload some Oracle tables on a regular basis from a main frame DB2 database. Management does not want to spring for the cost of any connectivity tools. Short of the obvious dump-to-a-text-file/input-with-sqlldr appoach, is there any other way to do this? thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: import question
If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. While Export it just bypasses the SQL Evaluation buffer,make it faster and directly put things in TTC buffer recognized by Import of Oracle If that option was not selected, frequent commit would enable the checkpoint more often and thus LGWR writing the buffers to redo logs more often. Enable a buffer size which could be substantial high, so that more number of rows could be extracted from the Export file in an array thus boosting the perf. Thanks Vikas Khanna -Original Message- Sent: Monday, July 29, 2002 5:58 PM To: Multiple recipients of list ORACLE-L Hi, We are importing a large amount of data and uit is generating a huge amount of redo..is there any way of avoiding this- unfortunately this is on an 8.0.6 database?? Any help/advice would be appreciated!! Rgds FAwzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Vikas Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Transfering data from DB2 to Oracle
I've done db to db transfers using either 1) Perl/DBI - db to db - select from first, insert into second 2) Perl/DBI - select from first, create file for SQL*Loader, load into Oracle using SQL*Loader I've usually found #2 to be quicker...usually... -Joe --- Schauss, Peter [EMAIL PROTECTED] wrote: We have an application which will require us to reload some Oracle tables on a regular basis from a main frame DB2 database. Management does not want to spring for the cost of any connectivity tools. Short of the obvious dump-to-a-text-file/input-with-sqlldr appoach, is there any other way to do this? thanks, Peter Schauss __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Are you qualified?
nah, at least then he'd have some idea of how Oracle works :) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: sounds like a new project manager - Rachel, is this the guy you are dealing with? ;) -Original Message- Sent: Monday, July 29, 2002 9:03 AM To: Multiple recipients of list ORACLE-L $35k only! That wouldn't even PAY for all the certifications they request! -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of ltiu [EMAIL PROTECTED] Sent: Sunday, July 28, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject:Re: Are you qualified? It did not mention how much is the pay? How much should this type of job pay though? ltiu On Sunday 28 July 2002 08:18, Gesler, Rich wrote: no way! It's all mine...you'll have to find this gem yourself ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Transfering data from DB2 to Oracle
If I were you I would talk to that management. We had a Mainframe DB2 database that needed to have shadow tables created on Oracle. What we ended up doing was to get Oracles Gateway for RDB which allowed us to create queries on Oracle that accessed data on the mainframe DB2. We even went one step further and bought their Replication Services Package (not sure they offer it any more). This package , in conjunction with IBM's data propagator, allowed us to create scheduled update jobs that used the logs created on DB2 to update the Oracle tables. Instead of getting Rep Services and Data Propogator, you could build your own queries that pull data to the Oracle tables thru the gateway. (But you will still need a way to tell that the data has changed on DB2). My advice talk to management. Talk them into at least getting the gateway. -Original Message- Sent: Monday, July 29, 2002 9:08 AM To: Multiple recipients of list ORACLE-L We have an application which will require us to reload some Oracle tables on a regular basis from a main frame DB2 database. Management does not want to spring for the cost of any connectivity tools. Short of the obvious dump-to-a-text-file/input-with-sqlldr appoach, is there any other way to do this? thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cursor Sharing .... Continued
I believe that you need OPTIMIZER_MODE=CHOOSE as well. From the bug: SQL alter session set cursor_sharing=force; . Session altered. . SQL create table tb1 (f1 number(4)); . Table created. . SQL insert into tb1 values (1999); . 1 row created. . SQL insert into tb1 values (2000); . 1 row created. . SQL insert into tb1 values (2001); . 1 row created. . SQL insert into tb1 values (2002); . 1 row created. . SQL commit; . Commit complete. . SQL select * from tb1; . F1 -- 1999 2000 2001 2002 . SQL analyze table tb1 compute statistics; . Table analyzed. . SQL select f1 from tb1 where f1 between 2000 and 2000; . F1 -- 2000 . SQL select f1 from tb1 where f1 between 2000 and 2001; . F1 -- 2000 . SQL select f1 from tb1 where f1 between 2001 and 2000; . F1 -- 2001 HTH! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Binley Lim [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 8:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: Cursor Sharing Continued Rich, you don't mind providing more info on 2225065 ? You mean its not even fixed in 8.1.7.4 ? Can you provide a bit more on the circumstances under which it occurs? [EMAIL PROTECTED] 07/27/02 04:09a.m. * * * HAPPY DBA/SA APPRECIATION DAY!!! * * * Beware of ORA-600, ORA-7445, and incorrect results w/CS=F on 8i! I've got it on 8.1.7.2 and we live with the possibilities. I get the most ORA-7445s when doing queries on the DD. This supposedly gets better with 8.1.7.3 and .4. We've also got one app that consistently returned WRONG results with CS=F (BUG 2225065). Tbe only workaround available is to turn it off for that app or upgrade to 9i. HTH! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:09 PM To: Multiple recipients of list ORACLE-L Subject: Cursor Sharing Continued Setting it to Force worked well as the pool has been cleared on many queries using literals any many of those hard parses went away. So far ... So good. I aint sayin nothin to the developers although some have already noticed an improvement. I am going to put the hammer down on them to rewrite those literals. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Replication - truncate not propagating
Take a look in the docs at the syntax: truncate table tablename preserve/purge snapshot log; The SNAPSHOT LOG clause lets you specify whether a snapshot log defined on the table is to be preserved or purged when the table is truncated. This clause allows snapshot master tables to be reorganized through export/import without affecting the ability of primary-key snapshots defined on the master to be fast refreshed. To support continued fast refresh of primary-key snapshots, the snapshot log must record primary-key information. PRESERVE Specify PRESERVE if any snapshot log should be preserved when the master table is truncated. This is the default. this is why you are not seeing the truncate being replicated PURGE Specify PURGE if any snapshot log should be purged when the master table is truncated -Joe --- Vladimir Barac [EMAIL PROTECTED] wrote: Hi! I have noticed something... Deletes are propagating from master site to the snapshots. Everything works like charm, as it is supposed. But... truncate of master table IS NOT seen in snapshot table. I don't really expect snapshot to be truncated, of course, but I expect it to be empty (trunace is essentially delete). So, is this bug or feature? What is logic behind it, if it is feature? __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ONLINE index creation in 8.1.7.2
Hi all, Has anyone experienced problems using the ONLINE option to create an index on a production 8.1.7.2 DB (HP/UX 11.0, if that matters)? I need to create a largish (for us -- ~300 MB) index on an audit table, but I don't want to lock it while the index is created. I've heard of bugs using ONLINE with indexes and am being paranoid, as usual. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Another one in 8.1.7.2
Automatic tuning = false Adaptive PQ = false drop table j1; drop table j2; create table j1 ( c1 number ); create table j2 ( c1 number ); insert into j1 values (1); insert into j1 values (1); insert into j1 values (2 ); insert into j2 values (3); insert into j2 values (3); commit; select a.c1,a.s1,b.c1,b.s1 from (select --+ parallel(j1,10) c1,count(*) s1 from j1 group by c1) a, (select --+ parallel(j2,10) c1,count(*) s1 from j2 group by c1) b where a.c1 = b.c1 (+); Here is the result: C1 S1 C1 S1 1 2 [NULL] 2 2 1 [NULL] 1 Then remove the parallel hint: You get this: C1 S1 C1 S1 1 2 [NULL] [NULL] 2 1 [NULL] [NULL] = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: import question
Vikas, Where did you find this information? I would appreciate any and all references. Thanks. - Kirti -Original Message- Sent: Monday, July 29, 2002 9:38 AM To: Multiple recipients of list ORACLE-L If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
IRWin?
Has anyone heard of "IRWin"? I have used BPWin and ERWin but have neverheard of "IRWin".Thanks,Ken Janusz, CPIM
Re: Are you qualified?
This is, of course, to laugh. Should someone go back and get certified in Oracle 7.3 just to meet these silly peoples' requirements? I hope that they aren't in a hurry to fill this job. Gesler, RichTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] RGesler cc: @lexington.coSubject: Are you qualified? m Sent by: root 07/27/2002 10:58 AM Please respond to ORACLE-L To OCP or not to OCP... I found an interesting Job Description Job description: Oracle Certified OCP DBA 8i and 9i with Des 2000 -Oracle Database Administrator10 plus yrs. experience in IT with at least 5 yrs. as Oracle DBA B.S. and Masters in Computer Science, or related curriculum. Copies of diplomas must accompany the bid response. Failure to do so will result in the bid being declared as non-responsive. Oracle Certifications (OCP) in Database Administrations in the following all 4 versions:7.3, 8.0, 8i, and 9i. Copies of certification must accompany the bid response. Failure to do so will result in the bid being declared as non-responsive. Oracle Master Certification on Database Administration on UNIX servers. Copies of certification must accompany the bid response. Failure to do so will result in the bid being declared as non-responsive. Minimum of 1 yr of experience creating and managing databases in data warehouse environment. Minimum of 2 yrs. experience installing, configuring, and using Designer 2000 design and develop logical physical databases. Minimum of 2 yrs. of experience with large financial ERP applications such as Peoplesoft, AMS, Oracle Applications. Minimum of 2 yrs. working experience of system supporting Oracle on IBM OS/390 environments using CICS, VSAM, and JCL on OS 390. Minimum of 2 yrs. experience with multiple UNIX environments, UNIX system administration experience, or completion of UNIX administration course. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: naming conventions for Oracle/Unix vs. SQL Server
Title: RE: naming conventions for Oracle/Unix vs. SQL Server Guys, Please help. I work in an organization where we have both SQL Server on NT and Oracle on Unix. SQL Server and developers who are used to GUI's in NT like column names to have mixed case with no underscores. The Unix folk - like myself prefer underscores and one case. Is there any reason not to adopt mixed case for Oracle? Is this really just what I am used to? I have been using this standard for so long that it maybe the reasons I adopted it do not any longer exist or are not as compelling as developer's today are more comfortable with mixed case. Help!
RE: ONLINE index creation in 8.1.7.2
Rich, There was a definite bug with online index creates in 8.1.7.1. I think it was fixed in 8.1.7.3 but I am sure it is OK in 8.1.7.4 John -Original Message- Sent: 29 July 2002 16:29 To: Multiple recipients of list ORACLE-L Hi all, Has anyone experienced problems using the ONLINE option to create an index on a production 8.1.7.2 DB (HP/UX 11.0, if that matters)? I need to create a largish (for us -- ~300 MB) index on an audit table, but I don't want to lock it while the index is created. I've heard of bugs using ONLINE with indexes and am being paranoid, as usual. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Select Query - Help required
A similar question was asked a while ago and I kept the answer as I thought it might be useful The following PL/SQL snippet should demonstrate a way to do what you want set serveroutput on 100 Declare sn varchar2(2000); cursor c_devices is select name from ashoke; Begin for v_devices in c_devices loop exit when c_devices%notfound; sn := sn || ',' || v_devices.name; end loop; dbms_output.put_line(sn); End; / John -Original Message- Sent: 29 July 2002 15:08 To: Multiple recipients of list ORACLE-L Gurus, Please read the following problem and help me if you have any solution. Select product_id from tname where id = 2; Product_ID -- A B C D But I want the output as follows: Select product_id from tname where id = 2; Product ID - ABCD. Thanks in advance. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Are you qualified?
To me this sounds like a job ad for a green card application (on someone else's behalf). Otherwise it wouldn't be to the point. Looks like the attorney who drafted the ad, probably ran out of where clauses. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: naming conventions for Oracle/Unix vs. SQL Server
Title: RE: naming conventions for Oracle/Unix vs. SQL Server Paula, Someone will correct me if I'm wrong, but if you create tables and columns with mixed case within Oracle, then your developers will need to refer them surrounded by double quotes: like: SQL create table "NameTable"("FirstName" varchar2(10)); Table created. SQL descr "NameTablee"ERROR:ORA-04043: object "NameTablee" does not exist SQL descr "NameTable"Name Null? Type- ---FirstName VARCHAR2(10) SQL select firstname from "NameTable";select firstname from "NameTable" *ERROR at line 1:ORA-00904: invalid column name SQL select "FirstName" from "NameTable"; no rows selected SQL Really Sucks! Tom Mercadante Oracle Certified Professional -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, July 29, 2002 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: naming conventions for Oracle/Unix vs. SQL Server Guys, Please help. I work in an organization where we have both SQL Server on NT and Oracle on Unix. SQL Server and developers who are used to GUI's in NT like column names to have mixed case with no underscores. The Unix folk - like myself prefer underscores and one case. Is there any reason not to adopt mixed case for Oracle? Is this really just what I am used to? I have been using this standard for so long that it maybe the reasons I adopted it do not any longer exist or are not as compelling as developer's today are more comfortable with mixed case. Help!
RE: naming conventions for Oracle/Unix vs. SQL Server
The only way to insert a column name in mixed case with Oracle is to enclose the create statements column names in double-quotes.. This also means that when selecting from the created table, you have to enclose the mixed case column name in double quotes as well.. Ad-hoc type queries could go wrong all the time if people forget to do this.. There may be better reasons not to - but this is the one that jumps to mind for me.. HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- [EMAIL PROTECTED] Sent: 29 July 2002 16:59 To: Multiple recipients of list ORACLE-L Guys, Please help. I work in an organization where we have both SQL Server on NT and Oracle on Unix. SQL Server and developers who are used to GUI's in NT like column names to have mixed case with no underscores. The Unix folk - like myself prefer underscores and one case. Is there any reason not to adopt mixed case for Oracle? Is this really just what I am used to? I have been using this standard for so long that it maybe the reasons I adopted it do not any longer exist or are not as compelling as developer's today are more comfortable with mixed case. Help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: import question
Title: RE: import question If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. Very interesting, except that I believe you are wrong. ALL of my exports are done with direct=y option. I can demonstrate very easily that there will be 'redo' generated when doing the import by putting the importing database into archivelog mode and turning off the archiver process. If redo is not being produced (as you state), why do I see messages in the alert log telling me that the database is halted because all my redo logs are full and need archiving? Have a nice day, Dan Straub McKesson Information Solutions 541-681-8278 44°03'N 123°05'W (or thereabouts) Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
RE: naming conventions for Oracle/Unix vs. SQL Server
Title: RE: naming conventions for Oracle/Unix vs. SQL Server Paula: The mixed case for Oracle does not matter, as Oracle is not case sensitive. The column names are stored in uppercase within the data dictionary. However, for SQL Server, the case sensitivity of column names is crucial. Another black eye for MSFT. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: naming conventions for Oracle/Unix vs. SQL Server Guys, Please help. I work in an organization where we have both SQL Server on NT and Oracle on Unix. SQL Server and developers who are used to GUI's in NT like column names to have mixed case with no underscores. The Unix folk - like myself prefer underscores and one case. Is there any reason not to adopt mixed case for Oracle? Is this really just what I am used to? I have been using this standard for so long that it maybe the reasons I adopted it do not any longer exist or are not as compelling as developer's today are more comfortable with mixed case. Help! The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.
RE: import question
Hi, I've never seen anything to suggest that exportijng using DIRECT=Y speeded up subsequent imports. I'd be interested to know if this is really the case but I doubt it. The structure of an export file is exactly the same whatever the DIRECT setting. But I've been wrong before ... Things I'd suggest would be: - Optimise your online redos - usual advice; pretty big, raw devices, watch for log switch interval. - Switch off archivelogging. - Offline all but one, large rollback segment and specify COMMIT=N to delay commits until the end of each object. - Postpone index creation until the import has finished. Create indexes after the import is completed using the NOLOGGING option (and maybe in parallel too). - Make sure that you have BUFFER set large enough. 1M-5M is sensible. - In the olden days there used to be some benefit in relinking the imp executable to use single-task mode rather than two-task. I haven't tested this recently; can anyone confirm that there's still a benefit? - separate your I/O. Your DB may already be optimised. But your expoprt file on a different disk again. - Also you may be able to run parallel import streams - you be the judge; just a thought. Obviously some of these suggestions may not suit your needs. Regards, Mike Hately Oracle DBA -Original Message- Sent: 29 July 2002 15:38 To: Multiple recipients of list ORACLE-L If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. While Export it just bypasses the SQL Evaluation buffer,make it faster and directly put things in TTC buffer recognized by Import of Oracle If that option was not selected, frequent commit would enable the checkpoint more often and thus LGWR writing the buffers to redo logs more often. Enable a buffer size which could be substantial high, so that more number of rows could be extracted from the Export file in an array thus boosting the perf. Thanks Vikas Khanna -Original Message- Sent: Monday, July 29, 2002 5:58 PM To: Multiple recipients of list ORACLE-L Hi, We are importing a large amount of data and uit is generating a huge amount of redo..is there any way of avoiding this- unfortunately this is on an 8.0.6 database?? Any help/advice would be appreciated!! Rgds FAwzia This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately 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).
Total Memory Usage in AIX System
Hi, I have a few Oracle scripts to calculate Total Physical Memory usage by Oracle at any give time. But I would like to find out Total Memory Usage by ORACLE and NON-ORACLE processes. I used dmesg in HP system but I do not know for IBM AIX system. Please let me know if you happen to know the method to calculate the total memory usage on the system. Thank you! Muqthar Ahmed Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: deploy forms on web
trying again... --- Forwarded message follows --- - begin returned message - http://www.odtug.com/web_members/mbrsonly_signup.asp S*u*b*s*c*r*i*b*e to the developers list, they have recently dealt with the problem, see the archives. It is a limitation of Developer. On 28 Jul 2002 at 20:43, Arvind Kumar wrote: i want to deploy my application (forms reports) on web, for this i have instlled forms and reports server 6i can see the forms (.fmx) in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. - end returned message - --- End of forwarded message --- Start at: http://www.odtug.com/index.asp click on Become a FREE ODTUG Web Member today... Enter your emali address, etc. and wait for the confirmation email that contains a password that you can then enter at the ODTUG web site to get access to the email list subscription screen. (or you can manually subscribe, see below). If you become a paying member of ODTUG, you can search the email list archives. Mailing Lists ODTUG is pleased to host nine mailing lists to keep you informed. ODTUG-L for general ODTUG questions, discussions, and administrative notices ODTUG-WAREHOUSE-L for data warehousing and OLAP-related topics ODTUG-METHODS-L for methodology and process topics ODTUG-DES2K-L for Oracle Designer topics *** *** ODTUG-DEV2K-L for Oracle Developer topics *** ODTUG-DISC2K-L for Oracle Discoverer topics ODTUG-JAVA-L for JDeveloper, JDBC, and Java-related topics ODTUG-SQLPLUS-L for SQL*Plus, PL/SQL, and general SQLtopics ODTUG-WEBDEV-L WSG, OAS, OWAS, WebDB, and other Web-related topics To subscribe to any of these lists, please fill out the subscription form below. To subscribe to the mailing lists on your own, send an e-mail message to: [EMAIL PROTECTED] And in the message BODY (not Subject line), put: SUBSCRIBE mailing list real name Have mailing list be the name of the list you want to receive, and real name be your full given name, not your e-mail address. Omit the angle brackets when sending your message. More than one SUBSCRIBE command can be put in the same message, but they must each be on a separate line. For example: SUBSCRIBE ODTUG-L John Doe To remove yourself from a list, use the UNSUBSCRIBE command (with the same parameters as above). You may also include the HELP command for a list of how to use the mailing list server software to change your subscription, check status, obtain archives, read digests, and more. If you would like to subscribe or unsubscribe to one of our current mailing lists, just fill out the form below. ... -- 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: RAC related info
Check out the book Tru64 Unix - Oracle 9i Cluster - Quick Reference by Tim Donar. Plus there might be some information at : http://www.tru64unix.compaq.com/docs/best_practices/ Darren -Original Message- Sent: July 29, 2002 1:48 AM To: Multiple recipients of list ORACLE-L Hi, everyone! Does anybody have links related to 9i RAC on Tru unix? Advices, trick'n'tips, FAQ's, case studies... Beside technet and metalink, of course. Thank you in advance, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Install Oracle 8i on Windows XP?
Indeed. I hadn't looked at the list since Friday, and I thought it was done with then. Jared On Monday 29 July 2002 05:53, Joe Raube wrote: Please end this thread and/or take it off the list... Thank you. --- Yechiel Adar [EMAIL PROTECTED] wrote: Eric, thank you for your illuminating notes on the reason they hate us. blowing steam Just two points: 1) A few days ago a bomb explode in India killing 50 people. I did not heard ANY remarks from anybody condemning this. 2) All the people who cry for the Palestinians and demand they should have their own country does not give a shit about the Curds (for example) who are in worse condition. The Europe countries are basing their policy on Jew hating. /blowing steam Yechiel Adar Mehish ISRAEL __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- 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).
Cloning Problems
Having some trouble cloning a database. The database was shutdown with the immediate option and all file where copied to new location. I usually shutdown immediate, open then shutdown normal myself but this was outside my control. I did the standard stuff with the trace file, reset logs etc...done this many times before. When I tried to open the database with the resetlogs option it told me I needed to do recovery. I have been doing this a lot lately with hot files so recovery is usually required but it has been a while since I have used cold files. Any ideas what I have done wrong here? Was it the shutdown immediate? My bet is if I had switched through the redo logs before the shutdown I probably wouldn't have this problem but I also thought that the shutdown immediate would have issued a checkpoint and all the changes in the redo would have been made to the datafiles. Thanks! 10:15:55 SQL 10:15:55 SQL alter database open; alter database open * ERROR at line 1: ORA-01589: must use RESETLOGS or NORESETLOGS option for database open 10:16:05 SQL alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/db04/oracle/DM8/system01.dbf' 10:16:12 SQL recover database using backup controlfile until cancel ORA-00279: change 1806063 generated at 07/25/2002 05:18:01 needed for thread 1 ORA-00289: suggestion : /archive/DM8arch_0001_95.dbf ORA-00280: change 1806063 for thread 1 is in sequence #95 10:16:28 Specify log: {RET=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log '/archive/DM8arch_0001_95.dbf' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/db04/oracle/DM8/system01.dbf' 10:16:36 SQL exit Disconnected -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: open cursors problem
The issue of open cursors and connection pooling (using the weblogic properties parms you mention) are completely different. Many cursors can be opened within a single connection from the pool. Too many open cursors is a case of a poorly written app, at least in my experience with weblogic/java apps. So I'd agree that it's a developer coding issue and not a connection pooling issue. And also agree with Rachel that setting open_cursors=1000 is reasonable, then it's a developer education issue. Gavin D'Mello wrote: Dennis William sent me a mail containing the discussions on this same topic a couple of weeks back. That discussion layed the blame a bit on the database config parameters in the weblogic properties file like initialCapacity, maxCapacity, capacityIncrement Is this really the case ? or just developer error of not closing the prepared statements ? Gavin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 6:43 PM I think the problem is that that's the value in the init.ora file for his database, NOT the limit of Oracle itself. According to the docs, the maximum number of open cursors you can allow in 8.1.7 AND 9.2 is 1 to 4294967295 (4 GB -1). And that limit is for each individual user, not cumulative total for the database. so the crash may be that the parameter is set to 750 in the initialization file for that database, in which case, if you hit it then you need to raise that number in the init.ora and bounce the database. If that's not the problem, then I would seriously review my code. Why ANY individual user would have that many open cursors in a single session is something to check. Usually means the app is written not to clean up after itself. There IS a limit to how much memory you can use before the machine hangs itself with constant swapping. I had one like that in 7.3.4, the programmers never bothered to explicitly close the cursors when done, they let it default to when the session was ended, the end users would click open new sessions without closing down old ones. We finally set open_cursors to 1000 and let it fail, to teach the end-users to close windows. Why didn't the programmers rewrite the code? Damagement there decided that the programmers knew better than the DBA about how things should work in conjunction with the database. And, of course, fixing bad code doesn't show as progress on status reports. --- Toepke, Kevin M [EMAIL PROTECTED] wrote: WHAT! A cap of 750 open cursors in the database? Where did you hear that? -Original Message- Sent: Monday, July 29, 2002 3:38 AM To: Multiple recipients of list ORACLE-L Hi everyone, I am running EJB under weblogic 5.1 jdbc 2.0, and when I last checked the database the number of open cursors was 564. I know 8.1.7 has a cap of 750 open cursors after which the db will crash. Since this is the first time I have faced this problem I would be grateful if anyone could point out what could be the possible areas that could cause this problem ( other than the logical one of not closing cursors once they have been opened and used !). any help here would be appreciated. thank you, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gavin D'Mello INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Toepke, Kevin 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). __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Total Memory Usage in AIX System
Use 'svmon', have a look at the man pages. -Original Message- Sent: 29 July 2002 17:25 To: Multiple recipients of list ORACLE-L Hi, I have a few Oracle scripts to calculate Total Physical Memory usage by Oracle at any give time. But I would like to find out Total Memory Usage by ORACLE and NON-ORACLE processes. I used dmesg in HP system but I do not know for IBM AIX system. Please let me know if you happen to know the method to calculate the total memory usage on the system. Thank you! Muqthar Ahmed Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: runInstaller Error ....
Thanks for the reply. I searched metalink and found couple of relevant articles, (not the exact ones), but they didn't help much. I raised Tar with oracle and submitted the error message from rda.sh, .profile, .login, .cshrc and .kshrc files. I would post the solution if I get any from Oracle. -- Babu -Original Message- Sent: Sunday, July 28, 2002 3:18 PM To: Multiple recipients of list ORACLE-L Babu This problem is confusing to me. Perhaps someone else on the list has an idea. It seems your problem may have to do with LD_LIBRARY_PATH. I can't think why /lib would be getting added to the first of your LD_LIBRARY_PATH. I am not familiar with rda.sh. Usually, in a path like this, the software simply searches each directory in turn and if it searches all of them without finding what it is searching for, then it returns an error. A wild idea would be for you to create an empty /lib directory on your system in the hope that it would get searched and then the code will move on to the next (correct) library. Maybe someone Monday morning will see this and have a better idea. Have you searched Metalink for this error? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, July 26, 2002 5:23 PM To: Multiple recipients of list ORACLE-L I did the setting for LD_LIBRARY_PATH and is not working. I also executed rda.sh script (REMOTE DIAGNOSTIC AGENT for UNIX), It came out with an error as follows: Argument LD_LIBRARY_PATH=/lib:/usr/local/oracle/817/lib:/usr/lib not recognized and was forced to exit. I don't know how /lib was picked up. When issued echo $LD_LIBRARY_PATH, it displayed as follows: /usr/local/oracle/817/lib:/usr/lib Please let me know how I should proceed with the error. Thanks, -- Babu -Original Message- Sent: Friday, July 26, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Babu Try setting LD_LIBRARY_PATH to $ORACLE_HOME/lib -Original Message- Sent: Friday, July 26, 2002 3:40 PM To: Multiple recipients of list ORACLE-L Dear list, When I execute runInstaller from /cdrom/disk1, I get the following error message: Initializing java virtual machine from /tmp/OraInstall/jre/bin/jre. Please wait... Class not found: LD_LIBRARY_PATH=/lib:/usr/lib Iam unable to start the installer. I unset LD_LIBRARY_PATH, and still getting the error. Iam installing 8.1.7.0.0(64bit) on Sun Sparc Solaris 2.8 (64bit). Please let me know if anyone has any ideas. Thanks, -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
Re: naming conventions for Oracle/Unix vs. SQL Server
Definately underscores, if simply just to break the habit of developers assuming that mixed-case means something outside of MS-land. While SQL-Server does allow/display/use objects in mixed-case format, forcing that into Oracle *can* be done, but it's a bad idea. The Oracle data dictionary stores object definitions upper-case, and allows those objects to be referenced in any mixed case. Forcing object creation in Oracle as mixed-case is a DDL hack using around the object name. At which point, the object can only be accessed in the exact case it was created enclosed with . For example SQL create table Test (id number); SQL desc test ERROR: ORA-04043: object test does not exist SQL desc test ERROR: ORA-04043: object test does not exist SQL desc Test ERROR: ORA-04043: object test does not exist SQL desc Test Name Null?Type - --- ID NUMBER [EMAIL PROTECTED] wrote: Guys, Please help. I work in an organization where we have both SQL Server on NT and Oracle on Unix. SQL Server and developers who are used to GUI's in NT like column names to have mixed case with no underscores. The Unix folk - like myself prefer underscores and one case. Is there any reason not to adopt mixed case for Oracle? Is this really just what I am used to? I have been using this standard for so long that it maybe the reasons I adopted it do not any longer exist or are not as compelling as developer's today are more comfortable with mixed case. Help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cloning Problems
Did you recover the database using backup controlfile? Try that. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 12:48 PM Having some trouble cloning a database. The database was shutdown with the immediate option and all file where copied to new location. I usually shutdown immediate, open then shutdown normal myself but this was outside my control. I did the standard stuff with the trace file, reset logs etc...done this many times before. When I tried to open the database with the resetlogs option it told me I needed to do recovery. I have been doing this a lot lately with hot files so recovery is usually required but it has been a while since I have used cold files. Any ideas what I have done wrong here? Was it the shutdown immediate? My bet is if I had switched through the redo logs before the shutdown I probably wouldn't have this problem but I also thought that the shutdown immediate would have issued a checkpoint and all the changes in the redo would have been made to the datafiles. Thanks! 10:15:55 SQL 10:15:55 SQL alter database open; alter database open * ERROR at line 1: ORA-01589: must use RESETLOGS or NORESETLOGS option for database open 10:16:05 SQL alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/db04/oracle/DM8/system01.dbf' 10:16:12 SQL recover database using backup controlfile until cancel ORA-00279: change 1806063 generated at 07/25/2002 05:18:01 needed for thread 1 ORA-00289: suggestion : /archive/DM8arch_0001_95.dbf ORA-00280: change 1806063 for thread 1 is in sequence #95 10:16:28 Specify log: {RET=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log '/archive/DM8arch_0001_95.dbf' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/db04/oracle/DM8/system01.dbf' 10:16:36 SQL exit Disconnected -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cloning Problems
Digging into my own problem here, I did find this message from some years back between Jonathen Lewis and Tom Kyte on Usenet, this probably explains why I need to do a redo log switch before shutting down... * If the database administrator shuts down an instance (NORMAL or IMMEDIATE), ORACLE forces a database checkpoint to complete before the instance is shut down. Yes it does. I will try to find out EXACTLY what is missing during the shutdown immediate. I know that SOMETHING is missing since sometimes recovery is performed on my database and sometimes not. Review of my alert files shows this. What it might be (and I have to research this) is that whilst the checkpoint is occurring, rollback is also taking place pretty much at the same time. A checkpoint in Oracle doesn't stop other work from taking place. The only time a checkpoint will hold up the instance is when the logs attempt to wrap around and the checkpoint hasn't completed. Just becase a checkpoint completes doesn't imply the datafiles are perfectly consistent, just fairly close. We allow other work to go on while the checkpoint takes place. This is ME hypothesising here but perhaps: shutdown normal (steps performed in roughly this order) 1. users not allowed to log in 2. users logged in waited on to finsish 3. when last user logs out, checkpoint starts (database is single user now) 4. when checkpoint completes database is shutdown for real (and is consistent since no work done during the checkpoint shutdown immediate (steps) 1. users not allowed to log in 2. users logged in are rolled back AND a checkpoint is initiated 3. when the last user is Logged off AND the checkpoint is complete the database is shutdown for real. But since the checkpoint and rolllbacks took place concurrently, database MAY be inconsistent Again, I AM GUESSING at the above ( an educated guess, but a guess none the less). I will be out of the office till september and won't be able to look at this in detail till then. If anyone else finds out more, let us know. -- Jonathan Lewis Thomas Kyte [EMAIL PROTECTED] Oracle Government -Original Message- Sent: Monday, July 29, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Having some trouble cloning a database. The database was shutdown with the immediate option and all file where copied to new location. I usually shutdown immediate, open then shutdown normal myself but this was outside my control. I did the standard stuff with the trace file, reset logs etc...done this many times before. When I tried to open the database with the resetlogs option it told me I needed to do recovery. I have been doing this a lot lately with hot files so recovery is usually required but it has been a while since I have used cold files. Any ideas what I have done wrong here? Was it the shutdown immediate? My bet is if I had switched through the redo logs before the shutdown I probably wouldn't have this problem but I also thought that the shutdown immediate would have issued a checkpoint and all the changes in the redo would have been made to the datafiles. Thanks! 10:15:55 SQL 10:15:55 SQL alter database open; alter database open * ERROR at line 1: ORA-01589: must use RESETLOGS or NORESETLOGS option for database open 10:16:05 SQL alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/db04/oracle/DM8/system01.dbf' 10:16:12 SQL recover database using backup controlfile until cancel ORA-00279: change 1806063 generated at 07/25/2002 05:18:01 needed for thread 1 ORA-00289: suggestion : /archive/DM8arch_0001_95.dbf ORA-00280: change 1806063 for thread 1 is in sequence #95 10:16:28 Specify log: {RET=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log '/archive/DM8arch_0001_95.dbf' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/db04/oracle/DM8/system01.dbf' 10:16:36 SQL exit Disconnected -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Slightly OT: Chart generation tool for db monitoring scripts out
Does anyone know of any simple utility that will take a data file and generate a quick chart. I'd like to generate a chart of number of transactions per time period. I can generate the output through a SQL query. Actually I'd like to do this for more data, but this is just an example. Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Oracle 11i
Hi all, I purchased the Oracle 11i Release 5 (with 11.5.6 family packs) CD pack for Windows from Oracle online store. My first installed (Win2000) run out of space, and I cleaned the folders manually. When I got more space and installed again, I got: not all the dependencies for the component OEM common files 2.2.0.0.0 are found. Missing component Oracle.swd.jre 1.1.8.10.0. Looks like the manually cleanup didn't go well. What should I do now? Also, how long does the install take? One guy told me to install one product/one db at a time. Is this a good idea? Is demo db enough? Are there any Oracle 11i group/email list? I know, lots of questions. :-) Thanks! Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cloning Problems
Yeah, went through the standard cloning process. My first line of trace file looked like this... CREATE CONTROLFILE SET DATABASE DM8 RESETLOGS NOARCHIVELOG I am wondering if I should have stated NORESETLOGS here instead, that way the data in the redo logs would be available and then the cloned instance could have performed instance recovery. I have always used the method above and never had any problems but that is likely because I have always done a SHUTDOWN NORMAL instead of SHUTDOWN IMMEDIATE. While the SHUTDOWN immediate performs a checkpoint it looks like there can still be stuff out there in the logs that will require instance recovery. Since I did a RESETLOGS I am guessing this necessary info is missing. Wondering if everything will be OK if I try to find another way to get the clone opened, like setting the hidden allow corrupt logs parameter. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Monday, July 29, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Did you recover the database using backup controlfile? Try that. HTH, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: import question
Title: RE: import question Dan: I believe the SQL on the outbound is eliminated. With DIRECT=Y, the Kernel performs I/O direct to the DMP file versus generating the SELECT statements to retrieve the data and then write out the data. Thats why exports take far less time with DIRECT=Y. You are correct that Redo WILL be generated on the import side. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- From: Straub, Dan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: import question If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. Very interesting, except that I believe you are wrong. ALL of my exports are done with direct=y option. I can demonstrate very easily that there will be 'redo' generated when doing the import by putting the importing database into archivelog mode and turning off the archiver process. If redo is not being produced (as you state), why do I see messages in the alert log telling me that the database is halted because all my redo logs are full and need archiving? Have a nice day, Dan Straub McKesson Information Solutions 541-681-8278 44°03'N 123°05'W (or thereabouts) Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.
Re: Install Oracle 8i on Windows XP?
Eric, Need I remind you that this is an Oracle forum? We all enjoy a little off topic banter mixed in with technical discussion, but this is really over the top. Please stop it. Jared Eric D. Pierce [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/28/2002 10:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Install Oracle 8i on Windows XP? Absurd. Your intention from the beginning was to be a snobby jerk. http://www.weeklystandard.com/Content/Public/Articles/000/000/001/102gwtnf.asp Among the Bourgeoisophobes Why the Europeans and Arabs, each in their own way, hate America and Israel. by David Brooks 04/15/2002, Volume 007, Issue 30 AROUND 1830, a group of French artists and intellectuals looked around and noticed that people who were their spiritual inferiors were running the world. Suddenly a large crowd of merchants, managers, and traders were making lots of money, living in the big houses, and holding the key posts. They had none of the high style of the aristocracy, or even the earthy integrity of the peasants. Instead, they were gross. They were vulgar materialists, shallow conformists, and self-absorbed philistines, who half the time failed even to acknowledge their moral and spiritual inferiority to the artists and intellectuals. What's more, it was their very mediocrity that accounted for their success. Through some screw-up in the great scheme of the universe, their narrow-minded greed had brought them vast wealth, unstoppable power, and growing social prestige. Naturally, the artists and intellectuals were outraged. Hatred of the bourgeoisie became the official emotion of the French intelligentsia. Stendhal said traders and merchants made him want to weep and vomit at the same time. Flaubert thought they were plodding and avaricious. Hatred of the bourgeoisie, he wrote, is the beginning of all virtue. He signed his letters Bourgeoisophobus to show how much he despised stupid grocers and their ilk. Of all the great creeds of the 19th century, pretty much the only one still thriving is this one, bourgeoisophobia. Marxism is dead. Freudianism is dead. Social Darwinism is dead, along with all those theories about racial purity that grew up around it. But the emotions and reactions that Flaubert, Stendhal, and all the others articulated in the 1830s are still with us, bigger than ever. In fact, bourgeoisophobia, which has flowered variously and spread to places as diverse as Baghdad, Ramallah, and Beijing, is the major reactionary creed of our age. This is because today, in much of the world's eyes, two peoples--the Americans and the Jews--have emerged as the great exemplars of undeserved success. Americans and Israelis, in this view, are the money-mad molochs of the earth, the vulgarizers of morals, corrupters of culture, and proselytizers of idolatrous values. These two nations, it is said, practice conquest capitalism, overrunning poorer nations and exploiting weaker neighbors in their endless desire for more and more. These two peoples, the Americans and the Jews, in the view of the bourgeoisophobes, thrive precisely because they are spiritually stunted. It is their obliviousness to the holy things in life, their feverish energy, their injustice, their shallow pursuit of power and gain, that allow them to build fortunes, construct weapons, and play the role of hyperpower. And so just as the French intellectuals of the 1830s rose up to despise the traders and bankers, certain people today rise up to shock, humiliate, and dream of destroying America and Israel. Today's bourgeoisophobes burn with the same sense of unjust inferiority. They experience the same humiliation because there is nothing they can do to thwart the growing might of their enemies. They rage and rage. Only today's bourgeoisophobes are not just artists and intellectuals. They are as likely to be terrorists and suicide bombers. They teach in madrassas, where they are careful not to instruct their students in the sort of practical knowledge that dominates bourgeois schools. They are Muslim clerics who incite hatred and violence. They are erudite Europeans who burn with humiliation because they know, deep down, that both America and Israel possess a vitality and heroism that their nations once had but no longer do. ... ( originally linked from www.dynamist.com ) --- On 28 Jul 2002 at 12:53, Mladen Gogala wrote: ... This debate is getting increasingly personal and that is why I am going to end it right now. I tried
RE: Slightly OT: Chart generation tool for db monitoring scripts out
MRTG is one. -Original Message- Sent: Monday, July 29, 2002 2:14 PM To: Multiple recipients of list ORACLE-L out Does anyone know of any simple utility that will take a data file and generate a quick chart. I'd like to generate a chart of number of transactions per time period. I can generate the output through a SQL query. Actually I'd like to do this for more data, but this is just an example. Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 generic data model library
Title: RE generic data model library Guys, Appears that survey is a type of data model. Does anyone know of a library/resource for common data models?
Re: Slightly OT: Chart generation tool for db monitoring scripts out
Do a google search for RRD Tool Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. Rajendra.Jamadagn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Slightly OT: Chart generation tool for db monitoring scripts out 07/29/02 11:14 AM Please respond to ORACLE-L Does anyone know of any simple utility that will take a data file and generate a quick chart. I'd like to generate a chart of number of transactions per time period. I can generate the output through a SQL query. Actually I'd like to do this for more data, but this is just an example. Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! (See attached file: InterScan_Disclaimer.txt) InterScan_Disclaimer.txt Description: Binary data
RE: import question
From the 8.1.7 docs: Direct path Export extracts data much faster than a conventional path export. Direct path Export achieves this performance gain by reading data directly, bypassing the SQL command processing layer and saves on data copies whenever possible. In a direct path Export, data is read from disk into the buffer cache and rows are transferred directly to the Export client. The evaluating buffer is bypassed. The data is already in the format that Export expects, thus avoiding unnecessary data conversion. The data is transferred to the Export client, which then writes the data into the export file. --- Karniotis, Stephen [EMAIL PROTECTED] wrote: Dan: I believe the SQL on the outbound is eliminated. With DIRECT=Y, the Kernel performs I/O direct to the DMP file versus generating the SELECT statements to retrieve the data and then write out the data. That's why exports take far less time with DIRECT=Y. You are correct that Redo WILL be generated on the import side. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
11i installation ???
Hi all, I purchased the Oracle 11i Release 5 (with 11.5.6 family packs) CD pack for Windows from Oracle online store. My first installed (Win2000) run out of space, and I cleaned the folders manually. When I got more space and installed again, I got: not all the dependencies for the component OEM common files 2.2.0.0.0 are found. Missing component Oracle.swd.jre 1.1.8.10.0. Looks like the manually cleanup didn't go well. What should I do now? Also, how long does the install take? One guy told me to install one product/one db at a time. Is this a good idea? Is demo db enough? Are there any Oracle 11i group/email list? I know, lots of questions. :-) Thanks! Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: naming conventions for Oracle/Unix vs. SQL Server
Title: RE: naming conventions for Oracle/Unix vs. SQL Server -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Please help. I work in an organization where we have both SQL Server on NT and Oracle on Unix. SQL Server and developers who are used to GUI's in NT like column names to have mixed case with no underscores. The Unix folk - like myself prefer underscores and one case. Is there any reason not to adopt mixed case for Oracle? Is this really just what I am used to? I have been using this standard for so long that it maybe the reasons I adopted it do not any longer exist or are not as compelling as developer's today are more comfortable with mixed case. Help! While it is possible to create table names that are reserved words or contain special characters when using double quotes around the names e.g. create table TABLE (COLUMN varchar2 (20)) ; create table joe's table (joe's data varchar2 (20)) ; I would not recommend it for the following reasons: a) As other persons have pointed out, it makes coding more difficult in that object names have to be surrounded with double quotes; b) You will run into difficulties when a third-party application is not smart enough to put double quotes around the column names; c) You will run into difficulties when you hit an Oracle bug relating to non-standard names. Two of them that I know of so far: - Cannot use alter table move on an index-organized table with lowercase column names (in 8.0, 8.1, 9.0 and maybe 9.2) : see example below - Cannot have the including column for an index-organized table in lowercase in 8.1 (strangely enough it works in 8.0 and 9.0): see example below - Also, I was unable to successfully implement a security policy (dbms_rls) on a table when the security policy function name was lowercase (but perhaps with some ingenuity it could be made to work) **' alter table move on index-organized table with lowercase column name error: SQL*Plus: Release 9.0.1.0.1 - Production on Me Jul 24 10:07:12 2002 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connecté à : Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production SQL create table book 2 (book_id number not null, 3 book_title varchar2 (40), 4 constraint book_pk primary key (book_id) 5 ) 6 organization index 7 tablespace users ; Table créée. SQL alter table book move tablespace tools ; alter table book move tablespace tools * ERREUR à la ligne 1 : ORA-00904: Nom de colonne non valide **' alter table move on index-organized table with lowercase column name error: SQL*Plus: Release 8.1.7.0.0 - Production on Lu Jul 29 10:59:06 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connecté à : Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production With the Partitioning option JServer Release 8.1.7.2.1 - Production SQL create table my_table 2 (id number (7) primary key, 3 name varchar2 (20), 4 type char(1) not null, 5 purchase date 6 ) 7 organization index 8 including type 9 overflow tablespace users ; create table my_table * ERREUR à la ligne 1 : ORA-25184: nom de colonne attendu SQL -- syntax correct when removing double quotes around including column name SQL create table my_table 2 (id number (7) primary key, 3 name varchar2 (20), 4 type char(1) not null, 5 purchase date 6 ) 7 organization index 8 including type 9 overflow tablespace users ; Table créée.
RE: Slightly OT: Chart generation tool for db monitoring scripts
Thanks Ron, Beth, That is the last option. Do we have anything that can be used without a supporting web server? I'd like to run this off my file system. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, July 29, 2002 2:49 PM To: Multiple recipients of list ORACLE-L scripts out Do a google search for RRD Tool *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
ODBC connection privs in Oracle
Can someone point out how ODBC connection privileges are set, e.g. if we connect to Oracle using MS access? The privs do not appear to match Oracle-based security. I am going to search technet and Metalink now... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Install Oracle 8i on Windows XP?
Easier , RH, easier ??? Are you kidding. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 27, 2002 2:48 PM On 2002.07.27 14:49 Eric D. Pierce wrote: JUST SETUP A DUAL BOOT OF WINDOWS 2000 PRO AND WINDOWS XP PRO AND MAKE YOUR LIFE EASIER!!! And then reformat all your disks, install Red Hat 7.3 and make your life still easier. No dual boot required. Keep your system Micros*t free. --- Remember, Windows .NET Server 2003 (the precise term used by Bill Gates recently) is the next evolution of the kind of production platform that Oracle server needs to run on, Yes. The most significant advance is that the blue screen of death will be replaced by the green one, to signify Microsoft's concerns for our environment. Microsoft is famous for the stability of its products, particularly the Exchange. Microsoft is really something that you want your production database to be running on. Does the .net part mean that a database running on a MS sever will be vulnerable to any damned virus there is on the (.)net? -- NOT XP (which is a desktop platform)!!! Not on my desk! XP is the desktop Whistler, whereas Windows .NET Server 2003 is the server version of Whistler. Oracle will probably have the same problem with Longhorn, which will be the next evolutionary step in the desktop Since when is return to the dinosaurs called evolution? progression after XP. Donward progression, that is. Just press Ctrl-Alt-Del. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cloning Problems
Ethan, Your first line of the trace file is the same as mine when I clone from cold backups. I also always do clean shutdown normal before cold backup but I think you should be okay with shutdown immediate too (IMHO). I think if you are renaming the cloned database then the RESETLOGS option is required. You said the database was shut down IMMEDIATE and you had no control over this. Did someone else shutdown and do the backup for you? Don't forget to check the obvious. Are you sure the backup was completely closed (not rolling back) before the backup began? (You're used to hot files) Are you sure the database was not restarted before the backup completed? Are you sure you copied ALL files to your cloned database? (I copy everything, then delete control files, then create controlfiles) Take a quick check on the timestamps on the files you backed up. See if there are any time differences that jump out at you. Good luck, Ed -Original Message- Sent: Monday, July 29, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Yeah, went through the standard cloning process. My first line of trace file looked like this... CREATE CONTROLFILE SET DATABASE DM8 RESETLOGS NOARCHIVELOG I am wondering if I should have stated NORESETLOGS here instead, that way the data in the redo logs would be available and then the cloned instance could have performed instance recovery. I have always used the method above and never had any problems but that is likely because I have always done a SHUTDOWN NORMAL instead of SHUTDOWN IMMEDIATE. While the SHUTDOWN immediate performs a checkpoint it looks like there can still be stuff out there in the logs that will require instance recovery. Since I did a RESETLOGS I am guessing this necessary info is missing. Wondering if everything will be OK if I try to find another way to get the clone opened, like setting the hidden allow corrupt logs parameter. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Monday, July 29, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Did you recover the database using backup controlfile? Try that. HTH, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Slightly OT: Chart generation tool for db monitoring scripts
I just got in on this, but I have used Embaradero's ERstudio. It ran right of the database and didn't need to connect to the web or anywhere else. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 3:23 PM Thanks Ron, Beth, That is the last option. Do we have anything that can be used without a supporting web server? I'd like to run this off my file system. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, July 29, 2002 2:49 PM To: Multiple recipients of list ORACLE-L scripts out Do a google search for RRD Tool -- 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: Slightly OT: Chart generation tool for db monitoring scripts
perl with GD module On Mon, 29 Jul 2002, Seefelt, Beth wrote: MRTG is one. -Original Message- Sent: Monday, July 29, 2002 2:14 PM To: Multiple recipients of list ORACLE-L out Does anyone know of any simple utility that will take a data file and generate a quick chart. I'd like to generate a chart of number of transactions per time period. I can generate the output through a SQL query. Actually I'd like to do this for more data, but this is just an example. Thanks Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Chart generation tool for db monitoring scripts
Hi Raj, What do you want to generate the output in if not html? Beth -Original Message- Sent: Monday, July 29, 2002 3:24 PM To: Multiple recipients of list ORACLE-L scripts Thanks Ron, Beth, That is the last option. Do we have anything that can be used without a supporting web server? I'd like to run this off my file system. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, July 29, 2002 2:49 PM To: Multiple recipients of list ORACLE-L scripts out Do a google search for RRD Tool -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 11i installation ???
Hello Leslie Did you remember to clean up c:\program files\oracle as well. This is where Oracle keeps the install log and files. I think that if you delete also this folder Oracle will start the install from fresh. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 8:49 PM Hi all, I purchased the Oracle 11i Release 5 (with 11.5.6 family packs) CD pack for Windows from Oracle online store. My first installed (Win2000) run out of space, and I cleaned the folders manually. When I got more space and installed again, I got: not all the dependencies for the component OEM common files 2.2.0.0.0 are found. Missing component Oracle.swd.jre 1.1.8.10.0. Looks like the manually cleanup didn't go well. What should I do now? Also, how long does the install take? One guy told me to install one product/one db at a time. Is this a good idea? Is demo db enough? Are there any Oracle 11i group/email list? I know, lots of questions. :-) Thanks! Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Chart generation tool for db monitoring scripts
Beth, Okay ... here is the whole story (I should have done this in my first mail, but I didn't have time then) ... 1. I currently generate a bunch of HTML reports using SQLPLUS. all these are stored on my file system. Updated periodically by (gasp) MS task scheduler. 2. I have a navigation page that lets me go to a page of my choice and see the tabular data which is in html format. I'd like to have some graphs generated to give more visual clues than having to scan the data manually. This is the reason why I am asking. An important one is to measure the 'current block receive time' for our RAC instance. Thanks for any pointers. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, July 29, 2002 3:45 PM To: Multiple recipients of list ORACLE-L Hi Raj, What do you want to generate the output in if not html? Beth *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Are you qualified?
At a previous company, one of my colleagues was being relocated from Canada. To prove that he wasn't taking a job away from a U.S. citizen, they had to run an advertisement in a professional magazine for his job. Needless to say they made it pretty specific. Had anyone replied, I suppose they would have had to write up why that person wasn't qualified. Then I understood some of the really weird ads I've seen. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 29, 2002 11:10 AM To: Multiple recipients of list ORACLE-L To me this sounds like a job ad for a green card application (on someone else's behalf). Otherwise it wouldn't be to the point. Looks like the attorney who drafted the ad, probably ran out of where clauses. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cloning Problems
Shutdown immediate always worked for me with 8.1.6 and 8.1.7.0.0 on HP-UX 11.0. Shutdown abort's another matter entirely. -Original Message- Sent: Monday, July 29, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Ethan, Your first line of the trace file is the same as mine when I clone from cold backups. I also always do clean shutdown normal before cold backup but I think you should be okay with shutdown immediate too (IMHO). I think if you are renaming the cloned database then the RESETLOGS option is required. You said the database was shut down IMMEDIATE and you had no control over this. Did someone else shutdown and do the backup for you? Don't forget to check the obvious. Are you sure the backup was completely closed (not rolling back) before the backup began? (You're used to hot files) Are you sure the database was not restarted before the backup completed? Are you sure you copied ALL files to your cloned database? (I copy everything, then delete control files, then create controlfiles) Take a quick check on the timestamps on the files you backed up. See if there are any time differences that jump out at you. Good luck, Ed -Original Message- Sent: Monday, July 29, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Yeah, went through the standard cloning process. My first line of trace file looked like this... CREATE CONTROLFILE SET DATABASE DM8 RESETLOGS NOARCHIVELOG I am wondering if I should have stated NORESETLOGS here instead, that way the data in the redo logs would be available and then the cloned instance could have performed instance recovery. I have always used the method above and never had any problems but that is likely because I have always done a SHUTDOWN NORMAL instead of SHUTDOWN IMMEDIATE. While the SHUTDOWN immediate performs a checkpoint it looks like there can still be stuff out there in the logs that will require instance recovery. Since I did a RESETLOGS I am guessing this necessary info is missing. Wondering if everything will be OK if I try to find another way to get the clone opened, like setting the hidden allow corrupt logs parameter. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Monday, July 29, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Did you recover the database using backup controlfile? Try that. HTH, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kirsch, Walter J (Northrop Grumman) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Chart generation tool for db monitoring scripts
Give us a sample SQL output and report on that output. -Original Message- Sent: Monday, July 29, 2002 2:49 PM To: Multiple recipients of list ORACLE-L scripts out MRTG is one. -Original Message- Sent: Monday, July 29, 2002 2:14 PM To: Multiple recipients of list ORACLE-L out Does anyone know of any simple utility that will take a data file and generate a quick chart. I'd like to generate a chart of number of transactions per time period. I can generate the output through a SQL query. Actually I'd like to do this for more data, but this is just an example. Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kirsch, Walter J (Northrop Grumman) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: naming conventions for Oracle/Unix vs. SQL Server
Suzy - it isn't just MS_LAND that uses mixed-case. i've seen more than one non-M$ shop take advantage of that in their namingConvetions. shell scripts, perl, java, and even other non-M$ databases - Sybase on HP-UX for example. i do however agree with the rest of the posts - probably not a good idea in oracleLand ;) funny how passionate some can be about small things like this. we had a rather heated debate on whether this: try { stuff(); more.stuff(); } or this: try { stuff(); more.stuff(); } was to be in our java standards recently. FWIW, the former won out. -Original Message- Sent: Monday, July 29, 2002 12:39 PM To: Multiple recipients of list ORACLE-L Definately underscores, if simply just to break the habit of developers assuming that mixed-case means something outside of MS-land. While SQL-Server does allow/display/use objects in mixed-case format, forcing that into Oracle *can* be done, but it's a bad idea. The Oracle data dictionary stores object definitions upper-case, and allows those objects to be referenced in any mixed case. Forcing object creation in Oracle as mixed-case is a DDL hack using around the object name. At which point, the object can only be accessed in the exact case it was created enclosed with . For example SQL create table Test (id number); SQL desc test ERROR: ORA-04043: object test does not exist SQL desc test ERROR: ORA-04043: object test does not exist SQL desc Test ERROR: ORA-04043: object test does not exist SQL desc Test Name Null?Type - --- ID NUMBER [EMAIL PROTECTED] wrote: Guys, Please help. I work in an organization where we have both SQL Server on NT and Oracle on Unix. SQL Server and developers who are used to GUI's in NT like column names to have mixed case with no underscores. The Unix folk - like myself prefer underscores and one case. Is there any reason not to adopt mixed case for Oracle? Is this really just what I am used to? I have been using this standard for so long that it maybe the reasons I adopted it do not any longer exist or are not as compelling as developer's today are more comfortable with mixed case. Help! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 OLLIG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Install Oracle 8i on Windows XP?
from a private message: | Suggestion: make it clear to the elitist unix bigots that if they | intend to regularly engage in ad hominem attacks and insults that | are clearly intended to disrupt the purpose of the list, which | would include people discussing oracle technology on windows free | of irrelevant b.s., it will be considered a violation of list | rules. | | I delete 98% of posts that are unix/mainframe related, why can't | the unix people do the same thing, and simply focus on what they | are interested in instead of interfering with other people's | conversations? Original Message: - Date: Mon, 29 Jul 2002 10:43:29 -0800 To: [EMAIL PROTECTED] Eric, Need I remind you that this is an Oracle forum? mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cloning Problems
Yeah Ed, your right, when renaming I think RESETLOGS is mandatory. If you see my post referencing the stuff from Tom Kyte you will see the most likely cause. I just wanted to be sure I wasn't losing my mind. I am sure of all the things you mentioned. Another DBA did the copies and I trust him 100%. Thanks for the help. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Monday, July 29, 2002 2:39 PM To: Multiple recipients of list ORACLE-L Ethan, Your first line of the trace file is the same as mine when I clone from cold backups. I also always do clean shutdown normal before cold backup but I think you should be okay with shutdown immediate too (IMHO). I think if you are renaming the cloned database then the RESETLOGS option is required. You said the database was shut down IMMEDIATE and you had no control over this. Did someone else shutdown and do the backup for you? Don't forget to check the obvious. Are you sure the backup was completely closed (not rolling back) before the backup began? (You're used to hot files) Are you sure the database was not restarted before the backup completed? Are you sure you copied ALL files to your cloned database? (I copy everything, then delete control files, then create controlfiles) Take a quick check on the timestamps on the files you backed up. See if there are any time differences that jump out at you. Good luck, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Chart generation tool for db monitoring scripts
Title: RE: Slightly OT: Chart generation tool for db monitoring scripts Couldn't you do this with, for example, Microsoft Excel? I mention Excel because it's very common, but any spreadsheet program like Lotus 123 could probably do it also. -Original Message- Sent: Monday, July 29, 2002 2:14 PM Does anyone know of any simple utility that will take a data file and generate a quick chart. I'd like to generate a chart of number of transactions per time period. I can generate the output through a SQL query. Actually I'd like to do this for more data, but this is just an example. Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
RE: RAC related info
Thanks so much . Can you Give the PUBLISHER's Name / Any Other Details of the Book ? -Original Message- Sent: Monday, July 29, 2002 10:09 PM To: Multiple recipients of list ORACLE-L Check out the book Tru64 Unix - Oracle 9i Cluster - Quick Reference by Tim Donar. Plus there might be some information at : http://www.tru64unix.compaq.com/docs/best_practices/ Darren -Original Message- Sent: July 29, 2002 1:48 AM To: Multiple recipients of list ORACLE-L Hi, everyone! Does anybody have links related to 9i RAC on Tru unix? Advices, trick'n'tips, FAQ's, case studies... Beside technet and metalink, of course. Thank you in advance, Vladimir Barac -- 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: Slightly OT: Chart generation tool for db monitoring scripts
gnuplot on http://sourceforge.net I use it to generate TPM graphs in PNG format, which just happens to be delivered via web, but it obviously doesn't have to. And it even runs on VMS! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 3:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Slightly OT: Chart generation tool for db monitoring scripts Beth, Okay ... here is the whole story (I should have done this in my first mail, but I didn't have time then) ... 1. I currently generate a bunch of HTML reports using SQLPLUS. all these are stored on my file system. Updated periodically by (gasp) MS task scheduler. 2. I have a navigation page that lets me go to a page of my choice and see the tabular data which is in html format. I'd like to have some graphs generated to give more visual clues than having to scan the data manually. This is the reason why I am asking. An important one is to measure the 'current block receive time' for our RAC instance. Thanks for any pointers. Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ONLINE index creation in 8.1.7.2
I've done it 4-6 times on 8.1.7.2 without problems. I'm not sure about this bug though, do you have a number? -Original Message- Sent: Monday, July 29, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Hi all, Has anyone experienced problems using the ONLINE option to create an index on a production 8.1.7.2 DB (HP/UX 11.0, if that matters)? I need to create a largish (for us -- ~300 MB) index on an audit table, but I don't want to lock it while the index is created. I've heard of bugs using ONLINE with indexes and am being paranoid, as usual. TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cloning Problems
I was looking in the docs :-) In Recovery Manager Users Guide and Reference they have a script to shut down the database for cold backup using RMAN. It starts out something like this: # Shut down the database cleanly using immediate priority. This type of shutdown lets # current calls to the database complete, but prevents further logons or calls. # If the database is not up now, you will get a message saying so but RMAN will not # treat this situation as an error. shutdown immediate; # Start up the database in case it crashed or was not shutdown cleanly prior to # starting this script. This will perform a crash recovery if it is needed. Oracle # uses the default INIT.ORA file. Alternatively, use this form: startup force dba # pfile=filename. Use the DBA option because you are going to shut down again right # away and do not want to let users in during the short interval. Use the FORCE # option because it cannot hurt and might help in certain situations. startup force dba; shutdown immediate; # Here, we know that the database is cleanly closed and is now ready for a cold # backup. RMAN requires that the database be started and mounted to perform a backup, # so do that now. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76990/usingrma.htm#435660 You'll need to use your OTN account to see the page. Also in the Glossary they define: clean shutdown: A database shut down with the IMMEDIATE, TRANSACTIONAL, or NORMAL options of the SHUTDOWN command. A database shut down cleanly does not require recovery; it is already in a consistent state. -Original Message- Sent: Monday, July 29, 2002 4:15 PM To: Multiple recipients of list ORACLE-L Shutdown immediate always worked for me with 8.1.6 and 8.1.7.0.0 on HP-UX 11.0. Shutdown abort's another matter entirely. -Original Message- Sent: Monday, July 29, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Ethan, Your first line of the trace file is the same as mine when I clone from cold backups. I also always do clean shutdown normal before cold backup but I think you should be okay with shutdown immediate too (IMHO). I think if you are renaming the cloned database then the RESETLOGS option is required. You said the database was shut down IMMEDIATE and you had no control over this. Did someone else shutdown and do the backup for you? Don't forget to check the obvious. Are you sure the backup was completely closed (not rolling back) before the backup began? (You're used to hot files) Are you sure the database was not restarted before the backup completed? Are you sure you copied ALL files to your cloned database? (I copy everything, then delete control files, then create controlfiles) Take a quick check on the timestamps on the files you backed up. See if there are any time differences that jump out at you. Good luck, Ed -Original Message- Sent: Monday, July 29, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Yeah, went through the standard cloning process. My first line of trace file looked like this... CREATE CONTROLFILE SET DATABASE DM8 RESETLOGS NOARCHIVELOG I am wondering if I should have stated NORESETLOGS here instead, that way the data in the redo logs would be available and then the cloned instance could have performed instance recovery. I have always used the method above and never had any problems but that is likely because I have always done a SHUTDOWN NORMAL instead of SHUTDOWN IMMEDIATE. While the SHUTDOWN immediate performs a checkpoint it looks like there can still be stuff out there in the logs that will require instance recovery. Since I did a RESETLOGS I am guessing this necessary info is missing. Wondering if everything will be OK if I try to find another way to get the clone opened, like setting the hidden allow corrupt logs parameter. Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Monday, July 29, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Did you recover the database using backup controlfile? Try that. HTH, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sherman, Edward INET: [EMAIL PROTECTED] Fat City Network Services-- (858)
RE: OT : Basic Critical O.S. Values that Trigger Problem Alert
Hi We are Trying to make a General Document to be forwarded to Customers which should allow them to know when they are performing far below normal At the Operating System Level we are trying to Identify Practical Critical Values which when below respective Threshold Limits which would give the alert about a potential problem . We are Looking for these in Areas of :- 1) Network Thruput 2) Memory Utilization 3) Swap Utilization 4) IO Utilization Would apreciate actual Commands used (preferably those Generic across different O.S.) respective Critical Threshold Limit Values for the Above EXAMPLE For Network thruput Between APPLICATION Server machine Database Server Machine what , by experience , are the parameters their respective Minimum threshold Values which would let us know that there is a Severe problem therein ? NOTE - We have generally been measuring this by Manually ftping a Big File , about 100MB , between APP DB Server machines , noting the thruput Displayed in (kbytes/s) on Completion Converting this Value to Mega Bits / Second (i.e. MBPS) . If this Value is Less than 40MBPS for a 100 MBPS Cable we know there is a PRoblem with Network Bandwidth. Miscellaneous - Some Threshold Limits known to us :- Command - vmstat 5 3 Virtual Memory Statistics: (pagesize = 8192) procs memorypagesintr cpu r w u act free wire fault cow zero react pin pout in sy cs us sy id 3 1K 34 266K 84K 32K 811M 132M 339M 635 193M0 188 28K 1K 16 7 77 3 1K 33 267K 84K 32K 410 71 151 0 1310 494 2K 4K 4 2 93 3 1K 36 269K 82K 32K 5459 1720 807 0 30160 471 3K 4K 37 5 58 1) Utilization of CPU due to Operating System (Internal) Operations (%sy) Exceeding Utilization due to user Applications (%us) 2) Average Wait of CPU for IO to Complete (%wio) Greater than () 30 % [ From sar Command ] 3) Utilization of CPU due to Operating System (Internal) Operations (%sy) 30 % 4) CPU Utilization - If Total CPU Utilization Consistently Near 0% Idle Or further Coupled with any of the following :- a)Abnormally High Wait for IO ( 30 %) [ From sar Command ] b)Abnormally High Operating System CPU Utilization ( 30 %) c)Abnormally High Run Queue [r (3 * Number of CPUs)] THANKS -- 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).
pfile/spfile Sync Problems
Hi all, I'm in the process of migrating 8i to 9i over the next couple weeks. One of my outstanding tasks it to find a way to keep the pfile/spfile synchronized as much as reasonable possible. I figured the easiest way would be to include startup and shutdown triggers to regenerate them from each other and include similar work in the backup. No, it's not perfect, but should be sufficient to meet the immediate need, after all pfile will eventually go away...maybe. Anyway, I wrote the following segment which works great at the command line: 1 DECLARE 2 spfile VARCHAR2(120); 3 pfileVARCHAR2(120); 4 cursor_handleINTEGER; 5 return_cdINTEGER; 6 BEGIN 7SELECT rtrim(a.value,'bdump')||'pfile/spfile'||b.value||'.ora', 8 rtrim(a.value,'bdump')||'pfile/init'||b.value||'.ora' 9INTO spfile, pfile 10FROM v$parameter a, v$parameter b 11WHERE a.name = 'background_dump_dest' and b.name = 'db_name'; 12cursor_handle:=DBMS_SQL.OPEN_CURSOR; 13DBMS_SQL.PARSE(cursor_handle,'CREATE SPFILE='''||spfile||''' FROM / PFILE='''||pfile||,dbms_sql.native); 14return_cd:=DBMS_SQL.EXECUTE(cursor_handle); 15DBMS_SQL.CLOSE_CURSOR(cursor_handle); 16EXCEPTION 17WHEN OTHERS THEN 18 DBMS_SQL.CLOSE_CURSOR(cursor_handle); 19* END; When I turn it into a trigger: CREATE OR REPLACE TRIGGER sys.sync_spfile AFTER STARTUP ON DATABASE {everything else the same} It compiles fine. However it doesn't execute on startup for some reason. Any ideas? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Differing statuses returned from dba_rollback_segs and v$rollstat
Okay, so today one of our QA databases suddenly started spewing out ora-1552 errors. Turned out all of the rollback segments had a status of FULL. The problem was quickly fixed by taking the rollback segments offline, then back online. The reason why the rollback segments all became FULL is another story. Anyway, before the problem was fixed we queried both dba_rollback_segs and v$rollstat to get the status of the rollback segments. v$rollstat returned FULL, but dba_rollback_segs returned ONLINE. I thought this was interesting (I'm easily amused) so I dug up the DDL for the two views (shown below). The two views appear to get their information from two different places, and both use DECODEs to make the status meaningful. But, there's no DECODE value for FULL in dba_rollback_segs. In fact, the status values for the two can be quite different. Why are they different? This bothers me. Steve Orr is off fishing today so he's not here to provide a rational explanation. Is anyone else bothered by this? Or, should I just laugh it off, pick up the shattered pieces of my life, and soldier on? I've also posted this on the appropriate (I think) Metalink forum. Thanks, --Walt Weaver Bozeman, Montana create or replace view DBA_ROLLBACK_SEGS (SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, FILE_ID, BLOCK_ID, INITIAL_EXTENT, NEXT_EXTENT, MIN_EXTENTS, MAX_EXTENTS, PCT_INCREASE, STATUS, INSTANCE_NUM, RELATIVE_FNO) as select un.name, decode(un.user#,1,'PUBLIC','SYS'), ts.name, un.us#, f.file#, un.block#, s.iniexts * ts.blocksize, decode(bitand(ts.flags, 3), 1, to_number(NULL), s.extsize * ts.blocksize), s.minexts, s.maxexts, decode(bitand(ts.flags, 3), 1, to_number(NULL), s.extpct), decode(un.status$, 2, 'OFFLINE', 3, 'ONLINE', 4, 'UNDEFINED', 5, 'NEEDS RECOVERY', 6, 'PARTLY AVAILABLE', 'UNDEFINED'), decode(un.inst#, 0, NULL, un.inst#), un.file# from sys.undo$ un, sys.seg$ s, sys.ts$ ts, sys.file$ f where un.status$ != 1 and un.ts# = s.ts# and un.file# = s.file# and un.block# = s.block# and s.type# = 1 and s.ts# = ts.ts# and un.ts# = f.ts# and un.file# = f.relfile# === GV$ROLLSTAT select inst_id,kturdusn,kturdext,kturdsiz,kturdwrt,kturdnax,kturdget,kturdwat, d ecode(kturdopt, -1,to_number(null), kturdopt), kturdhwm,kturdnsh,kturdnwp,kturdn ex, kturdash,kturdaae, decode(kturdflg, 0,'ONLINE', 2,'PENDING OFFLINE', 3,'OFFL INE', 4, 'FULL', 'UNKNOWN'), kturdcex, kturdcbk from x$kturd where kturd siz!=0 and kturdflg != 3 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Install Oracle 8i on Windows XP?
Title: RE: Install Oracle 8i on Windows XP? Mr. Pierce - the only ad hominem attacks I saw were from you. Someone posted Don't use Windows, a generic disparagement of the operating system. You immediately responded with a personal insult calling the person an asshole. You then followed it up with a post asserting the cultural superiority of Americans and Israelis over the rest of the world. I suggest that you refrain from personal insults and from political diatribes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] from a private message: | Suggestion: make it clear to the elitist unix bigots that if they | intend to regularly engage in ad hominem attacks and insults that | are clearly intended to disrupt the purpose of the list, which | would include people discussing oracle technology on windows free | of irrelevant b.s., it will be considered a violation of list | rules. | | I delete 98% of posts that are unix/mainframe related, why can't | the unix people do the same thing, and simply focus on what they | are interested in instead of interfering with other people's | conversations?
RE: Cloning Problems
From my understanding you do not need the on-line redo logs unless you perform a shutdown abort. As a matter of fact the database will create the logs if they do not exist when you issue the alter database open resetlogs command. -Original Message- Sent: Monday, July 29, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Ethan, Your first line of the trace file is the same as mine when I clone from cold backups. I also always do clean shutdown normal before cold backup but I think you should be okay with shutdown immediate too (IMHO). I think if you are renaming the cloned database then the RESETLOGS option is required. You said the database was shut down IMMEDIATE and you had no control over this. Did someone else shutdown and do the backup for you? Don't forget to check the obvious. Are you sure the backup was completely closed (not rolling back) before the backup began? (You're used to hot files) Are you sure the database was not restarted before the backup completed? Are you sure you copied ALL files to your cloned database? (I copy everything, then delete control files, then create controlfiles) Take a quick check on the timestamps on the files you backed up. See if there are any time differences that jump out at you. Good luck, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael-EDS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ids and passwords for application users
--Create roles for the possible user types. --Grant permissions to the roles. --Create induhvidual lusers in the database. --Assign the appropriate role to the appopriate luser. Anything else can quickly become a maintenance/monitoring nightmare. This is why roles were rolled out. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Schauss, Peter [SMTP:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Subject: Ids and passwords for application users I am in the process of designing a small database which may have as many as 250 to 300 users. We are reaching a stage where we need to decide how we will control access to this database. As I see it we have two options: 1. Provide a single hidden login for the entire application and control access to the applicaiton itself either by roll your own security or using the operating system (UNIX) controls. 2. Create ids for the users in Oracle and grant them access to the necessary tables using roles. Any opinions or alternate suggestions? thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 11i installation ???
Thank you! I'll try that. --- Yechiel Adar [EMAIL PROTECTED] wrote: Hello Leslie Did you remember to clean up c:\program files\oracle as well. This is where Oracle keeps the install log and files. I think that if you delete also this folder Oracle will start the install from fresh. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 29, 2002 8:49 PM Hi all, I purchased the Oracle 11i Release 5 (with 11.5.6 family packs) CD pack for Windows from Oracle online store. My first installed (Win2000) run out of space, and I cleaned the folders manually. When I got more space and installed again, I got: not all the dependencies for the component OEM common files 2.2.0.0.0 are found. Missing component Oracle.swd.jre 1.1.8.10.0. Looks like the manually cleanup didn't go well. What should I do now? Also, how long does the install take? One guy told me to install one product/one db at a time. Is this a good idea? Is demo db enough? Are there any Oracle 11i group/email list? I know, lots of questions. :-) Thanks! Leslie __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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/APPlication?
Hi, I have DB server and 2 web servers.Couple days back DB server was crashed and back again.I am wondering few processes like (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) on web server.All the applications are working fine.But its strange for me. Is this some kind of hack? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.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).
RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Funny, I just heard a seasoned Oracle consultant say that the 9i exams were considerably more difficult than the 8i exams. --- McBain, Neil SITI-ITDSEL314 [EMAIL PROTECTED] wrote: I have just completed my Oracle 8i OCP DBA using only ten years of experience and the Sybex books (thoroughly recommended, except Backup Recovery does not cover enough RMAN syntax). I believe if you sit the 9i OCP exams then you do have to attend one Oracle course (except if you had sat an Oracle 9i exam prior to a certain date this year), however you can sit the 8i exams and then the 9i upgrade exam without requiring the course (or I hope this is true, since I am studying for the upgrade exam now). Also heard an Oracle trainer say that the 9i exams are easier then the 8i exams but do not now if this is true or not. Hope this is of help, Neil. -Original Message- Sent: 25 July 2002 23:08 To: Multiple recipients of list ORACLE-L Also, isn't Oracle now REQUIRING you to go to THEIR classes to get your certification? On Thu, 2002-07-25 at 14:19, DENNIS WILLIAMS wrote: Paula - I'm skeptical whether a boot camp could cover all the material involved in the OCP tests. I could see where you might come out tuned up enough to whip out a couple of tests, but once you got past them, you'd probably have to do the other tests the hard way -- study for them. I would rate the individual classes as more likely to help you through the OCP, one test at a time. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Guys, I have been working hard on Oracle systems at various levels - various platforms, etc. for 8 years. It has been a long time since I have taken a course. Would like to go to IOUG. Reading e-mails I have made up my mind - I think it gives me more options to get certified. Problem has been I work and have 2 small kids. Also, I am a consultant who has been steadily applied - not a problem but it means I am either working on systems or with my kids. I am thinking this is a way to save myself the time I don't have and force the commitment - is it worth it? I know an unfair question but by taking this and the exams will I indeed completed what it takes to become certified for 9I? -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, July 25, 2002 8:26 AM To: [EMAIL PROTECTED] Hello, Tomorrow (Friday July 26th) is the last day of our Summer Promotion that entitles you to save 50% off our Oracle8i / 9i DBA eBoot Camp. That's right, save $1,749. We have only a handful of remaining seats for our Live, Online, Instructor-led course, so call us and register today!! In case you have lost the previous email I sent, here's the facts: Because the classes must go on...whether there are only 5 or as many as 15 students enrolled...we've decided to allow you the opportunity to register for a seat in one of our upcoming courses for 50% OFF. That's right, instead of the normal $3,499 registration fee for our Oracle8i / 9i DBA eBoot Camp, you can register for only $1,749. Here's what you get: - A 5 week blended eLearning program that includes Instructor Led Training in our Virtual Classroom environment. That's right, you simply need to login to the Virtual Classroom at the designated time to receive Live, Instructor Led Training...without having to leave your home or office! - The course includes training for all 5 Oracle8i OCP DBA exams, plus as a FREE BONUS we are including our Oracle9i New Features for Administrators course that will prepare you for the Oracle9i Upgrade exam. That's a === message truncated === = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ids and passwords for application users
I am in the process of designing a small database which may have as many as 250 to 300 users. We are reaching a stage where we need to decide how we will control access to this database. As I see it we have two options: 1. Provide a single hidden login for the entire application and control access to the applicaiton itself either by roll your own security or using the operating system (UNIX) controls. 2. Create ids for the users in Oracle and grant them access to the necessary tables using roles. Any opinions or alternate suggestions? thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Differing statuses returned from dba_rollback_segs and v$rollstat
I *think* the difference that dba_rollback_segs is a static view, while v$rollstat is dynamic. So the static view shows the segments as ONLINE, which they were, even though they were also full The dynamic view shows what is happening at that moment in time, which is that the segments were FULL. It's an explanation, not a great one, but an explanation. --- Weaver, Walt [EMAIL PROTECTED] wrote: Okay, so today one of our QA databases suddenly started spewing out ora-1552 errors. Turned out all of the rollback segments had a status of FULL. The problem was quickly fixed by taking the rollback segments offline, then back online. The reason why the rollback segments all became FULL is another story. Anyway, before the problem was fixed we queried both dba_rollback_segs and v$rollstat to get the status of the rollback segments. v$rollstat returned FULL, but dba_rollback_segs returned ONLINE. I thought this was interesting (I'm easily amused) so I dug up the DDL for the two views (shown below). The two views appear to get their information from two different places, and both use DECODEs to make the status meaningful. But, there's no DECODE value for FULL in dba_rollback_segs. In fact, the status values for the two can be quite different. Why are they different? This bothers me. Steve Orr is off fishing today so he's not here to provide a rational explanation. Is anyone else bothered by this? Or, should I just laugh it off, pick up the shattered pieces of my life, and soldier on? I've also posted this on the appropriate (I think) Metalink forum. Thanks, --Walt Weaver Bozeman, Montana create or replace view DBA_ROLLBACK_SEGS (SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, FILE_ID, BLOCK_ID, INITIAL_EXTENT, NEXT_EXTENT, MIN_EXTENTS, MAX_EXTENTS, PCT_INCREASE, STATUS, INSTANCE_NUM, RELATIVE_FNO) as select un.name, decode(un.user#,1,'PUBLIC','SYS'), ts.name, un.us#, f.file#, un.block#, s.iniexts * ts.blocksize, decode(bitand(ts.flags, 3), 1, to_number(NULL), s.extsize * ts.blocksize), s.minexts, s.maxexts, decode(bitand(ts.flags, 3), 1, to_number(NULL), s.extpct), decode(un.status$, 2, 'OFFLINE', 3, 'ONLINE', 4, 'UNDEFINED', 5, 'NEEDS RECOVERY', 6, 'PARTLY AVAILABLE', 'UNDEFINED'), decode(un.inst#, 0, NULL, un.inst#), un.file# from sys.undo$ un, sys.seg$ s, sys.ts$ ts, sys.file$ f where un.status$ != 1 and un.ts# = s.ts# and un.file# = s.file# and un.block# = s.block# and s.type# = 1 and s.ts# = ts.ts# and un.ts# = f.ts# and un.file# = f.relfile# === GV$ROLLSTAT select inst_id,kturdusn,kturdext,kturdsiz,kturdwrt,kturdnax,kturdget,kturdwat, d ecode(kturdopt, -1,to_number(null), kturdopt), kturdhwm,kturdnsh,kturdnwp,kturdn ex, kturdash,kturdaae, decode(kturdflg, 0,'ONLINE', 2,'PENDING OFFLINE', 3,'OFFL INE', 4, 'FULL', 'UNKNOWN'), kturdcex, kturdcbk from x$kturd where kturd siz!=0 and kturdflg != 3 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Chart generation tool for db monitoring scripts
Thanks, me being lazy (and excel ignorant), wanted to find an automated way out of this. If I am going to be generating 10-15 graphs, doing it every half hour might just be too much for me. As I said, I am trying to find an easy way out of this. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, July 29, 2002 4:33 PM To: Multiple recipients of list ORACLE-L Couldn't you do this with, for example, Microsoft Excel? I mention Excel because it's very common, but any spreadsheet program like Lotus 123 could probably do it also. *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Slightly OT: Chart generation tool for db monitoring scripts
Raj, I still think MRTG is an option, although I'm sure there are other better ones, like gnuplot that someone else mentioned. Beth -Original Message- Sent: Monday, July 29, 2002 4:08 PM To: Multiple recipients of list ORACLE-L scripts Beth, Okay ... here is the whole story (I should have done this in my first mail, but I didn't have time then) ... 1. I currently generate a bunch of HTML reports using SQLPLUS. all these are stored on my file system. Updated periodically by (gasp) MS task scheduler. 2. I have a navigation page that lets me go to a page of my choice and see the tabular data which is in html format. I'd like to have some graphs generated to give more visual clues than having to scan the data manually. This is the reason why I am asking. An important one is to measure the 'current block receive time' for our RAC instance. Thanks for any pointers. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, July 29, 2002 3:45 PM To: Multiple recipients of list ORACLE-L Hi Raj, What do you want to generate the output in if not html? Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Differing statuses returned from dba_rollback_segs and v$roll
Walt, The reason for the difference in status is that each view monitors a different aspect of rbs. v$rollstat is a performance view and would be constantly updated with such information. dba_rollback_segs is the metadata view and is fairly static. Imagine the thrashing that would occur if the performance info was actually kept in the data dictionary. You will also find similar differences between dba_data_files and v$datafile. HTH, Dan Fink -Original Message- Sent: Monday, July 29, 2002 2:59 PM To: Multiple recipients of list ORACLE-L v$rollstat Okay, so today one of our QA databases suddenly started spewing out ora-1552 errors. Turned out all of the rollback segments had a status of FULL. The problem was quickly fixed by taking the rollback segments offline, then back online. The reason why the rollback segments all became FULL is another story. Anyway, before the problem was fixed we queried both dba_rollback_segs and v$rollstat to get the status of the rollback segments. v$rollstat returned FULL, but dba_rollback_segs returned ONLINE. I thought this was interesting (I'm easily amused) so I dug up the DDL for the two views (shown below). The two views appear to get their information from two different places, and both use DECODEs to make the status meaningful. But, there's no DECODE value for FULL in dba_rollback_segs. In fact, the status values for the two can be quite different. Why are they different? This bothers me. Steve Orr is off fishing today so he's not here to provide a rational explanation. Is anyone else bothered by this? Or, should I just laugh it off, pick up the shattered pieces of my life, and soldier on? I've also posted this on the appropriate (I think) Metalink forum. Thanks, --Walt Weaver Bozeman, Montana create or replace view DBA_ROLLBACK_SEGS (SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, FILE_ID, BLOCK_ID, INITIAL_EXTENT, NEXT_EXTENT, MIN_EXTENTS, MAX_EXTENTS, PCT_INCREASE, STATUS, INSTANCE_NUM, RELATIVE_FNO) as select un.name, decode(un.user#,1,'PUBLIC','SYS'), ts.name, un.us#, f.file#, un.block#, s.iniexts * ts.blocksize, decode(bitand(ts.flags, 3), 1, to_number(NULL), s.extsize * ts.blocksize), s.minexts, s.maxexts, decode(bitand(ts.flags, 3), 1, to_number(NULL), s.extpct), decode(un.status$, 2, 'OFFLINE', 3, 'ONLINE', 4, 'UNDEFINED', 5, 'NEEDS RECOVERY', 6, 'PARTLY AVAILABLE', 'UNDEFINED'), decode(un.inst#, 0, NULL, un.inst#), un.file# from sys.undo$ un, sys.seg$ s, sys.ts$ ts, sys.file$ f where un.status$ != 1 and un.ts# = s.ts# and un.file# = s.file# and un.block# = s.block# and s.type# = 1 and s.ts# = ts.ts# and un.ts# = f.ts# and un.file# = f.relfile# === GV$ROLLSTAT select inst_id,kturdusn,kturdext,kturdsiz,kturdwrt,kturdnax,kturdget,kturdwat, d ecode(kturdopt, -1,to_number(null), kturdopt), kturdhwm,kturdnsh,kturdnwp,kturdn ex, kturdash,kturdaae, decode(kturdflg, 0,'ONLINE', 2,'PENDING OFFLINE', 3,'OFFL INE', 4, 'FULL', 'UNKNOWN'), kturdcex, kturdcbk from x$kturd where kturd siz!=0 and kturdflg != 3 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).