User ID, Oracle SID, and Directory at UNIX Prompt

Instead of checking your environment variables or running whoami and pwd to make sure your unix session is set to the correct database and directory to run a program or script or upgrade, you can add the following line to the end of your .profile file in your unix home directory to show your unix user ID and the Oracle SID and current working directory at the unix prompt (instead of just showing a dollar sign).  For example, if I'm in my home directory and production database, this shows "srea:PROD:/home/srea$ " for my unix prompt.

PS1='$USER:$ORACLE_SID:$PWD\$ '

If you want all database users to see this session information whenever they log into unix, you could put it at the end of the oraenv script (such as /usr/lbin/oraenv).  This line works for AIX unix korn shell.  For other unix versions, you can look through the comp.unix.aix archives in usenet, searching for the word "prompt", for the appropriate prompt command (http://www.unixguide.net/ibm/faq/faq6.10.shtml has a search you can use).

Copyright © 2009 by Maristream.   All information, scripts, forms, and other material
on this web site are freely available to all Banner and Oracle Database Administrators,
Systems Administrators, Programmers, and others that may need it.

The webmaster who maintains this web site may be reached at srea@maristream.org. Visit our other web sites:

Disclaimer:  As with all software, especially where it affects your vital data, make sure that you examine theses scripts and that you understand what they do before you use them to see if they would have any adverse effect on your particular setup or database layout.  Make a full backup of your database in case you have to revert to your original copy of the database before the scripts were run.  Use these scripts at your own risk.  As a condition of using these scripts, you agree to hold harmless both Maristream and Stephen Rea for any problems that they may cause or other situations that may arise from their use, and that neither Maristream nor I will be held liable for those consequences.