Can not create new Instances
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