Örnek Template Çoklu Database İçin .profile ve .bash_profile
11G
linux oracle .bash_profile
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 |
#Version 02092014_linux # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin:/sbin export PATH ##SID s ORACLE_SIDA=orcl1 ; export ORACLE_SIDA ORACLE_SIDB=dvlp ; export ORACLE_SIDB ORACLE_SIDC=tst ; export ORACLE_SIDC ORACLE_UNQNAME=orcl ##Hostname HOST_NAME=x3n1 ; export HOST_NAME echo "Enter your Choice" echo "1) Oracle11g RAC-11.2.0.4 Database - $ORACLE_SIDA" echo "2) Oracle11g RAC-11.2.0.4 Database - $ORACLE_SIDB" echo "3) Oracle11g RAC-11.2.0.x Database - $ORACLE_SIDC" read ans if [ $ans -eq '1' ]; then ORACLE_SID=$ORACLE_SIDA; export ORACLE_SID ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export ORACLE_HOME CRS_HOME=/u01/11.2.0/grid; export CRS_HOME ORACLE_INSTANCE1=$ORACLE_SIDA1; export ORACLE_INSTANCE1 ORACLE_INSTANCE2=$ORACLE_SIDA2; export ORACLE_INSTANCE2 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/simpana/Base; export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin::$CRS_HOME/bin:$ORACLE_HOME/OPatch ####Aliases alias ll='ls -ltr' alias agr='tail -200f '$CRS_HOME'/log/'$HOST_NAME'/alert'$HOST_NAME'.log' alias adb='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_UNQNAME'/'$ORACLE_SIDA'/trace/alert_'$ORACLE_SIDA'.log' alias sql='sqlplus / as sysdba' alias ohdb='cd '$ORACLE_HOME'' alias ohgr='cd '$CRS_HOME'' alias diag='cd '$ORACLE_BASE'/diag/' alias netgr='cd '$CRS_HOME'/network/admin/' alias netdb='cd '$ORACLE_HOME'/network/admin' alias dbsdb='cd '$ORACLE_HOME'/dbs/' alias dbsgr='cd '$CRS_HOME'/dbs/' alias racd='crsctl status resource -w "TYPE co 'ora'" -t' alias dgblog='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_UNQNAME'/'$ORACLE_SIDA'1/trace/drc'$ORACLE_SIDA'1.log' alias aasm='tail -200f '$ORACLE_BASE'/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log' elif [ $ans -eq '2' ]; then ##### 2 #### ORACLE_SID=$ORACLE_SIDB; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export ORACLE_HOME CRS_HOME=/u01/11.2.0/grid; export CRS_HOME ORACLE_UNQNAME=ORACLE_SIDB; export ORACLE_UNQNAME ORACLE_INSTACE1=$ORACLE_SIDB1; export ORACLE_INSTACE1 ORACLE_INSTACE2=$ORACLE_SIDB2; export ORACLE_INSTACE2 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/simpana/Base; export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin:$CRS_HOME/bin:$ORACLE_HOME/OPatch ####Aliases alias ll='ls -ltr' alias agr='tail -200f '$CRS_HOME'/log/'$HOST_NAME'/alert'$HOST_NAME'.log' alias adb='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDB'/'$ORACLE_SIDB'/trace/alert_'$ORACLE_SIDB'.log' alias sql='sqlplus / as sysdba' alias ohdb='cd '$ORACLE_HOME'' alias ohgr='cd '$CRS_HOME'' alias diag='cd '$ORACLE_BASE'/diag/' alias netgr='cd '$CRS_HOME'/network/admin/' alias netdb='cd '$ORACLE_HOME'/network/admin' alias dbsdb='cd '$ORACLE_HOME'/dbs/' alias dbsgr='cd '$CRS_HOME'/dbs/' alias racd='crsctl status resource -w "TYPE co 'ora'" -t' alias dgblog='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDB'/'$ORACLE_SIDB'1/trace/drc'$ORACLE_SIDB'1.log' alias aasm='tail -200f '$ORACLE_BASE'/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log' ##### 2 #### ################### elif [ $ans -eq '3' ]; then ### 3 #### ORACLE_SID=$ORACLE_SIDC; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1; export ORACLE_HOME CRS_HOME=/u01/11.2.0/grid; export CRS_HOME ORACLE_UNQNAME=ORACLE_SIDC; export ORACLE_UNQNAME ORACLE_INSTACE1=$ORACLE_SIDC1; export ORACLE_INSTACE1 ORACLE_INSTACE2=$ORACLE_SIDC2; export ORACLE_INSTACE2 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/simpana/Base; export LD_LIBRARY_PATH export AWT_TOOLKIT=XToolkit # "libXm.so.4: open failed: No such file or directory" hatasi ile ilgili ####Aliases alias ll='ls -ltr' alias agr='tail -200f '$CRS_HOME'/log/'$HOST_NAME'/alert'$HOST_NAME'.log' alias adb='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDC'/'$ORACLE_SIDC'/trace/alert_'$ORACLE_SIDC'.log' alias sql='sqlplus / as sysdba' alias ohdb='cd '$ORACLE_HOME'' alias ohgr='cd '$CRS_HOME'' alias diag='cd '$ORACLE_BASE'/diag/' alias netgr='cd '$CRS_HOME'/network/admin/' alias netdb='cd '$ORACLE_HOME'/network/admin' alias dbsdb='cd '$ORACLE_HOME'/dbs/' alias dbsgr='cd '$CRS_HOME'/dbs/' alias racd='crsctl status resource -w "TYPE co 'ora'" -t' alias dgblog='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDC'/'$ORACLE_SIDC'1/trace/drc'$ORACLE_SIDC'1.log' alias aasm='tail -200f '$ORACLE_BASE'/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log' ### 3 #### else echo "Oracle degiskenleri etkinlestirilmedi ! ! !" fi |
***********
linux grid .bash_profile
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
#Version 14082014_linux # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin ; export PATH CRS_HOME=/u01/11.2.0/grid: export CRS_HOME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=+ASM1; export ORACLE_SID PATH=$PATH:$CRS_HOME/bin:$CRS_HOME/OPatch:/usr/bin:/etc:/usr/local/bin: ; export PATH LD_LIBRARY_PATH=$CRS_HOME/lib; export LD_LIBRARY_PATH export AWT_TOOLKIT=XToolkit ################################## ##SID s ORACLE_SIDA=orcl; export ORACLE_SIDA ################################## ####Aliases alias vi='vim' alias ll='ls -ltr' alias agr='tail -200f '$CRS_HOME'/log/'$HOST_NAME'/alert'$HOST_NAME'.log' alias adb='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDA'/'$ORACLE_SIDA'/trace/alert_'$ORACLE_SIDA'.log' alias sql='sqlplus / as sysdba' alias ohdb='cd '$ORACLE_HOME'' alias ohgr='cd '$CRS_HOME'' alias diag='cd '$ORACLE_BASE'/diag/' alias netgr='cd '$CRS_HOME'/network/admin/' alias netdb='cd '$ORACLE_HOME'/network/admin' alias dbsdb='cd '$ORACLE_HOME'/dbs/' alias dbsgr='cd '$CRS_HOME'/dbs/' alias racd='crsctl status resource -w "TYPE co 'ora'" -t' alias dgblog='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDA'/'$ORACLE_SIDA'1/trace/drc'$ORACLE_SIDA'1.log' alias aasm='tail -200f '$ORACLE_BASE'/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log' |
**********
unix oracle .profile
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 |
#Version 14082014_solaris # .profile oracle PATH=$PATH:$HOME/bin export PATH ###################################### MAIL=/usr/mail/$<LOGNAME:?> EDITOR=vi EDITOR=vi ; export EDITOR hostname=`hostname` ; export hostname username=oracle_rdbms ;export username PS1='$-$ $ ' export PS1 ##################################### ##SID s ORACLE_SIDA=orcl; export ORACLE_SIDA ORACLE_SIDB=dvlp; export ORACLE_SIDB ORACLE_SIDC=tst; export ORACLE_SIDC #ORACLE_UNQNAME=mx ##Hostname HOST_NAME=db ; export HOST_NAME echo "Enter your Choice" echo "1) Oracle11g RAC-11.2.0.x Database - $ORACLE_SIDA" echo "2) Oracle11g RAC-11.2.0.x Database - $ORACLE_SIDB" echo "3) Oracle11g RAC-11.2.0.x Database - $ORACLE_SIDC" read ans if [ $ans -eq '1' ]; then ORACLE_SID=$ORACLE_SIDA; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME CRS_HOME=/u01/11.2.0/grid; export CRS_HOME ORACLE_UNQNAME=ORACLE_SIDA; export ORACLE_UNQNAME ORACLE_INSTACE1=$ORACLE_SIDA1; export ORACLE_INSTACE1 ORACLE_INSTACE2=$ORACLE_SIDA2; export ORACLE_INSTACE2 PATH=$PATH:$ORACLE_HOME/bin: PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/bin:/etc:/usr/openwin/bin:/usr/X11/bin:/usr/sbin:/usr/ccs/bin:/usr/local/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/simpana/Base; export LD_LIBRARY_PATH export AWT_TOOLKIT=XToolkit # "libXm.so.4: open failed: No such file or directory" hatasi ile ilgili EDITOR=vi; export EDITOR ####Aliases alias ll='ls -ltr' alias agr='tail -200f '$CRS_HOME'/log/'$HOST_NAME'/alert'$HOST_NAME'.log' alias adb='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDA'/'$ORACLE_SIDA'/trace/alert_'$ORACLE_SIDA'.log' alias sql='sqlplus / as sysdba' alias ohdb='cd '$ORACLE_HOME'' alias ohgr='cd '$CRS_HOME'' alias diag='cd '$ORACLE_BASE'/diag/' alias netgr='cd '$CRS_HOME'/network/admin/' alias netdb='cd '$ORACLE_HOME'/network/admin' alias dbsdb='cd '$ORACLE_HOME'/dbs/' alias dbsgr='cd '$CRS_HOME'/dbs/' alias racd='crsctl status resource -w "TYPE co 'ora'" -t' alias dgblog='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDA'/'$ORACLE_SIDA'1/trace/drc'$ORACLE_SIDA'1.log' alias aasm='tail -200f '$ORACLE_BASE'/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log' elif [ $ans -eq '2' ]; then ##### 2 #### ORACLE_SID=$ORACLE_SIDB; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME CRS_HOME=/u01/11.2.0/grid; export CRS_HOME ORACLE_UNQNAME=ORACLE_SIDB; export ORACLE_UNQNAME ORACLE_INSTACE1=$ORACLE_SIDB1; export ORACLE_INSTACE1 ORACLE_INSTACE2=$ORACLE_SIDB2; export ORACLE_INSTACE2 PATH=$PATH:$ORACLE_HOME/bin: PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/bin:/etc:/usr/openwin/bin:/usr/X11/bin:/usr/sbin:/usr/ccs/bin:/usr/local/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/simpana/Base; export LD_LIBRARY_PATH export AWT_TOOLKIT=XToolkit # "libXm.so.4: open failed: No such file or directory" hatasi ile ilgili EDITOR=vi; export EDITOR ####Aliases alias ll='ls -ltr' alias agr='tail -200f '$CRS_HOME'/log/'$HOST_NAME'/alert'$HOST_NAME'.log' alias adb='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDB'/'$ORACLE_SIDB'/trace/alert_'$ORACLE_SIDB'.log' alias sql='sqlplus / as sysdba' alias ohdb='cd '$ORACLE_HOME'' alias ohgr='cd '$CRS_HOME'' alias diag='cd '$ORACLE_BASE'/diag/' alias netgr='cd '$CRS_HOME'/network/admin/' alias netdb='cd '$ORACLE_HOME'/network/admin' alias dbsdb='cd '$ORACLE_HOME'/dbs/' alias dbsgr='cd '$CRS_HOME'/dbs/' alias racd='crsctl status resource -w "TYPE co 'ora'" -t' alias dgblog='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDB'/'$ORACLE_SIDB'1/trace/drc'$ORACLE_SIDB'1.log' alias aasm='tail -200f '$ORACLE_BASE'/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log' ##### 2 #### elif [ $ans -eq '3' ]; then ### 3 #### ORACLE_SID=$ORACLE_SIDC; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME CRS_HOME=/u01/11.2.0/grid; export CRS_HOME ORACLE_UNQNAME=ORACLE_SIDC; export ORACLE_UNQNAME ORACLE_INSTACE1=$ORACLE_SIDC1; export ORACLE_INSTACE1 ORACLE_INSTACE2=$ORACLE_SIDC2; export ORACLE_INSTACE2 PATH=$PATH:$ORACLE_HOME/bin: PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/bin:/etc:/usr/openwin/bin:/usr/X11/bin:/usr/sbin:/usr/ccs/bin:/usr/local/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/simpana/Base; export LD_LIBRARY_PATH export AWT_TOOLKIT=XToolkit # "libXm.so.4: open failed: No such file or directory" hatasi ile ilgili EDITOR=vi; export EDITOR ####Aliases alias ll='ls -ltr' alias agr='tail -200f '$CRS_HOME'/log/'$HOST_NAME'/alert'$HOST_NAME'.log' alias adb='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDC'/'$ORACLE_SIDC'/trace/alert_'$ORACLE_SIDC'.log' alias sql='sqlplus / as sysdba' alias ohdb='cd '$ORACLE_HOME'' alias ohgr='cd '$CRS_HOME'' alias diag='cd '$ORACLE_BASE'/diag/' alias netgr='cd '$CRS_HOME'/network/admin/' alias netdb='cd '$ORACLE_HOME'/network/admin' alias dbsdb='cd '$ORACLE_HOME'/dbs/' alias dbsgr='cd '$CRS_HOME'/dbs/' alias racd='crsctl status resource -w "TYPE co 'ora'" -t' alias dgblog='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDC'/'$ORACLE_SIDC'1/trace/drc'$ORACLE_SIDC'1.log' alias aasm='tail -200f '$ORACLE_BASE'/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log' ### 3 #### else echo "Oracle deÄŸiÅŸkenleri etkinleÅŸtirilmedi. ! ! !" fi |
unix grid .profile
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
#Version 14082014_solaris # .profile ###################################### MAIL=/usr/mail/$<LOGNAME:?> EDITOR=vi EDITOR=vi ; export EDITOR hostname=`hostname` ; export hostname username=grid_crs ;export username PS1='$-$ $ ' export PS1 ##################################### CRS_HOME=/u01/11.2.0/grid: export CRS_HOME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=+ASM1; export ORACLE_SID PATH=$PATH:$CRS_HOME/bin: PATH=$CRS_HOME/bin:$CRS_HOME/OPatch:/usr/bin:/etc:/usr/openwin/bin:/usr/X11/bin:/usr/sbin:/usr/ccs/bin:/usr/local/bin:$PATH; export PATH LD_LIBRARY_PATH=$CRS_HOME/lib; export LD_LIBRARY_PATH export AWT_TOOLKIT=XToolkit ################################## ##SID s ORACLE_SIDA=orcl; export ORACLE_SIDA ################################## alias ll='ls -ltr' alias agr='tail -200f '$CRS_HOME'/log/'$HOST_NAME'/alert'$HOST_NAME'.log' alias adb='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDA'/'$ORACLE_SIDA'/trace/alert_'$ORACLE_SIDA'.log' alias sql='sqlplus / as sysdba' alias ohdb='cd '$ORACLE_HOME'' alias ohgr='cd '$CRS_HOME'' alias diag='cd '$ORACLE_BASE'/diag/' alias netgr='cd '$CRS_HOME'/network/admin/' alias netdb='cd '$ORACLE_HOME'/network/admin' alias dbsdb='cd '$ORACLE_HOME'/dbs/' alias dbsgr='cd '$CRS_HOME'/dbs/' alias racd='crsctl status resource -w "TYPE co 'ora'" -t' alias dgblog='tail -200f '$ORACLE_BASE'/diag/rdbms/'$ORACLE_SIDA'/'$ORACLE_SIDA'1/trace/drc'$ORACLE_SIDA'1.log' alias aasm='tail -200f '$ORACLE_BASE'/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log' |
******
10G
unix oracle rdbms .profile
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
# # Copyright (c) 2001 by Sun Microsystems, Inc. # All rights reserved. # # ident "@(#)local.profile 1.10 01/06/23 SMI" # RDBMS icin hazirlanmis profile # sysdba_profile v_19042014 stty istrip PATH=/usr/bin:/usr/ucb:/etc:. export PATH EDITOR=vi export EDITOR hostname=`hostname` export hostname username=oracle_rdbms export username PS1='$-$ $ ' export PS1 #/u01/app/oracle/product/10.2.0/db_1 ORACLE_SID=ORACLE_SIDA1; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME CRS_HOME=/u01/crs; export CRS_HOME ORACLE_UNQNAME=ORACLE_SIDA; export ORACLE_UNQNAME ORACLE_INSTACE1=ORACLE_SIDA1; export ORACLE_INSTACE1 ORACLE_INSTACE2=ORACLE_SIDA2; export ORACLE_INSTACE2 NLS_LANG=AMERICAN_AMERICA.AL32UTF8; export NLS_LANG PATH=$PATH:$ORACLE_HOME/bin: PATH=$ORACLE_HOME/bin:/u01/app/oracle/product/10.2.0/db_1/OPatch:$CRS_HOME/bin:/usr/bin:/etc:/usr/openwin/bin:/usr/X11/bin:/usr/sbin:/usr/ccs/bin:/usr/local/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/simpana/Base; export LD_LIBRARY_PATH export AWT_TOOLKIT=XToolkit # "libXm.so.4: open failed: No such file or directory" hatasi ile ilgili ##### DIAG=/u01/app/oracle/admin/; export DIAG ###Aliases alias ll='ls -ltr' alias agr='tail -2200f /u01/crs/log/db1/alertdb1.log' alias adb='tail -2200f /u01/app/oracle/admin/ORACLE_SIDA/bdump/alert_ORACLE_SIDA1.log' alias sql='sqlplus / as sysdba' alias ohdb='cd /u01/app/oracle/product/10.2.0/db_1' alias ohgr='cd $CRS_HOME' alias dbdiag='cd $DIAG' alias netgr='cd $CRS_HOME/admin/' alias netdb='cd $ORACLE_HOME/network/admin' alias netasm='cd /u01/app/oracle/product/10.2.0/asm/network/admin' alias netdb='cd /u01/app/oracle/product/10.2.0/db_1/network/admin' alias dbsdb='cd $ORACLE_HOME/dbs/' alias dbsgr='cd $CRS_HOME/dbs/' alias racd='crs_stat -t' alias dgblog='tail -200f /u01/app/oracle/admin/ORACLE_SIDA/bdump/drcORACLE_SIDA1.log' alias aasm='tail -200f $DIAG/+ASM/bdump/alert_+ASM1.log' |
******
unix oracle crs .profile
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 |
# Copyright (c) 2001 by Sun Microsystems, Inc. # All rights reserved. # # ident "@(#)local.profile 1.10 01/06/23 SMI" # crs icin hazirlanmis profile # sysdba_profile v_19042014 stty istrip PATH=/usr/bin:/usr/ucb:/etc:. export PATH EDITOR=vi export EDITOR hostname=`hostname` export hostname username=oracle_crs export username PS1='$-$ $ ' export PS1 #/u01/app/oracle/product/10.2.0/db_1 ORACLE_SID=+ASM1; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/asm; export ORACLE_HOME CRS_HOME=/u01/crs; export CRS_HOME #ORACLE_UNQNAME=ORACLE_SIDA; export ORACLE_UNQNAME #ORACLE_INSTACE1=ORACLE_SIDA1; export ORACLE_INSTACE1 #ORACLE_INSTACE2=ORACLE_SIDA2; export ORACLE_INSTACE2 NLS_LANG=AMERICAN_AMERICA.AL32UTF8; export NLS_LANG PATH=$PATH:$ORACLE_HOME/bin: PATH=$ORACLE_HOME/bin:/u01/crs/OPatch:$CRS_HOME/bin:/usr/bin:/etc:/usr/openwin/bin:/usr/X11/bin:/usr/sbin:/usr/ccs/bin:/usr/local/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/simpana/Base; export LD_LIBRARY_PATH export AWT_TOOLKIT=XToolkit # "libXm.so.4: open failed: No such file or directory" hatasi ile ilgili ##### DIAG=/u01/app/oracle/admin/; export DIAG ###Aliases alias ll='ls -ltr' alias agr='tail -200f /u01/crs/log/db1/alertdb1.log' alias adb='tail -200f /u01/app/oracle/admin/ORACLE_SIDA/bdump/alert_ORACLE_SIDA1.log' alias sql='sqlplus / as sysdba' alias ohdb='cd /u01/app/oracle/product/10.2.0/db_1' alias ohgr='cd $CRS_HOME' alias dbdiag='cd $DIAG' alias netgr='cd $CRS_HOME/admin/' alias netdb='cd $ORACLE_HOME/network/admin' alias netasm='cd /u01/app/product/10.2.0/asm/network/admin' alias dbsdb='cd $ORACLE_HOME/dbs/' alias dbsgr='cd $CRS_HOME/dbs/' alias racd='crs_stat -t' alias dgblog='tail -200f /u01/app/oracle/diag/rdbms/ORACLE_SIDA/ORACLE_SIDA1/trace/drcORACLE_SIDA1.log' alias aasm='tail -200f $DIAG/+ASM/bdump/alert_+ASM1.log' |
******
unix oracle asm .profile
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
# Copyright (c) 2001 by Sun Microsystems, Inc. # All rights reserved. # # ident "@(#)local.profile 1.10 01/06/23 SMI" # asm icin hazirlanmis profile # sysdba_profile v_19042014 stty istrip PATH=/usr/bin:/usr/ucb:/etc:. export PATH EDITOR=vi export EDITOR hostname=`hostname` export hostname username=oracle_asm export username PS1='$-$ $ ' export PS1 #/u01/app/oracle/product/10.2.0/db_1 ORACLE_SID=+ASM1; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/10.2.0/asm; export ORACLE_HOME CRS_HOME=/u01/crs; export CRS_HOME #ORACLE_UNQNAME=ORACLE_SIDA; export ORACLE_UNQNAME #ORACLE_INSTACE1=ORACLE_SIDA1; export ORACLE_INSTACE1 #ORACLE_INSTACE2=ORACLE_SIDA2; export ORACLE_INSTACE2 NLS_LANG=AMERICAN_AMERICA.AL32UTF8; export NLS_LANG PATH=$PATH:$ORACLE_HOME/bin: PATH=$ORACLE_HOME/bin:/u01/app/oracle/product/10.2.0/asm/OPatch:$CRS_HOME/bin:/usr/bin:/etc:/usr/openwin/bin:/usr/X11/bin:/usr/sbin:/usr/ccs/bin:/usr/local/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/opt/simpana/Base; export LD_LIBRARY_PATH export AWT_TOOLKIT=XToolkit # "libXm.so.4: open failed: No such file or directory" hatasi ile ilgili ##### DIAG=/u01/app/oracle/admin/; export DIAG ###Aliases alias ll='ls -ltr' alias agr='tail -200f /u01/crs/log/db1/alertdb1.log' alias adb='tail -200f /u01/app/oracle/admin/ORACLE_SIDA/bdump/alert_ORACLE_SIDA1.log' alias sql='sqlplus / as sysdba' alias ohdb='cd /u01/app/oracle/product/10.2.0/db_1' alias ohgr='cd $CRS_HOME' alias dbdiag='cd $DIAG' alias netgr='cd $CRS_HOME/admin/' alias netdb='cd $ORACLE_HOME/network/admin' alias dbsdb='cd $ORACLE_HOME/dbs/' alias dbsgr='cd $CRS_HOME/dbs/' alias racd='crs_stat -t' alias dgblog='tail -200f /u01/app/oracle/diag/rdbms/ORACLE_SIDA/ORACLE_SIDA1/trace/drcORACLE_SIDA1.log' alias aasm='tail -200f $DIAG/+ASM/bdump/alert_+ASM1.log' |
Kategori seçin...