Re: How to increase the number of threads.

Well, then I it makes no sense for oracle to even publish Note:136077.1 in Metalink specifically for single node/ two instance parallel server architecture setup.

Eitherway, thanks for your advise and I appreciate it. I will attempt to parelliized it on 2 nodes as you had suggested.

Student-

"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message news:9hkm4r02q4m_at_drn.newsguy.com...
> In article <9hk9pv$ga$1_at_slb7.atl.mindspring.net>, "Student" says...
> >
> >
> >Thanks for your initial feedback and pointers.
> >
> >Just a little background here..
> >
> >Yes, I am attempting to build a single node/ two
> >instance parallel server architecture on a Linux box
> >(SuSe Linux 7.1) based on Oracle version 9.0.1.0.0
> >(9i Real Application Cluster)
> >
>
> it makes no sense whatsoever to have a one node cluster. OPS needs two
> computers. With one computer -- you have single instance oracle.
>
> If you had two computers, you would simply mount and open the same
 database --
> they would not have their own temp, data, rollback and such -- its a
 shared
> everything architecture.
>
>
> >I refered to Note:136077.1 from MetaLink as my
> >primary guide. After some reading, I was able to setup the required
> >Raw devices and the Cluster Manager components
> >(ie. Watchdog, NM, CM) making sure that they work correctly.
> >This enable me to move forward and install parallel server
> >and created the primary database. It works fine as a "standalone"
> >primary parallel server. (After runnning catparr.sql and
> >configuring the parallel parameters in init.ora file (ie.
> >parallel_server=true)
> >
> >Moving forward..
> >
> >The confusion that I have here is on the second database (OPS_B)
> >residing on the same node.Am I required to create a complete
 "independent"
> >database
> >(ie. including system, temp, rollback datafiles) or am I supposed only
> >create a set of
> >redologs file and mount parallel to the primary database? To my "fuzzy"
> >understanding
> >the only attributes that are required for the second database is the
> >redologs
> >and background processes and the rest are dependent on the primary
> >database (OPS_A). If so, what are the exact procedures to establish a
 basic
> >parallel
> >server environment ? Please correct me if I am terribly wrong.
> >
> >Any advise would be appreciated.
> >
> >Thanks in advance.
> >
> >Student-
> >
> >
> >"Spencer" <spencerp_at_swbell.net> wrote in message
> >news:NIb%6.123$uk1.7963_at_nnrp1.sbc.net...
> >> you'd need to be running Oracle Parallel Server.
> >>
> >> the clause "thread 2" in the context you are using
> >> it refers to multiple Oracle instances managing a
> >> single database, each instance writes its own log
> >> files.
> >>
> >> if you can't make sense of that, then you may find
> >> it beneficial to review the Oracle Concepts manual,
> >> available free of charge with registration at OTN.
> >> http://technet.oracle.com
> >>
> >> i think i'd be more concerned with the number of log
> >> groups, and adding a second member to each log
> >> group, rather than trying to add a thread.
> >>
> >> "Student" <kennylim_at_techie.com> wrote in message
> >> news:9hj8a7$brp$1_at_slb1.atl.mindspring.net...
> >> >
> >> > Good Evening,
> >> >
> >> > I am wondering if anyone knows how to increase the number of threads
> >> > available in a parallel database ? When I created the database, I
 seem
 to
> >> > have
> >> > only 1 thread.
> >> >
> >> > alter database add logfile thread 2 group 21 '/dev/raw8' size 10M;
> >> > alter database add logfile thread 2 group 22 '/dev/raw9' size 10M;
> >> >
> >> > SQL> alter database add logfile thread 2 group 2 1 '/dev/raw8' size
 10M
> >> > *
> >> > ERROR at line 1:
> >> > ORA-01611: thread number 2 is invalid - must be between 1 and 1
> >> > <=====How Can I increase to 4 ?
> >> >
> >> > Any advise will be greatly appreciated. Thanks.
> >> >
> >> > Student-
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Sun Jul 22 2001 - 01:54:52 CDT