Re: How to increase the number of threads.

[Quoted] 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 -- [Quoted] [Quoted] 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_at_us.oracle.com)             http://asktom.oracle.com/ 
[Quoted] 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