| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 9i Release 2 RAC on Linux Cluster RH7.3
Sorry I didn't get back to you sooner and save you
some time.
Also, note a couple of bugs I ran into w/spfiles.
1). If you change a parameter that can only take
affect after a database bounce, then you must exit
your session after shutting down the database before
you can restart. Otherwise your session will core
fault.
2). If you seed you SPFILE with an init.ora file
containing UPPER CASE, you will be unable to change
any parameter specified in upper case (although it
doesn't complain). Appears that although it converts
upper case to lower for lookup, it cannot do a match
for updates. When you dump the SPFILE you will see dup
entries, one in upper, the other in lower.
Bill
--- Jack van Zanen <nlzanen1_at_EY.NL> wrote:
> Hi Bill
>
>
> I RTFM'd (dig through all sorts of readme,
> whitepapers and forums) and
> found the command
>
> alter system.......yadayaya scope=spfile sid='SID';
>
>
> TIA
>
> Jack
>
>
>
>
>
> "Jack van Zanen"
>
>
> <nlzanen1_at_ey.nl> To:
> Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Sent by: cc:
> (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
>
> root_at_fatcity.com
> Subject: Re: Oracle 9i Release 2 RAC on Linux
> Cluster RH7.3
>
>
>
>
>
>
> 10-07-2002 10:33
>
>
> Please respond to
>
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
>
>
> Hi Bill,
>
>
> we use a shared SPFILE for these two instances. How
> can we specify
> local_listener for each specific instance
>
>
> TIA
>
>
> Jack
>
>
>
> Bill Pass
>
> <wbpass_at_yahoo.com To:
> Multiple
> recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > cc:
> (bcc: Jack van
> Zanen/nlzanen1/External/MEY/NL)
> Sent by:
> Subject: Re: Oracle 9i
> Release 2 RAC on Linux Cluster RH7.3
> root_at_fatcity.com
>
>
>
> 09-07-2002 17:28
>
> Please respond to
>
> ORACLE-L
>
>
>
>
>
>
> Had same problem on 9.0.1.3.
>
> Ended up being that you had to specify a
> LOCAL_LISTENER parameter even though it defaults to
> a
> reasonable value. The value must be one that is
> resolvable by all parties (clients and servers)via
> /etc/hosts or DNS. This is due to the manner in
> which
> redirects are done.
>
> Bill
>
> --- Jack van Zanen <nlzanen1_at_EY.NL> wrote:
> > Hi All,
> >
> >
> >
> > I have a question regarding setup of above.
> >
> > We have the above database setup working except
> for
> > connecting from the
> > clientfails every now and then.
> >
> > We have load balancing turned on on the client so
> > that it alternates
> > connection between the two servers.
> > We think we have load balancing turned on on the
> > servers (but documentation
> > is somewhat confusing on the proper setup)
> >
> > If we connect from the client it sometimes
> succeeds
> > and sometimes fails
> > with different messages on diefferent clients(but
> > always the same message
> > on the same client)
> >
> > - No listener
> > or
> > - No connect_data received
> >
> > the succesfull connections are not just to one
> > instance but both instances
> > have succesfull logons.
> >
> > If we specify one server in the tnsnames.ora (no
> > load balancing) and use
> > the service_name i.s.o sid it show the same
> > succesfull/unsuccesfull logon
> > behaviour.
> > if we then shut down the remote listener and
> > instance all connections go
> > fine
> >
> > This all looks like the load balancing on the
> server
> > seems to be not
> > working correctly
> >
> > Does anybody have experience with setting this up
> > correctly, have good
> > clear documents about it or know any gotcha's that
> > might help solve
> > this......
> >
> >
> > Any help appreciated
> >
> >
> > This is for testing purpose only and we do not pay
> > support for RAC (yet,
> > you never know if we can turn the sql*server march
> > around) so Creating a
> > TAR may be difficult
> >
> >
> > TIA
> >
> >
> > Jack
> >
> >
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pass INET: wbpass_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).Received on Wed Jul 10 2002 - 10:48:24 CDT
 |
 |