Difference between revisions of "SQWareProduction:oracle:etc:.profile confort"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
m (Updated by BatchUser)
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
Fichier de positionnement d'alias $gvsqw_OraBin/../etc/.profile_confort:<br>
+
File to put aliases $gvsqw_OraBin/../etc/.profile_confort:<br>
−
  echo => 'echo -e'
+
Contains confort aliases of SQWareProduction for oracle.<br>
−
  put => "echo $lvsqw_EchoOpt '\033]0;${USER}@$gvsqw_Hostname     ${ORACLE_SID}         (dbsqware GPL v3)\033\\'"
+
<br>
−
  erase => 'stty erase ^H'
+
Alias explanation:
−
  so => 'set -o emacs'
+
<pre>
−
  h => 'history -100'
+
put => "echo $gvsqw_EchoOpt '\033]0;${gvsqw_UserExec}@$gvsqw_Hostname     $gvsqw_Env  ${ORACLE_SID}   ${gvsqw_DB_UNIQUE_NAME}:${gvsqw_HOST_UNIQUE_NAME} ${gvsqw_TermInfo} (dbSQWare v$gvsqw_SqwVersion)\033\\'"
−
  ll => 'ls -al'
+
lsora => 'ps -edf|grep "[p]mon"'
−
  lt => 'ls -altr'
+
menu_rman => "$gvsqw_OraBin/../menu/sqwora_MenuRman.ksh"
−
  menu_rman => "$gvsqw_OraBin/../menu/sqwora_MenuRman.ksh"
+
sqwarchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
−
  edtarchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
+
SqwArchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
−
  SqwArchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
+
rma => 'cd $gvsqw_RootRman; ls -al'
−
  spm => "$gvsqw_OraBin/../tools/sqwora_Spm.ksh"
+
arc => 'cd $gvsqw_RootArch; ls -al'
−
  sg => 'size=$(du -sk .|cut -f1);((size=size/1024/1024));echo "$size Go";date +"%d/%m/%Y %H:%M:%S"'
+
dmp => 'cd $gvsqw_RootExp; ls -al'
−
  sm => 'size=$(du -sk .|cut -f1);((size=size/1024));echo "$size Mo";date +"%d/%m/%Y %H:%M:%S"'
+
dmpdp => 'cd $gvsqw_RootExpdp; ls -al'
−
  rma => 'cd $gvsqw_RootRman; ls -al';
+
sq => "sqlplus '$gvsqw_DbaUser'"
−
  arc => 'cd $gvsqw_RootArch; ls -al';
+
adump => 'cd $gvsqw_RootAdmin/adump; ls -ltr'
−
  dmp => 'cd $gvsqw_RootExp; ls -al';
+
bdump => 'cd $gvsqw_RootAdmin/bdump; ls -ltr'
−
  cfg => 'cd $gvsqw_RootCfg; ls -al';
+
cdump => 'cd $gvsqw_RootAdmin/cdump; ls -ltr'
−
  cre => 'cd $gvsqw_RootAdmin/create; ls -al';
+
ddump => 'cd $gvsqw_RootAdmin/ddump; ls -ltr'
−
  log => 'cd $gvsqw_RootAdmin/logs; ls -ltr';
+
udump => 'cd $gvsqw_RootAdmin/udump; ls -ltr'
−
  tmp => 'cd $gvsqw_RootAdmin/tmp; ls -ltr';
+
dbf => 'cd $gvsqw_RootDbf; ls -al'
−
  adump => 'cd $gvsqw_RootAdmin/adump; ls -ltr';
+
ob => 'cd $ORACLE_BASE; ls -al'
−
  bdump => 'cd $gvsqw_RootAdmin/bdump; ls -ltr';
+
oh => 'cd $ORACLE_HOME; ls -al'
−
  cdump => 'cd $gvsqw_RootAdmin/cdump; ls -ltr';
+
dbs => 'cd $ORACLE_HOME/dbs; ls -al'
−
  ddump => 'cd $gvsqw_RootAdmin/ddump; ls -ltr';
+
tns => 'cd $ORACLE_HOME/network/admin; ls -al'
−
  udump => 'cd $gvsqw_RootAdmin/udump; ls -ltr';
+
alt => '$gvsqw_OraBin/../tools/sqwora_GetAlertFile.ksh'
−
  dbf => 'cd $gvsqw_RootDbf; ls -al';
+
psid => 'ps -fu $(id | cut -d\) -f1 | cut -d\( -f2)'
−
  bin => 'cd $gvsqw_OraBin; ls -al';
+
</pre>
−
  lib => 'cd $gvsqw_OraBin/../lib; ls -al';
 
−
  men => 'cd $gvsqw_OraBin/../menu; ls -al';
 
−
  too => 'cd $gvsqw_OraBin/../tools; ls -al';
 
−
  etc => 'cd $gvsqw_OraBin/../etc; ls -al';
 
−
  cbin => 'cd $gvsqw_OraBin/../bin_cust; ls -al';
 
−
  clib => 'cd $gvsqw_OraBin/../lib_cust; ls -al';
 
−
  cmen => 'cd $gvsqw_OraBin/../menu_cust; ls -al';
 
−
  ctoo => 'cd $gvsqw_OraBin/../tools_cust; ls -al';
 
−
  cetc => 'cd $gvsqw_OraBin/../etc_cust; ls -al';
 
−
  ob => 'cd $ORACLE_BASE; ls -al';
 
−
  oh => 'cd $ORACLE_HOME; ls -al';
 
−
  dbs => 'cd $ORACLE_HOME/dbs; ls -al';
 
−
  tns => 'cd $ORACLE_HOME/network/admin; ls -al';
 
−
  e => '. $gvsqw_OraBin/../tools/sqwora_SetEnv.ksh'
 
−
  alert => 'cd $HOME/admin/$ORACLE_SID/ddump/diag/rdbms/*/$ORACLE_SID/trace';
 
−
  psid => 'ps -fu $(id | cut -d\) -f1 | cut -d\( -f2)'
 
 
<br>
 
<br>

Latest revision as of 17:58, 6 November 2023

File to put aliases $gvsqw_OraBin/../etc/.profile_confort:
Contains confort aliases of SQWareProduction for oracle.

Alias explanation: 

 put => "echo $gvsqw_EchoOpt '\033]0;${gvsqw_UserExec}@$gvsqw_Hostname      $gvsqw_Env   ${ORACLE_SID}   ${gvsqw_DB_UNIQUE_NAME}:${gvsqw_HOST_UNIQUE_NAME} ${gvsqw_TermInfo} (dbSQWare v$gvsqw_SqwVersion)\033\\'"
 lsora => 'ps -edf|grep "[p]mon"'
 menu_rman => "$gvsqw_OraBin/../menu/sqwora_MenuRman.ksh"
 sqwarchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
 SqwArchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
 rma => 'cd $gvsqw_RootRman; ls -al'
 arc => 'cd $gvsqw_RootArch; ls -al'
 dmp => 'cd $gvsqw_RootExp; ls -al'
 dmpdp => 'cd $gvsqw_RootExpdp; ls -al'
 sq => "sqlplus '$gvsqw_DbaUser'"
 adump => 'cd $gvsqw_RootAdmin/adump; ls -ltr'
 bdump => 'cd $gvsqw_RootAdmin/bdump; ls -ltr'
 cdump => 'cd $gvsqw_RootAdmin/cdump; ls -ltr'
 ddump => 'cd $gvsqw_RootAdmin/ddump; ls -ltr'
 udump => 'cd $gvsqw_RootAdmin/udump; ls -ltr'
 dbf => 'cd $gvsqw_RootDbf; ls -al'
 ob => 'cd $ORACLE_BASE; ls -al'
 oh => 'cd $ORACLE_HOME; ls -al'
 dbs => 'cd $ORACLE_HOME/dbs; ls -al'
 tns => 'cd $ORACLE_HOME/network/admin; ls -al'
 alt => '$gvsqw_OraBin/../tools/sqwora_GetAlertFile.ksh'
 psid => 'ps -fu $(id | cut -d\) -f1 | cut -d\( -f2)'


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:oracle:etc:.profile_confort&oldid=25142"