04-10-2003
Problem setting up raw partitions on SUSE v8.0 using LVM on Oracle 8.1.7.URGENT!!!!!!
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.
10 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
i want to know, how do i to create a rwa partttions in unixware 7
wit raid 5
best regards
felix arteaga (1 Reply)
Discussion started by: farteaga
1 Replies
2. UNIX for Advanced & Expert Users
I have been tasked with archiving Oracle tables. The data is on raw devices, and possibly will span multiple logical volumes.
Has anyone ever had to do this? How did you accomplish it?
Any references to accomplish this would be greatly appreciated.
Thanks, (2 Replies)
Discussion started by: isenhart
2 Replies
3. Solaris
Hi all,
I would like to know how to make new partitions....
I currently have allocated 60G for various slices (I have totally used 4 out of 7 available slices...
I am running only solaris on my box.
My plan is to have entire disk dedicated to solaris and run other OS from within... (19 Replies)
Discussion started by: wrapster
19 Replies
4. UNIX and Linux Applications
Hi everyone,
So far, I have done all the steps (including creating django.wsgi in the project). The step left is to turn on the httpd, but error put exit in this very last step. :(
<user> #: ./apachetrl start
httpd: Syntax error on line 450 of /usr/local/apache2/conf/httpd.conf:
Cannot... (1 Reply)
Discussion started by: AlexCheung
1 Replies
5. Web Development
Hi everyone,
So far, I have done all the steps (including creating django.wsgi in the project). The step left is to turn on the httpd, but error put exit in this very last step.:(
<user> #: ./apachetrl start
httpd: Syntax error on line 450 of /usr/local/apache2/conf/httpd.conf:
Cannot load... (1 Reply)
Discussion started by: AlexCheung
1 Replies
6. AIX
Please consider this a question about basics&best practices. On AIX 5.3 system, three raw physical volumes are defined from storage. While doing a read with command dd from the raw device, the speed rate is 250Mb/s.
Then, it gets complex when I define these three pv's to an lv of type raw. Doing... (4 Replies)
Discussion started by: royalliege
4 Replies
7. AIX
Hellow friends,
We are having AIX 5.3 total memory allotted to /Backup directory is 700GB actual used memory is 250GB ..but when i issue df -gt command to check space it is showing /Backup directory is 70% full ..how to identify root cause.? (1 Reply)
Discussion started by: umashankar1987
1 Replies
8. UNIX for Dummies Questions & Answers
Oracle Linux 6.6
To create Physical Volumes for Volume groups (LVM) , the disk need to be partitioned to LVM type ie. 'Linux LVM' type . In fdisk , this can done by choosing 8e when prompted for partition type.
Since it is easy to script (non-interactive), I use parted command rather than... (1 Reply)
Discussion started by: John K
1 Replies
9. Solaris
I am using Solaris 9 (Sparc based) with Sybase and a proprietary DB application that works with Sybase. In the past we have not used SVM or any RAID config. The DBs were configured such that each DB had its own partition.
Now I would like to setup a new machine with the DBs on a RAID5 config... (1 Reply)
Discussion started by: DavidC_SysEngr
1 Replies
10. Ubuntu
I am running Ubuntu 16.04 on a HP laptop with a core I3 processor. I am trying to run mariaDB and do hot backups to disk. In order to do that I wanted to create an LVM snapshot and backup the snapshot for a point in time backup, possibly using tar. I included a snapshot of the gparted app showing... (1 Reply)
Discussion started by: gandolf989
1 Replies