Re: Risk of knowing password hash value (Was: OEM permissions)
8.1.7 on win2000 SQL select password 2 from dba_users 3 where username = 'SCOTT'; PASSWORD -- F894844C34402B67 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 11:44 AM Hi, Okay. I'm almost a believer of this as a problem. How about 9.2.0.4 on RH9.3. 1) What does anyone/everyone get for my this query (my results shown): connect system/[EMAIL PROTECTED]; alter user scott identified by tiger; -- select password from dba_users where username = 'SCOTT'; PASSWORD F894844C34402B67 2) If you all get the same, then I'm concerned. Regards, Mike Thomas --- Yong Huang [EMAIL PROTECTED] wrote: Jared, I see you log out and log back in as SYSTEM to DB2. But how do you know the password for SYSTEM to log back in with after you change it? What if you don't log out? When I tried that (i.e. not logging out), I got ORA-1017. Yong Huang --- Jared Still [EMAIL PROTECTED] wrote: Environment: DB1: RH 8.0 with Oracle EE 9.2.0.4 DB2: Win2k SP3 with Oracle EE 9.2.0.1 SYSTEM user on each database initially have different passwords. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: background process LGWR did not start
alert/trace files ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 9:34 PM Anyone know what might be causing this error? Oracle 8.1.7 on Solaris. background process LGWR did not start -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: ** can two processes use the same rollback extent
i can answer the first part of your question.. YES, two transactions can write on the same extent of an RBS, i think the restriction is at the block level, this was true until 8i, might have changed in 9 + - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 03, 2003 9:09 AM Subject: ** can two processes use the same rollback extent Hi, One rollback segment can be used by multiple transactions/processes but what about the extents? Is it safe to assume that only one transaction/process can use one extent? What is a good way to size the extent for warehousing tasks? Or guess the rollback generated and size needed. Thank You Do you Yahoo!?Protect your identity with Yahoo! Mail AddressGuard
apologies for the repeated mails
List, my apologies for the post appearing multiple times... seems like a 'reload page post/send again' related problem to our web-mail program will be careful with the relaod button in the future.. -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: bug info, not displayed!!
Brad, we are running advance security, and we authenticate user from an external RSA/ACE server using secureID's tokens. we can connect from sql*plus.. but the web forms returns error.. which we were hoping to solve by patching the forms 6i -rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 14, 2003 2:39 AM Correct me if I am wrong but if you use some type of secure authentication method I believe you have to have Oracle Advanced Security option installed... If you are expecting to simply flip from switches in sqlnet.ora and have secure external authentication you might be in for more surprises than what any marketing hype may have told you. The last time I looked into external authentication it got ugly very quickly. -Original Message- Sent: Wednesday, November 12, 2003 8:30 AM To: Multiple recipients of list ORACLE-L the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com
bug info, not displayed!!
List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
using JDBC-OCI from JSP, authenticating using RSA
Dear all, a few days ago i posted a query regarding the JDBC-THIN driver using RSA authentication, a the RSA uses sql*net paramters, and the jdbc-thin would directly connect to the db using listener, it was not possible to use RSA. now we plan to change the setup to use JDBC-OCI driver to connect to oracle, as i understand JSP pages will be executing on the app server, which in turn would connect to the db server. as we will not be using an applet , no dirvers wil be downloaded to the client, all connectivity will be from the middle tier where the JSP pages are executed. Am i correct in assuming the above ? if anyone on this list has experience using jdbc-oci, please help me on this -rahul The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
connection using secureID tokens and JDBC thin
dear list, The setup: app server 9ias 1.0.2.2.2a db server 9i R2. The application Our app connects to the DB using JDBC thin, a simple app showing fields and inserting data into underlying tables. The problem All was working fine, then the management asked us to use RSA/ACE security using Token cards, we have implemented everything and all works fine, we CAN connect from the IAS to the DB using sql*plus and providing the passcode, BUT out application (using JDBC thin)is not able to connect !!! "invalid username or password"!!! we have another back office app connecting to the DB using web forms 6i, which also has the same problem after we setup secureID. again, we have no prolems connecting from SQL*PLUS using secureID passcodes please advise -rahul The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775.-
use of TEMP tables to re-query HTML form fields
list, this might not be the appropriate forum for this question, but it's friday night and i have to come up with some solution... we have developed an application using java script to display a form, which the users will fill in , this form is submitted using JDBC THIS to oracle database (using 9iAS). we have back and forward buttons on this form, the form appears in 3 pages !! the problem: after the user fills in the first page, he/she will click next and the 2nd page would load, there a button back on the second page to go back to the 1st page, NOW if the user has filled in values in the second page and he navigates to the 1st page, and again goes forward by clicking next button the form, the 2nd page apprears blank !! all the earlier filled in values are lost !! , ok , this is the expected default behaviour , how can we make the values re-apprear on the second page ?? the solution: use of TEMP tables, we use temp table to hold the values, each tikme the user clicks next page we save the values to the temp table, and re-query to fill in the fields if the user comes back to the same page .. is my approach correct ??? is there another easier way to do this?? TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
db security, managed from application forms
List, after reading so much about managing the srcurity from the db users, roles and privileges, i have finally decided to do the same. I have figured out most of the things... 1. i have made a form interface to create role and grant privileges to roles. all the data goes to app tables, and then DB roles are created and grants given which matches the data entered. I have a routine which syncs the role/privs in the app tables to the db roles and privs. 2. another form provides interface to create users and grant roles to users. 3. then i have a MMB menu attached to a form which is executed. the user will login, and will be displayed a menu based on the role given to the user. this is where i'm not sure how would i handle it, something like... on-new-form-instance i would check the role name from the session_roles, and would have a table which would tell me which menu option has to be enabled with this role. am i going the right way ?? the forms will be run on the web, so i guess i cannot store them in the db, and cant use the menu roles facility. i have done a lot of work on this.. but cant figure out the role and form module to run...i dont want to go back to one app user accessing the db, and application managed seurity would appreciate any help. TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
column level privilege - resolved
Arun, thanks for suggesting this, this is what i did.
1. created a table to store table names associated column names
and a security level for a that column
EMP emp_name 3
EMP emp_sal 5
2. then i granted every users a security level also,
3. then i created a view on the name table
select decode(sec_func('EMP','EMP_NAME'),1,emp_name,'x' emp_name),
decode(sec_func('EMP','EMP_SAL'),1,emp_sal,0 emp_sal)
the sec_func is passed table name and the column name and it checks the
security_level of that column againet the security level of the user
quering the table. if the security level is equal or lower, then 1 is
returned, else 0 is returned, and the decode in the view will do the rest
this way i can show/hide columns based on the security level (or roles
granted to users) ...
ok, i have only tested it, not implemented it, will it work in a real
application environment ? has anyone used this type of column privs ?
-TIA
=
On Sun, 24 Aug 2003 16:24:36 -0800, Arup Nanda [EMAIL PROTECTED]
wrote :
This is a multi-part message in MIME format.
Rahul,
I'm not sure if this is too late; but here is a strategy you could follow
to achieve what you want. True, VPD does not have a mechanism to suppress
columns; and using a view for each user is impractical. Someday, I hope,
VPD will have that capability; but until then you could try the following.
Suppose you have a table called SAVINGS, for savings account holders as
follows:
ACCTNO NUMBER
CLEARED_BALANCENUMBER
UNCLEARED_BALANCE NUMBER
The records in the table are as follows:
ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
-- --- -
11000 1100
21100 1200
31300 1500
Cleared balance is the amount the the customer can draw from the bank. If
there are checks outstanding, the balance is shown in uncleared. Let's
start with a simple example - you have users who are allowed to see the
uncleared balance of the customers and the others are not. Intead of hiding
the column completely, which how VPD operates, you would want to show then
as zero, if not authorized to see that; otherwise the actual value is shown.
You would create a context as follows:
create context sec_ctx using sec_ctx_pkg;
The trusted function can be created as:
create procedure sec_ctx_pkg
(
p_attribute_name in varchar2,
p_attribute_value in varchar2
) is
begin
dbms_session.set_context(
'sec_ctx',
p_attribute_name,
p_attribute_value);
end;
/
In the after-login trigger, you would set the context value automatically
for user using
set_Ctx_pkg ('cleared', 'yes'); or set_Ctx_pkg ('cleared', 'no');
depending on whether the user is cleared to see the balance or not. In real
life, you may have a table that lists all users and whether or not they are
cleared. The after-logon trigger could read that table and set the context
attribute properly.
Next, you would craete a view.
create or replace view vw_savings
as
select acctno, cleared_balance,
decode(sys_context('sec_ctx','cleared'),'yes',
uncleared_balance, 0) uncleared_balance
from savings
/
Note: there is only ONE view, not one per user. Regardless of how many
users you have, there will be only one view.
Now to test the setup. Assume user RAHUL is allowed to see the
uncleared_balance. The after-logon trigger will set the context
attribute cleared to yes when the user logs in. When the user selects:
select * from vw_savings;
He sees:
ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
- --- -
11000 1100
21100 1200
31300 1500
Which is the correct value. Now, user ARUP logs in, who does not have the
authority to see the uncleared balance. The logon trigger will set the
attribute to no and the same select will now produce:
ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
-- --- -
11000 0
21100 0
31300 0
Note: How the uncleared balance is 0.
This model can be extended to any column and any number of values for the
attribute cleared. You could even specify levels of users who are allowed
to see the balances under certain amount; not above that. In case of
character values; it's even simpler; just mask it by some value such
as , or NOT CLEARED TO SEE.
All the users are granted select privileges on the view, not the table.
The context setting procedure is owned by a secured user; SYS would do, but
you should have a separate username, say, SECUSER
column level privilege - resolved
Arun, thanks for suggesting this, this is what i did.
1. created a table to store table names associated column names
and a security level for a that column
EMP emp_name 3
EMP emp_sal 5
2. then i granted every users a security level also,
3. then i created a view on the name table
select decode(sec_func('EMP','EMP_NAME'),1,emp_name,'x' emp_name),
decode(sec_func('EMP','EMP_SAL'),1,emp_sal,0 emp_sal)
the sec_func is passed table name and the column name and it checks the
security_level of that column againet the security level of the user
quering the table. if the security level is equal or lower, then 1 is
returned, else 0 is returned, and the decode in the view will do the rest
this way i can show/hide columns based on the security level (or roles
granted to users) ...
ok, i have only tested it, not implemented it, will it work in a real
application environment ? has anyone used this type of column privs ?
-TIA
=
On Sun, 24 Aug 2003 16:24:36 -0800, Arup Nanda [EMAIL PROTECTED]
wrote :
This is a multi-part message in MIME format.
Rahul,
I'm not sure if this is too late; but here is a strategy you could follow
to achieve what you want. True, VPD does not have a mechanism to suppress
columns; and using a view for each user is impractical. Someday, I hope,
VPD will have that capability; but until then you could try the following.
Suppose you have a table called SAVINGS, for savings account holders as
follows:
ACCTNO NUMBER
CLEARED_BALANCENUMBER
UNCLEARED_BALANCE NUMBER
The records in the table are as follows:
ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
-- --- -
11000 1100
21100 1200
31300 1500
Cleared balance is the amount the the customer can draw from the bank. If
there are checks outstanding, the balance is shown in uncleared. Let's
start with a simple example - you have users who are allowed to see the
uncleared balance of the customers and the others are not. Intead of hiding
the column completely, which how VPD operates, you would want to show then
as zero, if not authorized to see that; otherwise the actual value is shown.
You would create a context as follows:
create context sec_ctx using sec_ctx_pkg;
The trusted function can be created as:
create procedure sec_ctx_pkg
(
p_attribute_name in varchar2,
p_attribute_value in varchar2
) is
begin
dbms_session.set_context(
'sec_ctx',
p_attribute_name,
p_attribute_value);
end;
/
In the after-login trigger, you would set the context value automatically
for user using
set_Ctx_pkg ('cleared', 'yes'); or set_Ctx_pkg ('cleared', 'no');
depending on whether the user is cleared to see the balance or not. In real
life, you may have a table that lists all users and whether or not they are
cleared. The after-logon trigger could read that table and set the context
attribute properly.
Next, you would craete a view.
create or replace view vw_savings
as
select acctno, cleared_balance,
decode(sys_context('sec_ctx','cleared'),'yes',
uncleared_balance, 0) uncleared_balance
from savings
/
Note: there is only ONE view, not one per user. Regardless of how many
users you have, there will be only one view.
Now to test the setup. Assume user RAHUL is allowed to see the
uncleared_balance. The after-logon trigger will set the context
attribute cleared to yes when the user logs in. When the user selects:
select * from vw_savings;
He sees:
ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
- --- -
11000 1100
21100 1200
31300 1500
Which is the correct value. Now, user ARUP logs in, who does not have the
authority to see the uncleared balance. The logon trigger will set the
attribute to no and the same select will now produce:
ACCTNO CLEARED_BALANCE UNCLEARED_BALANCE
-- --- -
11000 0
21100 0
31300 0
Note: How the uncleared balance is 0.
This model can be extended to any column and any number of values for the
attribute cleared. You could even specify levels of users who are allowed
to see the balances under certain amount; not above that. In case of
character values; it's even simpler; just mask it by some value such
as , or NOT CLEARED TO SEE.
All the users are granted select privileges on the view, not the table.
The context setting procedure is owned by a secured user; SYS would do, but
you should have a separate username, say, SECUSER
RE: 9iR2, grant select on a column (without using views) using RL
how would i write a policy which retuns selected columns if the user has issued select * from tab ??? using views for each user would work, but then.. i would end up with so many views in the main schema !!! ;-( On Sat, 23 Aug 2003 12:24:39 -0800, Jamadagni, Rajendra [EMAIL PROTECTED] wrote : This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Use RLS ... Raj -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Saturday, August 23, 2003 2:34 AM To: Multiple recipients of list ORACLE-L list, i'm ikn the process of designing security for a highly sensitive schema for a bank, plan: have multiple oracle users, and use roles, and grant minimum required privs, all the user/role/privs management coded in the application (with in turn would create the db role and user etc) probolem: i cannot do a grant select(col1)on tabname to role1, as select grant on a column level is not supported, to workaround this i must 1) use views and include all the columns granted seleted privs for a user, then give grant select on this view to user. 2) somehow use RLS ?? TIA -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: 9iR2, grant select on a column (without using views) using RL
how would i write a policy which retuns selected columns if the user has issued select * from tab ??? using views for each user would work, but then.. i would end up with so many views in the main schema !!! ;-( On Sat, 23 Aug 2003 12:24:39 -0800, Jamadagni, Rajendra [EMAIL PROTECTED] wrote : This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Use RLS ... Raj -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Saturday, August 23, 2003 2:34 AM To: Multiple recipients of list ORACLE-L list, i'm ikn the process of designing security for a highly sensitive schema for a bank, plan: have multiple oracle users, and use roles, and grant minimum required privs, all the user/role/privs management coded in the application (with in turn would create the db role and user etc) probolem: i cannot do a grant select(col1)on tabname to role1, as select grant on a column level is not supported, to workaround this i must 1) use views and include all the columns granted seleted privs for a user, then give grant select on this view to user. 2) somehow use RLS ?? TIA -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
9iR2, grant select on a column (without using views) using RLS
list, i'm ikn the process of designing security for a highly sensitive schema for a bank, plan: have multiple oracle users, and use roles, and grant minimum required privs, all the user/role/privs management coded in the application (with in turn would create the db role and user etc) probolem: i cannot do a grant select(col1)on tabname to role1, as select grant on a column level is not supported, to workaround this i must 1) use views and include all the columns granted seleted privs for a user, then give grant select on this view to user. 2) somehow use RLS ?? TIA -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
indexing PDF's using intermedia (8.1.7), not happening
List,
I have installed intermedia, and been using it for
the last couple of weeks without nay problems,
recently, after uploading a PDF documents in the
blob column, i found out that the contents of PDF's are
not being indexed !!! i have tried sync the index
also.. all the other formats (word,ppt' etc) are indexed
automatically (m running the ctxsrv)
the ctxsys.ctx_index_errors tables show the
following error when i try to index...
DRG-11101: failed to open file
C:\WINNT\TEMP\drgut27
i have searched metalink, and it says to create a
new filter.. i did that too..
SQL exec
ctx_ddl.create_preference('myfilter', 'USER_FILTER');
SQL exec
ctx_ddl.set_attribute('myfilter', 'command', 'auto_filt.bat');
SQL create index idx_documents on
documents(blob_content)INDEXTYPE is ctxsys.contextparameters
('filter myfilter section group ctxsys.html_section_group');
but still the PDF's do not appear in index !!!, all
metalink docs point to ORA_HOME/ctx/bin directory !!
but i could not locate the directory on my NT
server !!! very wierd indeed...
again.. the indexing works for all other formats...
other than PDF's
TIA
Rahul
The
information contained in this email and its attachments if any may contain
privileged and confidential information intended only for the attention of
the recipient(s) specified. If you are not a recipient , any forwarding ,
disclosure , photocopying , distribution or use of the information in any
way is prohibited . If you have received this email in error , please email
us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522
8775.-
Re: a simple xml output using stylsheet
thanks Charu, i have used this example
successfully... but nowhere it's tell me how to use/attach astylesheet
to format my XML output !!!
- Original Message -
From:
Charu
Joshi
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 28, 2003 1:29 PM
Subject: RE: a simple xml output using
stylsheet
Hi
Rahul,
Have
a look at http://otn.oracle.com/tech/xmland
also 'Oracle Application Developers Guide - XML'. There is a utility called
XSQL which does this for you. Here's an example of that utility cut from the
above mentioned guide (for 8i):
declare
queryCtx DBMS_XMLquery.ctxType;
result CLOB;
begin
-- set up the query context...!
queryCtx :=
DBMS_XMLQuery.newContext('select * from emp');
-- get the result..!
result :=
DBMS_XMLQuery.getXML(queryCtx);
-- Now you can use the result to put
it in tables/send as messages..
printClobOut(result);
DBMS_XMLQuery.closeContext(queryCtx);
-- you must close the query handle..
end;
/
The printClobOut procedure is :
/CREATE OR REPLACE
PROCEDURE printClobOut(result IN OUT NOCOPY CLOB) is
xmlstr varchar2(32767);
line varchar2(2000);
begin
xmlstr := dbms_lob.SUBSTR(result,32767);
loop
exit when xmlstr is null;
line := substr(xmlstr,1,instr(xmlstr,chr(10))-1);
dbms_output.put_line('| '||line);
xmlstr := substr(xmlstr,instr(xmlstr,chr(10))+1);
end loop;
end;
/
Hope that helps,
Regards,
Charu.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of rahul
sharmaSent: Monday, July 28, 2003 10:51 AMTo: Multiple
recipients of list ORACLE-LSubject: a simple xml output using
stylsheet
dear list, can anyone please point me to a
simple example of select * from emp; query
and the output displayed in xml (using a simple
stylesheet) ...
we have not beenable to locatethis
on the net...
TIA
-Rahul
The
information contained in this email and its attachments if any may contain
privileged and confidential information intended only for the attention
of the recipient(s) specified. If you are not a recipient , any forwarding ,
disclosure , photocopying , distribution or use of the information in
any way is prohibited . If you have received this email in error ,
please email us immediately on [EMAIL PROTECTED] or
contact us on (62 21) 522
8775.-
a simple xml output using stylsheet
dear list, can anyone please point me to a simple example of select * from emp; query and the output displayed in xml (using a simple stylesheet) ... we have not beenable to locatethis on the net... TIA -Rahul The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775.-
RE: imp table data, but not PK indexes?
as PK comes under 'constraints' you might also have to do constraints=N also... On Sat, 19 Jul 2003 07:04:23 -0800, Ganesh Raja [EMAIL PROTECTED] wrote : Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Guang Mei Sent: Saturday, July 19, 2003 10:14 PM To: Multiple recipients of list ORACLE-L Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace indexes (because I can create PK indexes later from a script), So I have this running before imp data: alter user ABC quota 0 on indexes; alter user ABC quota unlimited on ABC_DEFAULT_TS; I found that this way the PK indexes are imported in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: imp table data, but not PK indexes?
as PK comes under 'constraints' you might also have to do constraints=N also... On Sat, 19 Jul 2003 07:04:23 -0800, Ganesh Raja [EMAIL PROTECTED] wrote : Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Guang Mei Sent: Saturday, July 19, 2003 10:14 PM To: Multiple recipients of list ORACLE-L Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace indexes (because I can create PK indexes later from a script), So I have this running before imp data: alter user ABC quota 0 on indexes; alter user ABC quota unlimited on ABC_DEFAULT_TS; I found that this way the PK indexes are imported in ABC_DEFAULT_TS, together with table data. So my question is what I can/should do so that I can imp only table data into ABC_DEFAULT_TS, and not imp PK indexes at the same time? Thanks. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
weird behavior of utl_file_dir
list, i created a new instance of 8.1.7 on Hp-UX and because some of the front end programs use utl package to write the log files to the server, i did this. UTL_FILE_DIR = /u1/app/oracle/admin/BIS/utl_dir/ note the slash in the end in the front end programs.. we are also using directory name with the slash in the end... until yesterday ALL our programs were working fine !! and sure enough we got the files created in the aboe directory.!!! but suddenly today, all the programs are returing invalid operation from utl_file package !!! according to oracle we should remove the slash.. (which i'm going to do today) .. but i;m curious why everything worked without any errors until now !!! -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
(solved?) cannot disable or drop the ON DATABASE trigger !
ok... now i'm praying... cos after i had sent this mail to the list askling for suggestions.. my junior DBA deleted the trigger from trigger$ ! things are ok now he says... and this _is_ a production schema.. ! we are _not_ encountring any errors now, but i did shutdown/startup and took a new base backup and i will continue to pray for some time to come... ;-(( -rahul PS: this startup migrate is news to me.. i should have looked some more in the manuals... big thanks.. On Sat, 05 Jul 2003 10:24:24 -0800, Jared Still [EMAIL PROTECTED] wrote : D'oh! Shoulda thought of that. It's standard procedures on upgrades. Thanks Mladen. On Friday 04 July 2003 11:29, Mladen Gogala wrote: Parameter to disable database triggers is: _system_trig_enabled = FALSE This is 9i parameter. Alternatively, if you start the database up in the migrate mode, system triggers will be disable (startup migrate is what you need) On 2003.07.04 10:54, Jamadagni, Rajendra wrote: This will teach you that you should be _very_ careful when dealing with sys schema. what's that parameter to disable sys triggers ?? 1. Call OWS 2. If this is production DB, keep your resume ready. Raj -Original Message- Sent: Thursday, July 03, 2003 1:39 PM To: Multiple recipients of list ORACLE-L At first glance it appears that you have created a self referencing trigger. You can't drop it, because dropping it fires the trigger. Check metalink, open a TAR, etc. Jared rahul sharma [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 03:40 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:cannot disable or drop the ON DATABASE trigger Help list... i have created the following in 8.1.5 instance CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE CREATE OR ALTER OR DROP ON DATABASE BEGIN null; END; / and now i cannot drop or disable this trigger ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER i'm loggin into svrmgrl and connecting as internal to try drop or disable.. is this a bug ?? TIA Rahul.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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). This e-mail message is confidential, intended only for the named recipient (s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e- mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
(solved?) cannot disable or drop the ON DATABASE trigger !
ok... now i'm praying... cos after i had sent this mail to the list askling for suggestions.. my junior DBA deleted the trigger from trigger$ ! things are ok now he says... and this _is_ a production schema.. ! we are _not_ encountring any errors now, but i did shutdown/startup and took a new base backup and i will continue to pray for some time to come... ;-(( -rahul PS: this startup migrate is news to me.. i should have looked some more in the manuals... big thanks.. On Sat, 05 Jul 2003 10:24:24 -0800, Jared Still [EMAIL PROTECTED] wrote : D'oh! Shoulda thought of that. It's standard procedures on upgrades. Thanks Mladen. On Friday 04 July 2003 11:29, Mladen Gogala wrote: Parameter to disable database triggers is: _system_trig_enabled = FALSE This is 9i parameter. Alternatively, if you start the database up in the migrate mode, system triggers will be disable (startup migrate is what you need) On 2003.07.04 10:54, Jamadagni, Rajendra wrote: This will teach you that you should be _very_ careful when dealing with sys schema. what's that parameter to disable sys triggers ?? 1. Call OWS 2. If this is production DB, keep your resume ready. Raj -Original Message- Sent: Thursday, July 03, 2003 1:39 PM To: Multiple recipients of list ORACLE-L At first glance it appears that you have created a self referencing trigger. You can't drop it, because dropping it fires the trigger. Check metalink, open a TAR, etc. Jared rahul sharma [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 03:40 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:cannot disable or drop the ON DATABASE trigger Help list... i have created the following in 8.1.5 instance CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE CREATE OR ALTER OR DROP ON DATABASE BEGIN null; END; / and now i cannot drop or disable this trigger ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER i'm loggin into svrmgrl and connecting as internal to try drop or disable.. is this a bug ?? TIA Rahul.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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). This e-mail message is confidential, intended only for the named recipient (s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e- mail message from your computer, Thank you. *2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
cannot disable or drop the ON DATABASE trigger !!!!
Help list... i have created the following in 8.1.5 instance CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE CREATE OR ALTER OR DROP ON DATABASE BEGIN null; END; / and now i cannot drop or disable this trigger ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER i'm loggin into svrmgrl and connecting as internal to try drop or disable.. is this a bug ?? TIA Rahul.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
version control for pl/sql dev forms etc.
List, we are looking for a version control software for our application code. All the code is developed using dev6i, pl/sql. is there a product focused towards oracle tools ? we are looking for something which can compare two forms or reports!! and provide basic check-in-out facility TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
uploade using pl/sql gateway, ias
applogies for posting this in the DBA forum...
list, i'm uploading files from my client browser to the database using the
pl/sql gateway (mod pl/sql)
on ias. Everything is working, but i cannot find the procedure which
actually uploads the file!!! the upload
procedure is simply.. a procedure that dosnt do anything, it's jsut called
!!
PROCEDURE upload_doc(name IN owa.vc_arr) IS
BEGIN
htp.p('uploaded');
END;
now i hv made the name of the documents as a PK in the document table.. and
when uploading the same document again,
i want to display an eror... but where to put that pl/sql code to display
the error i hv tried writing the expection
in the above procedure.. but seems like this procedure is called AFTER the
file is magically uploaded in the DB !!
TIA
-rahul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: rahul sharma
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://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).
startup hangs, 8.1.7 on win2000 Pentium 4
list, this started occuring since 2 days ago..when we try to startup the instance using svrmgrl, after listing the SGA, the machine will just lock !!! no cursor , no keys.. just total lock.. the alert log show alter database mount as the last entry.. i have searched metalink on this.. but cannot find anything related to hanging issue on windows.. has someone else encountered this ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
standby on SAN ? or use internal storage
list, i'm a bit confused on whether to put the standby DB on the SAN storage or use the internal storage of the standby host !!! config a two instances on primary server, data-files on SAN, hot standby db files on SAN too. standby instances for both primary on another machine config b both primary on SAN, standby db files on the itnernal storage of standby machine any thoughts ? TIA Rahul
2 servers 2 DB with SAN, here's my config
list, once our client decides to buy SAN, here's what i'm going to propose for high availbility we have 2 servers HP-UX and two databases, storage is internal, once SAN is in place, i propose to put both the DB's on the same server (one of the DB isnot busy,less than 10 concurrent users) and place all the dbfiles on the SAN storage, and use the remaining server to be used as a hot backup instance for both the primaries running on the other server. the hot backup datafiles archive logs will be on the SAN too. my questions: 1) should i keep one DB per machine and backup of DB1 is on server 2 and backup of DB2 is on server1? 2) should the hot standby dbfiles/archivelogs be on the SAN ? or the internal drives of the backuo machine ? the SAN can also go down !! regards
why SAN ? why not external storage ?
list, one of our clietns are going to by SAN, the current oracle databases take around 36GB of storage i dnt understand there reason to go for SAN, i sugguested to buy an external storage box instead. How can i justify my desicion ? (cost of not the factor) TIA rahul
Re: why SAN ? why not external storage ?
my reasons to recommend an external storage was.. 1) the database size is 36GB, and according to many documents i have read, SAN is not cost effevtive unless populated by a large numbers of drives !!, now for the client the cost is not the factor.. given the situation.. wouldnt a SAN be an overkill ? 2) NO DBA or SYS ADMIN skills to manage the SAN !! - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 8:33 PM Subject: Re: why SAN ? why not external storage ? Can youshare some ofthereasons related to your decision in choosing a direct-attach storage(DAS) instead of a SAN? In general, a SAN is a much smarter choice than DAS. - Original Message - From: Rahul To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 1:33 AM Subject: why SAN ? why not external storage ? list, one of our clietns are going to by SAN, the current oracle databases take around 36GB of storage i dnt understand there reason to go for SAN, i sugguested to buy an external storage box instead. How can i justify my desicion ? (cost of not the factor) TIA rahul
how to find the version ?
list, my appologies for asking question regarding ias (solaris), but i could not find any info regarding this on the net.. i'm on solaris, running ias, i'm new to this environment, and have been asked to audit the setup !! to start, i simply want to find out the version of forms/reports server !!.. could anyone point out the method ? thanks and regards -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to find the version ?
i found the solution shortly after i sent the mail.. runinstaller and it will show all the installed product with verions ;-)) On Tue, 11 Feb 2003 00:33:36 -0800, rahul [EMAIL PROTECTED] wrote : list, my appologies for asking question regarding ias (solaris), but i could not find any info regarding this on the net.. i'm on solaris, running ias, i'm new to this environment, and have been asked to audit the setup !! to start, i simply want to find out the version of forms/reports server !!.. could anyone point out the method ? thanks and regards -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to find the version ?
i found the solution shortly after i sent the mail.. runinstaller and it will show all the installed product with verions ;-)) On Tue, 11 Feb 2003 00:33:36 -0800, rahul [EMAIL PROTECTED] wrote : list, my appologies for asking question regarding ias (solaris), but i could not find any info regarding this on the net.. i'm on solaris, running ias, i'm new to this environment, and have been asked to audit the setup !! to start, i simply want to find out the version of forms/reports server !!.. could anyone point out the method ? thanks and regards -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: Faking an ORA-600
this is sooo cool... i mean these tiny small things.. wich are hidden in oralce supplied packages...!! thanks Jared... -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, December 20, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: Faking an ORA-600 If you are monitoring the alert.log, try dbms_system.ksdwrt http://www.oracledba.co.uk/tips/plsql_alert_log.htm Jared Ball, Terry [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 12:51 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Faking an ORA-600 We are trying to test out monitoring software (on a test database at 8.1.6.3). We have been able to generate most of the errors that we want to monitor for, but have been unable to generate an ORA-600. Does anyone have a way of doing this? TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how many records will be keep in v$log_history?
while creating the instance, parameter MAXLOGHISTORY specifies this... my guess is that you have to recreate the controlfiles -- From: Jim[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:38 PM To: Multiple recipients of list ORACLE-L Subject: how many records will be keep in v$log_history? how to modify the default vaule for v$log_history? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
cant set multiblock read count 8 !!!
list !! my ora7.3.2 instance on AIX with a db_block_size of 4k has a multi block read count of 16 !! i thought i would create a new instance with a block size of 8k, so i can set the max multiblock read count to more than 16, BUT, after creating the new instance the db_multiblock_read_count *always* defaults to 8 !! here the new instance params db_files = 16 db_file_multiblock_read_count = 32 db_block_buffers = 3840 db_file_simultaneous_writes = 8 db_block_lru_latches = 8 shared_pool_size = 31457280 which of these parameter is affecting the value of multiblock read count ??? TIA Rahul PS: i hv checked the multiblock reads using ixora script... always 8 !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
phyrds in v$filestat and sql trace not match !!
list, i'm doing benchmarking using two DB's with different block size i run a count(*) on a 17 million row table, and compare the sql_trace file and the v$filestat stats.. the db was bounced before each test, the init.ora params were identical, EXCEPT in DB1 (4k block size) the muldiblock read was 16, and DB2(block size 8k) it was 8 4 samples were taken... CPU time : DB1 = 9023 DB2 = 8027 elapsed time: DB1 = 19171 DB2 = 18045 phy reads: (from sql_trace) DB1 = 327022 DB2 = 159347 PHYRDS from v$filestat DB1 = 16386 DB2 = 16385 PHYBLKRDS from v$filestat DB1 = 262148 DB2 = 131073 my question is... why the physical reads in the v$filestat are equal ?? but the p reads in the sql_trace file are different ?? TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: RAID 7137 configutation on AIX
list, we are trying to install the external disk array IBM 1737 to our J50 rs/6000 we do not have any documents/manuals .. this disk array can be configured as raid5 or raid0, but how to configure it ?? anyone ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
strange (?) ora7 behaviour using CTAS
list... this is something i cannot explain.. goal: to CTAS in a newly created tablespace 1) i created two raw devices test01 and test02 2) create tablespace test datafile '/dev/rtest01' size 1040m; 3) alter tablespace test add datafile '/dev/rtest02' size 1040m; 4) create table ratedlocal_test tablespace test storage(initial 1016m next 896 minextents 2 pctincrease 0 freelists 2) unrecoverable parallel 3 as (select * from ratedlocalcalls) / when the table creation was going on.. i happen to look at the v$filestat numbers, i found that the raw device TEST02 was being written to first !!! (it's the SECOND datafile in the tablespace creation) my understanding is that when a table is created, the extents are (initially) taken from the datafile which is the first file when the tbs was created !!! what could be the logic behind this ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: 9iAS install problem
maria believe me..it would be much easier if u installed the infrastructure and the app server on two separate machines.. i was also facing the similar problems..then i split the two installs and everything was fine -- From: Maria Quinn[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 7:03 PM To: Multiple recipients of list ORACLE-L Subject: 9iAS install problem I'm sitting in front of a networked PC, running RedHat 7.2 and Oracle 9i 9.0.1.0.0.I also have a networked Windows2000 box with Forms 6i on it, upon which I have managed to build a simple form on top of my 9i database, and run it client-server style. My ultimate aim is to have an environment for developing and deploying forms using Form Builder, using 9iAS, over the web. I'd like to do my forms development on my windows box, but have the Application Server and database on the linux box. Looking through the Installed products bit of the Oracle installer on my linux box, I note that the machine also has 9iAS Developer Kits 9.0.2.0.1 installed. My understanding is that I also need to install the following products : Oracle 9iAS Infrastructure 9.0.2.0.1 Oracle 9i Application Server 9.0.2.0.1 On attempting to install the Infrastructure, I got the following error: Oracle 9iAS installation has detected that the Enterprise Manager Website is running on the system. Install cannot continue unless the Enterprise Manager Website is shut down. To shut down the Enterprise Manager Website, at the command line, unset the ORACLE_HOME environment variable and run the command /u01/app/oracle/OraASHome/bin/emclt stop. After installation completes, please restart the Enterprise Manager Website using the command /u01/app/oracle/OraASHome/bin/emclt start. So I unset the ORACLE_HOME, and stopped emclt (I bounced it couple of times, for good measure, and I think it stopped OK). I continued to get the same error. I even tried rebooting the machine, and not starting anything up at all. Same problem. Now it's possible that I'm barking up the wrong tree - I'm a developer and this kind of work, has, in the past, been done by someone else. My experience of installing Oracle products is limited (and peppered with disappointment), and despite my willingness to RTFM, I often can't work figure out which FM to R. ;-) I've stated my overall aim at the top of this email - am I even close to achieving it? Thanks in advance, Maria -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Quinn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
question on data warehouse tools by oracle
list, i'm in the process of recommending Oracle as a completel solution for a ;large data warehouse (for a central bank) . After doing thru some of the documentation on OTN ..i have the following info on the products i would need. Please comment if i'm missing something - 9i database (with data mining option ?? wil this help ?) - Oracle warehouse builder (is this the GUI to develope the ETL procedures etc ???) - Oracle 9i reports - 9i App server( portal, reports server) to deploy and distribute the reports - discoverer( required ?? ) (..do i realy require the following??? ) - OLAP - express server / analyzer TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: can clustering help INSERTS ?
;-)
the only waits i see are parallel query dequeue wait, and sometimes
v$session_wait shows write complete waits ..
but i'm sure these are not slowing down the process... (or are they ?)
as most of the time v$session_wait does not return a row !!
and i query this view once every second
Rahul
--
From: Jared Still[SMTP:[EMAIL PROTECTED]]
Sent: Sunday, October 27, 2002 8:27 AM
To: [EMAIL PROTECTED]; Rahul
Subject: Re: can clustering help INSERTS ?
*no* waits?
How is this possible?
Is intantaneous computing now a reality?
Sorry for the sarcasm. Wait, no, not really. ;)
Seriously, all databases wait, all operations take
time. The question on everyone's lips is
'How long are *yours* taking?'
Jared
On Saturday 26 October 2002 00:33, Rahul wrote:
the DB is *not* experiencing any waits... i'm trying to bring down the
run
time of the
insertion process, currently it takes around 9 hrs... the management
wants
to bring it
down to 5-6 hrs...again.. i OD NOT see any wait events while the process
is
running..
there are no indexes on the tables
--
From: Tim Gorman[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, October 25, 2002 9:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: can clustering help INSERTS ?
Rahul,
It does no good to speculate; let's work with facts...
What wait-events are occurring in the sessions running the INSERTs?
If
you
can locate the sessions in the V$SESSION view, then use the value in
the
column SID to locate associated rows in the V$SESSION_EVENT view,
sorting
by
the cumulative time spent on each wait-event:
selectevent, time_waited, average_time, max_time
fromv$session_event
wheresid = SID
union
selectn.name, s.value, 0, 0
fromv$sesstat s, v$statname n
wheres.sid = SID
andn.name in ('CPU used by this session','parse time
cpu','recursive
cpu usage')
ands.statistic# = n.statistic#
order by 2 desc
As you can see, in addition to wait-event information, this query will
also
mix in CPU statistics from the V$SESSTAT view, to give a better
picture
of where time is being spent by these sessions...
Can you post the results of these queries back to the list?
Thanks!
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 25, 2002 6:18 AM
List,
i have two heavily inserted tables, the structures are same.
currently these tables reside on separate disks, can i increase the
performance
of inserts if i create these tables in a cluster ? as a cluster
would
force
the rows of both the tables
to be physically close on the disk !
regards
-rahul
Ora 7.3 on AIX
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://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: can clustering help INSERTS ?
top waits from system_event, when i siad no waits .. i ment no waits while
querying session_wait !!
offcourse a DB WILL experience waits... but, are these waits slowing down my
inserts ??
these stats are after the insertion of 16 million rows, the table in
question is the only table on that disk
EVENT TOTAL_WAITS TOTAL_TIMEOUTS SEC_WAITED AVERAGE_WAIT
--- --- -- --
parallel query dequeue wait 314695 314824 629392.78
200.000883
db file parallel write281993563850.24
13.6538175
db file sequential read 650214 02681.93
.412468818
buffer busy waits 31427 16 955.09
3.03907468
latch free 1623885 42121 818.44
.050400121
log file parallel write 25338 0 737.44
2.91041124
db file scattered read50131 0 690.79
1.37796972
log file sync 10085 3 144.78
1.43559742
the DB is *not* experiencing any waits... i'm trying to bring down the
run
time of the
insertion process, currently it takes around 9 hrs... the management
wants
to bring it
down to 5-6 hrs...again.. i OD NOT see any wait events while the process
is
running..
there are no indexes on the tables
--
From: Tim Gorman[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, October 25, 2002 9:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: can clustering help INSERTS ?
Rahul,
It does no good to speculate; let's work with facts...
What wait-events are occurring in the sessions running the INSERTs?
If
you
can locate the sessions in the V$SESSION view, then use the value in
the
column SID to locate associated rows in the V$SESSION_EVENT view,
sorting
by
the cumulative time spent on each wait-event:
selectevent, time_waited, average_time, max_time
fromv$session_event
wheresid = SID
union
selectn.name, s.value, 0, 0
fromv$sesstat s, v$statname n
wheres.sid = SID
andn.name in ('CPU used by this session','parse time
cpu','recursive
cpu usage')
ands.statistic# = n.statistic#
order by 2 desc
As you can see, in addition to wait-event information, this query will
also
mix in CPU statistics from the V$SESSTAT view, to give a better
picture
of
where time is being spent by these sessions...
Can you post the results of these queries back to the list?
Thanks!
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 25, 2002 6:18 AM
List,
i have two heavily inserted tables, the structures are same.
currently these tables reside on separate disks, can i increase the
performance
of inserts if i create these tables in a cluster ? as a cluster
would
force
the rows of both the tables
to be physically close on the disk !
regards
-rahul
Ora 7.3 on AIX
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
RE: can clustering help INSERTS ?
the DB is *not* experiencing any waits... i'm trying to bring down the run
time of the
insertion process, currently it takes around 9 hrs... the management wants
to bring it
down to 5-6 hrs...again.. i OD NOT see any wait events while the process is
running..
there are no indexes on the tables
--
From: Tim Gorman[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, October 25, 2002 9:13 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: can clustering help INSERTS ?
Rahul,
It does no good to speculate; let's work with facts...
What wait-events are occurring in the sessions running the INSERTs? If
you
can locate the sessions in the V$SESSION view, then use the value in the
column SID to locate associated rows in the V$SESSION_EVENT view, sorting
by
the cumulative time spent on each wait-event:
selectevent, time_waited, average_time, max_time
fromv$session_event
wheresid = SID
union
selectn.name, s.value, 0, 0
fromv$sesstat s, v$statname n
wheres.sid = SID
andn.name in ('CPU used by this session','parse time
cpu','recursive
cpu usage')
ands.statistic# = n.statistic#
order by 2 desc
As you can see, in addition to wait-event information, this query will
also
mix in CPU statistics from the V$SESSTAT view, to give a better picture of
where time is being spent by these sessions...
Can you post the results of these queries back to the list?
Thanks!
-Tim
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 25, 2002 6:18 AM
List,
i have two heavily inserted tables, the structures are same.
currently these tables reside on separate disks, can i increase the
performance
of inserts if i create these tables in a cluster ? as a cluster would
force
the rows of both the tables
to be physically close on the disk !
regards
-rahul
Ora 7.3 on AIX
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://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).
can clustering help INSERTS ?
List, i have two heavily inserted tables, the structures are same. currently these tables reside on separate disks, can i increase the performance of inserts if i create these tables in a cluster ? as a cluster would force the rows of both the tables to be physically close on the disk ! regards -rahul Ora 7.3 on AIX -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
how many async_io processes to invoke? - AIX ora 7.3
list, to give async_io a boost, i increased the minimum server parameter in AIX to 15 (from 2) .. now while doing a ps -Al i see only 4 kproc which are busy !! rest has ZERO excution time infront of them.. !! how do i determine the optimum number of minimum async_io servers for a db which has 1) all files (17 of them) on raw volumes, spread over 4 disks 2) two files are hot.. both on separate hdisks 3) process inserts 20million+ records in two big tables TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
SYS Columns added to the table
Hi I have table with aroung 2 million rows. When I was creating an index on the table, it failed as it was not able to extend the temp segment. I added a temp segment and recreated the index. But now i see the index is created on some columns which cannot be seen in the DESCRIBE TABLE command. The columns created are : SYS_NC00022$ SYS_NC00022$ SYS_NC00022$ SYS_NC00022$ SYS_NC00022$ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Mehendale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
[no subject]
Hi I have unpartitioned table with aroung 2 million rows. When I was creating an index on the table, it failed as it was not able to extend the temp segment. I added a temp segment and recreated the index. But now i see the index is created on some columns which cannot be seen in the DESCRIBE TABLE command. The columns created are : SYS_NC00022$ SYS_NC00023$ SYS_NC00024$ SYS_NC00025$ SYS_NC00026$ SYS_NC00027$ What are these columns. When I do a describe on the table, I cannot see these columns but when I do a select as follows, I see some data in these columns : SELECT SYS_NC00022$,SYS_NC00023$,SYS_NC00024$,SYS_NC00025$,SYS_NC00026$,SYS_NC00027 $ FROM TABLENAME ; SYS_NC00022$SYS_NC00023$SYS_NC00024$SYS_NC00025$SYS_NC00026$ SYS_NC00027$ AFD2BAFFC8FFC7CCFF CFFF CFFFCEFF AFD2BAFFC8FFC7CFFF CFFF CFFFCEFF AFD2BAFFCAFFCCCAFF CFFF CFFFCEFF BAB3BAFFC8FFC9CFFF CFFF CFFFCEFF ACBABCFFC8FFCDCAFF C8FF C8FFC9FF AFD2BAFFC8FFC7CBFF CFFF CFFFCEFF .. What are these columns and what is the data contained in it? TIA -rM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Mehendale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
desc order index
Hi I create a table as follows: create table a ( a number(1)); Then I create index as : create index ia on a(a desc); If i see the index columns as : select index_name, table_name, column_name, column_position from all_ind_columns where table_name = 'A'; index_name table_name column_name column_position IA A SYS_NC2$1 What is the reason for the change in the column name of the index. How to avoid this? TIA -rM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Mehendale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
is this block cleanout ?
when i do a count(*) an a 1.2GB table, just after an app finishes inserting 20 million records i can see from iostat that, that disk is being read as well as written to !!! the only reason i can think of WRITES being performed while being READ is the block cleanout is being performed by the count(*) !! i would appreciate if anyone could explain further ! regards PS: 7.3.2 on AIX, the file is raw and async_io is true -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: IBM Ultrium tape drive for AIX
list, we are planning to buy this external device for backup out AIX (2 databases + rootvg) the sales rep says that this device can backup 60GB in 1.5 hours... (our current internal DDS tape drive takes 4-5 hours for the backup.) .. does anyone else on this list has experience with this device ? how fast reliable is this ? regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: fast tape drive for AIX
list, we are looking for a fast tape drive to backup all the volume groups on our IBM H70.. around 100GB+, our current backup takes around 5-6 hours !!! any ideas about a faster tape drive ? or an optical one ? regards -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
OEM website - cannot login ;-(
list,.. i have tried everything, but stiill i cannot login to em website !! i *CAN* use OEM console (the java app) and can login using SYSMAN (or SYS) but... then i do http://myserver:1810/ it prompts with realm: emterprise-manager username: sysman when i use the same password as when using the java OEM console.. it does NOT work !!! i';m sooo frustrated... i hve tried changing the password to default OEM_TEMP (using the method in metalink) ,startup/shutdown the website.. but still does not work !! what am i doing wrong ? regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to display a precedure from sql plus
for procedure source you could query user_source to describe the procedure you could use SQL desc procedure_name -- From: Alaa Mostafa[SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 3:37 PM To: LazyDBA.com Discussion Subject: How to display a precedure from sql plus Hi All We Create a precedure from sql plus , and we want to desplay it ? thanx _ Do you Yahoo!? New DSL Internet Access http://rd.yahoo.com/evt=1207/*http://sbc.yahoo.com/ from SBC Yahoo! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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 Memory
girish... give the manuals a try... and read about the sga.. and the parameters affecting the sga size... i';m sure you will come up with the answer to ur own question. ;-) -- From: Girish[SMTP:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 3:35 PM To: LazyDBA.com Discussion Subject: Oracle Memory Hi , In WinNT dual processor 2Gb RAM at startup , Oracle 8.1.5 is occupying 50Mb of memory.Is this fine?My db_block size is 8Kb and the db_buffer is 2000. Thanks, Girish S.Bhat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Why does my insert creates so many logs?
- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: backup controlfile to trace
why not just simplay *name* it !!! SQL alter database backup controlfile to '/oracle/ctrl.trc'; -- From: Ray Stell[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 1:13 AM To: Multiple recipients of list ORACLE-L Subject: backup controlfile to trace 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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: backup controlfile to trace
;-( typed too fast the poster asked for the trace .. not the binary copy of the file me wrong.. me appologise... -- From: Rahul[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 12:03 PM To: Multiple recipients of list ORACLE-L Subject: RE: backup controlfile to trace why not just simplay *name* it !!! SQL alter database backup controlfile to '/oracle/ctrl.trc'; -- From: Ray Stell[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, September 18, 2002 1:13 AM To: Multiple recipients of list ORACLE-L Subject:backup controlfile to trace 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://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).
require info on OID / LDAP / LDIF
list, i have been learning about OID for the last couple of weeks.. i have managed to install and run the ldap server on my w2k, i can run the OID manager GUI, and can also do a ldap://wb-rahul:4034; from my IE5 now i want to pupulate the directory with some new info, and test the storage and search of OID... there are a couple of things i do not understand... 1) my understanding of oid is : it would store (and display) static data in a tree like hierarchical structure is this true ? 2) suppose i want to store state, street name, zip in a tree like order.. how to do it ? the syntax is too complicated for me.!! all the docs on metalink writes about cn and dn and sn anyone out there using OID/LDAP in this fashion ? TIA -rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: NFS mounts.
i use FTP to tranfer files... much more faster... -- From: Fernandez, Freddy[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 9:36 PM To: LazyDBA.com Discussion Subject: NFS mounts. Can someone give me a link where I can learn more about setting up NFS on Solaris. Is this a good way to transfer database files to one system to another? Freddy Fernandez Oracle Applications DBA/ Unix System Administrator Toni Guy/TIGI 214.273.2216 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test scenario # 1, dropped online redo logs
list, i will be testing various recovery scenarios on a test instance.. my db is in archive log.. i hv a cold backup, i created a table, inserted some records and switched the logfile.. (i dnt hv a hot backup) , then i deleted both the online redo logs. now i;m trying to re-create the controlfile (with resetlogs) but it fails with.. CREATE CONTROLFILE REUSE DATABASE ORACLE RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01158: database already mounted before i issue the create controlfile command... i do a . svrmgr30 startup nomount i have the following questions.. 1) why i'm getting this error 2) is re-creating the controlfile the *only* way out after the online logs are removed ? TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test scenario # 1, dropped online redo logs - UPDATE
i am able to re-create the control file .. but on doing recover database using backup controlfile the database is requesting a change# which was in the deleted online redo log !!! now what ??? -- From: Rahul Sent: Friday, August 16, 2002 1:57 PM To: 'Oracle List I' Subject: test scenario # 1, dropped online redo logs list, i will be testing various recovery scenarios on a test instance.. my db is in archive log.. i hv a cold backup, i created a table, inserted some records and switched the logfile.. (i dnt hv a hot backup) , then i deleted both the online redo logs. now i;m trying to re-create the controlfile (with resetlogs) but it fails with.. CREATE CONTROLFILE REUSE DATABASE ORACLE RESETLOGS ARCHIVELOG * ORA-01503: CREATE CONTROLFILE failed ORA-01158: database already mounted before i issue the create controlfile command... i do a . svrmgr30 startup nomount i have the following questions.. 1) why i'm getting this error 2) is re-creating the controlfile the *only* way out after the online logs are removed ? TIA rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
d/w for a central bank
list, i have been assigned the job of documenting the scope for a data warehouse for a central bank !! the problem is.. that none of us (including the IT devision of the bank) has any idea on what kind of things to include !!! i would appreciate inputs (off-list) from anyone who has experience in desiging a d/w for a central bank !!! mainly we have to document the various possibilites of utilizing there current OLTP data !!! regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: IO wait
interestingly... the b column of *my* AIX also shows 2 continiously ! kthr memory page faultscpu - --- --- r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 2 200034 3088 0 0 0 00 0 555 2139 1592 1 3 95 1 0 2 200279 2822 0 2 0 00 0 561 2048 313 2 2 95 2 1 2 200654 2397 0 1 0 00 0 568 7397 8371 16 14 68 3 1 2 200718 2077 0 3 0 00 0 675 3235 1394 8 5 82 5 0 2 200034 2778 0 0 0 00 0 541 1428 271 0 1 98 0 0 2 200034 2777 0 0 0 00 0 566 1540 311 1 2 97 1 0 2 200034 2777 0 0 0 00 0 531 3556 251 10 6 84 0 2 2 200034 2770 0 0 0 00 0 550 2942 2847 4 4 90 1 all systems are running fine without any IO (or other performance ) problems... !! regards Rahul -- From: John Kanagaraj[SMTP:[EMAIL PROTECTED]] Some remarks: (not an answer!) The first line of vmstat/iostat output is an average since restart. The 'wa' is 32 and you have 4 processes blocked on average. Was there a problem (or a large load) since your last restart that was since solved? If not, this may just be the average load... On the other hand, you aren't currently paging in/out nor have an abnormal amount of context switches (cs) or system calls (sy), so why should two processes be blocked for resources I/O, paging, and so forth (as per man page). Worth investigating! Unfortunately, *NIX does not provide the equivalent of V$ views so we really cannot dig into the details. -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] kthr memory page faultscpu - --- --- r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 4 754461 3196 0 15 12 299 242 0 596 448 294 53 17 99 32 0 2 754461 3195 0 0 0 00 0 503 1672 123 0 0 99 0 0 2 754461 3195 0 0 0 00 0 509 787 125 0 0 99 0 0 2 754461 3171 0 0 0 00 0 540 830 148 0 1 98 1 0 2 754461 3167 0 0 0 00 0 503 783 120 0 0 99 0 John, I think I recall some references in the past that would state that what you see above is a problem (the 2 blocked processes in the b column). However we are not suffering any type of obvious problems that I am aware of. Is there a way to determine what these processes are? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to force the DB to SKIP tx recovery ?
Vikas, even if the parameters were set for the checkpoint to happen often, all the transactions *not* commited would still be rolled back !! for example, when i shut down the PC in the middle of doing an update of 1/2 a million rows !!! (how would these parameters help?) -- From: Vikas Khanna[SMTP:[EMAIL PROTECTED]] No, Instance recovery has to take place internally, SMON has to recover the committed transactions which were left hanging in the cache to datafiles so that the files become synchronized. After that the db gets opened and roll backwards takes its own time. It depends SMON does this job in the background and any other Server process if needs that block can rollback the uncommitted transaction and proceed with the block. If you wish to recover the instance recovery very fast then set the LOG_CHECKPOINT_INTERVAL,LOG_CHECKPOINT_TIMEOUT,FAST_START_IO_TARGET parameters to force the checkpoints quite often, this would open the instance under crash quite fast as it has to perform less work. But more the checkpoints initiated more the performance degradations as B'ground processes would be under tremendous work. Hope it clarifies. Vikas Khanna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAHUL GAJANAN MEHENDALE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: urgent: production database won't be opened
my guess is that the instance is rolling back transactions which, were interupted when u shutdown the db. -- From: chal_ping[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Wednesday, June 19, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Subject: urgent: production database won't be opened Hi, grurus: This is a production database 8.1.7.2 on aix 4.3.3, there are 17 instances running on the same box. I shutdown immediate the database and it hangs.After wait for one hour, i do a shutdown abort. When i startup again, it failed to open the database , just hangs at this stage like: Sun Jun 16 09:36:40 2002 SMON: enabling cache recovery SMON: enabling tx recovery And the sql*plus window hangs at : database mounted, but never showed open. From another shell prompt, i sqlplus internal and query the instance, it showed instance open in read write state! But from remote node via listener, client process showed 0134: oracle not available. I once met such kind of questions on sun solaris, it is because of solaris bug.But never heard of this kind on AIX. Oracle support suggest reboot the server, but as there is 16 other instance on it, it is not the solution. Can anyone help? Great thanks. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chal_ping INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Urgent: Retrieving Disk Space
contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Advice needed please
containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to pick the lastes file using UTL_FILE package ?
list, the requirement is to use the UTL_FILE package on the server side to open and process the files as they are created (each hour) in a server's directory !! could anyone suggest a logic to pick up the the lastest file created in that dir. ? TIA 8.1.6 on win2k -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: altering next extent
LMT ??? -- From: Jeroen van Sluisdam[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, May 24, 2002 6:03 PM To: Multiple recipients of list ORACLE-L Subject: altering next extent Hi, I have a strange phenomena. Due to sizing problems with a specific table. I changed the next extent clause with ALTER TABLE contingenten.BOEKINGEN_ADDITIONS storage ( next 256K ); Mysteriously after running the batch, it was back on 8K. Ofcourse I select before (also closing sqlplus and starting it again and selecting) and after the batch the next extent by SQL select next_extent from dba_tables where table_name = 'BOEKINGEN_ADDITIONS'; NEXT_EXTENT --- 8192 After the batch it was back on 8K. I checked the scripts and there was no alter in the script. I turned on the audit on this table and did find only records with 'session rec' in action_name What can cause the previous alter to be changed back? Tia, Jeroen Details: oracle 7.3.4 HP-UX 10.20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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_ENCRYPT_LOGIN
could not say about the net8, but in oracle 7 clients, if the initial login fails, the client will do the *next* login attempt using *plain text* as password !!! but if this param is set to TRUE, all the attempts are done using an encrypted password. set ORA_ENCRYPT_LOGIN = TRUE , in the correct ORACLE_HOME using regedit (if on windows) turn the tracing level to 16, try to connect and see the trace file, u wud see the userid in plain text but thepassword will be encrypted... -- From: MacGregor, Ian A.[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 2:52 AM To: Multiple recipients of list ORACLE-L Subject: RE: ORA_ENCRYPT_LOGIN If you want to be absolutely sure the password is being encrypted, you'll need to place a sniffer on the network. Work with your network guys and whoever else needs to be involved. In most company's using an unauthorized sniffer will result in dismissal. Let me reinterate what I stated. SQL*NET encrypts passwords even if the ORA_ENCRYPT_LOGIN parameter is not set to TRUE I wouldn't label it strong encryption. If you really need that there is the Advanced Security Option. I'm not 100% sure when the passwrod is sent in the clear. It is never sent plain text when the ORA_ENCRYPT_L0gin parameter is set to TRUE. I believe it will be sent in the clear if the Oracle server side of SQL*NET is incapable of handling encrypted passwords and ORA_ENCRYPT_LOGIN is set to false. ( I cannot , off the top of my head, remember if the parameter takes YES/NO or TRUE/FALSE). The first thing I would do is ensure ORA_ENCRYPT_LOGIN is true for all clients. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- From: Richard Huntley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: ORA_ENCRYPT_LOGIN That's exactly what I want to stop, passwords being sent in the clear. However, I'm not able to verify it's working so far. I've turned on tracing, as recommended in another reply on this topic, did a login before enabling then after enabling this parameter and the differences are very minor and I'm seeing nothing that specifically points to this parameter being used other than output saying the parameter is detected. How are you all having developers connect to the production box via SQL*Plus client on developer workstations, so that the password is not sent in the clear? -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA_ENCRYPT_LOGIN Even without this parameter being set the password is encrypted. What the parameter does is stop the password from being sent in the clear if logging in with the encrypted password fails. I believe the encryption is a 54-bit variant of DES. It is very rare that someone improves DES by fiddling with it. It also always encrypts to the same value and provides no protection against replay attacks. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- From: Richard Huntley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 9:34 AM To: Multiple recipients of list ORACLE-L Subject: ORA_ENCRYPT_LOGIN Anyone using this and if so, do you know of a way to verify that the password is actually being encrypted? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
top 5 segments from each tablespace...
i hv written a pl/sql to print out the 5 largest segments (max number of extents) from each of the tbs present in a DB... can this is done using sql too ? just curious... regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: export to tape!!
$ cp dumpfile /dev/rmt0 -- From: Raghu Kota[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 11:48 PM To: Multiple recipients of list ORACLE-L Subject: export to tape!! Hi Friends, I need to export some 40 tables on to tape, my system is AIX415 with oracle7.3, some body could give steps. Thanks Raghu. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 is how i created mount points - AIX
list, i have 3 hdisks, i created ONE volume group for each hdisk, the VG size was just a little less than that of the disk... hdisk1 vg1 hdisk2 vg2 hdisk3 vg3 then i creatd mount points /hd1, /hd2/, and /hd3 and created 3 file systems on 3 volume groups and mounted them on the above mentioned directories.. now i will create further sub-directories under these mount points... for instance data/indexes etc... this setup gives me easy one-to-one mapping, so i;'m sure if i put my files under /hd1, the data is stored to hdisk1 physically !! am i right ?? or is there a more better (complex?) way to do this.. ? Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sysdba
and i'm just curious what does paPIpapupapePO means ? -- From: paPIpapupapePO[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, April 04, 2002 6:43 AM To: Multiple recipients of list ORACLE-L Subject: Re: sysdba the acoount that i used was oracle account. primary group is oinstall and secondary is dba. bill thater wrote: [EMAIL PROTECTED] wrote: i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. are you starting sqlplus from an account in the DBA group? is the DBA group the primary group? -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Youth and skill are no match for experience and treachery. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Stand By Database !!
you need to create the datafile in ur standby and then apply the logs... see the alter database create datafile AS command... -- From: Prasad Dash, Saroj (CAP, GCF)[SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 9:00 AM To: LazyDBA.com Discussion Subject: Stand By Database !! Suhen , After adding a datafile in Primary database .In the day end I am planning to apply the archive logs into stand by database. Did I require to refresh the controlfile . Hello all, My standby database is in manual mode. I came to know that if you will apply the archive logs then you will hit the errors below. ORA-283, ORA-1670, ORA-1157, ORA-1110 STANDBY DATABASE svrmgrl STANDBY DATABASE connect internal STANDBY DATABASE recover standby database Press Enter Key then i will hit those errors ORA-283, ORA-1670, ORA-1157, ORA-1110 My standby database is in manual mode.Everyday I transfer the archive logs manually and recove the dataase manually. So please tell me what will be the detail procedure of adding a datafile in stand by databse. I know about this command. Svrmgrl connect internal svrmgrl simple i will put the below command. ALTER DATABASE CREATE DATAFILE '/db/orcale/docimage.dbf' AS '/db/orcale/docimage.dbf'; svrmgrl then recover standby database HIt the Enter Key the appply the logs. Please tell me the detail procedure. Regards, Saroj. Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alter table enable table lock hangs..
list, i was playing around with the disable table lock command and disabled the locks on a temp table.. but i'm not able to ENABLE the table lock again !!! the command just hangs... queried from v$session_wait.. .the command is waiting for library cache handle eternally..!!! is there any way i can drop this table ??? (it would require enabling the table locks) seems like a bug to me... i'm on rs/6000 with 8.1.5.0.0 Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Replication - Oracle 9i - problem
I am not sure about this... just a guess They may have included catrep.sql as a part of something mandatory like catproc or catalog So, one does not need to run that separatly... Did you read the documentation? Do they say that if DB has to be created manually then run catrep.sql separatly? +R ___ ______ ___ ___ / /\ / /\ / /\ / /\ / /\ / /::\ / /::\/ /:// /:// /:/ / /:/\:\ / /:/:| / /:// /:// /:/ / /::\ \:\ / /:/|:| / /::\ __ / /:/ ___ / /:/ /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/ / /\ /__/:/ \__\/~|::\/:/ \__\/\:\:| \__\/ \:\/:/ \ \:\ / /:/ \ \:\ | |:|::/ \__\::| \__\::/ \ \:\ /:/ \ \:\ | |:|\/ | |:| / /:/ \ \:\/:/ \ \:\ |__|:| |__|:| /__/:/ \ \::/ \ \:\ \__\| \__\| \__\/ \__\/ \__\/ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 04, 2002 5:08 AM During install of Oracle9i EE software, I have checked replication option. Afterwards, when I run Database Configuration Assistant there is no check box related to replication??? When I run Oracle Installer after the install, it confirms that replication option is present. Platform is 9i on Win2000. Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: replication question
Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
Re: Replication - Oracle 9i - problem
I think what Vladimir is referring is the DBCA screen (atleast in 8i) which asks if Replication option is to be used or not. And if checked, it calls catrep.sql after dbcreate - catalog - catproc +Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 04, 2002 7:53 AM Replication is not part of database configuration. After you build the database and create objects inside you use the replication manager to create the replication on the objects you want to replicate. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Vladimir Barac - posao [SMTP:[EMAIL PROTECTED]] Sent: Mon, March 04, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: Replication - Oracle 9i - problem During install of Oracle9i EE software, I have checked replication option. Afterwards, when I run Database Configuration Assistant there is no check box related to replication??? When I run Oracle Installer after the install, it confirms that replication option is present. Platform is 9i on Win2000. Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Multimaster Replication Doubt...
1. It is my understanding that Oracle 7.x has continuous purge of the propogated deftrans. There is no option of scheduling periodic purge at specific time. Am I correct? 2. How to schedule continuous purge of propogated deftrans in Oracle 8i from command line? prompt SCHEDULE PURGE AT MASTER SITE BEGIN DBMS_DEFER_SYS.SCHEDULE_PURGE ( NEXT_DATE = SYSDATE, INTERVAL = 'SYSDATE + 1/24', DELAY_SECONDS = 0, ROLLBACK_SEGMENT = ''); END; / Manual says set DELAY_SECONDS to 500,000 and set INTERVAL to a value less than DELAY_SECONDS. I could not understand exactly how this works... +Rahul ___ ______ ___ ___ / /\ / /\ / /\ / /\ / /\ / /::\ / /::\/ /:// /:// /:/ / /:/\:\ / /:/:| / /:// /:// /:/ / /::\ \:\ / /:/|:| / /::\ __ / /:/ ___ / /:/ /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/ / /\ /__/:/ \__\/~|::\/:/ \__\/\:\:| \__\/ \:\/:/ \ \:\ / /:/ \ \:\ | |:|::/ \__\::| \__\::/ \ \:\ /:/ \ \:\ | |:|\/ | |:| / /:/ \ \:\/:/ \ \:\ |__|:| |__|:| /__/:/ \ \::/ \ \:\ \__\| \__\| \__\/ \__\/ \__\/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: replication question
Well, you could open standby DB only for read only access (8i) whereas in replication, both or all (more than 2) databases could be up and open to users all the times. Each DML causes substantial overhead as each transaction needs to be propogated and applied at all the master sites (whereas inOracle Parallel Server,there is centralized database accessed by multiple instances, there is no need for this). So, if you donot need two databases at two geographically separate locations, open for users, then Standby DB or OPSmight be better option. Again, in OPS, if the hardware cluster fails then you are in trouble... About speed, if you could tune up sending of logs and application of it, then Standby database would consume substantially lesser resources than replication, hence higher throughput... The primary database in Standby DB just needs to send the archivelogs (simple file transfer) and then log application happens on the secondary server... Whereas, in replication, the database would have to propogate and apply each and every transaction individually +Rahul - Original Message - From: James Ambursley To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 1:24 PM Subject: RE: replication question Is replication faster than a standby database.As I understand it, the standby database will be receive arch logs at preset intervals. Does replication have the same functionality and about how much data is sent to the replicated site. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: RE: replication question The way I see it . the question comes down to whether or not you need two way replication or just one way. If both databases can update those tables and you need them synced between the databases then Advanced Replication would be the route. If all you need are data changes from 1 database to be replicated to another database then simple replication is all you need. -Original Message-From: Rahul Dandekar [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 AMTo: Multiple recipients of list ORACLE-LSubject: Re: replication question Depends on your need. You can have read only snapshots, updatable snapshots or multimaster... Again if you think of multimaster... then you would need to make decision based on your application requirements about sync or async I donot have any expereince of snapshot replication. But, if you are planning multimaster replication, then better spend a couple of months studying it and testing on test boxes... Make 100% sure that your applicationreally needs the replication and there is no other simpler option... Just 2 cents... +Rahul - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is supported in my both databases. ? Bunyamin
Re: EXTENTS?
Isn't the minimum extent size something like 5 times the DB_BLOCK_SIZE? If that's true then maximum .2 extents in DB block. Or you are looking for this info? db_block_size Max Extents -- --- 2K121 4K249 8K505 16K 1017 32K 2041 +Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 04, 2002 1:28 PM Depends on your extent size -Original Message- Sent: Monday, March 04, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Hi If DB block size is 8k then how many extents in one db block? Thanks -Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Fwd: UNIX Performance Issues]
Title: Message James, Interleaved, please find my reply +Rahul - Original Message - From: James Morle To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 19, 2002 6:03 AM Subject: RE: [Fwd: UNIX Performance Issues] Rahul, Did you get a response on this? I'm not sure I fully understand the actual question - are you looking for specific commands you need to run to get the information, [Rahul] Yes. I would like to know which flags of the commonly used commands give good information. For general System stats, I use "sar -u" (same as default), for Memory / Virtual Memory I use "vmstat" and look for "r b w swap free pi po us sy id" columns. I am looking for general monitoring. And once we have this general information giving a overall picture, we could know if there is a problem and we could investigate further. I am specifically looking for IO and Network statistics. Is there any command which would give me approx IO of the system, say in last 5 minutes or current? How to get network statistics? I was littlebit confused with netstat. There are two main categories in my output : hme0 and Total. What does that mean? input hme0 output input (Total) outputpackets errs packets errs colls packets errs packets errs colls5757291 0 2447690 0 0 6071152 0 2761551 0 045 0 1 0 0 45 0 1 0 024 0 2 0 0 24 0 2 0 0 What I plan to do is to take snapshot of all these statistics at acertain frequency and put it in database.Later on I could generate reports based on this. Currently, I have a lot of "Camera"s like thistaking snapshots of my system. Others involveOracle stuff like DB Size Growth, Performance Ratios,UNIX File System usage, Replication Statistics, Growth of DB objects, a lot of monitors for application info (e.g. total # of clients, # of invoices generated per day). I generate trends based on this archival data for capacity planning and proactively anticipating chronic problems. or advice on how to interpret it? Don't forget that you will really need to correlate many of these statistics to the Oracle pathology at the same time. You said it! I want co-relation of Application Load, UNIX System Load and Database Statistics. And not just when the problem arises. So, that's what I am trying to develop. This then causes a problem because your sample points will at the very least experience clock drift and become harder to compare over time. There are ways to solve it, though. Anyway, if you could elaborate a little, I can try to assist! Regards James --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 22:11To: James MorleSubject: [Fwd: UNIX Performance Issues]Hi James,I've got no idea whether this is of interest or not to you, but you probably know a bit about this topic.Mogens Original Message Subject: UNIX Performance Issues Date: Thu, 14 Feb 2002 07:43:26 -0800 From: "Rahul Dandekar" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]DBAs, This might be littlebit (or completely!) UNIX related... But I am told to do the performance analysis of some 10-15 machines and generate some statistical data to find out bottlenecks and identify areas of tuning... Operating System : Solaris 2.6 I have been using sar, iostat, top... I actually plan to script these things and run these scripts at certain intervals and put the data in database (Oracle 8i) and then do the crunching... Inputs are appreciated... 1. I/O What is current I/O status. Is there a lot of I/O going on? 2. Paging Is there lot of swapping / paging happening? Which processes are getting swapped in/out continuously? Are the I/O waits due to swapping / paging or regular stuff like DB waiting to read from DB files? 3. CPU What is the CPU utulization? Which processes are using lot of CPU? 4. Memory What is the current picture of Real and Virtual Memory? What processes are using how much memory? Which processes are i n real memory and which are in virtual memory? Which processes are swapped in and out from/to real/virtual memory and how many times? 5. Network What is the percentage utilization of network pipe? What is the capacity (bandwidth) of the network device? What percentage of that bandwidth is getting used? Is the system waiting for data from outside network I/O? In short, is there any
Re: Copy files to hard drive from unix server
I do it from dos / command prompt in windows as follows Create files cmds and c.bat and run c.bat +--+ | cmds | +--+ oracle password lcd c:\temp get /test/files bye +---+ | c.bat | +---+ ftp -s:cmds tmatesttmrm +Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM Hallo, anyone who can give me an easy example on a unix shell script that copies files from a unix directory /test/files to the hard drive directory c:\temp Thanks in advance. Would appreciate very much. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: [Fwd: UNIX Performance Issues]
Title: Message
James,
Getting interesting, isn't it? I have added my
response...
- Original Message -
From:
James Morle
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, February 19, 2002 8:58
AM
Subject: RE: [Fwd: UNIX Performance
Issues]
Rahul,
Here's what I would do.
1) I would use "mpstat" for the processor statistics.
This breaks the usage up by processor in SMP configurations. This can be
useful to see the relative loading of each CPU, in particular the breakdown of
kernel and user time.
2) Memory: Concentrate on Page Outs and Free Memory more
than anything else. That will give you plenty of clues about memory
starvation, and the relevence of your VM tuning.
3) I/O: User "sar -d". It's a bit annoying on a system
with a lot of disks, because it returns a row for every device, even if no I/O
occurred in the sample period. However, it makes it easier to parse. ;-)
Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), and
the queue depth. The utilisation is a function of these (queuing theory), but
you can store that too as a shortcut. You can give sar any sample period, so
your 5 minute averages are no problem.
How can I get the current I/O load on the system? I don't know
exactly what metric I am looking for.
But I want to establish some baseline metric for each machine and
then hunt for spikes from the
gathered data. The metric can be "I/O load on system bus in
Mb/sec" (like the netstat info packets
input and output). I don't want individual disk statistics. I just
want a overall number, which I
can snapshot.
4) Network: "netstat 5" will report a row for every 5
seconds (for example), showing how many packets went in and out of each
interface. Your question below is easily answered - you have two columns in
your output; the first is for the named interface (hme0), the 100baseT network
card. The second is a total of all cards - looks like you only have one. This
total can also include the loopback interface (lo0), so look out for
that.
If I have only one card then why the total and hme0 data are
different (by about 10%)?
Good luck, you're doing the right thing. I've been
working on some software to do just this for a couple of years. I'd love to
hear how it goes!
+Rahul
Regards
James
--James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor
of "Scaling Oracle8i - Building Highly Scalable OLTP System
Architectures"
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul
DandekarSent: 19 February 2002 12:59To: Multiple
recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance
Issues]
James,
Interleaved, please find my
reply
+Rahul
- Original Message -
From:
James Morle
To: Multiple recipients of list
ORACLE-L
Sent: Tuesday, February 19, 2002 6:03
AM
Subject: RE: [Fwd: UNIX Performance
Issues]
Rahul,
Did you get a response on this? I'm not sure I fully
understand the actual question - are you looking for specific commands you
need to run to get the information,
[Rahul] Yes. I would like to know which flags of the
commonly used commands give good information.
For general System stats, I use "sar -u" (same as
default), for Memory / Virtual Memory I use "vmstat"
and look for "r b w
swap free pi po us
sy id" columns.
I am looking for general monitoring. And once we have
this general information giving a overall picture,
we could know if there is a problem and we could
investigate further.
I am specifically looking for IO and Network
statistics.
Is there any command which would give me approx IO of
the system, say in last 5 minutes or
current?
How to get network statistics? I was littlebit confused
with netstat. There are two main categories
in my output : hme0 and Total. What does that
mean?
input
hme0
output
input (Total) outputpackets errs packets
errs colls packets errs packets errs
colls5757291 0 2447690 0
0 6071152 0 2761551
0 045
0 1
0 0
45 0
1 0
024 0
2 0
0 24
0 2
0 0
What I plan to do is to take snapshot of all these statistics
at acertain frequency and put it
in database.Later on I could generate reports based on
this.
Currently, I have a lot of "Camera"s like thistaking
snapshots of my system.
Others involveOracle stuff like DB Size Growth,
Performance Ratios,UNIX File System
usage, Replication Statistics, Growth of DB objects, a lot of
monitors for application
info (e.g. total # of clients
Re: Oracle Advanced Replication
Adar, How do you take care of backups? I mean, what kind of backups do you take? How are you addressing the scenario of incomplete recovery? Following are some of my doubts. 1. What kind of Backup should be taken? Online or Offline? Does replication would generate substantially higher redo? Ø Lets analyze the possibility of Online Backups : q Redo Generation Apparently, a database in replicated environment would generate significantly more redo if the same database was not in replicated environment. Is there sufficient bandwidth (diskspace, tapes) for the additional redo? q Need for Complete Recovery If we need to recover one of the databases then it should be complete recovery. Incomplete recovery will not be permissible since the databases are in replicated environment. (Lets not consider 'All' the databases restored from their backups till a certain SCN.) q Quick Recovery Also, the recovery must be done quickly. This is because as one of the databases in replicated environment is down, the DEFTRAN queues in other master sites would start getting larger and larger and it might reach to a stage where we would also need to do the 'Offline Instantiation' for replicated objects. q When complete ercovery is not possible . In case complete recovery is not possible then we need to recover the databases and then perform 'Offline Instantiation' for replicated objects. Ø What if we take Offline Backups : q For a simple recovery, entire database needs to be restored from the cold backup. q 'Offline Instantiation' needs to be performed each time media recovery is performed. This is because media recovery would always bring the database till the time of cold backup and other master sites would be ahead in time. q In case datafiles affecting 'only' those tablespaces which have objects which are replicated are needing recovery then recovery can be done by using transportable tablespaces feature. i. First, we would need to drop those tablespaces from the database. ii. We can then drop replication for this master group. iii. Transport and Plug-in the tablespace's datafile from other master site. iv. Rebuild replication. TIA, +Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, February 17, 2002 11:18 AM Hello Peter We implemented Advance Replication as part of dealing room. We defined master to master real-time replication. Synchronous, 2 phase commit, from the primary to the backup DB as each deal is a lot of money and standby database will not reflect updates since the last log file was archived. Since we need master to master we defined the replication from the backup DB to the primary as asynchronous even though no body is using the backup DB. I think that the cases are similar. Points to take care off: 1) Prepare a script to drop the replication on each machine if the other machine fails. Lets say that you got a CPU fault on the primary and you switch to the backup. In this case you might get off with the asynchronous replication as updates will accumulate in the backup machine until the CPU is replaced. When the primary will come up the replication will update the primary DB with all the changes. Now, if the disk drive fails on the primary you will probably have to rebuild the DB from scratch (or from export from the backup). In this case there is no point to accumulate updates in the backup machine. Also, if the backup machine fails you do not want the updates to the primary to fail. In this case you drop replication and go on working. 2) Ensure that the log files, rollback segments, datafiles (size) and all init ora are the same on both machines. You do not want to swap to the backup only to find that the parameters are ok for one connection (replication) but fails when working as a primary DB. 3) Hey, what happens if the air condition stopped working and ALL the machines heats up and stopped working. Both machine will fail. Worse if that room gets on fire you are out of luck. Move the backup machine at least a couple of rooms away. 4) Use stand by database in another building so in case of a serious problem (11 seqptember) you will not lose all your data, only the data since the last archive. 5) Test, Test, Test again all failure scenarios, and test again each month, quarter or whatever. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] -Original Message- From: Peter Barnett [SMTP:[EMAIL PROTECTED]] Sent: Fri, February 15, 2002 1:04 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Advanced Replication We
script to populate tables, i just wrote one
List, i just finished writing a script to generate random data to populate tables for load testing... the script takes into account the check constraint of a column and generate the correct/valid values. Also, a DEFAULT value of a column is also considered and generated accordingly. values for ALL the columns are generated (to keep it simple). I'm sure there are many scripts like this on available on the web.. but hey!!! i needed to jog the pl/sql side of my brain ;-)) mail me privately to request the script ... regards PS: please do not fill the list with me too messages -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Library Cache wait -- Who is holding this latch
you are getting the SID from the v$session_wait view.. just query the v$session and find our the session details of this SID ! -- From: Gupta, Brijesh[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: Library Cache wait -- Who is holding this latch Hi All I have a session which is waiting for Library Cache latch for 6 hours. How can I find who is holding this latch. This session is executing a pl/sql script ( Not package ). Latch# 60 is library cache latch. Here is from v$session_wait 1 select * from v$session_wait 2* where sid=1005 PROD/ Press Enter to Continue SIDSEQ# EVENT P1TEXT --- --- -- - P1RAWP2TEXT P2 P2RAW --- -- Wait Sec in P3TEXT P3 P3RAW time Wait STATE --- -- 10055987 latch free address @9925 0701C0A5E228 number 60 003C tries 0 00 -1 32,962 WAITED SHORT Thanks Brijesh Gupta Oracle Production DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UNIX Performance Issues
DBAs, This might be littlebit (or completely!) UNIX related... But I am told to do the performance analysis of some 10-15 machines and generate some statistical data to find out bottlenecks and identify areas of tuning... Operating System : Solaris 2.6 I have been using sar, iostat, top... I actually plan to script these things and run these scripts at certain intervals and put the data in database (Oracle 8i) and then do the crunching... Inputs are appreciated... 1. I/O What is current I/O status. Is there a lot of I/O going on? 2. Paging Is there lot of swapping / paging happening? Which processes are getting swapped in/out continuously? Are the I/O waits due to swapping / paging or regular stuff like DB waiting to read from DB files? 3. CPU What is the CPU utulization? Which processes are using lot of CPU? 4. Memory What is the current picture of Real and Virtual Memory? What processes are using how much memory? Which processes are in real memory and which are in virtual memory? Which processes are swapped in and out from/to real/virtual memory and how many times? 5. Network What is the percentage utilization of network pipe? What is the capacity (bandwidth) of the network device? What percentage of that bandwidth is getting used? Is the system waiting for data from outside network I/O? In short, is there any bandwidth problem with network device or network traffic. Thanks, ___ ______ ___ ___ / /\ / /\ / /\ / /\ / /\ / /::\ / /::\/ /:// /:// /:/ / /:/\:\ / /:/:| / /:// /:// /:/ / /::\ \:\ / /:/|:| / /::\ __ / /:/ ___ / /:/ /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/ / /\ /__/:/ \__\/~|::\/:/ \__\/\:\:| \__\/ \:\/:/ \ \:\ / /:/ \ \:\ | |:|::/ \__\::| \__\::/ \ \:\ /:/ \ \:\ | |:|\/ | |:| / /:/ \ \:\/:/ \ \:\ |__|:| |__|:| /__/:/ \ \::/ \ \:\ \__\| \__\| \__\/ \__\/ \__\/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
my boss wants a report !!!
list, the management has asked me to report the activities i do to make sure that all the DB's are in perfect health.!! Without being technical the report should somehow show the status of the DB's . I have decided to devide the report into the following sections - performance how to show the performance of the DB ??? without using any stats . - storage occupied / available - security unauthorized access - backup and recovery status of the hot standby database. could anyone point out some more information to include showing the performance of the DB ? Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT - using winsock.dll from within forms 6i
list, sorry for this OT , but our development team is looking for resources/links on the web providing examples of sending/recieving data using winsock from oralce forms.. i tried searching google, but could not find any code samples...!! regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RECOMPILE INVALID OBJECTS
Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Mehendale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
