Oracle Database Discussions

Hi all

Recently i have install oracle 11g R2 software ( Using oracle user).

oracle home owner is "oracle" and group "oinstall". ( oinstall is primary group and dba as secondary group for the owner "oracle")

At the same time I have create new user name "test" and group as "dba".
As a "test" user i can able to access the software , creating new oracle instance , stop and starting the oracle database (orcl).
But when I started the orcl database as test user.
I can see the different owner for that instance and file permission is also different ( In my cas oracle user is becoming owner for the orcl database , Which is created by the test user )

Please help me in this

For your reference
===============
[test@redhat5 ~]$ id
uid=504(test) gid=501(dba) groups=501(dba)
[test@redhat5 ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_SID=orcl
export ORACLE_HOME=/oraeng/app/oracle/product/11.2.0
export ORACLE_BASE=/oraeng/app/oracle
export PATH=$ORACLE_HOME/bin:$PATH:.
[test@redhat5 ~]$ sqlplus '/ as sysdba'


SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 25 22:20:08 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size 1341312 bytes
Variable Size 864028800 bytes
Database Buffers 201326592 bytes
Redo Buffers 4636672 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[test@redhat5 ~]$ ps -ef|grep pmon
oracle 9248 1 0 22:20 ? 00:00:00 ora_pmon_orcl
test 9329 9173 0 22:20 pts/2 00:00:00 grep pmon


Please see the ps command output owner of the instance is "oracle" , Actual instance started by "test" user

Regards
Arjun

Edited by: Arjun B on Sep 25, 2010 4:19 AM