понедельник, 9 февраля 2009 г.

Создание пользователя oracle на *NIX

Aix:
mkgroup dba ; mkgroup oinstall ; mkuser pgrp='oinstall' groups='dba,oinstall' oracle ; passwd oracle

Solaris:

useradd -u 101 -d /export/home/oracle -g oinstall -G dba -m -s /usr/bin/bash oracle

1 комментарий:

nuke комментирует...

umask 022
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
export PATH

ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/1120
export ORACLE_HOME

ORACLE_SID=orcl
export ORACLE_SID
TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251
export NLS_LANG
CLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export CLASSPATH
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORA_NLS33
PATH=$PATH:$ORACLE_HOME/bin;
export PATH
LIBPATH=$ORACLE_HOME/lib:/usr/lib
export LIBPATH

if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.



#solaris

export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=/u01/oracle/product/1020
export ORACLE_SID=orcl # тут ваш SID

export PATH=/usr/ccs/bin:/usr/bin:/bin:.
export TNS_ADMIN=$ORACLE_HOME/network/admin
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH
export EDITOR=vi
export DISPLAY=localhost:0.0