Home » RDBMS Server » Server Administration » How do I create an ASM?
How do I create an ASM? [message #240999] Mon, 28 May 2007 03:16 Go to next message
trantuananh24hg
Messages: 668
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?
Re: How do I create an ASM? [message #241000 is a reply to message #240999] Mon, 28 May 2007 03:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You execute "export" BEFORE calling sqlplus as it is written.
First, export ...
Then, sqlplus / as sysdba

Regards
Michel
Re: How do I create an ASM? [message #241008 is a reply to message #241000] Mon, 28 May 2007 03:31 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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> ?

Re: How do I create an ASM? [message #241010 is a reply to message #241008] Mon, 28 May 2007 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How do I create an ASM? [message #241013 is a reply to message #241010] Mon, 28 May 2007 03:46 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Oh, thank you very much, Michel.
Have a good day!
Re: How do I create an ASM? [message #241045 is a reply to message #241013] Mon, 28 May 2007 04:25 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://www.oracle.com/technology/products/database/asm/index.html
Re: How do I create an ASM? [message #241215 is a reply to message #241045] Mon, 28 May 2007 21:32 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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 121 times)
Re: How do I create an ASM? [message #241233 is a reply to message #241215] Mon, 28 May 2007 23:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your Oracle version (4 decimals)?

Regards
Michel
Re: How do I create an ASM? [message #241238 is a reply to message #241233] Mon, 28 May 2007 23:46 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ASM does not exist in 9.2 only 10g.

Regards
Michel
Re: How do I create an ASM? [message #241249 is a reply to message #241244] Tue, 29 May 2007 00:08 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you for your guide, Michel!

Best Regard!
Previous Topic: knowing parse code
Next Topic: Delete ORAARCH folder
Goto Forum:
  


Current Time: Tue Dec 06 12:03:45 CST 2016

Total time taken to generate the page: 0.15400 seconds