Can not create new Instances
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Can not create new Instances

  1. #1
    Join Date
    Oct 2006
    Posts
    1

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  3. #3
    Join Date
    Jun 2006
    Posts
    259
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width