Can not create new Instances

[Aditya Purwanto]

Friends,

I want to create a new instance on solaris server.

When i instal oracle engine i using a user let's call it user1
and after that i want to create a new instances using different user, let's say user2.

when i run CreateDBdatabase1.sql i got an error messages:

CREATE DATABASE "database1"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/pbopicsdata01/oradata/popics/control01.ctl'
ORA-27040: file create error, unable to create file
SVR4 Error: 13: Permission denied


when i check it using ps -ef|grep pmon:
user1 2435 22571 0 08:40:55 ?? 0:00 ora_pmon_database1

but when i checked using id
uid=1003(user2) gid=101(dba)

so i think the error occure because of this i start using user2 but service ora_pmon_database1 was created by user1

Right now my solution is to change all permission of file system who corelated with create a new instance into chmod 770, so user from the same group can access it.

What I need to know is:
1.How to solve that problem in another way?
2.How can i tell oracle that i want to run ora_pmon_database1 using
user2 (user who login to the server) not user who install the oracle
engine?


Regards,

Aditya Purwanto

[davey23uk]

the problem is that whoever owns the oracle software cannot write to /pbopicsdata01/oradata/popics/
you need to sort that out - it doesnt matter who started the database

[ixion]

Why would you want to go through that effort?
Just install oracle software/engine as Oracle and group dba....
Then start the software as oracle.