Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!o42g2000hsc.googlegroups.com!not-for-mail From: trub3101 Newsgroups: comp.databases.oracle.server Subject: Re: Unable to manually create RAC database Date: Mon, 17 Dec 2007 11:55:51 -0800 (PST) Organization: http://groups.google.com Lines: 195 Message-ID: <7172fe58-ee3a-4ca0-b660-97231a03850a@o42g2000hsc.googlegroups.com> References: <6522b0fb-d411-4539-bb45-5f6344432ffb@e67g2000hsc.googlegroups.com> <91d9756c-300e-4283-b075-d6461815188f@n20g2000hsh.googlegroups.com> <1197766987.706968@bubbleator.drizzle.com> <230426c0-b978-4e4a-a716-39ea521125f1@r60g2000hsc.googlegroups.com> <9f1ff3b3-18cb-48d3-8d9b-06c91ab5964c@s8g2000prg.googlegroups.com> <76489ebd-5ed3-466a-88d3-2a15a6973645@b40g2000prf.googlegroups.com> <067f508b-a5f6-4cff-bba5-a688ccb704ed@t1g2000pra.googlegroups.com> NNTP-Posting-Host: 132.185.240.123 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1197921352 3396 127.0.0.1 (17 Dec 2007 19:55:52 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 17 Dec 2007 19:55:52 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: o42g2000hsc.googlegroups.com; posting-host=132.185.240.123; posting-account=RS0lkAoAAAB2-ppbLV8AIz8M0B5IV7QC User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 webgw3-rth.thls.bbc.co.uk:80 (squid/2.6.STABLE13) Xref: usenetserver.com comp.databases.oracle.server:439255 X-Received-Date: Mon, 17 Dec 2007 14:55:52 EST (text.usenetserver.com) On 17 Dec, 03:01, gerryt wrote: > On Dec 16, 3:32 pm, trub3101 wrote: > > > > > > > On Dec 16, 3:10 am, gerryt wrote: > > > > On Dec 15, 6:24 pm, trub3101 wrote: > > > > > On 16 Dec, 01:03, DA Morgan wrote: > > > > > > trub3101 wrote: > > > > > > On 16 Dec, 00:00, "Bob Jones" wrote: > > > > > >> "trub3101" wrote in message > > > > > > >>news:6522b0fb-d411-4539-bb45-5f6344432ffb@e67g2000hsc.googlegroups.com... > > > > > > >>> On 15 Dec, 19:38, "Bob Jones" wrote: > > > > > >>>> "trub3101" wrote in message > > > > > >>>>news:d09a1798-720c-4d3c-8f91-469f2c40f044@x69g2000hsx.googlegroups.com... > > > > > >>>>> Hi Guru's, > > > > > >>>>> I am hoping that someone (anyone!) will be able to provide me with > > > > > >>>>> some assistance with this as my RAC experience is very limited. > > > > > >>>>> I have been trying to manually create a new RAC database > > > > > >>>>> but I keep getting this error message: > > > > > >>>>> create database "" > > > > > >>>>> * > > > > > >>>>> ERROR at line 1: > > > > > >>>>> ORA-01092: ORACLE instance terminated. Disconnection forced > > > > > >>>>> The servers (hosted) came online yesterday with running > > > > > >>>>> (no db build script provided!)however, because of the db_block_size > > > > > >>>>> (too small) this > > > > > >>>>> is of no use to our business needs > > > > > >>>>> I have managed to manually create a single instance database (on > > > > > >>>>> another server) using the script listed (without the RAC thread 2 > > > > > >>>>> prerequisites!) > > > > > >>>>> Hopefully, I have provided enough information for someone to point me > > > > > >>>>> in the right direction. > > > > > >>>>> Many thanks in advance > > > > > >>>>> tb3101 > > > > > >>>>> ---Architecture. > > > > > >>>>> Two nodes > > > > > >>>>> Linux node1.domain01.com 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:56:44 EST > > > > > >>>>> 2007 x86_64 x86_64 x86_64 GNU/Linux > > > > > >>>>> Linux node2.domain01.com 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:56:44 EST > > > > > >>>>> 2007 x86_64 x86_64 x86_64 GNU/Linux > > > > > >>>>> Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production > > > > > >>>>> With the Partitioning, Real Application Clusters, OLAP and Oracle Data > > > > > >>>>> Mining options > > > > > >>>>> JServer Release 9.2.0.7.0 - Production > > > > > >>>>> ---Build RAC Database (used on node1 only) > > > > > >>>>> ORACLE_SID=11 > > > > > >>>>> export ORACLE_SID > > > > > >>>>> sqlplus /nolog< > > > > >>>>> connect sys/ as sysdba > > > > > >>>>> Connected to an idle instance. > > > > > >>>>> SQL> startup nomount pfile=$ORACLE_HOME/dbs/init11.ora > > > > > >>>>> create database "" > > > > > >>>>> maxinstances 10 > > > > > >>>>> maxlogfiles 20 > > > > > >>>>> maxdatafiles 100 > > > > > >>>>> maxlogmembers 5 > > > > > >>>>> character set "UTF8" > > > > > >>>>> datafile '/opt/app/oracle/oradata//system/ > > > > > >>>>> system01.dbf' size 250M > > > > > >>>>> default temporary tablespace temp tempfile '/opt/app/oracle/oradata/ > > > > > >>>>> /tmp/temp01.dbf' SIZE 1000M reuse autoextend on next 640k > > > > > >>>>> maxsize unlimited > > > > > >>>>> undo tablespace "UNDO1" datafile '/opt/app/oracle/oradata// > > > > > >>>>> undo/undo1_01.dbf' size 500m reuse autoextend on next 5120k maxsize > > > > > >>>>> unlimited extent management local > > > > > >>>>> logfile > > > > > >>>>> '/opt/app/oracle/oradata//rdo/log01a.dbf' > > > > > >>>>> SIZE 50M, > > > > > >>>>> '/opt/app/oracle/oradata//rdo/log02a.dbf' > > > > > >>>>> SIZE 50M, > > > > > >>>>> '/opt/app/oracle/oradata//rdo/log03a.dbf' > > > > > >>>>> SIZE 50M > > > > > >>>>> alter database mount > > > > > >>>>> create undo tablespace "UNDO2" datafile '/opt/app/oracle/oradata/ > > > > > >>>>> /undo/undo2_01.dbf' size 500m autoextend on next 5120k > > > > > >>>>> maxsize unlimited extent management local > > > > > >>>>> alter database add logfile thread 2 > > > > > >>>>> group 1 SIZE 50m, > > > > > >>>>> group 2 SIZE 50m, > > > > > >>>>> group 3 size 50m > > > > > >>>>> alter database enable public thread 2 > > > > > >>>>> spool off > > > > > >>>>>>> EOF > > > > > >>>>> ORACLE instance started. > > > > > >>>>> Total System Global Area 1813482504 bytes > > > > > >>>>> Fixed Size 744456 bytes > > > > > >>>>> Variable Size 788529152 bytes > > > > > >>>>> Database Buffers 1023410176 bytes > > > > > >>>>> Redo Buffers 798720 bytes > > > > > >>>>> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 > > > > > >>>>> 14 15 16 17 18 19 20 21 SQL> 2 SQL> SQL> > > > > > >>>>> SQL> / > > > > > >>>>> create database "" > > > > > >>>>> * > > > > > >>>>> ERROR at line 1: > > > > > >>>>> ORA-01092: ORACLE instance terminated. Disconnection forced > > > > > >>>>> SQL> > > > > > >>>> Try running just the CREATE DATABASE statement alone and see if it is > > > > > >>>> successful. Do you have enough space in /opt? If I were you, I would not > > > > > >>>> put > > > > > >>>> datafiles in /opt.- Hide quoted text - > > > > > >>>> - Show quoted text - > > > > > >>> Thanks for your reply Bob. > > > > > >>> I tried just running the CREATE DATABASE statement earlier. > > > > > >>> Unfortunately it returns with an 'ORA-01034: ORACLE not available' > > > > > >>> error message. > > > > > >>> Point taken regarding /opt howevver, this particular filesystem /opt/ > > > > > >>> app/oracle/oradata appears to sit on SAN and not the server HDD. > > > > > >>> Thanks again Bob. > > > > > > >> STARTUP NOMOUNT > > > > > >> then run CREATE DATABASE.- Hide quoted text - > > > > > > >> - Show quoted text - > > > > > > > Silly me! > > > > > > > Thanks Bob. However, I now get this message: > > > > > > > create database "" > > > > > > * > > > > > > ERROR at line 1: > > > > > > ORA-01092: ORACLE instance terminated. Disconnection forced > > > > > > > Thanks again > > > > > > > tb3101 > > > > > > What I think Bob is missing is that this is RAC. And that the RAC > > > > > install MUST push the binaries to both servers and know what to do with > > > > > a lot of other moving pieces. While you are only creating one database > > > > > you must support multiple instances. Even after the binaries are > > > > > installed it isn't vanilla. What are you using for a file system? The > > > > > correct answer is likely ASM have you built an ASM instance on each > > > > > node? Did you do it without using dbca? Or perhaps OCFS, OCFS2, or > > > > > NFS, again no indication from your script. > > > > > > Have installed and validated the Oracle clusterware with the cluster > > > > > verify tool? > > > > > You can play with this and inflict as much pain and suffering as you > > > > > wish ... but if you fire up dbca ... the installer handles it all for you. > > > > > In my lab we build clusters in far less time than you've spent trying > > > > > to hurt yourself: From operating system to failover testing for a 2 node > > > > > cluster takes less than 6 hours. > > > > These are very valid points which have crossed my mind whilst since I > > > > started all this. > > > > However, without access to DBCA I fear I have no choice but to plough > > > > on and see how far I > > > > can get with a manual install. > > > > I truly appreciate your contributions to this thread and I am by no > > > > means dismissing your > > > > valuable advice. Being the first time I have had anything to do with > > > > Oracle RAC I was expecting > > > > a steep learning curve. > > > Right - First to get 16k blocks out Solaris would take some pretty > > > specialized work. IOW I dont believe it. That would requite some > > > proof : > > > > Secondly how the HEY can you install RAC "successfully" if you cannot > > > even get dbca to run remotely..? > > > Rethink your approach or better yet, hire a consultant! > > Not clear what you mean. Are you suggesting that we should'nt use 16K > > db_block_size database on Solaris? > > Apparently it depends. Normally its 8k. Another poster suggested > otherwise > that 16k is better in some situations. Were it me, I'd opt for ASM - > then its less of an issue > maybe. But some places get scared off by ASM and wont have it. > Amazing. > In any case 8K is what newfs lays down. Thats what I was referring to. > So it should certainly be a multiple of that starting at 8K methinks. > > If you really want to know then set up some tests.. I wonder if would > make a measurable > difference. I have some doubts. Therefore choose the default. > O I see DA M says that bit about test and verify already : >- Hide quoted text - > > - Show quoted text - Thanks everyone for all your help and encouragement (especially Bob!). RAC database up and running (without use of DBCA or consultant!!) Cheers, tb3101