Is it possible to have listner running on box
a while databases running on X,Y,Z . If yes , then how does oracle
instance find the address of the box running the listner , if I configure
ini.ora with service_name . Does it mean that local tnsnames.ora file ( on
server X,Y,Z) should haave an
I think Robert Freeman's book is essential. Oracle RMAN Pocket Reference at
$13 U.S. is an easy decision.
I started before Robert's book was published and the book which really
helped me get off the ground is Oracle Backup Recovery 101. It is about
1/2 RMAN, and has some really simple
Michell,
A sequence is created and select privileges granted to users or roles.
The users or roles use the sequence in the applications to insert/update
the data in the tables. Check the privileges granted to the users/roles
and then get the info from the developers as to which tables use the
Well, there could be business logic reasons as to why you would have one
sequence per table.
Also, I don't know if I would ever go with one sequence for many tables,
sounds like a bottle neck to me. And how would one sequence for many tables
impact scalability?? Or having lots of users
If you are using the sequence to generate the primary key for a table, then the
sequence should only be used for that table. I can't think of a pro to have one
sequence shared for the primary keys on many different tables.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
I didn't say you should have only one sequence in the database. I said
there was no reason you had to have multiple ones.
and there isn't. There is no restriction in Oracle that you have to do
so. As it happens, for many of the reasons you stated, we have multiple
sequences. That is, where I can
Title: RE: Find the table's name that using sequences
I'd check dependencies of the sequence, you'll know what procedures,functions,packages,triggers that sue the sequence.
Raj
Rajendra dot Jamadagni at
In order for sequence not to become a bottle neck, use cache option.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, July 16, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L
Well, there could be business logic reasons as to why you would have one
Not only that but this sort of thing should be avoidable.
SQL alter system set db_cache_size=10m scope=both;
System altered.
time passes
SQL alter system set db_block_buffers=1000 scope=spfile;
System altered.
SQL shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL
A mad rampage through DBA_SOURCE might reveal something useful.
Something like:
select name,text from dba_source where upper(text) like '%SEQUENCE_NAME%';
And do the same with TRIGGER_BODY from DBA_TRIGGERS.
-Original Message-
Niall
I think that was the intention of the COMMENT parameter. As you point
out, that isn't foolproof. An improvement might be if Oracle tagged each
change with a date stamp.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday,
oh i forgot its binary but not THAT binary.
joe
Niall Litchfield wrote:
Not only that but this sort of thing should be avoidable.
SQL alter system set db_cache_size=10m scope=both;
System altered.
time passes
SQL alter system set db_block_buffers=1000 scope=spfile;
System altered.
SQL
this doesn't take into account external code that uses the sequence
there is no way to know for certain which sequence is being used to
generate values for which table. Even if you have multiple sequences,
you can't force a programmer to use the sequence you have designated as
the one for
Wow! Mladen, thanks for listing my name in your list.
As Arup mentioned, you forgot yourself. I would also suggest Dan Fink, Tim Gorman, and
Dr. Mogens!
Gaja is moving the other (dark) side, so I won't mind excluding him :)
When it comes to RMAN, I am not even in the rookie stage. We bought a
Nuala...
1.- can you send your environment variables? (my_pc -
properties - advanced - environment variables)
2.- can you send your Oracle registry values?
JL
--- Nuala Cullen [EMAIL PROTECTED] wrote:
Hi Jared,
Thanks for the advice,
I checked out the registry settings
ORA_WMS_PFILE
FailSafe comes with EE and works very well. It might even come with SE but I am not
sure. Our
production environment fails over in less than 2 minutes. It is much simpler to set up
( ie no
SAN, raw devices or OCFS) and a heck of a lotr cheaper ( 20K$ / CPU for RAC ). One
other
note is that we
This can be solved by creating the PFILE again from the SPFILE; and this
doesn't need the instance to be up. However, you did drive the nail home,
Niall, with this example.
Part of the problem could be avoided by restricting the ALTER SYSTEM, SYSDBA
or SYSOPER privileges; but in a large shop with
Kirti,
Gaja is moving the other (dark) side???
Elaboration, please.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 5:29 PM
Wow! Mladen, thanks for listing my name in your list.
As Arup mentioned, you forgot
Title: RE: 10i reg.
From the article ...
quote
Oracle 10i is expected to include Oracle Real Application Cluster (RAC) support for Sun, HP and IBM Unix boxes, bringing them up to date with technology currently available for Windows and Linux.
/quote
Ha Ha Ha Ha Ha Ha . The person
Title: Message
Mladen, one correction or comment. You don't need a
third party package if you are backing up to disk. Then it's straight
rman.
Ruth
- Original Message -
From:
Gogala, Mladen
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 16, 2003
i kind of get the point... its just overkill now.
From: Boivin, Patrice J [EMAIL PROTECTED]
Date: 2003/07/16 Wed AM 11:39:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: * Sr. Oracle DBA with 8i and 9i experience needed..
Intersting... I get spammed at
Arup,
My database version is Oracle 9i (9.2.0.1.0). Thanks!
Don
Arup Nanda wrote:
What is your database version? 9i? If so you are probably using the SPFILE;
changing the init.ora file wouldn't help.
Shutdown trhe database and startup with the pfile option
startup pfile=init.ora
EE is not required to FailSafe. It comes at no cost with Standard Edition
as well.
Tanel Poder
We are trying to configure an Oracle LDAP connection to Microsoft Active
Directory. This is so a client machine can get the connection information
(an alternative to tnsnames.ora or Oracle Names) and connect to an Oracle9i
database on Sun Solaris.
Does anyone know how you create the container
Title: Message
Ruth,
that is correct but, generally speaking, backup to disk is rather awkward thing
to
do,
even without mentioning the fact that you need more disks for that and that
disks
are not free, either. Between thwe two of us, I don't
know a company doing backups to
the
disk.
f) I would suggest Jared Still, Cary Millsap, Rachel Carmichael,
Jonathan Lewis, Wolfgang Breitling,
Steve Adams, Gaja V., Arup Nanda, Kirti Deshpande and Anjo Kolk to
start the Oracle List certification
process. I would trust that one more then the OCP. I apologize to
anyone who I
Yes we do, though we're cheap bastards, sorry public sector so its
compaq san rather than a big name co. It works well is reliable, and for
us was a pain to setup. You also need to remember that you are adding a
layer of complexity in the name of reliability. Complexity and
reliability do not
In addition to what Jacques has mentioned, here is my 0.02.
Why only one sequence per table? Does it stem from the concern that a single
sequence becomes overloaded with request to be inserted into multiple
tables?
The overloading does not come from number of tables, but number of
concurrent
Title: RE: 10i reg.
Raj,
The article probably meant the extension of Oracle
Cluster Filesystem to these Operating systems. In 9i, RAC required some third
party clustering software for these - MC/ServiceGuard, SunCluster, etc.; whereas
the OCFS was available for linux and Windows (??).
But
Well, he is part of Oracle 'chefs' now. Praising the food before they cooked it ;)
- Kirti
--- Arup Nanda [EMAIL PROTECTED] wrote:
Kirti,
Gaja is moving the other (dark) side???
Elaboration, please.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L
The other parameters that will get you in the same trouble are related to the special
buffer
pools.. I ran into this issue with 9iR1 and decided to stay away from SPFILE stuff...
The failure of Oracle (programmers) checking for such exclusiveness (?) tells their
background.
Doesn't it?
I
Following on from Cary's response, both internal and external testing
has shown the performance improvements of storing objects in tablespaces
with different block sizes to be so miniscule as to be not worth the
effort (or putting it another way, there are lots of better ways to
spend your
I can definitely appreciate the benefits of dynamic parameters, and of being able to
persist the values of those parameters accross shutdown/startup cycles. But I would
have guessed that oracle could have gotten both of those features together without
going to a binary parameter file--couldn't
help
Blessed are the cheesemakers, because they shall rule
the Kingdom of God. Blessed
are
the Greek, because they shall inherit the Earth. Hope this helps
you.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From: Tom Pall
[mailto:[EMAIL
When you say start the enterprise manager console and try to login as sys
do you mean that the EM console login box that prompts for username, pwd and
management server you enter sys as the user?
If so, you need to enter an EM username password rather than a DB username /
password.
Also, in
Hi!
Your databases actually have to register with your
listener on remote machine.
Your databases have to have tnsnames.ora configured
with entry for listener location as well and your instances' REMOTE_LISTENER
parameter has to specify the tns alias for listener location. That way
hi,
Did you get any replies off-list? We are moving to Aix so I'm very
interested in this topic.
Thanks
Stephen
[EMAIL PROTECTED] 07/15/03 10:44AM
Hi, friends:
There is a project that migrate a 9.0.1.3 database on linux server
to
9.2.0.3 on aix/p670 server, and I have some question
That won't catch sequences in triggers.
You can't easily find sequence use in a trigger either, as
the code is stored in a LONG.
Best to dump to a text file and use grep.
And if your programmers practice safe sequences, it will be
in their code instead of the database anyway.
Although if
Title: RE: Really annoying 9ias Rel 2 install
Guys,
It is not OFA compliant - all the files go in the same directory as the binary - there is no way to precreate the database and point the installer to an existing database initially. After the initial install - yes but not before.
Yuck.
And to add to that, I don't believe that FailSafe is even required to use
Oracle with MS Clusters.
IIRC, it's just to simplify the cluster setup.
FailSafe certainly isn't need for setting up failover withi Veritas
Cluster Server.
Jared
Allen R. Lucas [EMAIL PROTECTED]
Sent by: [EMAIL
Oh, you mean Elisonville!
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 6:59 PM
Well, he is part of Oracle 'chefs' now. Praising the food before they
cooked it ;)
- Kirti
--- Arup Nanda [EMAIL PROTECTED] wrote:
Chris,
The system I work on currently has a main sequence issuing GUID's (Globally
Unique Identifier's) for the entire application. I think it comes from the
Object Orientated world - where some physical tables may be storing various
different logical records and sometimes a foreign key may
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?)
it isn't binary on solaris ... pure text ...
Raj
-Original Message-
From: Pardee, Roy E [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 16, 2003 6:40 PM
To: Multiple recipients of list
Title: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in sync with INIT.ORA ?)
Not true; it's binary, on both Solaris 8 and 9. By
the most of the file (regardless of the OS) is still text; the non-ascii chars
are present at the beginning of the file.
Arup Nanda
-
Oh yeah. I forgot about that LONG data type pain in the anus when you are
looking for something. I just attended 9i new features in Colorado Springs
last week. I asked, with all these new features, why the implementation of
the LONG data type was still so piss poor (well, maybe not exactly in
Keeping them binary gives them power I guses...
On most platforms there is just a hashed value on the first line.
In 9i R1 (9.0.1), I was able to replace some param value without changing number of
chars on the
line, and the changes were taken without any problem (HP-UX 11, it was I think).
Thanks for the amusement, btw there is nothing in the article that isn't on
metalink, go figure
Very true..
Not worth to share your e-mail address to receive more 10i information as it becomes
available :)
Oracle will be pushing it down our throat for free... I bet those sign makers in
Hi, Stephen,
I did not get feedback from the list:(. Maybe my question is always too
lengthy.
It is not my company that is using AIX 5.2, but one of my friend. In
fact, I do not suggest you use AIX 5.2 in your production , after all, it is
too new!
One if my friend tell me, it is easy
Matt,List
Does this have a benefit for SINGLE instance Database Server connected to Multiple
Application Servers (Client Server Architecture) ?
OS = Solaris 9
Application , DB Servers = SF15K machines
Network = 1 GBPS interconnects routing thru a switch
May I further extend this to ask if
0 1 * * 0 /usr/bin/ksh -c [ `date '+\%a'` = 'Sun' -a $((`date '+\%U'` \%
2)) -eq 0 ] /path/myscript.ksh
This will run myscript.ksh on even Sundays at 1 a.m.
If ?'s, email me direct.
Having experienced SQL*BackTrack, EBU, and RMAN.
Yes RMAN is getting better (anyone else remember the nightmare called
EBU).
Yes RMAN still sucks.
Yes RMAN is still free (get what ya pay for)
SQL*BackTrack - Slicker than Owl S...
Have the $, use
101 - 152 of 152 matches
Mail list logo
