Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
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.