AW: Oracle and OpenLDAP server
We don't use it, yet. I considered using AD, because we already have an AD. But, I would prefer OpenLDAP for the UNIX world. OID is not an option since it is pretty much overkill for our needs. Let's try and see ;). Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Montag, 28. Juli 2003 16:05 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server Stefan - Instead of AD?? I'm still trying to figure out how to get it to work with AD. My impression at this point is that only a few people have played with OID. I really hope you receive a reply because it will probably give me some hints about how to use it with AD. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 28, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD ? If so, does anybody know of a good How-To ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: Oracle Banner
Hi Chris, Nice idea!, Out of interest I was looking for a way to hide or alter the listener banner info when i was writing the Oracle security step-by-step book for SANS but i didn't consider how to alter the banner info for the server as well. I wanted to find a way to hide banner info to stop those people who map networks looking for recognisable apps so that they can exploit them. The best way forward we could come up with at the time was to set the password as suggested in Howard Smiths paper. Oracle do allow configurable banner info for IFS and I was told by someone in Oracle that they were working towards allowing a configurable banner for the listener sometime in the future. I will add your idea for the server to my list though, thanks. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Ok, I like vi, that's why I turn on vi emulation in emacs. I use vim for quick file viewing because it loads faster than emacs. But, over time, I've found that emacs gives you a load of little extras that suck you in and become indispensible. A few that spring to mind: - - jde - java IDE, does most things that eclipse will without the memory footprint and crashes. - dired - directory browsing including remote browsing via ftp - sql-mode - sqlplus in emacs - gnuserve - so you can open up files from windows explorer in a pre-existing emacs instance. Yeah, you can probably get all of these from other programs that you use in conjunction with vim, but you don't get the integration (plus vim's syntax highlighting is slow. I've got a 200k perl script that takes minutes to highlight in vim, but only a few seconds in emacs). What have you got to lose (apart from a few months of your life messing with your .emacs). YMMV David Lord -Original Message- From: Stefan Jahnke [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 14:49 To: Multiple recipients of list ORACLE-L Subject: AW: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi on *nix and cygwin is the friend Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Orr, Steve [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 25. Juli 2003 22:10 An: Multiple recipients of list ORACLE-L Betreff: Emacs on SQLPlus, er uh... SQLPlus on emacs. vi is what I use and it's the predominant editor for SysAdmin/DBA types but I'm curious as to how many DBA's use emacs. I just saw a demo of SQL*Plus running under emacs and it was quite functional... Sorta like and IDE for SQL without Windoze GUI dependencies. Any DBA's use emacs on a daily basis? :wq (Or ZZ) Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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). ** This communication is intended for the addressee(s) named above only. This communication may contain confidential or privileged information. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the sender by replying to the email communication or by telephone and then delete the communication and any copies of it. Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure that they are actually virus free. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lord David INET: [EMAIL PROTECTED] Fat City Network Services--
RE: Oracle and OpenLDAP server
I have found the following link. It might be what you are looking for http://home.nc.rr.com/jtlayton/oid2openldap.html Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L We don't use it, yet. I considered using AD, because we already have an AD. But, I would prefer OpenLDAP for the UNIX world. OID is not an option since it is pretty much overkill for our needs. Let's try and see ;). Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Montag, 28. Juli 2003 16:05 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server Stefan - Instead of AD?? I'm still trying to figure out how to get it to work with AD. My impression at this point is that only a few people have played with OID. I really hope you receive a reply because it will probably give me some hints about how to use it with AD. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 28, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD ? If so, does anybody know of a good How-To ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: Hatzistavrou John 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).
AW: Oracle and OpenLDAP server
Hi Yannis (or John ?) That's GREAT. Exactly what I was looking for. I'll play around with it on the weekend and give some feedback to the list next week (if somebody is interested, that is). Thanks a lot ! Stefan -Ursprüngliche Nachricht- Von: Hatzistavrou John [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. Juli 2003 10:44 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server I have found the following link. It might be what you are looking for http://home.nc.rr.com/jtlayton/oid2openldap.html Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L We don't use it, yet. I considered using AD, because we already have an AD. But, I would prefer OpenLDAP for the UNIX world. OID is not an option since it is pretty much overkill for our needs. Let's try and see ;). Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Montag, 28. Juli 2003 16:05 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server Stefan - Instead of AD?? I'm still trying to figure out how to get it to work with AD. My impression at this point is that only a few people have played with OID. I really hope you receive a reply because it will probably give me some hints about how to use it with AD. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 28, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD ? If so, does anybody know of a good How-To ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: Hatzistavrou John 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: Stefan Jahnke 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).
undo tablespace and set transaction use rollback segment
when we were using oracle8i , whe had some process which use set transaction use rollback segment. and now we use undo tablespace and we have still same porocesses . how can set a rollbback segment for process with undo tablepsace -- 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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Thanks for this David, it's given me somewhere to start!!! Cheers Lee -Original Message- Sent: 28 July 2003 17:35 To: Multiple recipients of list ORACLE-L Here's mine with references to optional packages (mainly jde) removed. Its set up for windows and cygwin, so if you're using something else (better;) you can remove the cygwin bit at the end. --x--x--x--x--x--cut-here--x--x--x--x--x-- (setq viper-mode t) (require 'viper) (custom-set-variables ;; custom-set-variables was added by Custom -- don't edit or cut/paste it! ;; Your init file should contain only one such instance. '(auto-compression-mode t nil (jka-compr)) '(case-fold-search t) '(column-number-mode t) '(current-language-environment Latin-1) '(default-input-method latin-1-prefix) '(fill-column 80) '(font-lock-maximum-size 1048576) '(frame-background-mode (quote dark)) '(global-font-lock-mode t nil (font-lock)) '(indent-tabs-mode nil) '(mouse-wheel-mode t nil (mwheel)) '(perl-continued-brace-offset -3) '(perl-continued-statement-offset 3) '(perl-indent-level 3) '(sgml-indent-data t t) '(tab-width 3) '(text-mode-hook (quote (turn-on-auto-fill (lambda nil (auto-fill-mode 1)) viper-mode text-mode-hook-identify))) '(viper-auto-indent t) '(viper-electric-mode nil) '(viper-emacs-state-mode-list (quote (custom-mode dired-mode efs-mode tar-mode mh-folder-mode gnus-group-mode gnus-summary-mode Info-mode Buffer-menu-mode view-mode vm-mode vm-summary-mode SQLi-mode sql-interactive-mode shell-mode csh-mode ksh-mode comint-mode telnet-mode rlogin-mode))) '(viper-vi-state-mode-list (quote (fundamental-mode makefile-mode help-mode awk-mode m4-mode html-mode emacs-lisp-mode lisp-mode lisp-interaction-mode java-mode cc-mode c-mode c++-mode fortran-mode f90-mode basic-mode bat-mode asm-mode prolog-mode text-mode indented-text-mode tex-mode latex-mode bibtex-mode completion-list-mode compilation-mode perl-mode javascript-mode tcl-mode python-mode gnus-article-mode mh-show-mode sql-mode sh-mode Man-mode man-mode ;; SQL/PL/SQL mode (add-to-list 'auto-mode-alist '(\\.sql$ . sql-mode)) (add-to-list 'auto-mode-alist '(\\.pls$ . sql-mode)) (add-to-list 'auto-mode-alist '(\\.plb$ . sql-mode)) (eval-after-load sql '(font-lock-add-keywords 'sql-mode '(((exception\\|notfound\\|pragma\\|cursor_already_open\\|dup_val_on_i ndex\\|invalid_cursor\\|invalid_number\\|login_denied\\|no_data_found\\|not_ logged_on\\|program_error\\|storage_error\\|timeout_on_resource\\|too_many_r ows\\|transaction_backed_out\\|value_error\\|zero_divide\\|others\\)\\ . font-lock-warning-face) (\\loop\\ . font-lock-keyword-face) ((if\\|elsif\\|else\\|while\\|return\\)\\ . font-lock-function-name-face (autoload 'sql-oracle sql Interactive SQL mode. t):w ;; Load dired-x (require 'dired-x) ;; Another attept to get cygwin working (setq binary-process-input t) (setq w32-quote-process-args ?\) (setq shell-file-name bash) ;; or sh if you rename your bash executable to sh. (setenv SHELL shell-file-name) (setq explicit-shell-file-name shell-file-name) (setq explicit-sh-args '(-login -i)) --x--x--x--x--x--cut-here--x--x--x--x--x-- -Original Message- From: Lee Cullip [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 16:24 To: Multiple recipients of list ORACLE-L Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs. Thanks David, that is pretty good stuff. Where would the .emacs file be for this so that I can have a look and try and understand the configuration? Cheers Lee -Original Message- Sent: 28 July 2003 14:14 To: Multiple recipients of list ORACLE-L I know what you mean. The best I can come up with is http://www.emacswiki.org/cgi-bin/wiki.pl?SqlMode. My .emacs has been built up over five years. Its not pretty, but I'd be lost without it. Fortunately, sql-mode comes with GNU emacs (and I'm almost certain, with Xemacs) and doesn't need any setup beyond ensuring that Emacs can find the oracle client installation. Simply type M-x sql-oracle. It will prompt for the username, password and sqlnet alias and then try to log you in. Regards David Lord -Original Message- From: Lee Cullip [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 13:49 To: Multiple recipients of list ORACLE-L Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs. I'd see myself as one of the old dinosaur type's!! (Been using vi since I can remember) ;-) I've tried playing with emacs many times, but it's the configuration that put's me off everytime. Is there a good source of information for configuring emacs with sql support ? Regards Lee -Original Message- Sent: 28 July 2003 13:21 To: Multiple recipients of list ORACLE-L I use sql-mode for local databases. Its got the advantage that you can 'pop' sql statements from another buffer into it, giving you something very like the sqlplus worksheet. Its great when you're
RE: Oracle and OpenLDAP server
I am looking forward to your feedback. Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 12:49 PM To: Multiple recipients of list ORACLE-L Hi Yannis (or John ?) That's GREAT. Exactly what I was looking for. I'll play around with it on the weekend and give some feedback to the list next week (if somebody is interested, that is). Thanks a lot ! Stefan -Ursprüngliche Nachricht- Von: Hatzistavrou John [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 29. Juli 2003 10:44 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server I have found the following link. It might be what you are looking for http://home.nc.rr.com/jtlayton/oid2openldap.html Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L We don't use it, yet. I considered using AD, because we already have an AD. But, I would prefer OpenLDAP for the UNIX world. OID is not an option since it is pretty much overkill for our needs. Let's try and see ;). Stefan -Ursprüngliche Nachricht- Von: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Gesendet: Montag, 28. Juli 2003 16:05 An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle and OpenLDAP server Stefan - Instead of AD?? I'm still trying to figure out how to get it to work with AD. My impression at this point is that only a few people have played with OID. I really hope you receive a reply because it will probably give me some hints about how to use it with AD. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 28, 2003 4:04 AM To: Multiple recipients of list ORACLE-L Hi Is there a way to get Oracle to work with OpenLDAP instead of OID, NDS or AD ? If so, does anybody know of a good How-To ? TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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: Hatzistavrou John 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: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Integration with IBM Mqueue series
Did anybody get to download the presentation? When I try and get it form the NJ downloads page I get a: The requested URL /download/Oracle PRN Streams.ppt was not found on this server. message. I would very much like to read this. Thanks T¬ _ Tim Onions Speech Machines -Original Message- Sent: 25 July 2003 17:20 To: Multiple recipients of list ORACLE-L I thinks Oracle Streams in 9i does the same thing. Please check for doc on otn or metalink. I attended a workshop on Oracle Streams in NJ yesterday and presenter was Indy Johal. A nice presentation. It may be placed at www.njoug.org. He is also going to present it in Oracle OPENWorld in SEP 2003. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 25 Jul 2003 07:19:24 -0800 Try reading up about Oracle AQ, and particularly the JMS and translation related stuff with 9i AQ. IBM MQ series is a Messaging gateway for EAI integration, It has a number of competitors such as See Beyond, Tibco and MS Biztalk. In simple terms these systems take in a message and through translation rules read the message header and route it to another system, so your Oracle Applications can talk to the SAP system or the Peoplesoft system or our software via a single interface as the MQ server acts as the gateway. All adaptors are generally C++ or Java but not exclusively and the messages are XML Oracle has or did have a product called Interconnect built on AQ that was a competitor for MQ Series HTH Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rakesh Gupta [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2003 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Integration with IBM Mqueue series One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta 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). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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:
Re: latch
Hi! Shared pool latch protects memory allocation and de-allocation in shared pool. Thus probably you have a very volatile shared pool currently. You have several options, first of them would be to check whether you'r application is using bind variables. If it is mostly using literal values in SQL, then each sql call with different parameters has to be parsed and stored in library cache along with it's execution plan etc.. Maybe you have too *big* shared pool? I'm not sure about 9i, but in 8i you could have a lot of shared pool LRU scanning for recreatable chunks when loading/parsing in a new object. If literal values in SQL are your case, then either change the app or use cursor_sharing = force parameter. Check www.ixora.com.au Q+A section under shared pool, there is more information about shared pool tuning. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 28, 2003 8:34 PM can someone please tell me what is shared pool latch(latch# 155) and how do we prevent this. i am facing this in 9i very frequently. thanks sai -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sai Selvaganesan 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).
ocp question
Im using the osborne OCP books for review. They say you can do analyze table table_name validate structure into storage of bad rows table I do that I get ORA-14510 only place its documented is on metalink and it says: Error: ORA 14510 Text: can specify VALIDATE INTO clause only for partitioned tables --- Cause: The VALIDATE INTO has been specified for a non partitioned table or cluster or index. Action: Use syntax correctly . how do you define where you want to store your results ofa validate structure. I know you can use the invalid_rows table, but Im testing. and the book is wrong. -- 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: Integration with IBM Mqueue series
Tim I am attaching the file to your Email Id Directly and will also pass the message to the support team of the site for correction. Indy Johal Tim Onions [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/29/03 08:11 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Integration with IBM Mqueue series Did anybody get to download the presentation? When I try and get it form the NJ downloads page I get a: The requested URL /download/Oracle PRN Streams.ppt was not found on this server. message. I would very much like to read this. Thanks T¬ _ Tim Onions Speech Machines -Original Message- Sent: 25 July 2003 17:20 To: Multiple recipients of list ORACLE-L I thinks Oracle Streams in 9i does the same thing. Please check for doc on otn or metalink. I attended a workshop on Oracle Streams in NJ yesterday and presenter was Indy Johal. A nice presentation. It may be placed at www.njoug.org. He is also going to present it in Oracle OPENWorld in SEP 2003. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 25 Jul 2003 07:19:24 -0800 Try reading up about Oracle AQ, and particularly the JMS and translation related stuff with 9i AQ. IBM MQ series is a Messaging gateway for EAI integration, It has a number of competitors such as See Beyond, Tibco and MS Biztalk. In simple terms these systems take in a message and through translation rules read the message header and route it to another system, so your Oracle Applications can talk to the SAP system or the Peoplesoft system or our software via a single interface as the MQ server acts as the gateway. All adaptors are generally C++ or Java but not exclusively and the messages are XML Oracle has or did have a product called Interconnect built on AQ that was a competitor for MQ Series HTH Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Rakesh Gupta [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 26-07-2003 12:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Integration with IBM Mqueue series One of our clients requirement is to replicate data from oracle to IBM mqueue series. We are 100% oracle shop and we do not have any IBM DB experience. Can anyone please shed some light on how this can be done ? Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta 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). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051
Resend : Question about EXTPROC and vulnerability
Resending this email, hoping for a reply this time. Date: Fri, 25 Jul 2003 07:49:24 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Hemant K Chitale [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] From: Hemant K Chitale [EMAIL PROTECTED] Subject: Question about EXTPROC and vulnerability Organization: Fat City Network Services, San Diego, California Oracle's Security Alert #29 [Note 175429.1] on the EXTPROC recommends the workaround to disable EXTPROC as 1. Removing the entry for extproc/PLSExtproc/icache_extproc from the listener.ora 2. Removing the entry from the tnsnames.ora 3. Renaming or removing the extproc executable Why should all three actions be necessary ? Why not just removing the entry from the listener.ora ? Can extproc be called without the listener configured ? Security Alert #57 just talks of the CREATE LIBRARY privilege and makes no mention of updating the listener.ora or tnsnames.ora or removing/renaming the extproc executable. Why ? Is it that Oracle wants people to use EXTPROC [or makes use of EXTPROC itself] so it does not specify how EXTPROC can be disabled ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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 look at this imp command
imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: clustering
Tanel, I think that you've had some unfortunate experiences with RAC. Mind elucdating them ? I don't see nodes hanging when one node dies [I'm running a 2-node Tru64 RAC Cluster] Hemant At 03:04 PM 28-07-03 -0800, you wrote: However, failed transactions must be handled from client side. Queries may migrate to surviving nodes transparently. Also, currently RAC has many problems, such all nodes hanging when one node dies. Completely separate systems are still (an will always be) the most available solution. Tanel. - Original Message - From: Indy Johal To: Multiple recipients of list ORACLE-L Sent: Monday, July 28, 2003 7:49 PM Subject: Re: clustering Another Important different is that RAC is best High Availability solution in case of System/Instance Failure where in case of HP or Veritas Cluster, all of the resource get stopped on live system/node of the cluster and then get started on second node and hence user will be affected. But in case of system or Instance failure, there is seamless transition of the User session in RAC Indy Johal Ron Rogers [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/28/03 12:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: Re: clustering ak, As I understand it, an HP cluster is 2 boxes that have the capability to access the same disks and data but only one can have the oracle instance running and accessing the datafiles(active). Sort of like a high availability option. With RAC both boxes can access the instance and datafiles at the same time. List, Correct me if I need it. Ron [EMAIL PROTECTED] 07/28/03 12:14PM Hi Guys , I am new to this clustering concept. Just trying to understand few basics . Need ur help . what is differece between oracle running on sun /hp cluster with 2 nodes and oracle with RAC running on 2 nodes ? thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
BYTES in DBA_DATA_FILES shows NULL
Hi all, Can somebody explain how you can have NULL value for BYTES field in DBA_DATA_FILES? However, V$DATAFILE view shows the correct size under BYTES field. Query the SYS.X$KTFBHC, ktfbhccval field is equal to 1 for the offending datafiles. Tempting to bounce this production database later if that will fix the problem. How this happened... 1) ran script to add datafiles to existing tablespace: ALTER tablespace DATA_HISTORY add datafile '/u09/bilp/data_history_05.dbf' SIZE 1966088K, '/u06/bilp/data_history_06.dbf' SIZE 1966088K; 2) broke out of session 3) files were created on mount points /u09 and /u06 4) I saw that the files were created on UNIX, but Oracle still saw them a 0 bytes 5) I tried to resize the datafile's (received error - ORA-0600) --- alter database datafile '/u06/bilp/data_history_06.dbf' resize 100M 6) Took datafiles off-line 7) Tried to take them online, got a message that recovery is needed. Recovered datafiles 8) datafiles online, but still show 0 bytes 9) I was able to select and insert records into a table that uses this tablespace. Any idea will be greatly appreciated. Thanks, Gunawan Yuwono Oracle DBA Kansas City = Gunawan Yuwono Oracle DBA Kansas City, USA __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gunawan Yuwono 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).
ORA-03115 (TOAD question!!)
Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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: Resend : Question about EXTPROC and vulnerability
I sent a reply on that day. Here it is, once again. Date: Fri, 25 Jul 2003 12:25:59 -0400 Subject: Re: Question about EXTPROC and vulnerability Hemant, You are right in wondering why there are three steps. 1. The lsitener must not be listening for the EXTPROC connections - that is the first line of defense. 2. There is no absolute need to remove from tnsnames.ora, but good to do so as you will see later. 3. The executabe has to be removed as it could be exploited in a different manner. Note, all security alerts are based on what is known _today_; not what is possible. Just because the listener is not listening for the extproc executable does not _necessarily_ indicate that it can't be used in an attack; an enterprising hacker may find a way. If your intention is to remove extproc, you did so by removing from listener.ora; so it is just prudent to remove the last potential hole by removing extproc executable, too. After all, it not useful. Now for the other question why the alter 57 does not talk about the listener.ora security. The alerts 29 and 57 are similar, yet different. The alert 29 talks about a buffer overflow using the external process. The alert 57 is about system privileges. The system privilege, create library will alow a hacker to create a library on any filesystem that the user oracle has privileges on, INCLUDING THE ORACLE_HOME/BIN and $OH/lib! Therefore, imagine a hacker breaks in, creates a library that uses the Oracle excutables and java libraries and executes them. This is a huge hole and should be plugged by simply disallowing any user to create a library. Take for instance, a user has to create a library to create a function for some complex mathemetical calculation, e.g. finding the prime numbers, which can't be done in PL/SQL. This can be done via a C++ program and the shared object can be made availabel to ORacle using a lbrary as: create library prime_num_lib as '/usr/ananda/lib/prime_num_lib.so'; When a user uses this library, the EXTPROC process will run the .so file on the user's behalf. Fair enough; what's wrong with that? What is the user (the hacker) creates a library to point to some .so file in $OH/lib directory? You get the picture what might happen. Another variation of the create library is create library prime_num_lib as '/usr/ananda/lib/prime_num_lib.so' AGENT 'dblink1' Here the Oracle server process uses the dblink to connect to another server's EXTPROC process to executes its task. Instead of using a dblink to another server, it may actually connect to the extproc of the same server using the connect string defined in the tnsnames.ora. It may not exist; but what if the hacker actually copied the exeutable to a different name, seemingly harmless. Removing extproc from tnsnames.ora wil lplug that hole too. BEsides, it is a good practice to remove it since the presence indicates the usage (albeit in the past) and may give a potential hacker a clue. Remember, securing is not just plugging the most obvious holes; but all potential ones. The alerts point that out. Another thing of note here is to plug a seprate potential problem - removing the CREATE ANY DIRECTORY privilege. This provilege creates a directory on any filesystem accessible by oracle user. Do not grant any one this privilege; and be very cautious while granting CREATE DIRECTORY privilege, too. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:59 AM Resending this email, hoping for a reply this time. Date: Fri, 25 Jul 2003 07:49:24 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Hemant K Chitale [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] From: Hemant K Chitale [EMAIL PROTECTED] Subject: Question about EXTPROC and vulnerability Organization: Fat City Network Services, San Diego, California Oracle's Security Alert #29 [Note 175429.1] on the EXTPROC recommends the workaround to disable EXTPROC as 1. Removing the entry for extproc/PLSExtproc/icache_extproc from the listener.ora 2. Removing the entry from the tnsnames.ora 3. Renaming or removing the extproc executable Why should all three actions be necessary ? Why not just removing the entry from the listener.ora ? Can extproc be called without the listener configured ? Security Alert #57 just talks of the CREATE LIBRARY privilege and makes no mention of updating the listener.ora or tnsnames.ora or removing/renaming the extproc executable. Why ? Is it that Oracle wants people to use EXTPROC [or makes use of EXTPROC itself] so it does not specify how EXTPROC can be disabled ? Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
RE: ORA-03115 (TOAD question!!)
Title: RE: ORA-03115 (TOAD question!!) It is a TOAD question you need to read the sqlnet setup section from help file. It is pretty detailed and will help you resolve the problem. 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: Charu Joshi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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). *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.*1
Re: Oracle AQ monitoring questions
We are using AQ for long time . No problems so far . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 28, 2003 8:29 PM Hi, I am looking at using Oracle AQ to post messages.I know they are just like any other database table but with some limitations.i have some concerns from what I have heard from users who have previously used AQ 1.Are there any serious concerns in using AQ.My purpose of using AQ is just to act like a messager of message and to have JMS features implemented with the Application.Are there any known issues? or any advantages.? 2.Are there any monitoring scripts/features within oracle database to monitor the AQ for their growth/size/length or corruption.? 3.Does AQ get corrupted more often than other oracle tables?How can we find out if AQ is getting corrupted.This question may be related to the previous one . Pls advice. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra 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: AK 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: ORA-03115 (TOAD question!!)
Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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: AK 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).
direct path write waits, please help
Hi All, Please help me tune this i/o related wait event. This is my 8.1.6 statspack top-5 wait list: Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- direct path write 304,867 35,925 49.83 log file sync 145,015 23,441 32.52 db file sequential read11,3703,684 5.11 file open 9813,326 4.61 db file parallel write 1,8933,115 4.32 You'll notice that 'direct path write' is the most expensive one in the list. I cannot find enough info on the net about this wait event, therefore I'm asking the real experts. What events in Oracle trigger this wait event? In what way is this event different from db file parallel write? I mostly read comments that suggest lots of sorting and parallallel queries. However, most sorts are done in memory and degree = 0 for all tables. Any suggestions are very welcome. Thanks, Hans de Git _ MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hans de Git 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: direct path write waits, please help
Hi Hans, direct path write cause would be writing temporary segments when sorts are too large to be performed in memory, direct path operations like INSERT /+ APPEND or LOB access. It's hard to guess which one is causing your problems, so I'd suggest you profiling the call having performance issues : alter session set events = '10046 trace name context forever, level 8'; do what is an issue alter session set events = '10046 trace name context off'; Find trace file in udump directory and use tkprof then to identify SQL statement waiting on direct path write. You will need 9i tkprof (any platform is good) to report wait events, otherwise you could review raw trace file . HTH Vadim -Original Message- Sent: Tuesday, July 29, 2003 11:54 AM To: Multiple recipients of list ORACLE-L Hi All, Please help me tune this i/o related wait event. This is my 8.1.6 statspack top-5 wait list: Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- direct path write 304,867 35,925 49.83 log file sync 145,015 23,441 32.52 db file sequential read11,3703,684 5.11 file open 9813,326 4.61 db file parallel write 1,8933,115 4.32 You'll notice that 'direct path write' is the most expensive one in the list. I cannot find enough info on the net about this wait event, therefore I'm asking the real experts. What events in Oracle trigger this wait event? In what way is this event different from db file parallel write? I mostly read comments that suggest lots of sorting and parallallel queries. However, most sorts are done in memory and degree = 0 for all tables. Any suggestions are very welcome. Thanks, Hans de Git _ MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hans de Git 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: Gorbounov,Vadim 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: Please look at this imp command
Hi Stephen, No imp wouldn't close or otherwise impact Oracle instance. I'd look at init.ora . Someone could make changes there, effective at reboot time Vadim -Original Message- [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:04 AM To: Multiple recipients of list ORACLE-L imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Gorbounov,Vadim 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: clustering
Title: Message Hrrrmm - well, we've never seen the problem you describe, and we've got a pretty big RAC environment here (clusters from two to six nodes, and we combine dev clusters to build bigger ones as we need). What the situation you describe sounds like is what happens when there's interconnect failure. Each node thinks independently that its been separated from the rest of the cluster and (effectively) shoots itself in the head. This causes every instance to hang. This is why the crafty RAC Jedi designs well their interconnect architecture. But yes, if you're willing to take the "completely 2n capacity" cluster route and have two databases, double the oracle licenses, two storage arrays, two fibre channel networks, etc., that is the highest availability/reliability cluster you can have - although at the highest cost and complexity. Which clustering solution is right for you? Cheap and inelegant? Expensive and bullet-proof? Well, that's why we get paid the big bucks, right? :) Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Monday, July 28, 2003 7:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: clustering However, failed transactions must be handled from client side. Queries may migrate to surviving nodes transparently. Also, currently RAC has many problems, such all nodes hanging when one node dies. Completely separate systems are still (an will always be) the most available solution. Tanel. - Original Message - From: Indy Johal To: Multiple recipients of list ORACLE-L Sent: Monday, July 28, 2003 7:49 PM Subject: Re: clustering Another Important different is that RAC is best High Availability solution in case of System/Instance Failure where in case of HP or Veritas Cluster, all of the resource get stopped on live system/node of the cluster and then get started on second node and hence user will be affected. But in case of system or Instance failure, there is seamless transition of the User session in RAC Indy Johal "Ron Rogers" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/28/03 12:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: clusteringak,As I understand it, an HP cluster is 2 boxes that have the capabilityto access the same disks and data but only one can have the oracleinstance running and accessing the datafiles(active). Sort of like ahigh availability option.With RAC both boxes can access the instance and datafiles at the sametime.List, Correct me if I need it.Ron [EMAIL PROTECTED] 07/28/03 12:14PM Hi Guys ,I am new to this clustering concept. Just trying to understand fewbasics . Need ur help .what is differece between oracle running on sun /hp cluster with 2nodes and oracle with RAC running on 2 nodes ? thanks,-ak-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ron RogersINET: [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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Hi I use vi on Unix and textpad on windoze. I like to write macros for vi so it types repetitive code for me...:-), although I should probably use an editor with more powerful macro facilities. cheers Pete Pete! Another textpad fan ... way to go! An outstanding text editor for windows (even better than ultraedit in my opinion) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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: direct path write waits, please help
Hans I did a search on Google, and found this article: http://www.faqchest.com/prgm/oracle-l/ora-02/ora-0206/ora-020638/ora02062414 _22868.html (you'll probably have to patch the link together) According to this article, your biggest and second biggest wait may be connected. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Hi All, Please help me tune this i/o related wait event. This is my 8.1.6 statspack top-5 wait list: Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- direct path write 304,867 35,925 49.83 log file sync 145,015 23,441 32.52 db file sequential read11,3703,684 5.11 file open 9813,326 4.61 db file parallel write 1,8933,115 4.32 You'll notice that 'direct path write' is the most expensive one in the list. I cannot find enough info on the net about this wait event, therefore I'm asking the real experts. What events in Oracle trigger this wait event? In what way is this event different from db file parallel write? I mostly read comments that suggest lots of sorting and parallallel queries. However, most sorts are done in memory and degree = 0 for all tables. Any suggestions are very welcome. Thanks, Hans de Git _ MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hans de Git 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).
Number of processors and standard edition
I am trying to find any info on if there is a maximum number pf processors that a server can have and have Oracle standard edition run on it. Just looking to see if there is a cutoff point in the number of processors where I would be forced to go to Enterprise Edition of Oracle 8i.. I'm looking through the concepts docs but have not yet found this info. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave 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: Please look at this imp command
Two things to check immediately: (1) Is the Oracle service defined as started automatically in the services? (2) If yes, is there any error reported in alert log of the database? Import does not shut the database down. HTH Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:04 AM imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Arup Nanda 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: Please look at this imp command
Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: Number of processors and standard edition
Last time I checked it was 4 for Windows NT/2000. Not a UNIX shop so can't comment on that OS. T¬ _ Tim Onions Speech Machines -Original Message- Sent: 29 July 2003 18:04 To: Multiple recipients of list ORACLE-L I am trying to find any info on if there is a maximum number pf processors that a server can have and have Oracle standard edition run on it. Just looking to see if there is a cutoff point in the number of processors where I would be forced to go to Enterprise Edition of Oracle 8i.. I'm looking through the concepts docs but have not yet found this info. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave 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: Tim Onions 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: Number of processors and standard edition
Dave - Maximum of 4 processors. http://www.pro-dba.com/oracle_database_standard_edition.html Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 29, 2003 12:04 PM To: Multiple recipients of list ORACLE-L I am trying to find any info on if there is a maximum number pf processors that a server can have and have Oracle standard edition run on it. Just looking to see if there is a cutoff point in the number of processors where I would be forced to go to Enterprise Edition of Oracle 8i.. I'm looking through the concepts docs but have not yet found this info. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave 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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Or, for you GPL, cross-platform fans, there's NEdit at http://www.nedit.org I've made a simple addition to it's extensible config file so that it properly highlights all available Oracle 8i parameters when editing an init.ora file. My v5.3 .nedit file can be nabbed from http://society.servebeer.com/.nedit Look for the Oracle highlight in the file. Any additions/corrections are more than welcome. Enjoy! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Grant Allen [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs. Hi I use vi on Unix and textpad on windoze. I like to write macros for vi so it types repetitive code for me...:-), although I should probably use an editor with more powerful macro facilities. cheers Pete Pete! Another textpad fan ... way to go! An outstanding text editor for windows (even better than ultraedit in my opinion) Ciao Fuzzy :-) -- 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).
RE: Number of processors and standard edition
My memory is 4 ... and with typical Oracle Licensing Shennanigans attached ... I remember a few cases from 2001 where clients where arguing whether SE could be licenced for up to and including 4, or up to but not including 4. But given that's a two-year-old memory, I can pretty much guarantee Oracle licencing has changed 28 times since then :-) Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Farnsworth, Dave Sent: Tuesday, July 29, 2003 18:04 To: Multiple recipients of list ORACLE-L Subject: Number of processors and standard edition I am trying to find any info on if there is a maximum number pf processors that a server can have and have Oracle standard edition run on it. Just looking to see if there is a cutoff point in the number of processors where I would be forced to go to Enterprise Edition of Oracle 8i.. I'm looking through the concepts docs but have not yet found this info. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave 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: Grant Allen 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 7.3.2
We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am not concerned if Oracle has certified or desupported this, I just want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: Please look at this imp command
I'm starting to gather that -- that the reboot did it. Entertainingly enough I had enough presence of mind to use EM As SYSDBA and open the database using the InitTPOCS.ora. The users have been using the application for the last four hours without any issues, so, what is the graceful way of shutting down the database, via, EM and do a close? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Please look at this imp command Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Please look at this imp command
INLINE snip Two things to check immediately: (1) Is the Oracle service defined as started automatically in the services? Yes (2) If yes, is there any error reported in alert log of the database? Compared line-by-line the last three starts and they seem identical, nothing unusual in the last start. Anyway here is today's entries: Tue Jul 29 03:44:39 2003 Thread 1 advanced to log sequence 73 Current log# 1 seq# 73 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Tue Jul 29 03:45:00 2003 Thread 1 advanced to log sequence 74 Current log# 2 seq# 74 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Tue Jul 29 03:45:31 2003 Thread 1 advanced to log sequence 75 Current log# 3 seq# 75 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Dump file D:\oracle\admin\tpocs\bdump\tpocsALRT.LOG Tue Jul 29 05:31:23 2003 ORACLE V9.0.1.1.1 - Production vsnsta=0 vsnsql=10 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 3, CPU type 586 Starting up ORACLE RDBMS Version: 9.0.1.1.1. System parameters with non-default values: processes= 150 timed_statistics = TRUE shared_pool_size = 50331648 java_pool_size = 33554432 control_files= D:\oracle\oradata\tpocs\control01.ctl, D:\oracle\oradata\tpocs\control02.ctl, D:\oracle\oradata\tpocs\control03.ctl db_block_size= 4096 db_cache_size= 33554432 compatible = 9.0.0 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS remote_login_passwordfile= EXCLUSIVE db_domain= instance_name= tpocs background_dump_dest = D:\oracle\admin\tpocs\bdump user_dump_dest = D:\oracle\admin\tpocs\udump core_dump_dest = D:\oracle\admin\tpocs\cdump sort_area_size = 524288 db_name = tpocs open_cursors = 300 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Tue Jul 29 05:31:26 2003 /* OracleOEM */ ALTER DATABASE MOUNT Tue Jul 29 05:31:31 2003 Successful mount of redo thread 1, with mount id 1877649006. Tue Jul 29 05:31:31 2003 Database mounted in Exclusive Mode. Completed: /* OracleOEM */ ALTER DATABASE MOUNT Tue Jul 29 05:31:31 2003 /* OracleOEM */ ALTER DATABASE OPEN Tue Jul 29 05:31:32 2003 Beginning crash recovery of 1 threads Tue Jul 29 05:31:33 2003 Started first pass scan Tue Jul 29 05:31:33 2003 Completed first pass scan Tue Jul 29 05:31:38 2003 Started recovery at Thread 1: logseq 74, block 202409, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 2 Seq 74 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Recovery of Online Redo Log: Thread 1 Group 3 Seq 75 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Tue Jul 29 05:31:39 2003 Ended recovery at Thread 1: logseq 75, block 18467, scn 0.2938502 3305 data blocks read, 3305 data blocks written, 20858 redo blocks read Crash recovery completed successfully Tue Jul 29 05:31:40 2003 Thread 1 advanced to log sequence 76 Thread 1 opened at log sequence 76 Current log# 1 seq# 76 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Successful open of redo thread 1. Tue Jul 29 05:31:40 2003 SMON: enabling cache recovery Tue Jul 29 05:31:41 2003 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Tue Jul 29 05:31:41 2003 SMON: enabling tx recovery Tue Jul 29 05:31:43 2003 replication_dependency_tracking turned off (no async multimaster replication found) Completed: /* OracleOEM */ ALTER DATABASE OPEN Import does not shut the database down. I didn't think so. I'm just wondering why when I rebooted the server the TPOCS instance did start, it is like It didn't grab the InitTpocs.ora ...perplexed (but understandable when you are in the constant learn mode. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: direct path write waits, please help
Hans, Now let me guess Your disks are all RAID 5, right? And you possibly are bottlenecking on CPU as well? It is clear from the Top 5 that writes are an issue across the board, to TEMP (direct path write), Redo (log file sync) and DB files (db file parallel writes). Creating a RAID 1 set of disks and moving at least the TEMP, RBS, Redo (and Arch if present) to this will definitely help. John Kanagaraj Phone: 408-970-7002 (W) Fax: 408 327 3086 (Call/Email prior to fax) -Original Message- Sent: Tuesday, July 29, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Hi All, Please help me tune this i/o related wait event. This is my 8.1.6 statspack top-5 wait list: Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- direct path write 304,867 35,925 49.83 log file sync 145,015 23,441 32.52 db file sequential read11,3703,684 5.11 file open 9813,326 4.61 db file parallel write 1,8933,115 4.32 You'll notice that 'direct path write' is the most expensive one in the list. I cannot find enough info on the net about this wait event, therefore I'm asking the real experts. What events in Oracle trigger this wait event? In what way is this event different from db file parallel write? I mostly read comments that suggest lots of sorting and parallallel queries. However, most sorts are done in memory and degree = 0 for all tables. Any suggestions are very welcome. Thanks, Hans de Git _ MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hans de Git 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 Kanagaraj 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: Oracle 7.3.2
We ran 7.3.4 on HPUX 11 and 11i. It ran but we knew we could not relink and we were headed for another release anyway as part of a migration. It will run, but not recommended. Allan -Original Message- Sent: Tuesday, July 29, 2003 12:05 PM To: Multiple recipients of list ORACLE-L We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am not concerned if Oracle has certified or desupported this, I just want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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: ORA-03115 (TOAD question!!)
It's a TOAD issue. It's fixed in one of the v7.x versions. The current supported version is 7.5. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: AK [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-03115 (TOAD question!!) Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- 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).
RE: Oracle 7.3.2
David, You have to install 7.3.2 binaries for HP 11. Both HP 11 and Oracle binaries (whatever version you decide) to be installed from scratch as moving from from 10.20 to 11 itself is not supported. You may request support to provide 7.3.4 version for HP 11.Down load latest patch 7.3.4.5 and apply it after installation. After installing OS and Oracle Binaries , you can run migrate script on your 7.3.2. datafiles. I don't remember we had any serious issues while migration from 10.20 to 11 with version 7.3.4.5 2 years back. As I am no more working with that employer so no access of working paper/migration plan. However, on application side Oracle Financials 10.7 we applied all applicable patches after installing core product. If you have any specific question, please let me know. I shall try my best to answer it based on my memory. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 29 Jul 2003 09:44:23 -0800 We ran 7.3.4 on HPUX 11 and 11i. It ran but we knew we could not relink and we were headed for another release anyway as part of a migration. It will run, but not recommended. Allan -Original Message- Sent: Tuesday, July 29, 2003 12:05 PM To: Multiple recipients of list ORACLE-L We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am not concerned if Oracle has certified or desupported this, I just want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan 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). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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: Oracle 7.3.2
Sounds like time to upgrade. To the best of my limited knowledge on this, it may well run, but in 32 bit mode which may mean modifying the .mak files, manually. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 29, 2003 1:05 PM To: Multiple recipients of list ORACLE-L We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am not concerned if Oracle has certified or desupported this, I just want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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: direct path write waits, please help
But, I would like to know how this seemingly high wait for 'direct path write' is
affecting the
overall response time. (ResponseTime = WaitTime + ServiceTime)
If the 'CPU used by this session' is not considered in light of these wait times,
aren't you
getting ready to bark at the wrong tree?
- Kirti
--- John Kanagaraj [EMAIL PROTECTED] wrote:
Hans,
Now let me guess Your disks are all RAID 5, right? And you possibly are
bottlenecking on CPU as well? It is clear from the Top 5 that writes are an
issue across the board, to TEMP (direct path write), Redo (log file sync)
and DB files (db file parallel writes). Creating a RAID 1 set of disks and
moving at least the TEMP, RBS, Redo (and Arch if present) to this will
definitely help.
John Kanagaraj
Phone: 408-970-7002 (W)
Fax: 408 327 3086 (Call/Email prior to fax)
-Original Message-
Sent: Tuesday, July 29, 2003 8:54 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Please help me tune this i/o related wait event. This is my 8.1.6 statspack
top-5 wait list:
Top 5 Wait Events
~ Wait %
Total
Event Waits Time (cs) Wt
Time
---
direct path write 304,867 35,925
49.83
log file sync 145,015 23,441
32.52
db file sequential read11,3703,684
5.11
file open 9813,326
4.61
db file parallel write 1,8933,115
4.32
You'll notice that 'direct path write' is the most expensive one in the
list. I cannot find enough info on the net about this wait event, therefore
I'm asking the real experts.
What events in Oracle trigger this wait event? In what way is this event
different from db file parallel write?
I mostly read comments that suggest lots of sorting and parallallel queries.
However, most sorts are done in memory and degree = 0 for all tables.
Any suggestions are very welcome.
Thanks,
Hans de Git
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
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: Resend : Question about EXTPROC and vulnerability
Or, alternatively, you could live EXTPROC where it is, no matter how wulnerable it is, and trust a good firewall. If you are in a commercial environment, breaking in a box through the buffer overflow hole would require a major talent, which is very hard to come by in these days of cost cutting. I suggest that if anyone behind the firewall breaks in through that hole, that he's given a promotion to the senior programmer position and a hefty raise. On 2003.07.29 11:29, Arup Nanda wrote: I sent a reply on that day. Here it is, once again. Date: Fri, 25 Jul 2003 12:25:59 -0400 Subject: Re: Question about EXTPROC and vulnerability Hemant, You are right in wondering why there are three steps. 1. The lsitener must not be listening for the EXTPROC connections - that is the first line of defense. 2. There is no absolute need to remove from tnsnames.ora, but good to do so as you will see later. 3. The executabe has to be removed as it could be exploited in a different manner. Note, all security alerts are based on what is known _today_; not what is possible. Just because the listener is not listening for the extproc executable does not _necessarily_ indicate that it can't be used in an attack; an enterprising hacker may find a way. If your intention is to remove extproc, you did so by removing from listener.ora; so it is just prudent to remove the last potential hole by removing extproc executable, too. After all, it not useful. Now for the other question why the alter 57 does not talk about the listener.ora security. The alerts 29 and 57 are similar, yet different. The alert 29 talks about a buffer overflow using the external process. The alert 57 is about system privileges. The system privilege, create library will alow a hacker to create a library on any filesystem that the user oracle has privileges on, INCLUDING THE ORACLE_HOME/BIN and $OH/lib! Therefore, imagine a hacker breaks in, creates a library that uses the Oracle excutables and java libraries and executes them. This is a huge hole and should be plugged by simply disallowing any user to create a library. Take for instance, a user has to create a library to create a function for some complex mathemetical calculation, e.g. finding the prime numbers, which can't be done in PL/SQL. This can be done via a C++ program and the shared object can be made availabel to ORacle using a lbrary as: create library prime_num_lib as '/usr/ananda/lib/prime_num_lib.so'; When a user uses this library, the EXTPROC process will run the .so file on the user's behalf. Fair enough; what's wrong with that? What is the user (the hacker) creates a library to point to some .so file in $OH/lib directory? You get the picture what might happen. Another variation of the create library is create library prime_num_lib as '/usr/ananda/lib/prime_num_lib.so' AGENT 'dblink1' Here the Oracle server process uses the dblink to connect to another server's EXTPROC process to executes its task. Instead of using a dblink to another server, it may actually connect to the extproc of the same server using the connect string defined in the tnsnames.ora. It may not exist; but what if the hacker actually copied the exeutable to a different name, seemingly harmless. Removing extproc from tnsnames.ora wil lplug that hole too. BEsides, it is a good practice to remove it since the presence indicates the usage (albeit in the past) and may give a potential hacker a clue. Remember, securing is not just plugging the most obvious holes; but all potential ones. The alerts point that out. Another thing of note here is to plug a seprate potential problem - removing the CREATE ANY DIRECTORY privilege. This provilege creates a directory on any filesystem accessible by oracle user. Do not grant any one this privilege; and be very cautious while granting CREATE DIRECTORY privilege, too. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:59 AM Resending this email, hoping for a reply this time. Date: Fri, 25 Jul 2003 07:49:24 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Hemant K Chitale [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] From: Hemant K Chitale [EMAIL PROTECTED] Subject: Question about EXTPROC and vulnerability Organization: Fat City Network Services, San Diego, California Oracle's Security Alert #29 [Note 175429.1] on the EXTPROC recommends the workaround to disable EXTPROC as 1. Removing the entry for extproc/PLSExtproc/icache_extproc from the listener.ora 2. Removing the entry from the tnsnames.ora 3. Renaming or removing the extproc executable Why should all three actions be necessary ? Why not just removing the entry from the listener.ora ? Can extproc be called without the listener configured ? Security Alert #57 just talks of the CREATE LIBRARY
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
LOL--I'm the sole ultraedit fan in a den of textpad users have had many conversations that start with the phrase yeah, but can your editor do this I was of the opinion that they were pretty much equal until someone (Dennis Williams?) wrote in reminding me of ue's ability to open/edit/save a file on a remote host via ftp. It appears that tp does that only w/a supporting batch file (yuck!). Imagine my delighted cackling, having proven once and for all that ue is the one true windows text editor... 8^) -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, July 29, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Hi I use vi on Unix and textpad on windoze. I like to write macros for vi so it types repetitive code for me...:-), although I should probably use an editor with more powerful macro facilities. cheers Pete Pete! Another textpad fan ... way to go! An outstanding text editor for windows (even better than ultraedit in my opinion) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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: Pardee, Roy E 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: Oracle 7.3.2
We are running 7.3.4.0 on HP 11.0 with no problems at all, with compatible set to 7.3.3.0. The Application uses some old OO stuff written in GemStone. - Kirti --- Ehresmann, David [EMAIL PROTECTED] wrote: We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am not concerned if Oracle has certified or desupported this, I just want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Number of processors and standard edition
I'm pretty sure that SE will run on any size server, but you'll be charged for EE when that server has more than 4 CPUs... :-) You'll see info for this at http://oraclestore.oracle.com; when you try to price an SE license on a per-processor basis. Click on the explanation of User Minimums for the verbiage... on 7/29/03 10:04 AM, Farnsworth, Dave at [EMAIL PROTECTED] wrote: I am trying to find any info on if there is a maximum number pf processors that a server can have and have Oracle standard edition run on it. Just looking to see if there is a cutoff point in the number of processors where I would be forced to go to Enterprise Edition of Oracle 8i.. I'm looking through the concepts docs but have not yet found this info. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: direct path write waits, please help
WHO LET THE DOGS OUT!!! on 7/29/03 11:14 AM, Kirtikumar Deshpande at [EMAIL PROTECTED] wrote: But, I would like to know how this seemingly high wait for 'direct path write' is affecting the overall response time. (ResponseTime = WaitTime + ServiceTime) If the 'CPU used by this session' is not considered in light of these wait times, aren't you getting ready to bark at the wrong tree? - Kirti --- John Kanagaraj [EMAIL PROTECTED] wrote: Hans, Now let me guess Your disks are all RAID 5, right? And you possibly are bottlenecking on CPU as well? It is clear from the Top 5 that writes are an issue across the board, to TEMP (direct path write), Redo (log file sync) and DB files (db file parallel writes). Creating a RAID 1 set of disks and moving at least the TEMP, RBS, Redo (and Arch if present) to this will definitely help. John Kanagaraj Phone: 408-970-7002 (W) Fax: 408 327 3086 (Call/Email prior to fax) -Original Message- Sent: Tuesday, July 29, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Hi All, Please help me tune this i/o related wait event. This is my 8.1.6 statspack top-5 wait list: Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- direct path write 304,867 35,925 49.83 log file sync 145,015 23,441 32.52 db file sequential read11,3703,684 5.11 file open 9813,326 4.61 db file parallel write 1,8933,115 4.32 You'll notice that 'direct path write' is the most expensive one in the list. I cannot find enough info on the net about this wait event, therefore I'm asking the real experts. What events in Oracle trigger this wait event? In what way is this event different from db file parallel write? I mostly read comments that suggest lots of sorting and parallallel queries. However, most sorts are done in memory and degree = 0 for all tables. Any suggestions are very welcome. Thanks, Hans de Git __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: Oracle 7.3.2
I found out that the OS is HP11i 64bit. Does this change anything, or just make it harder? thanks, David Ehresmann. -Original Message- Sent: Tuesday, July 29, 2003 1:29 PM To: Multiple recipients of list ORACLE-L We are running 7.3.4.0 on HP 11.0 with no problems at all, with compatible set to 7.3.3.0. The Application uses some old OO stuff written in GemStone. - Kirti --- Ehresmann, David [EMAIL PROTECTED] wrote: We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am not concerned if Oracle has certified or desupported this, I just want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Ehresmann, David 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: Maximum Open Cursors on Insert Trigger
Thank you for the replies. It turn out to be a code issue. The developer added olecmd.dispose(), which fixed the problem. [EMAIL PROTECTED] 07/28/03 11:54AM There are some relevant notes on MetaLink that may be of help. Search on 'visual basic ora-1000' Jared On Monday 28 July 2003 07:54, Jay Hostetter wrote: We have a developer that is inserting a large number of records using a VB program. An insert trigger exists on the table. This trigger checks a parent table for records. I know this trigger really is not needed, since a Foreign Key exists to enforce referential integrity, so I plan to disable it (furthermore, it does a SELECT FOR UPDATE, which doesn't make sense). However, I'm trying to understand why the developer keeps getting ORA-01000: maximum open cursors exceeded during the inserts. I've bumped OPEN_CURSORS up to 1000. Is there something unique to VB that could be causing this problem? I've done mass inserts before on tables that have triggers without running into this type of problem. I can't see any problem in the trigger logic, since the cursor is always closed. This is a 9.2.0.3 database on Tru64. Thanks, Jay The source for the trigger is: .. **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter 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: ORA-03115 (TOAD question!!)
I would recommend upgrading to 7.6.x you can download it from www.quest.com From: AK [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-03115 (TOAD question!!) Date: Tue, 29 Jul 2003 07:49:23 -0800 Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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: AK 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). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: Oracle 7.3.2
We were using hp 11 64 bit OS but used Oracle software 32 bit because of Oracle Fianancials 10.7 32 but software. We also tried HP 11i 64bit OS with 7.3.4 in test environment without any issues. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 29 Jul 2003 11:24:23 -0800 I found out that the OS is HP11i 64bit. Does this change anything, or just make it harder? thanks, David Ehresmann. -Original Message- Sent: Tuesday, July 29, 2003 1:29 PM To: Multiple recipients of list ORACLE-L We are running 7.3.4.0 on HP 11.0 with no problems at all, with compatible set to 7.3.3.0. The Application uses some old OO stuff written in GemStone. - Kirti --- Ehresmann, David [EMAIL PROTECTED] wrote: We are going to upgrade a server from HP10.2 to HP11 or HP11i. There is an old version of Oracle 7 running on the box, Oracle 7.3.2. I looked through Oracle's certification matrix and found nothing about HP11 and 7.3.2. I am not concerned if Oracle has certified or desupported this, I just want to know will 7.3.2 run on HP11 and if there are any issues I need to be concerned about. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David 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!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Ehresmann, David 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). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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).
Inlist Iterator and NULLs
Is the INLIST ITERATOR unable to use the index unless we specify NOT NULL? I wanted to
bounce this off the list before we log a TAR.
We are examining the performance of a query and I am trying to understand why an
INLIST ITERATOR is not used if there is not an explicit IS NOT NULL predicate
condition.
TableA.column1 is nullable, has null values and has a high number of distinct values.
It also has a nonunique index with only column1.
The table and indexes are recently analyzed. The column has a histogram with 2 buckets.
In the query, the predicate for column1 is where column1 in ('value1',
'value2'). Both of the values are literals and actual values do exist in the table.
If we use just this predicate (along with the other join conditions), the execution
plan is a series of hash joins on full table scans (cost of 38756/card of 3). If we
add and column1 is not null, the execution plan is an INLIST ITERATOR with a series
of nested loops using index range or unique scans.
In looking at a 10053 trace file, it becomes clear as to why the query is taking a bad
plan. The cost of a single table access is radically different.
With Not Null (Note the tb_sel values (which seem to be the density * # of values) are
correct in this computation)
SINGLE TABLE ACCESS PATH
TABLE: SERIALS ORIG CDN: 3318658 ROUNDED CDN: 2 CMPTD CDN: 2
Access path: tsc Resc: 7137 Resp: 7137
Access path: index (no sta/stp keys)
Index: SERIALS_MAN_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 19877
IX_SEL: 1.e+00 TB_SEL: 6.0265e-07
Access path: index (scan)
Index: SERIALS_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 5
IX_SEL: 6.0277e-07 TB_SEL: 6.0265e-07
Access path: index (equal)
Index: SERIALS_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 3
IX_SEL: 3.0138e-07 TB_SEL: 3.0133e-07
Access path: index (equal)
Index: SERIALS_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 3
IX_SEL: 3.0138e-07 TB_SEL: 3.0133e-07
BEST_CST: 5.00 PATH: 4 Degree: 1
Without Not Null (Note the tb_sel values are not correct. If I read this correctly,
this is telling the CBO that there is a single value for each of the index columns)
SINGLE TABLE ACCESS PATH
TABLE: SERIALS ORIG CDN: 3318658 ROUNDED CDN: 3318658 CMPTD CDN: 3318658
Access path: tsc Resc: 7137 Resp: 7137
Access path: index (no sta/stp keys)
Index: SERIALS_EQ
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 13265
IX_SEL: 1.e+00 TB_SEL: 1.e+00
Access path: index (no sta/stp keys)
Index: SERIALS_MAN_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 19875
IX_SEL: 1.e+00 TB_SEL: 1.e+00
Access path: index (no sta/stp keys)
Index: SERIALS_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 12155
IX_SEL: 1.e+00 TB_SEL: 1.e+00
Access path: index (no sta/stp keys)
Index: SERIALS_UC
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 7361
IX_SEL: 1.e+00 TB_SEL: 1.e+00
BEST_CST: 7137.00 PATH: 2 Degree: 1
The interesting thing is if I extract the access of this table to a single
(non-joined) statement, it computes the cost and plan like I would expect. It is when
we add in other tables and a join condition that it 'loses' its mind.
Thoughts? Need More Detail?begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
RE: ORA-03115 (TOAD question!!)
7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-03115 (TOAD question!!) I would recommend upgrading to 7.6.x you can download it from www.quest.com From: AK [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-03115 (TOAD question!!) Date: Tue, 29 Jul 2003 07:49:23 -0800 Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- 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).
RE: Please look at this imp command
I'm embarrassed ... Shutdown immediate via SQL*Plus after verifying all users have disconnected. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Tuesday, July 29, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Please look at this imp command I'm starting to gather that -- that the reboot did it. Entertainingly enough I had enough presence of mind to use EM As SYSDBA and open the database using the InitTPOCS.ora. The users have been using the application for the last four hours without any issues, so, what is the graceful way of shutting down the database, via, EM and do a close? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Please look at this imp command Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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).
buffer busy waits and v$filestat
Folks, Say a session issues a read request, and finds another session already reading the block into the buffer cache. If this session waits N ms on a buffer busy waits event, does this N ms of wait get added to the read times in v$filestat? Or is the readtim in v$filestat purely physical I/O? Thanks Raj -- 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).
SQL Loader problem
Hi All, I'm trying to use SQL Loader to load data from a text file into a table. However, I always get error as column SKILL_DESCRIPTION field in data file exceeds maximum length where the column SKILL_DESCRIPTION is declared as varchar2(4000). I know the data is 4000 characters, but 1000 characters. It was inserted successfully when I execute insert statement in TOAD as: insert into skills_tmp values(..); Is there any option in SQL Loader I have to set in order to load a long string? Thanks for all the inputs in advance. Anna _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li 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: buffer busy waits and v$filestat
Buffer busy wait has a different correlation with v$filestat and I/O. Buffer busy wait simply means that the buffer you're waiting for is pinned by somebody else. There are 3 classic situations: 1) DBWR hasn't finished writing to the disk yet. 2) Block is locked by another node (OPS, RAC). 3) RMAN is writing the block. That's right, RMAN locks (pins) blocks in memory, otherwise it couldn't ensure consistent backup. That is the reason why RMAN doesn't need alter tablespace begin backup command. To make the long story short, there is a note on metalink (Note:155971.1) with an appropriate title: Resolving Intense and Random Buffer Busy Wait Performance Problems. Buffer busy waits are usually a consequence of I/O subsystem not being to provide enough throughput to the database. What can you do with v$filestat? You can find where are your hot spots and fix the problem. On 2003.07.29 17:24, [EMAIL PROTECTED] wrote: Folks, Say a session issues a read request, and finds another session already reading the block into the buffer cache. If this session waits N ms on a buffer busy waits event, does this N ms of wait get added to the read times in v$filestat? Or is the readtim in v$filestat purely physical I/O? Thanks Raj -- 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). -- Mladen Gogala Oracle DBA -- 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: clustering
Title: Message We used to experience problems in our RAC environment when there's an interconnect failure. There's a workaround for that problem, that was worked for us - Create a directory under $ORACLE_HOME/rdbms called ".aixopt". Create (touch) a file called SUSTAIN_IPC_FAILURE (uppercase - 0 byte file). We're using 9.2.0.3 2node RAC on AIX 5L / HACMP 4.4 Does Sun or Tru64 have similar workarounds or does it work flawlessly without the workaound. Having this workaround tells RAC to make sure atleast there's one surviving instance in the cluster instead of all instances crashing. Here's the section from alert log filewith an example of handling failures of all 3 interconnects. Marking down Network with IP 192.168.17.11Thu Apr 10 23:29:28 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:28 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:28 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:28 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:29 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:29 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:29 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:30 2003Marking down Network with IP 192.168.18.11Thu Apr 10 23:29:33 2003Marking down Network with IP 192.168.19.11WARNING!!! NO COMMON NETWORKS FOR ALL NODES TO COMMUNICATESUSTAINING IPC FAILURETHIS SHOULD BE THE ONLY INSTANCE RUNNING IN THIS CLUSTER -Original Message-From: Matthew Zito [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 29, 2003 9:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: clustering Hrrrmm - well, we've never seen the problem you describe, and we've got a pretty big RAC environment here (clusters from two to six nodes, and we combine dev clusters to build bigger ones as we need). What the situation you describe sounds like is what happens when there's interconnect failure. Each node thinks independently that its been separated from the rest of the cluster and (effectively) shoots itself in the head. This causes every instance to hang. This is why the crafty RAC Jedi designs well their interconnect architecture. But yes, if you're willing to take the "completely 2n capacity" cluster route and have two databases, double the oracle licenses, two storage arrays, two fibre channel networks, etc., that is the highest availability/reliability cluster you can have - although at the highest cost and complexity. Which clustering solution is right for you? Cheap and inelegant? Expensive and bullet-proof? Well, that's why we get paid the big bucks, right? :) Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tanel PoderSent: Monday, July 28, 2003 7:05 PMTo: Multiple recipients of list ORACLE-LSubject: Re: clustering However, failed transactions must be handled from client side. Queries may migrate to surviving nodes transparently. Also, currently RAC has many problems, such all nodes hanging when one node dies. Completely separate systems are still (an will always be) the most available solution. Tanel. - Original Message - From: Indy Johal To: Multiple recipients of list ORACLE-L Sent: Monday, July 28, 2003 7:49 PM Subject: Re: clustering Another Important different is that RAC is best High Availability solution in case of System/Instance Failure where in case of HP or Veritas Cluster, all of the resource get stopped on live system/node of the cluster and then get started on second node and hence user will be affected. But in case of system or Instance failure, there is seamless transition of the User session in RAC Indy Johal "Ron Rogers" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/28/03 12:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: clusteringak,As I understand it, an HP cluster is 2 boxes that have the capabilityto access the same disks and data but only one can have the oracleinstance running and accessing the datafiles(active). Sort of like ahigh availability option.With RAC both boxes can access the instance and datafiles at the sametime.List, Correct me if I need it.Ron [EMAIL PROTECTED] 07/28/03 12:14PM Hi Guys ,I am new to this clustering concept. Just trying to understand fewbasics . Need ur help .what is differece
Re: SQL Loader problem
Try with external tables. The best thing since sliced bread. On 2003.07.29 17:39, Anna Li wrote: Hi All, I'm trying to use SQL Loader to load data from a text file into a table. However, I always get error as column SKILL_DESCRIPTION field in data file exceeds maximum length where the column SKILL_DESCRIPTION is declared as varchar2(4000). I know the data is 4000 characters, but 1000 characters. It was inserted successfully when I execute insert statement in TOAD as: insert into skills_tmp values(..); Is there any option in SQL Loader I have to set in order to load a long string? Thanks for all the inputs in advance. Anna _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li 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 -- 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).
8.1.7.4 interim patch management strategy
Hello All, There are 188 interim patches after 8.1.7.4 patchset. I know that 8.1.7.4 is the last patchset. 1. What methods/strategy do you'll have for installing patches on a 8.1.7.4 64 bit hp-ux 11.11 database? 2. Is there opatch for 8.1.7.4? AFAIK opatch is only for 9i. 3. Should one install all the applicable patches (around 180 individual patches)? pessimistic (wait for the bug to hit and db to crash) optimistic (install applicable patches) 4. How to manage the interdependencies between these 180 individual patches? 5. Can we create a hp unix patch depot like thing for all these oracle patches? pls dont advise putting an enhancement request and upgrading to 9i/10i :-) Thanks, Mandar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandar A. Ghosalkar 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).
upgrade to 9i
Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i . Thanks, -ak
RE: upgrade to 9i
If its not an then you can simply run catalog.sql and catproc.sql to upgrade oracle dictionary tables. Also during 9I installation Oracle ask to upgrade existing databases on that system. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 29, 2003 3:54 PMTo: Multiple recipients of list ORACLE-LSubject: upgrade to 9i Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i . Thanks, -akDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
Re: SQL Loader problem
Sliced bread or not, the syntax problem will be the same since external tables are modeled on SQL*Loader syntax... :-) Anna, I suspect that there is confusion on the SQL*Loader concepts of external datatypes and internal datatypes, which incidentally is shared by external tables currently. SQL*Loader's internal datatypes match the standard Oracle RDBMS datatypes, but the external datatypes are something else altgoether... I don't have docs available, but specifying an external datatype of VARCHAR or VARCHAR2 probably doesn't mean what you want it to mean. If memory serves, I think it is supposed to be a two-byte binary integer (which is the data length) to be followed by the data itself. Or something like that... Try CHAR(4000), perhaps? The Server Utilities manual from the standard Oracle doc-set on http://otn.oracle.com; has all this stuff in it... Hope this helps... -Tim on 7/29/03 3:19 PM, Mladen Gogala at [EMAIL PROTECTED] wrote: Try with external tables. The best thing since sliced bread. On 2003.07.29 17:39, Anna Li wrote: Hi All, I'm trying to use SQL Loader to load data from a text file into a table. However, I always get error as column SKILL_DESCRIPTION field in data file exceeds maximum length where the column SKILL_DESCRIPTION is declared as varchar2(4000). I know the data is 4000 characters, but 1000 characters. It was inserted successfully when I execute insert statement in TOAD as: insert into skills_tmp values(..); Is there any option in SQL Loader I have to set in order to load a long string? Thanks for all the inputs in advance. Anna _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li 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: Tim Gorman 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: upgrade to 9i
AK, Start with Note:159657.1 on MetaLink. Gudmundur - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Tuesday, July 29, 2003 10:54 PM Subject: upgrade to 9i Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i . Thanks, -ak
Re: buffer busy waits and v$filestat
Hello Raj. BBW with a p3=0 are a consecuence of the I/O subsystem not being able to provide enough throughput to the database, as Mladen has said. But there are also many others causes for BBW. Check p3. Also if the session A is waiting for a buffer in the buffer cache (that's a BBW), the buffer is already in the BC so this session has no need (won't) to do a physical I/O for that block. Another thing I think (I'm sorry to disagree with Mladen on this) is that when DBWR hasn't finished writing a buffer to the disk, and a session wants that buffer in exclusive mode, there's a wait and that wait is computed as a write complete wait and not as BBW. please correct me if I'm wrong. thanks HTH Greetings Diego Cutrone Folks, Say a session issues a read request, and finds another session already reading the block into the buffer cache. If this session waits N ms on a buffer busy waits event, does this N ms of wait get added to the read times in v$filestat? Or is the readtim in v$filestat purely physical I/O? Thanks Raj -- 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). Internet GRATIS es Yahoo! Conexión 4004-1010 desde Buenos Aires. Usuario: yahoo; contraseña: yahoo Más ciudades: http://conexion.yahoo.com.ar -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Diego=20Cutrone?= 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: Inlist Iterator and NULLs
Can you post the sql, or even the 10053 trace up to the GENERAL PLANS
section. That would also answer the question which exact version/release
of Oracle 9?
At 12:59 PM 7/29/2003 -0800, you wrote:
Is the INLIST ITERATOR unable to use the index unless we specify NOT NULL?
I wanted to bounce this off the list before we log a TAR.
We are examining the performance of a query and I am trying to understand
why an INLIST ITERATOR is not used if there is not an explicit IS NOT NULL
predicate condition.
TableA.column1 is nullable, has null values and has a high number of
distinct values. It also has a nonunique index with only column1.
The table and indexes are recently analyzed. The column has a histogram
with 2 buckets.
In the query, the predicate for column1 is where column1 in ('value1',
'value2'). Both of the values are literals and actual values do exist
in the table.
If we use just this predicate (along with the other join conditions), the
execution plan is a series of hash joins on full table scans (cost of
38756/card of 3). If we add and column1 is not null, the execution plan
is an INLIST ITERATOR with a series of nested loops using index range or
unique scans.
In looking at a 10053 trace file, it becomes clear as to why the query is
taking a bad plan. The cost of a single table access is radically different.
With Not Null (Note the tb_sel values (which seem to be the density * # of
values) are correct in this computation)
SINGLE TABLE ACCESS PATH
TABLE: SERIALS ORIG CDN: 3318658 ROUNDED CDN: 2 CMPTD CDN: 2
Access path: tsc Resc: 7137 Resp: 7137
Access path: index (no sta/stp keys)
Index: SERIALS_MAN_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 19877
IX_SEL: 1.e+00 TB_SEL: 6.0265e-07
Access path: index (scan)
Index: SERIALS_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 5
IX_SEL: 6.0277e-07 TB_SEL: 6.0265e-07
Access path: index (equal)
Index: SERIALS_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 3
IX_SEL: 3.0138e-07 TB_SEL: 3.0133e-07
Access path: index (equal)
Index: SERIALS_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 3
IX_SEL: 3.0138e-07 TB_SEL: 3.0133e-07
BEST_CST: 5.00 PATH: 4 Degree: 1
Without Not Null (Note the tb_sel values are not correct. If I read this
correctly, this is telling the CBO that there is a single value for each
of the index columns)
SINGLE TABLE ACCESS PATH
TABLE: SERIALS ORIG CDN: 3318658 ROUNDED CDN: 3318658 CMPTD CDN:
3318658
Access path: tsc Resc: 7137 Resp: 7137
Access path: index (no sta/stp keys)
Index: SERIALS_EQ
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 13265
IX_SEL: 1.e+00 TB_SEL: 1.e+00
Access path: index (no sta/stp keys)
Index: SERIALS_MAN_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 19875
IX_SEL: 1.e+00 TB_SEL: 1.e+00
Access path: index (no sta/stp keys)
Index: SERIALS_SER
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 12155
IX_SEL: 1.e+00 TB_SEL: 1.e+00
Access path: index (no sta/stp keys)
Index: SERIALS_UC
TABLE: SERIALS
RSC_CPU: 0 RSC_IO: 7361
IX_SEL: 1.e+00 TB_SEL: 1.e+00
BEST_CST: 7137.00 PATH: 2 Degree: 1
The interesting thing is if I extract the access of this table to a single
(non-joined) statement, it computes the cost and plan like I would expect.
It is when we add in other tables and a join condition that it 'loses' its
mind.
Thoughts? Need More Detail?
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
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: buffer busy waits and v$filestat
That's On 2003.07.29 19:59, Diego Cutrone wrote: Another thing I think (I'm sorry to disagree with Mladen on this) is that when DBWR hasn't finished writing a buffer to the disk, and a session wants that buffer in exclusive mode, there's a wait and that wait is computed as a write complete wait and not as BBW. DBWR works in 2 phases: a) It scans for dirty buffers and pins them. b) It starts IO, usually using writev. If IO has been launched and not yet finished, then the wait is write complete wait. If IO hasn't been started yet, we have buffer busy. This write complete wait became essential with the advent of asynchronous I/O. I was just simplifying things, nothing else. -- Mladen Gogala Oracle DBA -- 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: Please look at this imp command
don't be... this means you are doing something we strongly advocate on this list... reading the manuals and learning. --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm embarrassed ... Shutdown immediate via SQL*Plus after verifying all users have disconnected. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Tuesday, July 29, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Please look at this imp command I'm starting to gather that -- that the reboot did it. Entertainingly enough I had enough presence of mind to use EM As SYSDBA and open the database using the InitTPOCS.ora. The users have been using the application for the last four hours without any issues, so, what is the graceful way of shutting down the database, via, EM and do a close? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Please look at this imp command Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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: Wolfe Stephen S GS-11 6 MDSS/SGSI 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
RE: upgrade to 9i
Are you missing something in your reply? If its not an then. From migrating 8.1.7 to 9i, one has to follow prescribed procedure. To my knowledge one needs to run u0801070.sql after starting the 8i database in 'migrate' mode...etc.. etc... I have the GUI thing, sorry! - Kirti --- [EMAIL PROTECTED] wrote: If its not an then you can simply run catalog.sql and catproc.sql to upgrade oracle dictionary tables. Also during 9I installation Oracle ask to upgrade existing databases on that system. -Original Message- Sent: Tuesday, July 29, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Hi where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i . Thanks, -ak __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: buffer busy waits and v$filestat
Gogala, quote RMAN is writing the block. That's right, RMAN locks (pins) blocks in memory, otherwise it couldn't ensure consistent backup. That is the reason why RMAN doesn't need alter tablespace begin backup command. /quote I have read that RMAN has the advantage of not generating excessive redo which alter tablespace begin backup does. When RMAN locks a data block while backup and suppose if some data is to be written to the same data block,what happens now ? 1.where will the data be until RMAN releases the lock ? 2.will this be a wait event.if so,how can it be identified ? Sorry,if i sound silly. i am going thro' the RMAN book by Robert Freeman and so curious to know ?! Regards, Jp. 30-07-2003 06:49:23, Mladen Gogala [EMAIL PROTECTED] wrote: Buffer busy wait has a different correlation with v$filestat and I/O. Buffer busy wait simply means that the buffer you're waiting for is pinned by somebody else. There are 3 classic situations: 1) DBWR hasn't finished writing to the disk yet. 2) Block is locked by another node (OPS, RAC). 3) RMAN is writing the block. That's right, RMAN locks (pins) blocks in memory, otherwise it couldn't ensure consistent backup. That is the reason why RMAN doesn't need alter tablespace begin backup command. To make the long story short, there is a note on metalink (Note:155971.1) with an appropriate title: Resolving Intense and Random Buffer Busy Wait Performance Problems. Buffer busy waits are usually a consequence of I/O subsystem not being to provide enough throughput to the database. What can you do with v$filestat? You can find where are your hot spots and fix the problem. -- 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: buffer busy waits and v$filestat
On 2003.07.29 21:36, Prem Khanna J wrote: Gogala, quote RMAN is writing the block. That's right, RMAN locks (pins) blocks in memory, otherwise it couldn't ensure consistent backup. That is the reason why RMAN doesn't need alter tablespace begin backup command. /quote I have read that RMAN has the advantage of not generating excessive redo which alter tablespace begin backup does. When RMAN locks a data block while backup and suppose if some data is to be written to the same data block,what happens now ? The answer is very simple: write will wait until block is released (un-pinned). Locks, latches and pins exist to prevent data corruption from the simultaneous access. Those mechanisms are, essentially, serializing the access to the critical resources. There is a very nice book, an oldie but goodie, that I read once upon a time, called Modern Operating Systems, written by Andrew Tannenbaum. 1.where will the data be until RMAN releases the lock ? 2.will this be a wait event.if so,how can it be identified ? Data will wait in user buffers. Yes, it will be a wait event, and same with the DBWR, when the buffer is pinned, it will be a buffer busy, and when I/O is in progress, it will be write complete. Sorry,if i sound silly. i am going thro' the RMAN book by Robert Freeman and so curious to know ?! Bob Freeman's book is an excellent book which helped me understand and write a few RMAN scripts. It is neither intended nor very good at thorough explanation of oracle kernel. For that, there is Steve Adams and his book. I'd also like to abuse this occasion and ask Steve whether he plans a revised V9 (or 10x) edition? Regards, Jp. 30-07-2003 06:49:23, Mladen Gogala [EMAIL PROTECTED] wrote: Buffer busy wait has a different correlation with v$filestat and I/O. Buffer busy wait simply means that the buffer you're waiting for is pinned by somebody else. There are 3 classic situations: 1) DBWR hasn't finished writing to the disk yet. 2) Block is locked by another node (OPS, RAC). 3) RMAN is writing the block. That's right, RMAN locks (pins) blocks in memory, otherwise it couldn't ensure consistent backup. That is the reason why RMAN doesn't need alter tablespace begin backup command. To make the long story short, there is a note on metalink (Note:155971.1) with an appropriate title: Resolving Intense and Random Buffer Busy Wait Performance Problems. Buffer busy waits are usually a consequence of I/O subsystem not being to provide enough throughput to the database. What can you do with v$filestat? You can find where are your hot spots and fix the problem. -- Mladen Gogala Oracle DBA -- 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: buffer busy waits and v$filestat
Thanks a lot for your explanation Gogala. Eagerly waiting for Steve's revised edition of Oracle Internals. Regards, Jp. -- 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: Index Usage ?!
Once again thanx a lot Tanel for spending your precious time to make me understand. Regards, Jp. 28-07-2003 22:59:25, Tanel Poder [EMAIL PROTECTED] wrote: The point is, that index access is cheap in reality, but CBO thinks it's very expensive and chooses next best executin plan in it's opinion, but this opinion is actually wrong, because unset optimizer_ parameters for example. One more thing, your test query returned no rows, it could be that with index access Oracle didn't even have to visit any table blocks because no relevant keys found in index. But when you'll have keys matching your query conditions in future, index access might get slower as well (here's where clustering_factor comes into play). Without analyzing, the index cost in reality is still low, and with super-optimistic default statistics CBO luckily picks that path. No, according plan in your orignal post, index range scan was used. Btw, I submitted a simple research about CBO table/index access costs to comp.databases.oracle.server yesterday under subject 2 Oracel doubts, you might want to read that one as well to get more understanding on your issue. Tanel. -- 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: Problem with Autotrace - Is this a BUG ?
The user is able to query the v_$ views and statistics are (Bexplained properly. (B (Blet me enable "Event 10046" and see what happens. (B (BThanx Tanel. (B (BRegards, (BJp. (B (B28-07-2003 22:34:30, "Tanel Poder" [EMAIL PROTECTED] wrote: (BHi (BHm, but try to query sys.v_$session sys.v_$sesstat and sys.v_$statname views (Bunder cti user. (BIf it works, then enable event 10046 at level 4 before you set autotrace on (Band check trace file (maybe there are some parse errors for example) (BIt could be a bug, or just change in behaviour when enabling tracing. Did (Byou actually try, that in 9.2.0.3 tracing works as expected?! Maybe in newer (Bversion just no warning is shown... (BTanel. (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
