pythontr.com
addgroup oinstall addgroup dba useradd -g oinstall -G dba -d /home/oracle -s /bin/bash oracle passwd oracle (Şifre isteyince orace kullanıcısı için şifre girin) mkdir /home/oracle chown -R oracle:dba /home/oracle
ln -s /usr/bin/awk /bin/awk ln -s /usr/bin/rpm /bin/rpm ln -s /usr/bin/basename /bin/basename
vim /etc/sysctl.conf fs.file-max = 6815744 fs.aio-max-nr = 1048576 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.core.rmem_default = 4194304 net.core.rmem_max = 4194304 net.core.wmem_default = 1048576 net.core.wmem_max = 1048576 net.ipv4.ip_local_port_range = 9000 65500
sysctl -p
vim /etc/security/limits.conf oracle soft nproc 2048 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536
mkdir /home/oracle/oraclesetup chown -R oracle:dba /home/oracle/oraclesetup/
aptitude install build-essential unixODBC rpm ksh lsb-rpm libaio1 sysstat pdksh unzip xterm xorg install sun-java6-jdk openjdk-6-jdk openbox aptitude install alien aptitude install autoconf aptitude install automake aptitude install autotools-dev aptitude install binutils aptitude install bzip2 aptitude install doxygen aptitude install elfutils aptitude install expat aptitude install gawk aptitude install gcc aptitude install gcc-multilib aptitude install g++-multilib aptitude install ksh aptitude install less aptitude install lesstif2 aptitude install lesstif2-dev aptitude install lib32z1 aptitude install libaio1 aptitude install libaio-dev aptitude install libc6-dev aptitude install libc6-dev-i386 aptitude install libc6-i386 aptitude install libelf-dev aptitude install libltdl-dev aptitude install libmotif4 aptitude install libodbcinstq4-1 libodbcinstq4-1:i386 yada aptitude install libodbcinstq1c2 libodbcinstq1c2:i386 aptitude install libpth-dev aptitude install libpthread-stubs0 aptitude install libpthread-stubs0-dev aptitude install libstdc++5 aptitude install lsb-cxx aptitude install make aptitude install pdksh aptitude install rlwrap aptitude install rpm aptitude install sysstat aptitude install unixodbc aptitude install unixodbc-dev aptitude install unzip aptitude install x11-utils aptitude install zlibc
xhost +
su - oracle cd oraclesetup # unzip kurulu değilse aptitude install unzip unzip linux_11gR2_database_1of2.zip unzip linux_11gR2_database_2of2.zip
cd database DISPLAY=192.168.2.161:0.0; export DISPLAY # arayüzden kurulum istiyor uğraşmaya gerek yok openbox iş görür startx ./runInstaller
cp /u01/app/oracle/product/11.2.0/dbhome_1/dbs/init.ora /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora vim /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora audit_file_dest='/u01/app/oracle/admin/ORCL/adump' db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
cat > /etc/init.d/oracle-shm <<-EOF
#! /bin/sh
# /etc/init.d/oracle-shm
#
#
case "\$1" in
start)
echo "Starting script /etc/init.d/oracle-shm"
# Run only once at system startup
if [ -e /dev/shm/.oracle-shm ]; then
echo "/dev/shm is already mounted, nothing to do"
else
mkdir /var/lock/subsys 2>/dev/null
touch /var/lock/subsys/listener
rm /dev/shm 2>/dev/null
mkdir /dev/shm 2>/dev/null
mount -t tmpfs shmfs -o size=16384m /dev/shm
touch /dev/shm/.oracle-shm
#rm -f /dev/shm
#mkdir /dev/shm
#mount -t tmpfs shmfs -o size=2048m /dev/shm
#touch /dev/shm/.oracle-shm
fi
;;
stop)
echo "Stopping script /etc/init.d/oracle-shm"
echo "Nothing to do"
;;
*)
echo "Usage: /etc/init.d/oracle-shm {start|stop}"
exit 1
;;
esac
#
### BEGIN INIT INFO
# Provides: oracle-shm
# Required-Start: $remote_fs $syslog
# Required-Stop: $remote_fs $syslog
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Description: Fix to allow Oracle 11g use AMM.
### END INIT INFO
EOF
chmod 755 /etc/init.d/oracle-shm update-rc.d oracle-shm defaults 01 99
vim /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
ORLC =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=boran)(PORT=1521))
(CONNECT_DATA=(SID=ORLC))
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
vim /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = boran)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
sqlplus /nolog SQL>connect / as sysdba SQL>connected...
vim /etc/init.d/dbora
export ORACLE_BASE=/u01/app/oracle/
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_OWNER=oracle
export ORACLE_SID=ORCL
export ORACLE_UNQNAME=ORCL
#export ORACLE_UNQNAME=DEFAULT
#export ORACLE_HOSTNAME=localhost.localdomain
export ORACLE_HOSTNAME=boran
export PATH=$PATH:$ORACLE_HOME/bin
if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]
then
echo "Oracle startup: cannot start"
exit 1
fi
case "$1" in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
su $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"
su - $ORACLE_OWNER -c "/home/oracle/scripts/startup.sh >> /home/oracle/scripts/startup_shutdown.log 2>&1"
touch /var/lock/subsys/dbora
echo "OK"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
su - $ORACLE_OWNER -c "/home/oracle/scripts/shutdown.sh >> /home/oracle/scripts/startup_shutdown.log 2>&1"
su $ORACLE_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"
rm -f /var/lock/subsys/dbora
echo "OK"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: `basename $0` start|stop|restart|reload"
exit 1
esac
exit 0
vim /home/oracle/scripts/startup.sh
# Start Database
sqlplus / as sysdba << EOF
STARTUP;
EXIT;
EOF
vim /home/oracle/scripts/shutdown.sh
# Stop Database
sqlplus / as sysdba << EOF
SHUTDOWN IMMEDIATE;
EXIT;
EOF
Yorumlar