| Creating a new database instance as a diferent unix user. [message #52550] |
Mon, 29 July 2002 11:37  |
Prasad
Messages: 104
Registered: October 2000
|
Senior Member |
|
|
Hi,
In a Sun box , I have 3 unix users 'oracle','oraprod' and 'orastage' all are under the same group (DBA ). I installed oracle 8.1.7 as 'oracle' user. Then connected as 'oraprod' and created a new database instance ORAPROD. when the instance is up and running I checked the process status and all the ORAPROD processors are owned by user 'oracle' ( not 'oraprod' ). here is the snap shot
$id
uid=1003(oraprod) gid=102(dba)
## created the datbase instance ............
$ ps -ef|grep ORAPROD
oracle 7922 1 0 11:54:55 ? 0:00 ora_pmon_ORAPROD
oracle 7924 1 0 11:54:55 ? 0:00 ora_dbw0_ORAPROD
oracle 7940 1 0 11:54:57 ? 0:00 ora_snp3_ORAPROD
oracle 7932 1 0 11:54:56 ? 0:00 ora_reco_ORAPROD
oracle 7926 1 0 11:54:56 ? 0:00 ora_lgwr_ORAPROD
oracle 7928 1 0 11:54:56 ? 0:00 ora_ckpt_ORAPROD
oracle 7936 1 0 11:54:56 ? 0:00 ora_snp1_ORAPROD
oracle 7938 1 0 11:54:57 ? 0:00 ora_snp2_ORAPROD
oracle 7930 1 0 11:54:56 ? 0:00 ora_smon_ORAPROD
oracle 7934 1 0 11:54:56 ? 0:00 ora_snp0_ORAPROD
why is it happening? . can some one help me? My intention is -- only 'oraprod' user should be able stop & start the ORAPROD database instance.
Thanks in advance
Prasad.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
