[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

[linux-lvm] Raw device setup problems on Suse v8.0 Linux!



Hi all!

Working on Oracle v8.1.7.0.0 with OS as Suse v8.0 Linux.

I had created LVM,linked raw devices to LVM as below:

# for binding raw devices

raw /dev/raw/raw1 /dev/oracle/sam_raw_system_251m
raw /dev/raw/raw2 /dev/oracle/sam_raw_users_26m
raw /dev/raw/raw3 /dev/oracle/sam_raw_temp_41m
raw /dev/raw/raw4 /dev/oracle/sam_raw_rbs_201m
raw /dev/raw/raw5 /dev/oracle/sam_raw_indx_26m
raw /dev/raw/raw6 /dev/oracle/sam_raw_controlfile1_110m
raw /dev/raw/raw7 /dev/oracle/sam_raw_controlfile2_110m
raw /dev/raw/raw8 /dev/oracle/sam_raw_controlfile3_110m
raw /dev/raw/raw9 /dev/oracle/sam_raw_tools_11m
raw /dev/raw/raw10 /dev/oracle/sam_raw_redo01_120m
raw /dev/raw/raw11 /dev/oracle/sam_raw_redo02_120m
raw /dev/raw/raw12 /dev/oracle/sam_raw_redo03_10m


# for linking raw devices with file system



ln -s /dev/raw/raw1 /ora8/m01/app/oracle/oradata/sam/sam_raw_system_251m
ln -s /dev/raw/raw2 /ora8/m01/app/oracle/oradata/sam/sam_raw_users_26m
ln -s /dev/raw/raw3 /ora8/m01/app/oracle/oradata/sam/sam_raw_temp_41m
ln -s /dev/raw/raw4 /ora8/m01/app/oracle/oradata/sam/sam_raw_rbs_201m
ln -s /dev/raw/raw5 /ora8/m01/app/oracle/oradata/sam/sam_raw_indx_26m
ln -s /dev/raw/raw6 /ora8/m01/app/oracle/oradata/sam/sam_raw_controlfile1_110m
ln -s /dev/raw/raw7 /ora8/m01/app/oracle/oradata/sam/sam_raw_controlfile2_110m
ln -s /dev/raw/raw8 /ora8/m01/app/oracle/oradata/sam/sam_raw_controlfile3_110m
ln -s /dev/raw/raw9 /ora8/m01/app/oracle/oradata/sam/sam_raw_tools_11m
ln -s /dev/raw/raw10 /ora8/m01/app/oracle/oradata/sam/sam_raw_redo01_120m
ln -s /dev/rawr/aw11 /ora8/m01/app/oracle/oradata/sam/sam_raw_redo02_120m
ln -s /dev/raw/raw12 /ora8/m01/app/oracle/oradata/sam/sam_raw_redo03_10m


I had then executed the script sqlora8.sh as below after making all the changes in
initsam.ora control files with raw devices,samrun.sh,samrun1.sh and replaced the
data files,redo log files with the necessary raw devices.


P.S:SAM is the db name and I want to create the SAM DB with the help of
sqlora8.sh script....


oracle saraswathi:/ora8/m01/app/oracle/product/8.1.7/assistants/dbca>
./sqlora8.sh

I get the following error as below:

ORA-01109: database not open
create or replace function privilege_list (priv_list out ora_name_list_t)
*
ORA-01109: database not open
grant execute on privilege_list to public
*
ORA-01109: database not open
drop public synonym ora_privilege_list
*
ORA-01109: database not open
create public synonym ora_privilege_list for privileg_list
*
ORA-01109: database not open
create or replace function with_grant_option return boolean is


ORA-01109: database not open
grant execute on is_drop_column to public
*
ORA-01109: database not open
drop public synonym ora_is_drop_column
*
ORA-01109: database not open
create public synonym ora_is_drop_column for is_drop_column
*
ORA-01109: database not open
create or replace function grantee (user_list out ora_name_list_t)
*
ORA-01109: database not open
grant execute on grantee to public
*
ORA-01109: database not open
drop public synonym ora_grantee
*
ORA-01109: database not open
create public synonym ora_grantee for grantee
*
ORA-01109: database not open
create or replace function revokee (user_list out ora_name_list_t)
*
ORA-01109: database not open
grant execute on revokee to public
*
ORA-01109: database not open
drop public synonym ora_revokee
*
ORA-01109: database not open
create public synonym ora_revokee for revokee
*
ORA-01109: database not open
create or replace function privilege_list (priv_list out ora_name_list_t)
*
ORA-01109: database not open
grant execute on privilege_list to public
*
ORA-01109: database not open
drop public synonym ora_privilege_list
*
ORA-01109: database not open
create public synonym ora_privilege_list for privileg_list
*
ORA-01109: database not open
create or replace function with_grant_option return boolean is





ORA-01109: database not open
grant execute on is_drop_column to public
*
ORA-01109: database not open
drop public synonym ora_is_drop_column
*
ORA-01109: database not open
create public synonym ora_is_drop_column for is_drop_column
*
ORA-01109: database not open
create or replace function grantee (user_list out ora_name_list_t)
*
ORA-01109: database not open
grant execute on grantee to public
*
ORA-01109: database not open
drop public synonym ora_grantee
*
ORA-01109: database not open
create public synonym ora_grantee for grantee
*
ORA-01109: database not open
create or replace function revokee (user_list out ora_name_list_t)
*
ORA-01109: database not open
grant execute on revokee to public
*
ORA-01109: database not open
drop public synonym ora_revokee
*
ORA-01109: database not open
create public synonym ora_revokee for revokee
*
ORA-01109: database not open
create or replace function privilege_list (priv_list out ora_name_list_t)
*
ORA-01109: database not open
grant execute on privilege_list to public
*
ORA-01109: database not open
drop public synonym ora_privilege_list
*
ORA-01109: database not open
create public synonym ora_privilege_list for privileg_list
*
ORA-01109: database not open
create or replace function with_grant_option return boolean is


Has anyone experienced the same problem so far and please could figure out as to
what is causing this problem...ORA:01109:database not open....


THESE ARE THE SETTINGS FOR MY INITORA8.ORA FILE:

db_name = "ora8"
instance_name = ora8

control_files = ("/dev/raw/raw1","/dev/raw/raw2", "/dev/raw/raw3")

open_cursors = 300
max_enabled_roles = 30

db_block_buffers = 2048

shared_pool_size = 4194304

large_pool_size = 614400
java_pool_size = 0

log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800

processes = 150

log_buffer = 163840

# audit_trail = false  # if you want auditing
# timed_statistics = false  # if you want timed statistics
"initora8.ora" [readonly] 110L, 4292C

Thanks&Regards,

Amit.




Amit Sood Tagala, Sr.Oracle Database(OCP) Administrator(DBA) v8i,v9i, Ph#:(R)+91-40-27508534. Mobile#:9849050133. *E-mail:amitstora rediffmail com, amitst yahoo com


_______________________________________________________________________ Odomos - the only mosquito protection outside 4 walls - Click here to know more! http://r.rediff.com/r?http://clients.rediff.com/odomos/Odomos.htm&&odomos&&wn




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]