Oracle のバックアップ(No.1)

バックアップ一覧
差分を表示
現在との差分を表示
ソースを表示
Oracle へ行く。
- 1 (2008-06-26 (木) 23:04:42)

Oracle

http://www.oracle.com/technology/software/products/database/xe/index.html

Oracle

Red Hat Enterprise Linux AS/ES 2.1
Red Hat Enterprise Linux AS/ES 3
MIRACLE LINUX Standard Edition V2.1
MIRACLE LINUX V3.0
SuSE Linux Enterprise Server 8

Patch#3006854 
Patch#3119415

http://www.miraclelinux.co.jp/faq/data/00072.html

dbora start

sqlplus /nolog
connect / as sysdba 
startup

↑

RedhatEnterpriseLinux? ES 3.0 + Oracle9.2

tcl-8.3.5-92.i386.rpm       2/4
setarch-1.3-1.i386.rpm      2/4
compat-db-4.0.14-5.i386.rpm  3/4
compat-gcc-7.3-2.96.122.i386.rpm  3/4
compat-gcc-c++-7.3-2.96.122.i386.rpm  3/4
compat-libstdc++-7.3-2.96.122.i386.rpm  3/4
compat-libstdc++-devel-7.3-2.96.122.i386.rpm  3/4
openmotif21-2.1.30-8.i386.rpm  3/4

mv /usr/bin/gcc /usr/bin/gcc323

ln -s /usr/bin/gcc296 /usr/bin/gcc

mv /usr/bin/g++ /usr/bin/g++323

ln -s /usr/bin/g++296 /usr/bin/g++

http://www.unix-power.jp/linux/p3006854_9204_LINUX.zip

unzip p3006854_9204_LINUX.zip
cd 3006854
sh rhel3_pre_install.sh

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle

export DISPLAY=localhost:0.0
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product
export ORACLE_SID=ora92
export NLS_LANG=Japanese_Japan.JA16EUC
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_DOC=$ORACLE_HOME/doc
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/classes12.zip
CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/nls_charaset12.zip
export CLASSPATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/etc/lib:$ORACLE_HOME/jdbc/lib
export LD_LIBRARY_PATH
export LD_ASSUME_KERNEL=2.4.1

source .bashrc

echo 100 32000 100 100 > /proc/sys/kernel/sem
echo 268435456 > /proc/sys/kernel/shmmax
echo 65536 > /proc/sys/fs/file-max
ulimit -n 65536
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range

xhost + localhost

/mnt/cdrom/runInstaller

oinstall

IndexOutouBounds?

cd $ORACLE_HOME/dbs
cp init.ora $ORACLE_BASE/admin/ora92/pfile/initora92.ora

db_name=ora92
db_domain = localdomain
control_files = ('/oracle/oradata/ora92/control01.ctl','/oracle/oradata/ora92/control02.ctl','/oracle/oradata/ora92/control03.ctl')
remote_login_passwordfile = none
background_dump_dest='/opt/oracle/admin/ora92/bdump'
user_dump_dest='/oracle/admin/ora92/udump'
core_dump_dest='/oracle/admin/ora92/cdump'
undo_management = AUTO
undo_tablespace = undotbs
fast_start_mttr_target = 300
compatible = 9.2.0.4.0

ln -s /oracle/admin/ora92/pfile/initora92.ora /oracle/product/dbs/initora92.ora

shutdown

shutdown immediate

ora92:/oracle/product:N

ora92:/oracle/product:Y

#!/bin/bash
#
# orale9.2           This shell script takes care of starting and stopping
#                 oracle.
#
# chkconfig: 345 60 90
# description: Oracle
# Source function library.
. /etc/rc.d/init.d/functions
# Source networking configuration.
[ -r /etc/sysconfig/network ] && . /etc/sysconfig/network

ORA_HOME=/oracle/product
ORA_OWNER=oracle
export ORACLE_HOME=$ORA_HOME
if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ] 
then
   echo "Oracle startup: cannot start"
   exit
fi
case "$1" in
   start)
       # Start the Oracle databases:
       su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart"
       # Start Oracle Net
       su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
       touch /var/lock/subsys/dbora
       ;;
    stop)
       # Stop Oracle Net
       su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
       # Stop the Oracle databases:
       su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut"
       rm -f /var/lock/subsys/dbora
       ;;
   restart)
       $0 stop
       $0 start
       ;;
   status)
       if [ -f /var/lock/subsys/dbora ]; then
           echo $0 started.
       else
           echo $0 stopped.
       fi
       ;;
   *)
       echo "usage: dbora {start|stop|restart|status}"
       exit 1
esac
exit 0

chkconfig --add dbora
chkconfig --level 345 dbora on

/etc/init.d/dbora start

http://www.akenotori.jp/kill/index.php

↑

Oracle Database 10g Express Edition

http://www.oracle.com/technology/software/products/database/xe/index.html

 rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm

libaio >= 0.3.96 is needed by oracle-xe-univ-10.2.0.1-1.0

yum install libaio

rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
Executing Post-install steps...
oracle-xe                 0:off  1:off  2:off  3:on   4:off  5:on   6:off
You must run '/etc/init.d/oracle-xe configure' as the root user to
configure the database.

/etc/init.d/oracle-xe configure


Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after



Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"
http://www.fiberbit.net/user/kunyami/oracle/xe/install.html

. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh

sqlplus

↑

Oracle11g

↑