Can not create new Instances
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
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
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
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.
Click Here to Expand Forum to Full Width