date:20030710

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: Restricting access via sqlplus

2003-07-10 Thread 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).

Multiple addreses in tns

2003-07-10 Thread 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: Multiple addreses in tns

2003-07-10 Thread 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).

RE: Multiple addreses in tns

2003-07-10 Thread 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

2003-07-10 Thread 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

2003-07-10 Thread 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: Do Not Call

2003-07-10 Thread 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


snip
http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov
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 ...  groan -- 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
http://www.orafaq.net/  
-- 
Author: Orr, Steve 
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
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).

Location of trace files and alert log

2003-07-10 Thread 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: Location of trace files and alert log

2003-07-10 Thread Erik Williams

Title: Location of trace files and alert log



SQLshow parameter background_dump_dest
SQLshow 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

Oracle on a mainframe (MVS)

2003-07-10 Thread Terrian, Tom (Contractor) (DAASC)

Title: Message




We have a future 
needto 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*Netdoes come with the server on MVS, correct? Does 
Pro*Cobol also exist on MVS?Would the connectionfromMVS 
toHPUX be a simple as creating adatabase link or are there 
moreproblems than that?

Any help would be 
appreciated.

Thanks,
Tom

Re: Location of trace files and alert log

2003-07-10 Thread 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).

RE: Location of trace files and alert log

Title: Location of trace files and alert log



Yes thereare ...

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

9iAs rel1 1.0.2.2.2.

2003-07-10 Thread 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

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; charset=3Diso-8859-=
1
TITLEMessage/TITLE

META content=3DMSHTML 6.00.2800.1106 name=3DGENERATOR/HEAD
BODY
DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D618400715-10072003All,/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D618400715-10072003/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D618400715-10072003/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D618400715-10072003We 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./SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D618400715-10072003If=20
yes,/SPAN/FONTFONT face=3DArial size=3D2SPAN class=3D618400715-10072=
003FONT=20
face=3DTimes New Roman size=3D3nbsp;is it possible to have two nodesnb=
sp; ( iAS=20
homes) active all the time for load balancing/failover for listening the=20
requests. /FONT/SPAN/FONTFONT face=3DArial size=3D2SPAN=20
class=3D618400715-10072003FONT face=3DTimes New Roman size=3D3We 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./FONT/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D618400715-10072003FONT=20
face=3DTimes New Roman size=3D3/FONT/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D618400715-10072003FONT=20
face=3DTimes New Roman size=3D3Any input is=20
apprecitated./FONT/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D618400715-10072003FONT=20
face=3DTimes New Roman size=3D3/FONT/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D618400715-10072003FONT=20
face=3DTimes New Roman size=3D3It is better if you can send me some kind=
 of=20
documenttaion/links./FONT/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D618400715-10072003FONT=20
face=3DTimes New Roman size=3D3/FONT/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D618400715-10072003FONT=20
face=3DTimes New Roman size=3D3Regards,/FONT/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN class=3D618400715-10072003FONT=20
face=3DTimes New Roman size=3D3Inder/FONT/DIV/SPAN/FONTFONT=20
size=3D3/DIV/FONTFONT SIZE=3D3BR
BR
BR
/FONT
/BODY/HTML

--_=_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: Oracle on a mainframe (MVS)

2003-07-10 Thread 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 
  needto 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*Netdoes come with the server on MVS, 
  correct? Does Pro*Cobol also exist on MVS?Would the 
  connectionfromMVS toHPUX be a simple as creating 
  adatabase link or are there moreproblems 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]

RE: Oracle on a mainframe (MVS)

2003-07-10 Thread 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 
needto 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*Netdoes come with the server on 
MVS, correct? Does Pro*Cobol also exist on MVS?Would the 
connectionfromMVS toHPUX be a simple as creating 
adatabase link or are there moreproblems 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]

RE: Multiple addreses in tns

2003-07-10 Thread 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)

2003-07-10 Thread 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 
  needto 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*Netdoes come with the server on MVS, 
  correct? Does Pro*Cobol also exist on MVS?Would the 
  connectionfromMVS toHPUX be a simple as creating 
  adatabase link or are there moreproblems than 
  that?
  
  Any help would be 
  appreciated.
  
  Thanks,
  Tom

RE: RAC system Calls

2003-07-10 Thread 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).

RAC time clocks (sysdate)

2003-07-10 Thread 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

2003-07-10 Thread 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).

RE: RAC system Calls

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

Time Accounting Application

2003-07-10 Thread 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


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

RE: RAC time clocks (sysdate)

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

OT: OAUG Database SIG Elections

2003-07-10 Thread 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).

High availability and upgrades

2003-07-10 Thread 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).

RE: RAC time clocks (sysdate)

2003-07-10 Thread 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).

RE: RAC time clocks (sysdate)

2003-07-10 Thread 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: High availability and upgrades




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 nextrequest
 issent to it. That could 
give some 
 performance practically 
without losing any
 reliability 
features.

Also, since you now have 
two identical 
 databases, you 
canmakeyour app servers
 load balance 
theselects.

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)

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

ORA-01722 while using sqlldr

2003-07-10 Thread 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: High availability and upgrades

2003-07-10 Thread 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 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

2003-07-10 Thread 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
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the

RE: High availability and upgrades

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! 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

RE: RAC system Calls

2003-07-10 Thread 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 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

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 time clocks (sysdate)

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

RE: RAC system Calls


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

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

2003-07-10 Thread 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: 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 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

Re: High availability and upgrades

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 initiatechanges to _standby_ databases beforechanges are
written to _primary_ dbredologs (I might be wrong because haven't read DG
concepts too thoroughly).

But incase 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 loggingissues, etc.

OTOH, backuprecovery 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 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

RE: RAC time clocks (sysdate)

2003-07-10 Thread 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: Multiple addreses in tns

2003-07-10 Thread Thomas Day


Is he trying to do failover or load balancing?





   

  Bob Metelsky   

  bmetelsky   To:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @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: High availability and upgrades



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

RE: Multiple addreses in tns

2003-07-10 Thread 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: RAC time clocks (sysdate)


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: Restricting access via sqlplus

2003-07-10 Thread 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: any script to parse alert log ?!

2003-07-10 Thread 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: any script to parse alert log ?!

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: High availability and upgrades

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: High availability and upgrades

2003-07-10 Thread 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: any script to parse alert log ?!

2003-07-10 Thread 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: Oracle on a mainframe (MVS)

2003-07-10 Thread 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: High availability and upgrades


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: RAC system Calls

2003-07-10 Thread 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 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--

RE: RAC system Calls

2003-07-10 Thread 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


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

Copying database from vxfs to ufs

2003-07-10 Thread 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: Copying database from vxfs to ufs