RE: Which certification for Oracle DBA ???
What when both are gone? IMH opinion, C++/Assembly would probably stay and be in demand. Within c++ probably text based would go earlier than GUI based. To my understanding, you can code for both in GUI. Aleem -Original Message- Sent: Wednesday, February 13, 2002 6:43 AM To: Multiple recipients of list ORACLE-L Subject:Re: Which certification for Oracle DBA ??? Get both. On Tuesday 12 February 2002 07:33, you wrote: > Hi, > > I have just given my oracle 9i upgrade exam. I was > wondering which certification is best for me next - > Sun Solaris administration or JAVA certification ? > I have a 6+ years of Oracle, 4 years of Solaris > experience and 6 months JAVA experience. > > What do the Oracle gurus at this list think ? Which is > better - Sun Solaris administration or JAVA > certification ? > > Thanks > Jason > > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: Preparation for OCP 8i Upgrade
HI Mandal , My recomendation is for this book : Oracle8 to Oraxcle8i upgrade for Robert G. Freeman , Charles A. Pack Regards Gholam --- > -Original Message- > From: Mandal, Ashoke [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, February 13, 2002 2:28 AM > To: Multiple recipients of list ORACLE-L > Subject: Preparation for OCP 8i Upgrade > > Is there any book for Oracle 8i upgrade > > Thanks, > Ashoke > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandal, Ashoke > 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: Ahmed Gholam Hussain 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: optimizer_mode/optimizer_rule
Yea, was not sure but not enough to check :-) Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rachel > Carmichael > Sent: Tuesday, February 12, 2002 7:23 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: optimizer_mode/optimizer_rule > > > optimizer_mode is a parameter in the init.ora > optimizer_goal is a parameter for the alter session command. > > you had them reversed > > > --- Alex Hillman <[EMAIL PROTECTED]> wrote: > > OPTIMIZER_GOAL is a parameter in init.ora and determines systemwide > > optimizer usage. OPTIMIZER_MODE is parameter in alter session command > > and > > determines optimizer used by that session. > > > > Alex Hillman > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > > [EMAIL PROTECTED] > > > Sent: Tuesday, February 12, 2002 1:50 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: optimizer_mode/optimizer_rule > > > > > > > > > What is the difference between optimizet_mode and optimizer_goal > > > parameters? > > > Are they being used interchangeably? > > > I've rtmf-ed. It is not clear. > > > Thank you. > > > -- > > > 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: Alex Hillman > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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: Sql question
Remco is right: the last predicate in the subquery should be "=" instead of "<>" as we want to EXCLUDE those ones using the NOT EXISTS. In fact, I think that query will always return no rows, as the first part is asking for those with searchvalue = 'first one', but not those with no searchvalues that do not equal 'second one', which of course excludes 'first one'... >>> [EMAIL PROTECTED] 13/2/2002 3:48:27 >>> This message has been scanned by MAILSweeper. Remco, This is exactly what he wants - all records where the first one exists and the second one does not exist. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 12, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Thomas, "NOT EXISTS" and "<>" equals "must be at least one" Right ? That's not what Zsolt wants ... :-) -Oorspronkelijk bericht- Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 12 februari 2002 14:28 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Sql question Zsolt, Try: select a.something ,c.searchvalue from a, b, c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and c.searchvalue= 'first one' and and not exists(select 1 from c c1 where c1.b1 = c.b1 and c1.b2 = c.b2 and c1.searchvalue<> 'second one') the above presumes that the columns b1 and b2 are part of the identifying columns for the c table. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, February 11, 2002 4:40 PM To: Multiple recipients of list ORACLE-L Hi, I have the following sql: select a.something ,c.searchvalue from a, b, c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and c.searchvalue= 'first one' and c.searchvalue<> 'second one' The problem is that if a company has a record with c.searchvalue= 'first one' then the query above list it although it has another record with c.searchvalue= 'second one' To be more precise : I need to get the companies that have searchvalue = 'first one' but I don't want to see companies that has 'second one'. (the main problem is with companies that have both values) Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may a
Re: Which certification for Oracle DBA ???
Get both. On Tuesday 12 February 2002 07:33, you wrote: > Hi, > > I have just given my oracle 9i upgrade exam. I was > wondering which certification is best for me next - > Sun Solaris administration or JAVA certification ? > I have a 6+ years of Oracle, 4 years of Solaris > experience and 6 months JAVA experience. > > What do the Oracle gurus at this list think ? Which is > better - Sun Solaris administration or JAVA > certification ? > > Thanks > Jason > > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Where FORTRAN version which supported on Oracle 8i
Dear all, Which FORTRAN version are supported on Oracle 8i? Which one is best among them? thanks in advance, Ahmadsyah Alghozi Nugroho ~ Holly ~ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho 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: Moving Oracle Binaries from HP to SUN
Rob, I've faced a slightly similar scenario. The main difference being, I didn't go from a SUN box to a HP box. Instead, it was from one SUN box to another SUN box. The binaries were installed on the other server and the EMC disks connected (if that is the right word) to the server. Everything worked fine after that. I don;t know whether or not going from HP to SUN would have different issues. Regards, Sujatha -Original Message- Sent: Wednesday, 13 February 2002 2:48 AM To: Multiple recipients of list ORACLE-L Has anyone done the following: Create a db using Oracle Loaded on an HP Server - The datafiles, controlfiles, etc will be on EMC Later, Install the oracle binaries on a SUN Server, basically unplug the HP from the SYMM, and plug in the SUN and bring up the database. I was asked this yesterday because some of the sun hardware is on back order, and they want to put the project in production before the parts will arrive. There is a spare HP server (bought for another project) they can use until the parts arrive. I am awaiting an official response from Oracle, but thought I would get your input. TIA, Robert Pegram - EDS Oracle DBA __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram 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: Sujatha Madan 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: optimizer_mode/optimizer_rule
optimizer_mode is a parameter in the init.ora optimizer_goal is a parameter for the alter session command. you had them reversed --- Alex Hillman <[EMAIL PROTECTED]> wrote: > OPTIMIZER_GOAL is a parameter in init.ora and determines systemwide > optimizer usage. OPTIMIZER_MODE is parameter in alter session command > and > determines optimizer used by that session. > > Alex Hillman > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > [EMAIL PROTECTED] > > Sent: Tuesday, February 12, 2002 1:50 PM > > To: Multiple recipients of list ORACLE-L > > Subject: optimizer_mode/optimizer_rule > > > > > > What is the difference between optimizet_mode and optimizer_goal > > parameters? > > Are they being used interchangeably? > > I've rtmf-ed. It is not clear. > > Thank you. > > -- > > 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: Alex Hillman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Masters certification !!!
I think he's catching on !!! -Original Message- Rowski Sent: Tuesday, February 12, 2002 3:09 PM To: Multiple recipients of list ORACLE-L I don't want to go for Oracle Masters because of the compulsory training from Oracle. Why should I spend big money on training when I have real world experience. Thanks Jason --- Joe Raube <[EMAIL PROTECTED]> wrote: > It depends on which way you want your career path to > go... > > administrator or developer? > > it really depends on what you want to do. > > Why not go for Oracle Master?? (big grin) > > -Joe > > --- Jason Rowski <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have just given my oracle 9i upgrade exam. I was > > wondering which certification is best for me next > - > > Sun Solaris administration or JAVA certification ? > > I have a 6+ years of Oracle, 4 years of Solaris > > experience and 6 months JAVA experience. > > > > What do the Oracle gurus at this list think ? > Which is > > better - Sun Solaris administration or JAVA > > certification ? > > > > Thanks > > Jason > > > > > > > > __ > > Do You Yahoo!? > > Send FREE Valentine eCards with Yahoo! Greetings! > > http://greetings.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Jason Rowski > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like > subscribing). > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Joe Raube > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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: Randy Kirkpatrick 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: Which certification for Oracle DBA ???
Java will go a lot sooner Scott Shafer San Antonio, TX 210-581-6217 "Common sense will not accomplish great things. Simply become insane and desperate." > -Original Message- > From: Jason Rowski [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, February 12, 2002 4:03 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Which certification for Oracle DBA ??? > > I think Solaris is going to go away soon as it is > going replaced by Linux.The reasons are : > > 1) Linux is backed by all the major vendors like IBM, > HP, SGI etc. ( even SUN was pressured into offering > Linux on sparc on low end servers). > > 2) Running Linux is cheap because of the all open > source software out there. Plus Linux admins are > cheaper than solaris admins. > > Thanks > Jason > > > --- [EMAIL PROTECTED] wrote: > > Solaris. Languages come and go (flavor of the month > > like java), but servers > > will be there always. > > > > Scott Shafer > > San Antonio, TX > > 210-581-6217 > > > > "Common sense will not accomplish great things. > > Simply become insane and > > desperate." > > > > > -Original Message- > > > From: Jason Rowski [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, February 12, 2002 9:34 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Which certification for Oracle DBA ??? > > > > > > Hi, > > > > > > I have just given my oracle 9i upgrade exam. I was > > > wondering which certification is best for me next > > - > > > Sun Solaris administration or JAVA certification ? > > > I have a 6+ years of Oracle, 4 years of Solaris > > > experience and 6 months JAVA experience. > > > > > > What do the Oracle gurus at this list think ? > > Which is > > > better - Sun Solaris administration or JAVA > > > certification ? > > > > > > Thanks > > > Jason > > > > > > > > > > > > __ > > > Do You Yahoo!? > > > Send FREE Valentine eCards with Yahoo! Greetings! > > > http://greetings.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: Jason Rowski > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > > (or the name of mailing list you want to be > > removed from). You may > > > also send the HELP command for other information > > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jason Rowski > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Thanks : URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi everybody, Finally it worked for me. Thanks for all your help. Ashoke -Original Message-From: orantdba [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 12, 2002 1:02 PMTo: Multiple recipients of list ORACLE-LSubject: Re: URGENT Help on tracking unauthorized login to Oracle DatabaseHi all,I have never done this particular activity but by following the clues given in thisthread AND BY reading the documentation I was able to make this work. Thesteps I followed were.1. change the initializaion parameter audit_trail to be:audit_trail=dbshutdown and restart database2. connect to the database as a user that has the privilege "AUDIT SYSTEM"audit session whenever not successfulat this point you can see these unsuccessful logins by monitoring the dba_audit_trail view.John[EMAIL PROTECTED] wrote: The SQL reference has some information... http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074 HTH Tim -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 12, 2002 12:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database To track users who tried and logged into the database : SQL > audit session; I don't know in which section you can find that in the Administrator Guide. Rivaldi -Original Message-From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]Sent: Monday, February 11, 2002 11:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the following Administrator's guide. Oracle8i Administrator's GuideRelease 2 (8.1.6)Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide.Chapter on auditing.Audit session. Rivaldi -Original Message-From: Mandal, Ashoke [ mailto:[EMAIL PROTECTED] ]Sent: Friday, February 08, 2002 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to OracleDatabase Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks,Ashoke -Original Message-Sent: Friday, February 08, 2002 11:54 AMTo: Multiple recipients of list ORACLE-LDatabase Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: >>Greetings,We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose.Any help is appreciatedThanks,>>Ashoke>> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL
RE: Rollback Segment Problem
Why would you need coalesce at all?. My understanding that if Oracle cannot find contiguous free space it try coalesce itself. Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohammad > Rafiq > Sent: Tuesday, February 12, 2002 4:53 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Rollback Segment Problem > > > Jerry, > Thanks for sharing script. We might have better systems as timing > was never > be a issue. I just tested my script on 2 systems and it ran between 34.5 > mseconds to 4.65 seconds...and on the basis of it is results we > coalesce all > such tablespaces. I prefer to keep pctincrease of tablespaces as > 0(zero) and > manually coalesing as and when it is required > > So have you ran your deletion job after coalesing or not? > > Regards > Rafiq > > > > > To: <[EMAIL PROTECTED]> > CC: <[EMAIL PROTECTED]> > Date: Tue, 12 Feb 2002 15:28:41 -0600 > > Rafiq, > > While your script provides a lot of good information, it sure is > slow on my > system. It took 1:44 minutes while my script below took 420 > mseconds. I was > really surprised as my script has a self-join. Then I checked out > dba_free_space_coalesced. It sure is complicated as it calls on two other > views and a table. > > select a.tablespace_name, count(a.tablespace_name) "ContinguousFreeBlocks" > from dba_free_space a, dba_free_space b > where a.tablespace_name = b.tablespace_name > and a.file_id = b.file_id > and a.block_id = b.block_id + b.Blocks > group by a.tablespace_name; > > If ContinguousFreeBlocks is > 10, I coalesce. > > Jerry Whittle > ACIFICS DBA > NCI Information Systems Inc. > [EMAIL PROTECTED] > 618-622-4145 > > > -Original Message- > > From: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] > > > > Is your tablespace fragmented as it is not finding contingous extent .. > > TRy to coalesce your subject tablespace and try... > > > > you can use following script to check whether coalesing is required or > not.. > > If percent is < 100 then coalesce it.. > > > > select substr(tablespace_name,1,10)TS_NAME,total_extents > > "Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0) > > from dba_free_space_coalesced > > order by tablespace_name > > / > > > > HTH > > Regards > > Rafiq > > > > > > > MOHAMMAD RAFIQ > > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman 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).
Preparation for OCP 8i Upgrade
Is there any book for Oracle 8i upgrade Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke 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: optimizer_mode/optimizer_rule
OPTIMIZER_GOAL is a parameter in init.ora and determines systemwide optimizer usage. OPTIMIZER_MODE is parameter in alter session command and determines optimizer used by that session. Alex Hillman > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, February 12, 2002 1:50 PM > To: Multiple recipients of list ORACLE-L > Subject: optimizer_mode/optimizer_rule > > > What is the difference between optimizet_mode and optimizer_goal > parameters? > Are they being used interchangeably? > I've rtmf-ed. It is not clear. > Thank you. > -- > 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: Alex Hillman 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: Which certification for Oracle DBA ???
I think Solaris is going to go away soon as it is going replaced by Linux.The reasons are : 1) Linux is backed by all the major vendors like IBM, HP, SGI etc. ( even SUN was pressured into offering Linux on sparc on low end servers). 2) Running Linux is cheap because of the all open source software out there. Plus Linux admins are cheaper than solaris admins. Thanks Jason --- [EMAIL PROTECTED] wrote: > Solaris. Languages come and go (flavor of the month > like java), but servers > will be there always. > > Scott Shafer > San Antonio, TX > 210-581-6217 > > "Common sense will not accomplish great things. > Simply become insane and > desperate." > > > -Original Message- > > From: Jason Rowski [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, February 12, 2002 9:34 AM > > To: Multiple recipients of list ORACLE-L > > Subject:Which certification for Oracle DBA ??? > > > > Hi, > > > > I have just given my oracle 9i upgrade exam. I was > > wondering which certification is best for me next > - > > Sun Solaris administration or JAVA certification ? > > I have a 6+ years of Oracle, 4 years of Solaris > > experience and 6 months JAVA experience. > > > > What do the Oracle gurus at this list think ? > Which is > > better - Sun Solaris administration or JAVA > > certification ? > > > > Thanks > > Jason > > > > > > > > __ > > Do You Yahoo!? > > Send FREE Valentine eCards with Yahoo! Greetings! > > http://greetings.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Jason Rowski > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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).
Patch 8.1.7.3 for NT/2000
FYI: It's available on Metastink and supposedly fixes a lo-o-o-o-o-ta bugs! Best, Sergey Babich
Oracle Advanced Security on Server - Mandatory encryption
Title: Oracle Advanced Security on Server - Mandatory encryption I am primarily interested in encryption, not authentication. I understand that placing the following lines in a client's sqlnet.ora file to REQUIRE encryption to/from the server is: SQLNET_CRYPTO_CHECKSUM_TYPE_SERVER = MD5 SQLNET.AUTHENTICATION_SERVICES= (NTS) SQLNET.CRYPTO_CHECKSUM_CLIENT = requested SQLNET.ENCRYPTION_TYPES_SERVER= (RC4_40, DES40) SQLNET.ENCRYPTION_TYPES_CLIENT= (RC4_40, DES40) SQLNET_CRYPTO_CHECKSUM_TYPE_CLIENT = MD5 SQLNET.EXPIRE_TIME = 0 SQLNET.ENCRYPTION_SERVER = REQUIRED SQLNET.ENCRYPTION_CLIENT = REQUIRED SQLNET.CRYPTO_CHECKSUM_SERVER = requested SQLNET.CRYPTO_SEED = qwertyuiopasdfghjkl;zxcvbnm If encryption can not be enforced by either the client or the server (due to the REQUIRED values), the connection won't be made. This seems kind of arbitrary that the client can dictate how the server is to conduct business. What (and where) on the server do I set such that encryption is mandatory to/from ANY client? Am I correct that the server's sqlnet.ora file has nothing to do with a remote client's sqlnet.ora file? Thanx, Alan Martin Principal Consultant Defense Logistics Information Service Battle Creek, Michigan
Oracle Masters certification !!!
I don't want to go for Oracle Masters because of the compulsory training from Oracle. Why should I spend big money on training when I have real world experience. Thanks Jason --- Joe Raube <[EMAIL PROTECTED]> wrote: > It depends on which way you want your career path to > go... > > administrator or developer? > > it really depends on what you want to do. > > Why not go for Oracle Master?? (big grin) > > -Joe > > --- Jason Rowski <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have just given my oracle 9i upgrade exam. I was > > wondering which certification is best for me next > - > > Sun Solaris administration or JAVA certification ? > > I have a 6+ years of Oracle, 4 years of Solaris > > experience and 6 months JAVA experience. > > > > What do the Oracle gurus at this list think ? > Which is > > better - Sun Solaris administration or JAVA > > certification ? > > > > Thanks > > Jason > > > > > > > > __ > > Do You Yahoo!? > > Send FREE Valentine eCards with Yahoo! Greetings! > > http://greetings.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Jason Rowski > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like > subscribing). > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Joe Raube > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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: Upgrading from 8.0.5 to 8.1.7 - Please help
Good point. -Original Message- Sent: Tuesday, February 12, 2002 12:29 PM To: Multiple recipients of list ORACLE-L Fred, I'll respond this way. The odma makes its selection on the database to upgrade based on those available from oratab (with the old database $ORACLE_HOME). Also the odma default execution will want to start that database before it upgrades the datafiles. On top of that, I would want my test upgrades to mimic the production upgrades as closely as possible. With that in mind, I would reinstall 8.0.5 under 5.8, and proceed from there. Mike Hand Polaroid Corp. -Original Message- Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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).
Preperation for OCP 9i
Hi I used the book 'Oracle 9i : New features' by Robert Freeman. I had made extensive notes on Oracle 9i new features from Oracle 9i manuals also. If you are interested , I can post it online. The exam is at the same level as Oracle 8i upgrade exam. Thanks Jason --- Mohammad Rafiq <[EMAIL PROTECTED]> wrote: > A quick question..What was the level of this upgarde > test,in your opinion, > and what level of preparation is required..I am > planning to appear it in > coming March/April 2002...for 9i OCP upgrade test. > > Based on your experience for Solaris, it is better > to have certification of > Solaris, IMH opinion... > > Regards > Rafiq > > > > > > Reply-To: [EMAIL PROTECTED] > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > Date: Tue, 12 Feb 2002 07:33:39 -0800 > > Hi, > > I have just given my oracle 9i upgrade exam. I was > wondering which certification is best for me next - > Sun Solaris administration or JAVA certification ? > I have a 6+ years of Oracle, 4 years of Solaris > experience and 6 months JAVA experience. > > What do the Oracle gurus at this list think ? Which > is > better - Sun Solaris administration or JAVA > certification ? > > Thanks > Jason > > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jason Rowski >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). > > > > > MOHAMMAD RAFIQ > > > _ > Chat with friends online, try MSN Messenger: > http://messenger.msn.com > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mohammad Rafiq > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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: Rollback Segment Problem
Jerry, Thanks for sharing script. We might have better systems as timing was never be a issue. I just tested my script on 2 systems and it ran between 34.5 mseconds to 4.65 seconds...and on the basis of it is results we coalesce all such tablespaces. I prefer to keep pctincrease of tablespaces as 0(zero) and manually coalesing as and when it is required So have you ran your deletion job after coalesing or not? Regards Rafiq To: <[EMAIL PROTECTED]> CC: <[EMAIL PROTECTED]> Date: Tue, 12 Feb 2002 15:28:41 -0600 Rafiq, While your script provides a lot of good information, it sure is slow on my system. It took 1:44 minutes while my script below took 420 mseconds. I was really surprised as my script has a self-join. Then I checked out dba_free_space_coalesced. It sure is complicated as it calls on two other views and a table. select a.tablespace_name, count(a.tablespace_name) "ContinguousFreeBlocks" from dba_free_space a, dba_free_space b where a.tablespace_name = b.tablespace_name and a.file_id = b.file_id and a.block_id = b.block_id + b.Blocks group by a.tablespace_name; If ContinguousFreeBlocks is > 10, I coalesce. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 > -Original Message- > From:Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] > > Is your tablespace fragmented as it is not finding contingous extent .. > TRy to coalesce your subject tablespace and try... > > you can use following script to check whether coalesing is required or not.. > If percent is < 100 then coalesce it.. > > select substr(tablespace_name,1,10)TS_NAME,total_extents > "Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0) > from dba_free_space_coalesced > order by tablespace_name > / > > HTH > Regards > Rafiq > MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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).
RUN STORE PROCEDURE INSIDE A FUNCTION
Hi List, How can I run a store procedure inside a function? I have a store procedure to do some DML, and we can not run it from our application for some sort of limitation, only we can call function from application side, Is there any way to run this store procedure inside a function or some thing like this Another question is can we do some DML inside the function or not?? Thanks alot for your help, appreciate. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Rollback Segment Problem
Rafiq, While your script provides a lot of good information, it sure is slow on my system. It took 1:44 minutes while my script below took 420 mseconds. I was really surprised as my script has a self-join. Then I checked out dba_free_space_coalesced. It sure is complicated as it calls on two other views and a table. select a.tablespace_name, count(a.tablespace_name) "ContinguousFreeBlocks" from dba_free_space a, dba_free_space b where a.tablespace_name = b.tablespace_name and a.file_id = b.file_id and a.block_id = b.block_id + b.Blocks group by a.tablespace_name; If ContinguousFreeBlocks is > 10, I coalesce. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 > -Original Message- > From: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] > > Is your tablespace fragmented as it is not finding contingous extent .. > TRy to coalesce your subject tablespace and try... > > you can use following script to check whether coalesing is required or not.. > If percent is < 100 then coalesce it.. > > select substr(tablespace_name,1,10)TS_NAME,total_extents > "Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0) > from dba_free_space_coalesced > order by tablespace_name > / > > HTH > Regards > Rafiq > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI 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[4]: Date format element rule change
Alexander, Your example below is very helpful, and explains why I recalled that duplicating date elements was possible. I probably used TO_CHAR to test this in the past, while the other day I was using ALTER SESSION. My theory on why you can't duplicate elements when setting NLS_DATE_FORMAT is that the NLS_DATE_FORMAT value gets used for both input AND output. It's no problem to spit the month out twice in two different ways, but there's probably some issues involved with making users specify the month twice. For example, what if a user specifies two different months, as in: Feb (03) 15, 2002? This is becomming clearer to me now. Thanks. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Monday, February 11, 2002, 10:48:20 PM, you wrote: AFmc> You can, using to_char, but not in "alter ... nls ..." SQL>> select to_char(sysdate,'Mon (MM) DD, ') from dual; AFmc> TO_CHAR(SYSDATE,' AFmc> - AFmc> Feb (02) 11, 2002 AFmc> 1 row selected. AFmc> Alex. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick 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: Re[4]: Date format element rule change
Title: RE: Re[4]: Date format element rule change Jonathan, You are right. From FM: For input format models, format items cannot appear twice, and format items that represent similar information cannot be combined. For example, you cannot use 'S' and 'BC' in the same format string. And: NLS_DATE_FORMAT specifies the default date format to use with the TO_CHAR and TO_DATE functions. Alex. -Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 1:21 PM To: [EMAIL PROTECTED] Cc: Alexander Feinstein Subject: Re[4]: Date format element rule change Alexander, Your example below is very helpful, and explains why I recalled that duplicating date elements was possible. I probably used TO_CHAR to test this in the past, while the other day I was using ALTER SESSION. My theory on why you can't duplicate elements when setting NLS_DATE_FORMAT is that the NLS_DATE_FORMAT value gets used for both input AND output. It's no problem to spit the month out twice in two different ways, but there's probably some issues involved with making users specify the month twice. For example, what if a user specifies two different months, as in: Feb (03) 15, 2002? This is becomming clearer to me now. Thanks. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Monday, February 11, 2002, 10:48:20 PM, you wrote: AFmc> You can, using to_char, but not in "alter ... nls ..." SQL>> select to_char(sysdate,'Mon (MM) DD, ') from dual; AFmc> TO_CHAR(SYSDATE,' AFmc> - AFmc> Feb (02) 11, 2002 AFmc> 1 row selected. AFmc> Alex.
RE: How to find out Oracle patch applied
In the $ORACLE_BASE/oraInventory/logs directory look for ' Patch' string in the installActions*.log files. You may find it there... Then you can view that install log file for more info. If those log files aren't there, then you are left with the Oracle Installer to tell you.. - Kirti -Original Message- Sent: Tuesday, February 12, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Is there any Oracle file I can use Unix command "strings" to search for version/patch info? I don't have x-window session. James > -Original Message- > From: Magaliff, Bill [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, February 12, 2002 3:02 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: How to find out Oracle patch applied > > Load the Oracle Installer and click on Installed Products - will tell you > every patch installed by the Installer, which are all the major ones . . . > minor patches and one-off's that are installed via OS file copy will NOT > show up. > > -bill > > -Original Message- > Sent: Tue, February 12, 2002 2:02 PM > To: Multiple recipients of list ORACLE-L > > > Hi DBAs, > > I want to find out what Oracle patch installed. > Someone just installed Oracle817 binary on our server but no 817 > instance setup yet, so can't query v$version. > > Thanks > James > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: parallel execution
Title: RE: parallel execution While on the topic, DEGREE VARCHAR2(10) The number of threads per instance for scanning the table What is a difference between '1' and 'DEFAULT'? SQL> select degree, count(*) from user_tables group by degree; DEGREE COUNT(*) -- -- 1 598 DEFAULT 7 2 rows selected. Alex. -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 6:44 AM To: Multiple recipients of list ORACLE-L Subject: RE: parallel execution Ruth, You can look in USER_TABLES/DBA_TABLES at the DEGREE column. This will give you the number of parallel processes to use for the table. It is also in the USER_INDEXES/DBA_INDEXES view. You can set this values by issuing an: Alter table {tablename} parallel 2; Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel? I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to find out Oracle patch applied
Is there any Oracle file I can use Unix command "strings" to search for version/patch info? I don't have x-window session. James > -Original Message- > From: Magaliff, Bill [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, February 12, 2002 3:02 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: How to find out Oracle patch applied > > Load the Oracle Installer and click on Installed Products - will tell you > every patch installed by the Installer, which are all the major ones . . . > minor patches and one-off's that are installed via OS file copy will NOT > show up. > > -bill > > -Original Message- > Sent: Tue, February 12, 2002 2:02 PM > To: Multiple recipients of list ORACLE-L > > > Hi DBAs, > > I want to find out what Oracle patch installed. > Someone just installed Oracle817 binary on our server but no 817 > instance setup yet, so can't query v$version. > > Thanks > James > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Xing, James > 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: Magaliff, Bill > 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: Xing, James 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: logon failure auditing
Hi Bob, 1. change the initializaion parameter audit_trail to be: audit_trail=db shutdown and restart database 2. connect to the database as a user that has the privilege "AUDIT SYSTEM" audit session whenever not successful at this point you can see these unsuccessful logins by monitoring the dba_audit_trail view. John [EMAIL PROTECTED] wrote: >All, > >I would like to audit all the database users upon >logon failure. > >I know that someone must have been implemented similar >kind of auditing. Could you please share your >information with me. > >At the same time I did create new profile and assign >it to all the database users. This new profile will >lock database users for about 15 Min. after three >successful logon failures. > >Thanks, >Bob > >__ >Do You Yahoo!? >Send FREE Valentine eCards with Yahoo! Greetings! >http://greetings.yahoo.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba 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).
[sans@sans.org: SANS FLASH ALERT: Widespread SNMP Vulnerability]
Oracle does not seem to be listed, but you got to wonder what code they based their snmp stuff on. You may want to nudge you sysadmin in the ribs, also. - Forwarded message from The SANS Institute <[EMAIL PROTECTED]> - Date: Tue, 12 Feb 2002 12:30:06 -0700 (MST) To: Ray Stell <[EMAIL PROTECTED]>(SD569668) SANS FLASH ALERT: Widespread SNMP Vulnerability 1:30 PM EST 12 February, 2002 To: Ray Stell (SD569668) Note: This is preliminary data! If you have additional information, please send it to us at [EMAIL PROTECTED] In a few minutes wire services and other news sources will begin breaking a story about widespread vulnerabilities in SNMP (Simple Network Management Protocol). Exploits of the vulnerability cause systems to fail or to be taken over. The vulnerability can be found in more than a hundred manufacturers' systems and is very widespread - millions of routers and other systems are involved. As one of the SANS alumni, your leadership is needed in making sure that all systems for which you have any responsibility are protected. To do that, first ensure that SNMP is turned off. If you absolutely must run SNMP, get the patch from your hardware or software vendor. They are all working on patches right now. It also makes sense for you to filter traffic destined for SNMP ports (assuming the system doing the filtering is patched). To block SNMP access, block traffic to ports 161 and 162 for tcp and udp. In addition, if you are using Cisco, block udp for port 1993. The problems were caused by programming errors that have been in the SNMP implementations for a long time, but only recently discovered. CERT/CC is taking the lead on the process of getting the vendors to get their patches out. Additional information is posted at http://www.cert.org/advisories/CA-2002-03.html A final note. Turning off SNMP was one of the strong recommendations in the Top 20 Internet Security Threats that the FBI's NIPC and SANS and the Federal CIO Council issued on October 1, 2001. If you didn't take that action then, now might be a good time to correct the rest of the top 20 as well as the SNMP problem. The Top 20 document is posted at http://www.sans.org/top20.htm - End forwarded message - -- === 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 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 find out Oracle patch applied
Load the Oracle Installer and click on Installed Products - will tell you every patch installed by the Installer, which are all the major ones . . . minor patches and one-off's that are installed via OS file copy will NOT show up. -bill -Original Message- Sent: Tue, February 12, 2002 2:02 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I want to find out what Oracle patch installed. Someone just installed Oracle817 binary on our server but no 817 instance setup yet, so can't query v$version. Thanks James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James 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: Magaliff, Bill 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: wrong result from select
I tried the steps on 8.1.7.0.0 on Solaris 2.7, and it worked fine. Trying it on 8.1.7.2.0 provided the erroneous(??) results, but only after the table was analyzed. Has this been filed as a bug? Brian Scott Canaan wrote: > It works fine in 8.1.6.0.0, Sun Solaris 2.6: > > SQL*Plus: Release 8.1.7.0.0 - Production on Tue Feb 12 09:01:22 2002 > > (c) Copyright 2000 Oracle Corporation. All rights reserved. > > Connected to: > Oracle8i Release 8.1.6.0.0 - Production > JServer Release 8.1.6.0.0 - Production > > SQL> set echo on > SQL> alter session set optimizer_mode=choose; > > Session altered. > > SQL> alter session set cursor_sharing=force; > > Session altered. > > SQL> create table tb1 (f1 number(4)); > > Table created. > > SQL> insert into tb1 values (1999); > > 1 row created. > > SQL> insert into tb1 values (2000); > > 1 row created. > > SQL> insert into tb1 values (2001); > > 1 row created. > > SQL> insert into tb1 values (2002); > > 1 row created. > > SQL> commit; > > Commit complete. > > SQL> select * from tb1; > > F1 > -- > 1999 > 2000 > 2001 > 2002 > > SQL> analyze table tb1 compute statistics; > > Table analyzed. > > SQL> select f1 from tb1 where f1 between 2000 and 2000; > > F1 > -- > 2000 > > SQL> select f1 from tb1 where f1 between 2000 and 2001; > > F1 > -- > 2000 > 2001 > > SQL> select f1 from tb1 where f1 between 2001 and 2000; > > no rows selected > > SQL> drop table tb1; > > Table dropped. > > SQL> > > This is the output on 8.1.7.0.0, Sun Solaris 2.6: > > SQL*Plus: Release 8.1.7.0.0 - Production on Tue Feb 12 09:03:48 2002 > > (c) Copyright 2000 Oracle Corporation. All rights reserved. > > Connected to: > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production > With the Partitioning option > JServer Release 8.1.7.0.0 - Production > > SQL> set echo on > SQL> alter session set optimizer_mode=choose; > > Session altered. > > SQL> alter session set cursor_sharing=force; > > Session altered. > > SQL> create table tb1 (f1 number(4)); > > Table created. > > SQL> insert into tb1 values (1999); > > 1 row created. > > SQL> insert into tb1 values (2000); > > 1 row created. > > SQL> insert into tb1 values (2001); > > 1 row created. > > SQL> insert into tb1 values (2002); > > 1 row created. > > SQL> commit; > > Commit complete. > > SQL> select * from tb1; > > F1 > -- > 1999 > 2000 > 2001 > 2002 > > SQL> analyze table tb1 compute statistics; > > Table analyzed. > > SQL> select f1 from tb1 where f1 between 2000 and 2000; > > F1 > -- > 2000 > > SQL> select f1 from tb1 where f1 between 2000 and 2001; > > F1 > -- > 2000 > 2001 > > SQL> select f1 from tb1 where f1 between 2001 and 2000; > > no rows selected > > SQL> drop table tb1; > > Table dropped. > > SQL> > > "Jesse, Rich" wrote: > > > Same result on 8.1.7.2 32bit on HP 11.0. The good news is that the correct > > result is obtained using "...where f1 >= 2000 and f1 <= 2001". > > > > Is anyone using 8.1.7.3 on HP/UX 11 to test this? > > > > Rich Jesse System/Database Administrator > > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > > -Original Message- > > [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 08, 2002 4:58 PM > > To: Multiple recipients of list ORACLE-L > > > > Hi, > > Can anybody try this on 9i? > > set echo on > > alter session set optimizer_mode=choose; > > alter session set cursor_sharing=force; > > create table tb1 (f1 number(4)); > > insert into tb1 values (1999); > > insert into tb1 values (2000); > > insert into tb1 values (2001); > > insert into tb1 values (2002); > > commit; > > select * from tb1; > > analyze table tb1 compute statistics; > > select f1 from tb1 where f1 between 2000 and 2000; > > select f1 from tb1 where f1 between 2000 and 2001; > > select f1 from tb1 where f1 between 2001 and 2000; > > drop table tb1; > > Here is what I got on 8.1.7.2.1 64bit on HP-UX 11.0: > > SQL> select * from tb1; > > F1 > > -- > > 1999 > > 2000 > > 2001 > > 2002 > > SQL> select f1 from tb1 where f1 between 2000 and 2000; > > F1 > > -- > > 2000 > > SQL> select f1 from tb1 where f1 between 2000 and 2001; > > F1 > > -- > > 2000 > > SQL> select f1 from tb1 where f1 between 2001 and 2000; > > F1 > > -- > > 2001 > > TIA > > Alex. > > PS. What about cursor_sharing=similar ? > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Jesse, Rich > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message >
Re: Moving Oracle Binaries from HP to SUN
haven't done it, and I don't think it can be done... the datafiles, while Oracle datafiles are still Unix OS files and you can't just copy a file created on HP to Sun and expect it to work. You'd have to export and import/rebuild the database --- Robert Pegram <[EMAIL PROTECTED]> wrote: > Has anyone done the following: > > Create a db using Oracle Loaded on an HP Server > - The datafiles, controlfiles, etc will be on EMC > > Later, > Install the oracle binaries on a SUN Server, basically > unplug the HP from the SYMM, and plug in the SUN and > bring up the database. > > I was asked this yesterday because some of the sun > hardware is on back order, and they want to put the > project in production before the parts will arrive. > There is a spare HP server (bought for another > project) they can use until the parts arrive. > > I am awaiting an official response from Oracle, but > thought I would get your input. > > TIA, > Robert Pegram - EDS > Oracle DBA > > > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robert Pegram > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Moving Oracle Binaries from HP to SUN
Or do like ORACLE says they are doing, and Cluster Intel Based Machines with LINUX. Then you can get rid of all those competing Hardware Vendors. -Original Message- Sent: Tuesday, February 12, 2002 13:39 To: Multiple recipients of list ORACLE-L Stephane, In the not so distant future, I think we might see a push to accomplish just what Robert is asking. With the growth of the need for speed and the decline in the economy, a lot of companies can not afford to purchase new machines and discard to old. If I was a company that had a few different but capable servers to use I would want them all to work together in a cluster if needed. $$$ talks in the IT world today and a lot of us are having to make do with what we have or be creative in our DBA duties. I would like to be able to cluster an HP,SUN,INTEL,AIX or what ever or have the different machines be a backup server. With the merging of companies there is a merging of resources. One company has HP and another has SUN. Do you discard one for the other? or have a capital expendature that you can't afford? Just a thought. ROR mô=Received: from CONNECT-MTA by galotterBF=F4m >>> [EMAIL PROTECTED] 02/12/02 11:48AM >>> Robert Pegram wrote: > > Has anyone done the following: > > Create a db using Oracle Loaded on an HP Server > - The datafiles, controlfiles, etc will be on EMC > > Later, > Install the oracle binaries on a SUN Server, basically > unplug the HP from the SYMM, and plug in the SUN and > bring up the database. > > I was asked this yesterday because some of the sun > hardware is on back order, and they want to put the > project in production before the parts will arrive. > There is a spare HP server (bought for another > project) they can use until the parts arrive. > > I am awaiting an official response from Oracle, but > thought I would get your input. > > TIA, > Robert Pegram - EDS > Oracle DBA > It will not work. Look at the prerequisite for standby databases, it will give you a fair idea of how far you can go in terms of cross-platform play - not very far. The architecture and OS must be the same. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Ron Rogers 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: Cornio, Georgette Ms USACFSC 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: Moving Oracle Binaries from HP to SUN
There have been a few posts in the past claiming that copying datafiles from HP to SUN and vice versa was okay. However, I never received anyone's reply when I asked them how many Production Databases they have transferred using this method. Experimenting is fine but one can't run business on such experimentation. - Kirti -Original Message- Sent: Tuesday, February 12, 2002 12:39 PM To: Multiple recipients of list ORACLE-L Thanks for the responses. I thought exp/imp was the only way to go, but I feel much more confident now. That was also Oracle's response. BTW, I think they have changed their thinking on this issue anyway. Thanks, Robert Pegram - EDS Oracle DBA --- bill thater <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > >Has anyone done the following: > > > >Create a db using Oracle Loaded on an HP Server > >- The datafiles, controlfiles, etc will be on > EMC > > > >Later, > >Install the oracle binaries on a SUN Server, > basically > >unplug the HP from the SYMM, and plug in the SUN > and > >bring up the database. > > > been there, done that, blew up big time.;-) > > as far as i know it won't work. you'd have to go > the exp/imp route. > > > -- > -- > 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. > > Hear and you forget; see and you remember; do and > you understand. - Confucius > > > > > > > -- > 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to find out Oracle patch applied
Hi DBAs, I want to find out what Oracle patch installed. Someone just installed Oracle817 binary on our server but no 817 instance setup yet, so can't query v$version. Thanks James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James 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 Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi all, I have never done this particular activity but by following the clues given in this thread AND BY reading the documentation I was able to make this work. The steps I followed were. 1. change the initializaion parameter audit_trail to be: audit_trail=db shutdown and restart database 2. connect to the database as a user that has the privilege "AUDIT SYSTEM" audit session whenever not successful at this point you can see these unsuccessful logins by monitoring the dba_audit_trail view. John [EMAIL PROTECTED] wrote: The SQL reference has some information... http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074 HTH Tim -Original Message- From: Behar, Rivaldi[mailto:[EMAIL PROTECTED]] Sent: Tuesday, February12, 2002 12:14 PM To: Multiple recipients of listORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Totrack users who tried and logged into the database : SQL> audit session; Idon't know in which section you can find that in the Administrator Guide. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 11:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the following Administrator's guide. Oracle8i Administrator's Guide Release 2 (8.1.6) Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines forAuditing Creating andDeleting the Database Audit Trail Views Managing AuditTrail Information Viewing DatabaseAudit Trail Information Auditing ThroughDatabase Triggers Thanks, Ashoke -Original Message- From: Behar, Rivaldi[mailto:[EMAIL PROTECTED]] Sent: Friday, February08, 2002 1:29 PM To: Multiple recipients of listORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter onauditing. Audit session. Rivaldi -Original Message- From:Mandal, Ashoke [ mailto:[EMAIL PROTECTED] ] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login toOracle Database Joe, We referred the auditing option. My understanding is thatyou can track the oracle users using database auditing feature once theusers are logged into the database. But my requirement is to track the users who tried tologin to the database but could not login due to wrong password. For example, somebody may know the connect string for anoracle database and trying to login to the database as system user andwith various combination of password. We like to know who are theseusers. Thanks, Ashoke -Original Message- Sent:Friday, February 08, 2002 11:54 AM To: Multiplerecipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: >>Greetings, >> >>We have a database with very sensitive data. Ourmanagement wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. >> >>Is there any waywe can track the unauthorized users, who try to login to an oracledatabase with invalid userid or password but with valid connect string. >> >>If there is nooptions under oracle then is there any 3rd party software for thispurpose. >> >>Any help is appreciated >> >>Thanks, >>Ashoke >> -- Please see the officialORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa INET: [EMAIL PRO
RE: Upgrading from 8.0.5 to 8.1.7 - Please help
This is all covered in great detail in the 8.1.7 Migration Guide - Chapter 7 titled "Upgrading from a Previous Version 8 Release to the New Oracle8i Release" There is no need to install 8.0.5 on the target server. Just load the cold backup files, adjust init.ora and follow the steps from the guide. Take another cold backup after the upgrade is done. BTW, Oracle calls this an Upgrade, not a Migrate... :) - Kirti -Original Message- Sent: Tuesday, February 12, 2002 11:44 AM To: Multiple recipients of list ORACLE-L This is definitely not a production db. I was just told by Oracle that it is possible to migrate the 8.0.5 datafiles using 8.1.7 software. They say I do not need to install 8.0.5 on the "new" server. Finding instructions in a document covering this is not easy! -fs >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Upgrading from 8.0.5 to 8.1.7 - Please help >Date: Tue, 12 Feb 2002 09:08:34 -0800 > > >Obviously this WAS not a production database. >If you were not aware that a new OS was being installed and that Oracle was >being wiped out then >step 1 Get a competent SA > >I do not know UNIX but I would think you have to >re-install 8.0.5, >do backup >restore 8.0.5 datafiles,redo,controlfiles,etc. >Modify controlfile to point to restored files > >Once database is started then you can proceed to upgrade to 8.1.7 > >I do not think you can do >"can I simply install 8.1.7 and perform a migration using >8.1.7 on the old 8.0.5 datafiles?" > >Rick > > > > "Fred Smith" > list ORACLE-L <[EMAIL PROTECTED]> > tmail.com> cc: > Sent by: Subject: Upgrading from >8.0.5 to 8.1.7 - Please help > [EMAIL PROTECTED] > m > > > 02/12/2002 > 10:28 AM > Please respond > to ORACLE-L > > > > > > >Hello list, > I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the >old > >8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of >the database. The SA then did a rebuild on the server to upgrade the OS to > >SunOS 5.8. There is no Oracle software or data on the server now. > My question is: Now that I want to go to 8.1.7, do I have to first >install 8.0.5 and bring the database up prior to installing 8.1.7 and >upgrading, OR ... can I simply install 8.1.7 and perform a migration using >8.1.7 on the old 8.0.5 datafiles? How does this work? > >Thanks in advance, > -Fred S. > >_ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dedicated server memory usage 8.1.7 vs 7.3.4
We just recently migrated some production databases from 7.3.4 to 8.1.7.3 on AIX. We have noticed that the amount of memory per dedicated server process spiked from about 400k to 2m. Anybody have any ideas about why this occurs? Is this normal? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow 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).
Oracle Developer/DBA with Java & Informatica Needed- White
White Plains, New York company is looking for a solid Oracle Developer/DBA who also has Java, Informatica, and ETL programming skills for it's I.T. staff. *Candidates who are not in the White Plains area must be willing to relocate themselves and have the ability to relocate "quickly". No relocation assistance is provided. This is a full time staff position so no sub-contractors or third parties. REQUIREMENTS: - Candidates MUST have a solid background in the following: PL/SQL, Oracle 8, Oracle 8i, Java, Informatica, ETL. - Some Oracle DBA experience. - U.S. citizenship or permanent residency is also required. This position is with a company that offers : * Quality Work Environment * Base salary in the 85K range--maybe more NO sub contracting positions available. PLEASE do not send your resume if you are not in the United States. For immediate consideration, please send your resume to: Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. * Please use job code: One/White Plains/Dev/DBA/Jeff ** If you are not in the White Plains area, please maaake it clear when you send your resume that you will pay your own relocation expenses. All inquires held in confidence. We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law OraStaff, Inc-"The Proven Connection To Oracle Opportunity" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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).
optimizer_mode/optimizer_rule
What is the difference between optimizet_mode and optimizer_goal parameters? Are they being used interchangeably? I've rtmf-ed. It is not clear. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrading from 8.0.5 to 8.1.7 - Please help
Fred, I'll respond this way. The odma makes its selection on the database to upgrade based on those available from oratab (with the old database $ORACLE_HOME). Also the odma default execution will want to start that database before it upgrades the datafiles. On top of that, I would want my test upgrades to mimic the production upgrades as closely as possible. With that in mind, I would reinstall 8.0.5 under 5.8, and proceed from there. Mike Hand Polaroid Corp. -Original Message- Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T 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: Moving Oracle Binaries from HP to SUN
Thanks for the responses. I thought exp/imp was the only way to go, but I feel much more confident now. That was also Oracle's response. BTW, I think they have changed their thinking on this issue anyway. Thanks, Robert Pegram - EDS Oracle DBA --- bill thater <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > >Has anyone done the following: > > > >Create a db using Oracle Loaded on an HP Server > >- The datafiles, controlfiles, etc will be on > EMC > > > >Later, > >Install the oracle binaries on a SUN Server, > basically > >unplug the HP from the SYMM, and plug in the SUN > and > >bring up the database. > > > been there, done that, blew up big time.;-) > > as far as i know it won't work. you'd have to go > the exp/imp route. > > > -- > -- > 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. > > Hear and you forget; see and you remember; do and > you understand. - Confucius > > > > > > > -- > 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). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram 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: Oracle Migration Utility
Fred, I don't know how you can use the migration utility from one physical machine to another. I used the export,import method when going across platforms. Build the new database on the new server to your desired specs and then export the tables you want to move to the new database and import them. It worked great for me. I could not use the full export because the database is 70GIG and I only have 5GIG free disk space. Exporting a few tables at a time worked nicely for the large tables. The small tables I built on the new server and then did a network copy of the data. That way I did not tie up the network during the day and the copy was controlled by a script to run all night. Good luck. ROR mª¿ªm >>> [EMAIL PROTECTED] 02/12/02 10:28AM >>> Can anyone advise me on using the migration utility? We are finally moving from 7.3.4 to 8.1.7. Has the utiReceived: from CONNECT-MTA by galotterlity worked well for you? Known bugs? Any info greatly appreciated. THe history, if you want to know. We have been stuck at 7.3.4 due to a lack of migration path for OPS on SGI equipment. We are now installing a Sun 4800, and will be ready to start testing the migration in March. Cheers, Fred = Fred Collington Oracle DBA Naval Air Warfare Center, Training Systems Division __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Collington 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: Ron Rogers 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: Moving Oracle Binaries from HP to SUN
Stephane, In the not so distant future, I think we might see a push to accomplish just what Robert is asking. With the growth of the need for speed and the decline in the economy, a lot of companies can not afford to purchase new machines and discard to old. If I was a company that had a few different but capable servers to use I would want them all to work together in a cluster if needed. $$$ talks in the IT world today and a lot of us are having to make do with what we have or be creative in our DBA duties. I would like to be able to cluster an HP,SUN,INTEL,AIX or what ever or have the different machines be a backup server. With the merging of companies there is a merging of resources. One company has HP and another has SUN. Do you discard one for the other? or have a capital expendature that you can't afford? Just a thought. ROR mô=Received: from CONNECT-MTA by galotterBFôm >>> [EMAIL PROTECTED] 02/12/02 11:48AM >>> Robert Pegram wrote: > > Has anyone done the following: > > Create a db using Oracle Loaded on an HP Server > - The datafiles, controlfiles, etc will be on EMC > > Later, > Install the oracle binaries on a SUN Server, basically > unplug the HP from the SYMM, and plug in the SUN and > bring up the database. > > I was asked this yesterday because some of the sun > hardware is on back order, and they want to put the > project in production before the parts will arrive. > There is a spare HP server (bought for another > project) they can use until the parts arrive. > > I am awaiting an official response from Oracle, but > thought I would get your input. > > TIA, > Robert Pegram - EDS > Oracle DBA > It will not work. Look at the prerequisite for standby databases, it will give you a fair idea of how far you can go in terms of cross-platform play - not very far. The architecture and OS must be the same. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Ron Rogers 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: Upgrading from 8.0.5 to 8.1.7 - Please help
To REMOVE yourself from th is mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling oReceived: from CONNECT-MTA by galotterf 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ron Rogers 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: Sql question
Why not try MINUS Select x, y, z >From tab Where condition=1 Minus Select x, y, z >From tab Where condition=2; HTH, Bambi. -Original Message- Sent: Tuesday, February 12, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Remco, This is exactly what he wants - all records where the first one exists and the second one does not exist. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 12, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Thomas, "NOT EXISTS" and "<>" equals "must be at least one" Right ? That's not what Zsolt wants ... :-) -Oorspronkelijk bericht- Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 12 februari 2002 14:28 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Sql question Zsolt, Try: select a.something ,c.searchvalue from a, b, c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and c.searchvalue= 'first one' and and not exists(select 1 from c c1 where c1.b1 = c.b1 and c1.b2 = c.b2 and c1.searchvalue<> 'second one') the above presumes that the columns b1 and b2 are part of the identifying columns for the c table. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, February 11, 2002 4:40 PM To: Multiple recipients of list ORACLE-L Hi, I have the following sql: select a.something ,c.searchvalue from a, b, c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and c.searchvalue= 'first one' and c.searchvalue<> 'second one' The problem is that if a company has a record with c.searchvalue= 'first one' then the query above list it although it has another record with c.searchvalue= 'second one' To be more precise : I need to get the companies that have searchvalue = 'first one' but I don't want to see companies that has 'second one'. (the main problem is with companies that have both values) Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Interne
RE: Upgrading from 8.0.5 to 8.1.7 - Please help
Fred, Read the Migration guide for 817. If you want to take the chance of losing time, put your 805 db back on the machine and try a migration. If you have never performed a migration, I think you will either be incredibly lucky if it works ok, or you will be back-tracking (delete all the files, and reload them again, reload 805, read the 817 migration docs, create a test 805 db, migrate the test db to 817 to get familiar with the process, and then migrate your db). The first place to start in read-read-read-read. Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 12, 2002 12:29 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] This is not a production database. It's just a reporting machine. Which document are you referring to? The migration guide for 8.0.5 or for 8.1.7? The 8.1.7 guide does not mention a migration process for a non-installed 8.0.5 software. Does this matter? Much thanks, -FS >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >CC: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >Subject: RE: Upgrading from 8.0.5 to 8.1.7 - Please help >Date: Tue, 12 Feb 2002 11:56:13 -0500 > >Fred, > >You can migrate your 805 to 817 directly. You really need to read the >migration documentation - it is pretty straight forward, and will answer >all >your questions. > >You will be doing a migration on a test database first, right? - not the >first time on a production database - right? You will be much happier. > >If I were you, I would install 805 and 817 both on your machine (different >Oracle homes), create a test 805 db and try migrating it to 817 after you >have read everything - just to get the feel of it. > >After that, migrate your production db, and when all is good, remove the >805 >software. > >good luck! > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >From: Fred Smith [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, February 12, 2002 10:29 AM >To: Multiple recipients of list ORACLE-L >Subject: Upgrading from 8.0.5 to 8.1.7 - Please help > > >Hello list, > I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the >old >8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of >the database. The SA then did a rebuild on the server to upgrade the OS to >SunOS 5.8. There is no Oracle software or data on the server now. > My question is: Now that I want to go to 8.1.7, do I have to first >install 8.0.5 and bring the database up prior to installing 8.1.7 and >upgrading, OR ... can I simply install 8.1.7 and perform a migration using >8.1.7 on the old 8.0.5 datafiles? How does this work? > >Thanks in advance, > -Fred S. > >_ >Chat with friends online, try MSN Messenger: http://messenger.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Fred Smith > 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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback Segment Problem
Is your tablespace fragmented as it is not finding contingous extent .. TRy to coalesce your subject tablespace and try... you can use following script to check whether coalesing is required or not.. If percent is < 100 then coalesce it.. select substr(tablespace_name,1,10)TS_NAME,total_extents "Total_Extnts",extents_coalesced,round(percent_extents_coalesced,0) from dba_free_space_coalesced order by tablespace_name / HTH Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 12 Feb 2002 02:33:19 -0800 All, The following is the pitiable scenario I am in and would really appreciate a bit of help : We were running a long running delete job which gave the following error : Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production PL/SQL Release 8.0.5.2.0 - Production SQLWKS> EXECUTE PKG_PAS_AnnualDataMaintenance.Delete_OldData (2000, '/home/sqribe/work/live', '2000AnnualDataDelete.log'); ORA-01562: failed to extend rollback segment number 8 ORA-01650: unable to extend rollback segment RSUNDB08 by 50 in tablespace RSUN425 ORA-06512: at "PAS.PKG_PAS_ANNUALDATAMAINTENANCE", line 66 ORA-06512: at line 2 I don't understand why it ran out of rollback space. The rollback segment has a virtually unlimited number of extents, so the only explanation I can see is that this particular rollback segment expanded until it exceeded the space allocation for the whole tablespace RSUN425, which is 3,000M. However, Oracle Storage Manager shows only 200M of the tablespace used, and it also shows high water marks against each rollback segment, none of which exceeds 400M. This would suggest to me that none of the previous month's deletions exceeded 400M per month, so why should it fail on this particular one when it had nearly 3,000M available? Is there something I am not understanding about rollback segments ?? Thanks and Regards, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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). MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Upgrading from 8.0.5 to 8.1.7 - Please help
This is definitely not a production db. I was just told by Oracle that it is possible to migrate the 8.0.5 datafiles using 8.1.7 software. They say I do not need to install 8.0.5 on the "new" server. Finding instructions in a document covering this is not easy! -fs >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Upgrading from 8.0.5 to 8.1.7 - Please help >Date: Tue, 12 Feb 2002 09:08:34 -0800 > > >Obviously this WAS not a production database. >If you were not aware that a new OS was being installed and that Oracle was >being wiped out then >step 1 Get a competent SA > >I do not know UNIX but I would think you have to >re-install 8.0.5, >do backup >restore 8.0.5 datafiles,redo,controlfiles,etc. >Modify controlfile to point to restored files > >Once database is started then you can proceed to upgrade to 8.1.7 > >I do not think you can do >"can I simply install 8.1.7 and perform a migration using >8.1.7 on the old 8.0.5 datafiles?" > >Rick > > > > "Fred Smith" > list ORACLE-L <[EMAIL PROTECTED]> > tmail.com> cc: > Sent by: Subject: Upgrading from >8.0.5 to 8.1.7 - Please help > [EMAIL PROTECTED] > m > > > 02/12/2002 > 10:28 AM > Please respond > to ORACLE-L > > > > > > >Hello list, > I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the >old > >8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of >the database. The SA then did a rebuild on the server to upgrade the OS to > >SunOS 5.8. There is no Oracle software or data on the server now. > My question is: Now that I want to go to 8.1.7, do I have to first >install 8.0.5 and bring the database up prior to installing 8.1.7 and >upgrading, OR ... can I simply install 8.1.7 and perform a migration using >8.1.7 on the old 8.0.5 datafiles? How does this work? > >Thanks in advance, > -Fred S. > >_ >Chat with friends online, try MSN Messenger: http://messenger.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Fred Smith > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith 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: Which certification for Oracle DBA ???
A quick question..What was the level of this upgarde test,in your opinion, and what level of preparation is required..I am planning to appear it in coming March/April 2002...for 9i OCP upgrade test. Based on your experience for Solaris, it is better to have certification of Solaris, IMH opinion... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 12 Feb 2002 07:33:39 -0800 Hi, I have just given my oracle 9i upgrade exam. I was wondering which certification is best for me next - Sun Solaris administration or JAVA certification ? I have a 6+ years of Oracle, 4 years of Solaris experience and 6 months JAVA experience. What do the Oracle gurus at this list think ? Which is better - Sun Solaris administration or JAVA certification ? Thanks Jason __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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). MOHAMMAD RAFIQ _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Moving Oracle Binaries from HP to SUN
[EMAIL PROTECTED] wrote: >Has anyone done the following: > >Create a db using Oracle Loaded on an HP Server >- The datafiles, controlfiles, etc will be on EMC > >Later, >Install the oracle binaries on a SUN Server, basically >unplug the HP from the SYMM, and plug in the SUN and >bring up the database. > been there, done that, blew up big time.;-) as far as i know it won't work. you'd have to go the exp/imp route. -- -- 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. Hear and you forget; see and you remember; do and you understand. - Confucius -- 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).
RE: Upgrading from 8.0.5 to 8.1.7 - Please help
So, why could you not do just what he is asking ?If you have all the files of the database (Cold Backup of everything), why could you not install the 8.1.7 code and then run the migration tool ? The installation of the Oracle Binaries does not touch the database at all. -Original Message- Sent: Tuesday, February 12, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Obviously this WAS not a production database. If you were not aware that a new OS was being installed and that Oracle was being wiped out then step 1 Get a competent SA I do not know UNIX but I would think you have to re-install 8.0.5, do backup restore 8.0.5 datafiles,redo,controlfiles,etc. Modify controlfile to point to restored files Once database is started then you can proceed to upgrade to 8.1.7 I do not think you can do "can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles?" Rick "Fred Smith" tmail.com> cc: Sent by: Subject: Upgrading from 8.0.5 to 8.1.7 - Please help [EMAIL PROTECTED] m 02/12/2002 10:28 AM Please respond to ORACLE-L Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database The SQL reference has some information... http://docs.oracle.com/cd_database_generic_8.1.7/server.817/a85397/state10b.htm#2059074 HTH Tim -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 12, 2002 12:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database To track users who tried and logged into the database : SQL > audit session; I don't know in which section you can find that in the Administrator Guide. Rivaldi -Original Message-From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]Sent: Monday, February 11, 2002 11:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the following Administrator's guide. Oracle8i Administrator's GuideRelease 2 (8.1.6)Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: >>Greetings, >> >>We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. >> >>Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. >> >>If there is no options under oracle then is there any 3rd party software for this purpose. >> >>Any help is appreciated >> >>Thanks, >>Ashoke >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: Mandal, Ashoke 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 spelli
RE: Which certification for Oracle DBA ???
May be to find a certified job that keeps you busy! -Original Message- Sent: Tuesday, February 12, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I have just given my oracle 9i upgrade exam. I was wondering which certification is best for me next - Sun Solaris administration or JAVA certification ? I have a 6+ years of Oracle, 4 years of Solaris experience and 6 months JAVA experience. What do the Oracle gurus at this list think ? Which is better - Sun Solaris administration or JAVA certification ? Thanks Jason __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Moving Oracle Binaries from HP to SUN
[Robert Pegram] > Create a db using Oracle Loaded on an HP Server > - The datafiles, controlfiles, etc will be on EMC > > Later, > Install the oracle binaries on a SUN Server, basically > unplug the HP from the SYMM, and plug in the SUN and > bring up the database. What storage format? If using filesystem files, I don't see how there's any chance. Even using raw devices it doesn't seem likely possible since Sun partition slices and all. Also, the data format is different between diff. arches, but that may just be an endian issue and these 2 big-endian arch's would be fine. Not sure. I'd give the probability rating around 1% at best :) -- James Manning <[EMAIL PROTECTED]> GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning 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: Which certification for Oracle DBA ???
Solaris. Languages come and go (flavor of the month like java), but servers will be there always. Scott Shafer San Antonio, TX 210-581-6217 "Common sense will not accomplish great things. Simply become insane and desperate." > -Original Message- > From: Jason Rowski [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, February 12, 2002 9:34 AM > To: Multiple recipients of list ORACLE-L > Subject: Which certification for Oracle DBA ??? > > Hi, > > I have just given my oracle 9i upgrade exam. I was > wondering which certification is best for me next - > Sun Solaris administration or JAVA certification ? > I have a 6+ years of Oracle, 4 years of Solaris > experience and 6 months JAVA experience. > > What do the Oracle gurus at this list think ? Which is > better - Sun Solaris administration or JAVA > certification ? > > Thanks > Jason > > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jason Rowski > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrading from 8.0.5 to 8.1.7 - Please help
This is not a production database. It's just a reporting machine. Which document are you referring to? The migration guide for 8.0.5 or for 8.1.7? The 8.1.7 guide does not mention a migration process for a non-installed 8.0.5 software. Does this matter? Much thanks, -FS >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >CC: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> >Subject: RE: Upgrading from 8.0.5 to 8.1.7 - Please help >Date: Tue, 12 Feb 2002 11:56:13 -0500 > >Fred, > >You can migrate your 805 to 817 directly. You really need to read the >migration documentation - it is pretty straight forward, and will answer >all >your questions. > >You will be doing a migration on a test database first, right? - not the >first time on a production database - right? You will be much happier. > >If I were you, I would install 805 and 817 both on your machine (different >Oracle homes), create a test 805 db and try migrating it to 817 after you >have read everything - just to get the feel of it. > >After that, migrate your production db, and when all is good, remove the >805 >software. > >good luck! > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >From: Fred Smith [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, February 12, 2002 10:29 AM >To: Multiple recipients of list ORACLE-L >Subject: Upgrading from 8.0.5 to 8.1.7 - Please help > > >Hello list, > I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the >old >8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of >the database. The SA then did a rebuild on the server to upgrade the OS to >SunOS 5.8. There is no Oracle software or data on the server now. > My question is: Now that I want to go to 8.1.7, do I have to first >install 8.0.5 and bring the database up prior to installing 8.1.7 and >upgrading, OR ... can I simply install 8.1.7 and perform a migration using >8.1.7 on the old 8.0.5 datafiles? How does this work? > >Thanks in advance, > -Fred S. > >_ >Chat with friends online, try MSN Messenger: http://messenger.msn.com > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Fred Smith > 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). _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith 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: Upgrading from 8.0.5 to 8.1.7 - Please help
Fred, Don't waste your time installing 8.0.5 unless you plan to go back to it some time in the future ("Back to the Future"?). Install 8.1.7 and patch to 8.1.7.2 (or higher). Copy your datafiles to the new system. Make sure that you copy them to the exact directory structure that existed previously! If you don't, you will run into major difficulties, especially if you haven't done a backup control file to trace! Read all the documentation on the migration, and perform the migration which should be relatively painless. Randy Kirkpatrick home: (303)772-7467 cell: (303)885-2102 -Original Message- Sent: Tuesday, February 12, 2002 8:29 AM To: Multiple recipients of list ORACLE-L Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith 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: Randy Kirkpatrick 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: Which certification for Oracle DBA ???
It depends on which way you want your career path to go... administrator or developer? it really depends on what you want to do. Why not go for Oracle Master?? (big grin) -Joe --- Jason Rowski <[EMAIL PROTECTED]> wrote: > Hi, > > I have just given my oracle 9i upgrade exam. I was > wondering which certification is best for me next - > Sun Solaris administration or JAVA certification ? > I have a 6+ years of Oracle, 4 years of Solaris > experience and 6 months JAVA experience. > > What do the Oracle gurus at this list think ? Which is > better - Sun Solaris administration or JAVA > certification ? > > Thanks > Jason > > > > __ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jason Rowski > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrading from 8.0.5 to 8.1.7 - Please help
Fred, You can migrate your 805 to 817 directly. You really need to read the migration documentation - it is pretty straight forward, and will answer all your questions. You will be doing a migration on a test database first, right? - not the first time on a production database - right? You will be much happier. If I were you, I would install 805 and 817 both on your machine (different Oracle homes), create a test 805 db and try migrating it to 817 after you have read everything - just to get the feel of it. After that, migrate your production db, and when all is good, remove the 805 software. good luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 12, 2002 10:29 AM To: Multiple recipients of list ORACLE-L Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT Help on tracking unauthorized login to Oracle Database
Title: RE: URGENT Help on tracking unauthorized login to Oracle Database To track users who tried and logged into the database : SQL > audit session; I don't know in which section you can find that in the Administrator Guide. Rivaldi -Original Message-From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]Sent: Monday, February 11, 2002 11:18 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Hi Revaldi and Joe (Testa), I went through the following Administrator's guide. Oracle8i Administrator's GuideRelease 2 (8.1.6)Part Number A76956-01 I could only see chapter 24 on 'Auditing database Use' and under that the following sub-sections. I went through these secition and could not find anything on unsuccessful login to oracle database. Could you please help me in ponting to the right chapter/section. Guidelines for Auditing Creating and Deleting the Database Audit Trail Views Managing Audit Trail Information Viewing Database Audit Trail Information Auditing Through Database Triggers Thanks, Ashoke -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Friday, February 08, 2002 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT Help on tracking unauthorized login to Oracle Database Joe, We referred the auditing option. My understanding is that you can track the oracle users using database auditing feature once the users are logged into the database. But my requirement is to track the users who tried to login to the database but could not login due to wrong password. For example, somebody may know the connect string for an oracle database and trying to login to the database as system user and with various combination of password. We like to know who are these users. Thanks, Ashoke -Original Message- Sent: Friday, February 08, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: >>Greetings, >> >>We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login to this database. >> >>Is there any way we can track the unauthorized users, who try to login to an oracle database with invalid userid or password but with valid connect string. >> >>If there is no options under oracle then is there any 3rd party software for this purpose. >> >>Any help is appreciated >> >>Thanks, >>Ashoke >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S Testa 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: Mandal, Ashoke 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: DSD
Not sure what you mean by DSD, but we provide a tool called the DataBee DBATool, that reads an export file, and generates all of the DLL for the objects within a schema, or the database on the whole (from a FULL export, generated with the ROWS=N option). You can then either document the DDL through HTML pages, or generate SQL scripts to regenerate the schema, as well as creating rules to strip storage clauses etc. There is a free version of this tool available from: http://www.cool-tools.co.uk/Products/Downloads/dbatool020001.exe As it reads an export file, there is no need to log in to any database at any time.. HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -Original Message- [EMAIL PROTECTED] Sent: 12 February 2002 15:04 To: Multiple recipients of list ORACLE-L Any good tool to reverse engineer a DSD either from a DDL or from a user that has full access to the schema, but not requiring to be logged in as the schema owner? Michael Cupp, Jr. Shonac Corporation 4150 East Fifth Avenue Columbus Ohio 43219 Phone: 614-238-4240 Fax: 614-238-4203 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Upgrading from 8.0.5 to 8.1.7 - Please help
Obviously this WAS not a production database. If you were not aware that a new OS was being installed and that Oracle was being wiped out then step 1 Get a competent SA I do not know UNIX but I would think you have to re-install 8.0.5, do backup restore 8.0.5 datafiles,redo,controlfiles,etc. Modify controlfile to point to restored files Once database is started then you can proceed to upgrade to 8.1.7 I do not think you can do "can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles?" Rick "Fred Smith" tmail.com> cc: Sent by: Subject: Upgrading from 8.0.5 to 8.1.7 - Please help [EMAIL PROTECTED] m 02/12/2002 10:28 AM Please respond to ORACLE-L Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: parallel execution
Further to Waleed' response: Field name called 'degree'. if > 1 then it invokes parallel process according to degree level defined if 2 will start 2 processes subject to maximum of parallel_max_servers defined in your init*.ora or in 8i depending on your other parallel settings.. Following param of 8i init ora are most relevent for parallel set up.. parallel_adaptive_multi_user TRUE parallel_automatic_tuning TRUE parallel_broadcast_enabled FALSE parallel_execution_message_siz 4096 parallel_instance_group parallel_max_servers 24 parallel_min_percent 0 parallel_min_servers 0 HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 12 Feb 2002 06:58:26 -0800 dba_tables -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: DSD
Title: Message Any good tool to reverse engineer a DSD either from a DDL or from a user that has full access to the schema, but not requiring to be logged in as the schema owner? ERwin supports reverse engineering from DDL - http://www.cai.com/products/alm/erwin.htm hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. "
Which certification for Oracle DBA ???
Hi, I have just given my oracle 9i upgrade exam. I was wondering which certification is best for me next - Sun Solaris administration or JAVA certification ? I have a 6+ years of Oracle, 4 years of Solaris experience and 6 months JAVA experience. What do the Oracle gurus at this list think ? Which is better - Sun Solaris administration or JAVA certification ? Thanks Jason __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jason Rowski 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: Sql question
Remco, This is exactly what he wants - all records where the first one exists and the second one does not exist. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 12, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Thomas, "NOT EXISTS" and "<>" equals "must be at least one" Right ? That's not what Zsolt wants ... :-) -Oorspronkelijk bericht- Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 12 februari 2002 14:28 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Sql question Zsolt, Try: select a.something ,c.searchvalue from a, b, c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and c.searchvalue= 'first one' and and not exists(select 1 from c c1 where c1.b1 = c.b1 and c1.b2 = c.b2 and c1.searchvalue<> 'second one') the above presumes that the columns b1 and b2 are part of the identifying columns for the c table. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, February 11, 2002 4:40 PM To: Multiple recipients of list ORACLE-L Hi, I have the following sql: select a.something ,c.searchvalue from a, b, c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and c.searchvalue= 'first one' and c.searchvalue<> 'second one' The problem is that if a company has a record with c.searchvalue= 'first one' then the query above list it although it has another record with c.searchvalue= 'second one' To be more precise : I need to get the companies that have searchvalue = 'first one' but I don't want to see companies that has 'second one'. (the main problem is with companies that have both values) Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Moving Oracle Binaries from HP to SUN
Robert Pegram wrote: > > Has anyone done the following: > > Create a db using Oracle Loaded on an HP Server > - The datafiles, controlfiles, etc will be on EMC > > Later, > Install the oracle binaries on a SUN Server, basically > unplug the HP from the SYMM, and plug in the SUN and > bring up the database. > > I was asked this yesterday because some of the sun > hardware is on back order, and they want to put the > project in production before the parts will arrive. > There is a spare HP server (bought for another > project) they can use until the parts arrive. > > I am awaiting an official response from Oracle, but > thought I would get your input. > > TIA, > Robert Pegram - EDS > Oracle DBA > It will not work. Look at the prerequisite for standby databases, it will give you a fair idea of how far you can go in terms of cross-platform play - not very far. The architecture and OS must be the same. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Table Locks
If they are using DBMS_ALERT then since it uses dbms_lock, it could be possible that the locking problem is one of the application's making (not the database). I can't remember the specifics, but things like a long gap between signalling the alert and the subsequent commit rings a bell as a cause of "locking" problems... hth connor --- K Gopalakrishnan <[EMAIL PROTECTED]> wrote: > What is the PCTFREE setting for the tables? Hope it > is not 0. > > > Here is the quote form one of my article which > explains this behavior > > --BEGIN QUOTE > > Each datablock will have an Interested Transaction > List (ITL) that holds the > transaction id of that block during the life cycle > of the transaction > modifying that datablock. A transaction, which > modifies a record in the > datablock, must get an ITL slot in that datablock. > The number of ITL slots > in a datablock is defined by the INITRANS (which > defaults 1 for data blocks > and 2 for index blocks) and MAXTRANS. > > While formatting a new block Oracle creates the > transaction slots specified > by INITRANS parameter. MAXTRANS specifies maximum > number of ITLs created for > a datablock and it defaults to 255. In practice you > dont need more MAXTRANS > unless your AVG_ROW_LENGTH is very small and the > segment is frequently > updated. > > The creation of additional Interested Transaction > Lists (ITL) slots is > subject to free space in the datablock because each > ITL takes approximately > 24 bytes of free space in the variable header of > that datablock. Initial > space reserved by INITRANS cannot be reused for data > insertion. But if a > datablock is fully packed due to less PCTFREE or > PCTFREE=0 and when two > transactions are accessing the same block, one has > to wait till the > transaction commits (or rollbacks). Here row level > locks are escalated in to > block level locks. > > > ---END > QUOTE--- > > > And I don't see any reason for row locks becoming > table locks unless you > have an un indexed foreign key. > > > Best Regards, > K Gopalakrishnan > Bangalore, INDIA > > > > -Original Message- > Mascranghe > Sent: Tuesday, February 12, 2002 4:33 AM > To: Multiple recipients of list ORACLE-L > > > Hi all > > We are running on 8.0.5.2.1 database. Once we had a > database creash and was > restored. After that the users have been > experiencing locks. What happens is > when one user locks some rows, other users are also > getting stuck. But they > are not locking the same rows. We are looking at the > code to see whether any > unusual things are there. One of the programs in the > system uses DBMS_ALERT. > > > How can we find more information - what rows are > being locked, and any other > relevant info about locks? > > Is there any ways in which a row locks turns out to > be a table lock ? > > Thanks > Alroy > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Alroy Mascranghe > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > _ > Do You Yahoo!? > Get your free @yahoo.com address at > http://mail.yahoo.com > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: K Gopalakrishnan > 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX
Oracle Migration Utility
Can anyone advise me on using the migration utility? We are finally moving from 7.3.4 to 8.1.7. Has the utility worked well for you? Known bugs? Any info greatly appreciated. THe history, if you want to know. We have been stuck at 7.3.4 due to a lack of migration path for OPS on SGI equipment. We are now installing a Sun 4800, and will be ready to start testing the migration in March. Cheers, Fred = Fred Collington Oracle DBA Naval Air Warfare Center, Training Systems Division __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Collington 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: parallel execution
It does, Thanks! RBG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, February 12, 2002 9:44 AM > Ruth, > > You can look in USER_TABLES/DBA_TABLES at the DEGREE column. This will give > you the number of parallel processes to use for the table. It is also in > the USER_INDEXES/DBA_INDEXES view. > > You can set this values by issuing an: Alter table {tablename} parallel 2; > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Tuesday, February 12, 2002 9:14 AM > To: Multiple recipients of list ORACLE-L > > > Good morning all, > > It there a view which tell which tables are in parallel?I would like to > see which table have parallel execution turned on. > > Thanks is advance, > Ruth > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Lite 8i as snapshot site
My probem was, that Oracle Support still does not seem to be able to answer with a simple 'yes' or 'no', wether I can user Oracle Lite as a readonly snapshot site. The Oracle Lite documenation is only talking about EE as a must, but our cutomer has only SE licence. I would need only one way replication ( SE >> Lite ), that is a readonly replication. Tamas Szecsy -Original Message- Sent: Tuesday, February 12, 2002 15:28 To: Multiple recipients of list ORACLE-L Dick - I believe that some replication is available in Standard Edition. My company is looking to put Oracle in remote sites, with some modest replication, and wanted to avoid the licensing penalty of EE. As I read the Oracle document http://technet.oracle.com/products/oracle9i/pdf/o9i_family_features.pdf (table at the bottom), and it says SE has "Basic Replication" and EE has "Advanced Replication". As I understand it, Basic Replication doesn't do multi-master replication, but snapshot replication should be fine. If anyone on the list can correct my understanding, because I certainly don't want to get a nasty Oracle licensing correction. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, February 11, 2002 9:43 PM To: Multiple recipients of list ORACLE-L To use snapshots or replication you need Enterprise edition. Lite is a single user edition for notebooks and the like Dick Goulet Reply Separator Author: Szecsy Tamas <[EMAIL PROTECTED]> Date: 2/11/2002 12:43 AM Hi, I would like to implement readonly replication on Oracle 8i Standard Edition with Oracle Lite 8i snapshot sites. Is Oracle Lite different in any way form Oracle SE what read only replication concerns? Can I run the same scripts for Oracle 8i as if I would use Oracle 8i SE for the sanpshot site or do I have to modify them? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Szecsy Tamas 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: White space compression in Oracle
Well, if you are not able to change CHAR to VARCHAR2, then you can't do compression in Oracle. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
parallel execution
Thanks to everyone who helped me with this problem! Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: parallel execution
Ruth, If you are requesting info on parallel DML operations then you can look at the V$PQ_STSSTAT, V_PQSESSTAT, V$PQ_TQSTAT views that show the parallel executions are running in the database. Also the V$SESSION has a column called PDML_ENABLED to display if parallel DML is enabled for the session. The dba_tables.degree column will tell you the tables that were created with the parallel (degree x) clause. 1 is the default. ROR mª¿ªm >>> [EMAIL PROTECTED] 02/12/02 09:13AM >>> Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)Received: from CONNECT-MTA by galotter 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: Ron Rogers 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).
logon failure auditing
All, I would like to audit all the database users upon logon failure. I know that someone must have been implemented similar kind of auditing. Could you please share your information with me. At the same time I did create new profile and assign it to all the database users. This new profile will lock database users for about 15 Min. after three successful logon failures. Thanks, Bob __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: White space compression in Oracle
Title: White space compression in Oracle Bjørn, Aren't those semantics all host language based? I haven't been working on Pro-X languages for a while, but I seem to recall that there were language options (switches, directives) on how the comparisons were done. Also, you could easily move the data from one data type to another if needed. In fact, in the early days, I remember VARCHAR2 was also blank-padded on output by default and trimmed when storing into the database. Are you referring to more recent ANSI standards? I believe you can still turn off the ANSI semantics if you want. Marc. - Original Message - From: Bjørn Engsig To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 12, 2002 3:18 AM Subject: Re: White space compression in Oracle Marc,There are subtle differences between CHAR and VARCHAR2 when it comes to comparison semantics as CHAR comparisons are blank padded, which VARCHAR2 are not. Thanks, Bjørn.Marc Perkowitz wrote: Beth, Actually, varchar2 is char with the trailing spaces removed. What's the difficulty with switching to varchar2? Does RDB regenerate the white spaces when retrieving the data or something? Generally, everyone uses varchar2 in Oracle. Marc PerkowitzSenior ConsultantTWJ Consulting, LLC 847-256-8866 x15www.twjconsulting.com - Original Message - From: Seefelt, Beth To: Multiple recipients of list ORACLE-L Sent: Monday, February 11, 2002 12:48 PM Subject: White space compression in Oracle Hi everyone, I hope this isn't a silly question, but is there any way to make Oracle compress white space in tables. I come from an RDB environment, and when you have a char(x) field in RDB, you can set the compression attribute on the table and any trailing white space in the char(x) column is compressed. I've found when moving some tables with long char fields to Oracle, the tables take up much more space, I suspect because Oracle is not compressing trailing spaces. Because of other constraints, I'm not able to change the fields to varchar2. Thanks for your help, Beth
RE: White space compression in Oracle
Title: White space compression in Oracle Note VARCHAR and CHAR uses different comparison semantics. With CHAR the shorter one is padded with spaces up to the same length as the longer one and a byte by byte comparison is used. VARCHAR uses a none padded method. -Original Message-From: Marc Perkowitz [mailto:[EMAIL PROTECTED]]Sent: Monday, February 11, 2002 4:40 PMTo: Multiple recipients of list ORACLE-LSubject: Re: White space compression in Oracle Beth, Actually, varchar2 is char with the trailing spaces removed. What's the difficulty with switching to varchar2? Does RDB regenerate the white spaces when retrieving the data or something? Generally, everyone uses varchar2 in Oracle. Marc PerkowitzSenior ConsultantTWJ Consulting, LLC 847-256-8866 x15www.twjconsulting.com - Original Message - From: Seefelt, Beth To: Multiple recipients of list ORACLE-L Sent: Monday, February 11, 2002 12:48 PM Subject: White space compression in Oracle Hi everyone, I hope this isn't a silly question, but is there any way to make Oracle compress white space in tables. I come from an RDB environment, and when you have a char(x) field in RDB, you can set the compression attribute on the table and any trailing white space in the char(x) column is compressed. I've found when moving some tables with long char fields to Oracle, the tables take up much more space, I suspect because Oracle is not compressing trailing spaces. Because of other constraints, I'm not able to change the fields to varchar2. Thanks for your help, Beth
DSD
Title: Message Any good tool to reverse engineer a DSD either from a DDL or from a user that has full access to the schema, but not requiring to be logged in as the schema owner? Michael Cupp, Jr. Shonac Corporation 4150 East Fifth Avenue Columbus Ohio 43219 Phone: 614-238-4240 Fax: 614-238-4203 e-mail: [EMAIL PROTECTED]
Moving Oracle Binaries from HP to SUN
Has anyone done the following: Create a db using Oracle Loaded on an HP Server - The datafiles, controlfiles, etc will be on EMC Later, Install the oracle binaries on a SUN Server, basically unplug the HP from the SYMM, and plug in the SUN and bring up the database. I was asked this yesterday because some of the sun hardware is on back order, and they want to put the project in production before the parts will arrive. There is a spare HP server (bought for another project) they can use until the parts arrive. I am awaiting an official response from Oracle, but thought I would get your input. TIA, Robert Pegram - EDS Oracle DBA __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Pegram 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: script to kill session
Here is a shell script I use in UNIX, restrict_and_kill. I included the sql command to build the sql with the kill commands, killuser_build. It excludes users with restricted session access and puts the database into restricted session mode. You can modify these scripts to suit your needs. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 11, 2002 4:58 PM > Hi, > > We are looking for a script that will grep the sid from v$session and > kill all the sessions of a particular user. The script will prompt the > username and kill all the related sessions. > > Thanks > --Harvinder > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Harvinder 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). restrict_and_kill Description: Binary data killusers_build.sql Description: Binary data
RE: parallel execution
How about DBA_TABLES where degree>1? Best, Sergey -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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).
Upgrading from 8.0.5 to 8.1.7 - Please help
Hello list, I am attempting to upgrade my database from 8.0.5 to 8.1.7. I had the old 8.0.5 database on a SunOS 5.6 database. I performed a full cold-backup of the database. The SA then did a rebuild on the server to upgrade the OS to SunOS 5.8. There is no Oracle software or data on the server now. My question is: Now that I want to go to 8.1.7, do I have to first install 8.0.5 and bring the database up prior to installing 8.1.7 and upgrading, OR ... can I simply install 8.1.7 and perform a migration using 8.1.7 on the old 8.0.5 datafiles? How does this work? Thanks in advance, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith 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: parallel execution
Hi, you should not see for the degree if it is in the HINT, you should see if is turned on for the instance ... there are some parameters like parallel_max_server,... Ciao - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, February 12, 2002 3:13 PM > Good morning all, > > It there a view which tell which tables are in parallel?I would like to > see which table have parallel execution turned on. > > Thanks is advance, > Ruth > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ruth Gramolini > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: claudio cutelli 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: wrong result from select
Hmmm...I've been executing this a script in TOAD, which seems to account for some differences. The really wierd thing in TOAD is that the SELECT acually WORKS CORRECTLY if I insert a COMMENT immediately after the ANALYZE statement! Of course, comments don't make a lick of difference in this for SQL*Plus. Wierd, wierd, wierd. Let us know what you get from your TAR! Thx! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Thanks Rich, But it does not work. One should execute with exactly same order. I you do "where f1 >= 2000 and f1 <= 2001" first, everything works fine (as expected). Here is the last part of the output SQL> select f1 from tb1 where f1 >= 2000 and f1 <= 2000; F1 -- 2000 SQL> select f1 from tb1 where f1 >= 2000 and f1 <= 2001; F1 -- 2000 SQL> select f1 from tb1 where f1 >= 2001 and f1 <= 2000; F1 -- 2001 SQL> drop table tb1; Table dropped. SQL> So far, works properly on 8.1.6.0.0 NT 8.1.6.0.0 32bit Solaris 9.0.1.2 Linux 9.0.1.2 AIX 9.0.1 Solaris does not work on 8.1.7.2.0 64bit HP-UX 8.1.7.2.0 32bit HP-UX 8.1.7.3 Solaris Alex. also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: parallel execution
Ruth, You can look in USER_TABLES/DBA_TABLES at the DEGREE column. This will give you the number of parallel processes to use for the table. It is also in the USER_INDEXES/DBA_INDEXES view. You can set this values by issuing an: Alter table {tablename} parallel 2; Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Table Locks
Sounds like you have run into the much annoying problem of missing foreign key indexes. I would check that out first I think. -Original Message- Mascranghe Sent: Tuesday, February 12, 2002 4:33 AM To: Multiple recipients of list ORACLE-L Hi all We are running on 8.0.5.2.1 database. Once we had a database creash and was restored. After that the users have been experiencing locks. What happens is when one user locks some rows, other users are also getting stuck. But they are not locking the same rows. We are looking at the code to see whether any unusual things are there. One of the programs in the system uses DBMS_ALERT. How can we find more information - what rows are being locked, and any other relevant info about locks? Is there any ways in which a row locks turns out to be a table lock ? Thanks Alroy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe 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: Kimberly Smith 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: Sql question
Thomas, "NOT EXISTS" and "<>" equals "must be at least one" Right ? That's not what Zsolt wants ... :-) -Oorspronkelijk bericht- Van: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 12 februari 2002 14:28 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Sql question Zsolt, Try: select a.something ,c.searchvalue from a, b, c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and c.searchvalue= 'first one' and and not exists(select 1 from c c1 where c1.b1 = c.b1 and c1.b2 = c.b2 and c1.searchvalue<> 'second one') the above presumes that the columns b1 and b2 are part of the identifying columns for the c table. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, February 11, 2002 4:40 PM To: Multiple recipients of list ORACLE-L Hi, I have the following sql: select a.something ,c.searchvalue from a, b, c where a.a= b.a and b.b1= c.b1 and b.b2= c.b2 and c.searchvalue= 'first one' and c.searchvalue<> 'second one' The problem is that if a company has a record with c.searchvalue= 'first one' then the query above list it although it has another record with c.searchvalue= 'second one' To be more precise : I need to get the companies that have searchvalue = 'first one' but I don't want to see companies that has 'second one'. (the main problem is with companies that have both values) Thank you Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco 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: parallel execution
Check the dba_tables there is a column name degree if it is not default ie 1 then parallel executions on that table is turned on -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani 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: parallel execution
dba_tables -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
default DB
Hi, I am new to Oracle DB. There is a m/c where already Oracle 8.1.7. I want to know the following info. a. How to login into Oracle thru sqlplus -how to know login and passwd? b. How to see what are the Databases already created. c. how to create a new Database d. Is there any default database is already present. e. What are the tables in a database. * Is there any step by step document available for a fresher? * Thanks Senthill **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited.
RE: Table Locks
What is the PCTFREE setting for the tables? Hope it is not 0. Here is the quote form one of my article which explains this behavior --BEGIN QUOTE Each datablock will have an Interested Transaction List (ITL) that holds the transaction id of that block during the life cycle of the transaction modifying that datablock. A transaction, which modifies a record in the datablock, must get an ITL slot in that datablock. The number of ITL slots in a datablock is defined by the INITRANS (which defaults 1 for data blocks and 2 for index blocks) and MAXTRANS. While formatting a new block Oracle creates the transaction slots specified by INITRANS parameter. MAXTRANS specifies maximum number of ITLs created for a datablock and it defaults to 255. In practice you dont need more MAXTRANS unless your AVG_ROW_LENGTH is very small and the segment is frequently updated. The creation of additional Interested Transaction Lists (ITL) slots is subject to free space in the datablock because each ITL takes approximately 24 bytes of free space in the variable header of that datablock. Initial space reserved by INITRANS cannot be reused for data insertion. But if a datablock is fully packed due to less PCTFREE or PCTFREE=0 and when two transactions are accessing the same block, one has to wait till the transaction commits (or rollbacks). Here row level locks are escalated in to block level locks. ---END QUOTE--- And I don't see any reason for row locks becoming table locks unless you have an un indexed foreign key. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Mascranghe Sent: Tuesday, February 12, 2002 4:33 AM To: Multiple recipients of list ORACLE-L Hi all We are running on 8.0.5.2.1 database. Once we had a database creash and was restored. After that the users have been experiencing locks. What happens is when one user locks some rows, other users are also getting stuck. But they are not locking the same rows. We are looking at the code to see whether any unusual things are there. One of the programs in the system uses DBMS_ALERT. How can we find more information - what rows are being locked, and any other relevant info about locks? Is there any ways in which a row locks turns out to be a table lock ? Thanks Alroy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: Fragmentation of data dictionary
Title: Fragmentation of data dictionary Helmut, X$ tables are NEVER stored in the disk. THey are just memory structures in the SGA and the contents are zeroed (are reset) when you shutdown the database. THey will not cause data dictionary fragmentation. Best Regards,K GopalakrishnanBangalore, INDIA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Daiminger, HelmutSent: Tuesday, February 12, 2002 5:53 AMTo: Multiple recipients of list ORACLE-LSubject: Fragmentation of data dictionary Hi! I was wondering whether the Oracle data dictionary gets fragmented and whether the dba needs to do something about it. E.g. if granting tons of rights through grants directly to a user (and later revoke them), does the data dictionary get fragmented (i.e. the x$ tables that hold that information)? Would it be beneficial to reorganise the dd (or at least rebuild the indexes)? Same thing with creating tons of temporary tables that are created during a session and get dropped at the end of a session. Does this fragment the dd? This is 8.1.7 on Sun Solaris. Thanks, Helmut
RE: parallel execution
DBA_TABLES.DEGREE? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Gramolini Sent: Tuesday, February 12, 2002 6:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: Oracle Lite 8i as snapshot site
Dick - I believe that some replication is available in Standard Edition. My company is looking to put Oracle in remote sites, with some modest replication, and wanted to avoid the licensing penalty of EE. As I read the Oracle document http://technet.oracle.com/products/oracle9i/pdf/o9i_family_features.pdf (table at the bottom), and it says SE has "Basic Replication" and EE has "Advanced Replication". As I understand it, Basic Replication doesn't do multi-master replication, but snapshot replication should be fine. If anyone on the list can correct my understanding, because I certainly don't want to get a nasty Oracle licensing correction. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, February 11, 2002 9:43 PM To: Multiple recipients of list ORACLE-L To use snapshots or replication you need Enterprise edition. Lite is a single user edition for notebooks and the like Dick Goulet Reply Separator Author: Szecsy Tamas <[EMAIL PROTECTED]> Date: 2/11/2002 12:43 AM Hi, I would like to implement readonly replication on Oracle 8i Standard Edition with Oracle Lite 8i snapshot sites. Is Oracle Lite different in any way form Oracle SE what read only replication concerns? Can I run the same scripts for Oracle 8i as if I would use Oracle 8i SE for the sanpshot site or do I have to modify them? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
parallel execution
Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: wrong result from select
It works fine in 8.1.6.0.0, Sun Solaris 2.6: SQL*Plus: Release 8.1.7.0.0 - Production on Tue Feb 12 09:01:22 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Release 8.1.6.0.0 - Production JServer Release 8.1.6.0.0 - Production SQL> set echo on SQL> alter session set optimizer_mode=choose; Session altered. SQL> alter session set cursor_sharing=force; Session altered. SQL> create table tb1 (f1 number(4)); Table created. SQL> insert into tb1 values (1999); 1 row created. SQL> insert into tb1 values (2000); 1 row created. SQL> insert into tb1 values (2001); 1 row created. SQL> insert into tb1 values (2002); 1 row created. SQL> commit; Commit complete. SQL> select * from tb1; F1 -- 1999 2000 2001 2002 SQL> analyze table tb1 compute statistics; Table analyzed. SQL> select f1 from tb1 where f1 between 2000 and 2000; F1 -- 2000 SQL> select f1 from tb1 where f1 between 2000 and 2001; F1 -- 2000 2001 SQL> select f1 from tb1 where f1 between 2001 and 2000; no rows selected SQL> drop table tb1; Table dropped. SQL> This is the output on 8.1.7.0.0, Sun Solaris 2.6: SQL*Plus: Release 8.1.7.0.0 - Production on Tue Feb 12 09:03:48 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL> set echo on SQL> alter session set optimizer_mode=choose; Session altered. SQL> alter session set cursor_sharing=force; Session altered. SQL> create table tb1 (f1 number(4)); Table created. SQL> insert into tb1 values (1999); 1 row created. SQL> insert into tb1 values (2000); 1 row created. SQL> insert into tb1 values (2001); 1 row created. SQL> insert into tb1 values (2002); 1 row created. SQL> commit; Commit complete. SQL> select * from tb1; F1 -- 1999 2000 2001 2002 SQL> analyze table tb1 compute statistics; Table analyzed. SQL> select f1 from tb1 where f1 between 2000 and 2000; F1 -- 2000 SQL> select f1 from tb1 where f1 between 2000 and 2001; F1 -- 2000 2001 SQL> select f1 from tb1 where f1 between 2001 and 2000; no rows selected SQL> drop table tb1; Table dropped. SQL> "Jesse, Rich" wrote: > Same result on 8.1.7.2 32bit on HP 11.0. The good news is that the correct > result is obtained using "...where f1 >= 2000 and f1 <= 2001". > > Is anyone using 8.1.7.3 on HP/UX 11 to test this? > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 4:58 PM > To: Multiple recipients of list ORACLE-L > > Hi, > Can anybody try this on 9i? > set echo on > alter session set optimizer_mode=choose; > alter session set cursor_sharing=force; > create table tb1 (f1 number(4)); > insert into tb1 values (1999); > insert into tb1 values (2000); > insert into tb1 values (2001); > insert into tb1 values (2002); > commit; > select * from tb1; > analyze table tb1 compute statistics; > select f1 from tb1 where f1 between 2000 and 2000; > select f1 from tb1 where f1 between 2000 and 2001; > select f1 from tb1 where f1 between 2001 and 2000; > drop table tb1; > Here is what I got on 8.1.7.2.1 64bit on HP-UX 11.0: > SQL> select * from tb1; > F1 > -- > 1999 > 2000 > 2001 > 2002 > SQL> select f1 from tb1 where f1 between 2000 and 2000; > F1 > -- > 2000 > SQL> select f1 from tb1 where f1 between 2000 and 2001; > F1 > -- > 2000 > SQL> select f1 from tb1 where f1 between 2001 and 2000; > F1 > -- > 2001 > TIA > Alex. > PS. What about cursor_sharing=similar ? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Die
Fragmentation of data dictionary
Title: Fragmentation of data dictionary Hi! I was wondering whether the Oracle data dictionary gets fragmented and whether the dba needs to do something about it. E.g. if granting tons of rights through grants directly to a user (and later revoke them), does the data dictionary get fragmented (i.e. the x$ tables that hold that information)? Would it be beneficial to reorganise the dd (or at least rebuild the indexes)? Same thing with creating tons of temporary tables that are created during a session and get dropped at the end of a session. Does this fragment the dd? This is 8.1.7 on Sun Solaris. Thanks, Helmut
Re: high tkprof parse counts == real # of hard parses?
[Bjørn Engsig] >Admittedly, I am no JDCB expert, but I wouldn't expect to see the >behaviour you see, in particular that each insert seems to produce a >soft parse. Do you have a non-cached sequence? If you do, that's >your reason - recursive SYS SQL is (almost) never cached, so your >update to seq$ will be soft parsed for each use of a non-cached >sequence number. Yes, the sequence has a cache of 1000 values right now (the table gets a good number of rows added :) The behavior that I'm seeing across my stored procedures is that even my non-SYS recursive sql isn't being cached (the soft parses are still happening). Admittedly, there's very little looping going on (like the previous procedure that just does the insert-returning/commit), but the soft parse on each exec is still bad. >I would suggest you run your session with event 10046 traceing turned >on. I did, level 12 - that's why the itrprof output has information on wait events. I didn't include the bind information in the itrprof because it 1) didn't appear to be relevant 2) kept the size of the itrprof much more reasonable. If there are different itrprof options that would be more helpful, I still have the raw trace around and would be happy to re-run it. Thanks! -- James Manning <[EMAIL PROTECTED]> GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning 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).