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.