Error creating ASM instance using DBCA [message #465595] |
Wed, 14 July 2010 23:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jxh461
Messages: 185 Registered: March 2005
|
Senior Member |
|
|
Gentlemen and Ladies, Greetings.
I am learning to create an ASM (Automatic Storage Management) instance using dbca. I am not sure which best forum to address this so I came here. Please direct me if not the right place.
My problem is really self inflicted. At first try I mistakenly skipped the part where I click on ASM Parameters to add /dev/raw/raw* as my asm_diskstring so it created an ASM instance. When I get to the next page ASM Disk Groups, I selected Create New and I did not have the desired display, because of the step I missed.
I went back to do some cleaning up as follows:
1) Edit the oratab file to remove the ASM entry
2) backed up these files by renaming to old-<filename>
old-ab_+ASM.dat
old-hc_+ASM.dat
old-lk+ASM
old-orapw+ASM
old-spfile2+ASM.ora
3) killed the following processes (kill -9):
oracle 1590 1 0 22:52 ? 00:00:00 asm_pmon_+ASM
oracle 1592 1 0 22:52 ? 00:00:00 asm_psp0_+ASM
oracle 1594 1 0 22:52 ? 00:00:00 asm_mman_+ASM
oracle 1596 1 0 22:52 ? 00:00:00 asm_dbw0_+ASM
oracle 1598 1 0 22:52 ? 00:00:00 asm_lgwr_+ASM
oracle 1600 1 0 22:52 ? 00:00:00 asm_ckpt_+ASM
oracle 1602 1 0 22:52 ? 00:00:00 asm_smon_+ASM
oracle 1604 1 0 22:52 ? 00:00:00 asm_rbal_+ASM
oracle 1606 1 0 22:52 ? 00:00:00 asm_gmon_+ASM
4) Run the following as root:
/u01/app/oracle/product/10.2.0/db_1/bin/localconfig delete
5) Restarted the database
Now when I try to go through the steps to create an ASM instance, at the point after I enter my ASM Parameters, I get the following prompt:
"DBCA will now create and start the ASM instance. After the ASM instance is started you can create the diskgroups to be used as storage for your database."
I click OK. Then I get the error message:
ORA-01012 not logged on
Please help/advise and be gentle. Thank you in advance.
[Updated on: Wed, 14 July 2010 23:12] Report message to a moderator
|
|
|
|
Re: Error creating ASM instance using DBCA [message #465891 is a reply to message #465613] |
Thu, 15 July 2010 22:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jxh461
Messages: 185 Registered: March 2005
|
Senior Member |
|
|
I restarted the orcl database (general purpose).
I renamed the spfile because the original error message was along the lines of "cannot create spfile, currently being used" . I was hoping that renaming it would make the asm creation process move along. But now I have the "not logged on" error message.
The mistake I made was to inadvertently skipp the part where I assign /dev/raw/raw* to the asm_diskstring parameter. I have sysdba permission on my sandbox.
Curiously I am finding this directory: /u01/app/oracle/admin/+ASM/
It contains the following direcories: bdump cdump pfile udump
Of which only the pfile contains the following files:
init.ora init.ora.6142010232649 init.ora.614201023477
init.ora.6142010231039 init.ora.6142010232859 init.ora.615201001615
init.ora.614201023115 init.ora.614201023329 init.ora.615201001620
init.ora.614201023151 init.ora.6142010233325 init.ora.615201001828
init.ora.6142010231559 init.ora.6142010233511 init.ora.61520100183
init.ora.6142010231758 init.ora.614201023433 init.ora.61520100915
init.ora.61420102318 init.ora.6142010234432 init.ora.6152010204959
init.ora.6142010232630 init.ora.614201023466
I am not sure how this is contributing to my problem. Please advise.
[Updated on: Thu, 15 July 2010 22:30] Report message to a moderator
|
|
|
|
|
|
|
|
Re: Error creating ASM instance using DBCA [message #466994 is a reply to message #466602] |
Wed, 21 July 2010 23:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jxh461
Messages: 185 Registered: March 2005
|
Senior Member |
|
|
Once I try to do it manually, the error seem more meaningful.
Can you please advise on what I ought to do about the following ?
SQL> create diskgroup diskgrp1 normal redundancy
failgroup controller1 disk
'/dev/shm/raw1' name diska1,
'/dev/shm/raw2' name diska2,
'/dev/shm/raw3' name diska3,
'/dev/shm/raw4' name diska4 2 3 4 5 6 ;
create diskgroup diskgrp1 normal redundancy
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/shm/raw4' matches no disks
ORA-15031: disk specification '/dev/shm/raw3' matches no disks
ORA-15031: disk specification '/dev/shm/raw2' matches no disks
ORA-15031: disk specification '/dev/shm/raw1' matches no disks
the content of my pfile which I used to create the spfile is as follows:
$ cat init+ASM.ora
asm_diskstring='/dev/shm/*'
background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile='SHARED'
user_dump_dest='/u01/app/oracle/admin/+ASM/udump'
I chose to use '/dev/shm/*' because in my Linux partition, it is the closest thing to what my manual suggested (/dev/raw/raw*).
$ df -h
/dev/sda2 15G 238M 14G 2% /
/dev/sda1 289M 14M 261M 5% /boot
none 1.5G 0 1.5G 0% /dev/shm
/dev/sda3 190M 95M 86M 53% /home
/dev/sda10 3.9G 41M 3.7G 2% /opt
/dev/sda9 3.9G 41M 3.7G 2% /tmp
/dev/sda6 7.7G 2.5G 4.9G 35% /usr
/dev/sda5 7.7G 50M 7.3G 1% /usr/local
/dev/sda8 3.9G 133M 3.6G 4% /var
/dev/sda11 28G 14G 13G 51% /u01/app/oracle
I ask because I don't know. Thanks for you patience
|
|
|
Re: Error creating ASM instance using DBCA [message #467034 is a reply to message #466994] |
Thu, 22 July 2010 01:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hi - I hope this doesn't sound like a silly question, but do you actually have any raw devices? Have you created them by, for example, partitioning a few SCSI discs?
And by the way, you shouldn't try to use devices in /dev/shm, they are your shared memory segments.
|
|
|
Re: Error creating ASM instance using DBCA [message #467237 is a reply to message #467034] |
Thu, 22 July 2010 20:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jxh461
Messages: 185 Registered: March 2005
|
Senior Member |
|
|
HI John, Here is what I have done
I created a filesystem /devasm/raw/ and mounted it on /dev/sda12 partition.
$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 15G 238M 14G 2% /
/dev/sda1 289M 14M 261M 5% /boot
none 1.5G 0 1.5G 0% /dev/shm
/dev/sda3 190M 97M 84M 54% /home
/dev/sda10 3.9G 41M 3.7G 2% /opt
/dev/sda9 3.9G 41M 3.7G 2% /tmp
/dev/sda6 7.7G 2.5G 4.9G 35% /usr
/dev/sda5 7.7G 50M 7.3G 1% /usr/local
/dev/sda8 3.9G 131M 3.6G 4% /var
/dev/sda11 28G 14G 13G 51% /u01/app/oracle
[b]/dev/sda12 950M 18M 885M 2% /devasm/raw[/b]
I set parameter asm_diskstring='/devasm/raw/*'
$ cat init+ASM.ora
[b]asm_diskstring='/devasm/raw/*'[/b]
background_dump_dest='/u01/app/oracle/admin/+ASM/bdump'
core_dump_dest='/u01/app/oracle/admin/+ASM/cdump'
instance_type='asm'
large_pool_size=12M
remote_login_passwordfile='SHARED'
user_dump_dest='/u01/app/oracle/admin/+ASM/udump'
I went on to do the following:
SQL> shutdown
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> create spfile from pfile;
File created.
SQL> startup nomount;
ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1217836 bytes
Variable Size 57502420 bytes
ASM Cache 25165824 bytes
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- -------------
asm_diskgroups string
asm_diskstring string /devasm/raw/*
asm_power_limit integer 1
SQL> create diskgroup diskgrp1 normal redundancy
failgroup controller1 disk
'/devasm/raw/raw1' name diska1,
'/devasm/raw/raw2' name diska2,
'/devasm/raw/raw3' name diska3,
'/devasm/raw/raw4' name diska4 2 3 4 5 6 ;
create diskgroup diskgrp1 normal redundancy
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/devasm/raw/raw4' matches no disks
ORA-15031: disk specification '/devasm/raw/raw3' matches no disks
ORA-15031: disk specification '/devasm/raw/raw2' matches no disks
ORA-15031: disk specification '/devasm/raw/raw1' matches no disks
What did I miss ?
Please advise, and many thanks in advance.
|
|
|
|
Re: Error creating ASM instance using DBCA [message #467551 is a reply to message #467250] |
Sun, 25 July 2010 19:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
jxh461
Messages: 185 Registered: March 2005
|
Senior Member |
|
|
Yes this is not a production system. While trying to figure out all things raw devices, I ended up corrupting my machine to were I could not reboot. I am going to reinstall and have at it again until I get it.
Thanks to all who contributed to my learning.
|
|
|