On Wed, 2010-09-01 at 09:28 -0700, Robbert van Andel wrote: > I am working with a USB drive supplied to us by a former contract company > that contains a backup of an Oracle databse. Looking at the file system, I > see this: > > drwxr-xr-x 6 60004 60004 4096 Jan 25 2010 . > drwxr-xr-x 11 root root 4096 Feb 20 2007 .. > drwxrwxrwx 4 60004 60004 4096 Dec 5 2007 6614448.992 > -rw------- 1 60004 60004 16883 Jan 25 2010 .bash_history > -rw-r--r-- 1 60004 60004 901 Oct 23 2009 .bash_profile > -rwxrwxrwx 1 60004 60004 424 Feb 1 2008 check_patches1.sh > -rwxrwxrwx 1 60004 60004 1220 Feb 1 2008 check_patches2.sh > As you can see, the owner and group are showing just a number. My guess is > this is the user id of the owner as it existed on the original server. Is > that correct? The company gave me a set of users to recreate but not the > original Second, is there a way to determine what correct this? > Unfortunately, asking the contractor is not an option. > > Thanks, > Robbert van Andel > _______________________________________________ > PLUG mailing list > [email protected] > http://lists.pdxlinux.org/mailman/listinfo/plug
Looks like the user this referred to is lost. This is a good reason to backup the password files along with a data backup. I don't think there is any way to figure out what is supposed to be in /etc/password from the bare number. If the user id was the same one that the database used, then set up Oracle if at all possible and chown to the Oracle user id. Ask an Oracle expert if there is a backup of Oracle how to extract from Oracle what the user name was from the id. If the user id doesn't have to be the same as the database id, my guess is that you can set a new user/group to 60004 with a name of your choosing. Thing is, and others can verify this probably, Oracle might be expecting a specific user name and group name stored in the data itself. Try googling the following: find database name oracle _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
