Group ownership/creation

[Andre Lemon]

Having a problem with oracle working on a newly converted system. While doing a compare
between the two systems on the oracle login, the oracle dba found that the groups on files in the oracle accounts were different. I created a file 'andre' on both and confirmed his findings.

Original system:

-rw-rw-r-- 1 oracle dba 0 Dec 11 12:43 andre

new system:

-rw-rw-r-- 1 oracle 500 0 Dec 11 12:36 andre


This is what I get when I type id on the original system while logged on as oracle:

/home/oracle:BASE > id
uid=500(oracle) gid=500(dba) groups=107(dev),104(oinstall),105(omnidex)

and this is what I get while signed on as oracle on the newly converted system:

/u07/home/oracle:BASE > id
uid=500(oracle) gid=500() groups=107(),104(),105()

notice that for the gid, groups, 104 and 105 that nothing is contain between the parenthesis and they are on the original system.

Any ideas what may be going on and how to correct it?

Andre'

[James R. Ferguson]

Hi Andre:

It would appear that your '/etc/group' doesn't contain mappings for 'gid' 500, 104, 105 nor 107.

If so, verify that '/etc/group' is readable by everyone.

Regards!

...JRF...

[Jeff_Traigle]

Are valid entries for the dba, dev, oinstall, and omnidex groups in /etc/group on the new system? My first guess from the output you gave is that they are't.

[Andre Lemon]

Guys, i had checked those earlier.

current system:

nogroup:*:-2:
smbnull::101:
mysql::102:
hpsmh::79:
sshd::103:
dba::500:
dev::107:oracle,hpmprda,hpmprdd,hpmprdo
oinstall::104:oracle
omnidex::105:oracle
unispool::108:

new system:

nogroup:*:-2:
smbnull::101:
mysql::102:
hpsmh::79:
sshd::103:
dba::500:
dev::107:oracle,hpmprda,hpmprdd,hpmprdo
oinstall::104:oracle
omnidex::105:oracle
unispool::108:

To get all of the files over they were just restored from tape using Data Protector.

[Patrick Wallek · Accepted solution]

Check the permissions on the /etc/group file.

They should be 444, -r--r--r--.

If it is anything else do a 'chmod 444 /etc/group

[Andre Lemon]

You have got it....


Here is the listing before I make any changes to it...

Original system:

# ll /etc/group
-r--r--r-- 1 bin bin 6697 Dec 11 12:27
/etc/group

new system

# ll /etc/group
-rw-r-----1 root sys 6665 Dec 11 12:24
/etc/group

Should the root sys be changed to bin bin also?

[Patrick Wallek]

Yes, you probably should change the ownership back to bin:bin as well.

[Andre Lemon]

Thanks guys. Patrick that was the problem.



Andre'