Regarding the OSUSER = 'oracle' question:
On Unix, the OSUSER is typically 'oracle' for background processes (LGWR, CKPT, etc). Actually, the OSUSER could be anything, it depends on how you installed Oracle and how it is started.
So, what's your question?
If you want specific instructions on how to install Oracle properly for your OS, see the Oracle documentation (Oracle9i Installation Guide Release 2 (22.214.171.124.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris).
The install doc says: "The oracle account is the UNIX user account that owns Oracle9i software after installation. You must run the Oracle Universal Installer with this user account."
Furthermore, it says: "Use the oracle account only for installing and maintaining Oracle software. Never use it for purposes unrelated to the Oracle9i server. Do not use the root account as the oracle account. ..... Sites with multiple Oracle home directories on one system may install Oracle software either with the same oracle account or with different ones. Each oracle account must have the ORAINVENTORY group as its primary group."
So, if your comment/question was to see if you could simply name the "oracle" account something other than "oracle", the answer is yes. But, if you have no pressing reason to do so or need to manage multiple Oracle home directories (as quoted above), my question back to you would be why? I tend to stick with standard conventions that are universally recognizable. If I were to look out at the OS to check processes and see a whole set of processes called "junior" or "monster", I'm not too sure how I'd react! :)
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in February 2003