SQWareProduction:oracle:etc:.profile: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
0 edits
m Updated by Expdbtools
 
m Updated by BatchUser
 
(17 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Fichier d'exemple $gvsqw_OraBin/../etc/.profile:<br>
Sample file for .profile $gvsqw_OraBin/../etc/.profile:<br>
Sample of lines to add to .profile of oracle users.<br>
<br>
<br>
Contenu du fichier:
File content:
<pre>
<pre>
#!/bin/ksh
#!/bin/bash
###################################################################
###################################################################
# SQWareProduction for Oracle module of ExpDbTools is developped with GPL Licence 3.0 :
# SQWareProduction for Oracle module of dbSQWare
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#  
#  
# This program is distributed in the hope that it will be useful,
# dbSQWare is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# CGU/CGA for more details.
#  
#  
# You should have received a copy of the GNU General Public License
# You should have received a copy of the CGU/CGA
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
#  
#  
# For information : contact@dbsqware.com or www.dbsqware.com
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
###################################################################
## @Synopsis Template of .profile for Oracle user
## @Synopsis Template of .profile for Oracle user
## @Copyright Copyright 2010, Michel PAYAN
## @Copyright Copyright 2007-2025, dbSQWare (www.dbsqware.com)
## @License GPL v3
## SVN : $URL$
## SVN : $Id$


## variables oracle
## variables oracle
export ORACLE_HOME=$HOME/product/10.2.0 // ORACLE_HOME=$HOME/product/11.1.0
export ORACLE_HOME=$HOME/uct/10.2.0 // ORACLE_HOME=$HOME/uct/11.1.0 // ORACLE_HOME=$HOME/uct/11.2.0
export ORACLE_BASE=$ORACLE_HOME
export ORACLE_BASE=$ORACLE_HOME
export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
Line 36: Line 29:


## gestion du path
## gestion du path
export gvsqw_OraBin=/usr/users/sysdba/SQWareProduction/oracle/bin
export gvsqw_OraBin=$HOME/SQWareProduction/oracle/bin
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH=$PATH:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/ccs/bin:/usr/openwin/bin:/opt/VRTSvcs/bin
export PATH=$PATH:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/ccs/bin:/usr/openwin/bin:/opt/VRTSvcs/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32


#dbSQWare
export gvsqw_Env=''
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_OraBin/../etc/.profile_confort ]
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_OraBin/../etc/.profile_confort ]

Latest revision as of 15:02, 23 February 2025

Sample file for .profile $gvsqw_OraBin/../etc/.profile:
Sample of lines to add to .profile of oracle users.

File content: 

#!/bin/bash
###################################################################
# SQWareProduction for Oracle module of dbSQWare
# 
# dbSQWare is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# CGU/CGA for more details.
# 
# You should have received a copy of the CGU/CGA
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
# 
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis	Template of .profile for Oracle user
## @Copyright	Copyright 2007-2025, dbSQWare (www.dbsqware.com)

## variables oracle
export ORACLE_HOME=$HOME/uct/10.2.0 // ORACLE_HOME=$HOME/uct/11.1.0 // ORACLE_HOME=$HOME/uct/11.2.0
export ORACLE_BASE=$ORACLE_HOME
export NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
export ORACLE_SID=""
export EDITOR=vi

## gestion du path
export gvsqw_OraBin=$HOME/SQWareProduction/oracle/bin
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH=$PATH:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/ccs/bin:/usr/openwin/bin:/opt/VRTSvcs/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32

#dbSQWare
export gvsqw_Env=''
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_OraBin/../etc/.profile_confort ]
then
   . $gvsqw_OraBin/../etc/.profile_confort
fi


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