ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
use without relying too heavilly on my mathematical
background. I don't dare say I am confident of it though, I still remember
that 32.
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services
did ask about swap size in Tanel's case, our swap slice is 2GB we rarely
use more than 500MB of swap.
Steve McClure
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, September 29, 2003 7:35 AM
To: Multiple recipients of list ORACLE-L
Tanel:
How large is the swap file? For Oracle
://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
OK seems I must have fat fingered something when I typed in my dictionary
location in start_logmnr. Odd though I saw no errors.
-Original Message-
Steve McClure
Sent: Friday, September 19, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
OK my first usage of log miner seemed
I am
wondering what others think.
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
it an elevated postition.
Sorry for rambling on and on etc.
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
described
above.
Steve
McClure
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Niall
LitchfieldSent: Tuesday, September 16, 2003 1:40 PMTo:
Multiple recipients of list ORACLE-LSubject: RE: Dataguard
Benchmark
Just
to add to Mladen's
for the
education requirements is pretty darned nice. Not to mention the Solaris
system administrator certification, that self study guide just arrived the
other day, and the Veritas backup administrator certification stuff I got
the other day. This is getting to be like college.
Steve McClure
I will try to be there as well. Possibly two of us, Alec Macdonell who
lurks about this list as well.
Steve McClure
-Original Message-
John Kanagaraj
Sent: Wednesday, September 03, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Hi all,
We talked about this earlier and I wanted
being extra paranioid. I certainly wasn't aware my current directory was /,
but it was. Luckilly the previous ,always crafty, sysadm had the foresight
to place a file named -i in the directory. Really saved my bacon when I
was prompted for confirmation.
Steve McClure
--
Please see
this question. It is from the ask tom site. It worked perfectly, and the
use of to_date was brilliant and elegant. Seeing routines like that reminds
me of just how far I have to go to be good at what I do.
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE
THAT much money in practice.
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
exams, I read and accepted that NO
hints were available if you were using the RULE based optimizer. I guess I
need to fire up my test instance later today, and figure this out.
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL
Just completed the registration, and was wondering how much company I was
going to have there.
Who else has plans to attend?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
on the record
set, you will get an error indicating an invalid cursor.
Steve McClure
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
I prefer to create an inner block using BEGIN and END inside the loop. This
isolates
l it works. I will
just have to be content knowingas good as it isit could be better
yet.
Steve
McClure
that if they are gung ho regarding Linux, Sun now supports Linux on
their hardware.
I feel like I should have started this response Hello my name is Steve
McClure and I am a RAC on Linux doubter Really I have felt this way for a
long time. Maybe the time will come when I see it as a great idea
://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing
Ah much more reasonable. I can't believe I typed the word licensers -- I
am guessing licensees was what I was going for
Steve McClure
Oracle Collaboration Server (Suite?) is licensed per-mailbox user
$60 per user...lets see Oracle claims we have 80,000
users...(not including the infinite
think this was the first time I noted Jared's annoying habit of
being right
Steve McClure
-Original Message-
Waleed
Sent: Tuesday, June 03, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L
I've just discovered this, never thought if it was possible or not.
Just wanted to share
Just a
thought. Possibly to assist in recovery of the database box. If you
have a complete media failure on the DB host, you greatly simplify the recovery
process if your RMAN database is somewhere safe.
Steve
McClure
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
was really done, except I have to manually transfer all those
archived logs. I am just wondering what I missed.
Thanks,
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
. Of
course if you can't recover your standby it will have to be resynched as
well.
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
sessions. Sorry for the long tale, but I am hoping someone else out there
has run into this before. Our forms/reports configuration is way to generic
for us to be the first ones to hit this.
Thanks in advance,
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author
while the
sessions were active.
I am soliciting
actively for any Hints, Tips, or Ideas you may have,
Thanks,
Steve
McClure
ew deletes
throughout the database, so I can't see where that would be affecting any of our
tables let alonecontribute totying up the entire
database.
I do appreciate the
help, If you would like more specific answers please let me know and I will
respond "off list"
Th
through it to display the output via utl_file or somesuch. Actually
if you are familiar with perl you could use a similar algorithm, and the
resulting code would likely be cleaner.
Steve
McClure
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
while
my production system is not scheduled for upgrade till the new year. I
will of course backup the database and do a complete failover/activation test
before deciding whether to maintain the OS difference for even a month or
so.
Steve
McClure
-Original Message-From: [EMAIL P
by specifying
log_archive_dest_2='nfs_mounted_remote_filesystem'.
P.S.
if you are not comfortable with perl or shell scripting, and are working with
Oracle on UNIX, get comfortable with perl or shell
scripting.
Steve
McClure
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
And everything I've learned about single malts, I've learned from this
list.
And save in my Teetotaller folder ;)
This post is not near off topic enough...please forward this folder
Steve McClure
-Original Message-
Michael T
Sent: Tuesday, November 26, 2002 10:17 AM
To: Multiple
of Oracle database design.
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
the
password ASAP, as it is a well known security loophole.
Steve McClure
-Original Message-
Sardina
Sent: Friday, November 22, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
Using OEM Configuration Assistant 2.2, I tried to set up a Management
Server/repository, etc. and through
The username password you use to login to OEM defaults to sysman/sysman.
I just reread my response, and saw I botched the default password. The
password is actually oem_temp.
Steve McClure
-Original Message-
Sardina
Sent: Friday, November 22, 2002 11:59 AM
To: Multiple recipients
. That last sentence may have sounded like a complaint, it wasn't, well
maybe I am complaining about losing the configuration battle, but I am a fan
of the product.
Steve McClure
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002 10:50 AM
To: Multiple recipients of list
to cause us
troubles when switching to CBO.
We have been on 8i since April of this year, and I am just now starting to
gather information on the inner workings of the CBO. I know it is where I
want to be, I am just looking to see how painful/painless the transition
will be.
Steve McClure
--
Please
of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve
It looks like I will be attending this year pending upper management balking
at the registration fee. As for getting together, I think that would be
great, Chevy's is great as well, In fact Tuesday evening looks great too.
So how big a party does that make? Count me in.
Steve McClure
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list
database.
Steve
McClure
60%
certified and counting
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Markham, RichardSent:
Thursday, October 03, 2002 11:03 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Backups
It would be interesting to see
://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
reports that require
Proper text.
So am I a dinosaur? Maybe it is because I am not writing the reports that
are complicated by my decision to upper() everything while loading.
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED
Am I missing something about the OCP program? The new required class is
only required for the new 'Oracle Certified Master' Certification. You can
still obtain OCP certification without taking any classes direct from
Oracle, right?
Steve McClure
--
Please see the official ORACLE-L FAQ
thing is that
the new client is a large one, so my company will actually be able to invest
in a nicer product.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
of for
switching between modes would be to avoid excessive archivalresulting from
very large processes. If you have room to archive logs you should consider
leaving your DB in archivelog mode.Your odds of having a
satisfying recovery scenario are greatly improved that way.
Steve
McClure
you check
into Rama Veluri's "Oracle Backup and Recovery Handbook". You should at
least refer to the Oracle Backup and Recovery guide.
Good
Luck,
Steve
McCLure
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Meomeo NguyenSent:
Friday, Ma
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
I suggest looking for large directories, and then follow up from there. You
should look at the man page on du. That should do the trick.
Steve McClure
-Original Message-
Sent: Monday, April 29, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Hi
Which unix command(On Solaris
.
Write the crontab to a file(crontab -l cronfile), edit it, and reload it
(crontab cronfile).
Nuke the site from orbit...It's the only way to be sure
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City
a
log switch the log will be archived, and your standby database will recover
without errors.
Steve McClure
-Original Message-
Sent: Tuesday, April 09, 2002 7:58 PM
To: Multiple recipients of list ORACLE-L
Hi,
I created a primary and a standby database. Both are
9i on Win2000, the same
.
Steve McClure
-Original Message-
Sent: Wednesday, February 20, 2002 9:30 AM
To: Multiple recipients of list ORACLE-L
Adary - Wow that is not good! Has anyone else encountered this situation?
Does the licensing fee have a name? Any indication if it differs between US
and non-US licensing
pharmacies, we would require over 50,000 named users.
Steve McClure
-Original Message-
Chris
Sent: Wednesday, February 20, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
I don't think it was Oracle telling you that, it was the sales guy trying to
get his vacation paid
learn was that Oracle will not credit any of your
previous license payments. So we were able to retain them. We have 800
processor units that can be used to run a database or a forms/reports
server. I don't know how or if the concurrent user licenses would be
retained.
Steve McClure
-Original
for this kind of
thing.
Also essential if you are dialing in from home under any circumstance. If
your connection drops you just telnet back in, and reattach to your screen
session exactly where you were when you dropped.
Steve McClure
-Original Message-
[EMAIL PROTECTED]
Sent: Monday
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
I
quoted above.
In writing this I am pretty sure that I screwed myself up by issuing a
'shutdown normal' after my first mount attempt failed, but I figured I would
go ahead and send this off to the list anyway.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve
for
MAXLOGFILES and MAXLOGMEMBERS. Where can I find these parameters? I was
sure I would find them in v$parameter, but they were not there.
Thanks for any response,
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED
containing: UNSUB ORACLE-L
(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: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services
anything more than compile. You
need to look into The Oracle Docs on PL/SQL. Because while you might have
created a procedure, it isn't very procedural.
Steve McCLure
-Original Message-
Sent: Wednesday, January 23, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L
I want to create
may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
there.
Thanks again,
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
recommend a book or
white paper on implementing 'email' from within an Oracle database? I have
downloaded some sample code from Orafaq, and actually gotten it working on
our db. I would just like to actually understand what I am doing, and
expand on what we have.
Steve McClure
--
Please see
to take a trip. Well at least a drive to
Liqour Store.
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
tools.
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
.
Any chance any of you have run across this in the past? I am hoping a patch
exists, because 8.1.6 is the final release for my OS platform.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
Title: Oracle Future???
For
God's sake sell your stock!!
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent:
Tuesday, January 08, 2002 8:51 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle Future??? - from the
conversion they are
receiving the Cannot update or edit from a view error message. I haven't
gotten the error number yet. In fact that is my next step. If I can
identify the exact error message, perhaps I can rtfm.
Thanks in advance for any responses.
Steve McClure
Duhveloper slowly evolving
realize that we are actually not that far off in
terms of concept. Except I bet your perl is much more ready for primetime
than mine. As usual I employed brute force as often as possible.
Steve McClure
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, January 07, 2002 12:35 PM
To: Multiple
that the user can duplicate the error, and until then I am
considering this unrelated to yesterday's conversion.
So
Thank you for any replies so far, but I would now say that this is a non issue
for now.
Thanks
again,
Steve
McClure
-Original Message-From: [EMAIL PROTECTED]
[mailto
and control files from Machine A to Machine B.
4.restart database on Machine A.
5.restore datafiles from hot backup to Machine B.
6.copy init files from Machine A to Machine B
7.issue a recover database on Machine B.
Hope This Helps,
Steve McClure
-Original Message-
Sent: Thursday
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
them, but maybe
Sun does this better than I think. Without some kind of redundancy I am
reluctant to use these disks for any DB purposes. Any thoughts here are
appreciated as well.
Thanks,
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send
I always
just tell the developers to figure out a way to accomplish their task, and
avoid the error on their own.
Oh the
link is Cats Dogs and ORA-01555
Steve
McClure
-Original
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Christine
Turner
Sent: Tuesday
had set for management. She managed our group for about 3
months, but we lived with trashed data for the next two years.
I hope this doesn't mean I have a bad attitude.
Steve McClure
-Original Message-
Sent: Wednesday, December 05, 2001 1:20 PM
To: Multiple recipients of list ORACLE-L
is this. Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple that
volume within two years?
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City
that
volume within two years?
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
done a
bit of internet searching, and seen these Sun boxes priced under 20K. My
question is this. Are these serious platforms for a business currently
handling 10K OLTP transactions a day, and looking to double or triple that
volume within two years?
Steve McClure
--
Please see the official
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve McClure
INET: [EMAIL
confirmation. I had better be careful or I am going to confidently screw up
my database one of these days.
Steve McClure
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rao, Maheswara
Sent: Friday, May 25, 2001 6:11 AM
To: Multiple recipients of list
going to create a small DB just to test this
out, but your input, as usual, is appreciated.
Thanks,
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
period. ( probably Saturday night :(
Jared
On Thursday 17 May 2001 13:48, Steve McClure wrote:
Koivu, Lisa said
A word of warning, and you probably already know this: you can't have
both
databases open at the same time or you will end up with incompatible
archive logs and control files. Good
retrieve my backup and recovery bible.
Any Comments are appreciated.
Thanks,
Steve McClure
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
and thanks for the tip about just moving the arc/redo/control
files back to the production machine to resynch the DBs. That will save me
from some tedium on moving day.
Steve McClure
-Original Message-
Sent: Thursday, May 17, 2001 11:47 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Hi Steve,
I
to a backup user executes my PERL backup script, then finally, calls my
newly created dumpall script as root.
Allthough I felt my original solution was more elegant, this one actually
works. We've all been there right?
Thanks Again,
Steve McClure
-Original Message-
From: [EMAIL
87 matches
Mail list logo