OraFAQ Forum: Server Administration » How do I create an ASM?

Home » RDBMS Server » Server Administration » How do I create an ASM?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do I create an ASM? [message #240999]

Mon, 28 May 2007 03:16

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Dear all!
I am newbie on ASM studying. This is the first time I try to create an ASM, and I referred one article from:

http://www.oracle-base.com/articles/10g/AutomaticStorageManagement10g.php

But I could not performed one of those step in that article..This is:

To create an ASM instance first create a file called init+ASM.ora in the /tmp directory containing the following information.

INSTANCE_TYPE=ASM

Next, using SQL*Plus connect to the ide instance.

export ORACLE_SID=+ASM
sqlplus / as sysdba

In the SQL*Plus, export is not a command, how do I do this step?
Thank you!

P/S: Where is the ASM documents can I try to study?

Report message to a moderator

Re: How do I create an ASM? [message #241000 is a reply to message #240999]

Mon, 28 May 2007 03:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You execute "export" BEFORE calling sqlplus as it is written.
First, export ...
Then, sqlplus / as sysdba

Regards
Michel

Report message to a moderator

Re: How do I create an ASM? [message #241008 is a reply to message #241000]

Mon, 28 May 2007 03:31

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Thank you, Michel for your reply!
I am sorry, but I don't understand everything you wrote down.

Do this command "Export" must be in what environment?
In the C:\>, or in the C:\> Sqlplus /nolog, then SQL> ?

Report message to a moderator

Re: How do I create an ASM? [message #241010 is a reply to message #241008]

Mon, 28 May 2007 03:41

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This why you should ALWAYS post your OS.
The equivalent for "export" in Windows is SET.

Btw, where do you find "/tmp" on your Windows system?

Regards
Michel

Report message to a moderator

Re: How do I create an ASM? [message #241013 is a reply to message #241010]

Mon, 28 May 2007 03:46

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Oh, thank you very much, Michel.
Have a good day!

Report message to a moderator

Re: How do I create an ASM? [message #241045 is a reply to message #241013]

Mon, 28 May 2007 04:25

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

http://www.oracle.com/technology/products/database/asm/index.html

Report message to a moderator

Re: How do I create an ASM? [message #241215 is a reply to message #241045]

Mon, 28 May 2007 21:32

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

To create an ASM instance as the article guides, I had got error as this image.

Please guide me if I was wrong.
+ Create an Init+ASM.ora with following information:
INSTANCE_TYPE=ASM
+ Connect to DB with SQL*Plus:
C:\>sqlplus /nolog
SQL>create spfile from pfile='/asm/init+asm.ora';
And the error occurred as in image.

Thank you!

Attachment: untitled.jpg
(Size: 19.46KB, Downloaded 671 times)

Report message to a moderator

Re: How do I create an ASM? [message #241233 is a reply to message #241215]

Mon, 28 May 2007 23:36

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your Oracle version (4 decimals)?

Regards
Michel

Report message to a moderator

Re: How do I create an ASM? [message #241238 is a reply to message #241233]

Mon, 28 May 2007 23:46

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

My Oracle is 9.2.0.1.0!
I check some information in DBInit.ora, and I found that it's only Instance_name, not Instance_type!

Regard!

[Updated on: Mon, 28 May 2007 23:46]

Report message to a moderator

Re: How do I create an ASM? [message #241244 is a reply to message #241238]

Mon, 28 May 2007 23:55

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ASM does not exist in 9.2 only 10g.

Regards
Michel

Report message to a moderator

Re: How do I create an ASM? [message #241249 is a reply to message #241244]

Tue, 29 May 2007 00:08

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Thank you for your guide, Michel!

Best Regard!

Report message to a moderator

Previous Topic:	knowing parse code
Next Topic:	Delete ORAARCH folder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 11:59:09 CST 2024