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
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 > > -- &
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!!
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).
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).
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
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
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.context parameters ('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 a stylesheet 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/xml and 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 been able to locate this 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 been able to locate this 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,
(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,
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 is not 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
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 you share some of the reasons 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
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: 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).
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: 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).
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).
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).
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).
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).
CA tools for d/w ?
list, is anyone using CA's ETL and reporting tools for a d/w ? would you recommend these for a big d/w ? we plan to recommend the following: - oracle 9i (partitioning, data mining options) - data warehouse builder - CA's Cleverpath set of tools (olap/reporting) -- 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 ?
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 &g
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 ?
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).
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).
[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 ; 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).
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).
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?
: [EMAIL PROTECTED] (note EXACT spelling of > > > > 'ListGuru') and in > > > > the message BODY, include a line containing: > > UNSUB > > > > ORACLE-L > > > > (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). > > > > > > > > > > > _ > > 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: Viral Desai > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 > > http://www.fatcity.com > > San Diego, California-- Mailing list and web > > hosting services > > > - > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (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
;-( 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).
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).
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 - 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).
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).
how to force the DB to SKIP tx recovery ?
List, ...was doing a looog update, was taking forever, i rebooted the PC, as expected, the *open* of the instance is taking a very long time.. and i cannot wait... is there a way to open the DB *without* letting oracle perform the thread recovery ?? i just to open the DB data lose is acceptable.. 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).
[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
een beperking van aansprakelijkheid is opgenomen. De > algemene voorwaarden worden u op verzoek kosteloos toegezonden. > = > The information contained in this communication is confidential and is > intended solely for the use of the individual or entity to whom it is > addressed. You should not copy, disclose or distribute this communication > without the authority of Ernst & Young. Ernst & Young is neither liable > for > the proper and complete transmission of the information contained in this > communication nor for any delay in its receipt. Ernst & Young does not > guarantee that the integrity of this communication has been maintained nor > that the communication is free of viruses, interceptions or interference. > > If you are not the intended recipient of this communication please return > the communication to the sender and delete and destroy all copies. > > In carrying out its engagements, Ernst & Young applies general terms and > 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
-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robertson Lee - lerobe > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: 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: 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 in Oracle 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 OPS might 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 application really 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 question
Why not just Updateable Snapshots? Updateable Snapshots allow users to query and update a local replicated data set even when disconnected from the master site. More relevant is the fact that... Updateable Snapshots require fewer resources than multimaster replication, while still supporting data updates. - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 10:43 AM Subject: 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 application really 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
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 - 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).
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 application really 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 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: [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 a certain frequency and put it in database. Later on I could generate reports based on this. Currently, I have a lot of "Camera"s like this taking snapshots of my system. Oth
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, 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 a certain frequency and put it in database. Later on I could generate reports based on this. Currently, I have a lot of "Camera"s like this taking snapshots of my system. Others involve Oracle 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
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 mont
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).
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).
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).