Thanks Dennis ,
But I am looking something for oracle application server .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 06, 2003 10:14 AM
> AK - My favorite for people that are new to Oracle, or even databases for
> tha
Any good book on oracle 9iAS for beginners which
covers installation , configurations etc .
There is too much in oracle docs .
-Ak
Not Elizabeth Hurley ... :-))) !!
> -Original Message-
>
>
> Everything looks like a big hammer to you,
> doesn't it Stephen?
>
> ;)
>
\
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services
That's 12X -- eXtreme databasing! (eXtra bangs added for eXtra
emphasis)
I just wish some software company -- ANY software company -- would get the
bugs out before feature-creeping and bloating the hell out of a product.
Rich
Rich Jesse System/Database Administrat
I have not heard installing hundred database instances on same server.
Maybe you should think creating one instance, and then hundred schemas in
it.
Guang
On Wed, 6 Aug 2003, Dilip Patel wrote:
> Hi All,
> Need some suggestions/Input.
>
> My application database is 8.1.7, NOARCHIVELOG, WIN200,
>
Thanks for the reply...
Good comments all around (except for the monkey bit, I just had to use
that...)
I should let you know that we are actually dipping our big toe into the
chilly RAC waters soon with a test lab system. Were purchasing a couple of
boxes to go through the setup and do some stre
Paula - Now you've got my attention. Can you describe in more detail what
you mean by "editing backup controlfile". I use a backup controlfile to
create test databases / validate RMAN backups, so this sounds like something
I could use. Thanks.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, I
Guys,
I am installing Oracle 9.2.0.1 on Win2K Adv.Server/SP3.
While database configuration asst. is creating the database,i get the error:
"ORA-29838 insufficient privileges to execute the operator(s)"
I found from docs that:
Cause: User does not have privileges to execute one of the op
Title: RMAN Script Question
David,
I notice that u r
using the line
format 'data_full_%d_%U_%p_%c.bak' (database);
in ur backup
script when u r actually performing a database backup including archived logs
backup.
Try modifying the
script as :
resync catalog; run { allocate chan
Avnish ,
As far as log buffer is considered , look at how much redo ur generating .
That will be help you in finding optimal size of log buffer .
-ak
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 05, 2003 4:54 PM
> What are t
Because you are still using db_block_buffers in init.ora file..
- Kirti
--- Roger Xu <[EMAIL PROTECTED]> wrote:
> Why I have db_cache_size set to zero in my database?
>
> SQL> show parameter db_cache_size
>
> NAME TYPEVALUE
> -
--_=_NextPart_001_01C35C00.634E5820
Content-Type: text/plain; charset="windows-1256"
The most important part of working with databases...
Have a look at 'Oracle Design', Dave Ensor & Ian Stevenson.
But if you have not already, I would urge you to attend a training course.
It is a complex,
Dennis,
If I understand your question correctly, ...
Your 10046 trace file will contain the execution plan that the PL/SQL
procedure is seeing, if you let the process close the cursor before you
shut off the trace.
I think you can also get the plan information you're looking for from
the 10053 d
Henry - Thanks. I feel like I'm getting an education today on the Oracle
Wait Interface today. Nothing like a live problem for everything to make
sense.
Thanks for pointing out that I could find the table. It is our
WKLYJOBFACT table. Not one we suspected.
We have been doing an EXPLAIN PLAN
Did you relink sqlplus?
Did you relink client?
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
Applied >250 OS patches on HP-UX 11.11 server and after that getting
ORA-3113 error message every time I do svrm
RAC -
Intel is not yet proven as far as I can tell. So be very cautious about choosing
this path for such a large project.
I
would probably stick with the big box and concentrate on as fast as IO as
possible. No wait please do the RAC with Intel quads, figure out all the bugs
and pitfalls
Agree. The fewer variables you change the easier it is to figure out what is going
wrong. Now depending on the OS that your migrating to you may well have to change
block sizes.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, August 06, 2003 3
Disney version. Andersen's story rarely end well.
Mladen Gogala wrote:
>
> You are definitely reading writings of Hans Christian Andersen.
>
> --
> Mladen Gogala
> Oracle DBA
>
> -Original Message-
> Boivin, Patrice J
> Sent: Wednesday, August 06, 2003 1:34 PM
> To: Multiple recipients
I have two or three of Tuftes more well known books.
For anyone that creates presentations with graphics, these
are a must have.
For anyone that feels stupid because they can't understand
someone else's charts in an power-point presentation, these
are a must have. Hint: It ain't you.
It's ter
Dennis,
Could you plese post the v$session_wait. Do you have a 10046 trace?
Henry
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, August 06, 2003 11:40 AM
To: Multiple recipients of list ORACLE-L
We have a situation where a process can't insert into a partition of a
partitioned ta
Type
: (to get the command prompt at the bottom of the screen)
Then type
%s/^M//
and press enter. Note that you get "^M" by pressing "Ctl/V" followed by
"Ctl/M".
Regards,
Mike Hately
-Original Message-
Sent: 06 August 2003 17:09
To: Multiple recipients of list ORACLE-L
Suddenly my vi
Suddenly my vi editor is showing ^M at the end of each line. How do I
get rid of it?
Thanks in advance,
Saira
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Saira Somani-Mendelin
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatci
left over memory segments/shared memory/semaphores?
ipcs is your friend, oh and its destructive brother ipcrm :)
joe
[EMAIL PROTECTED] wrote:
No, There is no log generated. Below is the only message I am getting.
hp204:NAMES :/home/oracle > svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Prod
I got this e-mail but deleted it.
Ken Janusz
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 06, 2003 9:19 AM
> OK, Who got infected??
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified 8i DBA
>
> -Original Message-
I noticed that the new Oracle TPC-C benchmark was 10G ... if that means
anything.
> -Original Message-
>
> Heard an Oracle rep last week say that 10G was mostly
> hype. If you want to watch what's for real at Oracle
> it's Linux.
>
> Only time will tell if he is right, but he has a
> b
Title: RMAN Script Question
David,
I have
a set of scripts which do various rman backups that I would be happy to send you
if you send me your email address ( no attachments to the list). They work
because I use them every day.
Ruth
-Original Message-From: [EMAIL PROTECTED]
Joe Testa scribbled on the wall in glitter crayon:
> linux, "you want me to do what with this file?" :)
>
> i got it too.
>
> joe
me three. about 6 times so far. might have gotten passed from here, i'm
looking at things now.
--
Bill "Shrek" Thater ORACLE DBA BAARF Party member #25
I've now gotten opatch to report its version. I had to get the right combination of
the perl executable and perl5 libraries. I expect the patch will install tomorrow. I
too ended up using per5005_03.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
What gets me here is that there are no other transactions occurring using that table.
Now there are alot of other long running transactions occuring at that time, but they
do not involve the table that was being analyzed.
any suggestions on what to check for?
--
Please see the official ORACLE
Matt, Brad, Group,
Another Bite.
My opinion on RAC (after limited nr of trials),
I did read Mogens and loads of other articles, ppts etc...
The arguments in favour of RAC are :
- Scalability (scale out, rather then forklift)
- flexibility (capacity on demand, increase and Decrease)
- redun
Paula - Okay, when you say you brought the database down, copied the files,
etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in
that post, but your original post was all about RMAN.
-Original Message-
Sent: Tuesday, August 05, 2003 10:19 AM
To: Multiple recipients
Title: Message
Hello
Group,
I just upgraded
a database to Oracle 9.2.0.3 from 8.1.7. I created an undo tablespace with
10 (default) undo segments... however, during an export I got the following
message:
ORA-01555: snapshot too old: rollback segment
number 15 with name "_SYSSMU15$" too
32 matches
Mail list logo