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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
File to put aliases $gvsqw_OraBin/../etc/.profile_confort:<br>
 
File to put aliases $gvsqw_OraBin/../etc/.profile_confort:<br>
Contains confort aliases of SQWareProduction for RDBMS oracle.<br>
+
Contains confort aliases of SQWareProduction for oracle.<br>
 
<br>
 
<br>
 
Alias explanation:
 
Alias explanation:
 
<pre>
 
<pre>
  put => "echo $lvsqw_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\\'"
+
  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 pmon|grep -v grep'
+
  lsora => 'ps -edf|grep "[p]mon"'
 
  menu_rman => "$gvsqw_OraBin/../menu/sqwora_MenuRman.ksh"
 
  menu_rman => "$gvsqw_OraBin/../menu/sqwora_MenuRman.ksh"
 
  sqwarchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
 
  sqwarchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
 
  SqwArchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
 
  SqwArchmon => "$gvsqw_OraBin/sqwora_SqwArchmon.ksh"
  rma => 'cd $gvsqw_RootRman; ls -al';
+
  rma => 'cd $gvsqw_RootRman; ls -al'
  arc => 'cd $gvsqw_RootArch; ls -al';
+
  arc => 'cd $gvsqw_RootArch; ls -al'
  dmp => 'cd $gvsqw_RootExp; ls -al';
+
  dmp => 'cd $gvsqw_RootExp; ls -al'
  dmpdp => 'cd $gvsqw_RootExpdp; ls -al';
+
  dmpdp => 'cd $gvsqw_RootExpdp; ls -al'
  adump => 'cd $gvsqw_RootAdmin/adump; ls -ltr';
+
sq => "sqlplus '$gvsqw_DbaUser'"
  bdump => 'cd $gvsqw_RootAdmin/bdump; ls -ltr';
+
  adump => 'cd $gvsqw_RootAdmin/adump; ls -ltr'
  cdump => 'cd $gvsqw_RootAdmin/cdump; ls -ltr';
+
  bdump => 'cd $gvsqw_RootAdmin/bdump; ls -ltr'
  ddump => 'cd $gvsqw_RootAdmin/ddump; ls -ltr';
+
  cdump => 'cd $gvsqw_RootAdmin/cdump; ls -ltr'
  udump => 'cd $gvsqw_RootAdmin/udump; ls -ltr';
+
  ddump => 'cd $gvsqw_RootAdmin/ddump; ls -ltr'
  dbf => 'cd $gvsqw_RootDbf; ls -al';
+
  udump => 'cd $gvsqw_RootAdmin/udump; ls -ltr'
  ob => 'cd $ORACLE_BASE; ls -al';
+
  dbf => 'cd $gvsqw_RootDbf; ls -al'
  oh => 'cd $ORACLE_HOME; ls -al';
+
  ob => 'cd $ORACLE_BASE; ls -al'
  dbs => 'cd $ORACLE_HOME/dbs; ls -al';
+
  oh => 'cd $ORACLE_HOME; ls -al'
  tns => 'cd $ORACLE_HOME/network/admin; 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)'
 
  psid => 'ps -fu $(id | cut -d\) -f1 | cut -d\( -f2)'
 
</pre>
 
</pre>
 
<br>
 
<br>

Latest revision as of 16: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)'