Home » RDBMS Server » Server Administration » should i install ASM instance at the same user as the database ? (10g on linux redhat 4(unbreakable linux))
should i install ASM instance at the same user as the database ? [message #422008] Sun, 13 September 2009 02:10 Go to next message
samiraly
Messages: 48
Registered: June 2009
Member

i have installed ASM instance in a separet user other than database user, user called asmuser
[asmuser@test ~]$ id
uid=501(asmuser) gid=500(oinstall) groups=500(oinstall),501(dba)



then i started the asm instance as follows
SQL> startup
ASM instance started

Total System Global Area   83886080 bytes
Fixed Size                  1217836 bytes
Variable Size              57502420 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL>
SQL> select instance_name , database_status , status ,host_name from v$instance;
INSTANCE_NAME    DATABASE_STATUS   STATUS        HOST_NAME
----------------------------------------------------------------
+ASM             ACTIVE            STARTED   test.oracle.com


SQL> exit



then i tried to install oracle database on anoether user 'oracle'
the installation errors out the following error
you have chosen to use automatic storage managment (ASM)
for database file storage. the oracle database 10g installation
has detected that you have an existing ASM instance on this
system but that this instanceis not running at this time or disk
groups are not mountedon this instance. you must start the ASM
instance and/or mount the disk groups before proceeding with
the rest of the installation:w


is it mandatory to have both ASM instance and databse instance installed on the same user????????
thanks
Re: should i install ASM instance at the same user as the database ? [message #422016 is a reply to message #422008] Sun, 13 September 2009 08:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
While it is recommended to install ASM and Oracle in separate ORACLE_HOME, it is not required to install ASM and Oracle with separate users. If you are using RAC, CRS and Oracle should go in different ORACLE_HOME.

This is as little gray area with which I wanted to test myself but never got the time.
Oracle 10g lingo states we **may** want to above to separate the functionality.
But in reality ASM and Oracle are so dependent on each other (sharing the groups etc)
and I do not understand the separation here.

Quote:
[asmuser@test ~]$ id
uid=501(asmuser) gid=500(oinstall) groups=500(oinstall),501(dba)


Is that the case for oracle user also?
Oracle also in oinstall and dba?
Check Oratab. See if there are appropriate entries.
Shutdown ASM instance (through ASMUSER)
Logged in as Oracle, invoke DBCA and let it do the job (starting the asm instance and proceeding with installation).

If this does not work, look into logfiles, post something for us to see.

[Updated on: Sun, 13 September 2009 08:54]

Report message to a moderator

Re: should i install ASM instance at the same user as the database ? [message #422066 is a reply to message #422016] Mon, 14 September 2009 03:32 Go to previous message
samiraly
Messages: 48
Registered: June 2009
Member

Hi Maheesh

Thank you for your attention Smile
actually i am trying to install ASM instance in defferent user than
oracle database instance to make administring both of them more easy

oracle user and asmuser user are both in onistall and dba

i openrd asmuser and started asm instance and every thing is ok
haowever when trying to install oracle instance using oracle user
iterrors out that asm is not up.

when swhitching again to asmuser and checking asm instance i found it up and running this is the issue






Previous Topic: problem after installing ASM instance
Next Topic: How to generate SQL Server database scripts automatically
Goto Forum:
  


Current Time: Sun Sep 25 16:18:07 CDT 2016

Total time taken to generate the page: 0.12266 seconds