Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create RAC database manually on Linux

Re: Create RAC database manually on Linux

From: chan01 <chandra_2000_us_at_yahoo.com>
Date: 11 Apr 2004 15:20:37 -0700
Message-ID: <480cb9d4.0404111420.311732cc@posting.google.com>


Thank you for your advise, yes may be i need to go through the docs once again. I am trying to create rac instance using dbca but i got struck up with problem like unable to access control file. Do you have any idea why i am getting this proble. my alert.log file is



Starting ORACLE instance (normal)
Sun Apr 11 12:07:59 2004
Global Enqueue Service Resources = 64, pool = 1 Sun Apr 11 12:07:59 2004
Global Enqueue Service Enqueues = 128
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
GES IPC: Receivers 1 Senders 1 
GES IPC: Buffers Receive 1000 Send 530 Reserve 300
GES IPC: Msg Size Regular 396 Batch 2048
SCN scheme 2
Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 150
timed_statistics = TRUE
shared_pool_size = 150994944
large_pool_size = 33554432
java_pool_size = 16777216
control_files = /var/opt/oracle/oradata/orcl/control01.ctl, /var/opt/oracle/oradata/orcl/control02.ctl, /var/opt/oracle/oradata/orcl/control03.ctl db_block_size = 8192
db_cache_size = 50331648
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
cluster_database_instances= 1
thread = 1
fast_start_mttr_target = 300
instance_number = 1
undo_management = AUTO
undo_tablespace = UNDOTBS1

undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
local_listener = LISTENER_ORCL1
remote_listener = LISTENERS_ORCL
hash_join_enabled = TRUE
background_dump_dest = /ora01/oracle/admin/orcl/bdump
user_dump_dest = /ora01/oracle/admin/orcl/udump
core_dump_dest = /ora01/oracle/admin/orcl/cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 60817408
Sun Apr 11 12:07:59 2004
cluster interconnect IPC version:Oracle UDP/IP IPC Vendor 1 proto 2 Version 1.0
PMON started with pid=2
DIAG started with pid=3
LMON started with pid=4
LMD0 started with pid=5
DBW0 started with pid=6
LGWR started with pid=7
CKPT started with pid=8
SMON started with pid=9
RECO started with pid=10

Sun Apr 11 12:08:02 2004
CREATE DATABASE orcl
MAXINSTANCES 32
MAXLOGHISTORY 0
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE '/var/opt/oracle/oradata/orcl/orcl/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/var/opt/oracle/oradata/orcl/orcl/temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE "UNDOTBS1" DATAFILE
'/var/opt/oracle/oradata/orcl/orcl/undotbs01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/var/opt/oracle/oradata/orcl/orcl/redo01.log') SIZE 5M REUSE,
GROUP 2 ('/var/opt/oracle/oradata/orcl/orcl/redo02.log') SIZE 5M REUSE Sun Apr 11 12:08:02 2004
lmon registered with NM - instance id 1 (internal mem no 0) Sun Apr 11 12:08:03 2004
Reconfiguration started
List of nodes: 0,
Global Resource Directory frozen
one node partition
Communication channels reestablished
Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out
Resources and enqueues cleaned out
Resources remastered 0
set master node info
Submitted all remote-enqueue requests
Update rdomain variables
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
0 GCS shadows traversed, 0 replayed, 0 unopened Submitted all GCS remote-cache requests
Sun Apr 11 12:08:03 2004
Reconfiguration complete
Post SMON to start 1st pass IR
Sun Apr 11 12:08:24 2004
Database mounted in Exclusive Mode.
Sun Apr 11 12:08:35 2004
Successful mount of redo thread 1, with mount id 1051001763. Assigning activation ID 1051001763 (0x3ea503a3) Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0:
/var/opt/oracle/oradata/orcl/orcl/redo01.log Successful open of redo thread 1.
Sun Apr 11 12:08:38 2004
SMON: enabling cache recovery
Sun Apr 11 12:08:38 2004
WARNING: Default passwords for SYS and SYSTEM will be used. Please change the passwords.
Sun Apr 11 12:08:38 2004
create tablespace SYSTEM datafile
'/var/opt/oracle/oradata/orcl/orcl/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL online
Sun Apr 11 12:10:08 2004
Errors in file /ora01/oracle/admin/orcl/bdump/orcl1_ckpt_16649.trc:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'
ORA-27072: skgfdisp: I/O error

Linux Error: 5: Input/output error
Additional information: 2
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control01.ctl'
ORA-27072: skgfdisp: I/O error

Linux Error: 5: Input/output error
Additional information: 2
Sun Apr 11 12:10:08 2004
Errors in file /ora01/oracle/admin/orcl/bdump/orcl1_ckpt_16649.trc:
ORA-00221: error on write to controlfile
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'
ORA-27072: skgfdisp: I/O error

Linux Error: 5: Input/output error
Additional information: 2
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control01.ctl'
ORA-27072: skgfdisp: I/O error

Linux Error: 5: Input/output error
Additional information: 2
Sun Apr 11 12:10:08 2004
CKPT: terminating instance due to error 221 Sun Apr 11 12:10:09 2004
System state dump is made for local instance Sun Apr 11 12:10:09 2004
Trace dumping is performing id=[cdmp_20040411121009] Sun Apr 11 12:10:13 2004
Instance terminated by CKPT, pid = 16649
 

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1081707695.164951_at_yasure>...
> chan01 wrote:
>
> > I would like to know how can i create RAC db manually on Linux. When i
> > am using dbca to create rac i am getting all kind of error like unable
> > to write to controlfile etc.
> > My Env: Linux AS2.1, Oracle v9.2.0.4 32-bit
> >
> > Thanks for your help.
>
> There is no problem doing this so you likely have not read the
> documentation. DBCA works just fine.
Received on Sun Apr 11 2004 - 17:20:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US