Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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