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



