| should i install ASM instance at the same user as the database ? [message #422008] |
Sun, 13 September 2009 02:10  |
samiraly
Messages: 57
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  |
 |
Mahesh Rajendran
Messages: 10707
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
