a wrote:
>
> I was following the instruction from metalink to put two instances on one
> machine, does anybody have experience with it? I followed the instructions
> very carefully. I use suse linux 7.2, with 256M and 500M as swap.
>
> I do not have any problem install the 9i RAC. After installation, I can
> start watchdog and nm, cm without problem. lsnodes will tell me that
> my_machine is the only node for my installation.
>
> But I can not create the database. The machine always reboot in the middle
> of the database creation.
> The alter file does not show any error,
> alert.ora is as follows:
> create tablespace SYSTEM datafile '/dev/oracle_raw/ora_system01' SIZE 590M
> REUSE
> default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
>
> There are also diag.trc, lmon.trc, lgwr.ora, lmd0.trc file generated, but
> none of them show any thing like error, or ORA.
> diag.trc is as follows:
> Redo thread mounted by this instance: 0 <none>
> Oracle process number: 3
> Unix process pid: 1653, image: oracle_at_devcshao (DIAG)
>
> *** SESSION ID:(2.1) 2001-12-27 18:22:12.489
> kjzcprt:rcv port created
> Node id: 0
> List of nodes: 0,
> Reconfiguration starts [incarn=0]
> I'm the master node
> Reconfiguration completes [incarn=1]
> ........
>
> The init.ora is as follows:
> db_name =test
> compatible=9.0.0
> db_files = 1024
> control_files = ("/dev/oracle_raw/ora_control1",
> "/dev/oracle_raw/ora_control2")
> db_file_multiblock_read_count = 8 # INITIAL
> db_block_size=8192 # Datawarehouse
> open_cursors=200
> sort_area_size=524288 #Transaction processing
> shared_pool_size = 152428800 # INITIAL
> log_checkpoint_interval = 10000
> processes = 150
> parallel_max_servers = 5
> log_buffer = 8192
> timed_statistics = true # if you want timed statistics
> max_dump_file_size = 10240 # limit trace file size to 10 K each
> global_names = TRUE
> background_dump_dest=/opt/oracle/product/admin/ops1/bdump
> user_dump_dest=/opt/oracle/product/admin/ops1/udump
> remote_login_passwordfile = exclusive
> job_queue_processes = 2
> open_links = 4
> undo_management=AUTO
> #cluster_database= true
> cluster_database_instances = 2
> thread = 1
> instance_name=ops1
>
> What could be wrong, could somebody help me out?
>
> Thanks
Just a thought...did you create the files (control, data) on the raw
partitions **before** trying to create the instance?
--
Ron Reidy
Oracle DBA
========= WAS CANCELLED BY =======:
Path: news.sol.net!spool1-nwblwi.newsops.execpc.com!newsfeeds.sol.net!priapus.visi.com!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: Ron Reidy <rereidy_at_indra.com>
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <3C2C03AB.8AF56E48_at_indra.com>
Control: cancel <3C2C03AB.8AF56E48_at_indra.com>
Date: Mon, 31 Dec 2001 08:08:00 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.3C2C03AB.8AF56E48_at_indra.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009790198 28060 166.102.15.34 (31 Dec 2001 09:16:38 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 09:16:38 GMT
X-No-Archive: yes
Comment: Anarchy! Fuck You!
X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1
X-Unacanc3l: yes
This message was cancelled from within Mozilla...not
Received on Thu Dec 27 2001 - 23:31:23 CST
