|
|
 |
 |
 |
 |
How can I tell if RAC is running?
I've got two nodes in an HP cluster... AMD, Novell Open Enterprise Server (OES / SuSe Linux ) 9 and Oracle Standard Edition. I've install clusterware 10.2.0.1 without any errors, but when I install the database afterwards, I'm not prompted to select the nodes on which I would like to install it. So even though Clusterware shows up in the installed products... How can I check to see if Clusterware services are running? Shouldn't the Universal installer place the database software on all of the nodes on its own or am I expected to propagate it myself (against all specified documentation.) Thanks in Advance, Ryan
On Thu, 10 May 2007 15:55:40 -0700, ryans @gmail.com wrote: > How can I check to see if Clusterware services are running? $ORA_CRS_HOME/bin/crs_stat -l -- http://www.mladen-gogala.com
-----------------------------------------------Reply-----------------------------------------------
ryans @gmail.com wrote: > I've got two nodes in an HP cluster... AMD, Novell Open Enterprise > Server (OES / SuSe Linux ) 9 and Oracle Standard Edition. > I've install clusterware 10.2.0.1 without any errors, but when I > install the database afterwards, I'm not prompted to select the nodes > on which I would like to install it. > So even though Clusterware shows up in the installed products... > How can I check to see if Clusterware services are running? > Shouldn't the Universal installer place the database software on all > of the nodes on its own or am I expected to propagate it myself > (against all specified documentation.) > Thanks in Advance, > Ryan
You'll need Oracle Enterprise Edition for RAC. HTH, Brian -- =================================================================== Brian Peasland d@nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - Unknown -- Posted via a free Usenet account from http://www.teranews.com
-----------------------------------------------Reply-----------------------------------------------
On May 11, 8:32 am, Brian Peasland <d @nospam.peasland.net> wrote:
> ryans @gmail.com wrote: > > I've got two nodes in an HP cluster... AMD, Novell Open Enterprise > > Server (OES / SuSe Linux ) 9 and Oracle Standard Edition. > > I've install clusterware 10.2.0.1 without any errors, but when I > > install the database afterwards, I'm not prompted to select the nodes > > on which I would like to install it. > > So even though Clusterware shows up in the installed products... > > How can I check to see if Clusterware services are running? > > Shouldn't the Universal installer place the database software on all > > of the nodes on its own or am I expected to propagate it myself > > (against all specified documentation.) > > Thanks in Advance, > > Ryan > You'll need Oracle Enterprise Edition for RAC.
WHen did that change? (http://download-east.oracle.com/docs/cd/B19306_01/license.102/b14199/ options.htm#CIHGHJBE) -- Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com) *** Feel free to correct me when I'm wrong! *** Top posting [replies] guarantees I won't respond.
-----------------------------------------------Reply-----------------------------------------------
On May 11, 10:32 am, Brian Peasland <d @nospam.peasland.net> wrote:
> > Ryan > You'll need Oracle Enterprise Edition for RAC. > HTH, > Brian > -- > =================================================================== > Brian Peasland > d@nospam.peasland.nethttp://www.peasland.net > Remove the "nospam." from the email address to email me. > "I can give it to you cheap, quick, and good. > Now pick two out of the three" - Unknown > -- > Posted via a free Usenet account fromhttp://www.teranews.com
Hi Brian, You can run RAC on standard edition. http://www.oracle.com/technology/products/database/clustering/index.html Regards, Steve
-----------------------------------------------Reply-----------------------------------------------
On May 10, 6:55 pm, "ryans @gmail.com" <ryans @gmail.com> wrote:
> I've got two nodes in an HP cluster... AMD, Novell Open Enterprise > Server (OES / SuSe Linux ) 9 and Oracle Standard Edition. > I've install clusterware 10.2.0.1 without any errors, but when I > install the database afterwards, I'm not prompted to select the nodes > on which I would like to install it. > So even though Clusterware shows up in the installed products... > How can I check to see if Clusterware services are running? > Shouldn't the Universal installer place the database software on all > of the nodes on its own or am I expected to propagate it myself > (against all specified documentation.) > Thanks in Advance, > Ryan
The installer will install the software only the nodes you choose to. If the nodes show up in the installer chances are the CRS suite is running fine, but to be sure follow Mladen's indication or search on Metalink as there is a script for displaying crs_stat's results in a better visual mode - for 10gR1. In 10g R2, I think there is a new utility - can't recall the exact name, but it is something like crs_stat2 or along those lines. -----------------------------------------------Reply-----------------------------------------------
On Fri, 11 May 2007 07:58:39 -0700, Valentin Minzatu wrote: > The installer will install the software only the nodes you choose to. If > the nodes show up in the installer chances are the CRS suite is running > fine, but to be sure follow Mladen's indication or search on Metalink as > there is a script for displaying crs_stat's results in a better visual > mode - for 10gR1. In 10g R2, I think there is a new utility - can't > recall the exact name, but it is something like crs_stat2 or along those > lines.
It's called "crs_stat". Looks like this: [oracle@oracle8 ~]$ $ORA_CRS_HOME/bin/crs_stat -l NAME=ora.news.NEWS1.inst TYPE=application TARGET=ONLINE STATE=ONLINE on oracle8 NAME=ora.news.NEWS2.inst TYPE=application TARGET=ONLINE STATE=ONLINE on oracle9 NAME=ora.news.db TYPE=application TARGET=ONLINE STATE=ONLINE on oracle8 NAME=ora.oracle8.ASM1.asm TYPE=application TARGET=ONLINE STATE=ONLINE on oracle8 NAME=ora.oracle8.LISTENER_ORACLE8.lsnr TYPE=application TARGET=ONLINE STATE=ONLINE on oracle8 NAME=ora.oracle8.gsd TYPE=application TARGET=ONLINE STATE=ONLINE on oracle8 NAME=ora.oracle8.ons TYPE=application TARGET=ONLINE STATE=ONLINE on oracle8 NAME=ora.oracle8.vip TYPE=application TARGET=ONLINE STATE=ONLINE on oracle8 NAME=ora.oracle9.ASM2.asm TYPE=application TARGET=ONLINE STATE=ONLINE on oracle9 NAME=ora.oracle9.LISTENER_ORACLE9.lsnr TYPE=application TARGET=ONLINE STATE=ONLINE on oracle9 NAME=ora.oracle9.gsd TYPE=application TARGET=ONLINE STATE=ONLINE on oracle9 NAME=ora.oracle9.ons TYPE=application TARGET=ONLINE STATE=ONLINE on oracle9 NAME=ora.oracle9.vip TYPE=application TARGET=ONLINE STATE=ONLINE on oracle9 Very simple thing would be to use $ORA_CRS_HOME/bin/olsnodes but it doesn't give you the full information. -- http://www.mladen-gogala.com
-----------------------------------------------Reply-----------------------------------------------
On Fri, 11 May 2007 18:19:38 +0200, Mladen Gogala wrote: > Very simple thing would be to use $ORA_CRS_HOME/bin/olsnodes but it > doesn't give you the full information.
In addition to that, if you want to work with RAC get RAC Handbook by K. Gopalakrishnan, it's a spectalularly good book. That book and a bit of experience is all that an oraclite needs to become oRAClite. -- http://www.mladen-gogala.com
-----------------------------------------------Reply-----------------------------------------------
On May 11, 12:19 pm, Mladen Gogala <mgogala.SPAM...@not-at-
verizon.net> wrote: > On Fri, 11 May 2007 07:58:39 -0700, Valentin Minzatu wrote: > > The installer will install the software only the nodes you choose to. If > > the nodes show up in the installer chances are the CRS suite is running > > fine, but to be sure follow Mladen's indication or search on Metalink as > > there is a script for displaying crs_stat's results in a better visual > > mode - for 10gR1. In 10g R2, I think there is a new utility - can't > > recall the exact name, but it is something like crs_stat2 or along those > > lines. > It's called "crs_stat". Looks like this: > [oracle@oracle8 ~]$ $ORA_CRS_HOME/bin/crs_stat -l > NAME=ora.news.NEWS1.inst > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle8 > NAME=ora.news.NEWS2.inst > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle9 > NAME=ora.news.db > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle8 > NAME=ora.oracle8.ASM1.asm > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle8 > NAME=ora.oracle8.LISTENER_ORACLE8.lsnr > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle8 > NAME=ora.oracle8.gsd > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle8 > NAME=ora.oracle8.ons > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle8 > NAME=ora.oracle8.vip > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle8 > NAME=ora.oracle9.ASM2.asm > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle9 > NAME=ora.oracle9.LISTENER_ORACLE9.lsnr > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle9 > NAME=ora.oracle9.gsd > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle9 > NAME=ora.oracle9.ons > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle9 > NAME=ora.oracle9.vip > TYPE=application > TARGET=ONLINE > STATE=ONLINE on oracle9 > Very simple thing would be to use $ORA_CRS_HOME/bin/olsnodes but it > doesn't give you the full information. > --http://www.mladen-gogala.com
Mladen, there is a new utility called crs_stat2 or along those lines which display the data above in a tabular format. I am pretty sure I saw it in R2 and sure it does not exist in R1, but I do not have an R2 installation handy. -----------------------------------------------Reply-----------------------------------------------
On Fri, 11 May 2007 10:00:40 -0700, Valentin Minzatu wrote: > Mladen, there is a new utility called crs_stat2 or along those lines > which display the data above in a tabular format.
Why would I need it? -- http://www.mladen-gogala.com
-----------------------------------------------Reply-----------------------------------------------
On May 11, 1:05 pm, Mladen Gogala <mgogala.SPAM @not-at-verizon.net> wrote: > On Fri, 11 May 2007 10:00:40 -0700, Valentin Minzatu wrote: > > Mladen, there is a new utility called crs_stat2 or along those lines > > which display the data above in a tabular format. > Why would I need it? > --http://www.mladen-gogala.com
In RAC with many services you'll have scroll up and down through the list, while with that you get something like below: HA Resource Target State ----------- ------ ----- ora.node01.ASM1.asm ONLINE ONLINE on node01 ora.node01.LISTENER_node01.lsnr ONLINE ONLINE on node01 ora.node01.gsd ONLINE ONLINE on node01 ora.node01.ons ONLINE ONLINE on node01 ora.node01.vip ONLINE ONLINE on node01 ora.node02.ASM2.asm ONLINE ONLINE on node02 ora.node02.LISTENER_node02.lsnr ONLINE ONLINE on node02 ora.node02.gsd ONLINE ONLINE on node02 ora.node02.ons ONLINE ONLINE on node02 ora.node02.vip ONLINE ONLINE on node02 ora.racdb.Service1.cs ONLINE ONLINE on node01 ora.racdb.Service1.qator1.sa ONLINE ONLINE on node02 ora.racdb.Service1.qator1.srv ONLINE ONLINE on node01 ora.racdb.Service2.cs ONLINE ONLINE on node01 ora.racdb.Service2.qator1.sa ONLINE ONLINE on node02 ora.racdb.Service2.qator1.srv ONLINE ONLINE on node01 ora.racdb.Service3.cs ONLINE ONLINE on node02 ora.racdb.Service3.qator2.sa ONLINE ONLINE on node01 ora.racdb.Service3.qator2.srv ONLINE ONLINE on node02 ora.racdb.Service4.cs ONLINE ONLINE on node02 ora.racdb.Service4.qator1.srv ONLINE ONLINE on node01 ora.racdb.Service4.qator2.srv ONLINE ONLINE on node02 ora.racdb.Service5.cs ONLINE ONLINE on node02 ora.racdb.Service5.qator1.srv ONLINE ONLINE on node01 ora.racdb.Service5.qator2.srv ONLINE ONLINE on node02 ora.racdb.Service6.cs ONLINE ONLINE on node01 ora.racdb.Service6.qator1.sa ONLINE ONLINE on node02 ora.racdb.Service6.qator1.srv ONLINE ONLINE on node01 ora.racdb.Service7.cs ONLINE ONLINE on node02 ora.racdb.Service7.qator2.sa ONLINE ONLINE on node01 ora.racdb.Service7.qator2.srv ONLINE ONLINE on node02 ora.racdb.Service8.cs ONLINE ONLINE on node01 ora.racdb.Service8.qator1.sa ONLINE ONLINE on node02 ora.racdb.Service8.qator1.srv ONLINE ONLINE on node01 ora.racdb.db ONLINE ONLINE on node02 ora.racdb.qator1.inst ONLINE ONLINE on node01 ora.racdb.qator2.inst ONLINE ONLINE on node02 (this is the output of the script for R1 - for obvious reasons I changed the real data) It is much easier to see the status of each service than running crs_stat.
-----------------------------------------------Reply-----------------------------------------------
On May 11, 1:13 pm, Valentin Minzatu <valentinminz @yahoo.com> wrote:
> On May 11, 1:05 pm, Mladen Gogala <mgogala.SPAM @not-at-verizon.net> > wrote: > > On Fri, 11 May 2007 10:00:40 -0700, Valentin Minzatu wrote: > > > Mladen, there is a new utility called crs_stat2 or along those lines > > > which display the data above in a tabular format. > > Why would I need it? > > --http://www.mladen-gogala.com > In RAC with many services you'll have scroll up and down through the > list, while with that you get something like below: > HA Resource Target State > ----------- ------ ----- > ora.node01.ASM1.asm ONLINE ONLINE on node01 > ora.node01.LISTENER_node01.lsnr ONLINE ONLINE on node01 > ora.node01.gsd ONLINE ONLINE on node01 > ora.node01.ons ONLINE ONLINE on node01 > ora.node01.vip ONLINE ONLINE on node01 > ora.node02.ASM2.asm ONLINE ONLINE on node02 > ora.node02.LISTENER_node02.lsnr ONLINE ONLINE on node02 > ora.node02.gsd ONLINE ONLINE on node02 > ora.node02.ons ONLINE ONLINE on node02 > ora.node02.vip ONLINE ONLINE on node02 > ora.racdb.Service1.cs ONLINE ONLINE on node01 > ora.racdb.Service1.qator1.sa ONLINE ONLINE on node02 > ora.racdb.Service1.qator1.srv ONLINE ONLINE on node01 > ora.racdb.Service2.cs ONLINE ONLINE on node01 > ora.racdb.Service2.qator1.sa ONLINE ONLINE on node02 > ora.racdb.Service2.qator1.srv ONLINE ONLINE on node01 > ora.racdb.Service3.cs ONLINE ONLINE on node02 > ora.racdb.Service3.qator2.sa ONLINE ONLINE on node01 > ora.racdb.Service3.qator2.srv ONLINE ONLINE on node02 > ora.racdb.Service4.cs ONLINE ONLINE on > node02 > ora.racdb.Service4.qator1.srv ONLINE ONLINE on > node01 > ora.racdb.Service4.qator2.srv ONLINE ONLINE on > node02 > ora.racdb.Service5.cs ONLINE ONLINE on node02 > ora.racdb.Service5.qator1.srv ONLINE ONLINE on node01 > ora.racdb.Service5.qator2.srv ONLINE ONLINE on node02 > ora.racdb.Service6.cs ONLINE ONLINE on > node01 > ora.racdb.Service6.qator1.sa ONLINE ONLINE on > node02 > ora.racdb.Service6.qator1.srv ONLINE ONLINE on > node01 > ora.racdb.Service7.cs ONLINE ONLINE on node02 > ora.racdb.Service7.qator2.sa ONLINE ONLINE on node01 > ora.racdb.Service7.qator2.srv ONLINE ONLINE on node02 > ora.racdb.Service8.cs ONLINE ONLINE on node01 > ora.racdb.Service8.qator1.sa ONLINE ONLINE on node02 > ora.racdb.Service8.qator1.srv ONLINE ONLINE on node01 > ora.racdb.db ONLINE ONLINE on > node02 > ora.racdb.qator1.inst ONLINE ONLINE on > node01 > ora.racdb.qator2.inst ONLINE ONLINE on > node02 > (this is the output of the script for R1 - for obvious reasons I > changed the real data) > It is much easier to see the status of each service than running > crs_stat.
I found the Metalink note for the above script. Note: 259301.1. -----------------------------------------------Reply-----------------------------------------------
On Fri, 11 May 2007 10:13:33 -0700, Valentin Minzatu wrote: > In RAC with many services you'll have scroll up and down through the > list, while with that you get something like below:
That is why Larry Wall has intelligently designed Perl. -- http://www.mladen-gogala.com
-----------------------------------------------Reply-----------------------------------------------
On Fri, 11 May 2007 11:18:49 -0700, Valentin Minzatu wrote: > I found the Metalink note for the above script. Note: 259301.1.
Thanks for the document. It's a good document, but it's a lousy script. -- http://www.mladen-gogala.com
-----------------------------------------------Reply-----------------------------------------------
On May 11, 9:06 pm, Mladen Gogala <mgogala.SPAM_ME. @verizon.net> wrote: > On Fri, 11 May 2007 11:18:49 -0700, Valentin Minzatu wrote: > > I found the Metalink note for the above script. Note: 259301.1. > Thanks for the document. It's a good document, but it's a lousy > script. > --http://www.mladen-gogala.com
I am not thrilled by the script either, but it did the job I needed it for. There are definitely other ways of displaying the same infromation, one of out-of-the-box ones being enterprise manager. -----------------------------------------------Reply-----------------------------------------------
I ran crs_stat and I receive the message... "CRS-0184: Cannot communicate with the CRS daemon." I followed through the install ... no issues -- so why isn't CRS running? I tried running a crs_start and it tells me I need to fill in a bunch of switches... so I did... then it still tells me "CRS-0184: Cannot communicate with the CRS daemon." I pass the cluvfy without errors -- so I'm confused as to why things aren't running. Any suggestions / ideas? Thanks, Ryan
-----------------------------------------------Reply-----------------------------------------------
On Sun, 13 May 2007 20:33:08 -0700, ryans @gmail.com wrote: > I pass the cluvfy without errors -- so I'm confused as to why things > aren't running. How did you run cluvfy, for what components and phases? -- http://www.mladen-gogala.com
-----------------------------------------------Reply-----------------------------------------------
On May 13, 11:33 pm, "ryans @gmail.com" <ryans @gmail.com> wrote:
> I ran crs_stat and I receive the message... > "CRS-0184: Cannot communicate with the CRS daemon." > I followed through the install ... no issues -- so why isn't CRS > running? > I tried running a crs_start and it tells me I need to fill in a bunch > of switches... so I did... > then it still tells me "CRS-0184: Cannot communicate with the CRS > daemon." > I pass the cluvfy without errors -- so I'm confused as to why things > aren't running. > Any suggestions / ideas? > Thanks, > Ryan
What is the output of the following: ps -ef|grep crs ps -ef|grep evm -----------------------------------------------Reply-----------------------------------------------
Brian Peasland wrote: > ryans @gmail.com wrote: >> I've got two nodes in an HP cluster... AMD, Novell Open Enterprise >> Server (OES / SuSe Linux ) 9 and Oracle Standard Edition. >> I've install clusterware 10.2.0.1 without any errors, but when I >> install the database afterwards, I'm not prompted to select the nodes >> on which I would like to install it. >> So even though Clusterware shows up in the installed products... >> How can I check to see if Clusterware services are running? >> Shouldn't the Universal installer place the database software on all >> of the nodes on its own or am I expected to propagate it myself >> (against all specified documentation.) >> Thanks in Advance, >> Ryan > You'll need Oracle Enterprise Edition for RAC. > HTH, > Brian
Oracle licenses up to 2 nodes and 4CPUs with Standard Edition with no additional license fee. The caveat ... you must use ASM. -- Daniel A. Morgan University of Washington damor @x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org -----------------------------------------------Reply-----------------------------------------------
ryans @gmail.com wrote: > I've got two nodes in an HP cluster... AMD, Novell Open Enterprise > Server (OES / SuSe Linux ) 9 and Oracle Standard Edition. > I've install clusterware 10.2.0.1 without any errors, but when I > install the database afterwards, I'm not prompted to select the nodes > on which I would like to install it. > So even though Clusterware shows up in the installed products... > How can I check to see if Clusterware services are running? > Shouldn't the Universal installer place the database software on all > of the nodes on its own or am I expected to propagate it myself > (against all specified documentation.) > Thanks in Advance, > Ryan
DBMS_UTILITY.ACTIVE_INSTANCES DBMS_UTILITY.IS_CLUSTER_DATABASE Both documented in Morgan's Library at www.psoug.org under DBMS_UTILITY. -- Daniel A. Morgan University of Washington damor@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org
-----------------------------------------------Reply-----------------------------------------------
I've set it for ASM management... during the clusterware install, you just point ASM at the available partition(s), but that's about it. We're running 2 nodes, dual dual-core AMD64 processors... Oracle said this would be OK. Since Standard Edition RAC is based on CPUs, not cores...
|
 |
 |
 |
 |
|