Re: Problem with understanding Optimization methods.
Hi Jonathan, What release did this NULL_CHECK start with? I used to see: Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1 Card=1 Bytes=6) 1 0 TABLE ACCESS (FULL) OF 'T1' (Cost=1 Card=1 Bytes=6) As I recall, I used-to need an FBI on column with NULL values create index i1 on t1 (nvl(n1,'null')) ; Regards, Donald K. Burleson www.dba-oracle.com www.remote-dba.net - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 8:14 AM > > Conversely, the CBO is a lot smarter with > this scenario that people realise. How many > people knew that Oracle can resolve a query > of the type: > where colX is null > using a b-tree index ? > > Try this -- > > drop table t1; > > create table t1 (n1 number, n2 number not null, n3 number); > create index i1 on t1 (n1, n2); > > set autotrace traceonly explain > select /*+ first_rows */ * from t1 where n1 is null; > set autotrace off > > Execution Plan > -- >0 SELECT STATEMENT Optimizer=HINT: FIRST_ROWS (Cost=4 Card=4 > Bytes=156) >10 TABLE ACCESS (BY INDEX ROWID) OF 'T1' (TABLE) (Cost=4 Card=4 > Bytes=156) >21 INDEX (RANGE SCAN) OF 'I1' (INDEX) (Cost=4 Card=4) > > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > The educated person is not the person > who can answer the questions, but the > person who can question the answers -- T. Schick Jr > > > Next public appearance2: > March 2004 Hotsos Symposium - Keynote > March 2004 Charlotte NC - OUG Tutorial > April 2004 Iceland > > > One-day tutorials: > http://www.jlcomp.demon.co.uk/tutorial.html > > > Three-day seminar: > see http://www.jlcomp.demon.co.uk/seminar.html > UK___February > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, January 08, 2004 11:54 AM > > > Bambi, > > Yes it is expected behaviour, but only when it is guaranteed that no rows > will be missed because of unindexed null entries. > I wanted to point out that RBO is too "dumb" to realize that even though it > ordered by column A which could be null, the column B in composite index was > not null, thus causing every row to be indexed and RBO didn't use the index. > > Tanel. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jonathan Lewis > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Burleson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Should we stop analyzing?
Hi Nuno, > > Do they clone the production database, change the statistics, prove that the > > system can complete it's batch job in 8 hours, then install ? I doubt it. > > Exactly my point above. Not feasible. So, what's the alternative? You hit the Nail on the head here, Nuno. The central questions about stats changes are: 1- How can I list the changes to execution plans after re-analysis, A Priori? 2 - How do I justify the risk (and server expense) of re-analyzing? Some alternatives might be: 1 - Enhance the dbms_stats "auto" option (monitoring) to make it more intelligent. Wouldn't it be nice if dbms_stats could do an "incremental" refresh, tracking ONLY stats changes that might make a difference to execution plan: a) Changes to clustering_factor b) Changes to column skew. Only create histograms when column is skewed AND SQL uses the column. The 10g workload tool "claims" to do some of this. c) Changes to highest-lowest values of key indexes, etc. 2- Devise a method where new stats can be collected, stored and compared against historical SQL (from stats$sql_summary) a) Allow for dbms_stats to collect, store and compare changes to historical execution plans, using historical SQL from STATSPACK (or new 10g workload views) b) Allow the DBA control about whether to implement the new statistics > itwouldhavehelpediftheyhadfixedthecodebackin7/8/9insteadofdelivering > aseriesofpatchesasnewreleasesthattotallyconfusedeverybodyaboutitsoperation Yes! IME, there ARE still problems in the CBO, especially with complex subqueries. I have more than a dozen systems where management insists on staying with the RBO! Every time we collect deep stats and histogram and switch optimizer_mode, hundreds of statements generate poor plans. It would cost these clients many thousands of dollars to have adjusted these plans, and management says "If it ain't broke, why fix it". We need look no further than Oracle Applications to see this issue. Oracle made a big-deal about going to the CBO in 11i, yet when we look at the SQL, a significant number of statement employ the "rule" hint! Connect-the-dots and you can guess why the RBO IS NOT being removed from Oracle10g. . . . JMHO. . . . Regards, Donald K. Burleson www.dba-oracle.com www.remote-dba.net - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 5:19 AM > - Original Message - > > > The issue here is that very few people understand how the CBO > > works, or what the statistics do, or how to use them properly. > > And a seriously *big* component of that problem is that Oracle keeps > changing/patching/modifying the CBO and how it reacts to > certain combinations of information, on EVERY SINGLE point > version! It's virtually impossible for a typical DBA to find the > time to fully test all the combinations and find out what works where > and how. Hence why this type of thread becomes so useful. > > > Do they clone the production database, change the statistics, prove that the > > system can complete it's batch job in 8 hours, then install ? I doubt it. > > Exactly my point above. Not feasible. So, what's the alternative > given that: > > 1- the information in Oracle's own doco is far from complete or > covering all bases? > > 2- the CBO like any other piece of code, is sometimes buggy? > > 3- You, Don, SA, and so many others who have the time to investigate > this may in turn not have the time to produce the detailed doco that is > needed to understand how the CBO works in all situations? > > > > Is dynamic sampling the solution? I don't think so: if anything, it will > enhance/increase the problems caused by 1 and 2. > > > > approach, while the 10g developers are pissed that the CBO has been getting > > a bum-rap because of crappy statistics. > > itwouldhavehelpediftheyhadfixedthecodebackin7/8/9insteadofdelivering > aseriesofpatchesasnewreleasesthattotallyconfusedeverybodyaboutitsoperation > > Cheers > Nuno Souto > [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Nuno Souto > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name o
Re: Should we stop analyzing?
Jonathan, Good point about the "change-control" issue. When we consider that re-analyzing stats can cause huge changes to data access patterns Im continuously amazed at the number of shops that re-analyze on a schedule and have the Monday Morning syndrome. I have worked for shops where they must certify every change, no matter how trivial. Mostly banks and medical systems. These certified shops are stuck. On one hand, they are obligated to follow the best-practices of their vendor, yet obligated not to make any untested changes in production. Even Oracle is schizophrenic on the issue; my contacts in the real-world performance group are zealously in favor of the take one deep sample approach, while the 10g developers are pissed that the CBO has been getting a bum-rap because of crappy statistics. Personally, I love the automatic histogram generation skewonly and the auto option in dbms_stats, and use it for all my 9ir2 clients. However, I remain skeptical about the benefits of dynamic sampling and workload analysis automation tools for most shops. In my experience, the vast majority of shops DO NOT benefit from re-analysis, and Ive got shops where re-analysis NEVER results in CBO changes. Regards, Donald K. Burlesonwww.dba-oracle.comwww.remote-dba.net - Original Message - From: "Jonathan Lewis" <[EMAIL PROTECTED]> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 31, 2003 1:34 AM Subject: Re: Should we stop analyzing? > > This makes Oracle's position with 10g interesting,> given that the default behaviour is to collect statistics> all over the place automatically. If it's built in by> the supplier, does it count as a change ?> > Jared's point is valid - in theory, if you keep statistics> up to date, then the CBO should produce the> optimum plan; if you fail to keep statistics up to> date, the CBO plans can cease to be optimal, or> may change to become sub-optimal. Moreover,> in theory, if a plan changes on a change of statistics,> it will be a better, or at worst equal cost, plan with> at worst no change in performance. Of course, in> the real world, we know that there are various> reasons why things go wrong at the boundary points> between plans, which is why we like to stick the> statistics down well within our preferred boundary.> > Of course, following your argument about change> control to its logical conclusion, since a change in the> data may change execution plans, which may introduce> untested portions of Oracle code, any data change> should also be subject to change control.> > Despite any whimsical arguments, though, your basic> premise is the important one. You need to know the> application to do the job correctly. If you know> how the data evolves, you will know how to get> the minimum amount of work done that allows the> optimizer to do its job well.> > > Regards> > Jonathan Lewis> http://www.jlcomp.demon.co.uk> > The educated person is not the person> who can answer the questions, but the> person who can question the answers -- T. Schick Jr> > > One-day tutorials:> http://www.jlcomp.demon.co.uk/tutorial.html> > > Three-day seminar:> see http://www.jlcomp.demon.co.uk/seminar.html> UK___November> > > The Co-operative Oracle Users' FAQ> http://www.jlcomp.demon.co.uk/faq/ind_faq.html> > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> Sent: Tuesday, December 30, 2003 11:44 PM> > > >> > At 03:29 PM 12/30/2003, you wrote:> > >But then again, if re-collecting statistics causes your database> performance> > >to suddenly become very bad, it seems at first cut there are only two> > >conclusions> > >you can come to.> > >> > >1) CBO is broke if fresh statistics result in poor performance> >> > That a plan changes due to changes in the statistics doesn't mean that the> > CBO is broke. That's the whole name of the game. The optimizer uses> > statistics - together with initialization parameters, heuristics and> rules> > - to develop the anticipated best access path. If you change any of these,> > statistics by analyzing, initialization parameters by changes to the> > init.ora, or heuristics and rule by upgrading to a new version or applying> > a patch. I regard any of these changes as serious changes to the database> > which should go through a test and acceptance cycle. And that includes> > refreshing statistics. I am constantly amazed how nonchalantly most shops> > schedule daily,
Job question
Metro One Telecommunications (Beaverton, Oregon) keeps advertising for an Oracle DBA. Any idea what is going on there that they can't seem to hang on to folks? I see that their stock price has has dropped to almost worthless. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Should we stop analyzing?
ity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Burleson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Client-server Forms6i against Oracle 9i (9.2.0.4) database?
Is it possible to run Forms6i in client-server mode against an Oracle 9.2.0.4 database? One of the developers where I work flatly states that Forms 6i (in any mode) doesn't work against (any) Oracle 9i and I cannot find any specific information either confirming or denying this assertion. Searches on Metalink and Google both came up with nothing of relevance. I would assume that with an Oracle8i client it shouldn't be a problem, but I haven't worked with Forms at all since v3.0 and she is adamant that it is simply impossible - with no explanation of why. Don Granaman - OraSaurus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Questiuon about unix
Try this as following: cat yourfile | awk -F; ' ( $4 == "") { print $0 }' # $4 means your field number from beginning; $0 means whole line. Good luck! Don [EMAIL PROTECTED] wrote: > Hallo everybody, > > anyone whom can tell me what the command is to search for an empty field in a unix > file. > > for instance if you want to find the empty spacelines if some lines looklike: > > 1;100;Name;; > 2;200;Test;45; > 3;300;Name;; > > I would like to find out line nr 1 and 3 here above. Anyone whom could suggest any > good? > > Maybe this sounds simple but I have tried with /;; and cant find it. If iI use that > command then I will get lines with ;; and i just want lines with two ;; > > Thanks in advance > > Roland > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: UNIX : script help/input
Johan: Please see the attachment file, which is my script for everyday web server log file and uses nslookup to process the results. Hope that it is helpful. Don Johan Muller wrote: > Anybody with a quick and dirty (elegant would be nice too), to munge > output from a nslookup output file to a delimited file? > > 'File content: > > Server: dns1.mci.com > Address: 199.249.19.1 > > Name:WCOM-4NXZGAPWY5.mcilink.com > Address: 166.50.73.209 > > Delimited file should have the following line(s); (using | or > whatever as delimiter): > > '166.50.73.209'|'4NXZGAPWY5.mcilink.com'. > > Required for both single and multiple records. > > > > TIA #! /bin/ksh # file name: log_file_parsing # Date: March 6,2003; Mar 7,2003; Mar 10,2003; Mar 13,2003; May 7,2003; 12 May,2003; May 15,2003; # May 20,2003; May 30,2003 # # Author: Don Y. # Desc: an example of parsing netTracker related web access from web server (www.welch.jhu.edu) access # log file. Extract client IP, access date, and host IP. This script also transfer client IP # with alphabet into digital one by issuing nslookup command call. Finally make nslookup work # for it outputs a few lines instead of one line. # # define output file WORKING_DIR=$1 OUTPUT_FILE="$WORKING_DIR/log_file_parsing_output.temp" INPUT_FILE=$WORKING_DIR/$2 TEMP_NAME=$3 SCRIPT_HOME="/export/users/dony/report" # check input access log file exists or not under $WORKING_DIR if [ ! -f $WORKING_DIR/$2 ] then echo "input access log file doesn't exist at working directory!" exit 1 fi # check output file under working directory exist or not : $WORKING_DIR/log_file_parsing_output.temp if [ ! -f $WORKING_DIR/log_file_parsing_output.temp ] then touch $WORKING_DIR/log_file_parsing_output.temp chown dony:staff $WORKING_DIR/log_file_parsing_output.temp fi # check all temporary files exist or not if [ -f $WORKING_DIR/log_file_parsing_temp01.temp ] then rm $WORKING_DIR/log_file_parsing_temp01.temp else # create an empty file with owner status: dony:staff touch $WORKING_DIR/log_file_parsing_temp01.temp chown dony:staff $WORKING_DIR/log_file_parsing_temp01.temp fi if [ -f $WORKING_DIR/log_file_parsing_temp02.temp ] then rm $WORKING_DIR/log_file_parsing_temp02.temp else touch $WORKING_DIR/log_file_parsing_temp02.temp chown dony:staff $WORKING_DIR/log_file_parsing_temp02.temp fi # file parsing for NetTracker associated lines success=0 cat $INPUT_FILE | grep "/cgi-bin/ntlinktrack.cgi" | awk '{print $1,substr($4,2,11),$7}' | sed 's/\/cgi-bin\/ntlinktrack.cgi?//' > $WORKING_DIR/log_file_parsing_temp01.temp let success=success+$? sed 's/http:\/\/www.welch.jhu.edu\/cgi-bin\/ntlinktrack.cgi?//' $WORKING_DIR/log_file_parsing_temp01.temp > $WORKING_DIR/log_file_parsing_temp02.temp let success=success+$? # get start line number here whole_parsing_start_line=`cat $OUTPUT_FILE | wc -l` # change the date format for arg_each_line in `cat $WORKING_DIR/log_file_parsing_temp02.temp | awk '{ print $1"==="$2"==="$3 }'` do one_line=`echo $arg_each_line | sed 's/===/ /g'` # debug one line below if enabled #echo $one_line >> $WORKING_DIR/log_file_parsing_temp03.temp client_ip=`echo $one_line | awk '{ print $1 }' | sed 's/ //g'` org_date=`echo $one_line | awk '{ print $2 }' | sed 's/ //g'` oracle_date=`$SCRIPT_HOME/ldate $org_date` host_ip=`echo $one_line | awk '{ print $3 }' | sed 's/ //g'` # transfer client_ip from alphabet to digital client_addr=`echo "$client_ip" | egrep -i -e [a-z] | sed 's/ //g'` # get the length of client_addr LENGTH=`expr "$client_addr" : '.*'` if [ $LENGTH -gt 8 ] then # add pattern of [1-9][1-9] for parsing since nslookup output might be changed /usr/sbin/nslookup $client_addr 2> $WORLING_DIR/$TEMP_NAME | awk '{ print $2 }' | egrep -e [0-9]'.'[0-9]'.' > nslookup_result NSR_LINES=`cat nslookup_result | wc -l` if [ $NSR_LINES -eq 2 ];then client_digit=`cat nslookup_result 2> $WORLING_DIR/$TEMP_NAME | awk '( NR == 2 ) { print $0 }'` elif [ $NSR_LINES -eq 3 ];then client_digit=`cat nslookup_result 2> $WORLING_DIR/$TEMP_NAME | awk '( NR == 3 ) { print $0 }'` fi # remove the result file rm nslookup_result 2> $WORLING_DIR/$TEMP_NAME # check whether or not the nslookup command gets a result,which it
Re: Job to run first Wednesday
I think that if this schedule job is on unix platform, the cron job is easy one. You only need to write a short script. Also in windows OS you can schedule a job there. Don [EMAIL PROTECTED] wrote: > Rachel, > > The assumption is that the current day is already >= the first wednesday > of the month, > making it useful for the dbms_job interval. > > Did you read the specs? :) > > Jared > > Rachel Carmichael <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/22/2003 01:14 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: Job to run first Wednesday > > don't rush off to use it. I tried it, substituting August 1 and got > September. > > 1* select > next_day(last_day(to_date('08/01/2003','MM/DD/')),'WED') from dual > SQL> / > > NEXT_DAY( > - > 03-SEP-03 > > --- [EMAIL PROTECTED] wrote: > > Hmm... much more elegant than mine, and everyone elses. > > > > Guess I better RTFM the next_day function. > > > > > > > > > > > > > > "Mercadante, Thomas F" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 07/22/2003 12:34 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Job to run first Wednesday > > > > > > Josh, > > > > With the following functions, you could probably get it to work: > > > > select next_day(last_Day(sysdate),'WED') from dual > > > > This (today) returns Wed, August 6th. > > > > Tom Mercadante > > Oracle Certified Professional > > > > > > -Original Message- > > Sent: Tuesday, July 22, 2003 3:14 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Greetings, > > > > How can I set the interval in my dbms job to have it run on the first > > Wednesday of every month? Is this even possible? I have been trying > > to > > noodle it thru for a week to no avail. > > > > tia, > > > > Josh > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Josh Collier > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mercadante, Thomas F > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > __ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site
Re: urgent Help!! FYI
Matthew, Yes. After I execute script as "lsnrctl start" by oracle, everything is the same to my original. But before I try to execute this script as root. I think that I make a big mistake. Many thanks! Don Matthew Zito wrote: > Also, it looks like you're starting the listener as root. Try doing it > as oracle. > > Matt > > -- > Matthew Zito > GridApp Systems > Email: [EMAIL PROTECTED] > Cell: 646-220-3551 > Phone: 212-358-8211 x 359 > http://www.gridapp.com > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Goulet, Dick > > Sent: Friday, July 18, 2003 3:24 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: urgent Help!! FYI > > > > > > In your listener.ora file add the line > > "logging_listener=off". Otherwise make sure > > $ORACLE_HOME/network/log exists and is writable by the Oracle user. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -Original Message- > > Sent: Friday, July 18, 2003 4:10 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi, > > > > I need somebody here to help me to start my Oracle listener > > for my Oracle server was power off this morning. Here, when I > > run the lsncrtl start, I get an error message. Please see the > > following message: > > > > # ./lsnrctl start > > > > LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on > > 18-JUL-2003 15:20:10 > > > > Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. > > > > Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... > > > > TNSLSNR for Solaris: Version 9.2.0.1.0 - Production > > NL-00280: error creating log stream > > /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log > > NL-00278: cannot open log file > > SNL-00016: snlfohd: error opening file > >Solaris Error: 13: Permission denied > > > > Listener failed to start. See the error message(s) above... > > > > Can somebody tell me how to start my Oracle listener? Any > > suggestion are highly appreciated! Many thanks! > > > > > > Don > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Don Yu > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of mailing list you want to be removed > > from). You may also send the HELP command for other > > information (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Goulet, Dick > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (or the name of mailing list you want to be removed > > from). You may also send the HELP command for other > > information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Matthew Zito > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!! FYI
Freeman, Before I change it, listener.ora property is like the following: $ls -al listener.ora -rw-rw-r-- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log After I change it by the following steps, it works fine. $chmod 666 listener.ora lsnrctl start Now Oracle listener starts up. Thank you very much! Don Freeman Robert - IL wrote: > In OH/network/log is there a listener.log file? Who owns it? Who are you > starting the listener as and does that ID have rights to write to the > listener.log? > > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 7/18/2003 3:09 PM > > Hi, > > I need somebody here to help me to start my Oracle listener for my > Oracle server was power off this morning. Here, when I run the lsncrtl > start, I get an error message. Please see the following message: > > # ./lsnrctl start > > LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 > 15:20:10 > > Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. > > Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... > > TNSLSNR for Solaris: Version 9.2.0.1.0 - Production > NL-00280: error creating log stream > /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log > NL-00278: cannot open log file > SNL-00016: snlfohd: error opening file >Solaris Error: 13: Permission denied > > Listener failed to start. See the error message(s) above... > > Can somebody tell me how to start my Oracle listener? Any suggestion are > highly appreciated! > Many thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Freeman Robert - IL > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!! FYI
Dick, It works now after I change the $ORACLE_HOME/network/log/listener.ora to like following: $ls -al listener.log -rw-rw-rw- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log But before the parameter is like following: $ls -al listener.log -rw-rw-r-- 1 oracle oinstall 1732613 Jul 18 16:02 listener.log I just don't know is this file property changed or not? If changed, who changed it. But before power off, it works fine. Thank you very much again! Don "Goulet, Dick" wrote: > In your listener.ora file add the line "logging_listener=off". Otherwise make sure > $ORACLE_HOME/network/log exists and is writable by the Oracle user. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, July 18, 2003 4:10 PM > To: Multiple recipients of list ORACLE-L > > Hi, > > I need somebody here to help me to start my Oracle listener for my > Oracle server was power off this morning. Here, when I run the lsncrtl > start, I get an error message. Please see the following message: > > # ./lsnrctl start > > LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 > 15:20:10 > > Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. > > Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... > > TNSLSNR for Solaris: Version 9.2.0.1.0 - Production > NL-00280: error creating log stream > /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log > NL-00278: cannot open log file > SNL-00016: snlfohd: error opening file >Solaris Error: 13: Permission denied > > Listener failed to start. See the error message(s) above... > > Can somebody tell me how to start my Oracle listener? Any suggestion are > highly appreciated! > Many thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Goulet, Dick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!! FYI
Dick, Before this morning power off, everything is fine with my Oracle server. I think this might be something related to autostart because my solaris server is down. But I will try it. Thanks! Don "Goulet, Dick" wrote: > In your listener.ora file add the line "logging_listener=off". Otherwise make sure > $ORACLE_HOME/network/log exists and is writable by the Oracle user. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Friday, July 18, 2003 4:10 PM > To: Multiple recipients of list ORACLE-L > > Hi, > > I need somebody here to help me to start my Oracle listener for my > Oracle server was power off this morning. Here, when I run the lsncrtl > start, I get an error message. Please see the following message: > > # ./lsnrctl start > > LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 > 15:20:10 > > Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. > > Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... > > TNSLSNR for Solaris: Version 9.2.0.1.0 - Production > NL-00280: error creating log stream > /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log > NL-00278: cannot open log file > SNL-00016: snlfohd: error opening file >Solaris Error: 13: Permission denied > > Listener failed to start. See the error message(s) above... > > Can somebody tell me how to start my Oracle listener? Any suggestion are > highly appreciated! > Many thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Goulet, Dick > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Instances not starting up via services
Niall, Could you please be more detail in step by step for this is my first time to meet my Oracle power off! Thanks! Don Niall Litchfield wrote: > Connect through the listener/tnsnames will work, then startup > pfile=. Its just the bequeath protocol that doesn't work. > Or net start oracleservice if the instance is set to autostart > with the service. > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of [EMAIL PROTECTED] > > Sent: 18 July 2003 01:59 > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Oracle Instances not starting up via services > > > > > > So, how are you starting up instances via Terminal Services? > > > > I haven't tried to make that work yet. > > > > Though I do get highly annoyed with myself when I forget I'm > > in termserver and not pcanywhere, and can't start a database. > > > > Jared > > > > > > > > > > > > "Niall Litchfield" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 07/17/2003 04:14 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Oracle Instances not starting up > > via services > > > > > > I didn't see the original message, but I'll get cannot open > > '%oracle_home%/database/init%oracle_sid%.ora" everytime if > > using terminal services to start the instance. Is this via a > > ts session or actually at the console? > > > > Er, Obviously I never forget to type pfile=. Though. Me, > > I'm professional > > > > Niall > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > > Behalf Of Nuala Cullen > > > Sent: 17 July 2003 12:24 > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: Oracle Instances not starting up via services > > > > > > > > > Hi Jose, > > > > > > I've tried twice to send you the information but the mailing > > > list has decided that it contains a 'virus signature' and > > > rejects the email. > > > > > > So can you let me know specially what you are looking for and > > > I will send you those values. > > > > > > Thanks, > > > N. > > > > > > :->-Original Message- > > > :->From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] :->Behalf Of :->Jose Luis Delgado > > > :->Sent: 16 July 2003 16:49 > > > :->To: Multiple recipients of list ORACLE-L > > > :->Subject: RE: Oracle Instances not starting up via services > > > :-> :-> :->Nuala... :-> > > > :->1.- can you send your environment variables? (my_pc -> > > > :->properties -> advanced -> environment variables) :-> > > > :->2.- can you send your Oracle registry values? > > > :-> > > > :->JL > > > :-> > > > :->--- Nuala Cullen <[EMAIL PROTECTED]> wrote: > > > :->> > > > :->> Hi Jared, > > > :->> > > > :->> Thanks for the advice, > > > :->> > > > :->> I checked out the registry settings > > > :->> ORA_WMS_PFILE is set to > > > :->> c:\oracle\ora81\database\initwms.ora. > > > :->> ORA_WMS_AUTOSTART is set to TRUE. > > > :->> > > > :->> I'm a bit confused what you mean by using variables. > > > :->> I think you mean not to use %oracle_home% etc but > > > :->> the error message: > > > :->> > > > :->> "LRM-00109 can not open parameter file > > > :->> '%oracle_home%/database/init%oracle_sid%.ora" > > > :->> is as it appeared on the screen. > > > :->> > > > :->> N. > > > :->> > > > :->> > > > :->> :->-Original Message- > > > :->> :->From: Jared Still [mailto:[EMAIL PROTECTED] > > > :->> :->Sent: 16 July 2003 14:31 > > > :->> :->To: [EMAIL PROTECTED]; Nuala Cullen > > > :->> :->Subject: Re: Oracle Instances not starting up via > > > :->> services > > > :->> :-> > > > :->> :-> > > > :->> :-> > > > :->&g
urgent Help!! FYI
Hi, I need somebody here to help me to start my Oracle listener for my Oracle server was power off this morning. Here, when I run the lsncrtl start, I get an error message. Please see the following message: # ./lsnrctl start LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 18-JUL-2003 15:20:10 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Starting /u01/app/oracle/product/9.2.0.1.0/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 9.2.0.1.0 - Production NL-00280: error creating log stream /u01/app/oracle/product/9.2.0.1.0/network/log/listener.log NL-00278: cannot open log file SNL-00016: snlfohd: error opening file Solaris Error: 13: Permission denied Listener failed to start. See the error message(s) above... Can somebody tell me how to start my Oracle listener? Any suggestion are highly appreciated! Many thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 can I turn Oracle listener on for Oracle 9i on solaris - FYI
Hi, My servers are power off. Now I get the power and start them up. I would like to know how to start Oracle 9.2 listener on Solaris platform so that my program can talk to it. Any suggestions are appreciated! Thanks in advance! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: shell question
Please see the following text, which comes from my shell script: for arg_each_line in `cat $WORKING_DIR/log_file_parsing_temp02.temp | awk '{ pri nt $1"==="$2"==="$3 }'` do one_line=`echo $arg_each_line | sed 's/===/ /g'` # debug one line below if enabled #echo $one_line >> $WORKING_DIR/log_file_parsing_temp03.temp client_ip=`echo $one_line | awk '{ print $1 }' | sed 's/ //g'` org_date=`echo $one_line | awk '{ print $2 }' | sed 's/ //g'` oracle_date=`$SCRIPT_HOME/ldate $org_date` host_ip=`echo $one_line | awk '{ print $3 }' | sed 's/ //g'` # transfer client_ip from alphabet to digital client_addr=`echo "$client_ip" | egrep -i -e [a-z] | sed 's/ //g'` # get the length of client_addr LENGTH=`expr "$client_addr" : '.*'` .. done Hope that it is helpful! Don [EMAIL PROTECTED] wrote: > > hi all , > > how can I read a text file and print line by line. > > Rgds. > Arslan. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 make SPFILE in sync with INIT.ORA ?
Arup, Thank you very much. It works fine now. But my Oracle database instance name is bluejayt not ORCL. See the following message: $ ps -ef | grep bluejayt oracle 5796 1 0 13:01:08 ?0:00 ora_s000_bluejayt oracle 5790 1 0 13:01:08 ?0:00 ora_reco_bluejayt oracle 5800 5774 0 13:01:13 ?0:03 oraclebluejayt (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 5788 1 0 13:01:08 ?0:01 ora_smon_bluejayt oracle 5804 5735 0 13:07:17 pts/20:00 grep bluejayt oracle 5798 1 0 13:01:08 ?0:00 ora_d000_bluejayt oracle 5784 1 0 13:01:08 ?0:00 ora_lgwr_bluejayt oracle 5786 1 0 13:01:08 ?0:00 ora_ckpt_bluejayt oracle 5794 1 0 13:01:08 ?0:02 ora_qmn0_bluejayt oracle 5792 1 0 13:01:08 ?0:00 ora_cjq0_bluejayt oracle 5782 1 0 13:01:07 ?0:00 ora_dbw0_bluejayt oracle 5780 1 0 13:01:07 ?0:00 ora_pmon_bluejayt Thank you very much again! Don Arup Nanda wrote: > Well, I thought I answered your question earlier. Here are the steps, in > more detail. > > I assume your database instance name is ORCL; replace with the actual. > > (1) With your database open, issue a command as sys > SQL> create pfile from spfile. > (2) Go to the directory $ORACLE_HOME/dbs and make sue the timestamp of teh > file initORCL.ora file is now. > (3) Open the file and place the line audit_trail=db, if not already there. > (4) Shutdown the database. > (5) Restart > SQL> startup pfile=$ORACLE_HOME/dbs/initORCL.ora > (6) Make sure the audit trail is set. > SQL> show parameter audit_trail. > (7) resynch the SPfile. > SQL> create spfile from pfile; > (8) And, please let us know here if they worked. If any error occurs, copy > and paste the error here. > > HTH. > > Arup Nanda > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, July 17, 2003 11:19 AM > > > Hi, > > > > I really need some helps to configure my database with audit_trail option. > I > > have tried some but fail so far. My database is Oracle 9.2. I have read > all > > email related to spfile. Can somebody provides simple steps for me to > update my > > specified initialization parameter in init.ora? > > (1) Manually change the initialization parameter, e.g. audit_trail = db in > > init.ora. How to sync it when re-start Oracle database? > > (2) Can I change the audit_trail = db initialization parameters in > init.ora > > on-line? > > > > Any comments are appreciated! > > Many thanks! > > > > Don > > > > > > > > Arup Nanda wrote: > > > > > The ability to change the system parameters without bouncing the system > is > > > not provided by spfile, neither in RAC nor single instance databas. It > > > depends upon the the parameter that can be changed dynamically or not. > > > > > > I guess you wanted to convey the impression that the using spfiles the > > > parameters can be changed and the changes can be persistent across > > > shutdowns. But that is not just in RAC; it's true for single instance > DBs, > > > too. > > > > > > Now, suppose you want to set a parameter that can't be changed using > ALTER > > > SYSTEM, such as, say, java_pool_size. How do you plan to make the > change? > > > You have to open up the old favorite init.ora file and start the > database > > > with pfile=init.ora option. At that stage the spfile is not active and > your > > > issuing Alter system set db_cache_size = 800m scope = [ memory | spfile > | > > > both ] sid = * has no effect. You must create the spfile from the pfile > and > > > then use the newly created spfile to use this "dynamic" parameter > > > persistent. Note the complexity involved - spfile allowed you to make > the > > > changes to some parmeters using alter system persistent; but for all > other > > > parametrs you are forced to use pfile. What happens if you ommit the > > > pfile=init.ora clause? The database will pickup the spfile, which will > _not_ > > > have your changes. > > > > > > To fully appreciate the value of the spfile parameter, Oracle should > have > > > allowed editing spfile directly and completely done away with pfile. > > > Splitting functionality across two different implementations adds to > > > difficulties, does not resolve them. I hope future versions of Oracle do > > > offer that functionality. It's not that difficult or unheard of, either. > >
Re: How to make SPFILE in sync with INIT.ORA ?
Hi, I really need some helps to configure my database with audit_trail option. I have tried some but fail so far. My database is Oracle 9.2. I have read all email related to spfile. Can somebody provides simple steps for me to update my specified initialization parameter in init.ora? (1) Manually change the initialization parameter, e.g. audit_trail = db in init.ora. How to sync it when re-start Oracle database? (2) Can I change the audit_trail = db initialization parameters in init.ora on-line? Any comments are appreciated! Many thanks! Don Arup Nanda wrote: > The ability to change the system parameters without bouncing the system is > not provided by spfile, neither in RAC nor single instance databas. It > depends upon the the parameter that can be changed dynamically or not. > > I guess you wanted to convey the impression that the using spfiles the > parameters can be changed and the changes can be persistent across > shutdowns. But that is not just in RAC; it's true for single instance DBs, > too. > > Now, suppose you want to set a parameter that can't be changed using ALTER > SYSTEM, such as, say, java_pool_size. How do you plan to make the change? > You have to open up the old favorite init.ora file and start the database > with pfile=init.ora option. At that stage the spfile is not active and your > issuing Alter system set db_cache_size = 800m scope = [ memory | spfile | > both ] sid = * has no effect. You must create the spfile from the pfile and > then use the newly created spfile to use this "dynamic" parameter > persistent. Note the complexity involved - spfile allowed you to make the > changes to some parmeters using alter system persistent; but for all other > parametrs you are forced to use pfile. What happens if you ommit the > pfile=init.ora clause? The database will pickup the spfile, which will _not_ > have your changes. > > To fully appreciate the value of the spfile parameter, Oracle should have > allowed editing spfile directly and completely done away with pfile. > Splitting functionality across two different implementations adds to > difficulties, does not resolve them. I hope future versions of Oracle do > offer that functionality. It's not that difficult or unheard of, either. > Listener.ora, tnsnames.ora are all editable and also read by Net Assistant. > > just my .02 > > Arup Nanda > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, July 15, 2003 8:09 PM > > > Spfile is shared and can be modified dynamically without bouncing the > > instances. > > > > Eg. Alter system set db_cache_size = 800m scope = [ memory | spfile | > both ] > > sid = * > > > > Without spfile, you can still make this change dynamically in memory, but > > you would have to manually update init.ora file to reflect your change. > > Spfile allows you to automatically capture these dynamic changes. > > > > Gerardo > > > > -Original Message- > > Sent: Tuesday, July 15, 2003 4:45 PM > > To: Multiple recipients of list ORACLE-L > > > > > > And how, exactly? > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Tuesday, July 15, 2003 7:29 PM > > > > > > > You'll appreciate spfiles if you're using RAC. > > > > > > -Original Message- > > > Sent: Tuesday, July 15, 2003 2:09 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > And create pfile from spfile; does a similar job. > > > > > > I'm rapidly beginning to think that spfiles are just not worth it. Now > > > how to reverse the policy decision having mandated them for 9i > > > installs :( > > > > > > Niall > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > > > > Of Arup Nanda > > > > Sent: 15 July 2003 04:44 > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: Re: How to make SPFILE in sync with INIT.ORA ? > > > > > > > > > > > > As user sys, issue > > > > > > > > CREATE SPFILE FROM PFILE; > > > > > > > > This will create the spfile. You must have started the database > > > > using the pfile to use this command. > > > > > > > > HTH. > > > > > > > > Arup Nanda > > > > - Original Message - > > > > To: "Multiple recipients of l
Re: sqlldr questions
Please look the following text, which works fine everyday for loading my data into oracle 9.2 database. $ORACLE_HOME/bin/sqlldr USERID=your_username/[EMAIL PROTECTED] control=link-summary.ctl log=link-summary.log $ more link-summary.ctl options (rows=9297500, errors=2, bindsize=100, readsize=100) LOAD DATA INFILE '/tmp/log_file_parsing_output.dat' truncate INTO TABLE access_summary FIELDS TERMINATED BY ' ' (CLIENT_IP char(100), ACCESS_DATE char(9), URL char(400)) This is my application. You need to change file name, file path, and table name and its column name as well. Hope it can help you. Don Kirtikumar Deshpande wrote: > An excellent book for SQL Loader new comers, and experienced users as well, is one > by Jonathan > Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly. > > Stenphen Andert will agree with me ;) > > - Kirti > > --- John Dunn <[EMAIL PROTECTED]> wrote: > > I'm a sqlldr newbie. Platform is Oracle 9.2. > > > > My question is...can I prevent sqlldr loading any data if there is even a > > single bad record, even if it is, for example, the last record? I am using > > conventional path > > load. > > > > John > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: John Dunn > > INET: [EMAIL PROTECTED] > > > > __ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Kirtikumar Deshpande > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: security without using different usernames
Arup, My database version is Oracle 9i (9.2.0.1.0). Thanks! Don Arup Nanda wrote: > What is your database version? 9i? If so you are probably using the SPFILE; > changing the init.ora file wouldn't help. > > Shutdown trhe database and startup with the pfile option > > startup pfile=init.ora > > being in the same directory. You will be able to see the parameter being > set. > > HTH. > > Arup Nanda > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, July 16, 2003 12:09 PM > > > Pete, > > > > I follow your steps to enable audit_trail = db in init.ora located in > > ORACLE_HOME/dbs > > and restart my Oracle database on solaris. After my database is up, I do > the exact > > query in your paper and results as followings: > > > > SQL> select name,value from v$parameter > > 2 where name like 'audit%'; > > > > NAME > > > > VALUE > > -- > -- > > audit_sys_operations > > FALSE > > > > audit_file_dest > > ?/rdbms/audit > > > > audit_trail > > NONE > > > > Please tell me what is possible causes that I fail to enable audit on my > database. > > Any comments are appreciated! > > Many thanks! > > > > > > Don > > > > > > Pete Finnigan wrote: > > > > > Hi > > > > > > You can get the ip address as follows: > > > > > > oracle:jupiter> sqlplus system/[EMAIL PROTECTED] > > > > > > SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003 > > > > > > (c) Copyright 2001 Oracle Corporation. All rights reserved. > > > > > > Connected to: > > > Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production > > > With the Partitioning option > > > JServer Release 9.0.1.0.0 - Production > > > > > > SQL> select sys_context('userenv','ip_address') ip,username,machine > > > 2 from v$session > > > 3 where sys_context('userenv','sessionid')=audsid; > > > > > > IP > > > > > > > > > USERNAME > > > -- > > > MACHINE > > > > > > 172.16.240.11 > > > SYSTEM > > > jupiter > > > > > > SQL> > > > > > > you need to provide the service name when you log on otherwise the ip > > > address is not available using sys_context. > > > > > > Also new with 9i as part of application contexts you can use the "using" > > > clause of create role that a pl/sql package can be used to verify the > > > user, for example something like this, typed in from memory so check the > > > syntax!: > > > > > > create role some_role identified using sys.confirm_user; > > > > > > create or replace procedure confirm_user > > > authid current user is > > > lv_ipaddress varchar2(30); > > > begin > > > select sys_context('userenv','ip_address') > > > into lv_ipaddress > > > from sys.dual; > > > if lv_ipaddress='172.16.140.1' then > > > dbms_session.set_role('some_role'); > > > end if; > > > end; > > > / > > > > > > hth > > > > > > kind regards > > > > > > Pete > > > -- > > > Pete Finnigan > > > email:[EMAIL PROTECTED] > > > Web site: http://www.petefinnigan.com - Oracle security audit > specialists > > > Book:Oracle security step-by-step Guide - see http://store.sans.org for > details. > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Pete Finnigan > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting services > > >
Re: security without using different usernames
Pete, I follow your steps to enable audit_trail = db in init.ora located in ORACLE_HOME/dbs and restart my Oracle database on solaris. After my database is up, I do the exact query in your paper and results as followings: SQL> select name,value from v$parameter 2 where name like 'audit%'; NAME VALUE audit_sys_operations FALSE audit_file_dest ?/rdbms/audit audit_trail NONE Please tell me what is possible causes that I fail to enable audit on my database. Any comments are appreciated! Many thanks! Don Pete Finnigan wrote: > Hi > > You can get the ip address as follows: > > oracle:jupiter> sqlplus system/[EMAIL PROTECTED] > > SQL*Plus: Release 9.0.1.0.0 - Production on Wed Jun 25 20:45:54 2003 > > (c) Copyright 2001 Oracle Corporation. All rights reserved. > > Connected to: > Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production > With the Partitioning option > JServer Release 9.0.1.0.0 - Production > > SQL> select sys_context('userenv','ip_address') ip,username,machine > 2 from v$session > 3 where sys_context('userenv','sessionid')=audsid; > > IP > > > USERNAME > -- > MACHINE > > 172.16.240.11 > SYSTEM > jupiter > > SQL> > > you need to provide the service name when you log on otherwise the ip > address is not available using sys_context. > > Also new with 9i as part of application contexts you can use the "using" > clause of create role that a pl/sql package can be used to verify the > user, for example something like this, typed in from memory so check the > syntax!: > > create role some_role identified using sys.confirm_user; > > create or replace procedure confirm_user > authid current user is > lv_ipaddress varchar2(30); > begin > select sys_context('userenv','ip_address') > into lv_ipaddress > from sys.dual; > if lv_ipaddress='172.16.140.1' then > dbms_session.set_role('some_role'); > end if; > end; > / > > hth > > kind regards > > Pete > -- > Pete Finnigan > email:[EMAIL PROTECTED] > Web site: http://www.petefinnigan.com - Oracle security audit specialists > Book:Oracle security step-by-step Guide - see http://store.sans.org for details. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Pete Finnigan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 security question
Ron, I have urgent question. Because I want to shutdown my database, I login as oracle and execute dbshut. But later I found that the process is very slow so I realize that I should type shutdown immediate. Then, I use control-D to stop shutdown command. And I re-execute "shutdown immediate". Now the shutdown command seems to take longer time to finish. Is there something wrong or normal? Any comments are appreciated! Thanks! Don Ron Rogers wrote: > Don, > The users need acces to the data that is in the database or what is > the purpose of the database? > I would change the privileges of the users to "CREATE SESSION" only > and revoke all others. Then I would use "ROLES" that have select > privileges on the tables that they need acces to. By creating roles and > granting the role to a user the user can select from the tables. If > different groups need acces to different tables you can create different > roles and grant them as needed. > Roles are an easy method of controlling acces to table data and if > changes are needed then you change the role's privileges and all users > of the role are effected. > Ron > > >>> [EMAIL PROTECTED] 07/11/03 03:44PM >>> > Hi, > > I have a security question about Oracle database. Recently I have > taken > full control an Oracle database in my department. Now I would like to > make sure that no other people except myself can update data in that > database. Can somebody tell me what it is necessary steps to do that? > Any comments are highly appreciated. Thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ron Rogers > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 security question
Dear Guang Mei: Thanks for your message. Your suggestion is very helpful. After reviewing all possible uesers, I have locked them. Now I have only one concern that if nobody knows my database's sys and system's password, there should be no way to unlock these accounts. Am I complete right? Thanks! Any comments are appreciated! Don Guang Mei wrote: > select * from all_users; > > to get all users, then change their oracle passwords so that no body can > log in except you. This way you know you are the only one who can change > the data. Next step is see what application can make the data change. > > Hope this helps. > > Guang > > On Fri, 11 Jul 2003, Don Yu wrote: > > > Dennis > > > > Thank you very much. My data in that database is changed three times. The first > > is whole data being delete. The second is over ten thousands records being > > added. The third is whole data related to a month being deleted. I know my > > working environment is very complicated. For this report application, I write > > shell scripts and C/C++ program to parsing Apache web server access log file > > (www.welch.jhu.edu) in order to get client ip, access date, and host ip, which > > are associated with the special pattern as "ntlinktrack.cgi", which is > > associated with Library E-Book,E-Journal, and E-database. Then I need to > > schedule a solaris cron job to process access log daily and load parsed data > > into database. Also I create some log files for saving intermediate information > > from my program. Then I create some ColdFusion pages to post these results into > > website. In my database there are over million records. Oracle DBA is new duty > > for me since I had found that my data was missing. This is the reason I post my > > question on Oracle user group. Now I am trying to read as much as I can but I do > > not have much time. I want to make sure my database is secure as early as I can. > > So what do you think of my reason? > > Thank you very much! > > > > > > Don > > > > > > DENNIS WILLIAMS wrote: > > > > > Don > > > SYS is the owner of the Oracle dictionary tables. It is a username with > > > DBA privilege, so someone who logs in can change data. If you have changed > > > its password, then you are assured that nobody is using that username right > > > now. If you've changed its password, then I wouldn't worry about it right > > > now. > > > Since it sounds as if you are the only person that accesses this > > > database, then you may want to change the username that owns your tables. > > > Hopefully this username is not SYSTEM or SYS. > > > After that, unless you know of other usernames someone might use to > > > access your Oracle database, don't make any more security changes for > > > awhile. Go back to trying to figure out why your data is changing without > > > your changing it. It may well be there is an innocent reason that has > > > nothing to do with someone else. I've had that happen to me when I've > > > started using an unfamiliar system. > > > And don't forget to buy a good Oracle DBA book like the one I suggested. > > > > > > Dennis Williams > > > DBA, 80%OCP, 100% DBA > > > Lifetouch, Inc. > > > [EMAIL PROTECTED] > > > > > > > > > > > > -Original Message- > > > Sent: Friday, July 11, 2003 3:49 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > Dennis: > > > > > > Thanks for your message. Now I have changed sys password by the following > > > command: > > > alter user sys identified by xxx > > > But when I try to login from sql plus window by using sys, I cannot > > > successfully > > > login. Also I get an error message. The message is something like > > > "connection to > > > sys should be as sysdba or sysoper". So my question is what sys for? > > > Thank you very much! > > > > > > Don > > > > > > DENNIS WILLIAMS wrote: > > > > > > > Don > > > >If only you can make updates to your Oracle database, then you must > > > enter > > > > all the data ;-) > > > >From the tone of your posting, I'm going to assume that you are pretty > > > > new to Oracle. You may want to get a good basic administration book like > > > > Oracle9i DBA 101. > > > > > > > http://www.amazon.com/exec/obidos/tg/detail/-/0072
Re: Oracle security question
Dennis Thank you very much. My data in that database is changed three times. The first is whole data being delete. The second is over ten thousands records being added. The third is whole data related to a month being deleted. I know my working environment is very complicated. For this report application, I write shell scripts and C/C++ program to parsing Apache web server access log file (www.welch.jhu.edu) in order to get client ip, access date, and host ip, which are associated with the special pattern as "ntlinktrack.cgi", which is associated with Library E-Book,E-Journal, and E-database. Then I need to schedule a solaris cron job to process access log daily and load parsed data into database. Also I create some log files for saving intermediate information from my program. Then I create some ColdFusion pages to post these results into website. In my database there are over million records. Oracle DBA is new duty for me since I had found that my data was missing. This is the reason I post my question on Oracle user group. Now I am trying to read as much as I can but I do not have much time. I want to make sure my database is secure as early as I can. So what do you think of my reason? Thank you very much! Don DENNIS WILLIAMS wrote: > Don > SYS is the owner of the Oracle dictionary tables. It is a username with > DBA privilege, so someone who logs in can change data. If you have changed > its password, then you are assured that nobody is using that username right > now. If you've changed its password, then I wouldn't worry about it right > now. > Since it sounds as if you are the only person that accesses this > database, then you may want to change the username that owns your tables. > Hopefully this username is not SYSTEM or SYS. > After that, unless you know of other usernames someone might use to > access your Oracle database, don't make any more security changes for > awhile. Go back to trying to figure out why your data is changing without > your changing it. It may well be there is an innocent reason that has > nothing to do with someone else. I've had that happen to me when I've > started using an unfamiliar system. > And don't forget to buy a good Oracle DBA book like the one I suggested. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > > -Original Message- > Sent: Friday, July 11, 2003 3:49 PM > To: Multiple recipients of list ORACLE-L > > Dennis: > > Thanks for your message. Now I have changed sys password by the following > command: > alter user sys identified by xxx > But when I try to login from sql plus window by using sys, I cannot > successfully > login. Also I get an error message. The message is something like > "connection to > sys should be as sysdba or sysoper". So my question is what sys for? > Thank you very much! > > Don > > DENNIS WILLIAMS wrote: > > > Don > >If only you can make updates to your Oracle database, then you must > enter > > all the data ;-) > >From the tone of your posting, I'm going to assume that you are pretty > > new to Oracle. You may want to get a good basic administration book like > > Oracle9i DBA 101. > > > http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8 > > -1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846 > > It is also a good idea to always mention your Oracle version and platform > > (Unix, NT, etc.) in your posts. > > First, log in with the SYSTEM username. Then change the password for > SYSTEM > > and SYS with the command: > > ALTER USER SYSTEM IDENTIFIED BY x; > > Where x is your new password. > > You should be able to make these changes without affecting any end users. > > Next you should identify your groups of users and how they access Oracle. > > Basically you need to identify what their access requirements are and then > > audit the usernames they use to ensure the privileges granted are just > what > > is required. This is also a good time to see about changing passwords, but > > first buy the book and read up on the basics of Oracle security. > > > > Dennis Williams > > DBA, 80%OCP, 100% DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Friday, July 11, 2003 2:45 PM > > To: Multiple recipients of list ORACLE-L > > > > Hi, > > > > I have a security question about Oracle database. Recently I have taken > > full control an Oracle database in my department. Now I would like to > > make sure that no other people except myself can update data in tha
Re: Oracle security question
Dennis: Thanks for your message. Now I have changed sys password by the following command: alter user sys identified by xxx But when I try to login from sql plus window by using sys, I cannot successfully login. Also I get an error message. The message is something like "connection to sys should be as sysdba or sysoper". So my question is what sys for? Thank you very much! Don DENNIS WILLIAMS wrote: > Don >If only you can make updates to your Oracle database, then you must enter > all the data ;-) >From the tone of your posting, I'm going to assume that you are pretty > new to Oracle. You may want to get a good basic administration book like > Oracle9i DBA 101. > http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1057949734/sr=8 > -1/ref=sr_8_1/104-2287688-5574335?v=glance&s=books&n=507846 > It is also a good idea to always mention your Oracle version and platform > (Unix, NT, etc.) in your posts. > First, log in with the SYSTEM username. Then change the password for SYSTEM > and SYS with the command: > ALTER USER SYSTEM IDENTIFIED BY x; > Where x is your new password. > You should be able to make these changes without affecting any end users. > Next you should identify your groups of users and how they access Oracle. > Basically you need to identify what their access requirements are and then > audit the usernames they use to ensure the privileges granted are just what > is required. This is also a good time to see about changing passwords, but > first buy the book and read up on the basics of Oracle security. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Friday, July 11, 2003 2:45 PM > To: Multiple recipients of list ORACLE-L > > Hi, > > I have a security question about Oracle database. Recently I have taken > full control an Oracle database in my department. Now I would like to > make sure that no other people except myself can update data in that > database. Can somebody tell me what it is necessary steps to do that? > Any comments are highly appreciated. Thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 security question
Stephane, Thanks for your message. The reason I ask this question is that now I am responsible for creating some reports based upon this database. But I have found that there are unaccountable data in my database, which is not from my insert script or my cron job program. Thanks! Don Stephane Paquette wrote: > Change the password of all Oracle related users (sys, system,...) > Revoke access from all other users or make sure all other users have select > only privilege on data. > > What is the use of such databases ? > > Stephane Paquette > Administrateur de bases de donnees > Database Administrator > Standard Life > www.standardlife.ca > Tel. (514) 499-7999 7470 and (514) 925-7187 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > -Original Message- > Don Yu > Sent: Friday, July 11, 2003 3:45 PM > To: Multiple recipients of list ORACLE-L > > Hi, > > I have a security question about Oracle database. Recently I have taken > full control an Oracle database in my department. Now I would like to > make sure that no other people except myself can update data in that > database. Can somebody tell me what it is necessary steps to do that? > Any comments are highly appreciated. Thanks! > > Don > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Don Yu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephane Paquette > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 security question
Hi, I have a security question about Oracle database. Recently I have taken full control an Oracle database in my department. Now I would like to make sure that no other people except myself can update data in that database. Can somebody tell me what it is necessary steps to do that? Any comments are highly appreciated. Thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: index on null column
Queries against the non-null values should benefit greatly. Queries on the null values will not use the index since null values are not indexed (at least in single column indexes). It is an old trick to create an index on something like STATUS where the vast majority of records have a NULL (meaning perhaps "PROCESSED") and a small percentage of the records have other non-null values for STATUS ("PENDING","APPROVED", etc.). Don Granaman certified OraSaurus - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Thursday, March 27, 2003 5:18 PM Subject: index on null column I have a table with column A. there are 100 records in table out of which 500o records has not null in column A rest are null. if i created an index on A, will it benefit . thanks, ak
OT: Anybody using QlikView BI tools?
After management learned the cost of Cognos PowerPlay, they decided to look at QlikView from QlikTech (Sweeden). I would be interested in hearing from anybody that has had experience with this BI tool. Pro and con issues are welcome. Thx - Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Performance Tuning Exam
Sorry for the very late response, but I've seen a lot of similar postings recently. I've been lurking for some months now, when I have time for even that, but I've never been accused of being under-opinionated, so... In my opinion, the exam to take first is the Architecture & Administration exam. Anyone with any sort of significant Oracle DBA experience should be able to pass it cold. If it doesn't seem too easy or doesn't score well, adjust the exam schedule and allocated study time accordingly. I took the 8i Architecture/Administration exam and the 8i Backup & Recovery exams on the same Tuesday at OracleWorld 2002 with zero preparation other than experience. I finished the first in under 20 minutes, the latter in about 35. Both seemed easy. Of course, there were some "trick" questions, some RMAN syntax trivia, and other OCP exam inanity. Two days later, I took the SQL & PL/SQL exam. I "crammed" on obscure syntax and advanced stuff for about two hours in the IOUG bookstore in the exhibit hall immediately prior. It was unnecessary - no advanced stuff appeared on the exam (Warning! Your mileage may vary.). It was easier than I thought based on what I had heard about it. It wasn't really difficult, but it was a little tricky in places and a bit tedious in places. All the other exams were allowed 90 minutes, but this one was allowed 120 minutes. I actually took about 65 minutes (almost twice as long as any of the other five for 8i + 9i) due to checking over every answer twice and some of the "tricky" questions thrice. I think that the vast majority of experienced DBAs could easily pass these with an 80%+ score with no formal preparation. The only caveat is that one needs to be conversant in RMAN - the basics at least. The tuning exam was "a bit odd". Knowing that it required the "party line" answers, I spent about two hours reviewing the various ratio formulae and memorizing other fairly useless trivia. Some of the questions had no truly correct answer - especially some that said something like "pick three..." when there were definitely NOT three "correct" answers (and perhaps not even two - or one). This one might require some study by even the most experienced DBAs. Actually, the amount of "prep time" required might be directly proportional to one's tuning expertise! The fairly naive might actually score better than actual experts given the same prep time! There were a number of questions that should have had a "none of the above - no matter what the book says" choice - or perhaps an optional write-in answer (e.g. "I refuse to answer - even the question is utterly irrelevant and misleading!"). I studied about 12 hours for the networking exam - primarily because I've never used connection manager, Oracle Names, or OID in "real life" - and have only rarely used some other stuff like MTS. This exam was *much* easier than I anticipated. However, it did have a few "GUI trivia" questions - stuff like knowing what menu something is on in netca, picking among four very similar possible answers for the exact wording on some boilerplate or menu, ad nauseum. (Kind of missed the point of GUIs didn't they?) I took the 9i upgrade a week later, but studied for it most of the week (The week of Thanksgiving - 4 evenings, one Saturday and a couple of hours per day for the three days at work). It could be considered the most difficult since it covers only 9i new features - few of which one might have any "real life" experience with. It covered most topics at the conceptual level or a very basic level, but there were a couple of extremely esoteric technical questions that almost nobody would even attempt to answer in "real life" without consulting a manual. All these OCP exams were far easier than I ever thought they would be - even after taking a few. Most of the questions were of a conceptual or rather basic nature. All the exams had some serious flaws - questions that were ambiguous, the wrong "correct" answers, obscure syntax trivia, GUI trivia, too many questions about things that (almost) nobody ever uses (e.g. OEM's Oracle Trace), etc. A significant part of the game is in knowing how to take exams. In this, I've had a lot of experience - about 240 university semester hours and three degrees. If you don't see an obviously "correct" answer right away, weed out the obviously "incorrect" answers. Never leave a "multiple guess" question unanswered if there is no penalty for missed guesses. Et cetera... After having gone from 0% OCP to 200% OCP (8i + 9i) in about three weeks in November, perhaps now I can say "OCP doesn't mean squat - except to HR checklists" - without appearing to be just another crusty old curmudgeon
Re: Info on context option
It is bundled with 8i (EE at least, not sure about SE) - see $ORACLE_HOME/ctx/admin/dr0csys.sql and Metalink Doc ID: 73605.1 The name has changed over time: ConText is a cartridge for Oracle 8.0.x interMedia Text is a feature of Oracle8i Oracle Text is a feature of Oracle9i Don Granaman certifiable OraSaurus - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, March 01, 2003 5:59 AM > Hi DBAs, > > Oracle 8.1.6 SE, WinNT > We are considering using Oracle Context. Is this a separately sold product > and is it available in enterprise edition. > I cannot find this info anywhere. Any help is appreciated. > > Thanks > Rick > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SqlNet Response ports
I guess I should have asked also: 1) what version of Oracle are you using? 2) Is this using MTS or dedicated servers? Since this is Linux, there are three cases: 1) Dedicated severs - there is no redirection. Client talks to dedicated server on listener port. 2) MTS & Oracle 9i - ditto 3) MTS & pre-9iR2 - MTS does redirect by default 0 to some (pseudo-)random port above 1024 but this may be overridden by adding a pfile (init.ora) entry like: mts_dispatchers="(address=(protocol=tcp)(host=yourhostname)(port=443))(dispa tchers=1)" See: Metalink Bulletin: 1016349.102 & Note: 163082.999 Go to advanced search and search on "Doc ID" with these IDs. There may be multiple mts_dispatchers= lines in the init file and there may be other parameters of interest. For the sake of this particular issue though, the pertinent item is the ("port=443)" clause. It would force MTS redirects to port 443. Actually, this parameter is obsoleted by the initiiation parameter: local_listener=listener_name_alias where tnsnames.ora has an entry like: listener_name_alias=(address=(protocol= tcp)(host= yourhostname)(port= 443))... and other appriopriate MTs initialization parameters. Please see the documentation for your version for options. Good luck! Don Granaman certified OraSaurus - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 12:39 PM > Redhat Linux 7.2 > > At 07:28 PM 2/21/2003 -0800, you wrote: > >What platform is this? Windows? > > > >Don Granaman > >OraSaurus > > > >- Original Message - > >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > >Sent: Friday, February 21, 2003 5:48 PM > > > > > > > Hi listers, > > > > > > Here is a question my client asked me, that I can't seem to find the > >answer > > > to on metalink, mostly because I am not sure how to frame the search > > > query. If you don't know what NMCI is, just know that it is a government > > > program that is establishing control over the network which our database > > > servers are on. Anyone have any ideas or advice for me? > > > > > > TIA, Regina > > > > > > Then, one of the NMCI technical guys mentioned that NMCI PCs wouldn t > >allow > > > inbound/outbound 1521 traffic (SQLNET). Hence, no NMCI user would be able > > > to use any client/server application. Wow, that s a major problem. There > > > are a few possible solutions. > > > > > > 1. Configure the database server to listen on port 443, because NMCI > > > allows 443. But, SQLNET uses random high order ports on the > > > return. Anybody know if you can configure SQLNET to use only 443 on the > > > response? > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Regina Harter > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting services > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > >-- > >Author: Don Granaman > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >San Diego, California-- Mailing list and web hosting services > >- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Regina Harter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hostin
Re: Urgent - Help ....
(Since this is "urgent", I'm probably a few days late.) But for future reference... I assume that "no change in the software" means no changing variables and such that can currently handle only a 9 digit number... Can your application can handle negative numbers? Is this really a surrogate key? If so you are in luck! Drop and recreate the sequence with: create sequence MY_SEQ increment by -1 start with 0 ... (Add whatever else is appropriate - cache 100, etc.) Don Granaman OraSaurus - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 2:58 AM > Hi Gurus, > > I need a urgent help. > > I have a table e.g. USER_DETAILS with a column NUMBER(9), populated by a > sequence. [ The column name is USERNO ] > > This table is quite heavy and the current situation is USERNO have reached > it's maximum value i.e. 9. > No more records can be inserted > > Problem !!! > > Can any one suggest a solution with NO change is the software and minor > change in the software. > > TIA > > Regards, > Harsh Agrawal > > > > The information contained in this message is proprietary of Amdocs, > protected from disclosure, and may be privileged. > The information is intended to be conveyed only to the designated recipient(s) > of the message. If the reader of this message is not the intended recipient, > you are hereby notified that any dissemination, use, distribution or copying of > this communication is strictly prohibited and may be unlawful. > If you have received this communication in error, please notify us immediately > by replying to the message and deleting it from your computer. > Thank you. > > ---- > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SqlNet Response ports
What platform is this? Windows? Don Granaman OraSaurus - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 21, 2003 5:48 PM > Hi listers, > > Here is a question my client asked me, that I can't seem to find the answer > to on metalink, mostly because I am not sure how to frame the search > query. If you don't know what NMCI is, just know that it is a government > program that is establishing control over the network which our database > servers are on. Anyone have any ideas or advice for me? > > TIA, Regina > > Then, one of the NMCI technical guys mentioned that NMCI PCs wouldn t allow > inbound/outbound 1521 traffic (SQLNET). Hence, no NMCI user would be able > to use any client/server application. Wow, that s a major problem. There > are a few possible solutions. > > 1. Configure the database server to listen on port 443, because NMCI > allows 443. But, SQLNET uses random high order ports on the > return. Anybody know if you can configure SQLNET to use only 443 on the > response? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Regina Harter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Tech Support
description of the differences (few except for time), and still got the idiot treatment. I said it was a bug and nobody would even consider the possibility. For about twelve rounds, they kept saying stuff like that I couldn't expect the query to run the same unless the hardware was identical (even after I explained that 8.1.7.4 was running on a single 1.2 GHz PIII CPU Dell desktop with Linux 7.2 and 256M RAM and a single IDE drive, but 9.2.0.2 was running on a dual 1.4 GHz Dell server with Linux 7.2, 4G RAM and the 9i database was alone on a Dell/EMC FC4700 array with 2 GB of cache and a bunch of 15k SCSI drives set up with RAID 0+1 (except for redo on dedicated mirrored drives) Or that I should consider moving redo logs off of disks with other datafiles.. Or that the datafiles might need to be redistributed to balance I/O (How much I/O does "select name from v$datafile" require? Is I/O redistributi9on likely to make it 400-600 times faster? Besides, the database and system was idle except for me and a few background processes.) Agh! Guess what? It was a bug. When I later found and applied patch #2773907, the problem disappeared entirely - the query went from >6.5 sec to 0.01-0.02 sec. All the nonsense that support suggested or asked for was entirely useless in solving the problem - and I politely told them so at the time (but humored them anyway). Don Granaman OraSaurus on the brink... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 2:26 PM > > Today I opened yet another iTar on the VERY buggy 9iAS R2 Reports Server. > > Below is a CLASSIC response to my report of errors being generated. > > "There is a Unix generic solution that you can try . Use the command like > this : > > + rwclient.sh userid=mwh/***@prod authid=orcladmin/** > desformat=postscript > server=repcosmora001 report=edi810ii destype=PRINTER desname=cohpfin013 > print_apunprinted=Y mode=default > /dev/null > > This would not display the error message on the terminal. > Can you try this workaround and let me know whether this is okay?" > > So, the next time anybody gets an error message from Oracle > simply wrap a blindfold over your eyes, send the message into > the bit bucket, & go merrily on your way. > > Error? What error? > > UNBELIEVABLE! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Preventing select on table
I disagree that it is inherently bad to EVER use a natural key. In most cases, such as this one, it doesn't work very well. However, there are many cases where implementing the primary key as a surrogate key, simply to satisfy a blanket "thou shalt not use natural keys" is overkill and unnecessarily complicates things. As a simple example, consider a table of US state codes to be used in addresses (STATE_CODE, STATE_NAME, ...). Is adding a sequence-generated STATE_ID really necessary? It is unlikely that CA will ever mean anything other than California or that California will demand that it be changed to CF. All that adding a surrogate key here does is complicate the application. The vast majority of users will never need to drill down to see what CA means, but to display anything useful on a screen or report, the surrogate key will always require a join. Don Granaman OraSaurus - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 17, 2003 1:33 PM > Ok, so now you have learnt the lesson that not to define a primary key based > on any attributes. > > is it ok for ur customer if the values r updated at night ? if so, u can add > a column to the table, say "new_customer_id", and then at night run thru a > huge update to replace all the keys in referenced tables. if this is an > acceptable soln, i would further suggest writing a procedure which uses > dynamic sql to read the oracle data dictionary and updating all the tables > using this key. also, u can use bulk binds to get ur updates done faster. > > and the hard way which u r saying is really not that hard. u would just need > a wknd and get all ur updates run. > > hope this helps ! > > -Original Message- > Sent: Monday, February 17, 2003 5:39 AM > To: Multiple recipients of list ORACLE-L > > > > > We have a database application that uses a primary key field value of > > CUSTOMER in several tables, and as a foreign key in others. Everything > > works fine, but the customer has come up with a new requirement - they > > wish to be able to rename these primary keys values on the fly. > > > > I'm looking for a simple way to do this, the problem is simply issuing a > > load of updates would be a risky business because what could happen is ... > > > > 1) Part of the application reads a CUSTOMER value using a SELECT > > statement and stores the value in a variable. > > 2) I do the big update renaming CUSTOMER values everywhere they are > > used & commit. > > 3) The part of the application that still has the old values stored in > > a variable and then writes the old value to a new record and the database > > ends up with a mix of old and new values. > > > > One way to prevent this would be to lock all tables I want to update in 2) > > before doing anything. This will only work if the lock prevents all SELECT > > statements from working until I am done. > > > > From answers given on this list, it seems that SELECTs cannot be prevented > > in this way. We are also not using any referential integrity constraints > > so the update in 3) would work fine. > > > > Can anyone think of a simple solution, or do I have to do this the hard > > way (rewrite whole thing to use a sequence number as the primary key, and > > have Customer as an updatable bit of text). > > > > -Original Message- > > From: John Dunn > > Sent: 17 February 2003 08:58 > > To: Jamie Pearce > > Subject: > > > > << Message: Re: Lock table and disallow select >> << Message: > > Re:Lock table and disallow select >> << Message: RE: Lock table and > > disallow select >> << Message: Re:Lock table and disallow select >> << > > Message: Re: Lock table and disallow select >> << Message: RE: Lock table > > and disallow select >> << Message: RE: Lock table and disallow select >> > > << Message: Re: Lock table and disallow select >> << Message: Re: Lock > > table and disallow select >> << Message: RE: Lock table and disallow > > select >> > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: John Dunn > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EX
Re: newbie question - late response.
1) select * from v$database; Note: Picky perhaps, but "instance" and "database" may be different. ... 3) grant create session to scott; Note: CONNECT is a role that includes the create session system privilege and a LOT more. It is NOT a synonym for "create session". ... Don Granaman OraSaurus - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, February 08, 2003 11:33 PM > 1)How to find out from sqlplus what is the current > database ? > > once, connected, do "select * from v$instance;" > > 2)and how to switch to another one ? > > from DOS prompt: by chaning your ORACLE_SID environment variable > or via Net8: either from SQL*Plus: connect system/manager@another_db > or from DOS: sqlplus system/manager@another_db. > > 3)How to create users in my new database ? after > creating users do I have to do something to allow them > get connected from another machine ? > > create user scott identified by tiger default tablespace users temporary > tablespace temp; > > grant connect to scott; > > 4)Do I need to create a tablespace for my new > database, if so how to do it ? > > OK, now I am gonna suggest you to read the Oracle's documentation: > especially the "Administrator's Guide". It's availabe on otn.oracle.com. > > 5)How to create tables ? > > See answer for #4. > > Thank you your help is appreciated. > > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: majid > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Richard Ji > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RAC on linux
Oracle 9.2.0.2 RAC on RedHat 7.2 is "OK", but 7.2 has no support for CFS or AIO (As I remember - it has been a while. I switched to AS 2.1, still on raw devices, months ago.). It was in many respects the least problematic combination, but is, of course, not officially supported. As far as the docs go, some are very good (RAC Concepts), some are marginally useful (e.g. RAC Setup and Configuration). Note that the CFS docs repeatedly mention "watchdog", even though it was discarded in 9.2.0.2 - months before CFS was even available. Other such contradictions abound... For example, no two docs seem to call the quorum disk the same thing - some call it that, some say the "cm" disk, some say other things. To keep things interesting, they sometimes rotate this usage between docs when a new version comes out. All quite confusing until you adapt by skimming over the details. Don't even think about anything prior to 9.2.0.2 on any version of Linux - unless you actually want to do *A LOT* of jumping through flaming hoops - tweaking everything in sight, "faking the watchdog" (really - MetaLink even has detailed directions for "faking it"), diagnosing random node reboots, ad nauseum. My experience over the last year with RAC on Linux has been "entertaining", to say the least. In 9.0.1.1, the Oracle-supplied cluster management software consisted of oracm (cluster monitor), oranm (network monitor), and watchdogd (daemon to randomly crash nodes ;-). Nodes spontaneously rebooted for no apparent reason - and took all the other nodes in the cluster down with them. This usually occurred at least a few times per week. ("It will be fixed in the next release".) In 9.2.0.1 (I think - it might have been 9.0.x), they eliminated oranm. It was slightly more stable - only spontaneously, randomly, and for no apparent reason rebooting one node at a time (usually). ("It will be fixed in the next patchset.") In 9.2.0.2, they eliminated watchdogd and added a kernel module named "hangcheck-timer". It became *much* more stable. I figure with the next release perhaps they will eliminate the last of the Oracle cluster management software troublemakers - oracm - and RAC will actually become as stable as it was initially hyped to be in 9.0.1 ;-) All this was on a complete front-to-back Oracle "certified" configuration from a major vendor. [In hindsight, I should have been more suspicious when they used the "c" word so often and so loudly...] Don Granaman (reluctant OCP) OraSaurus resurrected - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, February 02, 2003 5:23 PM > Hello everyone, i've been quiet recently, for those of you who know what > I've been up to class has been great, emergency medicine is really kewl. > > Now to the oracle stuff, > > We're having new requirements by multiple clients to ask about RAC(not > necessarily on linux), so a couple of us thought, we'd try to implement > it on a few linux servers, as an experiment to see how its done, etc. > > I'd really not purchase RH advanced Server 2.1 and just try it on rh > 8.0, is this even possible?, I've got like no experience on the > clustering side of operating systems. > > I've searched the OTN, oracle and RH sites to not much luck. > > Anyone tried this on non RH AS 2.1 and just used regular RH 8.0 and if > so are you willing to share the good/bad and otherwise of your luck with it? > > If there is something I missed in the docs on what I need to do to make > it happen, point me that way and I'll be glad to read up on it. > > thanks, joe > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OEM email problems (unix)
we are stumped. We have installed OEM 9.2, the console, the OMS, and 9.2 repository on a solaris 5.9 box. So far, we are not able to send any email from the console, no matter what we try. The messages generally indicated that the email SMPT host (a MS exchange server) can not be found. We found some info on Metalink that led us through some command line tests, which were all successful. The Unix admin, the network folks, the Exchange people, and even a consultant that wondered by, have all given up. any ideas? Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: IOUG 2003
I renewed my membership for 3 years at OracleWorld, so got a significant discount from the $125/year. I mentioned the registration discount for the IOUG-A live! conference registration and they said that was changing too. The person I talked to said that in the future, IOUG membership would be "automatic with conference registration". I'm not quite sure what that means if one is already in IOUG, but I suspect that it means there is no discount! Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 27, 2002 3:44 PM Yea $125, since i wont be attending in 2003, i'm really thinking about unjoining at that price. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: The future DBAs?
Detailed plan for transition from order clerk to DBA: OCP How to become an order clerk: More difficult (no certification exams... yet!) Don Granaman [certifiable OraSaurus & reluctant OCP] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 11:23 PM Wow! Do they offer a detailed plan for your career path from taking orders at LL Bean to storage/networking/data modeling/computer wrangling /SA intimidating/Managerial confusing/Vendor chucking/scripting god/ put-together-an-entire-infrastructure-during-a-break/space eating/ caffeine freaking/Scotch guzzling guru? What I wanna know is, "How do I become an order clerk?" Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i DB, 9i DB and 9iAS on same Unix box, refused
Jared, Well, a hunch paid off. Before doing anything else, I had our Sys Admin reboot the machine. Guess you have to reboot after an Oracle 9.2 RDBMS install. It now works and we can hit the 9i AS system through the web. Thanks. On Mon, 11 Nov 2002 [EMAIL PROTECTED] wrote: > Don, > > Oracle 8.1.7 RDBMS, 9iAS and 9.2 RDBMS should all be installed in separate > ORACLE_HOME's. If may be that the 9.2 database install went to the same > ORACLE_HOME as the 9iAS install. > > If so, you will likely need to reinstall both 9iAS and 9iR2. > > Jared > > > > > > > Don Malzahn <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/11/2002 02:44 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Oracle 8i DB, 9i DB and 9iAS on same Unix box, refused > > > All, > > Environment: > HP-UX 11i > We had Oracle 8i (8.1.7) running successfully on our one host. This host > also has Oracle 9i AS already too. > > Then we installed Oracle 9i R2 (9.2.0.1) on the same host (to run RMAN > backup and recovery on another host). > Since then our one application (FAMIS from PRISM) is having problems > taking connections through the web (9i AS). > > One person here did some research and says perhaps when 9i DB was > installed (to support doing RMAN backups for a 9i DB system on another > box), it overlaid the prior version of Apache. Sounds good to me. We don't > have that much experience in the 9iAS, so we can't really say where the > problem is. The database is up and open and I can hit it from command line > sqlplus. > > Any ideas what went wrong and how to fix it? Should we have done a reboot > of the host after the Oracle 9i install? We did not. > > message: > >=== > ERROR > The requested URL could not be retrieved > > While trying to retrieve the URL: http://cmms.harper.cc.il.us/pls/ftrn/loc.login > The following error was encountered: > · Connection Failed > The system returned: > (61) Connection refused > The remote host or network may be down. Please try the request again. > > Generated Mon, 11 Nov 2002 19:15:16 GMT by fw3.harper.cc.il.us (Squid/2.2.STABLE5) > > > >======= > > > > Thanks. > >- > Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 > E-mail: [EMAIL PROTECTED]Web page: http://www.harpercollege.edu > "The only limit to our realization of tomorrow will be our doubts of > today". - FDR > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED]Web page:http://www.harpercollege.edu "The only limit to our realization of tomorrow will be our doubts of today". - FDR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Malzahn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i DB, 9i DB and 9iAS on same Unix box, refused
All, Environment: HP-UX 11i We had Oracle 8i (8.1.7) running successfully on our one host. This host also has Oracle 9i AS already too. Then we installed Oracle 9i R2 (9.2.0.1) on the same host (to run RMAN backup and recovery on another host). Since then our one application (FAMIS from PRISM) is having problems taking connections through the web (9i AS). One person here did some research and says perhaps when 9i DB was installed (to support doing RMAN backups for a 9i DB system on another box), it overlaid the prior version of Apache. Sounds good to me. We don't have that much experience in the 9iAS, so we can't really say where the problem is. The database is up and open and I can hit it from command line sqlplus. Any ideas what went wrong and how to fix it? Should we have done a reboot of the host after the Oracle 9i install? We did not. message: === ERROR The requested URL could not be retrieved While trying to retrieve the URL: http://cmms.harper.cc.il.us/pls/ftrn/loc.login The following error was encountered: · Connection Failed The system returned: (61) Connection refused The remote host or network may be down. Please try the request again. Generated Mon, 11 Nov 2002 19:15:16 GMT by fw3.harper.cc.il.us (Squid/2.2.STABLE5) === Thanks. ----- Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED] Web page: http://www.harpercollege.edu "The only limit to our realization of tomorrow will be our doubts of today". - FDR
Re: Partition Question
It depends on your reason for partitioning -- if you mean to drop a partition in the future (to roll off the 1999 data or whatever) then the ID range is potentially a valid approach, as long as ID is serial. If you just want to put chunks on different disk volumes, you could use the type or even a hash partitioning scheme. It's down to what you're trying to accomplish, and what is good for one partition key is probably bad or neutral for the other. Hamid Alavi wrote: > Hi List, > > I have a question regarding partitioning: If I want to partition a table > which strategy is better, like do i have to use a value which from first day > of using this table all those partion is using or just using first partion, > then second etc. > E.G: > If I do partion tableA based on ID range 1000, so for few month the only > first partion of this table will be used then second partion, but if I > partion it on Type (1,2,3,4,5) any record can be any of these type and from > first day all of the partions will be used. > Just want to check with you guys which way is better for performance? > THanks for HELP> > > Hamid Alavi > Office 818 737-0526 > Cell818 416-5095 > > === Confidentiality Statement === > 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. > = End Confidentiality Statement = > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: Database design, replacing null by a default value
Properly formulated, a DW only reports on what happened, and ignores what did not happen. If it's really like a DW then you just leave the nulls out. You should do this if you can. Otherwise you have to decide how to lie based on least harm to aggregates. If you average or sum you should use 0 to avoid messing up the sums. If you can use a conditional code to skip a negative, and the negative is not allowed, -1 makes a good null, but you wouldn't want to sum it into an account or anything. Blanks may be an option depending on how Seibel interperets them, but it's probably a coding error. For a varchar I'd use a zero-length string or a single blank, if zero-length isn't allowed. If blanks are significant, first shoot your source system designer, then use ''. :) paquette stephane wrote: > Hi, > > We're in the process of writing functionnal specs for > a system which is like a DW but instead of a DW the > staging area push the data in Siebel. > > If we replaced null by something else. > What would you choose : >for a varchar field ? >for a numeric field ? > > Someone has proposed blanks for the character field > but I'm not comfortable with that. > > TIA > > = > Stéphane Paquette > DBA Oracle et DB2, consultant entrepôt de données > Oracle and DB2 DBA, datawarehouse consultant > [EMAIL PROTECTED] > > __ > Lèche-vitrine ou lèche-écran ? > magasinage.yahoo.ca > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Port usage?
Environment: Oracle 8.1.6 AIX server behind a firewall db is accessed by a Windows application running on a IIS web server sitting outside the firewall db uses port 1521 After a flurry of email between the Unix admin and the 4 software vendors concerned, all the fingers are now pointing at "that damn oracle database". The Unix admin is asking two questions: 1) what Oracle is doing with the four ports 20,000 - 20,003 2) can he shut them down? Any ideas are appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Actual list of supported/desupported versions of Oracle
Ray, Thanks, that's a nice little chart to have. At 11:59 AM 10/22/02 -0800, you wrote: I found this list which is pretty good summary: Oracle Server (RDBMS) Releases Support Status Summary Type: Note Doc ID: 161818.1 http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=161818 .1&p_showHeader=1&p_showHelp=1 === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --------- Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED]Web page: http://www.harpercollege.edu "The only limit to our realization of tomorrow will be our doubts of today". - FDR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Malzahn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Standard Edition and Enterprise Edition on same box?
Environment: HP_UX 11 This is a Development environment only. Can one safely run Oracle DB Standard Edition and Enterprise Edition on the same machine? I know this sounds odd. We have two packages, Application (A) which still runs Oracle 8i for the db, and for that we purchased 10 named users and x processors. Application (B) uses Oracle 9i AS Enterprise Edition with 10 named users. >From purely a technical standpoint, can you run both on the same box and not have it break or cause really bad performance. As we move forward into production, we'll need to buy more and different licensing, because Application (B) is web-based. And it would be split over different host computers in production, not both on the same, calm down. 8*) Thanks. ---- Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED] Web page: http://www.harper.cc.il.us "The only limit to our realization of tomorrow will be our doubts of today". - FDR Yahoo! Groups Sponsor ADVERTISEMENT [IMAGE][IMAGE] width Replies to this message will be sent to ALL members of the group. If your response is personal, please send it directly to the person who posted. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Malzahn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Loading a flat file into Oracle
Santosh, The Oracle "Utilities" manual is not bad either, it explains sqlldr and export and import, all database utilities that come with the database. Find it at the Oracle web site if you don't have a copy. > I suggest you look at sqlloader. There are some good pages on the FAQ > associated with this site > I have a client who will be doing the data capture and give me the > data in a flat file. > what i need to do in oracle is load from that flat file to my database. > any scripts available ?? please send me across. ASAP ---- Don Malzahn, IT/AS, Harper Community College Voice:(847) 925-6829 E-mail: [EMAIL PROTECTED]Web page: http://www.harper.cc.il.us "The only limit to our realization of tomorrow will be our doubts of today". - FDR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Malzahn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
rebuilding an instance from a cpio file?
I have a huge cpio file that a sys admin created when it was decided to remove an instance (8i) from a test server. I don't know for certain what to do with this file, but I'd like to get that instance back up and running long enough to do an export of the db. Can somebody help with the syntax to list out the contents of the cpio file? I have read the man pages, but I can't figure out the syntax to just list the cpio contents. Thx, in advance, for you help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: using obfuscation
Sorry, I munged the create view with the query.. I was reminded of a meeting while typing the note :) create view my_data as select de_encrypt(sensitive_data) as clear_sensitive_data, sensitive_data from my_table; create index on my_table(sensitive data); select clear_sensitive_data from my_data where sensitive_data = encrypt('CLEAR TEXT') Upon review, it does provide a cyphertext/cleartext attack, doesn't it? Just goes to show you -- security is hard. "Steiner, Randy" wrote: > Don, > > It seems like a real good idea, but what am I putting inside my call to the > encrypt function in my Create View statement? > > Randy > > -Original Message- > Sent: Tuesday, September 10, 2002 10:13 AM > To: Multiple recipients of list ORACLE-L > Subject:Re: using obfuscation > > << File: Card for Don Jerman >> What about... > > create view my_data as select de_encrypt(sensitive_data) as > clear_sensitive_data where > sensitive_data = encrypt('CLEAR TEXT') ? > > This lets you create an index on the sensitive data without decrypting it, > and > the function need only be called once on the clear text. > > Caveat: no idea if this should work :) > > "Steiner, Randy" wrote: > > > Hi all, > > > > I have downloaded the Metalink Notes on implementing dbms_obfuscation. I > am > > using multiple front ends on the database, so the way I plan to implement > > the de-encryption is with a de-encrypt function in a view. > > > > Create View my_data > > AS > > Select de_encrypt(sensitive_data) AS sensitive_data > > ,other_data > > FROM original_table > > ; > > > > If I select from the view with a where clause on other_data, the response > > time is fine. If I select from the view with a where clause on > > sensitive_data, I do a full table scan and which takes about 15 minutes. > > The de-encrypt function is copied from a Metalink note, nothing fancy. > > > > Since I have various front ends, I can not de-encrypt the data in the > front > > end. The only way I can think of is with the function in a view, but the > > response time is unacceptable. Does anyone have any thoughts on this? > > > > Thanks > > Randy > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Steiner, Randy > > 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: Steiner, Randy > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: using obfuscation
What about... create view my_data as select de_encrypt(sensitive_data) as clear_sensitive_data where sensitive_data = encrypt('CLEAR TEXT') ? This lets you create an index on the sensitive data without decrypting it, and the function need only be called once on the clear text. Caveat: no idea if this should work :) "Steiner, Randy" wrote: > Hi all, > > I have downloaded the Metalink Notes on implementing dbms_obfuscation. I am > using multiple front ends on the database, so the way I plan to implement > the de-encryption is with a de-encrypt function in a view. > > Create View my_data > AS > Select de_encrypt(sensitive_data) AS sensitive_data > ,other_data > FROM original_table > ; > > If I select from the view with a where clause on other_data, the response > time is fine. If I select from the view with a where clause on > sensitive_data, I do a full table scan and which takes about 15 minutes. > The de-encrypt function is copied from a Metalink note, nothing fancy. > > Since I have various front ends, I can not de-encrypt the data in the front > end. The only way I can think of is with the function in a view, but the > response time is unacceptable. Does anyone have any thoughts on this? > > Thanks > Randy > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steiner, Randy > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: Velpuri bkup script-syntax error
5 years ago, I worked through his UNIX flavor B/U scripts and found several errors. Over a 2-3 week period, I had multiple phone conversations with the Osborne editors with assurances, that the problems would be fixed IMMEDIATELY in the download files. They effused many thanks for my time and assistance. I sent them my corrected scripts, with full documentation a)what the "bug" was, b) the error that was generated, c) the solution. So much for promises I guess. At 09/02/2002 07:38 pm, you wrote: >Did anyone else run into the error "dbbackup_begin: syntax error at line 521 >'end of file' unexpected" after trying to use the Velpuri backup scripts for >Unix? Where was the problem at and how did you resolve it? I downloaded the >scripts from the Osborne website and this is the error that keeps occuring. >Before trying to set up some other scripts, I wanted to give the Velpuri >scripts one more shot. > >Thanks. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Eric Richmon > 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: Don 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 9.2 Stability Feedback Requested
All the bugs? Possible? Perhaps... Reality? Nope. The crippling bugs with SMU appear (at first glance) to be fixed in 9.2, but there is no shortage of other bugs. The first one I found was with many queries against the data dictionary being 70-180 times slower! I'm running 9.2.0.1 on Linux - exclusive and RAC - but not yet production. On the 9.2.0.1 RAC nodes, I'm getting tons of trace files with CMInit warnings, but support said "Don't worry. Be happy. Its OK" Searching for patches for 9.2.0.1 on Linux, I get 22 hits. Most are related to some bug ;) Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 2:13 PM Dave - Can you post the bug number? I searched Metalink and couldn't find any matches for 9.2. Is it possible that Oracle fixed the bugs by 9.2? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 20, 2002 12:57 PM To: Multiple recipients of list ORACLE-L Sam, The only problem I have come acroos is using SMU [ system managed undo ] instead of rollback segments Check metalink under bug database Dave Clarke. Cisco Systems - Amsterdam -Original Message- Sent: Tuesday, August 20, 2002 6:39 PM To: Multiple recipients of list ORACLE-L Hi Can anybody tell me what the track record has been for Oracle 9.2? Has it been reliable and stable? We have clients asking us about Oracle 9.2 and I would like to gather some experience from the field on how reliable it has been. Most of our clients are running Windows NT/2000, some are running UNIX. Appreciate any feedback anybody can provide. Thanks a lot. Sam Bootsma, OCP Technical Support Analyst [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma 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: Dave Robert Clarke (daclarke) 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: Don Granaman 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: Senware AutoDBA
That was truly a disaster of a session. I, and the small group I was with, left almost immediately. I was on the sundeck for the post-mortem though and even have a nice picture of Gaja discussing (emphasis on "cuss") it with Stan. I believe the presenter was the CTO, but I'm not sure. I have been hounded constantly about AutoDBA by a sales rep from Insession Technology. After a cold call from her, long before the conference, I asked for some technical material on it and got only marketing material - even the supposed "technical white papers" were pure marketing blather. I did try to get a "trial download" off their web site. I "registered" only to find out that there was no trial download. Instead, I got another call from the same sales rep offering to come out and give a presentation to executive management - and perhaps, after that, to come out and install a trial version. I have never seen AutoDBA nor used it, but I have formed a strong subjective opinion that it is most likely pure garbage. I apologize if anyone here is associated with this product and offended. Please don't take it personally - my admittedly highly subjective opinion is based largely on the tactics of marketing weasels. Here is the basis: 1) The presentation at IOUG-A Live! 2002 (The last straw - I already had a dislike for AutoDBA before that.) 2) The fact that they couldn't or wouldn't offer any substantial information about it - only marketing rhetoric. 3) The marketing is hyperbole full of exotic-sounding buzz-phrases meant to impress PHBs (e.g. "Utilizes advanced artificial intelligence, predictive analysis algorithms, and intelligent neural network technologies") - and it seems to be based mostly on the standard tuning myths (e.g. "As space is allocated in an Oracle database, the tablespaces become increasingly fragmented which hinders database performance. AutoDBA automatically repairs these fragmented tablespaces, improving database efficiency"). 4) The tactic of wanting to "sell" it to upper management before offering a trial copy or even significant technical information about how it works and what it does. 5) The proverbial "Big One" - I now work closely with someone who was not long ago a manager at a company that markets AutoDBA and was the project manager on that company's initial "evaluation" of the product. They said that AutoDBA sent out a couple of their "experts" who spent three days trying to get it working - installing it, patching it, downloading stuff from all over the web, patching it again, hacking ... and it still barely worked. They begged off the project (and shortly after left the company) when told in no uncertain terms that their "evaluation" needed to be "very positive". Granted, that was over a year ago and the product may have improved since then, but as recently as a few months ago a "registration" for a "trial download" on the web lead only to a marketing call. No thanks... I feel a bit queasy even now just thinking about it. Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 2:24 PM FWIW, someone from Senware presented a paper at IOUG 2002 titled 'Performance management from the ground up' (or somthing like that) which was a load of &*$% to say the least. Most of the audience (many on this list) walked out in disgust after the first 10 minutes (Does someone remember the 'green peas' story?) If their product is even twice as good as their rep, it would not be worth considering. I am not blaming their desperate tactics however. Anything to sell a product in this economy :( Just came off a marketing call on the office phone for services I don't need! John > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 21, 2002 11:04 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Senware AutoDBA > > > Interesting web site. > > They claim to eliminate chained rows by rebuilding the tables. > I'd like to see how they intend to do that. > > They also claim that their product can detect corrupt indexes > and rebuild them. How hard can it be to detect ORA-1578? > This kind of thing is fairly rare, and hardly seems worth the > resources to run DBMS_REPAIR or dbv to check for. > > Their MO is hardly new. IBM has had a team in place for years > designed to make an end run around the purchasing mgr/DBA/whoever > when their product wasn't selected. They go to upper mgt to > try and convince them of the foolish mistake the product > evaluators made. > > Not surprising that
Re: query problem
how about select tab1.id from tab1,tab2 where tab1.id=tab2.id group by tab1.id having sum(decode(tab2.status,'Y',1,'N',-1,0)) > 0; Harvinder Singh wrote: > Hi, > > we have 2 tables tab1 and tab2 each having id column and tab2 also has column status >that will contain value 'Y' or 'N' > for particular id and tab2 has many records for particular id > we need to select distinct id from join of these 2 tables where status in tab2 has >more 'Y' than 'N' > > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: Replication
Light works with a 9ias application (part of the Light package) to establish the mobile database and application on the mobile client. Once the application and database are downloaded, the database uses Advanced Replication to sync with the master when the clients are brought back to the network. While mobile, Light emulates the oracle server (and potentially the 9ias server) for a single user. You have a master database server connected to the mobile data server (9ias) which handles the interface to the mobile clients (laptops, desktops, what-have-you). Up to 64 mobile clients per mobile server, if I remember the marketing speil right, but we're still at the 4-client dev/test phase. We have staff working on it, with assistance from an Oracle consultant brought in for the purpose. I just deal with the master database. Since we're doing stand-alone, we have to hand-jar the java applications (the jar wizard with Oracle Developer doesn't fit the bill somehow) so application deployment is the sticking point at the moment. We might get an answer this month, but the dev manager is doing the schedule and application details. My understanding is that if you deploy a JSP web app using 9ias, the app can be downloaded and run on the mobile client against the Lite database, and that sort of deployment appears to run smoothly (the examples work). But we're not doing that in this case so I have no real-world experience there. "Ramon E. Estevez" wrote: > Don, > > What are you using for deploy the applications ?? > > I am interested in this topic too. > > Ramon > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, August 02, 2002 10:33 AM > > Oracle Lite is designed to do this -- the content-deployment part for > standalone applications is a little buggy, but the data deployment and > web-app deployment seems to work. We're instituting a couple of > applications with this now, and data sync seems to be working fine. > Application sync has been getting most of the attention so far, though, as > we try to get the programs deployed properly without by-hand intervention. > > paquette stephane wrote: > > > Hi, > > > > We will develop a new system that has a central > > database (817/win2000). > > >From times to times, some users will worked with a > > deployable version of the application in a region > > without network connection. > > When the users are back, there should be able to > > synchronize with the centralized database. The data > > goes from the deployable version to the centralized > > database only. > > > > What strategies can be considered ? > > > > = > > Stéphane Paquette > > DBA Oracle, consultant entrepôt de données > > Oracle DBA, datawarehouse consultant > > [EMAIL PROTECTED] > > > > ___ > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > > Yahoo! Mail : http://fr.mail.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: =?iso-8859-1?q?paquette=20stephane?= > > 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: Ramon E. Estevez > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: Replication
Yes that's how it works, although the volume for 2-3 months might be excessive, if the deltas get large. Light uses Advanced Replication to manage the deltas so the resolution process might take a while. paquette stephane wrote: > Hi, > > Oracle Lite would not be good for us as when I said > users are working with a deployable version, I mean a > bunch of users go away with their server/database and > come back 2-3 months after, then they synchronized the > master database. > > --- Don Jerman <[EMAIL PROTECTED]> a écrit : > > Oracle Lite is designed to do this -- the > > content-deployment part for > > standalone applications is a little buggy, but the > > data deployment and > > web-app deployment seems to work. We're instituting > > a couple of > > applications with this now, and data sync seems to > > be working fine. > > Application sync has been getting most of the > > attention so far, though, as > > we try to get the programs deployed properly without > > by-hand intervention. > > > > paquette stephane wrote: > > > > > Hi, > > > > > > We will develop a new system that has a central > > > database (817/win2000). > > > >From times to times, some users will worked with > > a > > > deployable version of the application in a region > > > without network connection. > > > When the users are back, there should be able to > > > synchronize with the centralized database. The > > data > > > goes from the deployable version to the > > centralized > > > database only. > > > > > > What strategies can be considered ? > > > > > > = > > > Stéphane Paquette > > > DBA Oracle, consultant entrepôt de données > > > Oracle DBA, datawarehouse consultant > > > [EMAIL PROTECTED] > > > > > > > > > ___ > > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite > > et en français ! > > > Yahoo! Mail : http://fr.mail.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: =?iso-8859-1?q?paquette=20stephane?= > > > 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). > > > begin:vcard > > n:Jerman;Don > > tel;work:919.508.1886 > > x-mozilla-html:TRUE > > org:Database Management Service,Information > > Technology > > version:2.1 > > email;internet:[EMAIL PROTECTED] > > title:Database Administrator > > adr;quoted-printable:;;Database Management > > Service,Information Technology=0D=0A104 Fayetteville > > Street Mall;Raleigh;NC;27699-1521;USA > > x-mozilla-cpt:;-9536 > > fn:Don Jerman > > end:vcard > > > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: Replication
Oracle Lite is designed to do this -- the content-deployment part for standalone applications is a little buggy, but the data deployment and web-app deployment seems to work. We're instituting a couple of applications with this now, and data sync seems to be working fine. Application sync has been getting most of the attention so far, though, as we try to get the programs deployed properly without by-hand intervention. paquette stephane wrote: > Hi, > > We will develop a new system that has a central > database (817/win2000). > >From times to times, some users will worked with a > deployable version of the application in a region > without network connection. > When the users are back, there should be able to > synchronize with the centralized database. The data > goes from the deployable version to the centralized > database only. > > What strategies can be considered ? > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! > Yahoo! Mail : http://fr.mail.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: Massive update troubles
"should" being the operative wordthey "should" be doing the transforms prior to or during load (in my opinion), since they're file-filter or file-merge operations mostly. Bart Cortenbach wrote: > "...the SAP requirements are slowly mutating...", > "...the developers are still tweaking the process..." > > If the developpers are still tweaking the process, and the requirements > still evolving, it means that they are still in a test phase. > If they are still in a test phase, they shouldn't use production files but > test files...smaller files. > > Don Jerman <[EMAIL PROTECTED]>@fatcity.com on 2002-08-01 17:14:40 > > Please respond to [EMAIL PROTECTED] > > Sent by:[EMAIL PROTECTED] > > To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > > I have a data conversion team working on our financial data, > prepping it for load into SAP. My concept for the conversion > process was to download the flat files, run programs written in C > or Perl to transform the data, then use SQL*Loader to load them > into relational tables for constraint testing and general > analysis, prior to export to the SAP system. > > At some point early on I lost control, and this mutated into: > download the flat files, load them into Oracle, run stored > procedures to transform the data through 2 or 3 stages to a new > schema for SAP. Still ok, you're thinking. > > But -- now we're running more than a couple hundred thousand rows > at the time, and the developers are still tweaking the process > (because the SAP requirements are slowly mutating -- another > issue). Frequently the developers will stop a long running query > with ALTER SESSION KILL -- this is working but often takes a very > long time to roll back. Well, there's the rub -- this is a PC > system, and the developers frequently want to make a tweak to > their program and re-run it. This puts a tremendous load on what > the PC isn't good at -- I/O. > > So I wind up with a frantic developer on the phone "the Oracle > server's locked up!" and sure enough, he's right -- there's so > much going on in there you can't do anything that requires a disk > access. The evolved response is shutdown abort, startup > mount, recover, open. This always works and always takes about 3 > minutes. Naturally, I've moved them to their Very Own server, so > that this doesn't disrupt other work. > > Can anyone turn their diagonstic eyes on this situation and > suggest a better method for me to either limit the damage or > recover from the problem? Or even a good method for analyzing > the problem, given that we haven't the downtime to wait for all > processes to complete (once in this state, a weekend can pass > without successfully ending whatever the database is doing). > > (See attached file: djerman.vcf) begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: User with less privileges...
I agree on the use of roles - it is the best way to go. However, beware that object privileges granted via a role are NOT in effect inside a definer's rights procedure/package (the default type). This *may* require some investigation and, perhaps, some changes to the application, the privileges of the package owner, the owner of the package, or the package authid, or ... I disagree about granting CONNECT to everyone - grant "create session" instead. CONNECT is actually a pre-defined role with a number of system privileges that most application users do NOT need (alter session, create table, create cluster, create database link, etc.) in addition to the "create session" system privilege. Likewise, I would grant explicit tablespace quotas. Granting RESOURCE is again overkill. Most application users don't need tablespace quotas and even if they do it is usually something trivial (e.g. 1-10 MB) in USERS. The system privilege "unlimited tablespace" (included in the RESOURCE role) is especially dangerous as it includes the SYSTEM tablespace. The "easy way" out is to just grant *everything* to PUBLIC, but it is a very poor choice from any rational security perspective - as you are now discovering. (Oracle preaches this, but doesn't actually practice it themselves!) You will need to do as Bill suggested: 1) Create a set of application-specific functional roles (e.g. CUST_SVC_REP, CUST_SVC_SUPR, CUST_SVC_ADMIN, ...). 2) Grant privileges to roles as appropriate 3) Grant roles to users as appropriate 4) Revoke all (most?) of the application object privileges (and perhaps some others) from PUBLIC The public synonyms are another issue. The don't carry any intrinsic privilege - SELECT, INSERT, etc. still have to be granted to the user or to a role granted to the user. However, public synonyms can be a performance issue and *may* be undesirable for other reasons. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 11:28 AM try this: rather than granting specific privs to PUBLIC, create specific roles for the different types of users you have, and grant appropriate object privs to each role (granting connect also helps :-). then for each user you add, just give that user whatever role is relevent and you're set . . . they will still be able to access public synonyms. only issue with this is that you'll still need to specify TS quotas to the specific users, as they don't inherit these from the roles (unless you grant RESOURCE to the role, which has UNLIMITED TABLESPACE). using roles is easy to maintain, document and manage -bill -Original Message- Sent: Thursday, August 01, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Hi guys. Can you give some ideeas about this problem. I have a schema which contains all the objects for the application. The user owner of the schema is also the application administrator and having more privilleges. The other users can have access to these objects by beeing granted with some special privilleges (like select/update/insert/delete for tables, execute for functions&procedures) Because the user are deleted or added from time to time, the application author decided to grant the above kind of privilleges to the public and also create some public synonyms with the same names as the originals. BUT, my problem is that now I need to create an user (he does not have any relations with the ordinary application users) which I don't want to have any access to the hrowner objects, or just on few. Is this doable working only on this new user or I have to re-create all those synonyms and grant privilleges to every application user and revoke'em from public? Thank in advance! iulian ** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania SA is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. ** -- 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
Massive update troubles
I have a data conversion team working on our financial data, prepping it for load into SAP. My concept for the conversion process was to download the flat files, run programs written in C or Perl to transform the data, then use SQL*Loader to load them into relational tables for constraint testing and general analysis, prior to export to the SAP system. At some point early on I lost control, and this mutated into: download the flat files, load them into Oracle, run stored procedures to transform the data through 2 or 3 stages to a new schema for SAP. Still ok, you're thinking. But -- now we're running more than a couple hundred thousand rows at the time, and the developers are still tweaking the process (because the SAP requirements are slowly mutating -- another issue). Frequently the developers will stop a long running query with ALTER SESSION KILL -- this is working but often takes a very long time to roll back. Well, there's the rub -- this is a PC system, and the developers frequently want to make a tweak to their program and re-run it. This puts a tremendous load on what the PC isn't good at -- I/O. So I wind up with a frantic developer on the phone "the Oracle server's locked up!" and sure enough, he's right -- there's so much going on in there you can't do anything that requires a disk access. The evolved response is shutdown abort, startup mount, recover, open. This always works and always takes about 3 minutes. Naturally, I've moved them to their Very Own server, so that this doesn't disrupt other work. Can anyone turn their diagonstic eyes on this situation and suggest a better method for me to either limit the damage or recover from the problem? Or even a good method for analyzing the problem, given that we haven't the downtime to wait for all processes to complete (once in this state, a weekend can pass without successfully ending whatever the database is doing). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
Unfortunately, we have no choice but to use the java-infested, half-baked ruinStaller. Don't even get me started about the DataBase Cremation Assistant! Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 12:25 PM > > > > ...hardcore DBAs might never use GUI tools. > > > > I fit that category. :) > What about the OUI? Don't you use that? :) Dan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Cursor Sharing
Actually, "CURSOR_SHARING=FORCE" is in the index. ;-) The short (?) story is that it is a crutch. It can provide some relief from applications that pour out tons of nearly identical SQL -varying only in literal values, but it can also cause some significant problems. Also, there are a lot of bugs with it in all the versions I've used it in (8.1.6.x and 8.1.7.x). My experience is that it (a) works and (b) helps significantly in about 30% of the system where I've tried it. Bugs include things like: 1) "... where col1='X'and col2='Y' (in 8.1.6.x, it substitutes wrong and generates an error. Fixed in 8.1.7) 2) If the first value in a bind list is a null, it can generate a process crash with an ORA-07445 (in 8.1.7.1.? at least) 3) Java thin clients can return wrong results (hearsay - from Stan Yelliot) --- Moral of the story - test it *very thoroughly*! It can also cause some significant problems, even when it works "correctly". For example: *) It cures the most obvious symptoms, but not the disease. Developers often like to think otherwise and simply continue bad coding practices. CURSOR_SHARING still doesn't avoid a soft parse. Applications with lots of literals typically don't reuse cursors either. Partially "masking" serious design and coding flaws with "magic bullets" like CURSOR_SHARING=FORCE doesn't actually solve the much larger systemic problems. It is likely to buy you some time and fewer headaches with thrashing in the shared pool, but it still isn't very scalable in the long run. *) *ALL* literals get substituted. This can throw the optimizer off. Examples: (1) "where ... and 1 = 2" ("Oh! I don't really need to fetch any rows!" isn't obvious.) (2) When a literal causes the optimizer to use histograms well. STATUS_CODE has possible values of 'OPEN and 'CLOSED'. 99% of all records have 'CLOSED', but 99% of all queries are for 'OPEN'. DBAs would gladly "suffer" an extra statement with literals rather than suffer a poor execution plan for 99% of the executions. I consider using CURSOR_SHARING=FORCE like I would consider using a tourniquet - its preferrable to sudden death, but it isn't applicable in every case and is rarely a great long term solution. About three days ago, I had this discussion with a (very technical) VP. *Everything* is written with literals. Every literal statement is "prepare()"ed. I explained the basic issues to him and his preference was not to use it. He wants to force a resolution of the deeper issues by letting the situation become so bad soon that it forces a better, more permanent solution - before the rapidly increasing transaction volume REALLY hits the fan. The CURSOR_SHARING=FORCE safety valve is something we are reserving as a last, temporary resort. Don Granaman [OraSaurus] BTW: Hi Mike! - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 24, 2002 7:23 PM Mike, What is the version of the database? Some versions of 8.1.7 had a few bugs when this parameter was set to FORCE. I suggest searching Metalink. But it does work as advertised in later releases. I would also recommend reviewing Tom Kytes' book to read about his views in using this parameter at the instance level (my boss is reading my copy, so I can't give you page #s). - Kirti -Original Message- Sent: Wednesday, July 24, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Has anyone set Cursor Sharing to Force ? I have a new system that we have to support and there is alot literals filling up the pool.I have never changed this parameter from the default as many seemed to think the jury was still out on it. However, due to my situation, I figured I would try it out. If anyone has any experience with this one I would be curious to know what happened. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael 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 -
Re: SMP on windows2000
My understanding is "according to design" it should do it automatically. My experience is it does, sort of. But the app has to be multi-threaded (by the OS definition, not just context-mapped like Java green threads) for it to ever use more than one processor at the same time. If your single-threaded then for obvious reasons NT will tend to give the next time-slice to the same processor if it's not busy, so it looks like you're stuck on the same one much of the time. With the task manager you can set "processor affinity" on MP machines from the right-click menu of the process. This limits which of the N processors will be used to schedule your process. So you can limit one processor hog to 1 or 2 processors and let the well behaved programs run freely on the others. I don't know how to do this using non-gui tools or to set it up at start time, and your userid has to have permission to do it (essentially you have to be running as the process owner). But it's a starting point for research :). "Boivin, Patrice J" wrote: > I am probably just complaining now, I think I know the answer already. > > Is it possible to force Windows2000 to "spread the load" for one application > to 2 or more CPUs, from the OS side? > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boivin, Patrice J > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: Rant - Oracle Security
Whenever I talk about database security, I put the emphasis on the much more common accidental damage. If the focus is on preventing external attack, everyone dozes off - few have had (known, at least) penetrations that got to the DB server. However, how many DBAs have NOT had a case of someone calling them and saying something like "Ooops! I dropped the ORDERS table in PROD. I thought I was in DEV." or "Can you restore the 20 records I accidentally deleted?" or ... ... or have never done something themselves like "lsnrctl stop" and discovered that they actually shut down the listener on a node other than the one intended? This kind of stuff probably happens a million times more often than things like SQL injection attacks. Sound security practices make both accidental and malicious damage much more difficult. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 11:13 PM I agree that the "glory" is in tuning, but I also think backup/recovery gets a sufficient amount of respect. It's nice now that advocating RMAN isn't considered snake-oil... Where I get funny looks these days is when I discuss database security. I try to defuse the tension by quoting the old saw about "just because you're paranoid doesn't mean they're not out to get you", but people still fidget and look away in pity as if I've lost my mind. I asked two audiences recently how many people utilize the SYSOPER role, and only one person in the second audience raised his hand. Similar effect if you ask about password management... ...I have to admit that some of the scarier folks are the ones who agree totally, though... :-) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 8:28 PM > mkb, you're right, the "glory" is in tuning nowadays, but i beg to > differ, since if you can't/won't do recovery when the chips are down, > then the point is moot. > > I specialize in backup/recovery but getting damagement to think its > important today when the db is running fine, is tough. Its only when > its time to do recovery does damagement all of a sudden think its important. > > Joe > > > mkb wrote: > > >Ok, I need to vent a little. > > > >Last week, I was asked to do some tech interviews over > >the phones for a mid level DBA position. Someone with > >about 2-3 years experience. > > > >I don't consider myself a real smart DBA, nor do I > >think that I ask particularly tough questions. The > >questions that I ask potential candidates are soley > >based on what is on the resume. So I figure if > >someone has, say, hot backups or SQL tuning on their > >resumes, I'd expect them to be able to hold a fairly > >intelligent conversation about these topics. No such > >luck! > > > >What really frustrated me, and what I really want to > >get out of my system, is that nobody that I talked to, > >had a real good concept of hot backups. Forget about > >recovery. I asked each and every candidate who > >claimed to have done hot backups, just give me a high > >level overview of how you do a hot backup. Don't care > >about syntax, just give me the mechanics. The answers > >I got were completely off base, baffling and > >frustrating. Some of these folks claimed to have 5 > >years experience!!! > > > >'Well, we use scripts to do these, so I'm not sure how > >these are done...' (But it says on your resume you've > >done this???) > > > >'Oh, I take the tablespace offline, and copy the > >datafile to tape...' (Unless I'm mistaken, that's not > >how a hot backup is done, right?) > > > >'Well, I use the export utility, and as the backup > >starts, it is written to the dump file.' (Huh? What?) > > > >'During this time, everything is written to the redo > >logs and not to the tablespace...' (You've been > >reading one of those books, haven't you?) > > > >I also asked them how they'd put a tablespace in > >backup mode. Simple enough, right? Not one of them > >got it right. Not even close. Didn't have clue as to > >what I was talking about. Fair enough, you don't > >know. Well how about a simple recovery scenario. I > >asked every candidate how they would do an online > >recover of a datafile while the database was still in > >use. No ideas. Not even close. > > > >I dunno, perhaps I'm spoilt by being
Re: Please share your experience with RAC on linux:)
I'm working on getting a new system up on the same (?) platform - Dell PowerEdge 6450 nodes, Dell/EMC FC4700 array, and 9i RAC. Click on the Dell/Linux "Yes" in the certification matrix at: http://www.oracle.com/ip/deploy/database/features/ops/certification/index.ht ml?content2.html 1) The current certification is only for RedHat 7.1 and Oracle 9.0.1, but the Dell rep says that 9.2 should be certified on RedHat Advanced Server within "a month or so". There are some distinct advantages to the new RedHat release - and to 9.2. So far, we are just doing some burn-in and "get aquatinted" with RedHat 7.1 and 9.0.1 RAC. The SA/VP wants to go live ASAP and prefers the current config. After seeing the long list of patches to 9.0.1, some issues with it, and some serious security holes (as mentioned here a month or so ago), I am in favor of testing out 9.2 on Advanced Server and using RH7.1/Oracle9.0.1 only as a fallback position. For one thing, the Oracle-supplied cluster software is (at least) "quirky" in 9.0.1. It is supposed to be significantly better in 9.2. RedHat Advanced Server is supposed to add a lot also - multiple HBAs, a logical volume manager, etc. 2) I use SuSE at home and it is a much smoother Oracle install than any (6.2-7.2)RedHat - at least for Oracle 9.2. SuSE even supplies an "orarun9i.rpm" to configure the kernel, startup scripts, and a bunch of stuff for Oracle9i (or "orarun8i.rpm" for 8i). In addition, there are several very savvy SuSE technical people (e.g. Michael Hasenstein and others) who frequent the SuSE-Oracle mailing list. Oracle on RedHat (any version) seems to always require jumping through a few more flaming hoops. However, RedHat is now in bed with Oracle again - after their little falling out. Even more important is that Dell officially supports only RedHat for RAC. (They also support SuSE, but do not certify it for RAC - or, I think, Oracle in general.) 3) RAC on Dell/RedHat is headed for production "soon", but no production experience yet. I'm still working out the basic cluster quirks - like why softdog wants to reboot the nodes several times per week! (The most recent, about 48 hours ago, was because nts hiccuped and the clocks on the two nodes got about 1/2 hour out of synch.) Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 9:28 AM hi, dbas: We plan to setup a new database on a Linux Cluster, using Oracle 9i RAC release 2, with Dell PC Servers (4CPU, 4G memory), to store our online history data and provide read only service and some other misc applications. So, what i care is: 1. Which Oracle version to use, release 1 or release 2. Release 1 is certified on many platforms with proper hardware and os, but release 2 is relatively new. But since oracle supports new version and there is maybe less bugs , i prefer release 2 version . Can you share your opnion? 2. Which OS to choose. Suse and Redhat is the oracle prefered version. For RAC/OPS support , is suse better than redhat? Or if i choose redhat, shall i choose the redhat 7.1(the certified version with rac release 1 on Dell machine) or Redhat Advanced Server, or redhat 7.2/7.3? 3. Has anyone here used RAC in production? Especially on Linux/RAC combination? what about your experience? Please share your valuable experience here:), thanks. Good luck chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos 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: Don Granaman 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: Rant
What Ruth describes is "tablespace point in time recovery" or incomplete recovery. I believe the question was about performing complete recovery on a single tablespace while the rest of the database is in use. (I could be wrong in this assumption.) If a single tablespace (other than SYSTEM!) needs complete recovery, then: 1) SQL> alter tablespace BAD_ONE offline; 2) restore corrupted tablespace datafile(s) from backup 3) restore archive log(s) from backup if necessary 4) SQL> recover tablespace BAD_ONE; 5) SQL> alter tablespace BAD_ONE online; While this is happening, object in other tablespaces are fully accessible, except that there may be some issues with objects in other tablespaces that reference objects in the BAD_ONE tablespace (e.g. foreign key constraints referencingtables in BAD_ONE, tables in other tablespaces with CLOBs stored out-of-line in BAD_ONE, tables with primary or unique key constraint indexes in BAD_ONE, etc.). There are a few variations on the theme for step 5 - for example, "recover datafile" perhaps if all the datafiles for the tablespace are not corrupted. Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 1:13 PM You have to restore the tablespace with the datafile you want to restore to a clone database and export the datafile's contents from the clone and import it into the database with the bad datafile. HTH, R - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 12:13 PM I read your rant, and I agree with you. But I do have one little itsy bitsy question... > I also asked them how they'd put a tablespace in > backup mode. Simple enough, right? Not one of them > got it right. Not even close. Didn't have clue as to > what I was talking about. Fair enough, you don't > know. Well how about a simple recovery scenario. I > asked every candidate how they would do an online > recover of a datafile while the database was still in > use. No ideas. Not even close. How DO you do an online recovery of a datafile while the database is still in use? I've had to do recoveries before, but never this scenario. Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Rant
CDs have some advantages - expense, searchability, and storage space primarily, but... 1) CDs are more difficult to read in bed, on a plane, waiting in the terminal, etc. 2) Books are easier to read, require less equipment, and are more portable than a computer and a CD 3) Try having six different CD manuals open to related sections spread out in front of you - reading them while you work against the database. 4) An open book shows two full pages of information. An open PDF about half a page. 5) I could usually grab a manual and flip through it to the relevant info about 10x faster than a computer search - and with a lot less extraneous (click/point/scroll/type) activity. 6) Highlighters, margin notes, and sticky-note bookmarks don't work at all with CDs I miss hardcopy manuals! Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 3:18 PM RE: RE: RantNot me. I LOVE the cds. I copy them onto my hard drive and use the pdf versions. they are SEARCHABLE. I can find things much more quickly in the pdf's than paper. Oracle is the only product that I feel this way about .. probably because they have more documentation than the library of congress! -Original Message- <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 3:54 PM To: Multiple recipients of list ORACLE-L I can see why they stopped distributing them though, it must have been costly. It doesn't remove the fact that it would be handy to have paper copies of the manuals. It's hard to put yellow sticknote tabs on a CD. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- 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: Don Granaman 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: Index questions
Bitmapped indexes will be fast for the queryagainst the 'Y's, but a bitmapped index may not be appropriate if you are getting lots of DML activity on this. Another option is to use NULL instead of the "vast majority" value ('N' - in this case) and create an index. The nulls won't be indexed, so the index will be small. This works best when there are relatively few non-majority values and they are the ones most critically/commonly queried. A hint MAY be required to make the CBO use the index. This obviousy won't help on queries against 'N' though. Example, ORDERS table with a STATUS column - 98% 'Closed', 2% ('New' | 'Pending' | 'Whatever...'). Change the logical to interprete NULL as 'Closed' and create an index on ORDERS.STATUS. Queries for open orders - ('Closed' | 'Pending' | 'Whatever...') become very fast. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 15, 2002 2:58 PM If we have a column of 'Y','N' values, the index will not help with CBT(usually most of the values are 'N'). My question is : how about bitmap indexes? Should it help a lot, or just a little bit? Thanks, Chris Harvest __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest 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: Don Granaman 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).
TOra: Toolkit for Oracle
I've seen some chatter here about Tora, but when I go to http://www.globecom.se/tora/ or http://www.globecom.net/tora/, all I get is a page with user comments and screen shots. Where do I go to download the product? Thx. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don 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: runInstaller - ruinInstaller? RUINstaller?
There have been times when I would have paid extra for (1) a character-mode installer and/or (2) a reliable and consistent way to create a listing of EXACTLY what was installed (e.g. the long-defunct "instver"). I think I've installed Oracle with just about every mechanism they've had since Oracle 5 came out - cpio from tape, custom platform-specific scripts, a few dozen floppy disks (Xenix & DOS), orainst /c, orainst /m, and runInstaller. The java-infested runInstaller is one of the worst pieces of junk that Oracle has ever forced upon the user community. I've made it a point to express this opinion to several rather senior people at Oracle. A few - from the technical ranks - have even agreed (off the record of course). For one thing, "making it easy to install Oracle" makes it far too easy for the clueless to install it poorly! Some of the comments like "Any machine that's need to run a production database should be strong enough to run Java ok" miss the point entirely. For one thing, not all Oracle installations are on production servers. More importantly, the vast majority of Oracle installs are NOT done at the system console. At my last two jobs, we used Exceed Hummingbird - which had quite a few problems with runInstaller. At my current job, we use Reflection-X. It seems a bit better - once you learn the quirks. (Hmmm... The first screen is chopped off at the bottom so the buttons are invisible... Hit return to go to next screen... Still invisible... Minimize... Click the minimized icon on taskbar to restore... OK The buttons at the bottom are visible now...). If you think that sounds like fun, try it over a dial-up connection. However, if you really want to experience ruinInstaller (pun intended) in all its glory, try a cluster install sometime. I spent at least a couple of man-weeks over the last five years fighting it, trying to diagnose problems, trying to get it to work correctly - and have NEVER seen it actually work. A typical cluster-based install with ruinInstaller usually goes something like this: loop until entirely sick of it 1) Perform cluster-based install, for which runInstaller reports successful completion. 2) Go to any node other than where ruinInstaller was run to find that a) not all the components were copied across b) only parts (or nothing) got relinked c) some components were installed, but cannot be recognized by local ruinInstaller (hence can never be patched or upgraded) d) all or some combination of the above and/or other major aggravations 3) Fumble around trying to find out why ( with little or no luck) 4) (optional) check Metalink - no help 5) (optional) Call support... a) "We've never heard of a problem... " b) Are you sure the server is plugged in? ..." c) "Can you rcp/rsh between nodes?" (YES!) d) "Are you sure?" (Well it did copy about half the required components over... and I can rcp and rsh between nodes as the oracle user - outside ruinstaller.) e) ad nausem - perhaps apply some iffy hack that doesn't end up solving the problem (e.g. "Try it again. When you reach the screen, open another shell session, convert the .mk file to pig latin, put three pennies in the Pepsi machine, go out to the parking lot, and perform a Hopi rain dance. Then select . It should work now.") 6) Wipe all nodes completely clean and start over end loop Then... (optional) Call somebody deep inside the mothership at Oracle and ask them about this nightmare - and find out that it actually is a known, but largely unadmitted, problem! Once someone on the OPS development team even supplied a convoluted deep-geek hack to make it (almost, 99.2%-ish) work. Finally... Give up on the cluster install and just install the software individually on each node. The problem here, on a complex install at least, is in trying to determine exactly what options were selected everywhere so that you actually have the same executables on every node. [Checking it with a file dump of the "Installed Software" isn't very helpful since it seems to generate the list in pseudo-random order as a hierarchical tree ("diff" doesn't work very well).] After the first dozen or so attempts (on several different platforms, with several different versions of Oracle8 & 8i), I simply decided that I wouldn't bother attempting another cluster install with ruinInstaller again. Don Granaman [OraSaurus and command line curmudgeon] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 09, 2002 3:47 PM What I wouldn't give for "./orainst /c" right now. Where is the productivity and ease of use of the #$%^#@ OUI when it takes hours and hours just to load up all the java crap! Piece of garbage is enough to make me want to go back to 7.3.4 -
Re: runInstaller
; > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > -- > > === > > 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). > -- > 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: Grabowy, Chris > 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: Yechiel Adar 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: Don Granaman 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: Copy
I know it existed in Oracle6 - and just checked my handy Oracle 6.0 SQL*Plus v3.0 Quick Reference (circa 1991) to be sure. The only v5 manual I could find easily is my Database Administrator's Guide for Version 5.1 (circa 1986) and it contained no information on the copy command, but I'm pretty sure it existed then also. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 07, 2002 5:13 PM at least... I can't remember now, but I think there was a version of copy at least as far back as version 5, when I started --- Joe Testa <[EMAIL PROTECTED]> wrote: > I think i rememebr using copy back in version 6. > > joe > > > Rachel Carmichael wrote: > > >copy has been around for a lng time > >from the 8.1.7 docs > > > >COPY {FROM database | TO database | FROM database TO database} > >{APPEND|CREATE|INSERT|REPLACE} destination_table > >[(column, column, column, ...)] USING query > > > >and the example > > > >SQL> COPY FROM SCOTT/TIGER@HQ - > > > > > >>CREATE SALESMEN (EMPNO,SALESMAN) - > >>USING SELECT EMPNO, ENAME FROM EMP - > >>WHERE JOB='SALESMAN' > >> > >> > > > >if you are copying within the same database you can leave out the > >from/to clause. If you are logged onto one of the two databases, you > >can leave out the from or to clause > > > > > >--- Yechiel Adar <[EMAIL PROTECTED]> wrote: > > > > > >>I checked the docs for 8.1.6 and 9.0.1. > >>I think that the copy command is new in 9i. > >>make sure that you are logged on to 9i sqlplus when you issue this > >>command. > >> > >>Yechiel Adar > >>Mehish > >> - Original Message - > >> From: Ramon E. Estevez > >> To: Multiple recipients of list ORACLE-L > >> Sent: Friday, July 05, 2002 10:08 PM > >> Subject: Copy > >> > >> > >> Hi list, > >> > >> I am trying to copy one table from a DB 9.0.1 on Linux RH to a DB > >>8.1.7 on NT using this statement > >> > >> COPY FROM RAMON@ORLNX TO RAMON@IBOR CREATE DATBAL_TMP USING > SELECT > >>* FROM DATOS_BALANCES; > >> > >> ERROR at line 1: > >> ORA-00900: invalid SQL statement > >> > >> Do I need a DBLINK, if yes, is it obligatory ? > >> > >> TIA, > >> > >> > >> Ramon E. Estevez > >> [EMAIL PROTECTED] > >> 809-565-3121 > >> > >> > >> > > > > > >__ > >Do You Yahoo!? > >Sign up for SBC Yahoo! Dial - First Month Free > >http://sbc.yahoo.com > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe 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). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.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: Don Granaman 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: Comparison between Oracle 8 and Oracle 9
Are their claims based on actual experience with 9i or are they simply regurgitating Oracle's marketing line? It may well be "better" in many respects, but beware of "consultants" who make recommendations based on what they may have read somewhere - especially if the source vendor press releases or the thinly disguised equivalents - "first looks"/"reviews" in many trade magazines. [For what it is worth - I'm just now beginning to seriously test some pending new systems on 9.2, but won't claim that it is actually "much faster" or "more reliable" until I have some first-hand empirical evidence.] Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 5:13 AM Hi everybody, Currently we are using Oracle 8.1.7 in our company and for a new datawarehouse project, a consultant company has suggested us to use Oracle 9. The have claimed that applications run much faster and it's more reliable etc... Of course I was not convinced. Could you please tell me, where I can get some documents about the comparison of these two databases? Thank you for your help. Regards M.Emre HANCIOGLU Masterfoods Services GmbH ISI Application Support Tel : +49 2162 500-576 Fax: +49 2162 41497 E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: exp73 dumpparam for unlimited extents?
Absolutely! I should have read more closely! Don Granaman [Orasaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, July 01, 2002 1:41 AM For the reported problem, (1) is the only option as (2) is not possible with 7.3.x database. - Kirti -Original Message- Sent: Sunday, June 30, 2002 9:28 PM To: Multiple recipients of list ORACLE-L With compress=N, you will get essentially the same mish-mash of extents you had previously - unless you are importing into a LMT. You have basically two options: 1) Pre-create the objects with a storage clause specifying the extent sizes you want - with initial and next the same size. Then import with ignore=Y. Of course, if you drop the users, you will have to recreate them before pre-creating the objects. This is the only option for dictionary-managed tablespaces to get uniform extents. (Hint: imp ... indexfile=somefilename.sql ..., edit somefilename.sql to (1) uncomment the create table statements and (2) modify storage clauses, then run somefilename.sql. If the export is large, you may wish to split this into two parts - one for the tables and one for the indexes and constraints. (It is a little more complicated than it might seem at first, but isn't too bad. One possible approach is to perform one export with rows=Y indexes=N constraints=N and another with rows=N indexes=Y constraints=Y. Details left as an exercise for the reader ;-) 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop and recreate them as such - prior to the import. In the vast majority of cases, (2) is preferred. Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 11:53 PM Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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: Don Granaman 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
Re: exp73 dumpparam for unlimited extents?
With compress=N, you will get essentially the same mish-mash of extents you had previously - unless you are importing into a LMT. You have basically two options: 1) Pre-create the objects with a storage clause specifying the extent sizes you want - with initial and next the same size. Then import with ignore=Y. Of course, if you drop the users, you will have to recreate them before pre-creating the objects. This is the only option for dictionary-managed tablespaces to get uniform extents. (Hint: imp ... indexfile=somefilename.sql ..., edit somefilename.sql to (1) uncomment the create table statements and (2) modify storage clauses, then run somefilename.sql. If the export is large, you may wish to split this into two parts - one for the tables and one for the indexes and constraints. (It is a little more complicated than it might seem at first, but isn't too bad. One possible approach is to perform one export with rows=Y indexes=N constraints=N and another with rows=N indexes=Y constraints=Y. Details left as an exercise for the reader ;-) 2) Convert the tablespace(s) to LMT(s) with uniform extents - or drop and recreate them as such - prior to the import. In the vast majority of cases, (2) is preferred. Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 11:53 PM Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical 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: Don Granaman 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 OPTIMAL setting
As far as I know, the jury is still out - I haven't had a chance yet to see if (a) the problems Dan found in 9.0.1.1 are fixed and (2) I like the way it works. Also, it does require 9i and I'm not yet ready to go there with everything. Even with 9i and system managed undo, rule #4 will still be in effect! Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 9:38 PM Don, 9i has system managed undo -- you don't think it works yet? Rachel --- Don Granaman <[EMAIL PROTECTED]> wrote: > I prefer to have OPTIMAL set and deal with "long running large > transactions" > another way - setting "OPTIMAL" on the developers! Granted, this > doesn't > work for 3rd party products, but I usually deal with in-house > applications. > Getting this to work requires: (1) having enough rollback segments, > (2) > large enough rollback segments that extends almost never occur, and > (3) NOT > having the "one giant rollback segment for large jobs", and, most > importantly, (4) all "batch-lookin' thingies" have to be reviewed by > the DBA > and optimized, by either the DBA or the developer - or both, until > they pass > muster. Using this, I rarely seen an ORA-01555 or a rollback shrink > (over > six months on the systems I'm working with now) - and when I do, I > know that > it (usually) means that somebody broke rule #(4). When that happens, > I > track it down and work with the developer to fix it. My experience > is that > the vast majority of developers are receptive - they actually like to > have > their code run without problems. > > Of course, this assumes that the "wasted" disk space for (1) and (2) > is not > a significant issue. It rarely is, but I work almost exclusively > with > (essentially) OLTP systems where space is typically less critical > than I/O > throughput capability and reliability. Usually, we have to add disks > for > performance rather than space. The database datafile drives are > typically > 36 GB (less often 18 GB) and are rarely "full", so a GB or two more > for > rollback tablespace is OK. If I had to operate under the space > constraints > that many seem to have, I might not set OPTIMAL either. > > I am looking forward to the day that this "no OPTIMAL" suggestion > fades into > the "myths and folklore" category. Either because of basic policy > changes > (e.g. the extents myth), a better Oracle algorithm (e.g. 10i system > managed > undo???), more intelligently designed batch processes in > applications, or > the trend towards ever-increasing drive size. > > Note: All this doesn't mean that I don't understand why so many use > the > "manual shrink" method. My philosophy differs in that not setting > OPTIMAL > should be a last resort, not a blanket policy. > > Don Granaman > [OraSaurus] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, June 27, 2002 10:13 AM > > > One of the constant comments regarding rollback segments is not to > set > optimal. I am wondering why this setting is often discouraged. I have > my own > ideas, but I want to gather more opinions and experiences. > > Daniel W. Fink > Sr. Oracle DBA > MICROMEDEX > 303.486.6456 > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Don Granaman > 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!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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: [
Re: Rollback OPTIMAL setting
I prefer to have OPTIMAL set and deal with "long running large transactions" another way - setting "OPTIMAL" on the developers! Granted, this doesn't work for 3rd party products, but I usually deal with in-house applications. Getting this to work requires: (1) having enough rollback segments, (2) large enough rollback segments that extends almost never occur, and (3) NOT having the "one giant rollback segment for large jobs", and, most importantly, (4) all "batch-lookin' thingies" have to be reviewed by the DBA and optimized, by either the DBA or the developer - or both, until they pass muster. Using this, I rarely seen an ORA-01555 or a rollback shrink (over six months on the systems I'm working with now) - and when I do, I know that it (usually) means that somebody broke rule #(4). When that happens, I track it down and work with the developer to fix it. My experience is that the vast majority of developers are receptive - they actually like to have their code run without problems. Of course, this assumes that the "wasted" disk space for (1) and (2) is not a significant issue. It rarely is, but I work almost exclusively with (essentially) OLTP systems where space is typically less critical than I/O throughput capability and reliability. Usually, we have to add disks for performance rather than space. The database datafile drives are typically 36 GB (less often 18 GB) and are rarely "full", so a GB or two more for rollback tablespace is OK. If I had to operate under the space constraints that many seem to have, I might not set OPTIMAL either. I am looking forward to the day that this "no OPTIMAL" suggestion fades into the "myths and folklore" category. Either because of basic policy changes (e.g. the extents myth), a better Oracle algorithm (e.g. 10i system managed undo???), more intelligently designed batch processes in applications, or the trend towards ever-increasing drive size. Note: All this doesn't mean that I don't understand why so many use the "manual shrink" method. My philosophy differs in that not setting OPTIMAL should be a last resort, not a blanket policy. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 10:13 AM One of the constant comments regarding rollback segments is not to set optimal. I am wondering why this setting is often discouraged. I have my own ideas, but I want to gather more opinions and experiences. Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: the ora certified masters cert - finally bloody sick
*** I swear this will be my last post on the issue. If I've offended anyone, they have my most sincere appology. However, I think you have interpreted this wrong. I have never said or implied, nor do I remember seeing anyone else say, that anyone with an OCP is trying to cover up for some deficiency. In the post that you replied to, I said "a few... that waved their OCP around like it was a Nobel prize". These (two) people were - quite obviously. The vast majority of OCPs I've known, including many on this list, are not like that at all. Many got it because it is now a market necessity. Some got it to get an entry-level DBA position. A few that I know got it just to see if they could pass all the exams without any preparation. My problem is not with people who have it, it is with the marketing and hype that has made it mandatory - regardless of level of exerience or anything else. And also with Oracle's most recent greedy exploitation of the situation they created. Will I get it? Probably. (I don't want to be the only one left without it and it looks like Kirti's gonna go for it now. ;-) I've been lucky that my last two jobs I got because someone I had worked with previously called me (a VP and a CTO). However, when and if I have to go looking again, I'll likely need it just to clear the HR checklist hurdle and land an interview. (Unless I get lucky again). Lets see... What do I need to do in the next few months... Finish building and testing a Linux 9i RAC system, set up new software for the MML on every server and migrate all the backups it and a new tape library, diagnose and redesign | tune significant parts of a custom in-house application, move two other internal Oracle systems to bigger servers, spend a couple of weeks reviewing and hardening a client's nine exclusive Oracle8i systems in Chicago and one 8i OPS system in Texas (all but one using literally every option Oracle offers in 8i, including iFS - which I haven't yet had time/motivation to learn), do a security and architectural assessment of a prototype 8i system that another client wants to install in *thousands* of retail locations around the world, do the standard "only DBA in a shop full of developers" development support and production thing, work with the CTO and VP on developing a disaster recovery plan, *perhaps* write a white paper (or two) and a presentation (or two) for OOW 2002, and, oh yeah, ... study for and take about six essentially entry-level DBA exams before Oracle ups the ante again. Sorry, but if I had a choice, I'd rather sleep occassionally instead. I don't really need any more flaming hoops to jump through. I imagine there are a lot of people like me out there who feel the same way. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 4:33 AM I've been pretty quiet while you all said that the OCP program was pretty worthless because I can see your point. I don't believe that it proves that the holder is technically better than someone has isn't certified. From my point of view, though, I'm convinced that in a tight market it's helped to get me into interviews and that justifies the cost to me. Now, however, you're straying towards calling OCP DBAs liars and cheats and implying that we're dangerous to have on site and I'm sorry but I'm not going to have that. What merit is there in saying "doctors have malpractice insurance and OCP ... should have one too.". Where's the evidence for that kind of witless comment? I originally took my OCP after amassing 10 years of DBA experience. I don't want to get into a pissing contest over this but it grates on me to have it constantly implied that OCP is just there to make up for lack of ability. I'm aware that many of you (Don for instance) have qualified their statements by saying that applies to "a few" or "some" but the implication is still that the majority of OCPs are trying to make up for some sort of technical deficiency. If you don't want to spend the money or the time then that's fine by me. I certainly won't it necessary to criticise you for it. Regards, Mike Hately No, really; I usually have a sense of humour. -Original Message- Sent: 27 June 2002 08:13 To: Multiple recipients of list ORACLE-L >From my experience with a few DBAs that waved their OCP around like it was a Nobel prize, some probably should have malpractice insurance. Lots of it. Don Granaman [Certifiable OraSaurus - NOCP] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 1:08 AM But doctors have malpractice insurance and OCP does not or do/should OCP have one too. -- Please see the off
Re: the ora certified masters cert, yet again
I absolutely am NOT saying that anyone with an OCP is incompetant, a bad person, or any other such thing. Some of the best DBAs I've known were OCP. Some weren't. Some of the very worst DBAs I've known were OCP. Some weren't. I simply think that its main value (other than the totally artifical value of being a common checklist item for hiring authorities now) is to get people to study, learn, and try things out. However, those things don't really require a certificate, ILT classes, or checks made out to Oracle. I agree that this thread is worn out. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 10:48 AM Good morning Don, I know that you are not suggesting that those with the OCP are bad persons. Listers, I suggest that we drop this topic now, since it might start to offend if it goes further. We all have much more in common that we have that divides us, and this topic is a downright silly thing to risk hurting each other over. It is worth far less than the harmony of this community. Jack OCPx4 --- Don Granaman <[EMAIL PROTECTED]> wrote: > From my experience with a few DBAs that waved their > OCP around like it was a > Nobel prize, some probably should have malpractice > insurance. Lots of it. > > Don Granaman > [Certifiable OraSaurus - NOCP] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Thursday, June 27, 2002 1:08 AM > > > But doctors have malpractice insurance and OCP does > not or do/should OCP > have > one too. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Don Granaman > 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!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey 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: Don Granaman 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: BOB
I thought is was BOB -("Big Orange Button"). As in "systems administration by BOB". Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 3:54 PM the "little red button" is my favorite -Original Message- Sent: Wednesday, June 26, 2002 4:24 PM To: Multiple recipients of list ORACLE-L try: Ctl-Alt-Del. Works wonders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: the ora certified masters cert, yet again
"What do you hate/find-frustrating about Oracle?" (Let me count the ways... ) That could easily be the most revealing interview question ever conceived! I love it!!! I'm amazed at the number of times someone that is supposedly qualified can't answer a very simple, but unexpected, practical question. I used to always start out with a few "indicator" questions to determine strengths, weaknesses and which way to go. One such was "If you find a file named 'afiedt.buf', how was it probably created?" That particular question caught two very "confident" applicants without the foggiest clue a few years ago. One was the "Oracle Wizard" at his current company. (Seriously. It was the official job title on his business card! ... even though he had been out of college less than a year.) The other was an extremely smug 7 & 8 OCP DBBS who claimed many years of experience and opened our conversation, immediately after the handshake and introductions, with "I'm one of the best Oracle DBAs around - if not THE best.". When I asked this question after a few minutes of pleasant generalities, his smirk disappeared, his jaw dropped and he just sat there staring at me with the best "deer in the headlights" look I've ever seen. [It must not have been in the Self Test Software Practice Exams or the Exam Cram books.] BTW: Grant: Can I buy that .sig from you? Don Granaman [OraSaurus & NOCP] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 1:23 AM Rachel Carmichael[SMTP:[EMAIL PROTECTED]] wrote: > >this goes back to a thread from maybe a year ago... what sort of > >questions do you ask on interviews. > > > >I may ask other questions based on what we are specifically looking for > >or building off something the interviewee says but I always include the > >following questions: > > > >1) what was your worst nightmare as a DBA and how did you resolve it > >2) what are you most proud of doing > >3) how do you learn new things about Oracle > > > >gee, not ONE multiple choice question among them! > [stops lurking for a change] I always throw in "What do you like most about Oracle?" and "What do you hate/find-frustrating about Oracle?". Most can answer the first, but you can often get a good idea of what people have (or haven't!) experienced with their answer to the second. Ciao Fuzzy :-) [goes back to lurking] -- "Woo Hoo!" - H. Simpson ------ The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: the ora certified masters cert, yet again
>From my experience with a few DBAs that waved their OCP around like it was a Nobel prize, some probably should have malpractice insurance. Lots of it. Don Granaman [Certifiable OraSaurus - NOCP] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 1:08 AM But doctors have malpractice insurance and OCP does not or do/should OCP have one too. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: the ora certified masters cert, yet again
The Chauncey certification exam (singular) was a failure because: 1) It didn't parrot/require enough Oracle ILT material 2) Oracle Corp didn't get a big enough cut 3) It was more scenario-based - requiring more understanding and less "knowledge" OCP is more like a "learner's permit". The Chauncey certification was more like a chauffeur's license. Don Granaman [OraSaurus - Just say NO(CP)] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 9:33 AM Well that explains a lot. In a separate post Rachel also said Oracle denigrated the prior Chauncey/IOUG tests so it's obvious that Oracle is just using testing and certification as another source of revenue. Professional Development of the DBA community is just marketing hype. All the more reason to avoid the 9i tests. -Original Message- Sent: Tuesday, June 25, 2002 7:08 PM To: Multiple recipients of list ORACLE-L Importance: High The original certification program was developed by IOUG when Mike Corey was president of the group. I cannot remember if the program ever certified anyone other than those who built it. Once Oracle had its own certification program the IOUG one withered. The relationship between ORACLE and its user groups have not always been friendly. The OAUG's complaints have made the national press. If my memory serves, and its already been shown to be faulty, the first OOW-Americas was scheduled to be at the same time as the IOUG-A. Corey indicated he was going to see Ellison and explain to him that he couldn't do such a thing, that OOW-Americas would have to be rescheduled. Ellison was not moved, neither was the OOW-Americas conference; the IOUG-A get together was :) To its credit IOUG-A live is seen as a more credible than the marketing show known as OOW. However I doubt the conference would maintain its value if Oracle sent no one. If the IOUG had a competing certification program, Oracle would do its best to snuff it out. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Don Granaman 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: the ora certified masters cert, yet again
It takes a lot of time and effort (and money if you pay for lessons) to run around the parking lot flapping your arms trying to learn to fly also... And I'm SURE that SOMEBODY would sell you a license - for the right price. So it must be worthwhile ;-) I would certainly hope that Doctors aren't educated and tested like OCP candidates! Hmmm... [62% is a passing score.] 3) Severe arterial bleeding should be a) encouraged b) covered by the HMO c) stopped d) converted to vascular e) ignored 2) What type(s) of leech should be applied for an acute myocardial infarction? (Choose all that apply) a) Erpobdella punctata b) Macrobdella decora c) Pharyngobdellida d) Rhyncobdellida e) Gnatbobdellida 3) The third selection from the top on the "Configuration" menu of the RunAmok Technologies Defibrillator for Dummies (TM) is: a) voltage b) amperage c) frequency d) duration e) billing rate [...] Don Granaman [certifiable OraSaurus - nOCP] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 6:25 PM Work experience is better than certification but ... Getting certified is hard work. Takes a lot of time and effort (not to mention money). So it must be worth something. If only for a little bit. It is definitely not worthless. Work experience plus certification is the best combination. Certification is no different from being a doctor. You need to pass exams to be a doctor too (you need internship to go as well, of course). As for naming famous Oracle authors, I don't think this is a valid gauge of your capacity as a DBA. I know some people well versed in Computer Engineering concepts (from 'great' authors) but can't code. They sound like experts but can't deliver sh_t. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: conferences - IOUG vs OOW
Ditto. There are some great technical sessions at OOW, but the percentage is dramatically lower. Oracle chooses the vast majority of the presentations at OOW and their motivation is quite different from that of IOUG. It seems that every morning at OOW is largely consumed with keynote (e.g. "pump me up" marketing) sessions. One per conference is about all I can take - sometimes even that is too much ;-) In a way its OK though - you can usually just sleep in! [Actually, they seem to have caught on to this (at both conferences!) and now scatter them throughout the day more]. A huge plus is that the crowd at IOUG-A Live! (nee IOUW) is *MUCH* smaller. The possibility of becoming roadkill, as in the inter-session stampede at the Moscone center, doesn't exist at IOUW. There are more/better chances of running into and hanging with your homies from the list. At the IOUG conference (especially), some of the best technical "sessions" are/were on the sun deck, in Starbucks, etc. The roundtables at IOUW are a real plus also. One advantage that OOW does have though is that Oracle usually lets some of their best deep-geeks escape from the bowels of the mothership to go to the conference. I always seem to get chances to drag them off for a little one-on-one time or at least some ad hoc small group discussion. (Its nice to have friends in low places!) Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 4:39 PM my preference when I have to choose is IOUG over OOW OOW tends to have a lot more marketing/Oracle employee (so it feels like marketing) presentations --- "Magaliff, Bill" <[EMAIL PROTECTED]> wrote: > Having never been to either and wanting to plan for one, am I to > infer from > some of this discussion that for real content (as opposed to > marketing > fluff), THE conference to attend would be IOUGLive, as opposed to > Oracle > Open World? > > -bill > -- > 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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: Don Granaman 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: Difference Between DBMS/RDBMS
Overlays in Turbo Pascal One of the more challenging aspects of writing Pro*C user exit code for Forms 2.3 on a DOS client running against an Oracle 5 database was trying to link 1,000 or so C functions (at one function per file for modularity) to create a large iapx (?correct name for version?) executable within a segmented 16-bit architecture. [These young whipper-snappers today have it SO easy!] Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 6:20 AM As I recall, the Dec product was called Rdb, and generally regarded as quite good. It was subsequently bought by Oracle. The old hierarchical and network systems did not require foreign keys, because all records were explicitly linked via hard-coded pointers. So you HAD to get your design right before building the data model, otherwise retrieval would be a nightmare. Because relational systems allow joins at query time, a major slackness has crept into database model design. Like not always protecting the integrity of PKs... Talking of working on small memory machines - here is a test for your age in the industry - all those who can remember writing overlays stand up! I suspect the current crop of PC software engineers have never encountered overlay programing. peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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 Performance Tuning steps
Two words: "wait events" I'll forward, in private mail, a posting I made here on April 21, 2002 with some pointers to sites... (The subject line was "Re: ioug-a question") Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 5:18 AM > > Hi guys , > > Need some help. Actually we are looking here at a Oracle 8.1.7 db on HP-UNIX. The application was running fine uptil yesterday. Suddenly a part of the appln is running extremely slow. I can not figure what might be the problem. Wanted to track this down asap. > > Here is some information about the db. > > Database size - 20GB > > Optimizer - CHOOSE > > Disk Structure - RAID 1+0 > > No. of processors - 4 > > Block Size - 8K > > Archivelog mode : ARCHIVELOG > > Please tell me what should be the ideal way I should try to trace the problem. I thought of running UTLBSTAT/UTLESTAT or STATSPACK and asked the user to run that part of the appln. Has anybody worked with STATSPACK before ? > > Can anybody tell me what should accurate and fastest way to hunt down the problem ? I think its something to do with indexes or changes in the queries. > > Also can someone tell me the ideal backup strategy for this database considering the fact that it's a 24x7 system. > > Thanks in advance . > > Chetan Chindarkar > > > > - > Do You Yahoo!? > Sign-up for Video Highlights of 2002 FIFA World Cup -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Management Reports
This type of request is entirely too common. The problem is that measuring the "performance" of an Oracle system isn't like measuring the performance of a car in the Indy 500 by timing laps, but that is typically the perception of those asking. At my last employer, we developed application-specific performance monitors - how many orders pending at each stage of the process (approval, submitted, filled, etc.), average processing time (overall and per phase), etc. It was much more useful for identifying problems. Of course this added non-trivial load to the system. The best such "single measure" chart I've ever seen was part of the Precise (nee Savant) Diagnostic Center. It was the response time of the periodic poll to gather information. Other products may have something similar. What are you trying to measure? If it is generic response time, that approach might work. If you don't have anything already, you could write something that pulls some statistics periodically (not too often) and time it on each run, graphing how long it takes. Beware of the Heisenberg uncertainty principle though. The act of detection will likely influence the results. Performance problem may appear and disappear between polls - not showing up. Increasing the frequency of the poll will further denigrate the overall performance. This is a Pandora's box of potential issues. Also beware that an application-independent generic "performance graph" will not always reflect what the users see (e.g. due to application-specific issues - locking, etc.). Generic response time may not be what they want - and probably isn't. One problem with this approach is that often the generic response time is best when the application performance is at its worst! Why? Something else in the stack goes into a catatonic state so that the instance/database is freed up to service the response time query faster. I've seen it happen many times. [Actually, this can be a plus. Scenario: Them: "Quick! Check the database! It seems slow!" Me: "No, its actually running much faster than normal. It seems that the app isn't submitting any/much work."] Another possible alternative is the "Etch-a-Sketch" approach. Give them whatever kind of nonsense appeases them to get them off your back so you can do useful work ;-) Of course, there are potential "issues" with this as well! Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 10:33 AM > Good Morning Everyone! > > My management wants a chart that shows the performance of the > database. If this was your boss, what would you show them? > > Thanks, > Mike > > P.S. This is a repeat e-mail. I never saw my other one hit the > list. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Difference Between DBMS/RDBMS
I missed this part in my previous response... Does anyone remember why there never was a 9.1? We seem to have gone directly from 9.0.x to 9.2.0! [Did I miss somethng while taking a nap sometime recently?] Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 11:18 AM > A - but is a system truely "Relational" if they don't support foreign > keys? > That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 > - I forget). > > Anybody remember why there was never a release 6.1 - we went from 6.0 > directly to 6.2??? > > Correct answer gets a virtual beer. > > Tom Mercadante > Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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:RE: Difference Between DBMS/RDBMS
I think that 6.0.x was all there ever was on most platforms. I worked with Oracle on a smorgasboard of Unix-like platforms (AIX, Sun, Xenix, SCO, Unisys s5r4, etc.) all the way through Oracle6 and don't remember ever seeing anything beyond 6.0.36. That could be because either (1) we skipped later 6.x in favor of Oracle7.0.x or (2) what was in memory was swapped to disk and never needed again. ;-) I didn't work with VMS after Oracle 4 (!), but there was at least a 6.2 release on VMS - exclusively I think. [If I remember correctly (unlikely), the VMS release 6.x (x=2?) for the VAX cluster was the granddaddy of OPS]. I don't know about 6.1, but if there ever was such a critter, I suspect that it was VMS-only also. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 12:08 PM > There was a 6.1 and/or 6.2? I went from 6.0.36 straight to 7.2. > > Dick Goulet > > Reply Separator > Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]> > Date: 6/25/2002 8:18 AM > > A - but is a system truely "Relational" if they don't support foreign > keys? > That did not happen within Oracle-Land until release 7 (maybe it was in 6.2 > - I forget). > > Anybody remember why there was never a release 6.1 - we went from 6.0 > directly to 6.2??? > > Correct answer gets a virtual beer. > > Tom Mercadante > Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: the ora certified masters cert, yet again
Hmmm... Within the last two days I saw a news blurb that said there are now 113,000 OCPs - up from ~60,000 two (?) years ago. I imagine the a non-trivial number of these went through the entire ILT schedule to get there. I'm not sure exactly what this new OCP ILT requirement is, but I'd venture a guess that it isn't some new course developed entirely from scratch. Look at what the OCM requires in the way of ILT - two additional existing courses (and they aren't very picky about which). So, it sounds like ~26,000 new OCPs per year. True, this isn't likely to cause their stock price to double, but I do think it is much more about revenue rather providing useful certification. How else could requiring a $2,000 ILT class be justified? (My understanding is that it is a class, not a practicum exam). Also, this is just the beginning. I'd bet that future certifications will up the ante on this Oracle ILT requirement. Perhaps by 10i (11i?), the OCP will become more like the Oracle Masters deal - more required ILT courses and simpler exams with heavier emphasis on the GUI tools and whatever esoteric features Oracle is pushing at the time. Think of it this way: Possible Oracle10i OCP requirements: 1) Four weeks of Oracle ILT @ ~$2000 / week for a new OCP 2) Two weeks of Oracle ILT for an upgrade 3) Some exams that are easily passed by regurgitating the ILT - flaws and all Assume 100,000 people want a 10i OCP. Assume that 30% are new and 70% are upgrades. (Wild guesses all.) 100,000 * [(0.30 * 4 * $2000) + (0.70 * 2 * $2000)] = $520,000,000 That doesn't include OCM or OCW (Oracle Certified Wizard) which add to the ILT requirements - and revenue. I can't imagine Oracle promoting anything so heavily if they only break even. (Does anyone else remember the Oracle Developer Programme? Evidently, it didn't turn out to be the cash cow it was expected to be, so it quietly disappeared. Don't know about anyone else, but I didn't get a refund.) Don Granaman [Curmudgeon OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 10:28 AM > Putting on my cost accounting hat I'd like to say this. At $2,000 a pop and > probably with a small group of people attending these classes, Oracle would > be lucky to break even. The costs of developing, hardware and staff to > proctor these exams are very high. A lot of people would have to take this > test for Oracle to break even. A thousand test takers in a year would only > generate $2,000,000 in sales which wouldn't even show up on their financial > statements. > > My $0.02 as a former cost accountant, > > Ken Janusz, CPIM > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, June 25, 2002 2:08 AM > > > > They aren't - unless it exceeds a non-trivial percentage (6%? 7%? more? I > > can't remember now...) of their income and is "required" (?). > > > > This new requirement for OCP is just another in a long line of > > propaganda/baloney from Oracle in its never-ending attempts to suck up > every > > buck it possibly can. [Oracle likes $. HR likes mindless checklist > > items. It is a match made in heaven.] I thought that the "need > practically > > any two ILT classes, no matter how irrelevant" 9i OCM was going to be the > > limit of extending the the greedy grab for OCP bucks - for 9i at least. > > This isn't about certification anymore (as if it ever was), its about > > revenue. > > > > Since this "new requirement" (for the moment at least) doesn't apply to > > upgrade from an 8i certification, does anyone know if there is (or soon > will > > be) a new constraint/surprise/ambush limiting that to 8i OCP obtained > prior > > to, oh say, June 15, 2002? September 2002? > > > > Don Granaman > > [OraSaurus - with more disdain than ever for the evil vampire Larry's OCP > > DBA tax] > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Friday, June 21, 2002 12:23 AM > > > > > > > I thought employees were not allowed to write things off as business > > > expenses... > > > > > > Confusedly yours, > > > Patrice Boivin > > > Systems Analyst (Oracle Certified DBA) > > > > > > -Original Message- > > > Sent: Thursday, June 20, 2002 10:13 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: the ora certified masters cert, yet again > > > > > > Are you
Re: Online vs offline backups
Many of us haven't had the luxury of downtime for cold backups for production systems in many years. Hot backups are quite sufficient. However, whenever I do a cold backup of a dev or test database (and when I could do cold backups in production) I *always* back(ed)up the redo log groups and the control file. Why? 1) You don't HAVE to restore the redo logs - and definitely shouldn't if you have surviving current redo logs and want to recover as much as possible. 2) Its a "no-brainer" to restore and recover a test system to a known state with a cold backup of datafiles, redo log groups, and a control file. Just slap them down, copy redo members & control if necessary, and startup. Very handy for repeating variations of tests from the same consistent known state. Don Granaman [OraSaurus - Oracle 6 backup habits die hard!] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 12:38 AM > Hi, guys, > We have discussed this topic many times on this list. Actually a good DBA > should design a good backup and restore strategy instead of "online or > offline" according to business situation. > > From my opinion, both "online" and "offline" are necessary, for example, I > do monthly offline line cold backup and daily online hot backup on my > production db. The only thing you need to know is that if you do offline > backup, you should backup every thing, include online redo logs, otherwise, > you may lost some data; if you do online hot backup, the online redo logs > are useless when you do restore. > > Cheers! > > Shine Sha > Snr. Oracle DBA > iGINE Pte. Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: the ora certified masters cert, yet again
They aren't - unless it exceeds a non-trivial percentage (6%? 7%? more? I can't remember now...) of their income and is "required" (?). This new requirement for OCP is just another in a long line of propaganda/baloney from Oracle in its never-ending attempts to suck up every buck it possibly can. [Oracle likes $. HR likes mindless checklist items. It is a match made in heaven.] I thought that the "need practically any two ILT classes, no matter how irrelevant" 9i OCM was going to be the limit of extending the the greedy grab for OCP bucks - for 9i at least. This isn't about certification anymore (as if it ever was), its about revenue. Since this "new requirement" (for the moment at least) doesn't apply to upgrade from an 8i certification, does anyone know if there is (or soon will be) a new constraint/surprise/ambush limiting that to 8i OCP obtained prior to, oh say, June 15, 2002? September 2002? Don Granaman [OraSaurus - with more disdain than ever for the evil vampire Larry's OCP DBA tax] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 12:23 AM > I thought employees were not allowed to write things off as business > expenses... > > Confusedly yours, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > -Original Message- > Sent: Thursday, June 20, 2002 10:13 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: the ora certified masters cert, yet again > > Are you trying to promote it? > > -Original Message- > Sent: Thursday, June 20, 2002 6:50 PM > To: Multiple recipients of list ORACLE-L > > > I am seriously considering pursuing one, since it can > be sold to hiring managers as a sign of professional > competence. > > Look at it from a cost/benefit ratio standpoint. Will > someone with this cerifification make $2000 more over > her professional life than she would without? > > So it takes a round trip ticket and three days of > vacation. Get the company to pay for it or write it > off as a business expense. > > Good investment, easy money, instant credibility to > many hiring managers. > > jack silvey > > > > > > > On 19 Jun 2002 at 4:38, Ron Rogers wrote: > > > > Date sent: Wed, 19 Jun 2002 04:38:18 -0800 > > To: Multiple recipients of list > > ORACLE-L <[EMAIL PROTECTED]> > > > > > It seems that our list has made mention in this > > report from > > > Searchdatabase.com. And Oracle is trying to > > justify the $2000 expence. > > > If I read this correct the $2000 is for 9i OCP. > > > === > > > LEAD STORY > > > > > > ORACLE FUELS CERTIFICATION CONTROVERSY | > > SearchDatabase > > > Oracle has a new requirement for its potential > > certified > > > professionals, and the price tag is about $2,000. > > Many DBAs aren't > > > happy about the new policy but Oracle says the > > class makes their > > > certification more valuable than ever. Read the > > details of the new > > > mandate, and what DBAs and industry experts have > > to say about it. > > > > > > For the full details, click: > > > > > > http://www.searchdatabase.com/originalContent/0,289142,sid13_gci833782,00.ht > ml > > > > ... > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Eric D. Pierce > > 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!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack Silvey > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet a
Re: Oracle DB2 DBA Needed in Nebraska (near Colorado border)
This has been open for a while - I first saw a posting for this opening in January or so. It is Cabela's. From what I hear, it is an outstanding place to work. Sidney is a long ways from anything though. As for "2 hours from Denver" ..., well -- MapQuest says "168.51 miles" with 3 hours, 20 minutes estimated driving time. I don't think you can normally average 85 MPH for the entire trip with the the likes of CO-113, US-138, *Chestnut St*, and I-25 into Denver! If I were interested and qualified (DB2 experience? No.), I would go direct at http://www.cabelas.com/ - bottom left side, under "About Us" -> Careers -> DB2/Oracle DBA ... or: http://www.cabelas.com/cabelas/en/templates/community/aboutus/career-details .jhtml?contentId=MIS_DB2_Oracle_DBA&hierarchyId=10708 Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 3:13 PM Company in Sidney, Nebraska has an Oracle /DB2 DBA position opening on its IT staff. Sidney is a small town, 2 hours from Denver.. 30 mins from Sterling, CO so it's very close to the CO/NE border. The area has a very, very low cost of living, so renting or buying a house is tremendously low compared to most other areas of the country. An excellent Relocation Package is offered. Description: The selected candidate will perform typical DBA tasks to ensure reliable and scheduled availability of multiple development and production databases. This position will be responsible for monitoring and tuning databases for optimum performance, working with application developers during all phases of the application development life cycle, designing and implementing physical database design, influencing all aspects of application architecture and design, and assisting in troubleshooting application problems. PLEASE Do Not send your resume for this position UNLESS you have the qualifications for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. No H-1B candidates please. Requirements: -4+ years of Oracle database administration experience on HP, SUN, or NT platforms (version 8.x or higher) -Solid DB2 database administration experience on AS400, HP, SUN, or NT platforms. -4+ years of experience writing and tuning complex SQL. -Experience in logical and physical relational database design and data modeling -Good communication skills, ability to work well with others and multi-task. -U.S. citizens or permanent residency The base salary range depends on experience...range is up to 85K..and possible bonus. They also offer a comprehensive benefits package, including generous product discounts, profit sharing, 401K savings plan, and Health and Dental coverage. For immediate consideration, please send your resume as a Word attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/Sidney/Oracle/DB2/KW ph: 1-800 -549-8502 All Submissions are handled 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 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Cache vs. Oracle
Cache = Mumps++ (Yes, it used to be called "Mumps". Is that an omen? ;-) I worked almost four years in a shop where one of the two most critical systems ran on Cache, but I didn't have anything to do with it. The other 40+ production databases were Oracle - those were mine. My only opinion of Cache is that even their "technical" people are completely full of BS. Once, we had two of them on site for a week on a consulting engagement (tuning). During that time, I heard them telling people how Cache was so much better than Oracle because, among other things, "With Oracle, design and code have nothing to do with performance. Only database tuning by the DBA makes any difference. With Cache, the developer has full control over performance. You don't even need a DBA." Of course, this database was a continual performance nightmare - primarily because the developers "had full control"... and no DBA (they administered it themselves - as per vendor propaganda). Whether Cache is actually capable of decent performance is still a mystery. There were also some other significant issues, but I don't have the details. Be sure that it will actually do what you need before seriously considering it. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 04, 2002 1:09 PM > Cache? What is cache? > > -Original Message- > Sent: Tuesday, June 04, 2002 1:44 PM > To: Multiple recipients of list ORACLE-L > > > > > > > > Okay, I admit it I am somewhat of an Oracle bigot. Does anyone have > objective comparisons between Cache vs. Oracle or any opinions on subject? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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).
Who should I buy Oracle software from?
I have a client that is purchasing additional Oracle db product. The company that the client has worked with for several years turns out to be a "not authorized" reseller. This is the first that I have heard of "not authorized" Oracle software resellers. Are there any reasons why one would purchase from an "authorized" vs a "not authorized" reseller? Thx - Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don 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: Rename Column in 9iR2
To steal a quote from Matt Adam's white board (sorry Matt!): "You gotta stop thinking logically, and start thinking Oracley" - Jim Droppa Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, May 22, 2002 2:00 PM Rachel, I agree with your statement but since you used the word "logically" , I questioned the workings of Oracle and why or how they do things. [...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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).