Bash profile example for oracle account on Linux / Unix

 # .bash_profile

 # Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

 # User specific environment and startup programs
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

 # Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

 ORACLE_HOSTNAME=testdb.domainname; export ORACLE_HOSTNAME
ORACLE_UNQNAME=testdb; export ORACLE_UNQNAME
ORACLE_BASE=/u01/oracle/11.2.0; export ORACLE_BASE
ORACLE_SID=testdb; export ORACLE_SID
ORACLE_HOME=/u01/oracle/11.2.0/db_home; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM

 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

 BASE_PATH=/usr/sbin:$PATH:$HOME/bin; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

 alias sql=’sqlplus / as sysdba’
alias home=’cd $ORACLE_HOME’
alias db=’export ORACLE_SID=testdb’
alias alert_db=’tail -55f /u01/oracle/11.2.0/diag/rdbms/testdb/testdb/trace/alert_testdb.log’

Comments

Post a Comment

Popular posts from this blog

Remove the spurious CR characters The ^M is a carriage return character. Linux uses the line feed character to mark the end of a line, whereas Windows uses the two-character sequence CR LF. Your file has Windows line endings, which is confusing Linux. You can remove the spurious CR characters with the following command: sed -i -e 's/\r$//' 
Read more
[Enter Post Title Here] All About Statistics In Oracle In this post I'll try to summarize all sorts of statistics in Oracle, I strongly recommend reading the full article, as it contains information you may find it valuable in understanding Oracle statistics. ##################################### Database | Schema | Table | Index Statistics ##################################### Gather Database Statistics : ======================= SQL> EXEC DBMS_STATS.GATHER_DATABASE_STATS(      ESTIMATE_PERCENT=>100,METHOD_OPT=>'FOR ALL COLUMNS SIZE SKEWONLY',       CASCADE => TRUE,       degree => 4,       OPTIONS => 'GATHER STALE',       GATHER_SYS => TRUE,       STATTAB => PROD_STATS); CASCADE => TRUE  :Gather statistics on the indexes as well. If not used Oracle will decide whether to collect index statistics or not. DEGREE => 4 :Degree of parallelism. options:          =>'GATHER'  :Gathers statistics on
Read more
Change bytes into char inside data type of VARCHAR2   begin for r in     (select owner, table_name, column_name, data_length       from all_tab_columns       where data_type = 'VARCHAR2'        and char_used = 'B' and owner = 'SCHEMA') loop execute immediate 'alter table ' || r.owner || '.' || r.table_name || ' modify '  || r.column_name  || ' varchar2(' || r.data_length || ' char)'; end loop; end; / Note: Replace SCHEMA with owner of the tables
Read more