Re: ETAGON...
I concur about the software prices on big machines. We work with IBM mainframes and the last upgrade cost us a lot in SOFTWARE licenses, since we moved into a higher performance group. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 7:49 PM Well, I'm going to get involved here saying upfront that my company is a competitor of Etagon's, so I'm certainly biased, both about us vs. Etagon and RAC in general. However, the financial savings of RAC can be significant - we do cost analyses all the time of RAC for potential customers, and its often as simple as: 2 mid-size sun servers (we'll say 16 processors) - $300,000 each = $600,000 a cluster of 5 4-way servers = $100,000 Cost of RAC per processor (list, even!) - $20,000 x 20 = $400,000 So, not taking into account the cost of clustering software for the two big sun boxes, the cost of downtime due to hardware failure, sun platinum support, discounted RAC licenses, forklift upgrades, and more expensive backup and other software licenses for larger servers - basically the simplest analysis you can do, RAC is still $100k cheaper. If we do add in those other factors, RAC becomes even more cost-effective. Where some of those cost savings get eaten up, though is in additional complexity and administration cost - which is where companies like mine and Etagon find a market. RAC is hard, there's no question. The financial savings in RAC generally don't come from the license costs (I can show how you can save on license costs, but we're straying into an advertisement for our product at that point), they come from improved availability and reduced hardware costs. Big SMP servers are exponentially more expensive than small ones, and the software that runs on them is correspondingly exponentially expensive. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Thursday, December 04, 2003 3:29 AM To: Multiple recipients of list ORACLE-L Subject: Re: ETAGON... Etagon invited me to come and visit them at their stand at the UKOUG conference in Birmingham next week. Don't know if I'll have time or not, but in general I'm still looking for hard evidence of financial savings using RAC, ie a real comparison where switching to RAC (on whatever platform) meant lower license costs in total. I've only seen calculations where the price of RAC was omitted or hugely discounted. I'm even willing to ignore the increase in complexity that follows from clustering and RAC'ing... One thing, though, that I will not accept, is this notion of TCO. It seems that anybody can use that thing to prove any point, so it becomes hard to compare :). If RAC is cheaper for you than non-RAC it must be because you save the $20K per CPU somewhere else. Or? Mogens Gunnar Berglund wrote: Hi all, I would like to hear, if you have any experience concering Etagon... Short review: Etagon is an Israeli company and their product is Data Center Automation SW focussing initially on Oracle 9i RAC clustering SW. Etagon claims that their SW can produce fundamental savings in 9i RAC installation and lifecycle management. Please see their web site; www.etagon.com http://www.etagon.com I'd be interested to hear if you know Etagon already and in any case what is your take on their value proposition. Is 9i RAC installation maintenance a real pain point to you? And could Etagon SW possibly ease that pain? -- -- Download Yahoo! Messenger http://uk.rd.yahoo.com/mail/tagline_messenger/*http://downloa d.yahoo.com/dl/intl/ymsgruk.exe now for a chance to WIN http://uk.rd.yahoo.com/mail/tagline_messenger/*http://messenger.promotions. yahoo.com/rwuk Robbie Williams Live At Knebworth DVD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network
Re: How to Find Client OS type from Oracle 8174......
Just a thought. A big company (you mentioned 900 user logged in) probably has inventory of all the machines used. Get a list of the machine and try to find someone who can match it, or send you inventory records and you can do the matching yourself. Yechiel AdarMehish - Original Message - From: Janardhana Babu Donga To: Multiple recipients of list ORACLE-L Sent: Thursday, December 04, 2003 10:44 PM Subject: How to Find Client OS type from Oracle 8174.. Dear List, We have TXN processing system with as many as 900 users log in at any point of time. We have the necessity to find what OS type the client is using (Windows 95, NT 2000 etc). I tried thru V$SESSION, V$SESSION_CONNECT_INFO and V$PROCESS, but couldn't find any useful info to get the client OS type. I also looked at the NET8 documentation to see if I can get any such info. I am not successful in getting such information from any source. Could some one help me how I should get such info. Appreciate a reply. -- Janardhana
more on block corruption
short question: if i fix a corrupted block using dbms_repair to mark block software corrupt, will I be able to access data contained in that block? thanks in advance... Regards, Rhojel
Re: How windows manage memory: oracle
Thanks Paul. I did a check this week with out Win2000 tech support and was told that it come with 3GB process size while WNT was limited to 2GB (without special parameters). What is this pslist command? Is it something from Unix? Yechiel AdarMehish - Original Message - From: Paul Drake To: Multiple recipients of list ORACLE-L Sent: Thursday, December 04, 2003 7:34 PM Subject: Re: How windows manage memory: oracle Hi. The 2 GB process limit kicks in well under 2 * 1024 *1024 * 1024. its between 1.7 and 1.8 GB. I'm quite familiar with hitting it in win32, as large memory support was not enabled in every 8.1.7.x patchset. Large memory support sure works great in 9.2.0.4. W2K3 Server (not Advanced) ships with large memory support. In Windows 2000, one needed to acquire Advanced Server edition for large memory support. ways that you know that you hit the process memory limit: 1. unable to startup instance 2. unable to spawn a dedicated server process (in listener.log) 3. unable to allocate n bytes of memory in the shared pool (in the user's error message) For tracking memory usage by a process (namely, oracle.exe), I'd recommend using the sysinternals pslist utility, and log that to an OS file. There is the performance logs option in the OS, which gives you the benefits of setting a max file size which will be filled in a circular fashion. http://www.sysinternals.com hth. Pd Yechiel Adar [EMAIL PROTECTED] wrote: I do not see the problem.SGA is 970M + PGA (20*40) 800 MB + executables and you got about 2GB whichis the upper limit on NT, unless you used special startup parameter.Yechiel AdarMehish- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Thursday, December 04, 2003 3:24 PM Hi, friends: Several months ago there is a thread talking about choosing the propermemory size for windows server running oracle. And today I logon to one of my small oracle on NT and found somethingI cannot understand. It is a small application running Oracle 817/win2k. SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from taskmanager, Oracle is using 1005M physical Memory and 1013M virtual memory(youcan view the data from here: http://www.cnoug.org/html/ut/attach/2003/12/04/12516-oramem2-embed.gif). SQL show sga Total System Global Area 971040796 bytes Fixed Size 75804 bytes Variable Size 299798528 bytes Database Buffers 671088640 bytes Redo Buffers 77824 byte SQL select count(*) from v$session; COUNT(*) -- 18 SQL select sum(value) from v$sesstat where statistic#=(select statistic#from v$statname where name='session pga memory max'); SUM(VALUE) -- 39526196 And I looked at another server running SAP/oracle, get similiar data: http://www.cnoug.org/html/ut/attach/2003/12/04/12518-sap-embed.gif (780M sga,33 connection and 25M pga). Can someone explain it? Regards Zhu Chao. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Yechiel AdarINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!?Free Pop-Up Blocker - Get it now
RE: Analytic bug in 9.2.0.4
ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [], [], [] on 9.2.0.4 64 bit; Solaris 2.8 mvg/regards Jo Prem Khanna J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 03:14 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analytic bug in 9.2.0.4 You are right Jared. ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [],[], [] this is on oracle 9.2.0.3 Win2k+SP3. Regards, Jp. -Original Message- While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. This bit of SQL is a bit useless as is, that is, for anything other than causing ORA-600. This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: more on block corruption
IIRC - no. The block will be marked as corrupted and you can not access it. Maybe you can dump the block using OS tools and see what data is in there. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Friday, December 05, 2003 9:24 AM Subject: more on block corruption short question: if i fix a corrupted block using dbms_repair to "mark block software corrupt", will I be able to access data contained in that block? thanks in advance... Regards, Rhojel
Re: Expense of 'over ... partition by'
Jared, I think what you've discovered is just a repeat of the fact that different functionality is appropriate in different circumstances. Imagine replacing your v$sql_workarea_histogram with a chunky SQL statement that crunched through a massive table producing a small result set. In those circumstances, your analytic approach would sort a small set twice having done one big crunch. With the group by approach, you would have to crunch the big data set twice. I know which option would be cheaper. (You then have to wonder whether you could produce the small result set using subquery factoring 'with subquery' as another possible optimisation strategy). BTW - did you notice how Oracle didn't do a sort for the order by in the GROUP BY example, because the optimizer could infer that the data had already been ordered by the GROUP BY ? That's the reason why your GROUP BY example did less sorting. (I'm not sure you need the GROUP BY, though I may be missing something). BTW-2: in the analytic clause, the (partition by 1) is not necessary, you can write: , sum(optimal_executions) over ( ) Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:24 AM While working on some scripts to monitor PGA usage on 9i, I came across something interesting while experimenting with different forms of SQL. I have recently been forcing myself to make use of 'OVER..PARTITION BY' in SQL so as to be more comfortable in using it. Can't add new tools to the box until I know how to use them. :) Yes, I know I should have been using them long ago. Anyway, I thought it might be interesting to compare the forms of SQL with and without the use of OVER...PARTITION BY. This SQL can be run on any instance that has PGA_AGGREGATE_TARGET set. Here is the SQL using OVER: select low_optimal_size_kb , high_optimal_size_kb , optimal_executions , onepass_executions , multipasses_executions , total_executions , optimal_executions / sum_optimal_executions * 100 pct_optimal_executions from ( select low_optimal_size/1024 low_optimal_size_kb , (high_optimal_size+1)/1024 high_optimal_size_kb , optimal_executions , onepass_executions , multipasses_executions , total_executions , sum(optimal_executions) over ( partition by 1 ) sum_optimal_executions from v$sql_workarea_histogram where total_executions != 0 ) a order by low_optimal_size_kb / and here is the SQL using good old GROUP BY select low_optimal_size_kb , high_optimal_size_kb , optimal_executions , onepass_executions , multipasses_executions , total_executions , optimal_executions / sum_optimal_executions * 100 pct_optimal_executions from ( select h.low_optimal_size/1024 low_optimal_size_kb , (h.high_optimal_size+1)/1024 high_optimal_size_kb , h.optimal_executions , h.onepass_executions , h.multipasses_executions , h.total_executions , hs.sum_optimal_executions from v$sql_workarea_histogram h, ( select sum(optimal_executions) sum_optimal_executions from v$sql_workarea_histogram ) hs where h.total_executions != 0 group by h.low_optimal_size/1024 ,(h.high_optimal_size+1)/1024 , h.optimal_executions , h.onepass_executions , h.multipasses_executions , h.total_executions , hs.sum_optimal_executions ) a order by low_optimal_size_kb / The new version is significantly simpler. It then seemed that it might be interesting to compare the performance and scalability of the two methods. This is where it gets interesting. 16:10:47 rsysdevdb.radisys.com - [EMAIL PROTECTED] SQL @run_stats NAME RUN1 RUN2 DIFF -- -- -- LATCH.lgwr LWN SCN1 0 -1 LATCH.mostly latch-free SCN 1 0 -1 LATCH.undo global data1 0 -1
Re: Analytic bug in 9.2.0.4
Fixed in 10. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:29 AM While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Internet Directory
Hi! Does anybody out there have any experience with the setup and administration of Oracle Internet Directory (OID)? Do you have any white papers or presentations on how to do so? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: wait events that indicate lack of bind variables
Also add the library cache load and pin events to that. Anjo. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 5:19 AM 1. latch free for the shared pool latch (a shared pool latch in 9i). 2. Indirectly, SQL*Net message from client and CPU service time consumption too, because not using bind variables probably means that an application parses more often than it needs to. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 2:24 PM To: Multiple recipients of list ORACLE-L Which wait events are indications that your missing bind variables? btw, if you want to implement bind variables through a c/c++ middle tier its best to use 'prepared statements'. correct? bind arrays can be issued as prepared statements right? This is when you need to do alot of inserts from the middle tier to the database with just one pass to the database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dba studio in oracle9.2
Hi all, I have installed oracle 9.2 server and managemenst server on windows. I have perform full installation. But there is no DBA Studio in oracle tools. Any comment. Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dba studio in oracle9.2
The functionality is now integrated in the console. mvg/regards Jo [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 11:29 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:dba studio in oracle9.2 Hi all, I have installed oracle 9.2 server and managemenst server on windows. I have perform full installation. But there is no DBA Studio in oracle tools. Any comment. Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How windows manage memory: oracle
Title: Message winternalssoftware runs a website called sysinternals which has a bunch of useful free utilities for windows (and IIRC Linux now as well). pslist is one of those utilities. www.sysinternals.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Yechiel AdarSent: 05 December 2003 07:24To: Multiple recipients of list ORACLE-LSubject: Re: How windows manage memory: oracle Thanks Paul. I did a check this week with out Win2000 tech support and was told that it come with 3GB process size while WNT was limited to 2GB (without special parameters). What is this pslist command? Is it something from Unix? Yechiel AdarMehish - Original Message - From: Paul Drake To: Multiple recipients of list ORACLE-L Sent: Thursday, December 04, 2003 7:34 PM Subject: Re: How windows manage memory: oracle Hi. The 2 GB process limit kicks in well under 2 * 1024 *1024 * 1024. its between 1.7 and 1.8 GB. I'm quite familiar with hitting it in win32, as large memory support was not enabled in every 8.1.7.x patchset. Large memory support sure works great in 9.2.0.4. W2K3 Server (not Advanced) ships with large memory support. In Windows 2000, one needed to acquire Advanced Server edition for large memory support. ways that you know that you hit the process memory limit: 1. unable to startup instance 2. unable to spawn a dedicated server process (in listener.log) 3. unable to allocate n bytes of memory in the shared pool (in the user's error message) For tracking memory usage by a process (namely, oracle.exe), I'd recommend using the sysinternals pslist utility, and log that to an OS file. There is the performance logs option in the OS, which gives you the benefits of setting a max file size which will be filled in a circular fashion. http://www.sysinternals.com hth. Pd Yechiel Adar [EMAIL PROTECTED] wrote: I do not see the problem.SGA is 970M + PGA (20*40) 800 MB + executables and you got about 2GB whichis the upper limit on NT, unless you used special startup parameter.Yechiel AdarMehish- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Thursday, December 04, 2003 3:24 PM Hi, friends: Several months ago there is a thread talking about choosing the propermemory size for windows server running oracle. And today I logon to one of my small oracle on NT and found somethingI cannot understand. It is a small application running Oracle 817/win2k. SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from taskmanager, Oracle is using 1005M physical Memory and 1013M virtual memory(youcan view the data from here: http://www.cnoug.org/html/ut/attach/2003/12/04/12516-oramem2-embed.gif). SQL show sga Total System Global Area 971040796 bytes Fixed Size 75804 bytes Variable Size 299798528 bytes Database Buffers 671088640 bytes Redo Buffers 77824 byte SQL select count(*) from v$session; COUNT(*) -- 18 SQL select sum(value) from v$sesstat where statistic#=(select statistic#from v$statname where name='session pga memory max'); SUM(VALUE) -- 39526196 And I looked at another server running SAP/oracle, get similiar data: http://www.cnoug.org/html/ut/attach/2003/12/04/12518-sap-embed.gif (780M sga,33 connection and 25M pga). Can someone explain it? Regards Zhu Chao. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Yechiel AdarINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing:
RE: dba studio in oracle9.2
Bahar , i think it's only OEM with 9iR2. ... and perhaps u have everything there . Regards, Jp. -Original Message- On Behalf Of [EMAIL PROTECTED] Hi all, I have installed oracle 9.2 server and managemenst server on windows. I have perform full installation. But there is no DBA Studio in oracle tools. Any comment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java package to run OS command
Thanks for all the replies...I'm wading through them! One more question...Do I always need to specify the full path of a Unix command e.g /usr/bin/mv rather then just mv That is something I don't currently need to do when using an external procedure. John -Original Message- Sent: 04 December 2003 20:15 To: Multiple recipients of list ORACLE-L No, but it disallows command chains - only single commands are permitted. If you want to run more than one command you have to write it as a shell script, and the full path to that shell script must be approved for the current user in the PRODUCT_PROFILE table. Normally, we will only allow scripts to run from certain controlled directories. But we need to be able to permit commands that we didn't think about when we wrote the procedure, and prefer to do this table driven rather than by changing programs. -Original Message- Sent: Thursday, December 04, 2003 1:39 PM To: Multiple recipients of list ORACLE-L will it catch following command apart from rm -rf ??? find /var/opt/oracle/logs -mtime +1 -type f -name *.trc|perl -nle unlink Probably not ... and that's why it is dangerous ... basically you should have a set of fixed programs that can be called and accept only arguments from calling programs. That will give at-least more control. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, December 04, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Dick, harsh words, hmmm? Powerful tools can also be powerful weapons in the wrong hands. But don't blame the toolmaker. John, the reason that running an OS command is such a hassle is that it can be horribly destructive to your server. An OS command that runs from a Java Stored Procedure such as the one from www.oracle-base.com that I gave you or the one that Tom Kyte wrote and published on Ask Tom will have all the permissions of the oracle database. Which means that it can be abused to absolutely destroy the database, just as in Dick's example. Doing this with an external procedure as we do is also dangerous. If you use a separate Oracle Net listener for them, instead of LISTENER, and have another user besides the database owner (usually oracle) start that listener, and password protect the listener, you can at least have some control over the permissions, which will be those of the user that starts the listener. People who run Oracle under Windows may be out of luck here - it is harder to get this running under a less privileged account in Windows. We do one more thing for security. We have a special schema in the database called COMMON that owns tables and stored procedures that are usable by all applications. We put the stub program for the external procedure that executes OS commands in a package as a private procedure. The public procedure that calls this private procedure can examine the OS command first. Certain commands, like rm -fr are absolutely forbidden, and raise an exception. Other commands are checked against the PRODUCT_PROFILE table which we set up much as for restrictions for what commands certain users may run in SQL*Plus. If the current user (or schema) does not have the explicit privilege to run that OS command, we raise an exception. You could easily put a similar protective shell around the Java version of the same thing. ** 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. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
ORA-02045 on 8.1.7.0.0
Hello @all, maybe this is a newbie question (at least I am) I've got an Oracle 8.1.7 installation on Sun Solaris 8 (sparc). We use some database management software which gegerates several select-statements going over ten database users. After some seconds (everytime in another db-user and another table), the system prints out the following error: ORA-02045: too many local sessions participating in global transaction ORA-02063: preceding line from STGTSU What's up here? greetz Elmar -- +++ GMX - die erste Adresse für Mail, Message, More +++ Neu: Preissenkung für MMS und FreeMMS! http://www.gmx.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Elmar Hartung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java package to run OS command
Our Unix guys create 'safe' versions of normal utilities and installed them in a special folder. So, we use the full path to invoke them from *that* folder. Some commands get logged to audit files. I'd say, yeah, specify full path, you don't loose much (well some electrons, but who cares). Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Friday, December 05, 2003 6:14 AM To: Multiple recipients of list ORACLE-L Thanks for all the replies...I'm wading through them! One more question...Do I always need to specify the full path of a Unix command e.g /usr/bin/mv rather then just mv That is something I don't currently need to do when using an external procedure. John ** 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. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analytic bug in 9.2.0.4
works on 9202 but that's not what you wanted to hear ... right? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, December 04, 2003 7:29 PMTo: Multiple recipients of list ORACLE-LSubject: Analytic bug in 9.2.0.4While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. Here's the SQL: select pga_target_for_estimate , pga_target_factor , low_optimal_size , high_optimal_size , estd_optimal_executions , estd_onepass_executions , estd_multipasses_executions , estd_total_executions , ignored_workareas_count from v$pga_target_advice_histogram where pga_target_for_estimate in ( select pga_target_for_estimate from ( select max(pga_target_for_estimate) over ( partition by pga_target_for_estimate) pga_target_for_estimate , sum(estd_multipasses_executions) over ( partition by pga_target_for_estimate) sum_estd_multipasses , max(high_optimal_size) over ( partition by pga_target_for_estimate) max_high_optimal_size from v$pga_target_advice_histogram ) a where sum_estd_multipasses 1 group by pga_target_for_estimate, sum_estd_multipasses ) order by pga_target_for_estimate, low_optimal_size / This bit of SQL is a bit useless as is, that is, for anything other than causing ORA-600. This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared **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.**4
RE: background process LGWR did not start
Is it possible there are stuck memory segments (using ipcs -m when instance is shutdown) ?? Any other errors in alert log, etc ? - Babette -Original Message- Sent: 2003-12-04 9:34 AM To: Multiple recipients of list ORACLE-L Anyone know what might be causing this error? Oracle 8.1.7 on Solaris. background process LGWR did not start -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oradebug suspend question
Tanel, I know, we are not what we would like to be, so I am trying to find some middle point. We can't make drastic changes to app, ESPN's daily business including on-air scores and programming gets affected by that (not to mention the huge calculators that run to estimate how much money we make by charging all of you to watch ESPN g). Thanks, you almost confirmed my fear. ps: I just got confirmed to Hotsos/04 and Steve Adams class, so hopefully I'll meet you in Dallas, TX. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Thursday, December 04, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Then have two sets of packages for reports, when releasing new versions, do them on set 2 whilst normal users are running on set 1. This gives you time to test new versions in production as well. When tests are successful, switch to set 2. Oh yes, this requires your application/reports to be aware of this set architecture. Basically you should have some kind of control table where you state on which set newly executed reports should run. Btw, how can you have constant DML activity and reporting going on when you have suspended your sessions? When your session executes a package and is suspended, the package is still pinned anyway and you cant just replace it on the fly. The baseline is, despite RAC you still one single database and you can't have this kind of online updating without doing some fundamental changes in the app. Tanel. ** 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. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analytic bug in 9.2.0.4
The same thing occurs on OpenVMS on version 9.2.0.4 of Oracle. Nelson -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Thursday, December 04, 2003 7:29 PMTo: Multiple recipients of list ORACLE-LSubject: Analytic bug in 9.2.0.4While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. Here's the SQL: select pga_target_for_estimate , pga_target_factor , low_optimal_size , high_optimal_size , estd_optimal_executions , estd_onepass_executions , estd_multipasses_executions , estd_total_executions , ignored_workareas_count from v$pga_target_advice_histogram where pga_target_for_estimate in ( select pga_target_for_estimate from ( select max(pga_target_for_estimate) over ( partition by pga_target_for_estimate) pga_target_for_estimate , sum(estd_multipasses_executions) over ( partition by pga_target_for_estimate) sum_estd_multipasses , max(high_optimal_size) over ( partition by pga_target_for_estimate) max_high_optimal_size from v$pga_target_advice_histogram ) a where sum_estd_multipasses 1 group by pga_target_for_estimate, sum_estd_multipasses ) order by pga_target_for_estimate, low_optimal_size / This bit of SQL is a bit useless as is, that is, for anything other than causing ORA-600. This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared
Re: DB Slow, v$session_wait shoeing SQL*Net message from client
Simon, what is your CPU consumption? Are CPUs executing oracle processes (top) or sitting idle? If CPUs are executing oracle processes, you may have a problem with parsing. If they're sitting idle and doing nothing, your client program(s) may be to blame or you may have a network problem. Have you tried pinging the database server from a client PC? What kind of network do you have and what are the response times? On 12/05/2003 12:39:26 AM, [EMAIL PROTECTED] wrote: Hi Gurus- Peformence of my DB(8174, Tru64 Unix) has terribly slowed down! Checked Indexes, Stats, etc but all look fine to me. Only one strange thing: I have more than 100 sessions in the v$session wait with same EVENT,P1TEXT, P1,STATE (SQL*Net message from client ,driver id,1413697536,WAITING). Refs to the v$session_wait view indicate that P1 is a hex representation and 1413697536==TCP. QNS: 1) Is it normal to have all these waits? 2) Does this mean clients are waiting to 'hear' from oracle hence the apparent slowdown Can anyone out explain to me the meaning of this and possible remedy. Thanking you all- CSW Simon. DBA -MTN Uganda. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: No links on search results for PDFs in UltraSearch
No, it couldn't. That is the problem. They are telling me to hack up my own makefile. So far, I've been unsuccessful, that is precisely why I'm asking. On 12/04/2003 04:49:30 PM, Jesse, Rich wrote: Perhaps the homepage on http://www.selfsoft.com/progs/mod_plsql/ could help? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, December 04, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Speaking of Apache, does anyone have a good makefile to link MOD_PLSQL into Apache? Does anybody know how to get mod_plsql into Apache2? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Analytic bug in 9.2.0.4
Do you know when will this fabulous version 10 be available for download? On 12/05/2003 04:14:34 AM, Jonathan Lewis wrote: Fixed in 10. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:29 AM While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analytic bug in 9.2.0.4
It wasnt fixed in my version of 9.2.0.3: ERROR at line 11: ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [], [], [] 9.2.0.3, 32-bit. Solaris 8. Brian - | Brian McGraw -+- Senior DBA | | mailto:[EMAIL PROTECTED] | - -Original Message- [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 6:29 PM To: Multiple recipients of list ORACLE-L While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. Here's the SQL: select pga_target_for_estimate , pga_target_factor , low_optimal_size , high_optimal_size , estd_optimal_executions , estd_onepass_executions , estd_multipasses_executions , estd_total_executions , ignored_workareas_count from v$pga_target_advice_histogram where pga_target_for_estimate in ( select pga_target_for_estimate from ( select max(pga_target_for_estimate) over ( partition by pga_target_for_estimate) pga_target_for_estimate , sum(estd_multipasses_executions) over ( partition by pga_target_for_estimate) sum_estd_multipasses , max(high_optimal_size) over ( partition by pga_target_for_estimate) max_high_optimal_size from v$pga_target_advice_histogram ) a where sum_estd_multipasses 1 group by pga_target_for_estimate, sum_estd_multipasses ) order by pga_target_for_estimate, low_optimal_size / This bit of SQL is a bit useless as is, that is, for anything other than causing ORA-600. This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How windows manage memory: oracle
My favorite SF computer is Holly, from the Red Dwarf. Add a hologram like Rimmer and who needs anything else? I believe that Holly was running MS-Windows. On 12/04/2003 04:44:26 PM, Bellow, Bambi wrote: I know I've posted this before, but it's been many years, so here we go again. NT was supposed to be Windows' answer to VMS. WNT, doesn't stand for anything, so how did they come up with the name? V+1=W M+1=N S+1=T Just like I-1=H B-1=A M-1=L Coincidence? Bambi. -Original Message- Sent: Thursday, December 04, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Even though I have never touched VMS myself, I completely agree that it is (was) a great operating system, I've just heard so many good words from respectable sources about it :) About Windows, probably the initial idea was great but since MS is a marketing driven company, they just left off most of the good pieces in order to release new versions sooner... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 10:19 PM That is utterly disgusting memory management. When I come to think of it, there was a guy named David Cutler who was promising that Windows will have the same virtual memory system as VMS, with FREELIM,FREEGOAL, BORROWLIM, GROWLIM and MPW_ parameters. Working sets are also gone as well as the most elaborate privileges system until that time. Authorize was a wonderful tool which still leaves anything that either windows or Unix can offer in the dust. On 12/04/2003 02:54:31 PM, Tanel Poder wrote: SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from task manager, Oracle is using 1005M physical Memory and 1013M virtual memory(you can view the data from here: http://www.cnoug.org/html/ut/attach/2003/12/04/12516-oramem2-embed.gif). Physical memory and virtual memory overlap in windows. If you have allocated 100M of memory, but only 50M of it is mapped to physical memory (rest is in pagefile), you see 100M and 50M accordingly in task manager. Also, there is a situation where you can have more physical memory than virtual memory. Im not sure, but it might be doing something with deallocated memory, which is not reclaimed by OS or smth like that. There is a note about windows nt memory management in metalink, search from there if want additional information. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
Patch to 9.2.0.4
Hi Oracle 9.2.0.3 AIX 5L anyone fail to start an instance after upgrading to 9.2.0.4 Everytime I try to start my instance which was working before the patch, I receive 07445 errors. Got the usual call raised but thought I would ask in case anyone had similar issues. Regards Lee ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analytic bug in 9.2.0.4
It works fine for me - 9.2.0.3, 64-bit, Solaris 9 -Debbie -Original Message- Brian McGraw Sent: Friday, December 05, 2003 8:09 AM To: Multiple recipients of list ORACLE-L It wasn't fixed in my version of 9.2.0.3: ERROR at line 11: ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [], [], [] 9.2.0.3, 32-bit. Solaris 8. Brian - | Brian McGraw -+- Senior DBA | | mailto:[EMAIL PROTECTED] | - -Original Message- [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 6:29 PM To: Multiple recipients of list ORACLE-L While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. Here's the SQL: select pga_target_for_estimate , pga_target_factor , low_optimal_size , high_optimal_size , estd_optimal_executions , estd_onepass_executions , estd_multipasses_executions , estd_total_executions , ignored_workareas_count from v$pga_target_advice_histogram where pga_target_for_estimate in ( select pga_target_for_estimate from ( select max(pga_target_for_estimate) over ( partition by pga_target_for_estimate) pga_target_for_estimate , sum(estd_multipasses_executions) over ( partition by pga_target_for_estimate) sum_estd_multipasses , max(high_optimal_size) over ( partition by pga_target_for_estimate) max_high_optimal_size from v$pga_target_advice_histogram ) a where sum_estd_multipasses 1 group by pga_target_for_estimate, sum_estd_multipasses ) order by pga_target_for_estimate, low_optimal_size / This bit of SQL is a bit useless as is, that is, for anything other than causing ORA-600. This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *** The contents of this communication are intended only for the addressee and may contain confidential and/or privileged material. If you are not the intended recipient, please do not read, copy, use or disclose this communication and notify the sender. Opinions, conclusions and other information in this communication that do not relate to the official business of my company shall be understood as neither given nor endorsed by it. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hrncirik, Debbie INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT - LHC
Hadrons are a class of elementary particles. A large hadron collider is a device for smashing them together at extremely high energies and seeing what happens. It is a very expensive, and very effective, way of finding out what matter is made of. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobak, Mark Sent: 03 December 2003 22:09 To: Multiple recipients of list ORACLE-L Subject: RE: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING If you read the full text of the article pointed to by the URL in the original posting, you learn that 'LHC' is 'Large Hadron Collider', whatever that is. ;-) Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Wednesday, December 03, 2003 4:55 PM To: Multiple recipients of list ORACLE-L what is an LHC? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 3:44 PM CERN estimates growth about 5-10 petabytes per year when they start their LHC in 2007... Data load rates vary up to 1,5GB per second. I would work there even for free for some time ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:09 PM are you using a grid at stanford? how much data do they have at CERN? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/03 Wed PM 02:49:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING http://www.interactions.org/cms/?pid=1008211 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: java package to run OS command
Title: RE: java package to run OS command Take a look at metalink doc 222079.1 -Original Message- From: John Dunn [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 04, 2003 7:49 AM To: Multiple recipients of list ORACLE-L Subject: java package to run OS command I need a java package that will allow me to run OS commands(Unix) from a stored procedure. Anyone got one? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Reporting database
Hi Faan, Thanks Faan for this effectively critical point. Like you I have faced this problem after applying some patch (FND patches on 11.5.7) and since I have standby database as emergency environment. It was big problem. I wrote a scripts to detect such events and I read some metalink docs that said Oracle will leave these unrecoverable options on their future patches. Have nice day, Kader --- Faan DeSwardt [EMAIL PROTECTED] wrote: Kader, Just a word of caution when considering options. Keep an eye on all the Apps objects that have NOLOGGING set. Last time I checked there were over a thousand of those which were mostly indexes but there are some tables among them. These are a real pain when using redo log refreshing/updating techniques like Quest's SharePlex and Dataguard. Definitely check out Metalink notes 216212.1 and 216211.1 when considering and implementing this refreshing technique. Good Luck and may the Force be with you! -f -Original Message- Sent: Wednesday, December 03, 2003 1:45 PM To: Multiple recipients of list ORACLE-L At 06:24 3-12-03 -0800, you wrote: Hi Listers, I'm about producing document to my boss about different strategies to build Informational database (reporting database) and ETL. Our production database is 9i supporting Oracle Financials 11i. I'm concerned about the strategies that have a minimum impact on the overload of production database. Could you please give me your advise and experience. Any input well be very appreciated. Hi Kader, What do you mean with ETL? Is your reporting database a DWH, and are you considering unload from production and ETL into it? Or do you just need an exact copy of your production database? What frequency should it be updated? Daily, Weekly, real-time? For some of these options Data Guard might be a solution, for others not. For a daily update you can create a (physical) standby database and put it in read-only mode. You can query along, transactions get forwarded but not processed in the meantime. Every midnight, for instance, you switch the standby from R/O to Managed Recovery mode, and it will 'synchronise' using the redologs received since the last synchronisation. After synchronisation put it back into R/O mode, and you can query all day long. During synchronisation the database isn't available for reporting. Data Guard comes for free with your Oracle Licence. However, as discussed in an earlier thread on this list, you have to pay for the standby server, unless , AFAIK, you're paying according to the named-user-plus model. It will give you the lowest possible overhead on your production database, except from using non-oracle storage level options like mirroring disks and detach them every n hours. Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carel-Jan Engel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Faan DeSwardt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also
RE: OT - LHC
Good analogy to this methodology is to take a watch, wrap it in a towel, smash it with a hammer, then try to figure out how it worked by looking at the pieces. Henry --who stayed away from any area in physics where the author list was longer than the paper abstract -Original Message- Niall Litchfield Sent: Friday, December 05, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hadrons are a class of elementary particles. A large hadron collider is a device for smashing them together at extremely high energies and seeing what happens. It is a very expensive, and very effective, way of finding out what matter is made of. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobak, Mark Sent: 03 December 2003 22:09 To: Multiple recipients of list ORACLE-L Subject: RE: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING If you read the full text of the article pointed to by the URL in the original posting, you learn that 'LHC' is 'Large Hadron Collider', whatever that is. ;-) Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Wednesday, December 03, 2003 4:55 PM To: Multiple recipients of list ORACLE-L what is an LHC? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 3:44 PM CERN estimates growth about 5-10 petabytes per year when they start their LHC in 2007... Data load rates vary up to 1,5GB per second. I would work there even for free for some time ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 10:09 PM are you using a grid at stanford? how much data do they have at CERN? From: MacGregor, Ian A. [EMAIL PROTECTED] Date: 2003/12/03 Wed PM 02:49:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ORACLE JOINS CERN OPENLAB TO ADVANCE GRID COMPUTING http://www.interactions.org/cms/?pid=1008211 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: dbua ORA-12545
Running dbua to upgrade 8.1.7 to 9.2.0 database produces: ORA-12545: Connect failed because target host or object does not exist. Very annoying because looking at logs under .../assistants subdirectories and ../admin/upgrade/logs or the alert log - directories doesn't show what the missing target or object is. Then dbua just hangs and I have to rollback. Grrr!!! I am seriously considering using the manual migration (not dbua or export/import) but running mig manually so I can see exactly what is happening. Anyone have any information on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analytic bug in 9.2.0.4
too funny. It was 'fixed' in 9203. According to Jonathan, it has actually been fixed in 10. Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 04:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analytic bug in 9.2.0.4 works on 9202 but that's not what you wanted to hear ... right? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 7:29 PM To: Multiple recipients of list ORACLE-L Subject: Analytic bug in 9.2.0.4 While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. Here's the SQL: select pga_target_for_estimate , pga_target_factor , low_optimal_size , high_optimal_size , estd_optimal_executions , estd_onepass_executions , estd_multipasses_executions , estd_total_executions , ignored_workareas_count from v$pga_target_advice_histogram where pga_target_for_estimate in ( select pga_target_for_estimate from ( select max(pga_target_for_estimate) over ( partition by pga_target_for_estimate) pga_target_for_estimate , sum(estd_multipasses_executions) over ( partition by pga_target_for_estimate) sum_estd_multipasses , max(high_optimal_size) over ( partition by pga_target_for_estimate) max_high_optimal_size from v$pga_target_advice_histogram ) a where sum_estd_multipasses 1 group by pga_target_for_estimate, sum_estd_multipasses ) order by pga_target_for_estimate, low_optimal_size / This bit of SQL is a bit useless as is, that is, for anything other than causing ORA-600. This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared ** 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. **4
RE: dbua ORA-12545
Paula, Just follow the steps for manually upgrading in the upgrade guide as you have stated. The dbua doesn't really give you a lot of information when things go wrong. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 07:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: dbua ORA-12545 Running dbua to upgrade 8.1.7 to 9.2.0 database produces: ORA-12545: Connect failed because target host or object does not exist. Very annoying because looking at logs under .../assistants subdirectories and ./admin/upgrade/logs or the alert log - directories doesn't show what the missing target or object is. Then dbua just hangs and I have to rollback. Grrr!!! I am seriously considering using the manual migration (not dbua or export/import) but running mig manually so I can see exactly what is happening. Anyone have any information on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analytic bug in 9.2.0.4
With a couple of exceptions, it appears that it is consistently buggy on several platforms. iTar time I guess. Thanks, Jared Hrncirik, Debbie [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 06:29 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analytic bug in 9.2.0.4 It works fine for me - 9.2.0.3, 64-bit, Solaris 9 -Debbie -Original Message- Brian McGraw Sent: Friday, December 05, 2003 8:09 AM To: Multiple recipients of list ORACLE-L It wasn't fixed in my version of 9.2.0.3: ERROR at line 11: ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [], [], [], [], [], [] 9.2.0.3, 32-bit. Solaris 8. Brian - | Brian McGraw -+- Senior DBA | | mailto:[EMAIL PROTECTED] | - -Original Message- [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 6:29 PM To: Multiple recipients of list ORACLE-L While playing around with SQL for some PGA scripts, I managed to create some SQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. Here's the SQL: select pga_target_for_estimate , pga_target_factor , low_optimal_size , high_optimal_size , estd_optimal_executions , estd_onepass_executions , estd_multipasses_executions , estd_total_executions , ignored_workareas_count from v$pga_target_advice_histogram where pga_target_for_estimate in ( select pga_target_for_estimate from ( select max(pga_target_for_estimate) over ( partition by pga_target_for_estimate) pga_target_for_estimate , sum(estd_multipasses_executions) over ( partition by pga_target_for_estimate) sum_estd_multipasses , max(high_optimal_size) over ( partition by pga_target_for_estimate) max_high_optimal_size from v$pga_target_advice_histogram ) a where sum_estd_multipasses 1 group by pga_target_for_estimate, sum_estd_multipasses ) order by pga_target_for_estimate, low_optimal_size / This bit of SQL is a bit useless as is, that is, for anything other than causing ORA-600. This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *** The contents of this communication are intended only for the addressee and may contain confidential and/or privileged material. If you are not the intended recipient, please do not read, copy, use or disclose this communication and notify the sender. Opinions, conclusions and other information in this communication that do not relate to the official business of my company shall be understood as neither given nor endorsed by it. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hrncirik, Debbie INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbua ORA-12545
Paule, you have TWO_TASK environment variable set and dbua is trying to connect to host it cannot find. Unset TWO_TASK and everything will be OK. On 12/05/2003 10:54:25 AM, [EMAIL PROTECTED] wrote: Running dbua to upgrade 8.1.7 to 9.2.0 database produces: ORA-12545: Connect failed because target host or object does not exist. Very annoying because looking at logs under .../assistants subdirectories and ../admin/upgrade/logs or the alert log - directories doesn't show what the missing target or object is. Then dbua just hangs and I have to rollback. Grrr!!! I am seriously considering using the manual migration (not dbua or export/import) but running mig manually so I can see exactly what is happening. Anyone have any information on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: background process LGWR did not start
Hi John! When I've run into this problem it was because there was a memory segment being forced open. If you have the same issue, I can hep. First, assuming that you're on Unix (if you're not, please ignore the rest of this email and just have a lovely day), and that your database is down (otherwise, if you wanted to do a shutdown abort, that wouldn't be such a bad thing), you can do an ipcs -mA If that was the only instance on your box, the rest is pretty easy, cuz the offending segment is the only one owned by oracle in the list. If it wasn't, and there are other oracle segments on the box, you have to find out which one is your guy. The memory segments associated with a particular instance should have very similar (but not exactly the same) CTIMEs. If there is one way out of whack, that's your guy. Now, this is where my memory gets a little fuzzy (age, doncha know?)... if the instances started up at nearly exactly the same time for some reason, you are looking for a 0 in the insert hem and haw segsz(?) column (anybody remember fersher on this one?). By now, you should know which memory segment to kill. To kill the offending memory segment, do an ipcrm -m segment on it. You, of course, want to be exceedingly careful here, and just assume that all the usual disclaimers apply. If you kill the wrong segment, your other database is not going to be very happy about it. But assuming you killed the right segment, your database with the LGWR problem should be well and truly down. Bring 'er on up and the LGWR process should come up just fine. Bambi. -Original Message- Sent: Thursday, December 04, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Anyone know what might be causing this error? Oracle 8.1.7 on Solaris. background process LGWR did not start -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Expense of 'over ... partition by'
Thanks Jonathan. Lack of some decent docs and my inexperience with analytics led me to the (partition by 1). Someone mentioned that Tom Kyte's book has a good chapter on them, so I'll go look that up. You're right, the group by is unnecessary in that query, it's an artifact of an earlier incarnation of the query. Removing it seemed to make little difference in Larry Elkins pointed out that the SQL could be greatly simplified via the ratio_to_report() function. It appears below. The standard SQL approach is more appropriate for this, I agree. I'm just trying to use newer functionality as much as possible so as to be familiar with it. select low_optimal_size/1024 low_optimal_size_kb , (high_optimal_size+1)/1024 high_optimal_size_kb , optimal_executions , onepass_executions , multipasses_executions , total_executions , optimal_executions / total_executions * 100 pct_optimal_executions , onepass_executions / total_executions * 100 pct_onepass_executions , multipasses_executions / total_executions * 100 pct_multipasses_executions , ratio_to_report(optimal_executions) over ( ) * 100 pct_total_optimal_executions from v$sql_workarea_histogram where total_executions != 0 order by low_optimal_size_kb Here is the latest run_stats from it - quite an improvement with ratio_to_report() ( RUN1 ) NAME RUN1RUN2DIFF -- -- -- LATCH.Consistent RBA 1 0 -1 LATCH.lgwr LWN SCN1 0 -1 LATCH.mostly latch-free SCN1 0 -1 LATCH.redo allocation 19 18 -1 STAT...calls to kcmgcs 7 6 -1 STAT...consistent gets 4 5 1 STAT...cursor authentications 0 1 1 STAT...deferred (CURRENT) block cleanout 4 3 -1 applications STAT...redo entries 17 18 1 STAT...enqueue requests 1 0 -1 STAT...db block gets 28 29 1 STAT...consistent gets - examination 0 1 1 STAT...cleanout - number of ktugct calls 0 1 1 STAT...calls to get snapshot scn: kcmgss10061005 -1 STAT...active txn count during cleanout 0 1 1 LATCH.undo global data 1 0 -1 LATCH.library cache pin20122010 -2 STAT...session logical reads 32 34 2 LATCH.redo writing2 0 -2 LATCH.cache buffers chains 102105 3 STAT...recursive cpu usage32 29 -3 LATCH.library cache pin allocation4 8 4 LATCH.messages 6 0 -6 LATCH.shared pool 10011008 7 LATCH.library cache 20142022 8 STAT...redo size 27084 27496412 LATCH.SQL memory manager workarea list l 020002000 atch 27 rows selected. Jared Jonathan Lewis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 01:14 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Expense of 'over ... partition by' Jared, I think what you've discovered is just a repeat of the fact that different functionality is appropriate in different circumstances. Imagine replacing your v$sql_workarea_histogram with a chunky SQL statement that crunched through a massive table producing a small result set. In those circumstances, your analytic approach would sort a small set twice having done one big crunch. With the group by approach, you would have to crunch the big data set twice. I know which option would be cheaper. (You then have to wonder whether you could produce the small result set using subquery factoring 'with subquery' as another possible optimisation strategy). BTW - did you notice how Oracle didn't do a sort for the order by in the GROUP BY example, because the optimizer could infer that the data had already been ordered by the GROUP BY ? That's the reason why your GROUP BY example did less sorting. (I'm not sure you need the GROUP BY, though I may be missing something). BTW-2: in the analytic clause, the (partition by 1) is not necessary, you can write: , sum(optimal_executions) over ( ) Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 12:24 AM While working on some scripts to monitor PGA usage on 9i, I came across something interesting while experimenting with different
RE: background process LGWR did not start
In regards to Bambi's comments about having a single instance on the server, this situation gets more complex if you have several instances on a server. There's also the possibility that the instance(s) shared memory is in more than one segment. You can use ipcs and oradebug to decipher which memory segments belong to which instance. Google for ipcs and oradebug, several helpful references showed up when I tried it. HTH Jared Bellow, Bambi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 08:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: background process LGWR did not start Hi John! When I've run into this problem it was because there was a memory segment being forced open. If you have the same issue, I can hep. First, assuming that you're on Unix (if you're not, please ignore the rest of this email and just have a lovely day), and that your database is down (otherwise, if you wanted to do a shutdown abort, that wouldn't be such a bad thing), you can do an ipcs -mA If that was the only instance on your box, the rest is pretty easy, cuz the offending segment is the only one owned by oracle in the list. If it wasn't, and there are other oracle segments on the box, you have to find out which one is your guy. The memory segments associated with a particular instance should have very similar (but not exactly the same) CTIMEs. If there is one way out of whack, that's your guy. Now, this is where my memory gets a little fuzzy (age, doncha know?)... if the instances started up at nearly exactly the same time for some reason, you are looking for a 0 in the insert hem and haw segsz(?) column (anybody remember fersher on this one?). By now, you should know which memory segment to kill. To kill the offending memory segment, do an ipcrm -m segment on it. You, of course, want to be exceedingly careful here, and just assume that all the usual disclaimers apply. If you kill the wrong segment, your other database is not going to be very happy about it. But assuming you killed the right segment, your database with the LGWR problem should be well and truly down. Bring 'er on up and the LGWR process should come up just fine. Bambi. -Original Message- Sent: Thursday, December 04, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Anyone know what might be causing this error? Oracle 8.1.7 on Solaris. background process LGWR did not start -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: background process LGWR did not start
I can almost guarantee that the issue will go away if you reboot the machine. I cannot fathom how would shared memory segments survive reboot. On 12/05/2003 11:49:24 AM, [EMAIL PROTECTED] wrote: In regards to Bambi's comments about having a single instance on the server, this situation gets more complex if you have several instances on a server. There's also the possibility that the instance(s) shared memory is in more than one segment. You can use ipcs and oradebug to decipher which memory segments belong to which instance. Google for ipcs and oradebug, several helpful references showed up when I tried it. HTH Jared Bellow, Bambi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 08:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: background process LGWR did not start Hi John! When I've run into this problem it was because there was a memory segment being forced open. If you have the same issue, I can hep. First, assuming that you're on Unix (if you're not, please ignore the rest of this email and just have a lovely day), and that your database is down (otherwise, if you wanted to do a shutdown abort, that wouldn't be such a bad thing), you can do an ipcs -mA If that was the only instance on your box, the rest is pretty easy, cuz the offending segment is the only one owned by oracle in the list. If it wasn't, and there are other oracle segments on the box, you have to find out which one is your guy. The memory segments associated with a particular instance should have very similar (but not exactly the same) CTIMEs. If there is one way out of whack, that's your guy. Now, this is where my memory gets a little fuzzy (age, doncha know?)... if the instances started up at nearly exactly the same time for some reason, you are looking for a 0 in the insert hem and haw segsz(?) column (anybody remember fersher on this one?). By now, you should know which memory segment to kill. To kill the offending memory segment, do an ipcrm -m segment on it. You, of course, want to be exceedingly careful here, and just assume that all the usual disclaimers apply. If you kill the wrong segment, your other database is not going to be very happy about it. But assuming you killed the right segment, your database with the LGWR problem should be well and truly down. Bring 'er on up and the LGWR process should come up just fine. Bambi. -Original Message- Sent: Thursday, December 04, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Anyone know what might be causing this error? Oracle 8.1.7 on Solaris. background process LGWR did not start -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views
RE: Patch to 9.2.0.4
Hmmm, ignore my post. For an unconnected reason we had to reboot the server and I can start the instance no problems. -Original Message- Robertson Lee - lerobe Sent: 05 December 2003 14:30 To: Multiple recipients of list ORACLE-L Hi Oracle 9.2.0.3 AIX 5L anyone fail to start an instance after upgrading to 9.2.0.4 Everytime I try to start my instance which was working before the patch, I receive 07445 errors. Got the usual call raised but thought I would ask in case anyone had similar issues. Regards Lee ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Poor performance importing LOBS
Hi, I have a apps 11.0 table that we have been importing with no problem but when we upgraded to apps 11.i the import takes 10 times as long. Upon inspection I found two of the columns have been converted to LOBS. I found a few articles on metalinks that referenced the slow import of LOBS but nothing to really fix it. I bumped the import buffer up to 64M and that helped by about 25% but we need more. I would appreciate any ideas. We are running 8.1.7.4 Thanks Craig Ward Southern Systems Solutions, Inc. 803-817-6438 mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: background process LGWR did not start
also 'sysresv' will show which shared memory segments and semaphore sets belong to an instance. Matt Adams - GE Appliances - [EMAIL PROTECTED]Their fundamental design flaws are completelyhidden by their superficial design flaws. - Douglas Adams -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, December 05, 2003 11:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: background process "LGWR" did not startIn regards to Bambi's comments about having a single instance on the server, this situation gets more complex if you have several instances on a server. There's also the possibility that the instance(s) shared memory is in more than one segment. You can use ipcs and oradebug to decipher which memory segments belong to which instance. Google for ipcs and oradebug, several helpful references showed up when I tried it. HTH Jared "Bellow, Bambi" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 08:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: background process "LGWR" did not startHi John!When I've run into this problem it was because there was a memory segmentbeing forced open. If you have the same issue, I can hep. First, assumingthat you're on Unix (if you're not, please ignore the rest of this email andjust have a lovely day), and that your database is down (otherwise, if youwanted to do a shutdown abort, that wouldn't be such a bad thing), you cando an ipcs -mAIf that was the only instance on your box, the rest is pretty easy, cuz theoffending segment is the only one owned by oracle in the list. If itwasn't, and there are other oracle segments on the box, you have to find outwhich one is your guy. The memory segments associated with a particularinstance should have very similar (but not exactly the same) CTIMEs. Ifthere is one way out of whack, that's your guy. Now, this is where mymemory gets a little fuzzy (age, doncha know?)... if the instances startedup at nearly exactly the same time for some reason, you are looking for a"0" in the insert hem and haw segsz(?) column (anybody remember fersher onthis one?). By now, you should know which memory segment to kill. To kill the offending memory segment, do an ipcrm -m segmenton it. You, of course, want to be exceedingly careful here, and just assumethat all the usual disclaimers apply. If you kill the wrong segment, yourother database is not going to be very happy about it.But assuming you killed the right segment, your database with the LGWRproblem should be well and truly down. Bring 'er on up and the LGWR processshould come up just fine.Bambi.-Original Message-Sent: Thursday, December 04, 2003 8:34 AMTo: Multiple recipients of list ORACLE-LAnyone know what might be causing this error? Oracle 8.1.7 on Solaris.background process "LGWR" did not start-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: John DunnINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bellow, BambiINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
tis a puzzlement...
database 8.1.7.2 Solaris 64 bit exp 9.2.0.1/8.1.7 same user, same database, schema export, same command line options exp user/[EMAIL PROTECTED] compress=n rows=y file=export.dmp log=log.txt 8.1.7 exports fine. 9.2.0.1 gives an ORA 942. OK so what am i missing here? which FM do i RT? i thought the 9 would export an 8.1.7 database or am i misunderstanding what i've read? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] 1916 General theory of relativity. Gravity is a warping of space-time. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Compare Index on Number Varchar2
I had a similar question a while back. Specifically my question was, is it faster to join on a numeric-based index or a varchar(2) based index. After much research, and a discussion with an Oracle PT friend of mine, the answer was/is: It depends. There is no right answer; your results will vary based on your specific situation and your data. suggestion: create both test cases, set on the autotracing and timing, and compare results. boss One of the column in a new table can be ename - varchar2(20) or hase_code_e= name - number(11) =96 Hash Code generated by JAVA. =0AWe are going to creat= e non-unique index on this column as one frequent query will have where cla= use on this column only. Choice is either varchar2(20) or number(11).=0A1.= Is Non-unique index on Number is faster then varchar2? Why?=0A2. If Number = column has negative values, then will it affect performance of Non-unique i= ndex on it? =0A3. How much space Number Varchar2 consume? i.e storage spa= ce difference between number(10) and varchar2(10)=0A=0ATillu=0A=0A --Next_1070355278---0-202.54.124.178-31576-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sahil patel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: tis a puzzlement...
Bill, why are you trying to export an 8i database with 9i exp? The export views are different, it shouldn't be expected to work. I don't believe there is any equivalent of catexp7 for 8i/9i. Jared On Fri, 2003-12-05 at 09:29, Thater, William wrote: database 8.1.7.2 Solaris 64 bit exp 9.2.0.1/8.1.7 same user, same database, schema export, same command line options exp user/[EMAIL PROTECTED] compress=n rows=y file=export.dmp log=log.txt 8.1.7 exports fine. 9.2.0.1 gives an ORA 942. OK so what am i missing here? which FM do i RT? i thought the 9 would export an 8.1.7 database or am i misunderstanding what i've read? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] 1916 General theory of relativity. Gravity is a warping of space-time. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Analytic bug in 9.2.0.4
Title: Message Just to add to the list Tru64/Trucluster 5.1b - 9.2.0.4 rac from v$pga_target_advice_histogram *ERROR at line 11:ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [], [],[], [], [], [], [] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, December 05, 2003 8:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Analytic bug in 9.2.0.4With a couple of exceptions, it appears that it is consistently buggy on several platforms. iTar time I guess. Thanks, Jared "Hrncirik, Debbie" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 06:29 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Analytic bug in 9.2.0.4It works fine for me - 9.2.0.3, 64-bit, Solaris 9-Debbie-Original Message-Brian McGrawSent: Friday, December 05, 2003 8:09 AMTo: Multiple recipients of list ORACLE-LIt wasn't fixed in my version of 9.2.0.3:ERROR at line 11:ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [],[],[], [], [], [], []9.2.0.3, 32-bit. Solaris 8.Brian-| Brian McGraw -+- Senior DBA || mailto:[EMAIL PROTECTED] |--Original Message-[EMAIL PROTECTED]Sent: Thursday, December 04, 2003 6:29 PMTo: Multiple recipients of list ORACLE-LWhile playing around with SQL for some PGA scripts, I managed to create someSQL that will consistently cause ORA-600 [kkqwrm_noref: COLFDNF set] This appears to be Bug # 2507421, which was supposedly fixed in 9.2.0.3. Here's the SQL: select pga_target_for_estimate , pga_target_factor , low_optimal_size , high_optimal_size , estd_optimal_executions , estd_onepass_executions , estd_multipasses_executions , estd_total_executions , ignored_workareas_count from v$pga_target_advice_histogram where pga_target_for_estimate in ( select pga_target_for_estimate from ( select max(pga_target_for_estimate) over ( partition bypga_target_for_estimate) pga_target_for_estimate , sum(estd_multipasses_executions) over ( partitionby pga_target_for_estimate) sum_estd_multipasses , max(high_optimal_size) over ( partition bypga_target_for_estimate) max_high_optimal_size from v$pga_target_advice_histogram ) a where sum_estd_multipasses 1 group by pga_target_for_estimate, sum_estd_multipasses ) order by pga_target_for_estimate, low_optimal_size / This bit of SQL is a bit useless as is, that is, for anything other thancausing ORA-600. This is on 9.3.0.4 on RH Linux 7.2 Kernel 2.4.20-18.7smp It also appears on 9.2.0.4 on Win2k SP3. Anyone else see similar results? On a test database of course. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Brian McGrawINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).*** The contents of this communication are intended only for the addressee andmay contain confidential and/or privileged material. If you are not theintended recipient, please do not read, copy, use or disclose thiscommunication and notify the sender. Opinions, conclusions and otherinformation in this communication that do not relate to the officialbusiness of my company shall be understood as neither given nor endorsed byit. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Hrncirik, DebbieINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: background process LGWR did not start
Rebooting is not always an option. On Fri, 2003-12-05 at 09:04, Mladen Gogala wrote: I can almost guarantee that the issue will go away if you reboot the machine. I cannot fathom how would shared memory segments survive reboot. On 12/05/2003 11:49:24 AM, [EMAIL PROTECTED] wrote: In regards to Bambi's comments about having a single instance on the server, this situation gets more complex if you have several instances on a server. There's also the possibility that the instance(s) shared memory is in more than one segment. You can use ipcs and oradebug to decipher which memory segments belong to which instance. Google for ipcs and oradebug, several helpful references showed up when I tried it. HTH Jared Bellow, Bambi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 08:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: background process LGWR did not start Hi John! When I've run into this problem it was because there was a memory segment being forced open. If you have the same issue, I can hep. First, assuming that you're on Unix (if you're not, please ignore the rest of this email and just have a lovely day), and that your database is down (otherwise, if you wanted to do a shutdown abort, that wouldn't be such a bad thing), you can do an ipcs -mA If that was the only instance on your box, the rest is pretty easy, cuz the offending segment is the only one owned by oracle in the list. If it wasn't, and there are other oracle segments on the box, you have to find out which one is your guy. The memory segments associated with a particular instance should have very similar (but not exactly the same) CTIMEs. If there is one way out of whack, that's your guy. Now, this is where my memory gets a little fuzzy (age, doncha know?)... if the instances started up at nearly exactly the same time for some reason, you are looking for a 0 in the insert hem and haw segsz(?) column (anybody remember fersher on this one?). By now, you should know which memory segment to kill. To kill the offending memory segment, do an ipcrm -m segment on it. You, of course, want to be exceedingly careful here, and just assume that all the usual disclaimers apply. If you kill the wrong segment, your other database is not going to be very happy about it. But assuming you killed the right segment, your database with the LGWR problem should be well and truly down. Bring 'er on up and the LGWR process should come up just fine. Bambi. -Original Message- Sent: Thursday, December 04, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Anyone know what might be causing this error? Oracle 8.1.7 on Solaris. background process LGWR did not start -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor
Re: background process LGWR did not start
No, but in this case, it's exactly what they did. Good, old ctrlaltdel saved the day. I just thought I might suggest it. After all, they did have an oracle version of BSOD. On 12/05/2003 12:59:25 PM, Jared Still wrote: Rebooting is not always an option. On Fri, 2003-12-05 at 09:04, Mladen Gogala wrote: I can almost guarantee that the issue will go away if you reboot the machine. I cannot fathom how would shared memory segments survive reboot. On 12/05/2003 11:49:24 AM, [EMAIL PROTECTED] wrote: In regards to Bambi's comments about having a single instance on the server, this situation gets more complex if you have several instances on a server. There's also the possibility that the instance(s) shared memory is in more than one segment. You can use ipcs and oradebug to decipher which memory segments belong to which instance. Google for ipcs and oradebug, several helpful references showed up when I tried it. HTH Jared Bellow, Bambi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 08:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: background process LGWR did not start Hi John! When I've run into this problem it was because there was a memory segment being forced open. If you have the same issue, I can hep. First, assuming that you're on Unix (if you're not, please ignore the rest of this email and just have a lovely day), and that your database is down (otherwise, if you wanted to do a shutdown abort, that wouldn't be such a bad thing), you can do an ipcs -mA If that was the only instance on your box, the rest is pretty easy, cuz the offending segment is the only one owned by oracle in the list. If it wasn't, and there are other oracle segments on the box, you have to find out which one is your guy. The memory segments associated with a particular instance should have very similar (but not exactly the same) CTIMEs. If there is one way out of whack, that's your guy. Now, this is where my memory gets a little fuzzy (age, doncha know?)... if the instances started up at nearly exactly the same time for some reason, you are looking for a 0 in the insert hem and haw segsz(?) column (anybody remember fersher on this one?). By now, you should know which memory segment to kill. To kill the offending memory segment, do an ipcrm -m segment on it. You, of course, want to be exceedingly careful here, and just assume that all the usual disclaimers apply. If you kill the wrong segment, your other database is not going to be very happy about it. But assuming you killed the right segment, your database with the LGWR problem should be well and truly down. Bring 'er on up and the LGWR process should come up just fine. Bambi. -Original Message- Sent: Thursday, December 04, 2003 8:34 AM To: Multiple recipients of list ORACLE-L Anyone know what might be causing this error? Oracle 8.1.7 on Solaris. background process LGWR did not start -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,
RE: tis a puzzlement...
Jared Still scribbled on the wall in glitter crayon: Bill, why are you trying to export an 8i database with 9i exp? because i thought i read somewhere that it would work. maybe i'm confusing it with imp? will 9i imp read an 81 exp file? it's either that, or i've experienced an ORA 99 - brain burnt out.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Great spirits have always found violent opposition from mediocrities. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tis a puzzlement...
Usual rule of thumb - export using the oldest RDBMS version in the transfer, import using the imp for the database to which you are importing. So export with your 8.1.7 version of exp, and if you are moving to 9.2 import with the 9.2 version of imp. -Original Message- Sent: Friday, December 05, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Bill, why are you trying to export an 8i database with 9i exp? The export views are different, it shouldn't be expected to work. I don't believe there is any equivalent of catexp7 for 8i/9i. Jared On Fri, 2003-12-05 at 09:29, Thater, William wrote: database 8.1.7.2 Solaris 64 bit exp 9.2.0.1/8.1.7 same user, same database, schema export, same command line options exp user/[EMAIL PROTECTED] compress=n rows=y file=export.dmp log=log.txt 8.1.7 exports fine. 9.2.0.1 gives an ORA 942. OK so what am i missing here? which FM do i RT? i thought the 9 would export an 8.1.7 database or am i misunderstanding what i've read? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] 1916 General theory of relativity. Gravity is a warping of space-time. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tis a puzzlement...
9i imp handles 8i dmp files. 9i exp does not like to connect to 8i databases though. At least that has been my experience migrating one of our 3rd party DBs. John P Weatherman Oracle Database Administrator Replacements, Ltd. -Original Message- Sent: Friday, December 05, 2003 1:34 PM To: Multiple recipients of list ORACLE-L Jared Still scribbled on the wall in glitter crayon: Bill, why are you trying to export an 8i database with 9i exp? because i thought i read somewhere that it would work. maybe i'm confusing it with imp? will 9i imp read an 81 exp file? it's either that, or i've experienced an ORA 99 - brain burnt out.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Great spirits have always found violent opposition from mediocrities. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tis a puzzlement...
ahhh shouldn't you use the exp from 9.2 for 9.2 and the exp for 8.1.7 for 8.1.7...?? -Original Message- Sent: Friday, December 05, 2003 11:29 AM To: Multiple recipients of list ORACLE-L database 8.1.7.2 Solaris 64 bit exp 9.2.0.1/8.1.7 same user, same database, schema export, same command line options exp user/[EMAIL PROTECTED] compress=n rows=y file=export.dmp log=log.txt 8.1.7 exports fine. 9.2.0.1 gives an ORA 942. OK so what am i missing here? which FM do i RT? i thought the 9 would export an 8.1.7 database or am i misunderstanding what i've read? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] 1916 General theory of relativity. Gravity is a warping of space-time. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Poor performance importing LOBS
What's the CACHE and LOGGING values for these LOBs (from dba_lobs view). If you have NOCACHE LOBs, then import has to write these immediately to disk using direct writes (and to redologs, depending on LOGGING setting). When you have CACHE LOBs, these don't have to be written to datafiles immediately, they can remain in buffer cache until DBWR writes them to disks. Btw, when using import, set your recordlength to 65535. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 7:09 PM Hi, I have a apps 11.0 table that we have been importing with no problem but when we upgraded to apps 11.i the import takes 10 times as long. Upon inspection I found two of the columns have been converted to LOBS. I found a few articles on metalinks that referenced the slow import of LOBS but nothing to really fix it. I bumped the import buffer up to 64M and that helped by about 25% but we need more. I would appreciate any ideas. We are running 8.1.7.4 Thanks Craig Ward Southern Systems Solutions, Inc. 803-817-6438 mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database management techniques and frameworks
We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You cant spend your time reading the alert log. you should poll it and get an email when something pops up. Same with chained rows, tablespace sizes, etc... Write scripts for this and send your self emails. Have statspack snapshots run daily. From: [EMAIL PROTECTED] Date: 2003/12/05 Fri PM 01:49:30 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database management techniques and frameworks Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where there are many instances, multiple databases, different platforms/versions, etc., what are some of the strategies for management in place? What daily tasks do you perform, and how do you organize them? How do you manage user requests (individually or as part of a larger environment)? How do you handle jobs? Organization techniques? Naming standards? User/application deployment framework, etc., etc.? (Obviously we could write a book about this -- there's an idea! -- but summaries and pointers would be interesting. Perhaps we can come up with a best practices document and associated framework for Oracle database management.) Thanks, Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database management techniques and frameworks
Well said, Ryan! I have about the same number of instances, all on Sun. Development responsibilities also. One DBA. Time off is difficult. Excellent advice on emailing results. I have found the tools cause you about as much maintenance as they might save, so I favor simple scripts with emailed results. If you have time to visit each instance each day, you have way too much time on your hands. But I can recall those days when I only had 2 instances too. Fondly recall. For user/developer requests, the magic phrase I've found is can I do that for you tomorrow morning? Before leaving for the day I prepare a list of tasks for the next morning, and when I arrive I defer anything that I can to concentrate on my list and ticking off tasks on that list. Try to get meetings moved to the afternoon. Just basic time management, and everyone is different. For mature applications, I've found autoextend on datafiles to be a big time-saver. I've used that for many years now and only been bitten by that a couple of times. Much simpler to watch one number (available disk space) than dozens of numbers. For deployment, we are working toward ITIL procedures. We have test, staging, production instances for most databases, so I and developers can deploy against a staging instance before inflicting a deployment on production. Staging is a fresh clone of production. Naming standards are good, but I have found that some sites get so wrapped up in them that they cause more work than they prevent. Often packaged applications are mainly tested against their default configuration so if you insist on changing everything to meet your standards, you end up finding bugs nobody else found. One technique I have had good results with is to prepare an audit sheet and when time is available, pick an instance and audit it for security, performance, recoverability, etc. During the audit, make up a list of tasks to perform on that instance, and as time permits, execute those tasks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 1:09 PM To: Multiple recipients of list ORACLE-L We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You cant spend your time reading the alert log. you should poll it and get an email when something pops up. Same with chained rows, tablespace sizes, etc... Write scripts for this and send your self emails. Have statspack snapshots run daily. From: [EMAIL PROTECTED] Date: 2003/12/05 Fri PM 01:49:30 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database management techniques and frameworks Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where there are many instances, multiple databases, different platforms/versions, etc., what are some of the strategies for management in place? What daily tasks do you perform, and how do you organize them? How do you manage user requests (individually or as part of a larger environment)? How do you handle jobs? Organization techniques? Naming standards? User/application deployment framework, etc., etc.? (Obviously we could write a book about this -- there's an idea! -- but summaries and pointers would be interesting. Perhaps we can come up with a best practices document and associated framework for Oracle database management.) Thanks, Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
Re: Database management techniques and frameworks
So your approach is to write a series of custom scripts, add them to (I assume) oracle's crontab for periodic execution. Do you have one single machine (or pair of machines) that monitor remote databases? Or do you install these scripts on each database server? Do you leverage dbms_jobs? And relying on email seems kind of iffy -- what happens if you're not around to check your email? Page system? Escalation matrix in place? Not trying to ruffle any feathers here, and certainly, I appreciate the time requirements in fully answering a question as broad as the one I submitted, but I would like to probe further into various strategies. The whole run scripts to check, install statspack, etc. approach seems both highly unscalable and leaves much to the whim of the individual DBA. So what, you've installed statspack? Do you use it regularly? Is this a manual review, or is some system in place to monitor changes? How easy is it to deploy this framework? (Does anyone here use Oracle's SNMP agents for monitoring? I've leveraged these -- along with a home-grown SNMP NMS (in Perl) -- to some degree at a multiple database site to good effect.) Are there any 'design patterns for databases' around? Should we come up with some? (I'll post my own notes on the topic of management in a future post -- still compiling.) Adam [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 11:09 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You cant spend your time reading the alert log. you should poll it and get an email when something pops up. Same with chained rows, tablespace sizes, etc... Write scripts for this and send your self emails. Have statspack snapshots run daily. From: [EMAIL PROTECTED] Date: 2003/12/05 Fri PM 01:49:30 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database management techniques and frameworks Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where there are many instances, multiple databases, different platforms/versions, etc., what are some of the strategies for management in place? What daily tasks do you perform, and how do you organize them? How do you manage user requests (individually or as part of a larger environment)? How do you handle jobs? Organization techniques? Naming standards? User/application deployment framework, etc., etc.? (Obviously we could write a book about this -- there's an idea! -- but summaries and pointers would be interesting. Perhaps we can come up with a best practices document and associated framework for Oracle database management.) Thanks, Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the
How to Find Client OS type from Oracle 8174......
Dear List, We have TXN processing system with as many as 900 users log in at any point of time. We have the necessity to find what OS type the client is using (Windows 95, NT 2000 etc). I tried thru V$SESSION, V$SESSION_CONNECT_INFO and V$PROCESS, but couldn't find any useful info to get the client OS type. I also looked at the NET8 documentation to see if I can get any such info. I am not successful in getting such information from any source. I tried setting LOG_DIRECTORY_CLIENT and LOG_FILE_CLIENT in SQLNET.ORA, but it is not generating any logfiles. Could some one help me how I should get such info. Appreciate a reply. -- Janardhana
RE: tis a puzzlement...
When exporting, use native (8.1) Export utility. When importing into 9.2 native Import utility (9.2) will perfectly well read 8.1 export files. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Thater, William Sent: Friday, December 05, 2003 1:34 PM To: Multiple recipients of list ORACLE-L Jared Still scribbled on the wall in glitter crayon: Bill, why are you trying to export an 8i database with 9i exp? because i thought i read somewhere that it would work. maybe i'm confusing it with imp? will 9i imp read an 81 exp file? it's either that, or i've experienced an ORA 99 - brain burnt out.;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Great spirits have always found violent opposition from mediocrities. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dba studio in oracle9.2
Hi... I have Oracle 9.2 DBA Studio comes embedded with the Management Console. Just conect to your Management Console and that's all. Regards. HTH JL --- Prem Khanna J [EMAIL PROTECTED] wrote: Bahar , i think it's only OEM with 9iR2. ... and perhaps u have everything there . Regards, Jp. -Original Message- On Behalf Of [EMAIL PROTECTED] Hi all, I have installed oracle 9.2 server and managemenst server on windows. I have perform full installation. But there is no DBA Studio in oracle tools. Any comment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database management techniques and frameworks
When I had only one instance to baby sit doing the script thing was OK, but it also missed things like the listener not being up and lost of other problems. Besides it was a pain to add it to each new server as they came along. Therefore I re-wrote those scripts into one C language program with integrated SMTP capabilities, a couple of extprocedures as well as a built in that understands when a DB is suppose to be down for backup or in hot backup mode. I then added common fix it stuff that I've always had to do manually hung it off the side on an NT server we had. It's been here for the past 10 years and even understands Oracle 9i. Sends a message to the pager/cell phone when needed otherwise just sends the old e-mail. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, December 05, 2003 1:50 PM To: Multiple recipients of list ORACLE-L Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where there are many instances, multiple databases, different platforms/versions, etc., what are some of the strategies for management in place? What daily tasks do you perform, and how do you organize them? How do you manage user requests (individually or as part of a larger environment)? How do you handle jobs? Organization techniques? Naming standards? User/application deployment framework, etc., etc.? (Obviously we could write a book about this -- there's an idea! -- but summaries and pointers would be interesting. Perhaps we can come up with a best practices document and associated framework for Oracle database management.) Thanks, Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Plan stability
At 01:14 PM 12/4/2003, you wrote: Hi Justin Didn't know you were on the list I'm usually about a week behind, so I don't get to participate very often... A properly formed hint will cause the CBO to consider the hinted path to be less costly than it would otherwise consider it, but hints do not force a query to use that particular plan. If you want to force Oracle to use a particular plan, plan stability is orders of magnitude easier! Umm, but if you look at plan stability you will see that it is implemented as hints (and query rewrite) - typically loads of them. A hint *does* force you to do what it says, if it is being 'ignored' then likely you haven't excluded alternative access paths. Of course for any sufficiently complex query (in my case that means 3 or more joins) then manually specifying an access path with hints becomes a too difficult problem. I've never looked under the covers on plan stability, so now I'm get confused. My understanding was that plan stability forced a query to follow a particular execution plan. My understanding of hints, however, was that they were only suggestions that the CBO could ignore. Tom Kyte writes (second or third response down): http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:1951680913800 1) yes -- IF it accepts the hint, hints are just that -- hints. They are NOT directives, they are suggestions. It took the suggestion in this case. If plan stability is just Oracle applying a bunch of hints, and hints are only suggestions, does that imply that the CBO can ignore plan stability? Justin Cave
Re: rebuilding indexes - sure to cause a ruckus
Tanel, I think you're saying a query almost always runs faster right after the index rebuild and there's no point in finding the criterion whether to rebuild an index. (What is 42?) Some time ago I posted a message somewhere else showing a case where rebuilding or coalescing an index may be benefitial. A data warehouse is found to have some data errors. Deletes and updates are done. Then the database goes to mostly read-only again, and will last for a month or quarter. Then shrinking frequently used B*Tree indexes is a good idea. Now I'd like to add one more criterion as a result of reading Jonathan Lewis' dbazine article and email with him (errors are mine): the index is full scanned, or if range scanned or unique scanned, the index selectivity has to be fairly low (but not too low for the index to be ignored by CBO). In a typical working environment, a data warehouse does have plenty of relatively quiet period. I worked on a monthly data load project at an insurance company. I remember we rebuilt a partitioned IOT (one partition at a time) and fast full index scan (certain partitions) did run faster. There're some errors in Don Burleson's dbazine article (e.g. pct_used in dba_indexes) and Mike Hordila's Oramag article (structurally unbalanced index). But one thing alluded to in there is important: study Oracle performance problems as scientific research. You said setting _wait_for_sync to false improves performance. That's a fact. We can only explain and analyze it but not deny it. Similarly, when Mike says queries run 10 to 50% faster after index rebuild, we can't deny unless we find his measurement is wrong. Wouldn't it be nice if Oracle researchers write articles with sections like Abstract - Experimental - Results - Discussion in that order? Yong Huang Tanel Poder wrote: There's no point of arguing about whether a query ran faster right after you rebuilt your index. Nor there is no point in finding some ultimate algorithm for finding the point of index rebuilding, we all know the answer - it's 42. Instead, a long stress test has to be done, e.g. running 10 millions of continous transactions and queries (simulating real life). Do one 10M without rebuilding indexes in the meantime, measure total execution time, IO amount, CPU usage, segment sizes etc. Then restore your database back to starting point and do the same test again with regular index rebuilds during the operations (online or taking users offline, depending on environment type). And then measure the same statistics, especially total execution time. Note, that statistics and time also for rebuilding indexes should be accounted in totals, because in real life they don't just disappear somewhere as in some simple-minded tests. Tanel. __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to Find Client OS type from Oracle 8174......
Man... it's just a bit difficult to find that you want only in Oracle... but can try this: 1.- There is an utility on Windows 2000 Resource Kit called: gettype.exe, it can help you to determine your OS Type (it works with the errorlevel), you need to be logged in your domain to make this works, else, it gets errors. 2.- You can combine with an sqlplus script to get your desired results. 3.- There you go: gettype \\machine_name -- get it from v$session. errorlevel means: Returns 1 for Windows NT Workstation. Returns 2 for Windows 2000 Professional installation. Returns 3 for Windows NT Server Non-Domain Controller. Returns 4 for Windows 2000 Server Non-Domain Controller. Returns 5 for Windows NT Server Domain Controller. Returns 6 for Windows 2000 Server Domain Controller. Returns 7 for Windows NT [Enterprise/Terminal] Server Domain Controller Returns 8 for Windows NT [Enterprise/Terminal] Server Non-Domain Controller --ELSE-- Windows 95 or 98. Testing should be done. Is this enough? If not... I have the utiilty and can email to you off-list... then if you need a bit of help for making your script, I can try to help you too. Best regards! HTH JL --- Janardhana Babu Donga [EMAIL PROTECTED] wrote: Dear List, We have TXN processing system with as many as 900 users log in at any point of time. We have the necessity to find what OS type the client is using (Windows 95, NT 2000 etc). I tried thru V$SESSION, V$SESSION_CONNECT_INFO and V$PROCESS, but couldn't find any useful info to get the client OS type. I also looked at the NET8 documentation to see if I can get any such info. I am not successful in getting such information from any source. I tried setting LOG_DIRECTORY_CLIENT and LOG_FILE_CLIENT in SQLNET.ORA, but it is not generating any logfiles. Could some one help me how I should get such info. Appreciate a reply. -- Janardhana __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database management techniques and frameworks
Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's some examples: 1) Monitoring script pages DBA group if X happens, Unix group if Y happens, Network group if Z happens. Simultaneously, XTerm windows are popped up in both Operations and HelpDesk with the name and pager number of the person paged (via uucp) 2) Monitoring script sends messages to centralized Error Management System. Error Management System handles it 3) Monitoring script finds problem and corrects problem. If problem continues, email is generated 4) Error Management System has external handles (not APIs) which can be used to call Monitoring Scripts, which need to be modified to ustilize System's internal structures (sometimes written in French -- *that* was fun!) 5) Monitoring script simply sends emails 6) Monitoring script keeps track of the errors in log files which are compared to log files from X time ago and only the differences are reported 7) Monitoring script has redundancy built in such that the first X times a particular problem is encountered, the Monitoring System ignores it, then generates a page 8) Monitoring script has redundnacy built in such that after the first time the problem is encountered, a page is sent, and if there is still a problem 15 minutes later, someone else is paged and so on up the company ladder It goes on and on. This is largely what I've been doing for the past 8 years. Note that the words Monitoring script as used above is generally an inherently complicated conglomeration of several different scripts, generally with a governor and/or one or more driver(s), infrequently on different operating systems, sometimes in multiple languages and/or utilizing, or integrating with, or extending the capabilities of, one or more COTS products, which use different mechanisms to trigger and synchronize them. Generally, there is some kind of IGNORE functionality which allows for specified downtime for maintenance, or ALTERNATE functionality for unusual yet definable situations, and hierarchy of tests (if the database is down, that implies that a subsequent error that a user cannot connect to it has already been dealt with) and, occasionally has sniffers on other boxes to determine whether remote scripts need to be run either dependent upon remote conditions or independent of them. Sometimes, there is a process which kicks off other jobs and manages the security. I particularly enjoy those where there is fault tolerance built in such that if Monitoring script X on Machine Y craps out, Machine Z takes over and runs the scripts until Y is back, then copies the logs back, kicks off Y, make sure it runs ok, then shuts itself down. (note to the Oracle-L historians who might be curious, this change in my utilization is largely why my posts from 10 years ago were a lot more DBMS/internals heavy and my posts nowadays are more OS/script heavy.) Regardless, I hope this answers your question and shows some of the complexity of what you're asking for... Bambi. -Original Message- Sent: Friday, December 05, 2003 1:44 PM To: Multiple recipients of list ORACLE-L So your approach is to write a series of custom scripts, add them to (I assume) oracle's crontab for periodic execution. Do you have one single machine (or pair of machines) that monitor remote databases? Or do you install these scripts on each database server? Do you leverage dbms_jobs? And relying on email seems kind of iffy -- what happens if you're not around to check your email? Page system? Escalation matrix in place? Not trying to ruffle any feathers here, and certainly, I appreciate the time requirements in fully answering a question as broad as the one I submitted, but I would like to probe further into various strategies. The whole run scripts to check, install statspack, etc. approach seems both highly unscalable and leaves much to the whim of the individual DBA. So what, you've installed statspack? Do you use it regularly? Is this a manual review, or is some system in place to monitor changes? How easy is it to deploy this framework? (Does anyone here use Oracle's SNMP agents for monitoring? I've leveraged these -- along with a home-grown SNMP NMS (in Perl) -- to some degree at a multiple database site to good effect.) Are there any 'design patterns for databases' around? Should we come up with some? (I'll post my own notes on the topic of management in a future post -- still compiling.) Adam [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 11:09 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have
Re: Database management techniques and frameworks
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:44 PM So your approach is to write a series of custom scripts, add them to (I assume) oracle's crontab for periodic execution. Do you have one single machine (or pair of machines) that monitor remote databases? Or do you install these scripts on each database server? Do you leverage dbms_jobs? And relying on email seems kind of iffy -- what happens if you're not around to check your email? Page system? Escalation matrix in place? 7-8 servers and growing. we use data files that the scripts read. We use an NAS, so we share common directories across servers making it easier to manage. so each server will be server_name.host each instance instance.target We use scripts to access these data files so we can change them. For example, I have one script that tests all alert logs. It does ps -ef| grep pmon. Then logs in to each instance and gets all the alert log paths and polls them for new ORA messages. I have another one to test whether the instances are up. This one takes the host variable and hits the appropriate *.host file. This file will have a list of all instances on that server. Then tries to log into each server. We dont have adequate code for checking the listener? Any suggestions. Easier to do with CRON on a platform like this than DBMS_JOB, plus I dont have to worry about the quotes. Our threat matrix is Success, failure, warning. People carry beepers that have emails and if a failure flag comes up, they get beeped. We use warnings for this such as ORA messages in alert log, Increase in size of data file, things that arent 100% the way we want on ETL loads, etc... Not trying to ruffle any feathers here, and certainly, I appreciate the time requirements in fully answering a question as broad as the one I submitted, but I would like to probe further into various strategies. The whole run scripts to check, install statspack, etc. approach seems both highly unscalable and leaves much to the whim of the individual DBA. So what, you've installed statspack? Do you use it regularly? Is this a manual review, or is some system in place to monitor changes? How easy is it to deploy this framework? Scripts are very scalable. You just dont go nailing the v$views 1000 times. We do our polling stuff every 5 minutes. You cant monitor statspack all the time. We monitor it when we have a problem. That is what design is for. As I said, I also write code every day. (Does anyone here use Oracle's SNMP agents for monitoring? I've leveraged these -- along with a home-grown SNMP NMS (in Perl) -- to some degree at a multiple database site to good effect.) not in the budget. Are there any 'design patterns for databases' around? Should we come up with some? David Wendelken from casetech has some articles on his company's website. More lower level patterns. Such as different types of relations. He basically takes relational theory and makes it readable. They are quite good. Overall all high level pattersn for one size fits all doesnt work. But lower level 'relational' patterns for specific tables is a viable strategy. Perl and C might be good. Dont know perl and Im weak in C. (I'll post my own notes on the topic of management in a future post -- still compiling.) Adam [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 11:09 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject Re: Database management techniques and frameworks We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You cant spend your time reading the alert log. you should poll it and get an email when something pops up. Same with chained rows, tablespace sizes, etc... Write scripts for this and send your self emails. Have statspack snapshots run daily. From: [EMAIL PROTECTED] Date: 2003/12/05 Fri PM 01:49:30 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database management techniques and frameworks Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where there are many instances, multiple databases, different platforms/versions, etc., what are some of the strategies for management in place? What daily tasks do you perform, and how do you organize them? How do you manage user requests (individually or as part of a larger environment)? How do you handle jobs? Organization techniques? Naming standards? User/application deployment framework, etc., etc.? (Obviously we could write a book about
Re: Database management techniques and frameworks
one more point. Sorry for all the emails. I found that when writing scripts for monitoring you really should follow an abstraction philosohpy similiar to what you see in Object Oriented programming. Write utility scripts, use data files, then have utility scripts that 'echo' out data from them like a function. maintenance is much easier. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 1:49 PM Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where there are many instances, multiple databases, different platforms/versions, etc., what are some of the strategies for management in place? What daily tasks do you perform, and how do you organize them? How do you manage user requests (individually or as part of a larger environment)? How do you handle jobs? Organization techniques? Naming standards? User/application deployment framework, etc., etc.? (Obviously we could write a book about this -- there's an idea! -- but summaries and pointers would be interesting. Perhaps we can come up with a best practices document and associated framework for Oracle database management.) Thanks, Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database management techniques and frameworks
i think instead of doing lists myself, I say Can I teach this guy how to do it and is he willing to learn. If he is willing to learn its great, if not, its a pain. Learning DBA skills is very advantage to any developers career, so if their smart they will want to learn. The key is to not give them the deer in the head lights look. Little bit at a time. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 2:39 PM Well said, Ryan! I have about the same number of instances, all on Sun. Development responsibilities also. One DBA. Time off is difficult. Excellent advice on emailing results. I have found the tools cause you about as much maintenance as they might save, so I favor simple scripts with emailed results. If you have time to visit each instance each day, you have way too much time on your hands. But I can recall those days when I only had 2 instances too. Fondly recall. For user/developer requests, the magic phrase I've found is can I do that for you tomorrow morning? Before leaving for the day I prepare a list of tasks for the next morning, and when I arrive I defer anything that I can to concentrate on my list and ticking off tasks on that list. Try to get meetings moved to the afternoon. Just basic time management, and everyone is different. For mature applications, I've found autoextend on datafiles to be a big time-saver. I've used that for many years now and only been bitten by that a couple of times. Much simpler to watch one number (available disk space) than dozens of numbers. For deployment, we are working toward ITIL procedures. We have test, staging, production instances for most databases, so I and developers can deploy against a staging instance before inflicting a deployment on production. Staging is a fresh clone of production. Naming standards are good, but I have found that some sites get so wrapped up in them that they cause more work than they prevent. Often packaged applications are mainly tested against their default configuration so if you insist on changing everything to meet your standards, you end up finding bugs nobody else found. One technique I have had good results with is to prepare an audit sheet and when time is available, pick an instance and audit it for security, performance, recoverability, etc. During the audit, make up a list of tasks to perform on that instance, and as time permits, execute those tasks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 1:09 PM To: Multiple recipients of list ORACLE-L We have about 20-25 instances here. Nearly all on SUN. I dont touch the ones on windows. I also have development responsibilities, so I dont have time for a checklist. you need to automate tasks. You cant spend your time reading the alert log. you should poll it and get an email when something pops up. Same with chained rows, tablespace sizes, etc... Write scripts for this and send your self emails. Have statspack snapshots run daily. From: [EMAIL PROTECTED] Date: 2003/12/05 Fri PM 01:49:30 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Database management techniques and frameworks Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where there are many instances, multiple databases, different platforms/versions, etc., what are some of the strategies for management in place? What daily tasks do you perform, and how do you organize them? How do you manage user requests (individually or as part of a larger environment)? How do you handle jobs? Organization techniques? Naming standards? User/application deployment framework, etc., etc.? (Obviously we could write a book about this -- there's an idea! -- but summaries and pointers would be interesting. Perhaps we can come up with a best practices document and associated framework for Oracle database management.) Thanks, Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
Cursor problem
Dear All My application uses connection pooling. I do not want to end a connection con.close() because this will end the connection from db but just want to release the connection. In my app , i specify releaseconnection . But how come all the cursor still open when i query this : select user_name, status, osuser, machine, a.sql_text from v$session b, v$open_cursor a where a.sid = b.sid Thank in advanced regards jacinta __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kean Jacinta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database management techniques and frameworks
Ryan, have you tried PDBA toolkit? The address is: http://www.oreilly.com/catalog/oracleperl/pdbatoolkit/ This toolkit has a plethora of very useful scripts. I seem to recollect an ugly looking O'Reilly book with moth on an orange overtone cover, which does a very good job on documenting it. The book is called Perl for Oracle DBA. The PDBA toolkit is slightly out of date but still very useful, but the book is invaluable because it documents a whole lot of other tools like Oracle::OCI (a perversion) Apache::OWA, Apache::DBI and Mason, which are hard to come by and even harder to find examples that make sense. The author is Mr. Jared Still, otherwise known as the owner of this list. Please let me know if you purchase the book, because I'll have to charge Jared for commission. On 12/05/2003 03:44:32 PM, Ryan wrote: one more point. Sorry for all the emails. I found that when writing scripts for monitoring you really should follow an abstraction philosohpy similiar to what you see in Object Oriented programming. Write utility scripts, use data files, then have utility scripts that 'echo' out data from them like a function. maintenance is much easier. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 05, 2003 1:49 PM Folks, I thought it'd be interesting to take a survey on what techniques and frameworks DBA's on this list use to manage their Oracle databases. I imagine that some of us manage only a single database and instance, but in those configurations where there are many instances, multiple databases, different platforms/versions, etc., what are some of the strategies for management in place? What daily tasks do you perform, and how do you organize them? How do you manage user requests (individually or as part of a larger environment)? How do you handle jobs? Organization techniques? Naming standards? User/application deployment framework, etc., etc.? (Obviously we could write a book about this -- there's an idea! -- but summaries and pointers would be interesting. Perhaps we can come up with a best practices document and associated framework for Oracle database management.) Thanks, Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing
anyone seen this? (possible controlfile corruption)
Hi. tar already opened - awaiting feedback. W2K Adv Svr Sp4 Oracle 9i R2 Std Ed 9.2.0.4 NTFS 5.0 filesystem Dell 2650, PERC3/Di controller, writeback caching enabled qa database, not a huge deal at the moment. I have a backup controlfile, but would rather not open resetlogs, as there is a remote standby database for this - but then again, that gets refreshed over the weekend anyways. I only found one similar posting on the Oracle Metalink Forums, so this seems to be uncommon. just wondering if anyone has experienced this. glad that I haven't seen it yet in production. so it seems that the battery in the PERC just decided to charge itself in an unscheduled fashion. I'd recommend that if you have any Dell Servers that you periodically re-charge the battery explicitly, rather than wait for it to do it itself, at some inopportune time. Paul * ATTENTION: The controlfile header block returned by the OShas a sequence number that is too old. The controlfile might be corrupted.PLEASE DO NOT ATTEMPT TO START UP THE INSTANCE without following the steps below.RE-STARTING THE INSTANCE CAN CAUSE SERIOUS DAMAGE TO THE DATABASE, if the controlfile is truly corrupted.In order to re-start the instance safely, please do the following:(1) Save all copies of the controlfile for later analysis and contact your OS vendor and Oracle support.(2) Mount the instance and issue: ALTER DATABASE BACKUP CONTROLFILE TO TRACE;(3) Unmount the instance. (4) Use the script in the trace file to RE-CREATE THE CONTROLFILE and open the database. *kccchb_6: Controlfile sequence number mismatch ! SGA Seq: 198992 lseqno: 198991 lfileno: 0 hseqno: 198991 hfileno : 0 Event Type:ErrorEvent Source:afamgtEvent Category:NoneEvent ID:1Date:12/4/2003Time:6:37:14 PMUser:N/AComputer:NY-ORCL-001Description:\Device\AFA0 : Battery is Charging Data:: 00 00 00 00 02 00 4e 00 ..N.0008: 00 00 00 00 01 00 07 e0 ...à0010: 00 00 00 00 00 00 00 00 0018: 00 00 00 00 00 00 00 00 0020: 00 00 00 00 00 00 00 00 Do you Yahoo!? Free Pop-Up Blocker - Get it now
Re: tis a puzzlement...
Bill, There are several bugs out there in exp.exe land. my current favorite is the ORA-00907 that shows up when importing (8.1.7.4 - just hit this one again last night). my second favorite is the ORA-00942 that appears when exporting (9.2.0.3 - fixed in 9.2.0.4). neither of these seem to be what this problem is, though. As others have said, export with the same version as the database, import with the target database's binaries. Paul "Thater, William" [EMAIL PROTECTED] wrote: database 8.1.7.2 Solaris 64 bitexp 9.2.0.1/8.1.7same user, same database, schema export, same command line optionsexp user/[EMAIL PROTECTED] compress=n rows=y file=export.dmp log=log.txt8.1.7 exports fine. 9.2.0.1 gives an ORA 942.OK so what am i missing here? which FM do i RT? i thought the 9 wouldexport an 8.1.7 database or am i misunderstanding what i've read?--Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song[EMAIL PROTECTED]1916 General theory of relativity. Gravity is a warping of space-time. -Albert Einstein-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Thater, WilliamINET: [EMAIL PROTECTED]Fat City Net! work Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Do you Yahoo!? Free Pop-Up Blocker - Get it now
RE: dbua ORA-12545
Actually TWO_TASK is not set - I signed in as oracle user and echoed it. Sooo I think my hope that finally after the many versions I have migrated - Oracle's assistant is finally ready to rock - is not correct. Mainly, do not get complete information running the migration that way. I find that really annoying - esp. as I have been spending a good deal of time lately in SQL Server land. It is so much easier to work with as a DBA - the toolsets are so much more reliable and integrated. Sorry boys - I have turned yet - Oracle is still my first love - and to tell you the truth - having cut my teeth as a DBA on Oracle gives me an advantage for sure. -Original Message- Sent: Friday, December 05, 2003 11:11 AM To: [EMAIL PROTECTED] Cc: Stankus, Paula G Paule, you have TWO_TASK environment variable set and dbua is trying to connect to host it cannot find. Unset TWO_TASK and everything will be OK. On 12/05/2003 10:54:25 AM, [EMAIL PROTECTED] wrote: Running dbua to upgrade 8.1.7 to 9.2.0 database produces: ORA-12545: Connect failed because target host or object does not exist. Very annoying because looking at logs under .../assistants subdirectories and ../admin/upgrade/logs or the alert log - directories doesn't show what the missing target or object is. Then dbua just hangs and I have to rollback. Grrr!!! I am seriously considering using the manual migration (not dbua or export/import) but running mig manually so I can see exactly what is happening. Anyone have any information on this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Plan stability
Title: Message
I could notget Outlook to prefix your message properly -
grrr. Comments are at the top which may make reading them hard.I have
tried to setup a simple demo that hints are not 'suggestions' sorry if this
becomes long - this is all 9.2 but should apply to 8i and later versions as
well. The sql I issue comes firstSQL create user niall identified by
niall;User created.SQL alter user niall default tablespace
users 2 temporary tablespace temp 3 quota
unlimited on users;User altered.SQL grant create
session, 2 alter session, 3 create
table, 4 select_catalog_role to niall;Grant
succeeded. create an unimaginatively named
userSQL conn niall/niallConnected.SQL
create table t1 as select * from dba_segments;Table
created.SQL create table t2 as select * from
dba_tablespaces;Table created.SQL create index i1 on
t1(tablespace_name);Index created.SQL create index i2 on
t2(tablespace_name);Index created.SQL conn
systemConnected.SQL exec
dbms_stats.gather_schema_stats('NIALL');PL/SQL procedure successfully
completed. create some tables and gather some
statsSQL alter session set events '10053 trace name
context forever, level 1';
Session altered.
SQL select /*+ index(t1 i1) */
t1.segment_name,t2.tablespace_name,t2.contents 2 from
t1,t2 3 where t1.tablespace_name=t2.tablespace_name
4 and t2.tablespace_name='USERS';
* Issue my query and tell Oracle to use index i1 for
table t1
SEGMENT_NAME
TABLESPACE_NAME
CONTENTS
--
-
snip boring results
20 rows selected.
SQL alter session set events '10053 trace name context
off';
Session altered.
This generates a trace file with the following info in it.
interesting bits bold and red
*** 2003-12-05 21:02:09.000*** SESSION ID:(9.15) 2003-12-05
21:02:09.000QUERYselect /*+ index(t1 i1) */
t1.segment_name,t2.tablespace_name,t2.contentsfrom t1,t2where
t1.tablespace_name=t2.tablespace_nameand
t2.tablespace_name='USERS'***PARAMETERS
USED BY THE
OPTIMIZEROPTIMIZER_FEATURES_ENABLE =
9.2.0OPTIMIZER_MODE/GOAL = Choose_OPTIMIZER_PERCENT_PARALLEL =
101snip parameter list
***BASE STATISTICAL
INFORMATION***Table stats Table:
T2 Alias: T2 TOTAL :: CDN: 15 NBLKS:
1 AVG_ROW_LEN: 88-- Index stats INDEX NAME: I2
COL#: 1 TOTAL :: LVLS: 1 #LB: 25
#DK: 100 LB/K: 1 DB/K: 1 CLUF:
800***Table stats Table:
T1 Alias: T1 TOTAL :: CDN: 1789 NBLKS:
25 AVG_ROW_LEN: 95-- Index stats INDEX NAME: I1
COL#: 5 TOTAL :: LVLS: 1 #LB: 25
#DK: 100 LB/K: 1 DB/K: 1 CLUF:
800_OPTIMIZER_PERCENT_PARALLEL =
0***SINGLE TABLE ACCESS
PATHColumn: TABLESPACE Col#: 5 Table:
T1 Alias: T1 NDV:
9 NULLS:
0 DENS:
1.e-001 NO HISTOGRAM: #BKT: 1 #VAL: 2 TABLE: T1 ORIG CDN:
1789 ROUNDED CDN: 199 CMPTD CDN: 199 Access path: index
(equal) Index:
I1 TABLE: T1
RSC_CPU: 0 RSC_IO: 92 IX_SEL: 0.e+000
TB_SEL: 1.e-001 BEST_CST: 92.00 PATH: 4
Degree: 1***SINGLE TABLE
ACCESS PATHColumn: TABLESPACE Col#: 1
Table: T2 Alias: T2 NDV:
15 NULLS:
0 DENS:
6.6667e-002 NO HISTOGRAM: #BKT: 1 #VAL: 2 TABLE:
T2 ORIG CDN: 15 ROUNDED CDN: 1 CMPTD CDN:
1 Access path: tsc Resc: 2 Resp: 2
Access path: index (equal) Index:
I2 TABLE: T2
RSC_CPU: 0 RSC_IO: 56 IX_SEL: 0.e+000
TB_SEL: 6.6667e-002 BEST_CST: 2.00 PATH: 2
Degree: 1***OPTIMIZER
STATISTICS AND
COMPUTATIONS***GENERAL
PLANS***Join order[1]: T2 [T2] T1 [T1] Now
joining: T1 [T1] ***NL Join
Outer table: cost: 2 cdn: 1 rcz: 17 resp: 2
Access path: index (join stp) Index:
I1 TABLE: T1
RSC_CPU: 0 RSC_IO: 92 IX_SEL: 0.e+000
TB_SEL: 1.e-001 Join: resc: 94 resp:
94Join cardinality: 199 = outer (1) * inner (199) * sel
(1.e+000) [flag=0] Best NL cost: 94 resp: 94Join
result: cost: 94 cdn: 199 rcz: 42Best so far: TABLE#: 0
CST: 2
CDN: 1
BYTES: 17Best so far:
TABLE#: 1 CST: 94
CDN: 199
BYTES:
8358***Join order[2]: T1 [T1] T2 [T2] Now
joining: T2 [T2] ***NL Join Outer table: cost: 92 cdn:
199 rcz: 25 resp: 92 Inner table: T2 Access path:
tsc Resc: 2 Join: Resc: 490
Resp: 490 Access path: index (join
stp) Index: I2
TABLE: T2 RSC_CPU: 0 RSC_IO:
56 IX_SEL: 0.e+000 TB_SEL:
6.6667e-002 Join: resc: 11236 resp:
11236Join cardinality: 199 = outer (199) * inner (1) * sel
(1.e+000) [flag=0] Best NL cost: 490 resp:
490Final: CST: 94 CDN: 199 RSC: 94 RSP: 94
BYTES: 8358 IO-RSC: 94 IO-RSP: 94 CPU-RSC: 0
CPU-RSP: 0*** 2003-12-05 21:02:30.000QUERYalter session set events
'10053 trace name context off'
You will see that for table t1
Oracle only ever considers an index access path using index i1. This is what we
told it to. By
RE: Database management techniques and frameworks
I guess the impetus here is my Occamian approach to technology problems. I abstract to the point of maximum flexibility with minimal complexity, which often also requires maximum time and effort. Reality of course dictates that a solution that ends up in common ground. So it's not that I'm asking for 'answers' so much as I'm attempting to identify patterns that have worked. From your post, it's clear your method isn't X -- it's X, Y, or Z depending on the situation. Perhaps we can extrapolate from these variables a more generic way ... a common thread throughout, that is understandable, deterministic, and implementable. It's Friday, ignore my ramblings. Adam Bellow, Bambi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 12:34 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Database management techniques and frameworks Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's some examples: 1) Monitoring script pages DBA group if X happens, Unix group if Y happens, Network group if Z happens. Simultaneously, XTerm windows are popped up in both Operations and HelpDesk with the name and pager number of the person paged (via uucp) 2) Monitoring script sends messages to centralized Error Management System. Error Management System handles it 3) Monitoring script finds problem and corrects problem. If problem continues, email is generated 4) Error Management System has external handles (not APIs) which can be used to call Monitoring Scripts, which need to be modified to ustilize System's internal structures (sometimes written in French -- *that* was fun!) 5) Monitoring script simply sends emails 6) Monitoring script keeps track of the errors in log files which are compared to log files from X time ago and only the differences are reported 7) Monitoring script has redundancy built in such that the first X times a particular problem is encountered, the Monitoring System ignores it, then generates a page 8) Monitoring script has redundnacy built in such that after the first time the problem is encountered, a page is sent, and if there is still a problem 15 minutes later, someone else is paged and so on up the company ladder It goes on and on. This is largely what I've been doing for the past 8 years. Note that the words Monitoring script as used above is generally an inherently complicated conglomeration of several different scripts, generally with a governor and/or one or more driver(s), infrequently on different operating systems, sometimes in multiple languages and/or utilizing, or integrating with, or extending the capabilities of, one or more COTS products, which use different mechanisms to trigger and synchronize them. Generally, there is some kind of IGNORE functionality which allows for specified downtime for maintenance, or ALTERNATE functionality for unusual yet definable situations, and hierarchy of tests (if the database is down, that implies that a subsequent error that a user cannot connect to it has already been dealt with) and, occasionally has sniffers on other boxes to determine whether remote scripts need to be run either dependent upon remote conditions or independent of them. Sometimes, there is a process which kicks off other jobs and manages the security. I particularly enjoy those where there is fault tolerance built in such that if Monitoring script X on Machine Y craps out, Machine Z takes over and runs the scripts until Y is back, then copies the logs back, kicks off Y, make sure it runs ok, then shuts itself down. (note to the Oracle-L historians who might be curious, this change in my utilization is largely why my posts from 10 years ago were a lot more DBMS/internals heavy and my posts nowadays are more OS/script heavy.) Regardless, I hope this answers your question and shows some of the complexity of what you're asking for... Bambi. -Original Message- Sent: Friday, December 05, 2003 1:44 PM To: Multiple recipients of list ORACLE-L So your approach is to write a series of custom scripts, add them to (I assume) oracle's crontab for periodic execution. Do you have one single machine (or pair of machines) that monitor remote databases? Or do you install these scripts on each database server? Do you leverage dbms_jobs? And relying on email seems kind of iffy -- what happens if you're not around to check your email? Page system? Escalation matrix in place? Not trying to ruffle any feathers here, and certainly, I appreciate the time requirements in fully answering a question as broad as the one I submitted, but I would like to probe further into various strategies. The whole run scripts to check, install statspack, etc. approach seems both highly unscalable and leaves much to the whim of the individual DBA.
RE: Database management techniques and frameworks
Adam -- Generally, my approach is X *and* Y *and* Z, and I have found that maximum flexibility with a decent level of functionality will be of at least moderate complexity. And I have never seen Occam's name turned into an adjective like that. Is that standard? Bambi. -Original Message- Sent: Friday, December 05, 2003 3:44 PM To: Multiple recipients of list ORACLE-L I guess the impetus here is my Occamian approach to technology problems. I abstract to the point of maximum flexibility with minimal complexity, which often also requires maximum time and effort. Reality of course dictates that a solution that ends up in common ground. So it's not that I'm asking for 'answers' so much as I'm attempting to identify patterns that have worked. From your post, it's clear your method isn't X -- it's X, Y, or Z depending on the situation. Perhaps we can extrapolate from these variables a more generic way ... a common thread throughout, that is understandable, deterministic, and implementable. It's Friday, ignore my ramblings. Adam Bellow, Bambi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 12:34 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Database management techniques and frameworks Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's some examples: 1) Monitoring script pages DBA group if X happens, Unix group if Y happens, Network group if Z happens. Simultaneously, XTerm windows are popped up in both Operations and HelpDesk with the name and pager number of the person paged (via uucp) 2) Monitoring script sends messages to centralized Error Management System. Error Management System handles it 3) Monitoring script finds problem and corrects problem. If problem continues, email is generated 4) Error Management System has external handles (not APIs) which can be used to call Monitoring Scripts, which need to be modified to ustilize System's internal structures (sometimes written in French -- *that* was fun!) 5) Monitoring script simply sends emails 6) Monitoring script keeps track of the errors in log files which are compared to log files from X time ago and only the differences are reported 7) Monitoring script has redundancy built in such that the first X times a particular problem is encountered, the Monitoring System ignores it, then generates a page 8) Monitoring script has redundnacy built in such that after the first time the problem is encountered, a page is sent, and if there is still a problem 15 minutes later, someone else is paged and so on up the company ladder It goes on and on. This is largely what I've been doing for the past 8 years. Note that the words Monitoring script as used above is generally an inherently complicated conglomeration of several different scripts, generally with a governor and/or one or more driver(s), infrequently on different operating systems, sometimes in multiple languages and/or utilizing, or integrating with, or extending the capabilities of, one or more COTS products, which use different mechanisms to trigger and synchronize them. Generally, there is some kind of IGNORE functionality which allows for specified downtime for maintenance, or ALTERNATE functionality for unusual yet definable situations, and hierarchy of tests (if the database is down, that implies that a subsequent error that a user cannot connect to it has already been dealt with) and, occasionally has sniffers on other boxes to determine whether remote scripts need to be run either dependent upon remote conditions or independent of them. Sometimes, there is a process which kicks off other jobs and manages the security. I particularly enjoy those where there is fault tolerance built in such that if Monitoring script X on Machine Y craps out, Machine Z takes over and runs the scripts until Y is back, then copies the logs back, kicks off Y, make sure it runs ok, then shuts itself down. (note to the Oracle-L historians who might be curious, this change in my utilization is largely why my posts from 10 years ago were a lot more DBMS/internals heavy and my posts nowadays are more OS/script heavy.) Regardless, I hope this answers your question and shows some of the complexity of what you're asking for... Bambi. -Original Message- Sent: Friday, December 05, 2003 1:44 PM To: Multiple recipients of list ORACLE-L So your approach is to write a series of custom scripts, add them to (I assume) oracle's crontab for periodic execution. Do you have one single machine (or pair of machines) that monitor remote databases? Or do you install these scripts on each database server? Do you leverage dbms_jobs? And relying on email seems kind of iffy -- what happens if you're not around to check your email? Page system?
RMAN restore on another server
Title: Message
Goal: To restore the database
from RMAN backup on a different server by means of moving the backup pieces and
logs over to the new machine and use Rman to unpack the database
files.
Strategy: To restore the
database from the RMAN backup pieces into a new directory locations on the
machine and extract the control file and startup the
database.
Some
of the steps to setup the new machine.
1)
Install oracle 8i2) install the patch 4.03) copy .profile
over
4)
duplicated the Admin directories for the database to be
restored
5)
created a big mount /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6)
Created a backup mount point to store the RMAN backup pieces and
archivelogs
7)
moved the backup pieces and archivelogs to the new machine
8)
Setup and confirm connectivity to Rman catalog
9) No
mount the database to be on the new machine
10)
Launch the Rman command
rman
cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it
gets to processing the command andgets to the"RMAN-03022:
compiling command: set " and just hangs...adding another line every 1/2
hour or so...
Anybody seen this or have ideas? I talked to one guy
who did have this but couldn't remember the solution. This is the first time
doing this so I might be missing something simple..
Here is the command in operation
== rman
cmdfile=restore_dbsid.rman
trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 -
Production
RMAN RMAN connect catalog
rman81740/[EMAIL PROTECTED]2
3 connect target /4 5 6 7 run8
9 {10 11 allocate channel disk_channel1 type disk
;12 13 sql 'alter session set NLS_DATE_FORMAT="-MM-DD
HH24:MI:SS"';14 set until time = '2003-12-02 05:50:00';15
16 set newname for datafile 1 to17
'/u02/vssppln/system01.dbf';18 19 set newname for datafile
2 to20 '/u02/vssppln/rbs01.dbf';21 22 set newname
for datafile 3 to23 '/u02/vssppln/rbs02.dbf';24 25
set newname for datafile 4 to26 '/u02/vssppln/AIMFACT01.dbf';27
28 set newname for datafile 5 to29
'/u02/vssppln/AIMFACT_INDEX01.dbf';30 31 set newname for
datafile 6 to32 '/u02/vssppln/AIMFACT101.dbf';33
34 set newname for datafile 7 to35
'/u02/vssppln/AIMFACT102.dbf';36 37 set newname for
datafile 8 to38 '/u02/vssppln/aimfact1_index01.dbf';39
40 set newname for datafile 9 to41
'/u02/vssppln/aimfact1_index02.dbf';42 43 set newname for
datafile 10 to44 '/u02/vssppln/aimfact1_index03.dbf';45
46 set newname for datafile 11 to47
'/u02/vssppln/aimfact1_index04.dbf';48 49 set newname for
datafile 12 to50 '/u02/vssppln/aimfact201.dbf';51
52 set newname for datafile 13 to53
'/u02/vssppln/aimfact202.dbf';54 55 set newname for
datafile 14 to56 '/u02/vssppln/aimfact2_index01.dbf';57
58 set newname for datafile 15 to59
'/u02/vssppln/aimfact2_index02.dbf';60 61 set newname for
datafile 16 to62 '/u02/vssppln/aimfact2_index03.dbf';63
64 set newname for datafile 17 to65
'/u02/vssppln/aimfact2_index04.dbf';66 67 set newname for
datafile 18 to68 '/u02/vssppln/aimstruct01.dbf';69
70 set newname for datafile 19 to71
'/u02/vssppln/aimstruct_index01.dbf';72 73 set newname for
datafile 20 to74 '/u02/vssppln/aimstruct101.dbf';75
76 set newname for datafile 21 to77
'/u02/vssppln/aimstruct1_index01.dbf';78 79 set newname
for datafile 22 to80 '/u02/vssppln/aimwork01.dbf';81
82 set newname for datafile 23 to83
'/u02/vssppln/mipsdata01.dbf';84 85 set newname for
datafile 24 to86 '/u02/vssppln/mipsindex01.dbf';87
88 set newname for datafile 25 to89
'/u02/vssppln/mipsdata101.dbf';90 91 set newname for
datafile 26 to92 '/u02/vssppln/mipsdata1_index01.dbf';93
94 set newname for datafile 27 to95
'/u02/vssppln/mipsdata201.dbf';96 97 set newname for
datafile 28 to98 '/u02/vssppln/nipsdata2_index01.dbf';99
100 set newname for datafile 29 to101
'/u02/vssppln/tools01.dbf';102 103 set newname for
datafile 30 to104 '/u02/vssppln/users01.dbf';105
106 set newname for datafile 31 to107
'/u02/vssppln/AIMINDEX01.dbf';108 109 set newname for
datafile 32 to110 '/u02/vssppln/aimfact1_index05.dbf';111
112 set newname for datafile 33 to113
'/u02/vssppln/aimfact2_index05.dbf';114 115 116 restore
database;117 118 restore controlfile to
'/u02/vssppln/restored_cf.ctl';119 120 mount
database;121 122 switch datafile all;123 124
release channel disk_channel1;125 }126 127
RMAN-06008: connected to recovery catalog database
RMAN-06006: connected to target
database: vssppln (not mounted)
RMAN-03022: compiling command:
allocateRMAN-03023: executing command: allocateRMAN-08030: allocated
channel: disk_channel1RMAN-08500: channel disk_channel1: sid=10
devtype=DISK
RMAN-03022: compiling command:
sqlRMAN-06162: sql statement: alter session set NLS_DATE_FORMAT="-MM-DD
HH24:MI:SS"RMAN-03023: executing command: sql
RMAN-03022: compiling command:
set
RMAN-03022: compiling command:
set
RMAN-03022: compiling command:
set
RMAN-03022: compiling command:
set
RE: Cursor problem
Jacinta - What language is the app written in? Java? How are you doing connection pooling? With Oracle? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 05, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Dear All My application uses connection pooling. I do not want to end a connection con.close() because this will end the connection from db but just want to release the connection. In my app , i specify releaseconnection . But how come all the cursor still open when i query this : select user_name, status, osuser, machine, a.sql_text from v$session b, v$open_cursor a where a.sid = b.sid Thank in advanced regards jacinta __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kean Jacinta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN restore on another server
Brian - First, congratulations on performing what seems pretty close to a
disaster recovery test. I don't know the specific answer to your problem, so
I'll ask a couple of questions related to hard points I encountered, and
maybe that will strike a cord.
1. You say you connected to your existing RMAN catalog? How does the
catalog know to recover this new database and not the one it backed up?
Maybe it is confused. I found it much simpler to recover from the
controlfile even if I used the catalog to perform the backup. Also in a true
disaster, you may not have your RMAN catalog unless you have another tape.
If you can recover from the single tape with the RMAN backup, then your
offsite tape could get you up and running.
2. Are the backup pieces in the same path as you backed them up? I don't
think that is your problem because that usually gives a clear error.
3. Are you using NFS? I encountered a problem with NFS very similar to
your symptoms. My sys admin assumed there would be only a connection or two
over NFS, so left some stuff default. Come to find out RMAN opens a bunch of
connections.
Sorry, but that is all my brain can think up on Friday.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 05, 2003 4:14 PM
To: Multiple recipients of list ORACLE-L
Goal: To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the RMAN-03022: compiling command: set and just
hangs...adding another line every 1/2 hour or so...
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
Here is the command in operation
== rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN
RMAN connect catalog rman81740/[EMAIL PROTECTED]
mailto:rman81740/[EMAIL PROTECTED]
2
3 connect target /
4
5
6
7 run
8
9 {
10
11 allocate channel disk_channel1 type disk ;
12
13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS';
14 set until time = '2003-12-02 05:50:00';
15
16 set newname for datafile 1 to
17 '/u02/vssppln/system01.dbf';
18
19 set newname for datafile 2 to
20 '/u02/vssppln/rbs01.dbf';
21
22 set newname for datafile 3 to
23 '/u02/vssppln/rbs02.dbf';
24
25 set newname for datafile 4 to
26 '/u02/vssppln/AIMFACT01.dbf';
27
28 set newname for datafile 5 to
29 '/u02/vssppln/AIMFACT_INDEX01.dbf';
30
31 set newname for datafile 6 to
32 '/u02/vssppln/AIMFACT101.dbf';
33
34 set newname for datafile 7 to
35 '/u02/vssppln/AIMFACT102.dbf';
36
37 set newname for datafile 8 to
38 '/u02/vssppln/aimfact1_index01.dbf';
39
40 set newname for datafile 9 to
41 '/u02/vssppln/aimfact1_index02.dbf';
42
43 set newname for datafile 10 to
44 '/u02/vssppln/aimfact1_index03.dbf';
45
46 set newname for datafile 11 to
47 '/u02/vssppln/aimfact1_index04.dbf';
48
49 set newname for datafile 12 to
50 '/u02/vssppln/aimfact201.dbf';
51
52 set newname for datafile 13 to
53 '/u02/vssppln/aimfact202.dbf';
54
55 set newname for datafile 14 to
56 '/u02/vssppln/aimfact2_index01.dbf';
57
58 set newname for datafile 15 to
59 '/u02/vssppln/aimfact2_index02.dbf';
60
61 set newname for datafile 16 to
62 '/u02/vssppln/aimfact2_index03.dbf';
63
64 set newname for datafile 17 to
65 '/u02/vssppln/aimfact2_index04.dbf';
66
67 set newname for datafile 18 to
68 '/u02/vssppln/aimstruct01.dbf';
69
70 set newname for datafile 19 to
71 '/u02/vssppln/aimstruct_index01.dbf';
72
73 set newname for datafile 20 to
74 '/u02/vssppln/aimstruct101.dbf';
75
76 set newname for datafile 21 to
77 '/u02/vssppln/aimstruct1_index01.dbf';
78
79 set newname for datafile 22 to
80 '/u02/vssppln/aimwork01.dbf';
81
82 set newname for datafile 23 to
83 '/u02/vssppln/mipsdata01.dbf';
84
85 set newname for datafile 24 to
86 '/u02/vssppln/mipsindex01.dbf';
87
88 set newname for datafile 25 to
89
Perpetually Spinning Job
We just had a major issue with a materialized view (aka snapshot) job running for over two months without end. This actually caused a loss of revenue for our company, as this job generated data which reported customer service usage. I can remember an old 8.1.5 but where an network outage would cause these jobs to hang, but this was supposedly fixed. The only solution I can see is to generate a script which validates that a job in dba_jobs_running is not there over a certain Period of time. The issue with this is that that period of time may be ill-defined. The refresh interval stored in dba_mviews is a relative date/time calculation, and does not lend it self to comparative testing. I can provide more detail on this dilemma if anyone needs them. Any ideas? Michael Fontana Sr. DBA NTT/Verio image001.gifThe previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. image002.gif
RE: Database management techniques and frameworks
Perhaps it should have said Occam's razorian ;) Bellow, Bambi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 01:59 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Database management techniques and frameworks Adam -- Generally, my approach is X *and* Y *and* Z, and I have found that maximum flexibility with a decent level of functionality will be of at least moderate complexity. And I have never seen Occam's name turned into an adjective like that. Is that standard? Bambi. -Original Message- Sent: Friday, December 05, 2003 3:44 PM To: Multiple recipients of list ORACLE-L I guess the impetus here is my Occamian approach to technology problems. I abstract to the point of maximum flexibility with minimal complexity, which often also requires maximum time and effort. Reality of course dictates that a solution that ends up in common ground. So it's not that I'm asking for 'answers' so much as I'm attempting to identify patterns that have worked. From your post, it's clear your method isn't X -- it's X, Y, or Z depending on the situation. Perhaps we can extrapolate from these variables a more generic way ... a common thread throughout, that is understandable, deterministic, and implementable. It's Friday, ignore my ramblings. Adam Bellow, Bambi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/05/2003 12:34 PM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Database management techniques and frameworks Adam -- I've done this more times than I can count. The answer is it depends on your environment, your desired results, and, more often than not, your corporate structure. Here's some examples: 1) Monitoring script pages DBA group if X happens, Unix group if Y happens, Network group if Z happens. Simultaneously, XTerm windows are popped up in both Operations and HelpDesk with the name and pager number of the person paged (via uucp) 2) Monitoring script sends messages to centralized Error Management System. Error Management System handles it 3) Monitoring script finds problem and corrects problem. If problem continues, email is generated 4) Error Management System has external handles (not APIs) which can be used to call Monitoring Scripts, which need to be modified to ustilize System's internal structures (sometimes written in French -- *that* was fun!) 5) Monitoring script simply sends emails 6) Monitoring script keeps track of the errors in log files which are compared to log files from X time ago and only the differences are reported 7) Monitoring script has redundancy built in such that the first X times a particular problem is encountered, the Monitoring System ignores it, then generates a page 8) Monitoring script has redundnacy built in such that after the first time the problem is encountered, a page is sent, and if there is still a problem 15 minutes later, someone else is paged and so on up the company ladder It goes on and on. This is largely what I've been doing for the past 8 years. Note that the words Monitoring script as used above is generally an inherently complicated conglomeration of several different scripts, generally with a governor and/or one or more driver(s), infrequently on different operating systems, sometimes in multiple languages and/or utilizing, or integrating with, or extending the capabilities of, one or more COTS products, which use different mechanisms to trigger and synchronize them. Generally, there is some kind of IGNORE functionality which allows for specified downtime for maintenance, or ALTERNATE functionality for unusual yet definable situations, and hierarchy of tests (if the database is down, that implies that a subsequent error that a user cannot connect to it has already been dealt with) and, occasionally has sniffers on other boxes to determine whether remote scripts need to be run either dependent upon remote conditions or independent of them. Sometimes, there is a process which kicks off other jobs and manages the security. I particularly enjoy those where there is fault tolerance built in such that if Monitoring script X on Machine Y craps out, Machine Z takes over and runs the scripts until Y is back, then copies the logs back, kicks off Y, make sure it runs ok, then shuts itself down. (note to the Oracle-L historians who might be curious, this change in my utilization is largely why my posts from 10 years ago were a lot more DBMS/internals heavy and my posts nowadays are more OS/script heavy.) Regardless, I hope this answers your question and shows some of the complexity of what you're asking for... Bambi. -Original Message- Sent: Friday, December 05, 2003 1:44 PM To: Multiple recipients of list ORACLE-L So your approach is to write a series of custom scripts, add them to (I assume) oracle's crontab for periodic execution.
Re: RMAN restore on another server
How did you expect the restore to work w/o first restoring the
controlfile? or am i missing something here?
joe
Spears, Brian wrote:
*Goal:* To restore the database from RMAN backup on a different
server by means of moving the backup pieces and logs over to the new
machine and use Rman to unpack the database files.
*Strategy:* To restore the database from the RMAN backup pieces into
a new directory locations on the machine and extract the control file
and startup the database.
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it gets to
processing the command and gets to the RMAN-03022: compiling
command: set and just hangs...adding another line every 1/2 hour or
so...
Anybody seen this or have ideas? I talked to one guy who did have this
but couldn't remember the solution. This is the first time doing this
so I might be missing something simple..
*Here is the command in operation*
== rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN
RMAN connect catalog rman81740/[EMAIL PROTECTED]
mailto:rman81740/[EMAIL PROTECTED]
2
3 connect target /
4
5
6
7 run
8
9 {
10
11 allocate channel disk_channel1 type disk ;
12
13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS';
14 set until time = '2003-12-02 05:50:00';
15
16 set newname for datafile 1 to
17 '/u02/vssppln/system01.dbf';
18
19 set newname for datafile 2 to
20 '/u02/vssppln/rbs01.dbf';
21
22 set newname for datafile 3 to
23 '/u02/vssppln/rbs02.dbf';
24
25 set newname for datafile 4 to
26 '/u02/vssppln/AIMFACT01.dbf';
27
28 set newname for datafile 5 to
29 '/u02/vssppln/AIMFACT_INDEX01.dbf';
30
31 set newname for datafile 6 to
32 '/u02/vssppln/AIMFACT101.dbf';
33
34 set newname for datafile 7 to
35 '/u02/vssppln/AIMFACT102.dbf';
36
37 set newname for datafile 8 to
38 '/u02/vssppln/aimfact1_index01.dbf';
39
40 set newname for datafile 9 to
41 '/u02/vssppln/aimfact1_index02.dbf';
42
43 set newname for datafile 10 to
44 '/u02/vssppln/aimfact1_index03.dbf';
45
46 set newname for datafile 11 to
47 '/u02/vssppln/aimfact1_index04.dbf';
48
49 set newname for datafile 12 to
50 '/u02/vssppln/aimfact201.dbf';
51
52 set newname for datafile 13 to
53 '/u02/vssppln/aimfact202.dbf';
54
55 set newname for datafile 14 to
56 '/u02/vssppln/aimfact2_index01.dbf';
57
58 set newname for datafile 15 to
59 '/u02/vssppln/aimfact2_index02.dbf';
60
61 set newname for datafile 16 to
62 '/u02/vssppln/aimfact2_index03.dbf';
63
64 set newname for datafile 17 to
65 '/u02/vssppln/aimfact2_index04.dbf';
66
67 set newname for datafile 18 to
68 '/u02/vssppln/aimstruct01.dbf';
69
70 set newname for datafile 19 to
71 '/u02/vssppln/aimstruct_index01.dbf';
72
73 set newname for datafile 20 to
74 '/u02/vssppln/aimstruct101.dbf';
75
76 set newname for datafile 21 to
77 '/u02/vssppln/aimstruct1_index01.dbf';
78
79 set newname for datafile 22 to
80 '/u02/vssppln/aimwork01.dbf';
81
82 set newname for datafile 23 to
83 '/u02/vssppln/mipsdata01.dbf';
84
85 set newname for datafile 24 to
86 '/u02/vssppln/mipsindex01.dbf';
87
88 set newname for datafile 25 to
89 '/u02/vssppln/mipsdata101.dbf';
90
91 set newname for datafile 26 to
92 '/u02/vssppln/mipsdata1_index01.dbf';
93
94 set newname for datafile 27 to
95 '/u02/vssppln/mipsdata201.dbf';
96
97 set newname for datafile 28 to
98 '/u02/vssppln/nipsdata2_index01.dbf';
99
100 set newname for datafile 29 to
101 '/u02/vssppln/tools01.dbf';
102
103 set newname for datafile 30 to
104 '/u02/vssppln/users01.dbf';
105
106 set newname for datafile 31 to
107 '/u02/vssppln/AIMINDEX01.dbf';
108
109 set newname for datafile 32 to
110 '/u02/vssppln/aimfact1_index05.dbf';
111
112 set newname for datafile 33 to
113 '/u02/vssppln/aimfact2_index05.dbf';
114
115
116 restore database;
117
118 restore controlfile to '/u02/vssppln/restored_cf.ctl';
119
120 mount database;
121
122 switch datafile all;
123
124 release channel disk_channel1;
125 }
126
127
RMAN-06008: connected to recovery catalog database
RMAN-06006: connected to target database: vssppln (not mounted)
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: disk_channel1
RMAN-08500: channel disk_channel1: sid=10 devtype=DISK
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter session set
RE: RMAN restore on another server
Title: Message
By default RMAN restores the backup to the
machine from where it is backedup. If you need to restore the backup on to
alternate client, your netbackup admin has to setup the access. You have not mentioned
whether you are using Netbackup or legato or something else. Once the access is
set up, you can test it by connecting to rman target / catalog rman/[EMAIL PROTECTED] on
the new machine ,and issuing the command list backup at RMAN prompt on the new
machine. If you see the backups, you can restore the backup. If you are using
NETBACKUP, use the var NB_ORA_CLIENT, If not substitute with the corresponding
variable.
Startup nomount;
Run {
Allocate channel t1 type 'sbt_tape'
parms="ENV=(NB_ORA_CLIENT=backedupclient; export NB_ORA_CLIENT);
Restore controlfile;
Alter database mount;
Restore database;
Alter database open;
}
-- Janardhana
-Original Message-
From: Spears, Brian
[mailto:[EMAIL PROTECTED]
Sent: Friday,
December 05, 2003 2:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: RMAN restore on another
server
Goal: To restore the database from RMAN backup on a different
server by means of moving the backup pieces and logs over to the new machine
and use Rman to unpack the database files.
Strategy: To restore the database from the RMAN backup pieces into a
new directory locations on the machine and extract the control file and startup
the database.
Some of the steps to
setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin
directories for the database to be restored
5) created a big
mount /u02/vssppln/ point for all the datafiles and controlfiles and so
on
6) Created a backup mount
point to store the RMAN backup pieces and archivelogs
7) moved the backup
pieces and archivelogs to the new machine
8) Setup and confirm
connectivity to Rman catalog
9) No mount the database
to be on the new machine
10) Launch the Rman
command
rman
cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this
restore from Rman backup...but it gets to processing the command andgets
to theRMAN-03022: compiling command: set and
just hangs...adding another line every 1/2 hour or so...
Anybody seen this or have
ideas? I talked to one guy who did have this but couldn't remember the
solution. This is the first time doing this so I might be missing something
simple..
Here is
the command in operation
== rman
cmdfile=restore_dbsid.rman
trace=restore_dbsid.nohup_log
Recovery Manager: Release
8.1.7.4.0 - Production
RMAN
RMAN connect catalog rman81740/[EMAIL PROTECTED]
2
3 connect target /
4
5
6
7 run
8
9 {
10
11 allocate channel disk_channel1 type disk ;
12
13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD
HH24:MI:SS';
14 set until time = '2003-12-02 05:50:00';
15
16 set newname for datafile 1 to
17 '/u02/vssppln/system01.dbf';
18
19 set newname for datafile 2 to
20 '/u02/vssppln/rbs01.dbf';
21
22 set newname for datafile 3 to
23 '/u02/vssppln/rbs02.dbf';
24
25 set newname for datafile 4 to
26 '/u02/vssppln/AIMFACT01.dbf';
27
28 set newname for datafile 5 to
29 '/u02/vssppln/AIMFACT_INDEX01.dbf';
30
31 set newname for datafile 6 to
32 '/u02/vssppln/AIMFACT101.dbf';
33
34 set newname for datafile 7 to
35 '/u02/vssppln/AIMFACT102.dbf';
36
37 set newname for datafile 8 to
38 '/u02/vssppln/aimfact1_index01.dbf';
39
40 set newname for datafile 9 to
41 '/u02/vssppln/aimfact1_index02.dbf';
42
43 set newname for datafile 10 to
44 '/u02/vssppln/aimfact1_index03.dbf';
45
46 set newname for datafile 11 to
47 '/u02/vssppln/aimfact1_index04.dbf';
48
49 set newname for datafile 12 to
50 '/u02/vssppln/aimfact201.dbf';
51
52 set newname for datafile 13 to
53 '/u02/vssppln/aimfact202.dbf';
54
55 set newname for datafile 14 to
56 '/u02/vssppln/aimfact2_index01.dbf';
57
58 set newname for datafile 15 to
59 '/u02/vssppln/aimfact2_index02.dbf';
60
61 set newname for datafile 16 to
62 '/u02/vssppln/aimfact2_index03.dbf';
63
64 set newname for datafile 17 to
65 '/u02/vssppln/aimfact2_index04.dbf';
66
67 set newname for datafile 18 to
68 '/u02/vssppln/aimstruct01.dbf';
69
70 set newname for datafile 19 to
71 '/u02/vssppln/aimstruct_index01.dbf';
72
73 set newname for datafile 20 to
74 '/u02/vssppln/aimstruct101.dbf';
75
76 set newname for datafile 21 to
77 '/u02/vssppln/aimstruct1_index01.dbf';
78
79 set newname for datafile 22 to
80 '/u02/vssppln/aimwork01.dbf';
81
82 set newname for datafile 23 to
83 '/u02/vssppln/mipsdata01.dbf';
84
85 set newname for datafile 24 to
86 '/u02/vssppln/mipsindex01.dbf';
87
88 set newname for datafile 25 to
89 '/u02/vssppln/mipsdata101.dbf';
90
91 set newname for datafile 26 to
92 '/u02/vssppln/mipsdata1_index01.dbf';
93
94 set newname for datafile 27 to
95 '/u02/vssppln/mipsdata201.dbf';
96
97 set newname for
RE: RMAN restore on another server
Title: Message
I am sorry, I thought you are restoring
from Tape. In either case, you connect to target and catalog database on the
new server and see if you can access the backups that were backed up on the
original server.
-- Janardhana
-Original Message-
From: Spears, Brian
[mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003
2:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: RMAN restore on another
server
Goal: To restore the database from RMAN backup on a different
server by means of moving the backup pieces and logs over to the new machine
and use Rman to unpack the database files.
Strategy: To restore the database from the RMAN backup pieces into a
new directory locations on the machine and extract the control file and startup
the database.
Some of the steps to
setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin
directories for the database to be restored
5) created a big
mount /u02/vssppln/ point for all the datafiles and controlfiles and so
on
6) Created a backup mount
point to store the RMAN backup pieces and archivelogs
7) moved the backup
pieces and archivelogs to the new machine
8) Setup and confirm
connectivity to Rman catalog
9) No mount the database
to be on the new machine
10) Launch the Rman
command
rman
cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this
restore from Rman backup...but it gets to processing the command andgets
to theRMAN-03022: compiling command: set and
just hangs...adding another line every 1/2 hour or so...
Anybody seen this or have
ideas? I talked to one guy who did have this but couldn't remember the
solution. This is the first time doing this so I might be missing something
simple..
Here is
the command in operation
== rman
cmdfile=restore_dbsid.rman
trace=restore_dbsid.nohup_log
Recovery Manager: Release
8.1.7.4.0 - Production
RMAN
RMAN connect catalog rman81740/[EMAIL PROTECTED]
2
3 connect target /
4
5
6
7 run
8
9 {
10
11 allocate channel disk_channel1 type disk ;
12
13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD
HH24:MI:SS';
14 set until time = '2003-12-02 05:50:00';
15
16 set newname for datafile 1 to
17 '/u02/vssppln/system01.dbf';
18
19 set newname for datafile 2 to
20 '/u02/vssppln/rbs01.dbf';
21
22 set newname for datafile 3 to
23 '/u02/vssppln/rbs02.dbf';
24
25 set newname for datafile 4 to
26 '/u02/vssppln/AIMFACT01.dbf';
27
28 set newname for datafile 5 to
29 '/u02/vssppln/AIMFACT_INDEX01.dbf';
30
31 set newname for datafile 6 to
32 '/u02/vssppln/AIMFACT101.dbf';
33
34 set newname for datafile 7 to
35 '/u02/vssppln/AIMFACT102.dbf';
36
37 set newname for datafile 8 to
38 '/u02/vssppln/aimfact1_index01.dbf';
39
40 set newname for datafile 9 to
41 '/u02/vssppln/aimfact1_index02.dbf';
42
43 set newname for datafile 10 to
44 '/u02/vssppln/aimfact1_index03.dbf';
45
46 set newname for datafile 11 to
47 '/u02/vssppln/aimfact1_index04.dbf';
48
49 set newname for datafile 12 to
50 '/u02/vssppln/aimfact201.dbf';
51
52 set newname for datafile 13 to
53 '/u02/vssppln/aimfact202.dbf';
54
55 set newname for datafile 14 to
56 '/u02/vssppln/aimfact2_index01.dbf';
57
58 set newname for datafile 15 to
59 '/u02/vssppln/aimfact2_index02.dbf';
60
61 set newname for datafile 16 to
62 '/u02/vssppln/aimfact2_index03.dbf';
63
64 set newname for datafile 17 to
65 '/u02/vssppln/aimfact2_index04.dbf';
66
67 set newname for datafile 18 to
68 '/u02/vssppln/aimstruct01.dbf';
69
70 set newname for datafile 19 to
71 '/u02/vssppln/aimstruct_index01.dbf';
72
73 set newname for datafile 20 to
74 '/u02/vssppln/aimstruct101.dbf';
75
76 set newname for datafile 21 to
77 '/u02/vssppln/aimstruct1_index01.dbf';
78
79 set newname for datafile 22 to
80 '/u02/vssppln/aimwork01.dbf';
81
82 set newname for datafile 23 to
83 '/u02/vssppln/mipsdata01.dbf';
84
85 set newname for datafile 24 to
86 '/u02/vssppln/mipsindex01.dbf';
87
88 set newname for datafile 25 to
89 '/u02/vssppln/mipsdata101.dbf';
90
91 set newname for datafile 26 to
92 '/u02/vssppln/mipsdata1_index01.dbf';
93
94 set newname for datafile 27 to
95 '/u02/vssppln/mipsdata201.dbf';
96
97 set newname for datafile 28 to
98 '/u02/vssppln/nipsdata2_index01.dbf';
99
100 set newname for datafile 29 to
101 '/u02/vssppln/tools01.dbf';
102
103 set newname for datafile 30 to
104 '/u02/vssppln/users01.dbf';
105
106 set newname for datafile 31 to
107 '/u02/vssppln/AIMINDEX01.dbf';
108
109 set newname for datafile 32 to
110 '/u02/vssppln/aimfact1_index05.dbf';
111
112 set newname for datafile 33 to
113 '/u02/vssppln/aimfact2_index05.dbf';
114
115
116 restore database;
117
118 restore controlfile to '/u02/vssppln/restored_cf.ctl';
119
120 mount database;
121
122 switch datafile all;
123
124 release channel disk_channel1;
125 }
RE: RMAN restore on another server
Title: Message
May be you try the following:
If you get errors restoring controlfile, You
may ftp the controlfiles manually to the new server and startup mount the
database first. Then, Try your restore database.
-- Janardhana
-Original Message-
From: Spears, Brian
[mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003
2:14 PM
To: Multiple recipients of list
ORACLE-L
Subject: RMAN restore on another
server
Goal: To restore the database from RMAN backup on a different
server by means of moving the backup pieces and logs over to the new machine
and use Rman to unpack the database files.
Strategy: To restore the database from the RMAN backup pieces into a
new directory locations on the machine and extract the control file and startup
the database.
Some of the steps to
setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin
directories for the database to be restored
5) created a big
mount /u02/vssppln/ point for all the datafiles and controlfiles and so
on
6) Created a backup mount
point to store the RMAN backup pieces and archivelogs
7) moved the backup
pieces and archivelogs to the new machine
8) Setup and confirm
connectivity to Rman catalog
9) No mount the database
to be on the new machine
10) Launch the Rman
command
rman
cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this
restore from Rman backup...but it gets to processing the command andgets
to theRMAN-03022: compiling command: set and
just hangs...adding another line every 1/2 hour or so...
Anybody seen this or have
ideas? I talked to one guy who did have this but couldn't remember the
solution. This is the first time doing this so I might be missing something
simple..
Here is
the command in operation
== rman
cmdfile=restore_dbsid.rman
trace=restore_dbsid.nohup_log
Recovery Manager: Release
8.1.7.4.0 - Production
RMAN
RMAN connect catalog rman81740/[EMAIL PROTECTED]
2
3 connect target /
4
5
6
7 run
8
9 {
10
11 allocate channel disk_channel1 type disk ;
12
13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD
HH24:MI:SS';
14 set until time = '2003-12-02 05:50:00';
15
16 set newname for datafile 1 to
17 '/u02/vssppln/system01.dbf';
18
19 set newname for datafile 2 to
20 '/u02/vssppln/rbs01.dbf';
21
22 set newname for datafile 3 to
23 '/u02/vssppln/rbs02.dbf';
24
25 set newname for datafile 4 to
26 '/u02/vssppln/AIMFACT01.dbf';
27
28 set newname for datafile 5 to
29 '/u02/vssppln/AIMFACT_INDEX01.dbf';
30
31 set newname for datafile 6 to
32 '/u02/vssppln/AIMFACT101.dbf';
33
34 set newname for datafile 7 to
35 '/u02/vssppln/AIMFACT102.dbf';
36
37 set newname for datafile 8 to
38 '/u02/vssppln/aimfact1_index01.dbf';
39
40 set newname for datafile 9 to
41 '/u02/vssppln/aimfact1_index02.dbf';
42
43 set newname for datafile 10 to
44 '/u02/vssppln/aimfact1_index03.dbf';
45
46 set newname for datafile 11 to
47 '/u02/vssppln/aimfact1_index04.dbf';
48
49 set newname for datafile 12 to
50 '/u02/vssppln/aimfact201.dbf';
51
52 set newname for datafile 13 to
53 '/u02/vssppln/aimfact202.dbf';
54
55 set newname for datafile 14 to
56 '/u02/vssppln/aimfact2_index01.dbf';
57
58 set newname for datafile 15 to
59 '/u02/vssppln/aimfact2_index02.dbf';
60
61 set newname for datafile 16 to
62 '/u02/vssppln/aimfact2_index03.dbf';
63
64 set newname for datafile 17 to
65 '/u02/vssppln/aimfact2_index04.dbf';
66
67 set newname for datafile 18 to
68 '/u02/vssppln/aimstruct01.dbf';
69
70 set newname for datafile 19 to
71 '/u02/vssppln/aimstruct_index01.dbf';
72
73 set newname for datafile 20 to
74 '/u02/vssppln/aimstruct101.dbf';
75
76 set newname for datafile 21 to
77 '/u02/vssppln/aimstruct1_index01.dbf';
78
79 set newname for datafile 22 to
80 '/u02/vssppln/aimwork01.dbf';
81
82 set newname for datafile 23 to
83 '/u02/vssppln/mipsdata01.dbf';
84
85 set newname for datafile 24 to
86 '/u02/vssppln/mipsindex01.dbf';
87
88 set newname for datafile 25 to
89 '/u02/vssppln/mipsdata101.dbf';
90
91 set newname for datafile 26 to
92 '/u02/vssppln/mipsdata1_index01.dbf';
93
94 set newname for datafile 27 to
95 '/u02/vssppln/mipsdata201.dbf';
96
97 set newname for datafile 28 to
98 '/u02/vssppln/nipsdata2_index01.dbf';
99
100 set newname for datafile 29 to
101 '/u02/vssppln/tools01.dbf';
102
103 set newname for datafile 30 to
104 '/u02/vssppln/users01.dbf';
105
106 set newname for datafile 31 to
107 '/u02/vssppln/AIMINDEX01.dbf';
108
109 set newname for datafile 32 to
110 '/u02/vssppln/aimfact1_index05.dbf';
111
112 set newname for datafile 33 to
113 '/u02/vssppln/aimfact2_index05.dbf';
114
115
116 restore database;
117
118 restore controlfile to '/u02/vssppln/restored_cf.ctl';
119
120 mount database;
121
122 switch datafile all;
123
124 release channel disk_channel1;
125 }
126
127
RE: RMAN restore on another server
Janardhana - That's a good point.
Brian - were you expecting RMAN to extract your controlfile from the RMAN
backup pieces? You are on Oracle8i, and RMAN isn't so good at doing that in
8i. I couldn't get that to work myself.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, December 05, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L
May be you try the following:
If you get errors restoring controlfile, You may ftp the controlfiles
manually to the new server and startup mount the database first. Then, Try
your restore database.
-- Janardhana
-Original Message-
Sent: Friday, December 05, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L
Goal: To restore the database from RMAN backup on a different server by
means of moving the backup pieces and logs over to the new machine and use
Rman to unpack the database files.
Strategy: To restore the database from the RMAN backup pieces into a new
directory locations on the machine and extract the control file and startup
the database.
Some of the steps to setup the new machine.
1) Install oracle 8i
2) install the patch 4.0
3) copy .profile over
4) duplicated the Admin directories for the database to be restored
5) created a big mount /u02/vssppln/ point for all the datafiles and
controlfiles and so on
6) Created a backup mount point to store the RMAN backup pieces and
archivelogs
7) moved the backup pieces and archivelogs to the new machine
8) Setup and confirm connectivity to Rman catalog
9) No mount the database to be on the new machine
10) Launch the Rman command
rman cmdfile=restore_dbsid.rman trace=restore_dbsid.log
Problem... I run this restore from Rman backup...but it gets to processing
the command and gets to the RMAN-03022: compiling command: set and just
hangs...adding another line every 1/2 hour or so...
Anybody seen this or have ideas? I talked to one guy who did have this but
couldn't remember the solution. This is the first time doing this so I might
be missing something simple..
Here is the command in operation
== rman cmdfile=restore_dbsid.rman trace=restore_dbsid.nohup_log
Recovery Manager: Release 8.1.7.4.0 - Production
RMAN
RMAN connect catalog rman81740/[EMAIL PROTECTED]
mailto:rman81740/[EMAIL PROTECTED]
2
3 connect target /
4
5
6
7 run
8
9 {
10
11 allocate channel disk_channel1 type disk ;
12
13 sql 'alter session set NLS_DATE_FORMAT=-MM-DD HH24:MI:SS';
14 set until time = '2003-12-02 05:50:00';
15
16 set newname for datafile 1 to
17 '/u02/vssppln/system01.dbf';
18
19 set newname for datafile 2 to
20 '/u02/vssppln/rbs01.dbf';
21
22 set newname for datafile 3 to
23 '/u02/vssppln/rbs02.dbf';
24
25 set newname for datafile 4 to
26 '/u02/vssppln/AIMFACT01.dbf';
27
28 set newname for datafile 5 to
29 '/u02/vssppln/AIMFACT_INDEX01.dbf';
30
31 set newname for datafile 6 to
32 '/u02/vssppln/AIMFACT101.dbf';
33
34 set newname for datafile 7 to
35 '/u02/vssppln/AIMFACT102.dbf';
36
37 set newname for datafile 8 to
38 '/u02/vssppln/aimfact1_index01.dbf';
39
40 set newname for datafile 9 to
41 '/u02/vssppln/aimfact1_index02.dbf';
42
43 set newname for datafile 10 to
44 '/u02/vssppln/aimfact1_index03.dbf';
45
46 set newname for datafile 11 to
47 '/u02/vssppln/aimfact1_index04.dbf';
48
49 set newname for datafile 12 to
50 '/u02/vssppln/aimfact201.dbf';
51
52 set newname for datafile 13 to
53 '/u02/vssppln/aimfact202.dbf';
54
55 set newname for datafile 14 to
56 '/u02/vssppln/aimfact2_index01.dbf';
57
58 set newname for datafile 15 to
59 '/u02/vssppln/aimfact2_index02.dbf';
60
61 set newname for datafile 16 to
62 '/u02/vssppln/aimfact2_index03.dbf';
63
64 set newname for datafile 17 to
65 '/u02/vssppln/aimfact2_index04.dbf';
66
67 set newname for datafile 18 to
68 '/u02/vssppln/aimstruct01.dbf';
69
70 set newname for datafile 19 to
71 '/u02/vssppln/aimstruct_index01.dbf';
72
73 set newname for datafile 20 to
74 '/u02/vssppln/aimstruct101.dbf';
75
76 set newname for datafile 21 to
77 '/u02/vssppln/aimstruct1_index01.dbf';
78
79 set newname for datafile 22 to
80 '/u02/vssppln/aimwork01.dbf';
81
82 set newname for datafile 23 to
83 '/u02/vssppln/mipsdata01.dbf';
84
85 set newname for datafile 24 to
86 '/u02/vssppln/mipsindex01.dbf';
87
88 set newname for datafile 25 to
89 '/u02/vssppln/mipsdata101.dbf';
90
91 set newname for datafile 26 to
92 '/u02/vssppln/mipsdata1_index01.dbf';
93
94 set newname for datafile 27 to
95 '/u02/vssppln/mipsdata201.dbf';
96
97 set newname for datafile 28 to
98 '/u02/vssppln/nipsdata2_index01.dbf';
99
100 set newname for datafile 29 to
101 '/u02/vssppln/tools01.dbf';
102
103 set newname for datafile 30 to
104 '/u02/vssppln/users01.dbf';
105
106 set newname for datafile 31 to
107 '/u02/vssppln/AIMINDEX01.dbf';
108
109 set newname for datafile 32 to
110 '/u02/vssppln/aimfact1_index05.dbf';
111
112 set newname
Re: what happened to baarf.net?
It's on www.baarf.com and there are some pretty good articles there. Best regards, Mogens [EMAIL PROTECTED] wrote: anyone got the articles about why raid 5 is bad for databases? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ETAGON...
Good stuff. Thanks. So what you're saying below is this: Before: 2 16-cpu Sun's: $600K for HW and OS plus 32 x $40K for Oracle, ie a total of $1.680K? Is that correct? After: 5 4-cpu Intel boxes: $100K for HW and OS plus 20 x $60K for Oracle, ie a total of 1.300K? What confuses me, I think, is the difference in number of CPU's mentioned when only the additonal RAC price tag of $20K was mentioned. Is it possible to move from 32 Sparc CPU's to 20 Intel CPU's? Mogens Yechiel Adar wrote: I concur about the software prices on big machines. We work with IBM mainframes and the last upgrade cost us a lot in SOFTWARE licenses, since we moved into a higher performance group. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 7:49 PM Well, I'm going to get involved here saying upfront that my company is a competitor of Etagon's, so I'm certainly biased, both about us vs. Etagon and RAC in general. However, the financial savings of RAC can be significant - we do cost analyses all the time of RAC for potential customers, and its often as simple as: 2 mid-size sun servers (we'll say 16 processors) - $300,000 each = $600,000 a cluster of 5 4-way servers = $100,000 Cost of RAC per processor (list, even!) - $20,000 x 20 = $400,000 So, not taking into account the cost of clustering software for the two big sun boxes, the cost of downtime due to hardware failure, sun platinum support, discounted RAC licenses, forklift upgrades, and more expensive backup and other software licenses for larger servers - basically the simplest analysis you can do, RAC is still $100k cheaper. If we do add in those other factors, RAC becomes even more cost-effective. Where some of those cost savings get eaten up, though is in additional complexity and administration cost - which is where companies like mine and Etagon find a market. RAC is hard, there's no question. The financial savings in RAC generally don't come from the license costs (I can show how you can save on license costs, but we're straying into an advertisement for our product at that point), they come from improved availability and reduced hardware costs. Big SMP servers are exponentially more expensive than small ones, and the software that runs on them is correspondingly exponentially expensive. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mogens Nørgaard Sent: Thursday, December 04, 2003 3:29 AM To: Multiple recipients of list ORACLE-L Subject: Re: ETAGON... Etagon invited me to come and visit them at their stand at the UKOUG conference in Birmingham next week. Don't know if I'll have time or not, but in general I'm still looking for hard evidence of financial savings using RAC, ie a real comparison where switching to RAC (on whatever platform) meant lower license costs in total. I've only seen calculations where the price of RAC was omitted or hugely discounted. I'm even willing to ignore the increase in complexity that follows from clustering and RAC'ing... One thing, though, that I will not accept, is this notion of TCO. It seems that anybody can use that thing to prove any point, so it becomes hard to compare :). If RAC is cheaper for you than non-RAC it must be because you save the $20K per CPU somewhere else. Or? Mogens Gunnar Berglund wrote: Hi all, I would like to hear, if you have any experience concering Etagon... Short review: Etagon is an Israeli company and their product is Data Center Automation SW focussing initially on Oracle 9i RAC clustering SW. Etagon claims that their SW can produce fundamental savings in 9i RAC installation and lifecycle management. Please see their web site; www.etagon.com http://www.etagon.com I'd be interested to hear if you know Etagon already and in any case what is your take on their value proposition. Is 9i RAC installation maintenance a real pain point to you? And could Etagon SW possibly ease that pain? -- -- Download Yahoo! Messenger http://uk.rd.yahoo.com/mail/tagline_messenger/*http://downloa d.yahoo.com/dl/intl/ymsgruk.exe now for a chance to WIN http://uk.rd.yahoo.com/mail/tagline_messenger/*http://messenger.promotions. yahoo.com/rwuk Robbie Williams Live At Knebworth DVD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself
