No one here [including me !] knows Oracle Names or OID.
There's a profusion of TNSNAMES.ORA files for various databases
and applications but not Oracle Names.
I've been thinking and thinking of Oracle Names for a year and
haven't got around to it . [I guess you'll think twice before hiring
me as a DBA <: ]
Hemant
At 09:14 AM 27-11-02 -0800, you wrote:
The first thing to do is quit using tnsnames.ora on the client PC's.
Use Oracle names or Oracle Internet Directory.
Jared
Hemant K Chitale <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/27/2002 07:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Recipe for application design to run on RAC
Hmm. Oracle says that with the improved Cache Fusion in 9i,
any current application can be taken "as is" and run on 9iRAC.
But yes, you are right. It really depends on the speed at which
the two instances can share the same block and this can never
be the same as two sessions accessing the same block in one
instance [one SGA].
We are currently running and 8.1.5 OPS [ouch !] environment
and testing 9iR2 RAC. The 8.1.5 OPS runs such that the
Application Servers [Pro*C servers which get transactions
from remote devices through a "message bus"] all connect to
one node and direct PCs using VB/MSQuery connect to the other.
Time and again I've asked for the PCs also to connect to the same
node but no ... the effort to update the TNSNAMES.ORA and ODBC
setup on the PCs would be too much I am told.
In 9iRAC we are testing both BASIC and PRECONNECT Failover for
TAF and will most certainly be using both nodes of the cluster for
transactions. Even the Application Servers will be connecting across
both nodes.
Cross-fingers, touch-wood and wish me luck !
Hemant
At 03:59 PM 26-11-02 -0800, you wrote:
>If two or more RAC instances will be trying to cache the same data
>blocks, then this causes the performance problems that you'll see show
>up as lots of time spent on the event called "global cache cr request".
>If you can partition your application so that RAC nodes don't have to
>share blocks very often through the cache fusion mechanism, then your
>system will scale a lot better.
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com
>
>Upcoming events:
>- Hotsos Clinic, Dec 9-11 Honolulu
>- Hotsos Clinic 101, Jan 7-9 Knoxville
>- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen
>- 2003 Hotsos Symposium, Feb 9-12 Dallas
>
>
>-----Original Message-----
>Sent: Tuesday, November 26, 2002 3:34 PM
>To: Multiple recipients of list ORACLE-L
>
>Dear List,
>
>Number of times I've seen that one of prerequsites for
>switching from single node DB to OPS/RAC is to have an
>application specifically designed / architectured to
>run on RAC.
>Can somebody elaborate? Is it something "visible" on
>ERD? That is by looking at the model can RAC guru tell
>that it wouldn't work well on RAC?
>Or put it another way can one conclude based on the
>ERD that app was modeled to run on RAC?
>
>What's the recepie for app design for RAC?
>
>TIA
>
>______________________________________________________________________
>Post your free ad now! http://personals.yahoo.ca
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Boris Dali
> 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.com
>--
>Author: Cary Millsap
> 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).
Hemant K Chitale
My web site page is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
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.com
--
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).
Hemant K Chitale
My web site page is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
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).
