RE: hw info on Tru64 system

[Stephen Lee]

psrinfo -v

vmstat -P


-Original Message-
How do I find hardware info on Tru64 machine?

Available RAM, number of CPUs...?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 Training

[Stephen Lee]

Yet another choice:

www.thinkspark.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Trolling for ideas

[Stephen Lee]

cursor_sharing = force

can cause it.  Bug.

 -Original Message-
 night, and sometimes receives an ORA-03113 end-of-file on 
 communication
 channel. Not consistently, just sporadically, and at varying 
 amounts of
 time. I have been unable to find anything in the server logs. 
 We have traced
 the program and the error occurs during different SQL 
 statements. Followed
 most of the tips I've located on solving ORA-03113 errors. I 
 am coming to
 the conclusion that maybe the only solution will be to 
 upgrade Oracle and
 hope that solves the problem. Unfortunately we can only 
 upgrade to Oracle
 8.1.7.4. Does anyone have any other ideas? Thanks.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Help with a truncate command in a procedure

[Stephen Lee]

Look up info on using execute immediate
This will let you put non-DML-type statements in a PL/SQL block.

-Original Message-

I am not a coder but I received this from one of our developers.  I can't
find anything about this anywhere.  Can someone tell me how to make the
truncate work?
Thanks! 
R.Smith 
In a DB procedure, I wanted to include the following SQL: 
BEGIN 
 TRUNCATE TABLE LOT837_GLOBAL_TBL_KMG; 
END; 
Error messages: 
PLS-00103: Encountered the symbol TABLE when expecting one of the
following: 
  := . ( @ % ; 
The symbol := was inserted before TABLE to continue. 
(It does not like it, if you take out TABLE, either.) 
So, I had to settle for the following SQL: 
BEGIN 
 DELETE LOT837_GLOBAL_TBL_KMG; 
END; 
Do you know why I can not use the TRUNCATE command? 
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Determine how many used and free blocks in an extent.

[Stephen Lee]

Do you mean something like this:

select max(bytes) from dba_free_space where tablespace_name = 'NAME';

 -Original Message-
 I would like to determine the maximum # of contiguous
 free blocks within an extent
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Windows 2000 Cluster on oracle

[Stephen Lee]

 -Original Message-
 
 As much as I hate defending Windoze, Win2k is in fact rather stable,
 at least Win2k server is.  I have one system on Win2k that I reboot,
 oh, every 6 months or so.
 
 Death to NT though.
 

The biggest problem that I have seen is (to me anyway) not one of stability
(I'll leave that to the bare-metal boys to argue about) but that it is not
really multi-user.  I think it only supports two users.

1. You're an administrator and can do anything you want.
2. You're not an administrator and can't do squat.

The idea of an application owner, somewhere in between -- someone who needs
to stop and start the app; install patches and upgrades to the app; but only
have access to his/her stuff and nobody else's stuff -- doesn't seem to be
well supported.  So the person who has a web app on the same box as your
database has complete access (or can take it) to any of your stuff.

Then there is the issue of all the missing Unix scripting utilities ...
which I suppose you can install ... if you are *THE* administrator and not
just *AN* administrator ... because we sure don't want *AN* administrator
pissing off *THE* administrator ... which the Oracle DBA in a company of any
size probably is not.  And you have to listen to *THE* administrators
constantly whine about the Oracle DBA being *AN* administrator, and
accidentally revoking the DBA's admin privileges from time to time.

Then there is the issue of doing all your admin stuff on a 28K dial-up line
after hours; NOT where you want to use a GUI!  But *THE* administrators have
only made provision for their easy dial-up access; and screw anyone who
might only be *AN* administrator.

 Windows is cheaper than SUN. Linux is cheaper than Windows.

Try comparing prices for a large Dell Xeon box versus a Sun V880 box.  The
bigger you get, the more competitive the mainline Unix boys get.

-
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT: unix script quetion: to replace $ with \$

[Stephen Lee]

Nope.  I will work.  Try it.

 -Original Message-
 
 The problem is that if LINE contains $ (dollar sign), as 
 some InterMedia
 table names do, the piped command will fail.
 
 Guang
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
  Stephen Lee
  Sent: Monday, February 03, 2003 3:54 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: OT: unix script quetion: to replace $ with \$
 
 
 
  Would something like this be adaptable to your stuff?
 
  #!/usr/bin/ksh
 
  {
  sqlplus -s -XXX
  joe/blow@SID
  set this and that off
  set the other thing and trimspool on
  set whatever else
  select table_name from dba_tables where owner = 'BUBBA';
  } | while read LINE; do
  echo exec analyze_that_puppy BUBBA.$LINE real good; | sed
  's/\$/\\\$/g'
  done
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Stephen Lee
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web 
 hosting services
  
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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: gmei
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: awk and ksh question - solved

[Stephen Lee]

-Original Message-
awk and ksh are both interpreting $1. 
-

Not possible.  One or the other will see $1, but not both.  That's the
problem with using quotes instead of assigning things to awk variables -- It
makes reading the stuff confusing.

FWIW, here is what I do:

   ## See if there is anything to send
   COUNT=`awk '/^$/ {next}; END {print NR}' $PAGE_FILE`
   ## If so send it
   if [ $COUNT -gt 0 ]; then
  PAGER_PERSON=''
  cat ${ADMIN_DIR}/who_to_page | while read LINE; do
 PAGER_PERSON=${PAGER_PERSON},${LINE}
  done
  ## Optional cleanup lines for the intractably paranoid
  PAGER_PERSON=`echo $PAGER_PERSON | sed 's/[   ]*//g'`
  PAGER_PERSON=`echo $PAGER_PERSON | sed 's/^,*//g'`
  PAGER_PERSON=`echo $PAGER_PERSON | sed 's/,,*/,/g'`
  if [ -n $PAGER_PERSON ]; then
 mailx -s IT IS ALL OVER THE WALLS $PAGER_PERSON  $PAGE_FILE
  fi
   fi
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT: Cron not working

[Stephen Lee]

 -Original Message- 
 Why the f(#$^%* it wasn't working,


You obviously ARE a beginner as it is clear you have not become familiar
with capriciousness of sunspots!
SUNSPOTS!  It's SUNSPOTS!
Now you know; so don't ask why anymore.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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[2]: awk and ksh question - solved

[Stephen Lee]

 -Original Message-
 It still seems like overkill to me. I just put the pager addresses in
 a alias in either /etc/aliases or .mailrc as a list for dba_oncall,
 eliminating the need for db_oncall.txt.
 
--

In a lot of companies, if a DBA managed to get into this file, the DBA would
have a short career there.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: awk and ksh question - solved

[Stephen Lee]

I thought I should add, if you wanted to comment out people in your pager
list, you could do something like:

sed 's/^[   ][]*//g; /^#/d' ${ADMIN_DIR/who_to_page | while read
LINE; do
 PAGER_PERSON=${PAGER_PERSON},${LINE}


Note: The brackets in the sed statement have a space and a tab in them to
handle the paranoia factor.

 -Original Message-
 FWIW, here is what I do:
 
## See if there is anything to send
COUNT=`awk '/^$/ {next}; END {print NR}' $PAGE_FILE`
## If so send it
if [ $COUNT -gt 0 ]; then
   PAGER_PERSON=''
   cat ${ADMIN_DIR}/who_to_page | while read LINE; do
  PAGER_PERSON=${PAGER_PERSON},${LINE}
   done
   ## Optional cleanup lines for the intractably paranoid
   PAGER_PERSON=`echo $PAGER_PERSON | sed 's/[   ]*//g'`
   PAGER_PERSON=`echo $PAGER_PERSON | sed 's/^,*//g'`
   PAGER_PERSON=`echo $PAGER_PERSON | sed 's/,,*/,/g'`
   if [ -n $PAGER_PERSON ]; then
  mailx -s IT IS ALL OVER THE WALLS $PAGER_PERSON 
  $PAGE_FILE
   fi
fi
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Stephen Lee
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: awk and ksh question - solved

[Stephen Lee]

 -Original Message-
 Those are the companies that you'd use the $HOME/.mailrc for.
 
-

Ah yes  TMTOWTDI

Since I have multiple scripts that do things and monitor things, the list of
mail and/or pager recipients is different for different things, even within
a single script. As a general philosophy on scripting, I like to keep things
as self-contained as reasonably practical.  I think this reduces the Murphy
Factor; and it makes it more obvious, when going to a directory for a
script, after not looking at the script for months, what stuff is required
for the script to do its thing -- it's all right there in that directory.
So I usually put larger scripts along with their config files in their own
directory.

If there are variables that we know we want to share among all scripts
regardless of who wrote the script, we keep those in a file called
ORACLE_VARIABLES (imaginative name, huh?).  And one of those variables is a
list of mail recipients for scripts that want to send to that list of
recipients.  The script code for pulling that list out of the text file is
very simple.

TMTOWDI.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT: Cron not working

[Stephen Lee]

 -Original Message-
 
 Wow! another BDBAFH! And Jared says that this isn't a DBA list?
 
-

No. No. I'm really (B)eneficial from (H)eaven!  (See my halo?)
The question about what to do about the situation had been answered.  But
the question about WHY it happened 
Why!?  You want to know WHY!?
There is only one answer to that.  And it is ALWAYS that one answer.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 quetion: to replace $ with \$

[Stephen Lee]

echo '123$456$789' | sed 's/\$/\\\$/g'
123\$456\$789

Why?  The $ means end of line to sed; so you have to quote it too.


 -Original Message-
 Maybe there is another syntax that I should use? TIA.
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT: unix script quetion: to replace $ with \$

[Stephen Lee]

Would something like this be adaptable to your stuff?

#!/usr/bin/ksh

{
sqlplus -s -XXX
joe/blow@SID
set this and that off
set the other thing and trimspool on
set whatever else
select table_name from dba_tables where owner = 'BUBBA';
} | while read LINE; do
echo exec analyze_that_puppy BUBBA.$LINE real good; | sed
's/\$/\\\$/g'
done
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: awk and ksh question

[Stephen Lee]

$number to awk means the number-th field.
To pass variables into an awk statement, you generally have two choices:

1.  The ugly one where you do a bunch of stuff with double and single
quotes.

2.  The correct one where you do something like

/usr/bin/nawk 'statement AWKVAR1 more statement AWKVAR2' AWKVAR1=$THIS
AWKVAR2=$THAT
where THIS and THAT are shell variables (such as $1 and $2).

Example:
export X=HELLO
echo SDFLKJ | nawk '{print Y}' Y=$X
HELLO

Note that you do NOT use $Y in the awk script; just Y.


-Original Message-
Sent: Monday, February 03, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L


Hello everyone, 
I'm trying to awk through a text file and use that with a passed-in message
to send email.  Here's an example of my text file:
# DBA's on call 
[EMAIL PROTECTED]# Lisa pager 
[EMAIL PROTECTED]# Lisa email 
Here's my awk statement, which works properly 
awk '!/^#/ {print $1}' filename.txt 
prints the first entry in each file and skips any lines starting with #. 
So I put it in a loop.  I don't quite understand all the syntax here, I'm
pulling the exact syntax out of Steve Adams'  database check script.  
-- 
for PAGER in ${*-$(awk '!/^#/ {print $1}' dba_oncall.txt)} 
do 
print $PAGER 
done 
-- 
Works fine. 


Now when I try to pass in a parameter in $1 (which I mean to be the email
message), awk grabs it and the script no longer works.  Like this

-- 
export FILE=$1 
print File is $FILE 
for PAGER in ${*-$(awk '!/^#/ {print $1}' dba_oncall.txt)}; 
do 
print $PAGER 
done 
-- 
This prints the name of the file in both print statements, before and inside
the loop.  What am I doing wrong?  


Also if anyone can explain in a nutshell what the ${} means (I think it
means consider the results as a variable) and the * and - and $() means in
the for/do loop syntax I would be grateful.  I'm leafing through my ksh book
but I think this is several specific functions all slapped together. 
Thanks to anyone that can help pull my head out of the sand... 
Lisa Koivu 
Oracle Database Administrator 
Fairfield Resorts, Inc. 
5259 Coconut Creek Parkway 
Ft. Lauderdale, FL, USA  33063 
Office: 954-935-4117  
Fax:954-935-3639 
Cell:954-683-4459 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Debate on rc commands Solaris and Oracle/startup force?

[Stephen Lee]

Startup force followed by shutdown immediate is what we use.  We have not
had any problems with it  yet.

 -Original Message-
 
 startup force?
 
 What is your experience about it?
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Excessive library cache latch contention

[Stephen Lee]

I don't know about 9, but I am pretty sure that in 8, this feature is
broken.

 -Original Message-
 cursor_sharing=FORCE may be an option,
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Excessive library cache latch contention

[Stephen Lee]

After I posted this, I thought I should elaborate:
This seems to work sometimes; but we also had some problems with it and
opened a TAR.  We were told there is an unspecified bug associated with it.
I guess the conclusion is: Try it.  Maybe it will work; maybe not.

 -Original Message-
 
 I don't know about 9, but I am pretty sure that in 8, this 
 feature is
 broken.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Debate on rc commands Solaris and Oracle

[Stephen Lee]

Any votes for startup force?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Perl

[Stephen Lee]

 -Original Message-
 Is it better/faster than a ksh script?
--

Whether you use perl or ksh, the main purpose of the script is to build a
command line and run it for whatever backup method you are using.  After
that, virtually all of the time is used by the backup process which doesn't
care from whence its command line came.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Perl - Was unix time conversion function

[Stephen Lee]

Original Message

In my mind there is nothing obvious about Perl,
Anyone else feel that way about Perl or am I a
lone wolf in a Perl world?


I think the correct progression is to start with ksh; then mix in sed, awk,
and maybe a dash of egrep.  When you finally are comfortable with
co-processes (aaaugh!!), then you are ready to start on Perl.  Not that Perl
has anything as goofy as co-processes; but if you can do that, you should be
ready for Perl.  The ksh function definition and calling as vaguely similar
to C, so you won't be on completely unfamiliar turf.  When you have gotten
the hang of sed, awk, and egrep, than at least some of Perl will be deja vu
all over again.

KSH!  PERL?!  We don't need no stinkin' Perl!

(except the ksh you get with Linux is probably the lame, piece-of-crap
version.  Download and build the REAL ksh93.)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Perl - Was unix time conversion function

[Stephen Lee]

My impression of Programming Perl was that it was primarily intended as an
ego trip for the author.  I found Learning Perl 2nd Ed. and Perl Core
Language / Little Black Book to be much more useful.  Yes, I have the Perl
for Oracle DBA's too, but haven't had the time to get into it yet.

 -Original Message-
 I've started writing some perl and it is hard to learn, but 
 once you learn,
 it can do some great things. And if you learned it from the 
 Larry Wall book
 like I did, then it's even harder.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Base conversion

[Stephen Lee]

Oracle made rowids base 64.  Try to identify a corrupt block number from
that when you do select rowid, last_column_of_table from table; to see
where the thing breaks.  Does anyone, perchance, know if they provided a
base 64 converter to go with the base 64 rowids?

 -Original Message-
 
 
 Sounds like something the bright spark or Duhveloper should 
 fix.  It's better
 when they experience their own pain.
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Windows 2000 Cluster on oracle

[Stephen Lee]

 -Original Message-
 I wanted to migrate my database from SUN solaris to WINDOWS 2000 
 platform.
-

... and there was a time when I thought it would be neat to put splinters in
my bathroom tissue.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Perl - Was unix time conversion function

[Stephen Lee]

 -Original Message-
 I'll bet Stephen has a toolbox in his garage that  contains
 a single flat blade screwdriver and no phillips screwdrivers nor any
 wrenches.  ;)
 
-

Don't need tools.  Got pshycokinesis (got milk too).  Been taking lessons
from Carrie (and dating her mom!).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Base conversion

[Stephen Lee]

 -Original Message-
 Stephen,
 
 The code I posted earlier is easily adapted to do base 64.
 
 Please share your mods.  :)
-

OK.  I figured out that A is zero (I think).  Now, only 63 more to go!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sequences in 8.1.7 vs 9i

[Stephen Lee]

sed will fix that in a big hurry.  PERL?!  We don't need no stinkin' perl!

 -Original Message-
 
 The problem is that there are over 
 2000 lines of
 code similar to the one I identified.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Slow database, too MANY buffers???

[Stephen Lee]

From your e-mail, I get the impression that there is a 687 Mb SGA on a box
with 256 Mb.  If that is the case, then the majority of the instance is
sitting out on a swap file ... on a hard drive ... not in memory.  For what
it's worth, 687 Mb SGA is not **HUGE** (actually, it's rather small these
days).  But 256 Mb of memory is **TINY**.  All this ASS-U-ME-s that I have
interpreted your post correctly.

-Original Message-

I suspect it is the error of having a **HUGE** value
in db_block_buffers and it's constantly crunching memory
trying to figure out which ones to free up. It's only
256 meg, but depending on load, it may be too much. SGA
is 687 meg.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Slow SQL*Plus connect.

[Stephen Lee]

If the box is swapping memory, connections can be slow since memory has to
allocated for the connection.  Just one possibility.

 -Original Message-
 
 We have experienced a *very* slow connect time to a 9.0.1 database via
 SQL*Plus (and other apps as well) on a Win2K machine,
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database Verification

[Stephen Lee]

If I recall correctly, RMAN checks for corruption.

-Original Message-
 
I am considering the appropriate way to do database corruption prevention.

Should I use  one or more of the following as a proactive measure ?
  a) Export  
  b) DBVerify  
  c) Analyze table table_name validate structure cascade 

Any advice ?

Thanks,

PH



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: from Non-Archive-Mode to Archive-Mode

[Stephen Lee]

It depends on how much data is changed in the database.  If there is no data
manipulation, then you need very little archive space (just enough for the
online logs when you run a backup).  Look in the alert log to see how many
log switches occur.  I think this will give you a reasonable estimate of how
much archiving will occur.

-Original Message-
Sent: Friday, January 17, 2003 4:09 AM
To: Multiple recipients of list ORACLE-L

Hi,

  how can I calculate/estimate the extra disk space I'll need if I
change the log mode from non-archive-mode to archive-mode. I want to change
the log mode of all my objects. Do I need to do this one-by-one or is it
enough if I change the log mode of my tablesapces?

Thanks in advance

Murat



--
Bu  e-posta  sadece  yukarida  isimleri  belirtilen  kisiler  arasinda ozel
haberlesme  amacini  tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji
geri  gonderiniz  ve  sisteminizden  siliniz.  Rt.Net  Internet  Hizmetleri
Pazarlama  ve  Ticaret  A.S.  bu  mesajin icerigi ile ilgili olarak hic bir
hukuksal sorumlulugu kabul etmez.

This  e-mail  communication  is intended for the private use of the persons
named  above.  If  you  received  this message in error, please immediately
notify  the  sender  and  delete  it  from  your  system.  Rt.Net  Internet
Hizmetleri  Pazarlama  ve Ticaret A.S. does not accept legal responsibility
for the contents of this message.
--



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MURAT BALKAS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: More RMAN Questions

[Stephen Lee]

For question 1.

(920)/oracle/app/oracle/admin rman nocatalog

Recovery Manager: Release 9.2.0.2.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN connect target sys/password@sid (NOTE: sid is 8.1.7)

Recovery Manager incompatible with TARGET database: RMAN 8.0.4 to 8.1.6
required
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-06429: TARGET database is not compatible with this version of RMAN

For question 2.

I suppose you could write your own API to talk to legato, but it seems like
it would be a lot of extra work.  One scenario that I have found works well
-- IF your databases aren't too big and you have plenty of fault-tolerant
disk space -- is to back up to disk; then use OS to copy backup sets to
tape.  If space permits, keep two or three days worth of stuff on disk (hard
drives are cheap).  Handy Handy!

Here is a driver script I use to rotate directories for storing more than
one day's worth of backups on disk.

- go.ksh --
#!/bin/ksh

BASEDIR='/u05/oracle/admin'
SIDLIST=''

cd $BASEDIR

for SID in `ls -1`;do
   RESULT=''

   BACKDIR=${BASEDIR}/${SID}/backup
   if [ -d $BACKDIR ]; then
  SIDLIST=${SIDLIST} ${SID}
   else
  continue
   fi
   cd $BACKDIR
   if [ ! -d ${BACKDIR}/DIR1 ]; then
  mkdir -m 750 ${BACKDIR}/DIR1
   fi
   if [ ! -d ${BACKDIR}/DIR2 ]; then
  mkdir -m 750 ${BACKDIR}/DIR2
   fi
   ls -1dt DIR[12] 2 /dev/null | while read LINE; do
  if [ -n $LINE ]; then RESULT=$LINE; fi
   done
   STASH=${BACKDIR}/${RESULT}

   find $STASH \( -type f -a -ctime +2 \) -exec rm {} \;

   for i in `find . -type f -print -o \( ! -name . -a -type d -prune \)`; do
  mv $i ${STASH}/${i}
   done

done

/oracle/app/oracle/admin/dbascripts/rman/disk_backup.ksh $SIDLIST 
/oracle/app/oracle/admin/dbascripts/rman/debug 21

- End go.ksh -

-Original Message-
 
Oracle environment: 3 x 8.1.6 databases + 23 x 8.1.7 databases on 3 servers
running AIX 4.3.3.
 
My plan is to use RMAN 9i, Legato Module for Oracle without a catalog and
have all databases in archivelog mode.  Databases will be backed up
incrementally and full.
 
Questions below:
 
1) Will RMAN 9iR2 support 8.1.6  8.1.7 databases w/out using a catalog? 
From the documentation, it appears the RMAN executable must match the target
database.
 
2) Is RMAN even required for use w/ the Legato Module for Oracle?  I know
the MML is not required for RMAN, hence RMAN disk backups.
 
My prior plan was to upgrade the databases to 9iR2 then implement RMAN, no
time to do both.  Can I use RMAN 9i w/ older database versions?
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: More RMAN Questions

[Stephen Lee]

After looking at my post, I thought maybe showing the contents of the
directories involved might help show the logic (??) of the script.

/u05/oracle/admin ls
ACP1/  HLPP/  HRP1/  INTP/  MOBP/  RCNP/  RSAP/  TIMP/

/u05/oracle/admin/ACP1/backup ls -l
-rw-r-   1 oracle   dba3645440 Jan 15 22:09 CONTROL_FILE.BAK
drwxr-x---   2 oracle   dba   8192 Jan 15 22:00 DIR1/
drwxr-x---   2 oracle   dba   8192 Jan 14 22:00 DIR2/
-rw-r-   1 oracle   dba  847053824 Jan 15 22:08 mjed073k_1_1_DATA
-rw-r-   1 oracle   dba   14367744 Jan 15 22:09 mked07kf_1_1_ARCH
-rw-r-   1 oracle   dba   14367744 Jan 15 22:09 mled07kj_1_1_ARCH
-rw-r-   1 oracle   dba3662848 Jan 15 22:09 mmed07ko_1_1_CONTROL

/u05/oracle/admin/ACP1/backup/DIR2 ls -l
-rw-r-   1 oracle   dba3645440 Jan 13 22:09 CONTROL_FILE.BAK
-rw-r-   1 oracle   dba  844276736 Jan 13 22:07 mbecqubk_1_1_DATA
-rw-r-   1 oracle   dba   16161792 Jan 13 22:09 mcecqusf_1_1_ARCH
-rw-r-   1 oracle   dba   16161792 Jan 13 22:09 mdecqusk_1_1_ARCH
-rw-r-   1 oracle   dba3662848 Jan 13 22:09 meecqusp_1_1_CONTROL
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Caching a huge table's data in memory

[Stephen Lee]

Pro: It is in memory

Con: You must buy the memory.  You must be sure you don't cause the box to
start paging to swap ... very bad ... VERY bad.

When you live in the land of bad applications, sometimes the politics of the
situation are such that you just do what you know is the equivalent of
fixing things with duct tape  -- a whole lot of duct tape -- rather than
attempt to engage in a hopeless fight.  Consider the case of an application
that is so bad that a box with more than 50 Gb of RAM and 16 Alpha CPU's are
required to handle from 6 to 10 active connections.  Hey, if they want to
spend the money 


 -Original Message-
 What are the pros and cons of caching a table's data?  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Caching a huge table's data in memory

[Stephen Lee]

I have never delved into just what gets cache and how permanently it gets
cached when a table is cached.  In the case of a monstrosity of an
application, to cache or not to cache (that is the question) a large table,
is a case of tweedle-dee and tweedle-dum.  But when people are grabbing at
any straw that can be grabbed, you just go with the flow and hope the real
problems and what needs to be done become self-evident.

-Original Message-

I don't think a cache table is actually pinned in memory. It just means 
that its blocks stick around once they are read and are not recycled as 
much as normal tables. That having been said, due diligence should be 
taken to tune the queries and caching large tables should be avoided. What 
good is it if you tune, or rather, speed up one query if it takes
resources 
away from other queries and slows down the overall system? Sounds like a 
good opportunity to educate a DUHveloper. Tune the query and show her/him 
before and after tkprof stats. Better yet, teach her/him how to use tkprof 
and make them run it on each query before putting it into code. Make sure 
your test/development data set reflects production volumes. 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Automatic backup on Oracle 9i -- For Jared

[Stephen Lee]

I should have mentioned that another useful one could be QRM.

QRM = I am experiencing interference.
QRM? = Are you experiencing interference?

Look across the table at your DBA-mates during your next meeting with
management and say or ask QRM(?).  Or blink your eyes.

--.-  .-.  --


 -Original Message-
 
 Yea but I never see a what's your QTH
 
 joe
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database/system Crashing

[Stephen Lee]

Title: RE: Database/system Crashing



If the database 
has data files on NFS mounts, then any network problems or problems on the NFS 
server can crash things. Disappearing NFS mounts can be very nasty. 
That's why it's a big no-no to putANY files related to the database -- 
data files, log files, oracle binaries, etc. --on NFS 
mounts.

  -Original Message-From: Webber Valerie H 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003 
  10:40 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Database/system Crashing
  Yes there are NFS mounts involved. What you said about the OS 
  locks on the audit directory makes a lot of sense. My SA's are back to 
  thinking it's a OS problem because it crashed again with the database shut 
  down. 
  The odd thing is that there is nothing written to the Oracle 
  alert log file nor are there any entries in the trace files. But when the 
  system is rebooted and I bring the db back up, Oracle knows it previously 
  crashed and recovers itself. That's in the alert log file. Its like the system 
  is losing its pointers or something. I suggested reinstalling the OS and 
  Oracle then put my database back and see if that helps. Are there huge risks 
  with this scenario?
  Another odd thing that the SA's can't figure out is there are 
  no entries in the message file nor can they get a dump file to determine why 
  the system crashed. There is nothing. It crashed over the weekend with no 
  activity and they got some sort of i-nodes error. 
  Thanks for all your replies. Any ideas are helpful and I will 
  relay them to our SA's... 
  Val 
  -Original Message- From: 
  Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 10:09 AM To: 
  Multiple recipients of list ORACLE-L Subject: RE: 
  Database/system Crashing 
  I wonder if a file lock is being left in place when the 
  instance crashes, and the OS does not clear the lock 
  until a reboot. I would think the OS should 
  clear this without a reboot, but stranger things have been seen with 
  OS's ... even Unix. This doesn't explain why the 
  instance crashes. I wonder if fuser would show 
  anything. Are there any NFS mounts involved? 
  -Original Message- Yes, you're 
  correct and it can write the file to $ORACLE_HOME/rdbms/audit once the system is rebooted. Its just that when the database crashes, 
  it can't write to that location until its 
  rebooted. Is it possible that I need to beef up my 
  init.ora parameters? -- Please 
  see the official ORACLE-L FAQ: http://www.orafaq.net -- 
  Author: Stephen Lee  
  INET: [EMAIL PROTECTED] 
  Fat City Network Services -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (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: Database/system Crashing

[Stephen Lee]

I wonder if a file lock is being left in place when the instance crashes,
and the OS does not clear the lock until a reboot.  I would think the OS
should clear this without a reboot, but stranger things have been seen with
OS's ... even Unix.  This doesn't explain why the instance crashes.  I
wonder if fuser would show anything.  Are there any NFS mounts involved?

-Original Message-
Yes, you're correct and it can write the file to $ORACLE_HOME/rdbms/audit
once the system is rebooted. Its just that when the database crashes, it
can't write to that location until its rebooted.
Is it possible that I need to beef up my init.ora parameters?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Free Shared pool memory

[Stephen Lee]

How does this grab you?

FTLP show sga

Total System Global Area 2.2596E+10 bytes
Fixed Size   103396 bytes
Variable Size1120354304 bytes
Database Buffers 2.1475E+10 bytes
Redo Buffers1064960 bytes

Got a bad application?  Throw more hardware at it!  QRO! QRO!


 -Original Message-
 can you give your opinion?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Automatic backup on Oracle 9i -- For Jared

[Stephen Lee]

Maybe it's time to bring back all those Morse code Q abbreviations with
appropriate adaptation to IT industry.  Instead of QRO meaning increase
your power, it might mean Here's a nickel kid, get yourself a better
computer.

I don't think you will ever see QRP used (reduce your power).


 -Original Message-
 With more people start to use wireless phones, PDAs, we will see more
 messages like this.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Automatic backup on Oracle 9i

[Stephen Lee]

If this is rman backup, perhaps try granting sysdba to sys, or connecting to
target as sysdba?


 -Original Message-
 From: Sony kristanto [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, December 26, 2002 7:24 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Automatic backup on Oracle 9i
 
 
 Hi Listers,
 I'm new on Oracle Database 9i after I migrated from Oracle 8i.
 I try to use backup facility from Oracle 9i and I already follow the
 instructions how to activate the automatic backup but when I 
 see the status
 on history I get an error comment 'Failed'. I've try again 
 and again but the
 results are the same. Could someone out there tell me why it 
 can't runs. For
 your note I use 'SYS' as my user. I will really appreciate your help.
 
 Rgrds,
 
 Sony
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Sony kristanto
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Rebuilding Indexes...

[Stephen Lee]

Title: Rebuilding Indexes...



Here is the index 
rebuilding part of a ksh script I use. Prior to this, I some variable 
setting, check the existence and permissions on some files, check the existence 
of tablespaces, check that the script is not already running, etc. In this 
script, all the index extentsare set to the same size whichis fine 
for this particular database.

- snip 


echo "RAT INDEX 
REBUILD SCRIPT"  "$MAILFILE"## First index build to 
alternate tablespace ###echo "--- START TIME: 
`/usr/bin/date +'%T %D'` --"  
"$MAILFILE"{sqlplus -s -system/$SYSPASS@$ORACLE_SID-- 
crap-- crap-- crap

set 
serveroutput onwhenever sqlerror exit failure

ALTER 
TABLESPACE ALT_RAT_DATA_IDX COALESCE;

declarecursor c1 is select owner,index_name from 
dba_indexes where tablespace_name = 'RAT_DATA_IDX';a 
integer;b 
integer;begindbms_output.enable(50);

for x 
in c1 loopexecute immediate 'ALTER INDEX 
'||x.owner||'.'||x.index_name||' REBUILD INITRANS 20 STORAGE(INITIAL 1M NEXT 1M 
MAXEXTENTS UNLIMITED PCTINCREASE 0) TABLESPACE ALT_RAT_DATA_IDX 
ONLINE';dbms_output.put_line('ALT_RAT_DATA_IDX 
'||x.owner||'.'||x.index_name);end loop;

select 
count(*) into a from dba_indexes where tablespace_name = 
'RAT_DATA_IDX';select count(*) into b from dba_indexes where 
tablespace_name = 
'ALT_RAT_DATA_IDX';dbms_output.put_line('RAT_DATA_IDX = 
'||a||' ALT_RAT_DATA_IDX = 
'||b);

exceptionwhen others 
thendbms_output.put_line('ERROR: '||SQLCODE||' 
'||SQLERRM);end;/} | /usr/bin/sed '/^$/d; 
s/^ *//g; s/^ *$//g' | while read LINE; doif [ -n 
"`echo $LINE | /usr/bin/sed -n '/^ERROR/p'`" ]; thenecho 
"PROBLEM encountered on first index rebuild."  
"$MAILFILE"echo "$LINE"  
"$MAILFILE"while read LINE; 
doecho "$LINE"  
"$MAILFILE"doneecho "$0 $* did not 
finished"  "$MAILFILE"mailx -s "BROKE: rat index 
rebuild" $SUPPORT  "$MAILFILE"exit 
1fiecho "$LINE"  
"$MAILFILE"done

echo 
"- END FIRST REBUILD: `/usr/bin/date +'%T %D'` --" 
 "$MAILFILE"

## 
Second index build back to original tablespace ###{sqlplus -s 
-system/$SYSPASS@$ORACLE_SID-- 
crap-- crap-- crap

set 
serveroutput onwhenever sqlerror exit failure

ALTER 
TABLESPACE RAT_DATA_IDX COALESCE;

declarecursor c1 is select owner,index_name from 
dba_indexes where tablespace_name = 'ALT_RAT_DATA_IDX';cursor c3 
is select owner,object_name from dba_objects where status = 
'INVALID';a integer;b 
integer;begindbms_output.enable(10);

for x 
in c1 loopexecute immediate 'ALTER INDEX 
'||x.owner||'.'||x.index_name||' REBUILD INITRANS 20 STORAGE(INITIAL 1M NEXT 1M 
MAXEXTENTS UNLIMITED PCTINCREASE 0) TABLESPACE RAT_DATA_IDX 
ONLINE';dbms_output.put_line('RAT_DATA_IDX 
'||x.owner||'.'||x.index_name);end loop;

select 
count(*) into a from dba_indexes where tablespace_name = 
'RAT_DATA_IDX';select count(*) into b from dba_indexes where 
tablespace_name = 
'ALT_RAT_DATA_IDX';dbms_output.put_line('RAT_DATA_IDX = 
'||a||' ALT_RAT_DATA_IDX = 
'||b);

dbms_output.put_line('--- INVALID OBJECTS 
-');

for x 
in c3 
loopdbms_output.put_line(x.owner||'.'||x.object_name);end 
loop;

exceptionwhen others 
thendbms_output.put_line('ERROR: '||SQLCODE||' 
'||SQLERRM);end;/

ALTER 
TABLESPACE RAT_DATA_IDX COALESCE;ALTER TABLESPACE ALT_RAT_DATA_IDX 
COALESCE;

} | 
/usr/bin/sed '/^$/d; s/^ *//g; s/^ *$//g' | while read LINE; 
doif [ -n "`echo $LINE | /usr/bin/sed -n '/^ERROR/p'`" ]; 
thenecho "PROBLEM encountered on second index 
rebuild."echo "$LINE"while read 
LINE; doecho 
"$LINE"doneexit 
1fiecho "$LINE"  
"$MAILFILE"done

echo 
"- END SECOND REBUILD: `/usr/bin/date +'%T %D'` 
--"  "$MAILFILE"

mailx -s "SUCCESS: 
rat index rebuild" $SUPPORT  "$MAILFILE"

exit 
0

RE: Migrate table data to CSV file - Urgent help !!!

[Stephen Lee]

If I understand your question correctly:

If you are on Unix, or have the sed utility available. then you can do
something like the following.  Assume X is the character to eliminate.


sed 's/X//g'  CSV_file  temp_file

verify temp_file is OK, then replace CSV_file with temp_file.  Perl has
syntax similar to this.


 -Original Message-
 From: oraora oraora [mailto:[EMAIL PROTECTED]]
 Sent: Monday, December 23, 2002 11:49 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Migrate table data to CSV file - Urgent help !!!
 
 
 Guys,
 
 i want to export table data into a CSV file.
 i am using the script below to do the same.
 --
 set   wrap off
 set linesize 2000
 set   feedback off
 set   pagesize 0
 set   verify off
 set termout off
 
 spool ytmpy.sql
 
 prompt prompt LOAD DATA
 prompt prompt INFILE *
 prompt prompt INTO TABLE 1 
 prompt prompt REPLACE
 prompt prompt FIELDS TERMINATED BY ','
 prompt prompt (
 select  'prompt ' || decode(column_id,1,'',',') || lower(column_name)
 fromuser_tab_columns
 where   table_name = upper('1')
 order by column_id
 /
 prompt prompt )
 prompt prompt BEGINDATA
 
 prompt  select
 select  lower(column_name)||'||chr(44)||'
 fromuser_tab_columns
 where   table_name = upper('1') and
 column_id != (select max(column_id) from user_tab_columns where
  table_name = upper('1'))
order by column_id
 /
 select  lower(column_name)
 fromuser_tab_columns
 where   table_name = upper('1') and
 column_id = (select max(column_id) from user_tab_columns where
  table_name = upper('1'))
order by column_id
 /
 prompt  from1
 prompt  /
 
 spool off
 
 set termout on
 
 @ytmpy.sql
 exit
 -
 things work fine.
 for example , i have a record as below (fields seperated by , ) :
 AAA,B,C,D,,GGG
 the  at the end of D is new line character .hope so.
 when this record gets written to CSV file , it is like this :
 AAA,B,C,D
 you can see the data after  is truncated.
 and the records after this without  are written properly.
 problem occurs when there is  in a record.
 how to get rid of this ? 
 
 kindly help me plzzz. This is quite urgent.
 
 TIA.
 Jp. 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: oraora  oraora
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RMAN and cron

[Stephen Lee]

Are you executing (or running) the env variable script; then running the
backup script?  If so, then the env script sets the variables OK ... in the
sub-shell that ran it!  When that sub-shell finishes the env script, then
your variables exit with the sub-shell.  If this is what you have going on,
then put the variable in the same script as the backup, or dot the env
script.

 . env_script
 /execute/the/backup


 -Original Message-
 From: Ron Rogers [mailto:[EMAIL PROTECTED]]
 Sent: Monday, December 23, 2002 8:24 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RMAN and cron
 
 
 list,
  Cron server os RedHat 7.2
  Database server os OpenVMS 7.3-1
  Database Oracle 8.1.7 rel 3
  Rman server os OpenVMS 7.3-1
  Rman Oracle 8.1.7 rel 3
  
  On the Cron server I have created a script that will backup the
 database server and catalog the action on the rman server. 
 When I try to
 have cron perform the backup sctipt I get 
 RMAN-571 and LEM-00031, and LEM-00033 error message. According to
 Metalink it is an environmental error that the oracle 
 variables are not
 set. I have set up my environment as follows:
 
 file:  /alphaprd/profile
 ORACLE_HOME =  cron server ORACLE_HOME
 ORACLE_BASE =cron server ORACLE_BASE
 LD_LIBRARY_PATH = cron server LD_LIBRARY_PATH
TNS_ADMIN = cron server TNS_ADMIN
  export ORACLE_HOME ORACLE_BASE LD_LIBRARY_PATH TNS_ADMIN
 
 Script to backup the database controlfile: test.sh
 
 ./alphaprd/profile
 echo start backup: /alphaprd/rman_test.log
 /home/oracle/OraHome1/bin/rman EOF /alphaprd/rman_test.log
 connect target sys/password@database server
 connect catalog rman/rman@rman server
 run {
 allocate channel di type disk;
 backup format
 'orabck:[backups]control_%U.bus'
 (current controlfile);
 }
 EOF
 
 Crontab entry as ROOT:
 10 01 * * 1 su oracle -c /alphaprd/test.sh -u
 
 OR 
 Crontab entry as ORACLE
 10 01 * * 1 /alphaprd/test.sh
 
 The script functions properly if I run it from the command line as
 oracle but fails with
 RMAN-571 and LEM-00031 and LEM-00033 errors when run from cron.
 
 I don't see how it could be Oracle environmentals when I am running it
 as an Oracle cron and the target and catalog are on a different server
 that the cron server.
 Can you point me in the direction where I can get this resovled?
 Thanks,
 Ron
 -- 
 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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RMAN and cron

[Stephen Lee]

I suppose I should add that you can also have the backup script dot the
env script.
For example:

- backup_script.ksh -
#!/usr/bin/ksh

. /path/to/env_script

etc.
etc.
etc.
---

 -Original Message-
 From: Stephen Lee [mailto:[EMAIL PROTECTED]]
 Sent: Monday, December 23, 2002 8:49 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: RMAN and cron
 
 
 
 Are you executing (or running) the env variable script; then 
 running the
 backup script?  If so, then the env script sets the variables 
 OK ... in the
 sub-shell that ran it!  When that sub-shell finishes the env 
 script, then
 your variables exit with the sub-shell.  If this is what you 
 have going on,
 then put the variable in the same script as the backup, or 
 dot the env
 script.
 
  . env_script
  /execute/the/backup
 
 
  -Original Message-
  From: Ron Rogers [mailto:[EMAIL PROTECTED]]
  Sent: Monday, December 23, 2002 8:24 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RMAN and cron
  
  
  list,
   Cron server os RedHat 7.2
   Database server os OpenVMS 7.3-1
   Database Oracle 8.1.7 rel 3
   Rman server os OpenVMS 7.3-1
   Rman Oracle 8.1.7 rel 3
   
   On the Cron server I have created a script that will backup the
  database server and catalog the action on the rman server. 
  When I try to
  have cron perform the backup sctipt I get 
  RMAN-571 and LEM-00031, and LEM-00033 error message. According to
  Metalink it is an environmental error that the oracle 
  variables are not
  set. I have set up my environment as follows:
  
  file:  /alphaprd/profile
  ORACLE_HOME =  cron server ORACLE_HOME
  ORACLE_BASE =cron server ORACLE_BASE
  LD_LIBRARY_PATH = cron server LD_LIBRARY_PATH
 TNS_ADMIN = cron server TNS_ADMIN
   export ORACLE_HOME ORACLE_BASE LD_LIBRARY_PATH TNS_ADMIN
  
  Script to backup the database controlfile: test.sh
  
  ./alphaprd/profile
  echo start backup: /alphaprd/rman_test.log
  /home/oracle/OraHome1/bin/rman EOF /alphaprd/rman_test.log
  connect target sys/password@database server
  connect catalog rman/rman@rman server
  run {
  allocate channel di type disk;
  backup format
  'orabck:[backups]control_%U.bus'
  (current controlfile);
  }
  EOF
  
  Crontab entry as ROOT:
  10 01 * * 1 su oracle -c /alphaprd/test.sh -u
  
  OR 
  Crontab entry as ORACLE
  10 01 * * 1 /alphaprd/test.sh
  
  The script functions properly if I run it from the command line as
  oracle but fails with
  RMAN-571 and LEM-00031 and LEM-00033 errors when run from cron.
  
  I don't see how it could be Oracle environmentals when I am 
 running it
  as an Oracle cron and the target and catalog are on a 
 different server
  that the cron server.
  Can you point me in the direction where I can get this resovled?
  Thanks,
  Ron
  -- 
  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: Stephen Lee
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RMAN, recatalog backup set

[Stephen Lee]

When you are not 
using a catalog database, the control file is your only catalog. If you 
destroy all copies ofit, then you have destroyed your catalog. It's 
gone. It is a late catalog. It is no more. (I wish I could 
remember the Monty Python dead parrot bit.) That's why you must backup the 
control file at the end of the rman backup -- a REAL backup of the file itself, 
not a "to trace" backup.

  -Original Message-From: Vladimir Barac 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 4:49 
  AMTo: Multiple recipients of list ORACLE-LSubject: RMAN, 
  recatalog backup set
  Hi!
  
  RMAN 8.1.7, nocatalog 
  option
  
  I have two backup sets, placed on disk. 
  Those backup sets contain archived logs.
  
  How do I register those sets (and arch. 
  logs they contain) in newcontrolfile?
  
  "New controlfile" is created by "alter 
  database backup controlfile to trace" script. So, RMAN info is nonexistant. 
  
  
  Thanks,
  Vladimir 
Barac

RE: Disable Database Startup While COLD Backup is in Progress

[Stephen Lee]

Rename the init.ora?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 8i OCP DBA Exams

[Stephen Lee]

They are trying to catch up with Sybase.  Larry feels bad about falling
behind.

 -Original Message-
 Not to mention 10i is coming out soon. Too fast man.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RMAN scripts - archived logs

[Stephen Lee]

Attached (If the list supports attachments) are one for tape (Legato
Networker) and one for disk which later gets backed up by OS.  These are
generated by a ksh backup script every time the script runs.  The disk
backup does not use a catalog server; so you have the line at the end that
backs up the control file.


-Original Message-
 Would somenone share their scripts used to backup
 archived logs




disk_backup_arch.rcv
Description: Binary data


tape_backup_arch.rcv
Description: Binary data

RE: Footprint of 9i

[Stephen Lee]

On Tru64 5.1

/oracle/app/oracle/product du -sk 9.2.0
4601900 9.2.0

There are multiple DBA's here that have a hand in this, so I don't know how
much fiddling with the Apache stuff has been done (probably not much).  At
this time, there is only one 9.2 database on the box, and it is
experimental, so I don't think there are a bunch of network logs that have
piled up.  I think this installation everything including the kitchen
sink, so I would think this size would be near the upper limit.

 -Original Message-
 From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, December 19, 2002 7:49 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Footprint of 9i
 
 
 All
 
 I'm about to consider rolling out 9i here and I'm wondering 
 what type of
 footprint most people are seeing. In other words how large of 
 an install
 is a database administrators (enterprise edition)?
 
 I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8
 all were about 2G. I also noticed that even if I tried to remove some
 components I did not think I needed that the installation 
 size/footprint
 was not really affected
 
 Also a worthwhile note is that my current (enterprise edition) install
 of 8 17 on win2k server is about 1G 
 
 This issue is we all run the same size drives here and really cant
 afford to loose 2G 1G maybe 
 
 So is it true that overall installing the Enterprise edition of 9i
 that one could not expect to be much below 2G??
 
 If not, we may have to add a drive for the dba's which is not going to
 go over big.
 
 thanks
 Bob
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Bob Metelsky
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Backup DB files to the Tape

[Stephen Lee]

It's one of those Unix things.  It goes with the beard and the bad-fitting
trousers held up by suspenders.


 -Original Message-
 From: Hemant K Chitale [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, December 19, 2002 9:21 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Backup DB files to the Tape
 
 
 Stephen,
 
 The para. about pax vis-a-vis tar versus cpio was interesting !
 I never knew that -- though the names do make sense now !
 Hemant
 
 At 06:39 AM 18-12-02 -0800, you wrote:
 
 I will add a vote for cpio.  I have found it to be so 
 reliable that I used
 cpio, instead of a dump utility, to back up Unix boxes.  It 
 never failed.
 In the past, I found that tar had filename length limitation that was
 shorter than what the OS permitted (80 characters iirc -- 
 that's filename,
 not path).  This happened when I worked in a development 
 environment that
 used Rogue Wave tools.  During software builds, files would 
 be generated
 with ridiculously long names, and tar could not handle 
 these.  Time has
 passed since the days I had to backup Unix servers, but iirc 
 cpio could
 correctly handle all types of special files (devices, etc.), 
 and tar could
 not (as I said, iirc).
 
 If you are just experimenting, there is another utility 
 called pax, which is
 latin for peace, the idea being that it will bring peace to 
 the Tar Wars
 where tar2d2 is always fighting c3pio.  I get the impression 
 that neither
 group was willing to abandon its favorite utility and adopt 
 pax, so the
 fight goes on.
 
 
   -Original Message-
  
   Well for this you can use cpio command in Unix for copying
   files to Tape.
  
   Another option is using ufsdump commnand .
  
We have UnixWare 7.1 and I want to take backup of
Database files (Physical files) to my tape.
   
I did use tar command:
   
tar c8v1 /home/oradata
   
It's working properly but the problem is:
   
tar can't handle large files(larger than 2GB).
The total size of the DB files under /home/oradata
more than 2GB.
   
So the result I'll get some of those files not all.
   
Could any body in the list give me the alternative
command of tar that can handle backup of large files
or any other solution...
   
because I want to schedule this process.
   
Your help will be appreciated.
   
Regards,
ashraf salaymeh
System Analyst(OCP Certified DBA)
   
__
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.com
--
Author: Ashraf Salaymeh
  INET: [EMAIL PROTECTED]
   
Fat City Network Services-- 858-538-5051 
 http://www.fatcity.com
San Diego, California-- Mailing list and web
   hosting services
   
   
 -
To REMOVE yourself from this mailing list, send an 
 E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 
 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: dilmohan
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- 858-538-5051 
 http://www.fatcity.com
   San Diego, California-- Mailing list and web 
 hosting services
   
 -
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 
 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (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: Stephen Lee
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 Hemant K Chitale
 My web site page is :  http://hkchital.tripod.com
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Hemant K Chitale
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing

RE: Backup DB files to the Tape

[Stephen Lee]

Long live Dilbert!

The scary thing around here is that the guy that most fits the description
is an NT admin.  He even has empty Mountain Dew cans all over his cubicle.
The only thing missing are the Hostess Twinkie wrappers.

 -Original Message-
 From: Brian Dunbar [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, December 19, 2002 11:45 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Backup DB files to the Tape
 
 
 Here's a nickel, kid. Go buy yourself a better computer.
 
 -Original Message-
 Sent: Thursday, December 19, 2002 10:15 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 It's one of those Unix things.  It goes with the beard and 
 the bad-fitting
 trousers held up by suspenders.
 
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Backup DB files to the Tape

[Stephen Lee]

I will add a vote for cpio.  I have found it to be so reliable that I used
cpio, instead of a dump utility, to back up Unix boxes.  It never failed.
In the past, I found that tar had filename length limitation that was
shorter than what the OS permitted (80 characters iirc -- that's filename,
not path).  This happened when I worked in a development environment that
used Rogue Wave tools.  During software builds, files would be generated
with ridiculously long names, and tar could not handle these.  Time has
passed since the days I had to backup Unix servers, but iirc cpio could
correctly handle all types of special files (devices, etc.), and tar could
not (as I said, iirc).

If you are just experimenting, there is another utility called pax, which is
latin for peace, the idea being that it will bring peace to the Tar Wars
where tar2d2 is always fighting c3pio.  I get the impression that neither
group was willing to abandon its favorite utility and adopt pax, so the
fight goes on.


 -Original Message-
 
 Well for this you can use cpio command in Unix for copying 
 files to Tape.
 
 Another option is using ufsdump commnand .
 
  We have UnixWare 7.1 and I want to take backup of
  Database files (Physical files) to my tape.
 
  I did use tar command:
 
  tar c8v1 /home/oradata
 
  It's working properly but the problem is:
 
  tar can't handle large files(larger than 2GB).
  The total size of the DB files under /home/oradata
  more than 2GB.
 
  So the result I'll get some of those files not all.
 
  Could any body in the list give me the alternative
  command of tar that can handle backup of large files
  or any other solution...
 
  because I want to schedule this process.
 
  Your help will be appreciated.
 
  Regards,
  ashraf salaymeh
  System Analyst(OCP Certified DBA)
 
  __
  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.com
  --
  Author: Ashraf Salaymeh
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web 
 hosting services
  
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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: dilmohan
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: archiving redo logs

[Stephen Lee]

After the subconscious worked on this a bit, a solution that I should have
thought of, right at the beginning, popped into my head.  Unix has a
wonderful utility called rdist that is intended for just this sort of thing.
If you read the man page, it will talk about a distfile which contains
commands for the utility.  I rarely use a distfile, and when I do, I have to
re-read the man page s-l-o-w-l-y to relearn the syntax for the distfile.  I
usually use rdist to copy an entire directory tree to another box.  A
command for this is:

cd /directory/to/copy
rdist -wc * other_box:/where/to/copy

The spiffy thing about rdist is that it will only copy what is new or has
been updated on the source box.  By default, I think the decision about what
to update is done on the basis of time, but you can tell rdist to perform a
binary comparison of files -- a process I think would be a bit time
consuming for large files.

In the case of your archived logs, this would certainly work, but I think
rdist would try to copy any archive that was currently being written.  I
don't think this would be a problem since, at the next invocation, it would
detect that the log that was being written at the previous invocation has
been updated and would copy it again.  However, if you wanted to avoid this,
you could do something like:

 go.ksh --

#!/usr/bin/ksh

## Check that we can rsh to the other box.
rsh other_box '/usr/bin/date'  /dev/null 21
if [ $? -ne 0 ]; then
echo Something broke
exit 1
fi

cd /the/source/directory

COUNT=0
for FILE in `ls -1t *.xyz 2 /dev/null`; do

COUNT=$(( $COUNT + 1 ))
if [ $COUNT -gt 2 ]; then
rdist -wc $FILE other_box:/the/destination/directory
fi

done



The script will attempt to rdist all but the most recent two archived logs
(adjust this in the if condition).  Any logs that have already been copied
will not get copied again, so this will save you from trying to keep track
of that (although, when I was thinking about this, one solution for doing
that would be to create a soft link to point to last file you copied in the
previous invocation).

You will need to have a .rhosts file set up on the other box to use rdist.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Recovery Scenarios

[Stephen Lee]

-Original Message-
Could you please suggest me how to corrupt a data file, for testing
recovery.
--

How corrupt do you want the file to be?

vi the file?
copy /usr/bin/ksh on top of the file.  That ought to corrupt it real good!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: RMAN Reporting?

[Stephen Lee]

Perhaps looking at the last update time on the log files?
And I assume you know what time the backup started ... ?

 Is there no way to produce a report from the RMAN
 views/tables that lists the date and duration of the
 backups for each database?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: imp table by table

[Stephen Lee]

Most likely, you will have to run the imports to get the data and the
primary keys.  Then run them again with ignore=y and rows=n to get the
foreign keys.

  
 My problem is with referential
 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: trapping errors from assignment of SQL*Plus Input Variables

[Stephen Lee]

You can define your own exceptions in the declare section, then RAISE that
exception.

 -Original Message-
 
 I want to trap the case where either no value for i_runcr is 
 specified at
 runtime (and thus the assignment should be NULL) or a 
 non-numeric character
 is specified (e.g., a letter).
 
 I had hoped the WHEN OTHERS exception would handle it but it does not.
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: archiving redo logs

[Stephen Lee]

Oh yeah.  I forgot to say, if you create a script with a password in it, be
sure to change the permissions so nobody but you can read it.  For example
chmod 700 (or 500) script_name
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: archiving redo logs

[Stephen Lee]

If security policy allows, and you don't have any religious convictions
against doing it, you can put a .rhosts file in the home directory of the
target user/box that will allow you to use rcp on the source box.  Be sure
to set the permissions to 400 after creating it.

If you can't do this, another option is to use ftp.  You can do something
like:

- go.ksh ---

#!/usr/bin/ksh

ftp -n -XXX
   open 123.123.123.123
   user oracle the_password
   cd /yada/yada/yada
   mput *.extension
   bye
XXX

---

You can also investigate using a .netrc file in the home directory on the
source box.


-Original Message-

If UNIX script is the only option, I appreciate if you can share it here.

-
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DB corruption question

[Stephen Lee]

Is it possible that the data files from the first database were copied to
the second, but the control files did not get copied?

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, December 05, 2002 5:05 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: DB corruption question
 
 
 These errors are from the second database. It's normal to get them.
 I do not think there is any corruptions.
 
 As long the first one is running without errors then do not worry.
 
 To make sure try to restart the database.
 
 Regards,
 
 Waleed
  Try, recreate the controlfile
- Original Message - 
From: Nick Wagner 
To: Multiple recipients of list ORACLE-L 
Sent: Wednesday, December 04, 2002 10:09 PM
Subject: DB corruption question
  
  
  
With Oracle 8.1.7, Solaris 8 OS.  
  
I have a shared storage device for storing all my 
 datafiles, control files, 
  redo logs, archive logs, etc..  everything except for the 
 ORACLE_HOME and Oracle 
  binaries.  
  
If I have the file system and database mounted to one 
 machine, and have a 
  fully open, available database running.  What happens if 
 someone else tries to 
  mount the same files to another machine and start up the 
 same database on it. 
  (No OPS or RAC involved)
  
I get the following error on the on the second machine...
  
  
SVRMGR ORACLE instance started.
Total System Global Area 272359584 bytes
Fixed Size 73888 bytes
Variable Size 88678400 bytes
Database Buffers 183427072 bytes
Redo Buffers 180224 bytes
Database mounted.
SVRMGR ORA-00283: recovery session canceled due to errors
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf'
ORA-01207: file is more recent than controlfile - old controlfile
SVRMGR alter database open
*
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf'
ORA-01207: file is more recent than controlfile - old controlfile
SVRMGR Server Manager complete.
EXITING 1
Unable to start Oracle instance
  
Will this corrupt the database?  Will it harm/corrupt the 
 original instance?   
  What happens if someone tries to recover it at this point?  
 Does it make a 
  difference whether its a RAW or cooked file system?
  
Any help is appreciated! 
  
Nick
  
  
  
  
  
 -- 
 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).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: To_Number

[Stephen Lee]

When somebody complains that, when they do an order by and get that 100 is
less than 2, now you know what to tell them  Because.  (As you might
guess, you're not the first to see this.)

-Original Message-
Sent: Thursday, December 05, 2002 7:29 PM
To: Multiple recipients of list ORACLE-L


Since we don't have that many 3rd party software packages I did make the
mistake of asking 'Why??' and received 'Because!' so I too am trying to jump
in and 'fix it'.  As I responded to another email earlier, the RTrim worked
because there were spaces after the amount which was causing the problem.
The only problem now is I have one record (so far) that has a unit cost that
looks like any other unit cost, yet I receive 'invalid number' for it.  The
only thing I can figure is that there must be an unprintable character in
the field that I cannot see and rtrim is not deleting since it isn't a
space.
Laura 


-Original Message- 
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 05, 2002 5:34 PM 
To: Multiple recipients of list ORACLE-L 


Rachel, 
We have two Third Party apps here for Finance and Student Information that 
do ridiculous stuff like this so often, I just immediately jumped into fix 
it mode without even questioning.  Don't even ask why is our motto.; 
-) 
Jack C. Applewhite 
Database Administrator 
Austin Independent School District 
Austin, Texas 
512.414.9715 (wk) 
512.935.5929 (pager) 
[EMAIL PROTECTED] 



 

Rachel

Carmichael   To: Multiple recipients of list
ORACLE-L   
wisernet100@Y[EMAIL PROTECTED]

AHOO.COMcc:

Sent by: Subject: Re: To_Number

[EMAIL PROTECTED]

om

 

 

12/05/2002

03:49 PM

Please respond

to ORACLE-L

 

 



Am I the only one wondering why an obviously numeric field 
(unit_cost???) is being stored as varchar? 
--- [EMAIL PROTECTED] wrote: 
 
 Laura, 
 
 Are those really zeros in $34,000.05 or are they letter Os?  If so 
 use 
 Replace.  (Beware of letter l being used instead of numeral 1 as 
 well.) 
 
 Any leading or trailing spaces?  If so use Trim(unit_cost). 
 
 Just a couple of quick suggestions. 
 
 Jack C. Applewhite 
 
 
Burton, Laura 
 
 I have a table which contains a Unit_Cost varchar2(16) which contains 
 $34,000.05.  I can enter select 
 to_number('$34,990.08','$999,999,999.99') 
 from dual; and the results is 34990.08.  However when I enter select 
 to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-01722: 
 invalid number. 
 
 Is there any other way to do this?  I am trying to add a varchar2 
 field 
 that contains $ and commas.  I thought the to_number function would 
 convert 
 the data to a number field. 
 
 Thanks, 
 
 Laura 



-- 
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). 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Implementing Continuous Managed Recovery on a Standby Databas

[Stephen Lee]

It's surprising you could do this since, as far as I know, if you start a
background process in ksh then try to exit the shell, you get prompted that
you have running jobs; if you type exit again, the jobs are killed.  

Two things I do are:

Instead of running nohup directly, run
sh -c /bin/nohup your_command 

or

echo command (including any redirects, if needed) | at now


 -Original Message-
 From: Orr, Steve [mailto:[EMAIL PROTECTED]]
 Sent: Friday, December 06, 2002 11:29 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Implementing Continuous Managed Recovery on a 
 Standby Database
 
 
 Problem: How to keep a standby database in continuous managed recovery
 without having to maintain an open terminal session. (Version 8.1.7.2)
 
 When you execute the following...
 -- 
 SQL RECOVER MANAGED STANDBY DATABASE;
 -- 
 ...SQL*Plus does not return a prompt and the database is in continuous
 recovery BUT... as soon as you exit the session, recovery 
 discontiues and
 the logs are nolonger automagically applied. No problem, I 
 said, I'll
 just wrap it in a shell script and launch it in the 
 background. Doesn't
 work and it appears SQL*Plus is a misbehaving process. (Linux)
 
 So then I tried nohup:
 -- 
 $ nohup sqlplus / as sysdba @managed_recov.sql  
 [1] 23412 
 $ nohup: appending output to 'nohup.out' 
 [1]+ Exit 127 nohup sqlplus / as sysdba @managed_recov.sql 
 -- 
 The managed_recov.sql script contains this one line: 
 RECOVER MANAGED STANDBY DATABASE; 
 This works but it does not persist as a background process- 
 it terminates
 when I hit enter or leave the terminal session. I think it terminates
 because SQL*Plus is misbehaving. What do you think? 
 
 So with a little help from a *nix geek I did this...
 -- 
 sqlplus / as sysdba @managed_recov.sql /dev/null standby.log 
 -- 
 ...presto chango, it works- standard I/O is OK and running in the
 background. The standby DB is in continuous recovery and I 
 can shutdown my
 PC and go home and managed recovery just keeps on running. Cool.
 
 Is there a better way to do this? I submitted a TAR but OWS 
 hasn't been any
 help. Doesn't it seem lame that Oracle gives the RECOVER 
 MANAGED STANDBY
 DATABASE command but is unable to provide a means to 
 implement it without
 requiring the terminal session to remain open?
 
 
 Whining in Bozeman, Montana
 Steve Orr
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Orr, Steve
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Something that might be of use

[Stephen Lee]

 -Original Message-
 it has GUI interface and a lot finer control over the 


GUI's are evil.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Archived logs backup

[Stephen Lee]

-Original Message-
Within script how do I skip archived log file that is being written by
oracle?
-

I took another look at this and figured out what you were really asking.
The commands: ls -1rt or ls -1t will list the files in the directory and
sort according to time.  Note that the 1 is a one.  This will allow you to
see the most recent files.  If you would like to keep the two most recent
then something like:

#!/bin/ksh

COUNT=0
for i in `ls -1t *.dbf`; do
   COUNT=$(( $COUNT + 1 ))
   if [ $COUNT -gt 2 ]; then
  SEND $i TO TAPE
  if [ $? -ne 0 ]; then
 print SOMETHING BROKE
  else
 rm $i
 (or maybe safer to move it to a pre-delete filesystem, then delete
it later)
  fi
   fi
done
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Archived logs backup

[Stephen Lee]

-Original Message-
I want to write unix script to automate archved logs backup to tape ...
After hot backup of data files is completed...

Within script how do I skip archived log file that is being written by
oracle?
---

Here is my crontab entry (paste it back together).  The 70 means start a
backup if the archive directory hits 70% full.  This does NOT run around the
time when the normal backup is running.

0,30 1-18 * * * /oracle/app/oracle/admin/dbascripts/rman/check_arch_dir.ksh
70  /oracle/app/oracle/admin/dbascripts/rman/arch_debug 21

Here is my script (which calls the backup script)

- Snip --
#!/bin/ksh

PERCENT1=`/usr/bin/df -k /z01 | /usr/bin/nawk 'NR == 2 {print
substr($5,1,match($5,%)-1)}'`
PERCENT2=`/usr/bin/df -k /z02 | /usr/bin/nawk 'NR == 2 {print
substr($5,1,match($5,%)-1)}'`
PERCENT3=`/usr/bin/df -k /z03 | /usr/bin/nawk 'NR == 2 {print
substr($5,1,match($5,%)-1)}'`
PERCENT4=`/usr/bin/df -k /z04 | /usr/bin/nawk 'NR == 2 {print
substr($5,1,match($5,%)-1)}'`

PERCENT1=`echo $PERCENT1 | /usr/bin/sed 's/[^0-9]*//g'`
PERCENT2=`echo $PERCENT2 | /usr/bin/sed 's/[^0-9]*//g'`
PERCENT3=`echo $PERCENT3 | /usr/bin/sed 's/[^0-9]*//g'`
PERCENT4=`echo $PERCENT4 | /usr/bin/sed 's/[^0-9]*//g'`

if [ -z $PERCENT1 ]; then PERCENT1=0; fi
if [ -z $PERCENT2 ]; then PERCENT2=0; fi
if [ -z $PERCENT3 ]; then PERCENT3=0; fi
if [ -z $PERCENT4 ]; then PERCENT4=0; fi

if [ $PERCENT1 -gt $PERCENT2 ]; then
   PERCENT=$PERCENT1
else
   PERCENT=$PERCENT2
fi

if [ $PERCENT3 -gt $PERCENT ]; then
   PERCENT=$PERCENT3
fi

if [ $PERCENT4 -gt $PERCENT ]; then
   PERCENT=$PERCENT4
fi

THRESHOLD=$1
if [ -z $THRESHOLD ]; then
   THRESHOLD=50
fi
if [ $PERCENT -gt $THRESHOLD ]; then
   /oracle/app/oracle/admin/dbascripts/rman/backup.ksh ARCH ALL 
/oracle/app/oracle/admin/dbascripts/rman/debug 21
fi

exit 0
-- Snip --

The backup.ksh script is a 1559 line big boy I wrote to automate a lot of
stuff and do a lot checking and verifying.  I don't think you want to see
it.  One thing that might be of interest is a C (not PERL!) frontend I wrote
to make SUID oracle so a non-oracle operator can start a backup by hand if
needed without us opening the permissions on any of our security-sensitive
areas.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DB corruption question

[Stephen Lee]

-Original Message-
ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf'
ORA-01207: file is more recent than controlfile - old controlfile

Will this corrupt the database?  Will it harm/corrupt the original instance?
What happens if someone tries to recover it at this point?  Does it make a
difference whether its a RAW or cooked file system?
---

I don't think it will corrupt anything, but you won't be able to open the
database.  Apparently somebody smoked at least one control file and restored
it from a backup.  So now the control file(s) is/are behind the data file.
If only one control file was smoked, and you have another that is up to
date, replace the smoked one with a copy of the good one.

If you can't do that (i.e. ALL your control files are old) AND if the
database was shut down clean (why do I have the feeling it wasn't?), then
move what control file you have off somewhere else; and see if you can
recreate a new control file; then recover the database using backup control
file.  This will require an open resetlogs (You DO have a good backup of
what you currently have right?).

If the database was not shut down clean and you only have old control files,
then I think you have no choice but to restore the entire database back to
your last backup.  If you are in this situation, you still might try
recreating the contol files.  If the database had no activity prior to the
disruption, you might get lucky and have all your headers up to date even
without a clean shutdown.  As long as you are planning a complete restore, I
don't think it would hurt to give it a try.

It's time to get out that Oracle backup and restore manual.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Something that might be of use

[Stephen Lee]

 -Original Message-
  GUI's are evil.
 
 Sure, blinking LEDs are much more better.

Especially when the admins are epileptic.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Something that might be of use

[Stephen Lee]

 -Original Message-
 I saw an article last night, apparently Sun is planning to 
 make Gnome its
 gui of choice on solaris.


But REAL Unix guys will still use fvwm2.  And don't confuse GUI with a
window manager; i.e. merely a desktop where one does work from a collection
of xterm command line interfaces.

(Pick up mouse: Computer  Oh Computer?  A keyboard?  How quaint!)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Are Oracle courses required for Oracle Certification now?

[Stephen Lee]

 -Original Message- 
 ( background sound of DBA frantically riffling through
 stacks of papers on his desk)
--

You've obviously not come up to date on the most reliable of storage
methods: A refrigerator covered with magnets.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:

[Stephen Lee]

I got to thinking a little more about this.

If you have an oraInventory directory under your product directory, I think
you need to back that one up too ... at least it wouldn't hurt.


-Original Message-
Sent: Wednesday, December 04, 2002 12:14 PM
To: Multiple recipients of list ORACLE-L


I believe that is the easiest/cleanest way to restore from patches esp. when
you don't know what those patches contain.  
-Original Message- 
Sent: Tuesday, December 03, 2002 2:21 PM 
To: Multiple recipients of list ORACLE-L 


Gurus, 
I was just given a project to maintain a Computerized Maintenance 
Management System.  When I asked the companies support staff how to roll 
back patches in the backend Oracle Database (Ver. 8174), they said that 
there was no way to do this.  I'm guessing I could use logminer just incase 
a patch doesn't work.  Would this be a good solution, or are there other 
(better) ways of safeguarding myself when it comes to patching?  Obviously, 
I will be applying the patches to a test instance first, but I don't want 
to have to go back to restore from a backup if the patch causes unexpected 
issues. 
TIA! 


** 
Scott Stefick 
UNIX Systems Administrator 
Oracle Certified Professional DBA 
Wm. Rainey Harper College 
847.925.6130 
** 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Scott Stefick 
  INET: [EMAIL PROTECTED] 
Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Something that might be of use

[Stephen Lee]

We often need to refresh test and development databases with exports that
have extent sizing a lot bigger that what we want.  In test and ESPECIALLY
dev, space and file system availability often require us to just  get
something working without regard for performance.  In these cases, extent
sizing in the exports often prevents us from loading even a row-less import
into the test/dev database.  The following C program was written to deal
with those situations.  I have used it enough that I think I can go ahead
and toss it out to the world.  The program is functional but not necessarily
elegant.  Of course, no guarantees about anything are made.  If you make any
improvements, I would be most appreciative if you sent them.

== SNIP == SNIP == SNIP == SNIP == SNIP == SNIP
==

/***
** This was hastily written by Stephen Lee because we've  **
** been needing something like this real bad for a while. **
** If you leave the section that opens the files commented,   **
** then the syntax would be something like:   **
** modify_extents  dumpfile  modified_dump_file **
****
** Even though this has been tested against enough exports**
** that it seems to work OK, I do have some nagging doubts**
** about how universally compatible it is.  I do make some**
** assumptions about the text in an export dump file and  **
** about the size of a character in that file.**
****
** This program changes the INITIAL and NEXT extent size  **
** specification in the dump file to a fixed size.  You can   **
** edit this value in the program, prior to compiling it. **
****
** It is acknowledged that this is a rather bare-bones**
** program, but it needed to written in a hurry.  Enhancement **
** of the program is left as an exercise for the reader.  **
***/

#include sys/types.h
#include sys/stat.h
#include sys/param.h
#include sys/signal.h
#include sys/fault.h
#include sys/syscall.h
#include sys/procfs.h
#include dirent.h
#include fcntl.h
#include stdio.h
#include stdlib.h
#include string.h
#include unistd.h
#include pwd.h
#include math.h
#include time.h
#include termios.h
#include signal.h
#include ctype.h
#include netdb.h
/** Include the kitchen sink too **/

/* BEGIN MAIN **/

int main (int argc, char **argv, char **envp) {

int in, out, bytes_read, diddle, match = 0, create = 0;
char read_buf[57344], write_buf[65536], diddler;

// Note that the following strings contain a space. That is
important.
char *s0 = CREATE ;
char *s1 = ALTER ;
char *s8 = INITIAL ;
char *s9 = NEXT ;
int s0_len = strlen(s0);
int s1_len = strlen(s1);
int s8_len = strlen(s8);
int s9_len = strlen(s9);
int i, j0, j1, j8, j9, x, skip = 0;

/***

** Un-comment this section and use the open statements if you want to
hard-code
** the paths, or if you want to use something like argv[1] and argv[2].

if( (in = open(/export/oracle/admin/FTLP/exp/test.dmp, O_RDONLY))
 0 ) {
printf(\nFailed to open input file.\n);
return 1;
}

if( (out = open(/export/oracle/admin/FTLP/exp/modified.dmp,
O_RDWR|O_CREAT|O_TRUNC))  0 ) {
printf(\nFailed to open output file.\n);
return 1;
}
fchmod(out, 0600);


/

/* Use the dup commands if you want to use command-line redirection as
in:
 * program_name  input_file  output_file ***/
in = dup(0);
out = dup(1);

/**
 ** The following loop reads bytes from the input file and copies them to
the output file.
 ** While it is doing this, it is looking for matches to the strings defined
in s0, s1, etc.
 ** S0 and s1 define when we have found the beginning of a CREATE or ALTER
command and
 ** should start looking for the strings INITIAL and NEXT.  When those
strings are found,
 ** and we verify that they are followed by a number, then the numeric data
is replaced by
 ** the new characters.  Then any following numeric data is skipped until we
get to the
 ** next space.  We write the output buffer every time we read a new input
buffer.
 ** We continue this until the entire input file has been read.
 ** The reason for the CREATE and ALTER searches is to throw in a quart or
two of paranoia.
 ** This requires that both strings CREATE/ALTER and INITIAL/NEXT to be
present.  I suppose
 ** there some chance that we could have these strings present

RE:

[Stephen Lee]

On Unix, you can back up the installation directory.  If you need to go back
to the old version, put the old directory back.  You can use tape, tar,
cpio, cp, etc. to do this.

Example 1
cd /path/here/product
tar cvf /path/elsewhere/old817.tar 8.1.7 (assuming 8.1.7 is the directory to
back up)
If you want, you can compress the resulting tar file.

Example 2
cd /path/here/product/8.1.7
find . -print | cpio -pvmud /path/elsewhere/8.1.7

If you find that you need to go back to the old version, just restore your
backup.


 -Original Message-
 From: Scott Stefick [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, December 03, 2002 1:21 PM
 To: Multiple recipients of list ORACLE-L
 Subject: 
 
 
 Gurus,
 
 I was just given a project to maintain a Computerized Maintenance 
 Management System.  When I asked the companies support staff 
 how to roll 
 back patches in the backend Oracle Database (Ver. 8174), they 
 said that 
 there was no way to do this.  I'm guessing I could use 
 logminer just incase 
 a patch doesn't work.  Would this be a good solution, or are 
 there other 
 (better) ways of safeguarding myself when it comes to 
 patching?  Obviously, 
 I will be applying the patches to a test instance first, but 
 I don't want 
 to have to go back to restore from a backup if the patch 
 causes unexpected 
 issues.
 
 TIA!
 
 
 **
 Scott Stefick
 UNIX Systems Administrator
 Oracle Certified Professional DBA
 Wm. Rainey Harper College
 847.925.6130
 **
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Scott Stefick
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

 -Original Message-
 We hope by
 eliminating redo log multiplex, but with OS mirroring we 
 can speed up this loading process.

--

We deal with this by:

1.  Hardware mirroring of archives.
2.  Archives go to device on which no other I/O is present and, if there is
a difference in the speed of devices in the system (for example 7200 rpm
drives and 1 rpm drives), the archives get the faster drives.
3.  Alternating online redo between different devices, the theory being that
when a log switch occurs then the log being archived will be on a device
that is not being written to, so (we hope) the reads from that device will
be faster.

Even after making the archiving as fast as possible, you still might be
required to have a very large amount of online redo available in order to
handle the backlog built up during peak times.  We have found that archiving
is so much slower than online redo writing in a case like this, that we can
Oracle multiplex online redo to hardware RAID (redundant redundancy) and the
archiving will still be the slow point.

I wouldn't worry about the fault tolerance aspect of online redo mirroring,
since whatever would blow away both sides of a hardware or OS mirror would
also blow away both sides of Oracle multiplexing.  However, my experience
has shown that, as far as any debate on how one mirrors online redo the
point is moot.  My experience is that, in this scenario, the archiving is
what will snag things.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OSF11 in TRU64 Unix

[Stephen Lee]

-Original Message-
I am about to install Oracle 9i release 2 on TRU64 Unix. In one
of the pre-requisites, Oracle suggests to have OSF11 installed on the
Operating System.
--

For what it's worth, it installs fine on this:

(NOTHING)/oracle/app/oracle uname -a
OSF1 box.domain.com V5.1 732 alpha
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

 -Original Message-
 We do redo log file multiplexing to protect against fat 
 fingers and other odd-ball stuff that have caused problems 
 for an entire file system.  Call it an unreliable OS, poor SA 
 (ok, maybe even DBA) practices

I do it because it's a CYA thing of doing it by the book.  I've listened to
a lot of debates about database things and been amazed at the reasoning
behind why people do what they do.  I've lost count of how many debates I've
heard about extent sizes and numbers of extents, the majority of it pure
superstition.  In the end, no matter how scientific or superstitious the
reasoning, CYA trumps all.  So that's why I do it.  But, in fact, this whole
thing about corrupt blocks is flawed reasoning.  If an OS cannot do disk
writes in an absolutely reliable way, then the OS is unusable.  The bad
writes will occur throughout the system.  This includes when your logs get
archived and writes to data files.  Put those two together and what do you
get?

Actually, there is one advantage to hardware mirroring of archives.  On
Oracle duplexed archives, my experience is that it is inevitable that you
will have one destination fill up while the other one doesn't.  In which
case Oracle quietly quits using the one destination even after the files are
removed during a backup.  I wrote a script to monitor when Oracle has
stopped duplexing archived logs for those where we don't have hardware
mirroring.

I was amazed at the non-security that seems to be rampant out there, with
mischievous people running around deleting files.  I kept reading about it
and thinking you've got to be kidding.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

 -Original Message-
 have you NEVER accidentally, at 3AM, after having been woken from a
 sound sleep to a crisis that needs to be fixed RIGHT NOW,  
 made a typo?
 

Actually no.  But we usually script our actions and test the scripts prior
to doing anything in production.  As a sys admin, I've restored enough
casualties of the rm -rf * command to be rather careful about it myself.

 Um, I have.

I was wondering if anyone had.  But I could turn this around too and give an
example of when duplexing the redos failed to save me.  One so-called patch
that Compaq released for Tru64 actually caused disk writes to be unreliable
(OH MY GOD!!).  And we wound up with a G.D. mess in spite of the redos being
duplexed all nice and official.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 OS level security

[Stephen Lee]

My experience with NT security in an environment of any significant size is
that it is a hopeless situation.  In addition to dealing with admins on the
box with the database, it seems that there is always an application support
person or two that needs to administrator privs on that box too.  Then there
are the people that support multiple boxes, so they get domain admin privs.

I set the privs on Oracle files so that any administrator would at least
have to take ownership of the files  in order to delete them.  Following
strict file and directory naming conventions and teaching everyone to
recognize sacred file name patterns helps.  We even had certain drive
letters throughout the domain that were reserved for Oracle stuff so that
people would know which drive letters were danger zones.

With all this in place, the only problems we experienced were due to the
flakey disk clustering that the admins were using.  File systems (or the NT
equivalent thereof) had a habit of getting unmounted, and Oracle seems to
take offense at files suddenly disappearing.

I wasn't all that worried about people going in and deleting files.  My
biggest worry was that we automate a lot of jobs and a lot of monitoring
with scripts.  Some of these require information, (such as passwords) be put
into files; files that I can't protect on NT.  I never had a big problem
with admins being administrator (or root on Unix), but on NT it seems that
there are always people from development, or people from some department up
on 10th floor, that need administrator on the box too in order to support
some app.  So now you have developers and people you don't even know about
that, if they chose to do so, can go nosing around in your stuff.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

 -Original Message-
 Sorry if you took offense at some attempted humor.
--
No offense taken here.  I've always worked in large environments where there
were multiple DBA's, sys admins, developers, and testers.  One cannot be
easily offended and survive in these environments.  You have your debates;
break a few chairs in the ensuing fight; then go out for lunch.  It's all a
nice break from the daily routine.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: is it possible ?

[Stephen Lee]

 -Original Message-
 Is it possible For 2 Databases to be Brought up on the SAME 
 machine with the SAME ORACLE_SID 
 from Different ORACLE_HOMEs ?
 
 If so , how ?

It would seem so.  Listener setup might be a bit dicey.  I might have to try
this.  It seems that as long as you had separate environments, it should
work ... we're talking Unix here right?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 8.1.6 Installation error

[Stephen Lee]

 -Original Message-
 I was under impression that you can install a lower version 
 of Oracle in the same box.

Did you use a different ORACLE_HOME?  I sounds like your oracle home is the
same.  If so, the install is probably finding the existing inventory file.
With completely a different installation location, the installer would not
find the other inventory file and, consequently, have no idea what was on
the box in the other location.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: patches

[Stephen Lee]

-Original Message-
I am wondering how your sites handle patching production servers.


We make a copy of the existing product directory structure using tar
(everyone else) or cpio (me) before installing the patch.

For example:
cd /path/path/product/8.1.7
find . -print | cpio -pvmud /some/backup/directory
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

If I may offer another view 

 -Original Message-
 Having multiple redo log members has its advantages. The 
 archiver process 'knows' these multiple members and it will 
 optimize the archiving process,

Is there any supporting documentation about this optimizing?  Are you
saying that the makers of hardware-based and software-based RAID have not
optimized their RAIDing?  If I were a betting man, I would bet that a
hardware device can do mirrored writes faster than Oracle.

 but it does not know about 
 the mirrored copies of these logs.

Know?  What does it need to know?  Mirroring is mirroring.  A mirrored
copy either exists, or it doesn't.  Knowing about it has no effect on the
existence of the copy.  Computer operations aren't based on faith (although
there are many times we are tempted to question that).

 The other important thing 
 to know is that Oracle issues a separate write for these log 
 members

And this improves performance?

 and in an unlikely event a corrupted write will be 
 restricted to just the affected member.  Such corruption will 
 affect all the mirrored copies. 

Two things:
1.  This is pure speculation.
2.  If your OS can't do reliable disk writes, then it's time to get a new
OS.  A database consists of more than just redo logs.  It also has pesky
little things like data files.  Should we have Oracle mirror those too
rather than rely on RAIDing for fault tolerance?  Why would we expect the OS
to reliably write data files and detect hardware errors when it can't
reliably maintain redo logs?

Pending further evidence to the contrary, I'll take mirroring external to
Oracle as the better choice.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 9i installation - Basic Qs

[Stephen Lee]

I think the problem is the client.  Does it have an xauth setting somewhere?

 -Original Message-
 Oracle 9i installation on Solaris being attempted 
 # xhost +
 Message - unable to open display :  
 export DISPLAY=PC Client IP address:0.0
 # xhost +
 Xlib : connection to client refused PC Client IP Address 
 Xlib : cannot set display to PC Client IP Address
 NOTE - Installation being initiated from a laptop using 
 Exceed Hummingbird
 software to simulate Xwindows Console 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

 of reasoning is to extend
it to its logical conclusion.  Since, last time I checked, Oracle supported
five-way mirroring, am I to assume that you do this?  Probably not.  Why
not?  After all, those redo log files are most sacred and one is sure to
suffer hell-fire and damnation if one should be corrupted which,
apparently, must be happening an awful lot to somebody out there.  And we
can hardware mirror the Oracle mirrors.  So why not recommend that we just
go mirror crazy?

While the scenarios of gloom and doom that have been painted by some seem to
be credible, I've have yet to witness, in my years of personal experience as
a sys admin and a database admin the unreliability that some claim to exist.
That being the case, I must go with the arrangement that I think offers
fault tolerance with the best performance.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

 -Original Message-
 Stephen,
   Nothing is gained by personal attacks in this forum. 

Please enlighten me.  Exactly what personal attack was made?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: LGWR using lots of CPU time, low CPU usage

[Stephen Lee]

I don't think changing the logmembers will do much good

I agree.


 4 groups, they are on the local drive.

BOOM!!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: SQL tuning help

[Stephen Lee]

 
 This week it began to hang and I can't figure out why.

The first thing I would check are locks.  The statement is trying to update
a table.  Try something like the following while the statement appears to be
hung.  These are two different ways (and certainly not the only ways) of
checking for lockers and waiters.



SELECT substr(s1.username,1,12)WAITING User,
   substr(s1.osuser,1,8)OS User,
   substr(to_char(w.session_id),1,5)Sid,
   P1.spid  PID,
   substr(s2.username,1,12)HOLDING User,
   substr(s2.osuser,1,8)OS User,
   substr(to_char(h.session_id),1,5)Sid,
   P2.spid  PID
FROM   sys.v_$process P1,   sys.v_$process P2,
   sys.v_$session S1,   sys.v_$session S2,
   sys.dba_lock w, sys.dba_lock h
WHERE  h.mode_held= 'None'
ANDh.mode_held= 'Null'
ANDw.mode_requested  != 'None'
ANDw.lock_type (+)= h.lock_type
ANDw.lock_id1  (+)= h.lock_id1
ANDw.lock_id2  (+)= h.lock_id2
ANDw.session_id   = S1.sid  (+)
ANDh.session_id   = S2.sid  (+)
ANDS1.paddr   = P1.addr (+)
ANDS2.paddr   = P2.addr (+)
/

-


set lines 150
set pages 600
col mode_held for a12
col mode_requested for a12

select /*+ all_rows */ a.osuser waiter, nvl(b.osuser,'NOBODY') blocker,
w.lock_type, h.mode_held, w.mode_requested
-- w.lock_id1, w.lock_id2
from dba_locks w, dba_locks h, v$session a, v$session b
where h.blocking_others = 'Blocking' and h.mode_held != 'None'
and h.mode_held != 'Null' and w.mode_requested != 'None' and w.lock_type =
h.lock_type
and w.lock_id1 = h.lock_id1 and w.lock_id2 = h.lock_id2
and w.session_id in (select sid from v$session where last_call_et  100 and
sid  10 and osuser is not null)
and w.session_id = a.sid and h.session_id = b.sid;

--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

 -Original Message-
 Of course, you'll need Tom Kyte's binary conversion program 
 here to execute this very weak proof:

Yeah, well this didn't come from Stephen Hawking.  And let's not forget the
part about in the natural integers.  Homey didn't take a bunch of 5000 and
6000 level math courses and come away entirely untrained.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: LGWR using lots of CPU time, low CPU usage

[Stephen Lee]

H. I got to thinking about a previous reply which was while doing
something else:

I don't think changing the logmembers will do much good
I agree.

 4 groups, they are on the local drive.
BOOM!!

Then got to thinking  This is not right at all.  I think I was making a
subconscious interpretation based on the context of your usage of the terms.
If your groups look like
GROUP1
redo_01a.dbf_or_log
redo_01b.dbf_or_log
redo_01c.dbf_or_log

GROUP2
redo_02a.dbf_or_log
redo_02b.dbf_or_log
redo_02c.dbf_or_log

etc.

Then, this all this extra writing will definitely incur overhead.

Now, the part about it all being on the local drive: That still is BOOM!!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Imp of all users tables

[Stephen Lee]

-Original Message-

imp system/pwd fromuser=david touser=david tables=a,b,c,... ignore=y
file=expdat.dmp

How can I do all (and not a full=y) of the 544 tables for one user at one
time?


Leave out the tables=.  Then it will default to all the tables of that
user.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

-Original Message
I believe the forgone conclusion you are talking about is that mirroring
outside of Oracle MAY result in data loss  MAY is a very important word.
The multiplexing of redo logs across multiple disks and controllers is a
simple way protect your database from potential failure.

Your position appears to be that hardware mirroring, software mirroring,
RAID hardware, and the controllers feeding them all are infallible.


For those of you who are averse to the acquisition of knowledge through
muscular debate, I trust you know where the DELETE button is.  For the rest
of you 

As far as MAY goes, we can take that to any ridiculous extreme you wish to
take it.  The issue is NOT: The multiplexing of redo logs across multiple
disks and controllers.  The issue is HOW one does this.  Let's get this
back to my original post.  I was responding to the implication that there is
some danger in using hardware mirroring such than one should not use it.

As one who HAS ACTUALLY DONE BOTH and ACTUALLY USES BOTH and HAVE DONE SO
FOR A LONG TIME (have you?) with both DATABASE and NON-DATABASE files, I
felt it necessary to state that notwithstanding whatever armchair academia
is floating around on the topic, I have NEVER experienced a loss with
hardware mirroring;  And have never seen a  reason to imply that the
practice has any inherent dangers.  Does that mean that a problem can never
occur?  Certainly not.  Have we ever had a controller or hard drive fail?
Yes, indeed.  But, have we ever lost a database as a result?  Nope.

Let me turn things around on you and look at Oracle multiplexing.  Has
anyone ever lost a database who was doing Oracle multiplexing?  Sure.  Well
gosh!  I thought this was supposed to keep this from happening.  Why didn't
it?

The previous posts seemed to be totally preoccupied with this apparently
ubiquitous phenomenon of corrupt blocks.  Let me ask you this: How often
does it occur that you run your rman backup, and it detects bad blocks that
your OS missed or Oracle missed and failed to report?  I'm just curious to
know how prevalent these things are.

Another thing that was stated by the original response was that there was
some performance benefit to Oracle doing the multiplexing -- that Oracle
somehow optimizes the process.  In the case of software mirroring by the
OS, this is a dubious statement.  In the case of hardware mirroring, the
statement is patently false and is the main reason why one would use
hardware mirroring -- because performance demands on the system require it.

Let's take this performance thing a little further.  As we have read in many
posts to the list, we even do such reckless and unthinkable things (at least
it was a few years ago) as allow storage arrays to cache our writes ... even
our redo writes (lions, tigers, and bears, oh my!) because performance
demands require it.  Now, you can peruse the database literature and find an
abundance of text on what a hideously EVIIL practice this is.  But we do
it anyway.  And, saints preserve us!  We don't have a landscape littered
with lost databases.

As one who has never lost a file of any kind to hardware or software
mirroring (well ... except for the early releases of Veritas on the Motorola
88K system where Veritas was a complete abortion and worse than nothing at
all) I am going to go with my own considerable experience on the subject.
If you wish to quote chapter and verse from this doc or that doc, that's
great.  But I'm going to go with what I have actually seen tempered by any
tangible, objective, hard evidence I come across.

Now for those who are into this worst scenario thing let me ask you: What
if I put your storage array between a 30HP air conditioning blower moter and
a spot welder, and run a couple of paint shakers on top of the array to
boot.  What will your vaunted Oracle multiplexing do for you then?  Huh?
Well, smarty pants, I'm waiting!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: redo log file setup with mirrored drives

[Stephen Lee]

I suppose I should come clean on this deal and admit that we do indeed have
Oracle duplex the redo files.  The only time we would not do this is if some
user with sufficient bureaucratic power has some suckwad app and was
demanding that everything be done to bump up performance.  If it comes to
that, we'll do it and not lose any sleep over it.  Even though we have
Oracle duplexing, we still have had it happen that some storage array
maintenance person went in and managed to hose up both sides of the duplex.
Of course, this doesn't result in the loss of the database, but rather the
loss of some data.  But wasn't it fun debate.

What I found interesting was that nobody brought up what to do about the
archived logs -- how much mirroring is enough and how long to wait before
shoving them off onto tape.  Now, the loss of these babies can get you into
deep doodoo.  But, here again, we must sometimes make compromises for the
sake of a rotten application and overtaxed hardware.  At our shop here, we
are forced to rely on hardware mirroring of archives.  We have no choice.

You just try to get as many people to sign off on the setup as you can.

None of this changes the truth of anything I wrote.  I have found hardware
and software mirroring to be extremely reliable.  I have never lost a file
to it, and it has saved my butt many times.  At one place I worked, we
regularly tested yanking out power cords, I/O cables, storage array drawers,
anything we could think of, while the database and application were running
full blast.  It never failed once (except for early Veritas on Motorola 88K
which was a mess).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Problem doing RMAN backup of Clone?

[Stephen Lee]

You can change the DBID as mentioned in other messages.
(see metalink doc id 174625.1)

If you don't want to change the DBID, you can still backup the database
using RMAN; you just can't use the same schema in the same rman catalog
database as the original.

You can:
1. Use a different catalog database.
2. Use a different schema in the same catalog database (for example
rman_prod and rman_test schemas).
3. Don't use a catalog, and rely entirely on the control files as your
catalog.



 -Original Message-
 
 Someone has just told me you can't do an RMAN backup of a 
 clone because it has
 the same database id as the original.   Is this true or not?  
 If so, how to get
 around it?
 
---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: A way to restore a DB

[Stephen Lee]

From the rest of you message, I would say there is something wrong with the
hardware setup of your database.  If the setup is such that you can lose an
entire database of nearly 4 TB, then your backup/restore speed is the LEAST
of your problems.  You disk striping and mirroring should prevent the lose
of the database in the vent of a disk failure; I would even consider
mirroring across more than one storage array so that you can survive the
loss of an entire storage array.

If finances don't permit complete redundancy, the setup should be such that
you never lose more than fraction of the database (i.e. a datafile or two
... or three).  Then you only restore and recover the datafile(s) rather
than the entire database.  I can't imagine a setup where the loss of a disk,
or even a controller, would cause the COMPLETE loss of a 4TB database.

This whole thing looks very much like somebody screwed up and delete files.
I suspect that a trip to Hell would reveal the rm -rf * command sitting at
Satan's right hand.


 -Original Message-
 We are evaluating a strange way to recover a production DB.
 This is a 3.7 TB database,
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 do I calculate the Oracle's usage

[Stephen Lee]

  I'm trying to figure out how much of the srever's resources
  (CPU-wise) a database and the application 

You can try the following.  Substitute the name of the database for ABCD
in the awk command.  On a multi-cpu box, the sum can be more than %100.

ps -eo %cpu -o args | awk '$2 ~ /ABCD/ {sum = sum + $1}; END {print sum}'
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:

[Stephen Lee]

You obviously know how to check it.  Plain old egrep can parse the export
file for CREATE TABLE too.

It sounds like you might need to open up a commodity sized can of this stuff
on the guy.

http://www.squirtsplace.com/tackypics/wupass.html


 -Original Message-
 I can't convince this guy the table is
 not there.  What else can I do?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Password Generator...

[Stephen Lee]

-Original Message-
Does anyone know of products,procedures,etc that would generate a random
password for a user?

--

Bang on the computer keyboard with the palms of both hands and see what
comes out.
This random password generator has been around for a long time; and it's
free.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: AIX vs Solaris

[Stephen Lee]

The administration of Solaris has always been much more straightforward than
with AIX.  AIX maintains this internal database (sort of) about how things
are set up, so it doesn't take kindly to you doing stuff by hand.  AIX has
command-line commands (???) to do things, but they are usually very
complicated and require a prodigious memory.  The administration of a Plain
Jane Solaris setup can easily be done entirely by hand with the exception of
one thing -- printers.

Talk to a REAL Solaris admin and you will hear: GUI?!  We don't need no
stinkin' GUI!

Of course, the same thing could said about REAL Oracle admins.  But that
would be inflammatory.  So I didn't say it.


 -Original Message-
 
 the Solaris Admintool seems to have very little 
 functionality(create users
 and not much else). With SMIT on AIX you can do much, much 
 more. Does anyone
 use any other party tools for easier Solaris syatems admin? 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).