Operating System - HP-UX
1748126 Members
3290 Online
108758 Solutions
New Discussion юеВ

Re: Oracle 8.1.7 database creation problem

 
SOLVED
Go to solution
AYMA
Advisor

Oracle 8.1.7 database creation problem

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
8 REPLIES 8
Shaikh Imran
Honored Contributor

Re: Oracle 8.1.7 database creation problem

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

Regs
I'll sleep when i am dead.
Sanjay Kumar Suri
Honored Contributor

Re: Oracle 8.1.7 database creation problem

check the uid & gid with
$id
$groups

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

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Jean-Luc Oudart
Honored Contributor
Solution

Re: Oracle 8.1.7 database creation problem

Have you completed the whole instalation process ?

what are the permissions for oracle, svrmgrl :

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

Regards,
Jean-Luc
fiat lux
Greg OBarr
Regular Advisor

Re: Oracle 8.1.7 database creation problem


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..
AYMA
Advisor

Re: Oracle 8.1.7 database creation problem

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.
Ron Gordon
Advisor

Re: Oracle 8.1.7 database creation problem

Did you run root.sh ? You might want to run it again
Jean-Luc Oudart
Honored Contributor

Re: Oracle 8.1.7 database creation problem

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.
fiat lux
AYMA
Advisor

Re: Oracle 8.1.7 database creation problem

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