Home / server / Questions / 134964
Accepted
Kwang Mark Eleven
Asked: 2010-04-23 08:03:01 +0800 CST

How do you determine the OWNER of an Oracle Database

  • 772

When you install an Oracle database in a Unix server, the Unix user id you use for the installation becomes the OWNER of the database. What is the most reliable and general way of determining in a shell script which Unix user is the owner of an Oracle installation? I mean, can you perform a grep on a file created by the installation to find this information or shall I resort to use the ls command on a specific file on a specific directory. If the name of the file to be checked is also variable, I would need to have a way of determining the name and path to the file.

oracle owner

3 Answers

  1. Best Answer

    Look for the file named "oratab", usually found in either /etc or /var/opt/oracle. In there you will find for each database the name of the home directory for that database. The owner of that directory should be the owner of the installation and of all databases running from the home.

    This might be of some use, assuming the oratab file is in /var/opt/oracle:

    ls -ld `grep 'your_db_name' /var/opt/oracle/oratab|cut -d":" -f2`|cut -d" " -f4

    The other solutions offered here that examine the owner of the process should work as well, but require the database to be running. This solution offers the advantage that it does not require the instance to be up.

    • 2

  2. I'm not a professional Oracle DBA, but it has been my experience that the owner of the database is the owner of the Oracle processes. A reliable process to check would probably be ora_pmon.

    • 1 
  3. ps -ef | grep <process name or id> | awk '{print $1}'

    this should give you the name of the user process is running as.

    • 1