Oracle Profile


 
Thread Tools Search this Thread
Operating Systems Solaris Oracle Profile
# 1  
Old 01-10-2011
Oracle Profile

So my oracle DBA emails me a profile.txt and tells me I need to install it for my oracle user account. what do I do with it?
# 2  
Old 01-10-2011
more informations... what's inside the file would be a good start?
# 3  
Old 01-10-2011
Sure, here is the text inside.


#
Code:
 @(#) $Revision: 72.2 $

# Default user .profile file (/usr/bin/sh initialization).

# Set up the terminal:
#       if [ "$TERM" = "" ]
#       then
#               eval ` tset -s -Q -m ':?hp' `
#       else
#               eval ` tset -s -Q `
#       fi
        stty erase "^H" kill "^U" intr "^c" eof "^D"
        stty hupcl ixon ixoff
        tabs

# Set up the search paths:
PATH=/u01/app/oracle/product/10.2.0/db_1/ctx/lib:/u01/app/oracle/product/10.2.0/db_1/bin:/u01/app/product/webdb/bin:/usr/bin:/etc:/usr/ccs/bin:/usr/openwin/bin:/u01/app/oracle/product/10.2.0/db_1/OPatch:.
# Set up the shell environment:
        set -u

        trap "echo 'logout'" 0
set -o vi
# Set up the shell variables:
        EDITOR=vi
        export EDITOR

#
# Set umask for Oracle Web Application Server
#
umask 022

#
# Oracle Environment Variables
#
ORATAB=/var/opt/oracle/oratab
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_HOME
ORACLE_SID=PCFDB
export ORACLE_SID
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
export TNS_ADMIN
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH
ORACLE_TERM=vt100 ; export ORACLE_TERM
TOOLS=/u01/app/CRON ; export TOOLS
WV_GATEWAY_CFG=/u01/app/product/webdb/listener/cfg/wdbsvr.app
export WV_GATEWAY_CFG

TEMP=/tmp
export TEMP
#Oracle Environment Variable needed for WEBDB Installation
#
# Oracle Web Application Server Environment Variables
#
#
# Oracle DBA Path Variables
#
obase=$ORACLE_BASE
ohome=$ORACLE_HOME
obin=$ORACLE_HOME/bin
odbs=$ORACLE_HOME/dbs
ordbms=$ORACLE_HOME/rdbms
onetadmin=$ORACLE_HOME/network/admin

onames=$ORACLE_HOME/network/names
onetlog=$ORACLE_HOME/network/log
oadmin=$ORACLE_BASE/admin/$ORACLE_SID
oarch=$ORACLE_BASE/admin/$ORACLE_SID/arch
obdump=$ORACLE_BASE/admin/$ORACLE_SID/bdump
ocdump=$ORACLE_BASE/admin/$ORACLE_SID/cdump
ocreate=$ORACLE_BASE/admin/$ORACLE_SID/create
opfile=$ORACLE_BASE/admin/$ORACLE_SID/pfile
oudump=$ORACLE_BASE/admin/$ORACLE_SID/udump
export obase ohome obin odbs ordbms oadmin
export oarch obdump ocdump ocreate opfile oudump

#
# Set Additional Path Variables
#
OPATH=$ORACLE_HOME/tools:$ORACLE_HOME/.local
OPROFILE_PATH=$ORACLE_BASE/dbaprofile
OPATH=$OPATH:$OPROFILE_PATH
PATH=$PATH:$OPATH
export PATH

#
#
# Set UNIX prompt to display machine & oracle SID
#
PS1="`uuname -l`:$ORACLE_SID> "

#
# Oracle SID Annnouncement
#
echo
echo '*********************************************************************'
echo '*********************************************************************'
echo 'Your HOME directory is' $HOME
echo
echo 'You are currently working as' $LOGNAME 'in SID' $ORACLE_SID
echo
echo 'The ORACLE BASE directory is' $ORACLE_BASE
echo 'The ORACLE HOME directory is' $ORACLE_HOME
echo '*********************************************************************'
echo '*********************************************************************'

if [ $TERM = "vt100" ]; then
   stty intr "^c"
fi
TMP=/db01/tmp
export TMP
TMPDIR=/tmp
export TMPDIR
stty erase "^H"

ulimit -s 32768
ulimit -n 4096

# 4  
Old 01-10-2011
the second line of the file should give you some clues... it's the user "oracle" login shell config file (.profile; in this case). place it in the useres homedir...
This User Gave Thanks to DukeNuke2 For This Post:
# 5  
Old 01-10-2011
so it's just oracle.profile?

---------- Post updated at 11:11 AM ---------- Previous update was at 10:43 AM ----------

I got it, Login on UNIX

Code:
. oracle.profile

bingo
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

2. Shell Programming and Scripting

Edit .profile to connect to Oracle- Linux 2.6.9-89

Hi, I want to connect to sqlplus through unix. I got the command to do it. But I was getting error: ./executeSQL.ksh: sqlplus: not found Then when I googled I found that we have to include Oracle Client path in .profile file. I don't know how to do it. Also I don't have permissions to... (2 Replies)
Discussion started by: dips_ag
2 Replies

3. Infrastructure Monitoring

trap in etc/profile and user .profile

Hello I really wonder what's trap in etc/profile and in each user .profile. I try to google for it but I think I have no luck. Mostly hit is SNMP traps which I think it is not the same thing. I want to know ... 1. What's a "trap 2 3" means and are there any other value I can set... (4 Replies)
Discussion started by: Smith
4 Replies

4. UNIX for Dummies Questions & Answers

difference between /etc/profile and .profile?

What is the difference between /etc/profile and .profile? (5 Replies)
Discussion started by: gehlnar
5 Replies

5. SCO

Difference between .profile and .~/.profile

what is the difference between these two lines, if we use it in korn shell script: .profile .~/.profile (3 Replies)
Discussion started by: maneesh mehta
3 Replies

6. UNIX for Dummies Questions & Answers

changed .profile but didnt ./.profile, yet reflected changes

hi , i added ls -F to .profile. and i need to do ./.profile for the effect to take effect BUT i didnt and YET the next day when i came to work and log in, the changes took effect. i am on aix. please explain.. thanks (4 Replies)
Discussion started by: yls177
4 Replies
Login or Register to Ask a Question