Re: How to increase the number of threads.

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 22 Jul 2001 06:54:54 GMT
Message-ID: <9ho0aa0147v_at_drn.newsguy.com>

In article <9hnjnh$71n$1_at_slb6.atl.mindspring.net>, "Student" says...
>
>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.
>

I stand corrected -- apparently it is technically possible to put it on one node with linux, sorry about that

However, I'll still say "it makes absolutely no sense whatsoever".

So, you can go back to the note and pick up in the middle of step 6 -- using the same single database instance you have.

But as step 8 points out:

8) Conclusions

---

 The solution exposed here does have not many useful practical  applications because we are using a single node, losing most of the key  features of a Parallel Server solution that depends on multiple nodes to  scale-up application performances and to be Fault Tolerant eliminating  single points of failures such instances and nodes .  

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

--
Thomas Kyte (tkyte_at_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 - 08:54:54 CEST