topic Re: Oracle 8.1.7 database creation problem in Operating System - HP-UX

Oracle 8.1.7 database creation problem

AYMA — Wed, 31 Mar 2004 04:15:02 GMT

Hello,
I have installed an Oracle 8.1.7 server on a B2600 with 11.11. When I tried to create the tablespace with svrmgrl (under oracle account), the .dbf files have owner/group root sys instead of oracle dba.
Any idea ?
Thanks for your help
Best regards

Re: Oracle 8.1.7 database creation problem

Shaikh Imran — Wed, 31 Mar 2004 05:07:13 GMT

Hi,
Please change the group to oracle:dba of the home directory of oracle.
Example:
chgrp oracle:dba /home/oracle

Regs

Re: Oracle 8.1.7 database creation problem

Sanjay Kumar Suri — Wed, 31 Mar 2004 05:14:11 GMT

check the uid & gid with
$id
$groups

command. Look at /etc/passwd, /etc/groups and make necessary changes.

sks

Re: Oracle 8.1.7 database creation problem

Jean-Luc Oudart — Wed, 31 Mar 2004 05:16:34 GMT

Have you completed the whole instalation process ?

what are the permissions for oracle, svrmgrl :

ll $(which oracle)
ll $(which svrmgrl)

Regards,
Jean-Luc

Re: Oracle 8.1.7 database creation problem

Greg OBarr — Thu, 01 Apr 2004 09:27:09 GMT

Who is the owner of the directory where you are creating the tablespace?
should be oracle:dba

Who is the owner of the svrmgrl binary? should be oracle:dba

Could also just shut down the database and then chown the datafile to oracle:dba, then startup again if you're pressed for time..

Re: Oracle 8.1.7 database creation problem

AYMA — Thu, 01 Apr 2004 10:33:11 GMT

With your replies,I have found the solution of my issue.
The problem was due to bad permission for the
oracle binary (root/sys instead of oracle/oinstall). I don't know why only this binary has this bad owner/group in the bin directory....
Thanks for your help.

Re: Oracle 8.1.7 database creation problem

Ron Gordon — Thu, 01 Apr 2004 11:19:45 GMT

Did you run root.sh ? You might want to run it again

Re: Oracle 8.1.7 database creation problem

Jean-Luc Oudart — Thu, 01 Apr 2004 11:20:36 GMT

and now you have a solution to your problem, you should assign points (with obviously a bunny)
many thanks,
Jean-Luc
PS : no point on this last post.

Re: Oracle 8.1.7 database creation problem

AYMA — Fri, 02 Apr 2004 01:17:13 GMT

Yes the root.sh had been run during the installation porcedure. Only Oracle has this owner/group, not the others.
Thanks.