Re: Unique constraint violation question.

[Mladen Gogala]

There is a way, but you have to master the Tao first. When you
do, you will not ask questions like that. Short of that,
you could try selecting the record(s) from the table which
have the same unique key as the record you're trying to insert.
Truncate table will also rid you of the problems with duplicate
keys.
begin
dbms_rtfm.database_concepts;
end;
/


On 2003.07.11 00:29, [EMAIL PROTECTED] wrote:
Hi, All,

When an unique constraint is violated, is there any way to know which record
cause this problem?
TIA,

Chuan
Important: This transmission is intended only for the use of the addressee
and may contain confidential or legally privileged information.  If you are
not the intended recipient, you are notified that any use or dissemination
of this communication is strictly prohibited.  If you receive this
transmission in error please notify the author immediately by telephone and
delete all copies of this transmission together with any attachments.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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).

Unique constraint violation question.

[chuan . zhang]

Hi, All,

When an unique constraint is violated, is there any way to know which record
cause this problem?

TIA,

Chuan
Important: This transmission is intended only for the use of the addressee
and may contain confidential or legally privileged information.  If you are
not the intended recipient, you are notified that any use or dissemination
of this communication is strictly prohibited.  If you receive this
transmission in error please notify the author immediately by telephone and
delete all copies of this transmission together with any attachments.

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

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

Re: trigger and LogMiner

[Chip]

Idea for testing: looking for redo associated with select
statement(s) that are cleaning out row level locks in
block(s) from previously committed DML transaction(s).
Have Fun :)

Tanel Poder wrote:

Hi!

Maybe they were thinking that if you audit select statements, you can
analyze inserts on AUD$ using logminer later on
Anyway, if there's any future release where selects can be in redo, I hope
they aren't there by default..
Tanel.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2003 2:19 PM
 

Hi Arup and Joe

When I wrote the SANS Oracle security step-by-step book I wrote in there
the list of restrictions for log miner including that is didn't support
selects and during the review process of my book someone in Oracle who
was reviewing it informed me that selects would be in the redo in one of
the 9i releases, so i changed the book to say fixed in 9i.
To be honest I now agree with you, it doesn't make sense for selects to
be in the redo, although i suppose they could include them if they
wanted to.
At least for 9iR1 I am sure they are not included as I did some tests 2
or 3 weeks ago when i was writing a paper "detecting SQL injection on
Oracle" for securityfocus.com and selects were definitely not recorded
by logminer. I did not also dump the archive log to trace to see if
there was no select in it but at least LogMiner does not recognise
selects. I copied the list i posted from a file yesterday without
thinking i was perpetuating this issue even though i saw myself a few
weeks ago it wasn't true.
kind regards

Pete

In article <[EMAIL PROTECTED]>, Arup Nanda
<[EMAIL PROTECTED]> writes
   

Hi Pete,

I am a little prerplexed by "selects are not recorded in redo prior to 9i
 

".
 

AFAIK selects are nevere recorded in the redo, and therefore archived
 

logs -
 

so they are never unearthed by LogMiner, even in 9i Release2. Isn't that
true?
Thanks.

Arup
 

--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for
   

details.
 

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



 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chip
 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).

Thanx --> Re: any script to parse alert log ?!

[Prem Khanna J]

Thanx Mladen.
i have got some scripts now.
i have to try one by one and find out which suits my need.

thanx u all.

Jp.

10-07-2003 09:09:24, Mladen Gogala <[EMAIL PROTECTED]> wrote:

>Here is a good one:
>create or replace directory bdump as '/oracle/admin/o9i/bdump'
>/
>grant read on directory bdump to public
>/
>create table alert_log_ext (
>line varchar2(2000) )
>organization external
>(
>type oracle_loader
>default directory bdump
>access parameters
>   (
>   records delimited by newline
>   nobadfile nologfile nodiscardfile
>   fields (line char(132)
>   )
>)
>location('alert_o9i.log') )
>reject limit unlimited
>/
>
>You can now write a PL/SQL or Java procedure to parse alert_log_ext table
>if your heart so desires. There is only one problem: this doesn't work
>if you don't have 9iR2.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  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: Restricting access via sqlplus

[Mark Brooks]

We use a similar process for several of our in-house applications. The users
get an Oracle id that only has create session. The application prompts for
the users username and password and attempts to login to the database. If
the login succeeds the application closes the connection and then logs in
behind the scenes using an application account. This way if the user
connects to the database with any tool (Toad, Navigator, Access, ...) they
have no object rights and cannot do anything. Downside is the DBA sees a lot
of application connections in the session table. Some of the applications
maintain a table that maps user names to sessions to make support easier.
Works pretty well most of the time.

YMMV.

Mark

-Original Message-
Jacques Kilchoer
Sent: Wednesday, July 09, 2003 5:29 PM
To: Multiple recipients of list ORACLE-L


To prevent these kinds of problems, the only solution I've ever thought was
feasible was how we implemented it at a previous company of mine.

I think this kind of solution was discussed on the list many months ago.

Problem description at my previous company:
We had a two-tier application written that required users to sign on with
their own Oracle userid/password. (We implemented password expiration rules
etc...) The application, while connected to the database as the user, would
issue insert/update/delete statements against database tables in a common
"APPLICATION" schema.

We wanted to prevent a user from being able to connect to the database using
another application (SQL*Plus, Toad, Excel using ODBC, etc.) and issue the
same insert/update/delete statements that the application could do.

Our solution:
Each user would be granted a role, but the role would not be a default role.
The role was protected by a password. The application would connect to the
database, read the password
-Original Message-
Sent: mercredi, 9. juillet 2003 14:59
To: Multiple recipients of list ORACLE-L


Hi!

No, if you code your trigger to check if the program is your apps name, then
renaming TOAD to TODD doesn't change anything.
But of course if you change TOAD to your apps name, then this scheme fails.
But as I stated, these kinds of methods only help against dumb users.
If you want true security you have to have some kind of middle layer
enforcing security and business/data rules.. (could be implemented inside
database as well, through PL/SQL packages and no direct access to tables for
example).

Cheers,
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 09, 2003 11:39 PM


Tanel,
If I change TOAD.EXE to TODD.EXE, this scheme fails instantly ...
Raj


Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Wednesday, July 09, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L


Hi!
I think sqlplus product profile isn't a good idea, because some smarter ones
might be using TOAD, SQL Navigator or SQL Worksheet... What you might want
to do is to write an after logon trigger which checks the app name from
v$session and allows logon if and only if app name (v$session.program) is
your 3rd party one. If app name isn't correct, then your trigger raises an
exception.
But of course, it only protects you from dumb users.
Another way would be playing with roles, but since you have 3rd party app,
it might be problematic.
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 10:29 PM


> Is there a way to prevent end users from connecting directly
> to the database via sqlplus without restricting access of those
> same users via application code.  The application is a third party
> package which prompts for an id and password and then uses that
> id/password to connect to the database.
>
> I found a note the the archives which suggested making an entry into
> the SQLPLUS_PRODUCT_PROFILE table, but I have not been able to make
> this work.
>
> Oracle version:  8.1.7
> AIX 4.3.3
>
> Thanks,
> Peter Schauss
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Schauss, Peter
>   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: Tanel Poder
 

Re: Copying database from vxfs to ufs

[Tanel Poder]

Hi!

Yep, there should be no problems. It is possible to copy files to and from
raw devices (with one issue of raw device header block(s)).

And if you want to cut migration time, then make a full online backup to
your ufs file system, then shutdown your production and do recovery of "ufs"
database.

Tanel.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, July 11, 2003 4:04 AM


> Hi,
> I have a database (200GB+ 8.1.7.4 version) on Vxfs file systems on a Sun
server ( Solaris 8), which I need to migrate to Ufs file systems mounted on
same server. To cut the migration time,
> can I copy the database files from vxfs to ufs ie across the different
filesystems type. Has anyone done it and noticed any problems.  Is it
supported ?
>
> Thanks in advance.
> Manmohan
>
>
> 
> Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
> http://login.mail.lycos.com/r/referral?aid=27005
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Anubha Jalsingh
>   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: Tanel Poder
  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).

Copying database from vxfs to ufs

[Anubha Jalsingh]

Hi,
I have a database (200GB+ 8.1.7.4 version) on Vxfs file systems on a Sun server ( 
Solaris 8), which I need to migrate to Ufs file systems mounted on same server. To cut 
the migration time,
can I copy the database files from vxfs to ufs ie across the different filesystems 
type. Has anyone done it and noticed any problems.  Is it supported ?

Thanks in advance.
Manmohan



Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anubha Jalsingh
  INET: [EMAIL PROTECTED]

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

RE: RAC system Calls

[Matthew Zito]

Nah - no reason not to use it, especially given how long they've been
around.  Basically you should enable jumbo frames everywhere you can -
whenever your box talks to a host that doesn't support them, it just
won't use them, and when it can it'll get the performance advantage
(side note: your switch has to support jumbo frames as well, but every
major managed switch manufacturer does, so that's not such a big deal).
Everyone wins.  

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Ravi Kulkarni
> Sent: Thursday, July 10, 2003 7:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RAC system Calls
> 
> 
> Hey Matt, 
> Thanks for the useful info.
> 
> >into a smaller number of ethernet frames,
> > reducing both latency and overhead.  Ideally, each
> > block will fit into one ethernet frame,
> We are using 16K blocksize, so we cannot avoid
> datagram splits with 9k frames - but certainly, sounds
> better than with 1500 frames.
> >so unless you're running one of a couple of
> third-party gigabit cards, I think you're probably out
> of luck. 
> Will check with SysAdmins if the GigE we have
> supports. Are there any risks/disadvantages of using
> 9k frames for interconnect?
> 

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

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

RE: RAC system Calls

[Ravi Kulkarni]

Raj,
Yes. Timed_statistics=true. But I see the 'times' even
in single instance(non-rac)database but relatively
called negligible number of times.
-Ravi.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> You seem to have timed_statistics=TRUE right ?? in
> RAC you will ALWAYS see
> GCS pings ... basically as long as
> cluster_database=true, even if only one
> node is running, you will still see Oracle trying to
> ping other instances.
> 
> My guess is that's what is happening ... but I could
> be very well wrong, I
> have RAC experience, but never tried to truss the
> top processes.
> 
> Raj
>

> 
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an opinion is
> an art !
> 
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 12:30 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello List,
> 
> We are running Benchmark tests on Solaris 2-Node
> RAC.
> Consistently noticed the following :
> - Very high Kernel usage (averaging 45%) on TOP 
> - Statspack has "IPC Send Completion sync" waits
> (70%
> Total ela time)
> - On trussing top process, found Oracle to be
> issuing
> huge number of "times" system calls in addition to
> read/writes(which I think are select/inserts).
> Has anyone noticed this in your environment. I am
> guessing these to be inter-instance pings, but could
> not get any hits in Doc/Metalink to confirm this.
> "times" call is clocking lot of CPU. Is this normal
> ? 
> Any pointers would be helpful ? If this is out of
> context, is there a separate list for RAC?
> 
> Thanks,
> Ravi.
> 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Ravi Kulkarni
>   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).
> >
*This
> e-mail message is confidential, intended only for
> the named recipient(s) above and may contain
> information that is privileged, attorney work
> product or exempt from disclosure under applicable
> law. If you have received this message in error, or
> are not the named recipient(s), please immediately
> notify corporate MIS at (860) 766-2000 and delete
> this e-mail message from your computer, Thank
>
you.*1
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: [EMAIL PROTECTED]

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

RE: RAC system Calls

[Ravi Kulkarni]

Hey Matt, 
Thanks for the useful info.

>into a smaller number of ethernet frames,
> reducing both latency and overhead.  Ideally, each
> block will fit into one ethernet frame, 
We are using 16K blocksize, so we cannot avoid
datagram splits with 9k frames - but certainly, sounds
better than with 1500 frames.
>so unless you're running one of a couple of
third-party gigabit cards, I think you're probably out
of luck. 
Will check with SysAdmins if the GigE we have
supports. Are there any risks/disadvantages of using
9k frames for interconnect?

Thanks,
-Ravi.

--- Matthew Zito <[EMAIL PROTECTED]> wrote:
> 
> Jumbo frames are the use of larger than normal MTU
> (Maximum Transmission
> Unit) settings on gigabit Ethernet links.  The
> traditional limit for
> Ethernet frames is 1500 bytes, which was fine for 10
> and 100 megabit
> Ethernet links.  With gigabit, however, since you
> lose a certain minimum
> amount of bandwidth to signaling overhead (preamble,
> postamble, header
> info, etc.) and that the Ethernet card has to do a
> certain minimum
> processing for each Ethernet frame it receives, a
> huge amount of CPU
> overhead can be spent on trying to fill a gigabit
> pipe.  The other
> problem is that if the host(s) are sending/receiving
> data larger than
> 1500 bytes, the data packet has to be fragmented
> into multiple, smaller
> packets, which then have to be reassembled on the
> far side.  Since this
> all has to be done on the host CPU rather than the
> Ethernet card, it
> increases both bus overhead and CPU time.
> 
> With jumbo frames, you use a >1500 byte MTU - the
> exact amount varies by
> implementation, but they're generally in the
> 9000-9200 byte range.
> That's a 6x improvement in the amount of data per
> ethernet frame, plus
> there's less reassembly.  Unfortunately, Sun never
> really embraced it as
> a technology, so unless you're running one of a
> couple of third-party
> gigabit cards, I think you're probably out of luck. 
> 
> 
> The specific relevance to RAC, which I somehow
> managed to mention, is
> that data blocks being shuttled 'tween nodes
> (depending on the
> blocksize) can be placed into a smaller number of
> ethernet frames,
> reducing both latency and overhead.  Ideally, each
> block will fit into
> one ethernet frame, but as always, YMMV.
> 
> Thanks,
> Matt
> 
> --
> Matthew Zito
> GridApp Systems
> Email: [EMAIL PROTECTED]
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359
> http://www.gridapp.com
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On 
> > Behalf Of Ravi Kulkarni
> > Sent: Thursday, July 10, 2003 2:49 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: RAC system Calls
> > 
> > 
> > Matt,
> > What are jumbo frames? Are these assigning private
> > network IPs to cluster_interconnects parameter?
> > -Ravi.
> > 
> > 
> > --- Matthew Zito <[EMAIL PROTECTED]> wrote:
> > > 
> > > And are you using jumbo frames on your
> interconnect?
> > >  That can make a
> > > significant contribution to reducing overhead
> from a
> > > system standpoint.
> > > 
> > > Thanks,
> > > Matt
> > > 
> > > --
> > > Matthew Zito
> > > GridApp Systems
> > > Email: [EMAIL PROTECTED]
> > > Cell: 646-220-3551
> > > Phone: 212-358-8211 x 359
> > > http://www.gridapp.com
> > > 
> > > > -Original Message-
> > > > From: [EMAIL PROTECTED]
> > > [mailto:[EMAIL PROTECTED] On
> > > > Behalf Of K Gopalakrishnan
> > > > Sent: Thursday, July 10, 2003 11:44 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: RE: RAC system Calls
> > > > 
> > > > 
> > > > Ravi:
> > > > 
> > > > Do you have a statspack report? I would like
> to
> > > see that. But
> > > > in any case, 45% kernel is just too much?
> > > > 
> > > > BTW have you verified the private interconnect
> is
> > > used
> > > > for cache fusion transfer.. Make sure the
> cache
> > > fusion
> > > > is not going thru the public network.
> > > > 
> > > > 
> > > > 
> > > > Best Regards,
> > > > K Gopalakrishnan
> > > > 
> > > >  
> > > > 
> > > > 
> > > > -Original Message-
> > > > Ravi Kulkarni
> > > > Sent: Thursday, July 10, 2003 9:30 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > > 
> > > > 
> > > > Hello List,
> > > > 
> > > > We are running Benchmark tests on Solaris
> 2-Node
> > > RAC.
> > > > Consistently noticed the following :
> > > > - Very high Kernel usage (averaging 45%) on
> TOP
> > > > - Statspack has "IPC Send Completion sync"
> waits
> > > (70%
> > > > Total ela time)
> > > > - On trussing top process, found Oracle to be
> > > issuing
> > > > huge number of "times" system calls in
> addition to
> > > 
> > > > read/writes(which I think are select/inserts).
> Has
> > > anyone
> > > > noticed this in your environment. I am
> guessing
> > > these to be
> > > > inter-instance pings, but could not get any
> hits
> > > in
> > > > Doc/Metalink to confirm this. "times" call is
> > > clocking lot of
> > > > CPU. Is this normal ?
> > > > Any pointers 

RE: High availability and upgrades

[Matthew Zito]

Cluster - like Microsoft or Veritas - strictly active/passive, though
you could do RAC if you wanted.  That's for high availability - one box
goes down, the other one either stays up or kicks into action.

Third Mirror - absolutely correct.  It could be a whole separate storage
array or just a virtual disk of pointers to the original storage, but
its a logical copy of your data that can be periodically synced with and
broken off from your main production data.  You could either have both
servers continue to access the main data store and have a third box do
the testing, or break the cluster and take the passive node and use that
for the testing.  I've seen this done a lot, often with the server
dedicated for DR being used for the testing.  

Does this clarify a bit?  I realize I tend to ramble...

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Paul Baumgartel
> Sent: Thursday, July 10, 2003 6:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: High availability and upgrades
> 
> 
> Matt, can you elaborate a bit?  "Configure your two servers 
> in a cluster" how:  RAC, FailSafe (these are Windoze servers, 
> unfortunately)?  
> 
> "Third mirror" implies the two nodes share a disk cluster in 
> which all active drives consist of three mirrored copies; 
> when the third mirror is split off, the two nodes continue to 
> run against two mirrored copies, correct?
> 
> Thanks!
> 
> Paul Baumgartel
> 
> --- Matthew Zito <[EMAIL PROTECTED]> wrote:
> [snip]
> 
> 
> > What about a storage-level solution?  Either at the software (i.e.
> > Veritas) or hardware (i.e. your big honkin' storage array) 
> level, have 
> > a "third mirror" of your data. Configure your two servers in a 
> > cluster, then when you want to do separate testing, split off the 
> > mirror, detach
> > the idle node from the cluster, run your tests against the third
> > mirror,
> > and then resync/rejoin the nodes.  Basically every reasonable
> > hardware
> > vendor and every storage software vendor supports some notion of r/w
> > point-in-time copies that are designed for just this purpose.
> > 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Paul Baumgartel
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

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

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

Re: Oracle on a mainframe (MVS)

[Brian_P_MacLean]

COBOL, SQL*Net, DB_Link...it's all there.

You might want to follow these links to the dark side

  http://www.mvsoraclesig.org/
  http://www.oramain.com/welcome.htm (this guy runs the users group)





   
  
  "Terrian, Tom
  
  (Contractor) To:   Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  (DAASC)" cc: 
  
  <[EMAIL PROTECTED]Subject:  Oracle on a mainframe (MVS)  
   
  mil> 
  
  Sent by: 
  
  [EMAIL PROTECTED]
  
  .com 
  
   
  
   
  
  07/10/2003 08:59 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




We have a future need to create an Oracle database on a mainframe (MVS)
which will then pull data from an Oracle database on an HPUX box.  I know
nothing about MVS so does anyone know of any connectivity problems between
the two boxes?  For example, SQL*Net does come with the server on MVS,
correct?  Does Pro*Cobol also exist on MVS?  Would the connection from MVS
to HPUX be a simple as creating a database link or are there more problems
than that?

Any help would be appreciated.

Thanks,
Tom




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

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

RE: any script to parse alert log ?!

[Gogala, Mladen]

If you have more databases, there are synonyms, views and db-links.
That is classic DBA patchwork. The funniest siutations arise when 
you have a circle of synonyms and db-links pointing to each other,
just like perpetuum mobile. What is impossible in thermodynamics, is
possible in oracle. It doesn't meant that it works, but can be done,
much to the joy of us DBAs.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, July 10, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L


> Here is a good one:
> create or replace directory bdump as 
> '/oracle/admin/o9i/bdump' / grant read on directory bdump to 
> public / create table alert_log_ext ( line varchar2(2000) ) 
> organization external ( type oracle_loader default directory 
> bdump access parameters
>(
>records delimited by newline
>nobadfile nologfile nodiscardfile
>fields (line char(132)
>)
> )
> location('alert_o9i.log') )
> reject limit unlimited
> /
> 
> You can now write a PL/SQL or Java procedure to parse 
> alert_log_ext table if your heart so desires. There is only 
> one problem: this doesn't work if you don't have 9iR2.
Or if the database isn't up. 

I do like the idea though, could centralize all alert.logs and indeed
listener.logs etc in one db. 

Niall 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  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: Gogala, Mladen
  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: High availability and upgrades

[Paul Baumgartel]

Matt, can you elaborate a bit?  "Configure your two servers in a
cluster" how:  RAC, FailSafe (these are Windoze servers,
unfortunately)?  

"Third mirror" implies the two nodes share a disk cluster in which all
active drives consist of three mirrored copies; when the third mirror
is split off, the two nodes continue to run against two mirrored
copies, correct?

Thanks!

Paul Baumgartel

--- Matthew Zito <[EMAIL PROTECTED]> wrote:
[snip]


> What about a storage-level solution?  Either at the software (i.e.
> Veritas) or hardware (i.e. your big honkin' storage array) level,
> have a
> "third mirror" of your data. Configure your two servers in a cluster,
> then when you want to do separate testing, split off the mirror,
> detach
> the idle node from the cluster, run your tests against the third
> mirror,
> and then resync/rejoin the nodes.  Basically every reasonable
> hardware
> vendor and every storage software vendor supports some notion of r/w
> point-in-time copies that are designed for just this purpose.
> 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  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: High availability and upgrades

[Tanel Poder]

Hi!

>
> In the case of 1), not only have you not given yourself high
> availability, you've actually reduced the MTBF for your system, since
> you'll go down twice and often. In the second case, you've got data
> consistency problems - log mining is fine and dandy, but how do you deal
> with a situation where a database is intermittently available?

Note that you can't achieve ultra high availability with only doubling
systems anyway. Nor can you achieve this kind of availability by only making
physical infrastructure redundant. You have go all the way up to client and
also think on software design level (i.e. what happens when doing rolling
upgrades etc..)

Let say we have a 2 databases with this transaction multiplexing system.
Since we already have a change logging and detection system for rolling
upgrades, we should use the same one for disaster recovery.
1) When DML 1 is issued, it's sent both to database A and B (it doesn't
actually be the database but some middle data layer). App server gets
acnowledge, that database A has committed and continues accepting requests.
2) Let say DML 2 is sent to data layers now, before doing any changes, the
app server or data layer checks whether database B managed to commit
previous DML (DML 1). If yes, it can proceed normally with DML 2. If no, it
has to either send an error back and halting (possibly retrying) whole
operations, which is of course unacceptable. But other way would be to
activate this change logging mechanism, and record DML 1 to change log
before DML 2 is handled. And since app server knows now that database B is
down (and out of sync), it writes DML 2 to change log before to real table
as well.

If database B comes up again and it can be recovered to last commit, then we
can use the change logs of A to sync, because the DML 1 and DML 2 entries we
have in change log are there exactly for that reason that database B was
unavailable. And thanks to app server (which doesn't discard old transaction
before it's committed in every mandatory database) we have all changes in
A's change logs since the first change in B failed. (I hope I don't get too
confusing, it's 1 AM here ;)

Or if we cant recover database B to latest commit, then we probably have to:
1) enable change logging in A
2) clone database A to B (possibly via BCV or snapshots)
3) purge (unneeded) change logs on B
4) sync from A->B
5) activate B

There's much more possibilities (and error-possibilities) when you have
databases A, B and C for example ;)

Now that I read from OP's original message they wanted to use second
database for reporting, I see that this solution is probably overkill.

Cheers,
Tanel.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  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: any script to parse alert log ?!

[Tanel Poder]

And load 'em to CLOBs as well and use InterMedia Text to index them ;)

Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, July 11, 2003 12:59 AM


> > Here is a good one:
> > create or replace directory bdump as 
> > '/oracle/admin/o9i/bdump' / grant read on directory bdump to 
> > public / create table alert_log_ext ( line varchar2(2000) ) 
> > organization external ( type oracle_loader default directory 
> > bdump access parameters
> >(
> >records delimited by newline
> >nobadfile nologfile nodiscardfile
> >fields (line char(132)
> >)
> > )
> > location('alert_o9i.log') )
> > reject limit unlimited
> > /
> > 
> > You can now write a PL/SQL or Java procedure to parse 
> > alert_log_ext table if your heart so desires. There is only 
> > one problem: this doesn't work if you don't have 9iR2.
> Or if the database isn't up. 
> 
> I do like the idea though, could centralize all alert.logs and indeed
> listener.logs etc in one db. 
> 
> Niall 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Niall Litchfield
>   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: Tanel Poder
  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: any script to parse alert log ?!

[Niall Litchfield]

> Here is a good one:
> create or replace directory bdump as 
> '/oracle/admin/o9i/bdump' / grant read on directory bdump to 
> public / create table alert_log_ext ( line varchar2(2000) ) 
> organization external ( type oracle_loader default directory 
> bdump access parameters
>(
>records delimited by newline
>nobadfile nologfile nodiscardfile
>fields (line char(132)
>)
> )
> location('alert_o9i.log') )
> reject limit unlimited
> /
> 
> You can now write a PL/SQL or Java procedure to parse 
> alert_log_ext table if your heart so desires. There is only 
> one problem: this doesn't work if you don't have 9iR2.
Or if the database isn't up. 

I do like the idea though, could centralize all alert.logs and indeed
listener.logs etc in one db. 

Niall 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  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: Restricting access via sqlplus

[Jacques Kilchoer]

The problem is that if the decryption and set role were done inside a database 
package, then that means that the Oracle database user needs execute privilege on the 
package, and so the user could call the package from inside SQL*Plus on the client.
At my old company they were talking about encrypting the network traffic but I left 
before they implemented that, and I don't know if they ever did.

> -Original Message-
> From: Pete Finnigan [mailto:[EMAIL PROTECTED]
> 
> It sounds like the encrypted password is read by the client? and
> decrypted on the client? or in the database as a package 
> procedure?. If
> it was decrypted in the client and then the set role command 
> was sent to
> the database the password could be read from the network with a tool
> such as snoop on Unix or using SQL*Net support level trace as 
> that shows
> packet contents in the SQL trace. The latter could be setup 
> by a user on
> his PC attempt a logon to the database and then read the password from
> the trace file. 
> 
> If the decryption and set role were to be done in a package and the
> password is not passed over the network then its better. You 
> could also
> encrypt the network traffic of course. But as you say there is still a
> risk from someone discovering the encryption scheme. 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

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

RE: RAC time clocks (sysdate)

[Matthew Zito]

Oh, that could definitely be true.  My impression on that point had
always been that the really bad form was to have all 100+ hosts on your
network hit the public stratum-1 servers, hence the delgation to local
stratum-2s.  But it is definitely better form to never touch the
stratum-1s.  So, if it wasn't proper manners before, Rich has convinced
me: Thou Shalt Not Use Stratum-1 Servers Unless Thou Art Sharing Thy
Stratum-2s

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Jesse, Rich
> Sent: Thursday, July 10, 2003 4:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RAC time clocks (sysdate)
> 
> 
> Hey Matt!
> 
> I thought that it was a bit of proper manners to avoid 
> hitting the public stratum-1 servers unless you were planning 
> on being a public stratum-2, just to avoid overloading the stratum-1s.
> 
> Thoughts?
> Rich
> 
> Rich Jesse 
> System/Database Administrator 
> 
> Quad/Tech Inc. 
> A Subsidiary of Quad/Graphics 
> 
> Sussex, Wisconsin USA
> 414-566-7633 phone 
> [EMAIL PROTECTED] 
> www.qtiworld.com 
> 
> 
> -Original Message-
> Sent: Thursday, July 10, 2003 3:29 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Beware, NTP can be a complicated critter to get working in a 
> proper fashion. The best way to configure your NTP is to have 
> one or two local stratum 2 or stratum 3 servers that all of 
> your nodes sync off of (a good choice for these servers are 
> servers that do other low-load internal services like mail 
> relay or DNS).  Those servers should each be configured with 
> two unique stratum 1 or 2 servers and then set up to peer off 
> of each other.  Then, point your database servers at your 
> stratum 2 servers.  If your servers are too far out of sync 
> with the rest of the world, NTP won't change the clocks 
> instantaneously, but will gradually "drift" your clocks into 
> sync.  If you want to rush the process, stop the ntpd 
> process, use ntpdate to set the clock one time, and then 
> restart ntp.  The drift should be small enough that will 
> immediately maintain synchronization.
>  
> The above config is a little bit over-engineered if you only 
> have a few hosts, but if you don't already have a global time 
> management system configured, now is the time (no pun 
> intended) to do it - its one of those things that should be 
> required for any infrastructure.  Properly synchronized time 
> makes things like auditing, monitoring, and general sanity an 
> order of magnitude easier.  The above system will easily 
> scale to up to a few hundred hosts and basically insures that 
> the time will be consistent across the infrastructure as a 
> whole.  The other nice thing about NTP is that its an 
> interesting protocol, for those who care about such things, 
> since it actually makes a distinct effort to take network 
> latency and so-such into consideration when setting the time.
>  
> Thanks,
> Matt
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

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

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

RE: Multiple addreses in tns

[Bob Metelsky]

I don't know, thats what Im trying to figgure out. Non the less the
connection works, It looked weird to me (on the first impression)

I suppose I could ask, I was just wondering if this was an easily
identifiable entry

Thanks
bob

> 
> Is he trying to do failover or load balancing?
> 
> 
> 
-- 
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).

RE: High availability and upgrades

[Matthew Zito]

Ugh - this is a tricky idea for a couple of reasons.  What happens when
one database goes down?  When its brought back up its no longer in sync
with the original, and has to be brought up to speed somehow (I see that
you mention that, but that in and of itself is a project).  Besides
that, what if an application node can't talk to one of the database
servers, either because the node is down or network problems are
preventing proper communications.  Either:

1) the transaction has to fail because it could not be committed on both
sides
or
2) only one side is updated

In the case of 1), not only have you not given yourself high
availability, you've actually reduced the MTBF for your system, since
you'll go down twice and often. In the second case, you've got data
consistency problems - log mining is fine and dandy, but how do you deal
with a situation where a database is intermittently available?

What about a storage-level solution?  Either at the software (i.e.
Veritas) or hardware (i.e. your big honkin' storage array) level, have a
"third mirror" of your data. Configure your two servers in a cluster,
then when you want to do separate testing, split off the mirror, detach
the idle node from the cluster, run your tests against the third mirror,
and then resync/rejoin the nodes.  Basically every reasonable hardware
vendor and every storage software vendor supports some notion of r/w
point-in-time copies that are designed for just this purpose.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Tanel Poder
> Sent: Thursday, July 10, 2003 3:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: High availability and upgrades
> 
> 
> Hi!
> 
> I wouldn't call it replication, because data is not 
> replicated from one database to other. The DML feed always 
> goes from app servers to all active databases. One database 
> doesn't even have to know about existence of other one during 
> normal operations, it's done on app server (client) level.
> 
> Since all databases are always in sync, there is no need for 
> complicated conflict resolution or similar mechanisms. But 
> this concept definitely has it's gotchas, like every system out there.
> 
> Tanel.
> 
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, July 10, 2003 10:09 PM
> 
> 
> > are you suggesting that they basically write their own home-grown 
> > version of replication?
> >
> > If so, I believe Peter Robson has already done this in his shop and 
> > may be able to share the code, or at least give a list of "gotchas".
> >
> > seems a bit excessive and prone to error and failure to me.
> >
> >
> > --- Tanel Poder <[EMAIL PROTECTED]> wrote:
> > > Hi!
> > >
> > > Is this your own-written app?
> > >
> > > If you want performance, control and no-data-loss reliability:
> > >
> > > 1) Have 2 completely independent databases
> > > 2) Have your application servers multiplex
> > >all DML requests to both database servers
> > >
> > >That means, if your client inserts something,
> > >then app layer does one insert on first DB
> > >and the same insert in second DB too.
> > >
> > >It can be more efficient than standby
> > >database in maximum protection mode,
> > >because DMLs are sent to databases
> > >parallelly, not through primary to standby.
> > >
> > >Depending on application you could commit
> > >done either when both servers acnowledge
> > >commit, or when only one acknowledges it.
> > >In that case you could check whether second
> > >instance managed to commit when next request
> > >is sent to it. That could give some
> > >performance practically without losing any
> > >reliability features.
> > >
> > >Also, since you now have two identical
> > >databases, you can make your app servers
> > >load balance the selects.
> > >
> > > 3) Before you shut down one database for
> > >maintenance, you first configure your
> > >app servers to use only one database
> > >AND set change logging on on active DB.
> > >There are several ways for change logging,
> > >starting from customer triggers ending
> > >with logminer.
> > >
> > > 4) When you bring second db up again you
> > >first synchronize all changes manually,
> > >several times if needed, and when the
> > >log of changes is sufficiently low you
> > >just halt both app servers for very short
> > >time, do the final synchronization and
> > >activate both databases again.
> > >
> > > If you upgrade your application, will you change the 
> schema as well? 
> > > Then you must move from physical to logical level, where you have 
> > > some kind of mapping, which columns of old tables match 
> columns in 
> > > new tables.
> > >
> > > That w

Re: Multiple addreses in tns

[Thomas Day]

Is he trying to do failover or load balancing?





   

  "Bob Metelsky"   

  
  @cps92.com>  cc: 

  Sent by: Subject: Multiple addreses in tns   

  ml-errors

   

   

  07/10/2003 10:19 

  AM   

  Please respond   

  to ORACLE-L  

   

   





Is having multiple addresses valid for a tns entry?

A client provided this to me and initailly looked invalid

alias =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526))
)
(CONNECT_DATA = (SID = name)(SERVER = DEDICATED))
  )


>From initial testing, if the first server is not avaliable the entire
connect fails. Personally Ive never seen this and from checking my
reference, this does NOT seem to be valid

Any input would be most welcome

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: Thomas Day
  INET: [EMAIL PROTECTED]

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

RE: RAC time clocks (sysdate)

[Jesse, Rich]

Hey Matt!

I thought that it was a bit of proper manners to avoid hitting the public
stratum-1 servers unless you were planning on being a public stratum-2, just
to avoid overloading the stratum-1s.

Thoughts?
Rich

Rich Jesse 
System/Database Administrator 

Quad/Tech Inc. 
A Subsidiary of Quad/Graphics 

Sussex, Wisconsin USA
414-566-7633 phone 
[EMAIL PROTECTED] 
www.qtiworld.com 


-Original Message-
Sent: Thursday, July 10, 2003 3:29 PM
To: Multiple recipients of list ORACLE-L


Beware, NTP can be a complicated critter to get working in a proper fashion.
The best way to configure your NTP is to have one or two local stratum 2 or
stratum 3 servers that all of your nodes sync off of (a good choice for
these servers are servers that do other low-load internal services like mail
relay or DNS).  Those servers should each be configured with two unique
stratum 1 or 2 servers and then set up to peer off of each other.  Then,
point your database servers at your stratum 2 servers.  If your servers are
too far out of sync with the rest of the world, NTP won't change the clocks
instantaneously, but will gradually "drift" your clocks into sync.  If you
want to rush the process, stop the ntpd process, use ntpdate to set the
clock one time, and then restart ntp.  The drift should be small enough that
will immediately maintain synchronization.
 
The above config is a little bit over-engineered if you only have a few
hosts, but if you don't already have a global time management system
configured, now is the time (no pun intended) to do it - its one of those
things that should be required for any infrastructure.  Properly
synchronized time makes things like auditing, monitoring, and general sanity
an order of magnitude easier.  The above system will easily scale to up to a
few hundred hosts and basically insures that the time will be consistent
across the infrastructure as a whole.  The other nice thing about NTP is
that its an interesting protocol, for those who care about such things,
since it actually makes a distinct effort to take network latency and
so-such into consideration when setting the time.
 
Thanks,
Matt
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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: High availability and upgrades

[Tanel Poder]

Title: RE: High availability and upgrades



Hi!
 
In data guard, when you do a DML, it first goes to 
primary instance log buffers, then to redolog, then to standby host using log 
transport services, then applied to stanby using log apply 
services.
 
Thus, in data guard maximum protection mode you 
can't initiate changes to _standby_ databases before changes are 
written to _primary_ db redologs (I might be wrong because haven't read DG 
concepts too thoroughly).
 
But in case I described previously, you can 
issue both "commits" concurrently and even better, using threading and maybe an 
additional layer, you could count transaction committed when at least one node 
has committed, and check whether other nodes have commited with next request 
sent to DBs. That gives performance for example in OLTP environments, but of 
course your app has to be able to handle situations when during next request 
other nodes still haven't committed (this session with not enough committed 
nodes should wait or return some kind of error or handle the situation other 
way).
 
Of course, data guard maximum protection mode 
doesn't require you to program additional mechanisms, but it definitelay hits 
performance. And more, the DG switchover mechanism would be slower than just 
continuing with one active database in case of failure. Also, since we are 
dealing with two regular databases, we won't have problems like stanby has, 
nologging, LOB logging issues, etc.
 
OTOH, backup&recovery strategy is probably 
different than with physical standbys.
 
Tanel.

  - Original Message - 
  From: 
  Jamadagni, Rajendra 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, July 10, 2003 10:49 
  PM
  Subject: RE: High availability and 
  upgrades
  
  Tanel, 
  points 1 & 2  isn't it like using data guard ?? 
  
  Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: Paul 
  Baumgartel [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, July 10, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: High availability and upgrades 
  It is our own application.  That's an interesting 
  approach, thanks! 
  --- Tanel Poder <[EMAIL PROTECTED]> wrote: 
  > Hi! > > Is this your own-written app? > 
  > If you want performance, control and no-data-loss 
  reliability: > > 1) Have 
  2 completely independent databases > 2) Have your 
  application servers multiplex >    
  all DML requests to both database servers > >    That means, if your client inserts 
  something, >    then app layer does 
  one insert on first DB >    and the 
  same insert in second DB too. > >    It can be more efficient than standby 
  >    database in maximum protection 
  mode, >    because DMLs are sent to 
  databases >    parallelly, not 
  through primary to standby. > >    Depending on application you could commit 
  >    done either when both servers 
  acnowledge >    commit, or when only 
  one acknowledges it. >    In that 
  case you could check whether second >    instance managed to commit when next 
  request >    is sent to it. That 
  could give some >    performance 
  practically without losing any >    
  reliability features. > >    Also, since you now have two identical 
  >    databases, you can make your 
  app servers >    load balance the 
  selects. > > 3) Before 
  you shut down one database for >    
  maintenance, you first configure your >    app servers to use only one database 
  >    AND set change logging on on active 
  DB. >    There are several ways for 
  change logging, >    starting from 
  customer triggers ending >    with 
  logminer. > > 4) When 
  you bring second db up again you >    first synchronize all changes manually, 
  >    several times if needed, and when the 
  >    log of changes is sufficiently 
  low you >    just halt both app 
  servers for very short >    time, do 
  the final synchronization and >    
  activate both databases again. > > If you upgrade your application, will you change the schema as 
  well? > Then you must move from physical to logical 
  level, where you have > some kind of mapping, which 
  columns of old tables match columns in > new 
  tables. > > That way you 
  have two separate fully functional databases, no Stanby > or RAC restrictions or additional licence costs etc. If you have 
  a > packaged 3rd party app, then my post is quite 
  useless, but the idea > should be ok. 
  > > Tanel. > > > - 
  Original Message - > To: "Multiple recipients 
  of list ORACLE-L" <[EMAIL PROTECTED]> > 
  Sent: Thursday, July 10, 2003 8:59 PM > 
  > > > We're 
  considering high availability options.  One of our > requirements > > is to be able to 
  take one database offline (i.e., direct all > > 
  application conne

Re: High availability and upgrades

[Tanel Poder]

Hi!

I wouldn't call it replication, because data is not replicated from one
database to other. The DML feed always goes from app servers to all active
databases. One database doesn't even have to know about existence of other
one during normal operations, it's done on app server (client) level.

Since all databases are always in sync, there is no need for complicated
conflict resolution or similar mechanisms.
But this concept definitely has it's gotchas, like every system out there.

Tanel.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2003 10:09 PM


> are you suggesting that they basically write their own home-grown
> version of replication?
>
> If so, I believe Peter Robson has already done this in his shop and may
> be able to share the code, or at least give a list of "gotchas".
>
> seems a bit excessive and prone to error and failure to me.
>
>
> --- Tanel Poder <[EMAIL PROTECTED]> wrote:
> > Hi!
> >
> > Is this your own-written app?
> >
> > If you want performance, control and no-data-loss reliability:
> >
> > 1) Have 2 completely independent databases
> > 2) Have your application servers multiplex
> >all DML requests to both database servers
> >
> >That means, if your client inserts something,
> >then app layer does one insert on first DB
> >and the same insert in second DB too.
> >
> >It can be more efficient than standby
> >database in maximum protection mode,
> >because DMLs are sent to databases
> >parallelly, not through primary to standby.
> >
> >Depending on application you could commit
> >done either when both servers acnowledge
> >commit, or when only one acknowledges it.
> >In that case you could check whether second
> >instance managed to commit when next request
> >is sent to it. That could give some
> >performance practically without losing any
> >reliability features.
> >
> >Also, since you now have two identical
> >databases, you can make your app servers
> >load balance the selects.
> >
> > 3) Before you shut down one database for
> >maintenance, you first configure your
> >app servers to use only one database
> >AND set change logging on on active DB.
> >There are several ways for change logging,
> >starting from customer triggers ending
> >with logminer.
> >
> > 4) When you bring second db up again you
> >first synchronize all changes manually,
> >several times if needed, and when the
> >log of changes is sufficiently low you
> >just halt both app servers for very short
> >time, do the final synchronization and
> >activate both databases again.
> >
> > If you upgrade your application, will you change the schema as well?
> > Then you must move from physical to logical level, where you have
> > some kind of mapping, which columns of old tables match columns in
> > new tables.
> >
> > That way you have two separate fully functional databases, no Stanby
> > or RAC restrictions or additional licence costs etc. If you have a
> > packaged 3rd party app, then my post is quite useless, but the idea
> > should be ok.
> >
> > Tanel.
> >
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Thursday, July 10, 2003 8:59 PM
> >
> >
> > > We're considering high availability options.  One of our
> > requirements
> > > is to be able to take one database offline (i.e., direct all
> > > application connections to a second database server), perform
> > database
> > > and application upgrades, and perform a few hours' worth of tests
> > > before bringing it back online.  We would then take the second
> > database
> > > offline and repeat the procedure.
> > >
> > > We've tried Data Guard logical standby but it's incompatible with
> > Label
> > > Security (which we plan to run), presents performance problems, and
> > has
> > > a number of bugs.  We'd like to use the secondary database for
> > > reporting as well, so a physical standby isn't practical.
> > >
> > > RAC doesn't give us a second database copy.
> > >
> > > Multimaster replication requires that changes to replicated objects
> > be
> > > made via DBMS_REPCAT.ALTER_MASTER_OBJECT, which propagates the
> > changes
> > > to all masters at once.
> > >
> > > We haven't tested Streams yet.
> > >
> > > I'd be interested in hearing of any experiences from those who have
> > the
> > > same or similar requirements.
> > >
> > > Paul Baumgartel
> > >
> > >
> > > __
> > > Do you Yahoo!?
> > > SBC Yahoo! DSL - Now only $29.95 per month!
> > > http://sbc.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Paul Baumgartel
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > > San Diego, California-- Mailing list and web hosting
> > services
> > >
> > 

8.1.7.4 doesn't take stirped raw LVs for redo and rollback. HPUX

[Jessica Mao]

can anyone please help?

errors like below when any of the redo or rollback raw LVs are created using stripe: 

CREATE TABLESPACE RBS DATAFILE '/dev/vgrbs/rrbs01.dbf' SIZE 8000M REUSE AUTOEXTEND OFF 
MINIMUM EXTENT 512K DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 
UNLIMITED ) 
* 
ORA-01119: error in creating database file '/dev/vgrbs/rrbs01.dbf' 
ORA-27042: not enough space on raw partition to fullfill request 
Additional information: 2 

same statement got processed when LVs were recreated w/o stripe. didn't change size 
settings. 

8.1.7.0 did take striped raw LVs for redo and rollback. 
user tablespaces can ALWAYS be created using striped raw LVs.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jessica Mao
  INET: [EMAIL PROTECTED]

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

RE: RAC system Calls

[Matthew Zito]

Jumbo frames are the use of larger than normal MTU (Maximum Transmission
Unit) settings on gigabit Ethernet links.  The traditional limit for
Ethernet frames is 1500 bytes, which was fine for 10 and 100 megabit
Ethernet links.  With gigabit, however, since you lose a certain minimum
amount of bandwidth to signaling overhead (preamble, postamble, header
info, etc.) and that the Ethernet card has to do a certain minimum
processing for each Ethernet frame it receives, a huge amount of CPU
overhead can be spent on trying to fill a gigabit pipe.  The other
problem is that if the host(s) are sending/receiving data larger than
1500 bytes, the data packet has to be fragmented into multiple, smaller
packets, which then have to be reassembled on the far side.  Since this
all has to be done on the host CPU rather than the Ethernet card, it
increases both bus overhead and CPU time.

With jumbo frames, you use a >1500 byte MTU - the exact amount varies by
implementation, but they're generally in the 9000-9200 byte range.
That's a 6x improvement in the amount of data per ethernet frame, plus
there's less reassembly.  Unfortunately, Sun never really embraced it as
a technology, so unless you're running one of a couple of third-party
gigabit cards, I think you're probably out of luck.  

The specific relevance to RAC, which I somehow managed to mention, is
that data blocks being shuttled 'tween nodes (depending on the
blocksize) can be placed into a smaller number of ethernet frames,
reducing both latency and overhead.  Ideally, each block will fit into
one ethernet frame, but as always, YMMV.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of Ravi Kulkarni
> Sent: Thursday, July 10, 2003 2:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RAC system Calls
> 
> 
> Matt,
> What are jumbo frames? Are these assigning private
> network IPs to cluster_interconnects parameter?
> -Ravi.
> 
> 
> --- Matthew Zito <[EMAIL PROTECTED]> wrote:
> > 
> > And are you using jumbo frames on your interconnect?
> >  That can make a
> > significant contribution to reducing overhead from a
> > system standpoint.
> > 
> > Thanks,
> > Matt
> > 
> > --
> > Matthew Zito
> > GridApp Systems
> > Email: [EMAIL PROTECTED]
> > Cell: 646-220-3551
> > Phone: 212-358-8211 x 359
> > http://www.gridapp.com
> > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On
> > > Behalf Of K Gopalakrishnan
> > > Sent: Thursday, July 10, 2003 11:44 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: RAC system Calls
> > > 
> > > 
> > > Ravi:
> > > 
> > > Do you have a statspack report? I would like to
> > see that. But
> > > in any case, 45% kernel is just too much?
> > > 
> > > BTW have you verified the private interconnect is
> > used
> > > for cache fusion transfer.. Make sure the cache
> > fusion
> > > is not going thru the public network.
> > > 
> > > 
> > > 
> > > Best Regards,
> > > K Gopalakrishnan
> > > 
> > >  
> > > 
> > > 
> > > -Original Message-
> > > Ravi Kulkarni
> > > Sent: Thursday, July 10, 2003 9:30 AM
> > > To: Multiple recipients of list ORACLE-L
> > > 
> > > 
> > > Hello List,
> > > 
> > > We are running Benchmark tests on Solaris 2-Node
> > RAC.
> > > Consistently noticed the following :
> > > - Very high Kernel usage (averaging 45%) on TOP
> > > - Statspack has "IPC Send Completion sync" waits
> > (70%
> > > Total ela time)
> > > - On trussing top process, found Oracle to be
> > issuing
> > > huge number of "times" system calls in addition to
> > 
> > > read/writes(which I think are select/inserts). Has
> > anyone
> > > noticed this in your environment. I am guessing
> > these to be
> > > inter-instance pings, but could not get any hits
> > in
> > > Doc/Metalink to confirm this. "times" call is
> > clocking lot of
> > > CPU. Is this normal ?
> > > Any pointers would be helpful ? If this is out of
> > > context, is there a separate list for RAC?
> > > 
> > > Thanks,
> > > Ravi.
> > > 
> > > 
> > > 
> > > __
> > > Do you Yahoo!?
> > > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > > --
> > > Author: Ravi Kulkarni
> > >   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 

RE: RAC time clocks (sysdate)

[Matthew Zito]

Title: Message



Beware, NTP can be a complicated critter to get working in a proper 
fashion.  The best way to configure your NTP is to have one or two 
local stratum 2 or stratum 3 servers that all of your nodes sync off of (a good 
choice for these servers are servers that do other low-load internal services 
like mail relay or DNS).  Those servers should each be configured with two 
unique stratum 1 or 2 servers and then set up to peer off of each other.  
Then, point your database servers at your stratum 2 servers.  If your 
servers are too far out of sync with the rest of the world, NTP won't change the 
clocks instantaneously, but will gradually "drift" your clocks into sync.  
If you want to rush the process, stop the ntpd process, use ntpdate to set the 
clock one time, and then restart ntp.  The drift should be small enough 
that will immediately maintain synchronization.
 
The 
above config is a little bit over-engineered if you only have a few hosts, but 
if you don't already have a global time management system configured, now is the 
time (no pun intended) to do it - its one of those things that should be 
required for any infrastructure.  Properly synchronized time makes things 
like auditing, monitoring, and general sanity an order of magnitude 
easier.  The above system will easily scale to up to a few hundred hosts 
and basically insures that the time will be consistent across the infrastructure 
as a whole.  The other nice thing about NTP is that its an interesting 
protocol, for those who care about such things, since it actually makes a 
distinct effort to take network latency and so-such into consideration when 
setting the time.
 
Thanks,
Matt
--Matthew ZitoGridApp SystemsEmail: 
[EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick 
  WagnerSent: Thursday, July 10, 2003 1:10 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: RAC time clocks 
  (sysdate)
  thanks! 
  -Original Message-From: Jamadagni, Rajendra 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, July 10, 2003 
  10:40 AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: RAC time clocks (sysdate)
  Our sysadmins use ntp or something like that . 
  Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: Nick 
  Wagner [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, July 10, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: RAC time clocks (sysdate) 
  In a RAC environment, what is the best way to synchronize the 
  time clocks on the nodes?   It seams I came across a case where 
  select sysdate from dual; produced two different values. 
  Thanks! 
  Nick 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.net -- 
  Author: Nick Wagner   
  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). 

dbms_repair question

[Jamadagni, Rajendra]

Title: dbms_repair question





Okay ... so I used dbms_repair today for the first time ... found one corrupt row in a table. dbms_repair.check_object populated the repair_Table and data shows corrupt_type = 6148 and corrupt_description is null. This gives me no clue ... so does anyone know what is corrupt type 6148 ??

This is on a trash db, 9202 on AIX.


Thanks in advance
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: RAC system Calls

[Ravi Kulkarni]

Matt,
What are jumbo frames? Are these assigning private
network IPs to cluster_interconnects parameter?
-Ravi.


--- Matthew Zito <[EMAIL PROTECTED]> wrote:
> 
> And are you using jumbo frames on your interconnect?
>  That can make a
> significant contribution to reducing overhead from a
> system standpoint.
> 
> Thanks,
> Matt
> 
> --
> Matthew Zito
> GridApp Systems
> Email: [EMAIL PROTECTED]
> Cell: 646-220-3551
> Phone: 212-358-8211 x 359
> http://www.gridapp.com
> 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On 
> > Behalf Of K Gopalakrishnan
> > Sent: Thursday, July 10, 2003 11:44 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: RAC system Calls
> > 
> > 
> > Ravi:
> > 
> > Do you have a statspack report? I would like to
> see that. But 
> > in any case, 45% kernel is just too much?
> > 
> > BTW have you verified the private interconnect is
> used 
> > for cache fusion transfer.. Make sure the cache
> fusion
> > is not going thru the public network.
> > 
> > 
> > 
> > Best Regards,
> > K Gopalakrishnan
> > 
> >  
> > 
> > 
> > -Original Message-
> > Ravi Kulkarni
> > Sent: Thursday, July 10, 2003 9:30 AM
> > To: Multiple recipients of list ORACLE-L
> > 
> > 
> > Hello List,
> > 
> > We are running Benchmark tests on Solaris 2-Node
> RAC. 
> > Consistently noticed the following :
> > - Very high Kernel usage (averaging 45%) on TOP 
> > - Statspack has "IPC Send Completion sync" waits
> (70%
> > Total ela time)
> > - On trussing top process, found Oracle to be
> issuing
> > huge number of "times" system calls in addition to
> 
> > read/writes(which I think are select/inserts). Has
> anyone 
> > noticed this in your environment. I am guessing
> these to be 
> > inter-instance pings, but could not get any hits
> in 
> > Doc/Metalink to confirm this. "times" call is
> clocking lot of 
> > CPU. Is this normal ? 
> > Any pointers would be helpful ? If this is out of
> > context, is there a separate list for RAC?
> > 
> > Thanks,
> > Ravi.
> > 
> > 
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > -- 
> > Author: Ravi Kulkarni
> >   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: K Gopalakrishnan
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') 
> > and in the message BODY, include a line
> containing: UNSUB 
> > ORACLE-L (or the name of mailing list you want to
> be removed 
> > from).  You may also send the HELP command for
> other 
> > information (like subscribing).
> > 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> -- 
> Author: Matthew Zito
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  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 ORAC

RE: High availability and upgrades

[Jamadagni, Rajendra]

Title: RE: High availability and upgrades





Tanel,


points 1 & 2  isn't it like using data guard ??


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Paul Baumgartel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 10, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: High availability and upgrades



It is our own application.  That's an interesting approach, thanks!



--- Tanel Poder <[EMAIL PROTECTED]> wrote:
> Hi!
> 
> Is this your own-written app?
> 
> If you want performance, control and no-data-loss reliability:
> 
> 1) Have 2 completely independent databases
> 2) Have your application servers multiplex
>    all DML requests to both database servers
> 
>    That means, if your client inserts something,
>    then app layer does one insert on first DB 
>    and the same insert in second DB too.
> 
>    It can be more efficient than standby 
>    database in maximum protection mode, 
>    because DMLs are sent to databases 
>    parallelly, not through primary to standby.
> 
>    Depending on application you could commit
>    done either when both servers acnowledge
>    commit, or when only one acknowledges it.
>    In that case you could check whether second
>    instance managed to commit when next request
>    is sent to it. That could give some 
>    performance practically without losing any
>    reliability features.
> 
>    Also, since you now have two identical 
>    databases, you can make your app servers
>    load balance the selects.
> 
> 3) Before you shut down one database for 
>    maintenance, you first configure your
>    app servers to use only one database
>    AND set change logging on on active DB.
>    There are several ways for change logging,
>    starting from customer triggers ending
>    with logminer.
> 
> 4) When you bring second db up again you
>    first synchronize all changes manually,
>    several times if needed, and when the 
>    log of changes is sufficiently low you
>    just halt both app servers for very short
>    time, do the final synchronization and
>    activate both databases again.
> 
> If you upgrade your application, will you change the schema as well?
> Then you must move from physical to logical level, where you have
> some kind of mapping, which columns of old tables match columns in
> new tables.
> 
> That way you have two separate fully functional databases, no Stanby
> or RAC restrictions or additional licence costs etc. If you have a
> packaged 3rd party app, then my post is quite useless, but the idea
> should be ok.
> 
> Tanel.
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, July 10, 2003 8:59 PM
> 
> 
> > We're considering high availability options.  One of our
> requirements
> > is to be able to take one database offline (i.e., direct all
> > application connections to a second database server), perform
> database
> > and application upgrades, and perform a few hours' worth of tests
> > before bringing it back online.  We would then take the second
> database
> > offline and repeat the procedure.
> > 
> > We've tried Data Guard logical standby but it's incompatible with
> Label
> > Security (which we plan to run), presents performance problems, and
> has
> > a number of bugs.  We'd like to use the secondary database for
> > reporting as well, so a physical standby isn't practical.
> > 
> > RAC doesn't give us a second database copy.
> > 
> > Multimaster replication requires that changes to replicated objects
> be
> > made via DBMS_REPCAT.ALTER_MASTER_OBJECT, which propagates the
> changes
> > to all masters at once.
> > 
> > We haven't tested Streams yet.  
> > 
> > I'd be interested in hearing of any experiences from those who have
> the
> > same or similar requirements.
> > 
> > Paul Baumgartel
> > 
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Paul Baumgartel
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> > San Diego, California    -- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > 



__
Do you Yahoo!?
SBC Yahoo! 

Re: High availability and upgrades

[Rachel Carmichael]

are you suggesting that they basically write their own home-grown
version of replication?

If so, I believe Peter Robson has already done this in his shop and may
be able to share the code, or at least give a list of "gotchas".

seems a bit excessive and prone to error and failure to me. 


--- Tanel Poder <[EMAIL PROTECTED]> wrote:
> Hi!
> 
> Is this your own-written app?
> 
> If you want performance, control and no-data-loss reliability:
> 
> 1) Have 2 completely independent databases
> 2) Have your application servers multiplex
>all DML requests to both database servers
> 
>That means, if your client inserts something,
>then app layer does one insert on first DB 
>and the same insert in second DB too.
> 
>It can be more efficient than standby 
>database in maximum protection mode, 
>because DMLs are sent to databases 
>parallelly, not through primary to standby.
> 
>Depending on application you could commit
>done either when both servers acnowledge
>commit, or when only one acknowledges it.
>In that case you could check whether second
>instance managed to commit when next request
>is sent to it. That could give some 
>performance practically without losing any
>reliability features.
> 
>Also, since you now have two identical 
>databases, you can make your app servers
>load balance the selects.
> 
> 3) Before you shut down one database for 
>maintenance, you first configure your
>app servers to use only one database
>AND set change logging on on active DB.
>There are several ways for change logging,
>starting from customer triggers ending
>with logminer.
> 
> 4) When you bring second db up again you
>first synchronize all changes manually,
>several times if needed, and when the 
>log of changes is sufficiently low you
>just halt both app servers for very short
>time, do the final synchronization and
>activate both databases again.
> 
> If you upgrade your application, will you change the schema as well?
> Then you must move from physical to logical level, where you have
> some kind of mapping, which columns of old tables match columns in
> new tables.
> 
> That way you have two separate fully functional databases, no Stanby
> or RAC restrictions or additional licence costs etc. If you have a
> packaged 3rd party app, then my post is quite useless, but the idea
> should be ok.
> 
> Tanel.
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, July 10, 2003 8:59 PM
> 
> 
> > We're considering high availability options.  One of our
> requirements
> > is to be able to take one database offline (i.e., direct all
> > application connections to a second database server), perform
> database
> > and application upgrades, and perform a few hours' worth of tests
> > before bringing it back online.  We would then take the second
> database
> > offline and repeat the procedure.
> > 
> > We've tried Data Guard logical standby but it's incompatible with
> Label
> > Security (which we plan to run), presents performance problems, and
> has
> > a number of bugs.  We'd like to use the secondary database for
> > reporting as well, so a physical standby isn't practical.
> > 
> > RAC doesn't give us a second database copy.
> > 
> > Multimaster replication requires that changes to replicated objects
> be
> > made via DBMS_REPCAT.ALTER_MASTER_OBJECT, which propagates the
> changes
> > to all masters at once.
> > 
> > We haven't tested Streams yet.  
> > 
> > I'd be interested in hearing of any experiences from those who have
> the
> > same or similar requirements.
> > 
> > Paul Baumgartel
> > 
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Paul Baumgartel
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
--

Re: High availability and upgrades

[Paul Baumgartel]

It is our own application.  That's an interesting approach, thanks!


--- Tanel Poder <[EMAIL PROTECTED]> wrote:
> Hi!
> 
> Is this your own-written app?
> 
> If you want performance, control and no-data-loss reliability:
> 
> 1) Have 2 completely independent databases
> 2) Have your application servers multiplex
>all DML requests to both database servers
> 
>That means, if your client inserts something,
>then app layer does one insert on first DB 
>and the same insert in second DB too.
> 
>It can be more efficient than standby 
>database in maximum protection mode, 
>because DMLs are sent to databases 
>parallelly, not through primary to standby.
> 
>Depending on application you could commit
>done either when both servers acnowledge
>commit, or when only one acknowledges it.
>In that case you could check whether second
>instance managed to commit when next request
>is sent to it. That could give some 
>performance practically without losing any
>reliability features.
> 
>Also, since you now have two identical 
>databases, you can make your app servers
>load balance the selects.
> 
> 3) Before you shut down one database for 
>maintenance, you first configure your
>app servers to use only one database
>AND set change logging on on active DB.
>There are several ways for change logging,
>starting from customer triggers ending
>with logminer.
> 
> 4) When you bring second db up again you
>first synchronize all changes manually,
>several times if needed, and when the 
>log of changes is sufficiently low you
>just halt both app servers for very short
>time, do the final synchronization and
>activate both databases again.
> 
> If you upgrade your application, will you change the schema as well?
> Then you must move from physical to logical level, where you have
> some kind of mapping, which columns of old tables match columns in
> new tables.
> 
> That way you have two separate fully functional databases, no Stanby
> or RAC restrictions or additional licence costs etc. If you have a
> packaged 3rd party app, then my post is quite useless, but the idea
> should be ok.
> 
> Tanel.
> 
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, July 10, 2003 8:59 PM
> 
> 
> > We're considering high availability options.  One of our
> requirements
> > is to be able to take one database offline (i.e., direct all
> > application connections to a second database server), perform
> database
> > and application upgrades, and perform a few hours' worth of tests
> > before bringing it back online.  We would then take the second
> database
> > offline and repeat the procedure.
> > 
> > We've tried Data Guard logical standby but it's incompatible with
> Label
> > Security (which we plan to run), presents performance problems, and
> has
> > a number of bugs.  We'd like to use the secondary database for
> > reporting as well, so a physical standby isn't practical.
> > 
> > RAC doesn't give us a second database copy.
> > 
> > Multimaster replication requires that changes to replicated objects
> be
> > made via DBMS_REPCAT.ALTER_MASTER_OBJECT, which propagates the
> changes
> > to all masters at once.
> > 
> > We haven't tested Streams yet.  
> > 
> > I'd be interested in hearing of any experiences from those who have
> the
> > same or similar requirements.
> > 
> > Paul Baumgartel
> > 
> > 
> > __
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > -- 
> > Author: Paul Baumgartel
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like
> subscribing).
> > 


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  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 OR

ORA-01722 while using sqlldr

[Saira Somani-Mendelin]

I'm hoping for expert assistance. I'm using SQL*Loader to load some
2200+ records (comma delimited) into a table and running into this
problem for the modcnt field:

The control file reads:

modcnt DECIMAL EXTERNAL <-- I'm sure this is where my problem is. I have
tried almost every datatype that the control file will accept - some
bleed into the next column which is a date field, messing up that
column, etc with ORA-01841 (full) year must be between -4713 and +,
and not be 0.

The datatype in the table is:

MODCNT NUMBER <-- no precision defined

The value in the file for this field is always 0. And when I start to
load the file, I receive this error (I'm testing with a few random
records from the 2200+ and each have the same error):

Record 1: Rejected - Error on table LC_F, column MODCNT.
ORA-01722: invalid number

Any help is greatly appreciated. Thanks,
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.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: RAC time clocks (sysdate)

[Jamadagni, Rajendra]

Title: RE: RAC time clocks (sysdate)





Yup ... we got redundant time servers on dedicated boxes ... they feed to unix/windowz clients. No production boxes are EVER exposed to ANYTHING outside a firewall.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 10, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: RAC time clocks (sysdate)



Exactly.  Surf over to http://www.ntp.org and follow the links to download
(binaries or source), install, and configure.


If it were me doing it, I'd probably setup an existing local non-RAC
Internet-connected server (if available) with ntp to sync to an external
stratum-2 server (see ntp docs for definition of "stratum-2") over the
Internet, then have ntp on the RAC nodes use that local box as their ntp
server.  Then again, I don't do this much...


GL!  :)


Rich


Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

Re: High availability and upgrades

[Tanel Poder]

Hi!
 
Is this your own-written app?
 
If you want performance, control and 
no-data-loss reliability:
 
1) Have 2 completely independent 
databases
2) Have your application servers 
multiplex
   all DML requests to both 
database servers
    
   That means, if your 
client inserts something,
   then app layer does one insert 
on first DB 
   and the same insert in 
second DB too.
    
   It can be more efficient 
than standby 
   database in maximum 
protection mode, 
   because DMLs are sent to 
databases 
   parallelly, not through 
primary to standby.
 
   Depending on application you 
could commit
   done either when both servers 
acnowledge
   commit, or when only one 
acknowledges it.
   In that case you could check 
whether second
   instance managed to commit 
when next request
   is sent to it. That could 
give some 
   performance practically 
without losing any
   reliability 
features.
 
   Also, since you now have 
two identical 
   databases, you 
can make your app servers
   load balance 
the selects.
 
3) Before you shut down one database for 

   maintenance, you first 
configure your
   app servers to use only one 
database
   AND set change logging on on 
active DB.
   There are several ways for 
change logging,
   starting from customer 
triggers ending
   with logminer.
 
4) When you bring second db up again 
you
   first synchronize all changes 
manually,
   several times if needed, and 
when the 
   log of changes is sufficiently 
low you
   just halt both app servers for 
very short
   time, do the final 
synchronization and
   activate both databases 
again.
 
If you upgrade your application, will you 
change the schema as well?
Then you must move from physical to logical 
level, where you have some kind of mapping, which columns of old tables match 
columns in new tables.
 
That way you have two separate fully 
functional databases, no Stanby or RAC restrictions or additional licence costs 
etc. If you have a packaged 3rd party app, then my post is quite useless, but 
the idea should be ok.
 
Tanel.
 
 
- Original Message - 
From: "Paul Baumgartel" <[EMAIL PROTECTED]>
To: "Multiple recipients of list ORACLE-L" 
<[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2003 8:59 PM
Subject: High availability and 
upgrades
> We're considering high availability options.  One of our 
requirements> is to be able to take one database offline (i.e., direct 
all> application connections to a second database server), perform 
database> and application upgrades, and perform a few hours' worth of 
tests> before bringing it back online.  We would then take the 
second database> offline and repeat the procedure.> > We've 
tried Data Guard logical standby but it's incompatible with Label> 
Security (which we plan to run), presents performance problems, and has> 
a number of bugs.  We'd like to use the secondary database for> 
reporting as well, so a physical standby isn't practical.> > RAC 
doesn't give us a second database copy.> > Multimaster replication 
requires that changes to replicated objects be> made via 
DBMS_REPCAT.ALTER_MASTER_OBJECT, which propagates the changes> to all 
masters at once.> > We haven't tested Streams yet.  > 
> I'd be interested in hearing of any experiences from those who have 
the> same or similar requirements.> > Paul 
Baumgartel> > > __> 
Do you Yahoo!?> SBC Yahoo! DSL - Now only $29.95 per month!> 
http://sbc.yahoo.com> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net> -- 
> Author: Paul Baumgartel>   INET: [EMAIL PROTECTED]> > 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com> San 
Diego, California    -- Mailing list and 
web hosting services> 
-> To 
REMOVE yourself from this mailing list, send an E-Mail message> to: 
[EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in> the message BODY, include a line 
containing: UNSUB ORACLE-L> (or the name of mailing list you want to be 
removed from).  You may> also send the HELP command for other 
information (like subscribing).> 

RE: RAC time clocks (sysdate)

[Nick Wagner]

Title: RE: RAC time clocks (sysdate)



thanks! 
-Original Message-From: Jamadagni, Rajendra 
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 10, 2003 
10:40 AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: RAC time clocks (sysdate)
Our sysadmins use ntp or something like that .. 
Raj  
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! 

-Original Message- From: Nick 
Wagner [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, July 10, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: 
RAC time clocks (sysdate) 
In a RAC environment, what is the best way to synchronize the 
time clocks on the nodes?   It seams I came across a case where select 
sysdate from dual; produced two different values. 
Thanks! 
Nick 
-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.net 
-- Author: Nick Wagner   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California    
-- Mailing list and web hosting services - 
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT spelling of 
'ListGuru') and in the message BODY, include a line 
containing: UNSUB ORACLE-L (or the name of mailing list 
you want to be removed from).  You may also send 
the HELP command for other information (like subscribing). 

RE: RAC time clocks (sysdate)

[Jesse, Rich]

Exactly.  Surf over to http://www.ntp.org and follow the links to download
(binaries or source), install, and configure.

If it were me doing it, I'd probably setup an existing local non-RAC
Internet-connected server (if available) with ntp to sync to an external
stratum-2 server (see ntp docs for definition of "stratum-2") over the
Internet, then have ntp on the RAC nodes use that local box as their ntp
server.  Then again, I don't do this much...

GL!  :)

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


-Original Message-
Sent: Thursday, July 10, 2003 12:40 PM
To: Multiple recipients of list ORACLE-L


Our sysadmins use ntp or something like that ... 
Raj 

 
Rajendra dot Jamadagni at nospamespn dot com 
All Views expressed in this email are strictly personal. 
QOTD: Any clod can have facts, having an opinion is an art ! 


-Original Message- 
Sent: Thursday, July 10, 2003 1:09 PM 
To: Multiple recipients of list ORACLE-L 


In a RAC environment, what is the best way to synchronize the time clocks on
the nodes?   It seams I came across a case where select sysdate from dual;
produced two different values. 
Thanks! 
Nick 
-- 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  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).

High availability and upgrades

[Paul Baumgartel]

We're considering high availability options.  One of our requirements
is to be able to take one database offline (i.e., direct all
application connections to a second database server), perform database
and application upgrades, and perform a few hours' worth of tests
before bringing it back online.  We would then take the second database
offline and repeat the procedure.

We've tried Data Guard logical standby but it's incompatible with Label
Security (which we plan to run), presents performance problems, and has
a number of bugs.  We'd like to use the secondary database for
reporting as well, so a physical standby isn't practical.

RAC doesn't give us a second database copy.

Multimaster replication requires that changes to replicated objects be
made via DBMS_REPCAT.ALTER_MASTER_OBJECT, which propagates the changes
to all masters at once.

We haven't tested Streams yet.  

I'd be interested in hearing of any experiences from those who have the
same or similar requirements.

Paul Baumgartel


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

how to calculate total foreground time

[A.Bahar]

Title: Message



is 
following correct ,
 'total foreground time' = 'cpu used by this session' 
+ 'total of Foreground Wait times' 
or
 
 
is  'cpu used by 
this session'  includes also   'total of Foreground 
Wait times'

OT: OAUG Database SIG Elections

[Michael Brown]

The Oracle Applications Users Group Database SIG will be holding elections
for Vice Chairman and Secretary on September 14 at the OAUG conference in
San Diego.  If anyone is interested in being an officer, please go to our
website for more information (http://datasig.oaug.org).

 --
Michael Brown   Glen Raven, Inc./Info Services
Chairman, OAUG DB SIG   1831 N. Park Ave
Phone: (336)586-1146Glen Raven, NC 27217
Fax: (336)586-1382  [EMAIL PROTECTED]

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

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

RE: RAC time clocks (sysdate)

[Jamadagni, Rajendra]

Title: RE: RAC time clocks (sysdate)





Our sysadmins use ntp or something like that ...


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Nick Wagner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 10, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RAC time clocks (sysdate)



In a RAC environment, what is the best way to synchronize the time clocks on the nodes?   It seams I came across a case where select sysdate from dual; produced two different values. 

Thanks! 


Nick


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nick Wagner
  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).



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: RAC system Calls

[Matthew Zito]

And are you using jumbo frames on your interconnect?  That can make a
significant contribution to reducing overhead from a system standpoint.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
> Behalf Of K Gopalakrishnan
> Sent: Thursday, July 10, 2003 11:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RAC system Calls
> 
> 
> Ravi:
> 
> Do you have a statspack report? I would like to see that. But 
> in any case, 45% kernel is just too much?
> 
> BTW have you verified the private interconnect is used 
> for cache fusion transfer.. Make sure the cache fusion
> is not going thru the public network.
> 
> 
> 
> Best Regards,
> K Gopalakrishnan
> 
>  
> 
> 
> -Original Message-
> Ravi Kulkarni
> Sent: Thursday, July 10, 2003 9:30 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello List,
> 
> We are running Benchmark tests on Solaris 2-Node RAC. 
> Consistently noticed the following :
> - Very high Kernel usage (averaging 45%) on TOP 
> - Statspack has "IPC Send Completion sync" waits (70%
> Total ela time)
> - On trussing top process, found Oracle to be issuing
> huge number of "times" system calls in addition to 
> read/writes(which I think are select/inserts). Has anyone 
> noticed this in your environment. I am guessing these to be 
> inter-instance pings, but could not get any hits in 
> Doc/Metalink to confirm this. "times" call is clocking lot of 
> CPU. Is this normal ? 
> Any pointers would be helpful ? If this is out of
> context, is there a separate list for RAC?
> 
> Thanks,
> Ravi.
> 
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Ravi Kulkarni
>   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: K Gopalakrishnan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
> and in the message BODY, include a line containing: UNSUB 
> ORACLE-L (or the name of mailing list you want to be removed 
> from).  You may also send the HELP command for other 
> information (like subscribing).
> 

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

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

Time Accounting Application

[Goulet, Dick]

To ALL,

If any of you have an Time accounting application in house called Smart Time, 
would you please reply privately? I've a few questions.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: [EMAIL PROTECTED]

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

RE: RAC system Calls

[Jamadagni, Rajendra]

Title: RE: RAC system Calls





You seem to have timed_statistics=TRUE right ?? in RAC you will ALWAYS see GCS pings ... basically as long as cluster_database=true, even if only one node is running, you will still see Oracle trying to ping other instances.

My guess is that's what is happening ... but I could be very well wrong, I have RAC experience, but never tried to truss the top processes.

Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Ravi Kulkarni [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 10, 2003 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RAC system Calls



Hello List,


We are running Benchmark tests on Solaris 2-Node RAC.
Consistently noticed the following :
- Very high Kernel usage (averaging 45%) on TOP 
- Statspack has "IPC Send Completion sync" waits (70%
Total ela time)
- On trussing top process, found Oracle to be issuing
huge number of "times" system calls in addition to
read/writes(which I think are select/inserts).
Has anyone noticed this in your environment. I am
guessing these to be inter-instance pings, but could
not get any hits in Doc/Metalink to confirm this.
"times" call is clocking lot of CPU. Is this normal ? 
Any pointers would be helpful ? If this is out of
context, is there a separate list for RAC?


Thanks,
Ravi.




__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  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).



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

Re: RAC system Calls

[Mladen Gogala]

I had a similar experience on OPS when we tried with
releasable locks. What is the platform? What kind of
interconnect do you have?
On 2003.07.10 12:44, K Gopalakrishnan wrote:
Ravi:

Do you have a statspack report? I would like to see that. But
in any case, 45% kernel is just too much?
BTW have you verified the private interconnect is used
for cache fusion transfer.. Make sure the cache fusion
is not going thru the public network.


Best Regards,
K Gopalakrishnan


-Original Message-
Ravi Kulkarni
Sent: Thursday, July 10, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L
Hello List,

We are running Benchmark tests on Solaris 2-Node RAC.
Consistently noticed the following :
- Very high Kernel usage (averaging 45%) on TOP
- Statspack has "IPC Send Completion sync" waits (70%
Total ela time)
- On trussing top process, found Oracle to be issuing
huge number of "times" system calls in addition to
read/writes(which I think are select/inserts).
Has anyone noticed this in your environment. I am
guessing these to be inter-instance pings, but could
not get any hits in Doc/Metalink to confirm this.
"times" call is clocking lot of CPU. Is this normal ?
Any pointers would be helpful ? If this is out of
context, is there a separate list for RAC?
Thanks,
Ravi.


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ravi Kulkarni
  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: K Gopalakrishnan
  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).
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
 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).

RAC time clocks (sysdate)

[Nick Wagner]

In a RAC environment, what is the best way to synchronize the time clocks on the 
nodes?   It seams I came across a case where select sysdate from dual; produced two 
different values. 

Thanks! 

Nick

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

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

RE: RAC system Calls

[K Gopalakrishnan]

Ravi:

Do you have a statspack report? I would like to see that. But 
in any case, 45% kernel is just too much?

BTW have you verified the private interconnect is used 
for cache fusion transfer.. Make sure the cache fusion
is not going thru the public network.



Best Regards,
K Gopalakrishnan

 


-Original Message-
Ravi Kulkarni
Sent: Thursday, July 10, 2003 9:30 AM
To: Multiple recipients of list ORACLE-L


Hello List,

We are running Benchmark tests on Solaris 2-Node RAC.
Consistently noticed the following :
- Very high Kernel usage (averaging 45%) on TOP 
- Statspack has "IPC Send Completion sync" waits (70%
Total ela time)
- On trussing top process, found Oracle to be issuing
huge number of "times" system calls in addition to
read/writes(which I think are select/inserts).
Has anyone noticed this in your environment. I am
guessing these to be inter-instance pings, but could
not get any hits in Doc/Metalink to confirm this.
"times" call is clocking lot of CPU. Is this normal ? 
Any pointers would be helpful ? If this is out of
context, is there a separate list for RAC?

Thanks,
Ravi.



__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  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: K Gopalakrishnan
  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 on a mainframe (MVS)

[Stephane Paquette]

Title: Message



I've 
started with Oracle 5 on MVS a very long time ago, ProCobol was 
there.
It is 
probably still there since it is the most popular language on 
mainframes.
 



Stephane Paquette
Administrateur 
de bases de donnees
Database 
Administrator
Standard 
Life
www.standardlife.ca
Tel. 
(514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED]

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]On Behalf Of Terrian, Tom (Contractor) 
  (DAASC)Sent: Thursday, July 10, 2003 12:00 PMTo: 
  Multiple recipients of list ORACLE-LSubject: Oracle on a mainframe 
  (MVS)
  
  We have a future 
  need to create an Oracle database on a mainframe (MVS) which will then 
  pull data from an Oracle database on an HPUX box.  I know nothing about 
  MVS so does anyone know of any connectivity problems between the two 
  boxes?  For example, SQL*Net does come with the server on MVS, 
  correct?  Does Pro*Cobol also exist on MVS?  Would the 
  connection from MVS to HPUX be a simple as creating 
  a database link or are there more problems than 
  that?
   
  Any help would be 
  appreciated.
   
  Thanks,
  Tom

RE: Multiple addreses in tns

[Wolfgang Breitling]

Works for me. I just did a the test on Oracle 8.1.7. Here is the trace 
file. Note the "nsopen: unable to open transport" after trying to find host 
fleming. Then it goes on to try host altair which succeeds. One thing 
though. The host must not exist or be unreachable. If the host is reachable 
but the listener for the requested port is down then the connection fails 
without trying a second address with a different port. You can not fail 
over to a different port on the same server.

nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbni: Unable to get data from navigation file tnsnav.ora
nnftmlf_make_local_addrfile: construction of local names file failed
nnftmlf_make_system_addrfile: system names file is 
c:\oracle\network\admin\tnsnames.ora
niotns: niotns: setting up interrupt handler...
niotns: Not trying to enable dead connection detection.
niotns: Calling address: 
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=fleming)(Port=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=altair)(PORT=1526))(ADDRESS=(PROTOCOL=NMP)(SERVER=altair)(PIPE=ORAPIPE)))(SDU=16384)(TDU=16384)(CONNECT_DATA=(SID=stats)(CID=(PROGRAM=C:\ora81\bin\SQLPLUSW.EXE)(HOST=ALTAIR)(USER=Administrator
nscall: connecting...
nttbnd2addr: port resolved to 1526
nttbnd2addr: looking up IP addr for host: fleming
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 352.
ntt2err: soc 352 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, 
ntresnt[2]=0
nserror: nsres: id=0, op=65, ns=12535, ns2=12560; nt[0]=505, nt[1]=60, 
nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nsopen: unable to open transport
nttbnd2addr: port resolved to 1526
nttbnd2addr: looking up IP addr for host: altair
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 356.
nttcon: set TCP_NODELAY on 356
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61
nsopen: global context check-in (to slot 0) complete
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: got NSPTRD packet
nscall: redirected
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 0) complete
nscall: connecting...
nttbnd2addr: port resolved to 1151
nttbnd2addr: using host IP address: 172.20.230.237
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcni: trying to connect to socket 364.
nttcon: set TCP_NODELAY on 364
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61
nsopen: global context check-in (to slot 0) complete
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nscon: got NSPTAC packet
nscon: doing connect handshake...

At 06:54 AM 7/10/2003 -0800, you wrote:
Thanks Rachael

Getting some more feedback on this
"
What this appears to be is a cluster configuration with a middle ware
capability ( like Oracle FailSafe) to fail a database over from one node
to its backup. This would be the reason each IP is configured with two
ports.
"
That sounds reasonable Although my docs souw mulitple ADDRESS_LIST =
eg for parrallel or cluster server.
However if I performd the simple test below, as is it- fails, if I place
valid first, it connects. Which raised my concern of Oracle not going to
"the next address"
??

locdb =
  (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = invalid)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = valid)(PORT = 1521))
)
(CONNECT_DATA =
  (SERVICE_NAME = locdb)
)
  )
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 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 on a mainframe (MVS)

[Terrian, Tom (Contractor) (DAASC)]

Title: Message



great, 
thanks Allan

  
  -Original Message-From: Nelson, Allan 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 12:19 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Oracle on a mainframe (MVS)
  I 
  have done a little of this.  TNS is there but I don't know about 
  Pro*Cobol, I would assume so.  Database links between MVS and HPUX work 
  as expected.
   
  Allan
  

-Original Message-From: Terrian, Tom 
(Contractor) (DAASC) [mailto:[EMAIL PROTECTED] Sent: Thursday, 
July 10, 2003 11:00 AMTo: Multiple recipients of list 
ORACLE-LSubject: Oracle on a mainframe (MVS)

We have a future 
need to create an Oracle database on a mainframe (MVS) which will then 
pull data from an Oracle database on an HPUX box.  I know nothing about 
MVS so does anyone know of any connectivity problems between the two 
boxes?  For example, SQL*Net does come with the server on 
MVS, correct?  Does Pro*Cobol also exist on MVS?  Would the 
connection from MVS to HPUX be a simple as creating 
a database link or are there more problems than 
that?
 
Any help would 
be appreciated.
 
Thanks,
Tom
  __This 
  email is intended solely for the person or entity to which it is addressed and 
  may contain confidential and/or privileged information. Copying, forwarding or 
  distributing this message by persons or entities other than the addressee is 
  prohibited. If you have received this email in error, please contact the 
  sender immediately and delete the material from any computer. This email may 
  have been monitored for policy compliance. 
[021216]

RAC system Calls

[Ravi Kulkarni]

Hello List,

We are running Benchmark tests on Solaris 2-Node RAC.
Consistently noticed the following :
- Very high Kernel usage (averaging 45%) on TOP 
- Statspack has "IPC Send Completion sync" waits (70%
Total ela time)
- On trussing top process, found Oracle to be issuing
huge number of "times" system calls in addition to
read/writes(which I think are select/inserts).
Has anyone noticed this in your environment. I am
guessing these to be inter-instance pings, but could
not get any hits in Doc/Metalink to confirm this.
"times" call is clocking lot of CPU. Is this normal ? 
Any pointers would be helpful ? If this is out of
context, is there a separate list for RAC?

Thanks,
Ravi.



__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  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 on a mainframe (MVS)

[Nelson, Allan]

Title: Message



I have 
done a little of this.  TNS is there but I don't know about Pro*Cobol, I 
would assume so.  Database links between MVS and HPUX work as 
expected.
 
Allan

  
  -Original Message-From: Terrian, Tom 
  (Contractor) (DAASC) [mailto:[EMAIL PROTECTED] Sent: Thursday, 
  July 10, 2003 11:00 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Oracle on a mainframe (MVS)
  
  We have a future 
  need to create an Oracle database on a mainframe (MVS) which will then 
  pull data from an Oracle database on an HPUX box.  I know nothing about 
  MVS so does anyone know of any connectivity problems between the two 
  boxes?  For example, SQL*Net does come with the server on MVS, 
  correct?  Does Pro*Cobol also exist on MVS?  Would the 
  connection from MVS to HPUX be a simple as creating 
  a database link or are there more problems than 
  that?
   
  Any help would be 
  appreciated.
   
  Thanks,
  Tom

__
This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information.  Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer.  This email may have been monitored for policy compliance.  [021216]

9iAs rel1 1.0.2.2.2.

[Singh Pushpinder]

--_=_NextPart_001_01C346F5.C2C8F737
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

All,
=20
=20
We are implementing portal 9iAS rel1 and for the failover purposes we are t=
rying to find out if it is possible to have the two nodes (iAS homes) point=
ing to the same database at the same time.
If yes, is it possible to have two nodes  ( iAS homes) active all the time =
for load balancing/failover for listening the requests. We have a web switc=
h which has the capability to run these two nodes in parallel. Along with t=
hat it also keep on checking the healthcheck of both the nodes and sendd th=
e requests to a node which has lesser load. My questions is Is it possible =
to have both the nodes up and running pointing to the same database at the =
same time.
=20
Any input is apprecitated.
=20
It is better if you can send me some kind of documenttaion/links.
=20
Regards,
Inder





--_=_NextPart_001_01C346F5.C2C8F737
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable




Message




All,
 
 
We are im=
plementing=20
portal 9iAS rel1 and for the failover purposes we are trying to find out if=
 it=20
is possible to have the two nodes (iAS homes) pointing to the same database=
 at=20
the same time.
If=20
yes, is it possible to have two nodes&nb=
sp; ( iAS=20
homes) active all the time for load balancing/failover for listening the=20
requests. We have =
a web=20
switch which has the capability to run these two nodes in parallel. Along w=
ith=20
that it also keep on checking the healthcheck of both the nodes and sendd t=
he=20
requests to a node which has lesser load. My questions is Is it possible to=
 have=20
both the nodes up and running pointing to the same database at the same=20
time.
 
Any input is=20
apprecitated.
 
It is better if you can send me some kind=
 of=20
documenttaion/links.
 
Regards,
Inder





--_=_NextPart_001_01C346F5.C2C8F737--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Singh Pushpinder
  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: Location of trace files and alert log

[Jamadagni, Rajendra]

Title: Location of trace files and alert log



Yes there are ...
 
Originally called ... SAVE_ALERT_LOGFILE_DIR and SAVE_USER_TRACEFILE_DIR 
... but they were replaced with various *_DUMP_DEST parameters ... because the 
committee who certifies and performs code reviews didn't have sense of 
humor.
 
ps: look for various DUMP_DEST paramaters ...
Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Nguyen, David M 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, July 10, 2003 11:44 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Location of trace files and alert log
  How do I locate where 
  all trace files and alert log are saved?  There is no parameter setup in 
  init.ora file.
  Thanks,
  David
*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

Re: Location of trace files and alert log

[Joe Testa]

query v$parameter?

joe

Nguyen, David M wrote:

How do I locate where all trace files and alert log are saved?  There 
is no parameter setup in init.ora file.

Thanks,

David

--
Joseph S Testa
Chief Technology Officer 
Data Management Consulting
p: 614-791-9000
f: 614-791-9001

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

Oracle on a mainframe (MVS)

[Terrian, Tom (Contractor) (DAASC)]

Title: Message




We have a future 
need to create an Oracle database on a mainframe (MVS) which will then pull 
data from an Oracle database on an HPUX box.  I know nothing about MVS so 
does anyone know of any connectivity problems between the two boxes?  For 
example, SQL*Net does come with the server on MVS, correct?  Does 
Pro*Cobol also exist on MVS?  Would the connection from MVS 
to HPUX be a simple as creating a database link or are there 
more problems than that?
 
Any help would be 
appreciated.
 
Thanks,
Tom

RE: Location of trace files and alert log

[Erik Williams]

Title: Location of trace files and alert log



SQL>show parameter background_dump_dest
SQL>show parameter user_dump_dest

  -Original Message-From: Nguyen, David M 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, July 10, 2003 11:44 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  Location of trace files and alert log
  How do I locate where 
  all trace files and alert log are saved?  There is no parameter setup in 
  init.ora file.
  Thanks,
  David

Location of trace files and alert log

[Nguyen, David M]

Title: Location of trace files and alert log






How do I locate where all trace files and alert log are saved?  There is no parameter setup in init.ora file.

Thanks,

David

RE: Do Not Call

[DENNIS WILLIAMS]

Stephen
 From what I understand from our Web administrator, the netcraft site
just reports the web server that is used, not the application server or
database. 



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 11:16 AM
To: Multiple recipients of list ORACLE-L



http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov
 

 
Well, if it were unix then it couldn't be SQLserver.  It is Windows,
therefore I assume its SQLserver, but it could be Oracle.  But who runs
Oracle on Windows anyway *hahahaha* 
 
... We do ...   -- Steve Wolfe

>>> [EMAIL PROTECTED] 07/01/03 02:29PM >>>


Paradox for DOS 



-Original Message- 
Sent: Tuesday, July 01, 2003 2:00 PM 
To: Multiple recipients of list ORACLE-L 


There have been over 10,000,000 entries made in the National Do Not Call 
Registry since Friday June 27. Does anyone know the database engine in 
which this is stored? 


Curious in Bozeman, MT 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
  
-- 
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.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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

RE: Multiple addreses in tns

[Bob Metelsky]

Thanks Rachael

Getting some more feedback on this
"
What this appears to be is a cluster configuration with a middle ware
capability ( like Oracle FailSafe) to fail a database over from one node
to its backup. This would be the reason each IP is configured with two
ports.
"
That sounds reasonable Although my docs souw mulitple ADDRESS_LIST =
eg for parrallel or cluster server.

However if I performd the simple test below, as is it- fails, if I place
valid first, it connects. Which raised my concern of Oracle not going to
"the next address"

??


locdb =
  (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = invalid)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = valid)(PORT = 1521))
)
(CONNECT_DATA =
  (SERVICE_NAME = locdb)
)
  )


> it's valid.
> 
> if there is no response on the first port, Oracle tries the 
> next etc etc etc. It's a means of failover or allowing for 
> continuity of connections while doing  maintenance on a 
> listener or server
> 
> --- Bob Metelsky <[EMAIL PROTECTED]> wrote:
> > Is having multiple addresses valid for a tns entry?
> > 
> > A client provided this to me and initailly looked invalid
> > 
> > alias =
> >   (DESCRIPTION =
> > (ADDRESS_LIST =
> >   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521))
> >   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526))
> >   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521))
> >   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526))
> >   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521))
> >   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526))
> > )
> > (CONNECT_DATA = (SID = name)(SERVER = DEDICATED))
> >   )
> > 
> > 
> > From initial testing, if the first server is not avaliable 
> the entire 
> > connect fails. Personally Ive never seen this and from checking my 
> > reference, this does NOT seem to be valid
> > 
> > Any input would be most welcome
> > 
> > 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).
> 
> 
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Rachel Carmichael
>   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: 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).

RE: Multiple addreses in tns

[Gogala, Mladen]

Add FAILOVER=ON and it will check the next address if the previous
one has failed. Alternatively, use SOURCE_ROUTE=ON and it will check 
every single one of them if the previous one fails.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, July 10, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L


Is having multiple addresses valid for a tns entry?

A client provided this to me and initailly looked invalid

alias =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526))
)
(CONNECT_DATA = (SID = name)(SERVER = DEDICATED))
  )


>From initial testing, if the first server is not avaliable the entire
connect fails. Personally Ive never seen this and from checking my
reference, this does NOT seem to be valid

Any input would be most welcome

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: Gogala, Mladen
  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: Multiple addreses in tns

[Jack van Zanen]

I think this is used in Parallel server environments. I have seen something
similar (maybe not exactly) so it could well be valid. My understanding is
that it should be working it's way down the list or pick a random address
depending on  (not much experience with OPS/RAC)

Jack

-Original Message-
Sent: Thursday, July 10, 2003 4:19 PM
To: Multiple recipients of list ORACLE-L


Is having multiple addresses valid for a tns entry?

A client provided this to me and initailly looked invalid

alias =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526))
)
(CONNECT_DATA = (SID = name)(SERVER = DEDICATED))
  )


>From initial testing, if the first server is not avaliable the entire
connect fails. Personally Ive never seen this and from checking my
reference, this does NOT seem to be valid

Any input would be most welcome

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: Jack van Zanen
  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: Multiple addreses in tns

[Rachel Carmichael]

it's valid.

if there is no response on the first port, Oracle tries the next etc
etc etc. It's a means of failover or allowing for continuity of
connections while doing  maintenance on a listener or server

--- Bob Metelsky <[EMAIL PROTECTED]> wrote:
> Is having multiple addresses valid for a tns entry?
> 
> A client provided this to me and initailly looked invalid
> 
> alias =
>   (DESCRIPTION =
> (ADDRESS_LIST =
>   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521))
>   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526))
>   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521))
>   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526))
>   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521))
>   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526))
> )
> (CONNECT_DATA = (SID = name)(SERVER = DEDICATED))
>   )
> 
> 
> From initial testing, if the first server is not avaliable the entire
> connect fails. Personally Ive never seen this and from checking my
> reference, this does NOT seem to be valid
> 
> Any input would be most welcome
> 
> 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).


__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  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).

Multiple addreses in tns

[Bob Metelsky]

Is having multiple addresses valid for a tns entry?

A client provided this to me and initailly looked invalid

alias =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.141.22)(PORT = 1526))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.34)(PORT = 1526))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.41.36)(PORT = 1526))
)
(CONNECT_DATA = (SID = name)(SERVER = DEDICATED))
  )


>From initial testing, if the first server is not avaliable the entire
connect fails. Personally Ive never seen this and from checking my
reference, this does NOT seem to be valid

Any input would be most welcome

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).

Re: Restricting access via sqlplus

[Pete Finnigan]

Hi Jacques,

It sounds like the encrypted password is read by the client? and
decrypted on the client? or in the database as a package procedure?. If
it was decrypted in the client and then the set role command was sent to
the database the password could be read from the network with a tool
such as snoop on Unix or using SQL*Net support level trace as that shows
packet contents in the SQL trace. The latter could be setup by a user on
his PC attempt a logon to the database and then read the password from
the trace file. 

If the decryption and set role were to be done in a package and the
password is not passed over the network then its better. You could also
encrypt the network traffic of course. But as you say there is still a
risk from someone discovering the encryption scheme. 

thanks for sharing your solution

kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

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

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

Re: trigger and LogMiner

[Tanel Poder]

Hi!

Maybe they were thinking that if you audit select statements, you can
analyze inserts on AUD$ using logminer later on

Anyway, if there's any future release where selects can be in redo, I hope
they aren't there by default..

Tanel.

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2003 2:19 PM


> Hi Arup and Joe
>
> When I wrote the SANS Oracle security step-by-step book I wrote in there
> the list of restrictions for log miner including that is didn't support
> selects and during the review process of my book someone in Oracle who
> was reviewing it informed me that selects would be in the redo in one of
> the 9i releases, so i changed the book to say fixed in 9i.
>
> To be honest I now agree with you, it doesn't make sense for selects to
> be in the redo, although i suppose they could include them if they
> wanted to.
>
> At least for 9iR1 I am sure they are not included as I did some tests 2
> or 3 weeks ago when i was writing a paper "detecting SQL injection on
> Oracle" for securityfocus.com and selects were definitely not recorded
> by logminer. I did not also dump the archive log to trace to see if
> there was no select in it but at least LogMiner does not recognise
> selects. I copied the list i posted from a file yesterday without
> thinking i was perpetuating this issue even though i saw myself a few
> weeks ago it wasn't true.
>
> kind regards
>
> Pete
>
> In article <[EMAIL PROTECTED]>, Arup Nanda
> <[EMAIL PROTECTED]> writes
> >Hi Pete,
> >
> >I am a little prerplexed by "selects are not recorded in redo prior to 9i
".
> >AFAIK selects are nevere recorded in the redo, and therefore archived
logs -
> >so they are never unearthed by LogMiner, even in 9i Release2. Isn't that
> >true?
> >
> >Thanks.
> >
> >Arup
> --
> Pete Finnigan
> email:[EMAIL PROTECTED]
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Pete Finnigan
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  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: Firewall -- ORA-12535: TNS:operation timed out

[Mladen Gogala]

If packets are dropped, increasing timeout will not help.
There are things in this world which cannot be done by
modifying oracle parameter values.
On 2003.07.10 05:19, Manoj Kumar Jha wrote:
also check the value of CONNECT_TIMEOUT_,
its default value is 10 (secs).
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2003 11:04 AM
Oh boy!
You need to fix that firewall. You should
a) allow your local nodes to go out on Oracle*Net port (and I advise against
1521, 1526 and 1527).
b) allow certain IP addresses to go in your LAN by using Oracle*Net port.
Second thing to do would be to have a SSL firewall and use Advanced
Networking
or, alternatively, configure Oracle*Net to tunnel through firewalls by using
ssh. The latter is described on in the following article by R. Schrag:
http://www.dbspecialists.com/presentations/net8_security.html
There are tons of options for you and I could easily write an article about
Oracle*Net and firewalls (Thermopilae in Greek). The best thing to do is to
read a few articles about firewalls and Oracle*Net until you find something
that fits your needs. It's half past midnight and I'm tired. May gods be
with
you. There was a guy named Leonidas who was the original security
administrator at the original firewall. Be brave, your work is much easier
then his was.
On 2003.07.10 00:44, Bob Robert wrote:
> Could someone share with me if you come across similar
> kind of configuration.
> --- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> > You obviously do need special configuration.
> > You are welcome.
> >
> > On 2003.07.08 17:09, Bob Robert wrote:
> > > All,
> > >
> > > I am getting following error message when I try to
> > > connect though firewall (from DMZ to Network).
> > >
> > > ORA-12535: TNS:operation timed out
> > >
> > > Do I need to do special configuration (like cman)
> > > around firewall?
> > >
> > > Thanks In Advance,
> > > Bob
> > >
> > >
> > >
> > > __
> > > Do you Yahoo!?
> > > SBC Yahoo! DSL - Now only $29.95 per month!
> > > http://sbc.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > > --
> > > Author: Bob Robert
> > >   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).
> > >
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Bob Robert
>   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).
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
  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 contai

Re: Moving LOB Storage and Index

[DEEDSD]

I seem to recall from Jonathan Lewis' book that moving a LOB index after
creation was possible in some versions of 8.0, but no longer possible in
8i.  Unfortunately, I don't have the book in front of me right now so I
can't say for sure.


   
   
  Munish Bajaj 
   
  <[EMAIL PROTECTED]> T
  
   To:   Multiple recipients of list 
ORACLE-L 
  Sent by: <[EMAIL PROTECTED]> 

  [EMAIL PROTECTED]cc: 
   
   
   
   bcc:
   
   Subject:
  Moving LOB   
  07/10/03 12:49 AMStorage and Index   
   
  Please respond to
   
  ORACLE-L 
   
   
   
   
   




Hi Listers,

I created a table containing a LOB Column (icon) with the following storage
clause :



LOB (ICON)


STORE AS (TABLESPACE QUARKDMS_BLOB


STORAGE(INITIAL 1M NEXT 5M)


CHUNK 4K PCTVERSION 10


NOCACHE LOGGING


INDEX (TABLESPACE QUARKDMS_INDEX


STORAGE (INITIAL 1M NEXT 1M))


DISABLE STORAGE IN ROW);


I want to move only the lob-Index from tablespace Quarkdms_index to a new
tablespace. Please let me know whether this is possible and the command for
the same.


Thanks to all


Best Regards


Munish Bajaj








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

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

RE: Restricting access via sqlplus

[Simon . Anderson]

We used a similar idea on an in-house application - hard-coded the role 
password into the application.

Neither approach is perfect, if someone wanted to try hard enough they 
could reverse-engineer the app, or try and pick up the password by spying 
on the sql*net connection. 

For practical security, you need to back these schemes up with auditing 
failed logons, audit triggers to record who made changes to data, etc.

Simon Anderson






"Jacques Kilchoer" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/07/2003 01:29
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: Restricting access via sqlplus


To prevent these kinds of problems, the only solution I've ever thought 
was feasible was how we implemented it at a previous company of mine.

Our solution:
Each user would be granted a role, but the role would not be a default 
role. The role was protected by a password. The application would connect 
to the database, read the encrypted password for the role from a database 
table, use a two-way decryption scheme to decrypt the password, and then 
use the "set role" command to give the user the role that would allow 
insert/update/delete to be done from inside the application.

The same could not be accomplished from inside SQL*Plus or Toad because 
the user would not know the password to use for the "set role" command. 
The role password could be changed as often as deemed necessary, except 
that the new password would have to be stored in the database in an 
encrypted form.

This scheme has an obvious flaw, that anyone able to crack the encryption 
scheme could decrypt the role password, do a "set role" and then issue DML 
commands from inside a SQL client. And it would only work if you are 
building and deploying your own in-house application. But at the time we 
could not think of anything better. This was using Oracle 8.0.



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

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

Re: trigger and LogMiner

[Pete Finnigan]

Hi Arup and Joe

When I wrote the SANS Oracle security step-by-step book I wrote in there
the list of restrictions for log miner including that is didn't support
selects and during the review process of my book someone in Oracle who
was reviewing it informed me that selects would be in the redo in one of
the 9i releases, so i changed the book to say fixed in 9i. 

To be honest I now agree with you, it doesn't make sense for selects to
be in the redo, although i suppose they could include them if they
wanted to. 

At least for 9iR1 I am sure they are not included as I did some tests 2
or 3 weeks ago when i was writing a paper "detecting SQL injection on
Oracle" for securityfocus.com and selects were definitely not recorded
by logminer. I did not also dump the archive log to trace to see if
there was no select in it but at least LogMiner does not recognise
selects. I copied the list i posted from a file yesterday without
thinking i was perpetuating this issue even though i saw myself a few
weeks ago it wasn't true.

kind regards

Pete

In article <[EMAIL PROTECTED]>, Arup Nanda
<[EMAIL PROTECTED]> writes
>Hi Pete,
>
>I am a little prerplexed by "selects are not recorded in redo prior to 9i ".
>AFAIK selects are nevere recorded in the redo, and therefore archived logs -
>so they are never unearthed by LogMiner, even in 9i Release2. Isn't that
>true?
>
>Thanks.
>
>Arup
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

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

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

RE: Tech meetings

[Robson, Peter]

--_=_NextPart_001_01C346BE.A37BB570
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Didn't this guy get himself an entry in the Darwin awards? Sounds
familiar...=20


A R&R jet engine in a car Cute idea! There is an urban legend about a
military guy who tried=20
to mount a JATO rocket on his Chevy Impala (nothing so fancy as R & R). It
didn't end up
very good for him. May be he should have tried with R & R jet engine.
=20

Mladen Gogala=20
Oracle DBA=20
Phone:(203) 459-6855=20
Email:[EMAIL PROTECTED]

-Original Message-
Sent: Wednesday, July 09, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L



Okay ... so you don't get a car ... do you at-least get an engine once in
say 5 years ??=20

Same thing happens to me, I always get the question .. "Do you get tickets
to all the games?" the answer is a big NO. We may get to see them on our
internal cable network, but unless you are good spending ($$) advertiser
tickets are unlikely .. or if you win them in a contest.

Raj=20

=20
Rajendra dot Jamadagni at nospamespn dot com=20
All Views expressed in this email are strictly personal.=20
QOTD: Any clod can have facts, having an opinion is an art !=20


-Original Message-=20
 ]=20
Sent: Wednesday, July 09, 2003 2:15 PM=20
To: Multiple recipients of list ORACLE-L=20


I wish.  I always get that question.  I work at a gear box manufacturing=20
plant which primarily manufactures gear boxes for jet engines.  Rolls-Royce=
 plc doesn't even make the cars anymore. In "1998 Rolls-Royce Motor Cars wa=
s=20
sold by Vickers to Volkswagen, although BMW hold the rights to the name and=
 the marque for use on Rolls-Royce cars, having acquired the rights from=20
Rolls-Royce plc for =A340m in 1998. BMW will take over responsibility for=
 Rolls-Royce cars from the beginning of 2003."=20
http://www.rolls-royce.com/history/timeline/default.htm
 =20

Jeff Eberhard=20
Database Administrator=20
Rolls-Royce Gear Systems=20
Park City, Utah=20



*
This  e-mail  message,  and  any  files  transmitted  with  it, are
confidential  and intended  solely for the  use of the  addressee. If
this message was not addressed to  you, you have received it in error
and any  copying,  distribution  or  other use  of any part  of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent  those of the British
Geological  Survey. The  security of e-mail  communication  cannot be
guaranteed and the BGS accepts no liability  for claims arising as a
result of the use of this medium to  transmit messages from or to the
BGS. .http://www.bgs.ac.uk
*


--_=_NextPart_001_01C346BE.A37BB570
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable




RE: Tech meetings



Didn't =
this guy=20
get himself an entry in the Darwin awards? Sounds=20
familiar... 

  A=20
  R&R jet engine in a car Cute idea! There is an urban legend about=
 a=20
  military guy who tried 
  to=20
  mount a JATO rocket on his Chevy Impala (nothing so fancy as R & R). =
It=20
  didn't end up
  very=20
  good for him. May be he should have tried with R & R jet=20
  engine.
   
  Mladen Gogala Oracle DBA Phone:(203)=20
  459-6855 Email:[EMAIL PROTECTED] 
  
-Original Message-From: Jamadagni, Rajendra=
 [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 0=
9,=20
2003 2:34 PMTo: Multiple recipients of list=20
ORACLE-LSubject: RE: Tech meetings
Okay ... so you don't get a car ... do you at-least g=
et an=20
engine once in say 5 years ?? 
Same thing happens to me, I always get the question .=
. "Do=20
you get tickets to all the games?" the answer is a big NO. We may get t=
o see=20
them on our internal cable network, but unless you are good spending=20
($$) advertiser tickets are unlikely .. or if you win them in a=20
contest.
Raj --=
--=20
Rajendra dot Jamadagni at nospamespn dot com=
 All Views expressed in this email are strictly=20
personal. QOTD: Any clod can have facts, havi=
ng an=20
opinion is an art ! 
-Original Message- =
From:=20
Eberhard, Jeff [mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]
lls-RoyceGS.com]=20
Sent: Wednesday, July 09, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: Tech meetings 
I wish.  I always get that question.  I wor=
k at a=20
gear box manufacturing plant which primarily=
 manufactures gear boxes for jet engines.  Rolls-Royce =
plc doesn't even make the cars anymor

Re: Firewall -- ORA-12535: TNS:operation timed out

[Manoj Kumar Jha]

also check the value of CONNECT_TIMEOUT_,
its default value is 10 (secs).

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, July 10, 2003 11:04 AM


Oh boy!
You need to fix that firewall. You should
a) allow your local nodes to go out on Oracle*Net port (and I advise against
1521, 1526 and 1527).
b) allow certain IP addresses to go in your LAN by using Oracle*Net port.

Second thing to do would be to have a SSL firewall and use Advanced
Networking
or, alternatively, configure Oracle*Net to tunnel through firewalls by using
ssh. The latter is described on in the following article by R. Schrag:
http://www.dbspecialists.com/presentations/net8_security.html

There are tons of options for you and I could easily write an article about
Oracle*Net and firewalls (Thermopilae in Greek). The best thing to do is to
read a few articles about firewalls and Oracle*Net until you find something
that fits your needs. It's half past midnight and I'm tired. May gods be
with
you. There was a guy named Leonidas who was the original security
administrator at the original firewall. Be brave, your work is much easier
then his was.

On 2003.07.10 00:44, Bob Robert wrote:
> Could someone share with me if you come across similar
> kind of configuration.
> --- Mladen Gogala <[EMAIL PROTECTED]> wrote:
> > You obviously do need special configuration.
> > You are welcome.
> >
> > On 2003.07.08 17:09, Bob Robert wrote:
> > > All,
> > >
> > > I am getting following error message when I try to
> > > connect though firewall (from DMZ to Network).
> > >
> > > ORA-12535: TNS:operation timed out
> > >
> > > Do I need to do special configuration (like cman)
> > > around firewall?
> > >
> > > Thanks In Advance,
> > > Bob
> > >
> > >
> > >
> > > __
> > > Do you Yahoo!?
> > > SBC Yahoo! DSL - Now only $29.95 per month!
> > > http://sbc.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > > --
> > > Author: Bob Robert
> > >   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).
> > >
> >
> > --
> > Mladen Gogala
> > Oracle DBA
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: Mladen Gogala
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California-- Mailing list and web
> > hosting services
> >
> -
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Bob Robert
>   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).
>

--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
  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 offic

RE: tunning an index built

[Niall Litchfield]

> Hi all. Thanks to all who replied. I'm still trying
> to speed the things up and wondering whether someone
> can explain what is "paging to file system" is
> referring to? Does this indicate that I don't have
> enough memory? Is it related to reads? Anything else?

Yes it does relate to a lack of memory. I'd hazard a guess that you are
seeing what kirti was referring to, potentially up to 32x200Mb 6.4gb ram
used for the sorts. (Actually I'd expect the usage to be less than that
but if you are setting SAS at 200m and degree 32 that is what you could
be using.) 

I'd ask a couple of things though. 

First how often do you build this index. A one off hit of 55min doesn't
seem horrible to me. If you are rebuilding daily this is probably not
necessary. 
Second I'm assuming that this is 9i (because you refer to db_cache) and
you are in a test environment. If both of these are the case you could
see if you do better by abandoning SAS and SARS and instead setting
PGA_AGGREGATE_TARGET to some large value (say 500m). 

Cheers

Niall

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  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: composite primary key versus unique index

[GKor]

i did exactly the first thing you named.

 <> 
--- Begin Message ---
You mean you created an index A on the table with the descending column
order, and then added a primary key constraint, which created another index
on the same columns (except that all the columns are in ascending order).
Or did you do something different? If you did something different I'd be
curious to know exactly what you implemented.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> 
> i didnt that try on Oracle, but our mainframe Rdms. We have 
> that situation
> there with the ascending en descending attributes in the primary key.
> The workaround is to create a unique index (with and without desc) and
> create afterwards a primary key constraint on it in oracle.
> we have oracle 8.1.7.4.10. (including patches)
> 
> 
> -Original Message-
> From: Jacques Kilchoer
> 
> I don't understand how you can have those types of objects created.
> 
> Let's assume this situation:
> 
> create table T (a number, b number, c number) ;
> create unique index t_pk on t (a asc, b desc) ;
> alter table t add (constraint t_pk primary key (a, b)) ;
> 
> In 8.1 and later, the third statement (add constraint) will return an
> ORA-0955 error because Oracle is unable to build the index 
> needed for the
> primary key constraint.
> 
> In 8.0 and earlier, the "desc" keyword will be ignored in the 
> "create index"
> statement, so there will be no reason why you cannot create 
> the primary key
> constraint and foreign key constraints referencing that primary key
> constraint.
> 
> 
> Now, in 8.1 and later, if the index and the PK have different 
> names, like
> so:
> 
> create table T (a number, b number, c number) ;
> create unique index t_idx1 on t (a asc, b desc) ;
> alter table t add (constraint t_pk primary key (a, b)) ;
> 
> then the third statement (add constraint) will create a 
> second index on the
> table named t_pk, and again you will be able to create foreign key
> constraints referencing the primary key constraint.
> 
> What version of Oracle are you running, and could you describe the
> tables/indexes/constraints involved?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  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).
--- End Message ---