のバックアップ(No.8)

バックアップ一覧
差分を表示
現在との差分を表示
ソースを表示
へ行く。
- 1 (2004-12-14 14:40:30 (火))
- 2 (2004-12-14 18:32:23 (火))
- 3 (2004-12-17 14:18:33 (金))
- 4 (2005-01-31 15:08:26 (月))
- 5 (2005-02-01 19:33:28 (火))
- 6 (2005-02-15 19:11:19 (火))
- 7 (2005-11-04 17:44:15 (金))
- 8 (2008-07-15 00:30:11 (火))

set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

↑

†

groupadd dba
useradd -g dba -d /opt/oracle -s /bin/csh -m oracle
passwd oracle

setenv ORACLE_BASE /opt/oracle
setenv ORACLE_HOME $ORACLE_BASE/product/9.2.0
setenv ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/data
setenv CLASSPATH $ORACLE_HOME/jre/1.1.8:$ORACLE_HOME/jlib:$ORACLE_HOME/jlib/product/jlib

set path = ($ORACLE_HOME/bin $path)
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib:$LD_LIBRARY_PATH

↑

†

↑

†

```
cd /tmp
/cdrom/disk1/runInstaller
```

↑

†

↑

†

↑

†

```
su
/tmp/orainstRoot.sh
```

↑

†

↑

†

↑

†

Server
- Enterprise Edition
- Statndard Edition
- Custom
Client
- Administrator
- Runtime
- Custome

↑

Database Configuration †

Server
- General Propose
- Transaction Processing
- Data Warehouse
- Customized
- Software Only
Client

↑

†

↑

†

↑

†

```
su
/opt/oracle/product/9.2.0/root.sh
```
```
/usr/local/bin
```

↑

†

unzip hogehoge.zip
cpio -i -d < hogehoge.cpio

↑

†

↑

†

```
$ORACLE_BASE/bin/netca
```

↑

†

```
lsnrctl start
```
```
lsnrctl start <lisner名>
```

↑

†

mkdir /export/home/oracle/oradata
mkdir /export/home/oracle/admin
cd $ORACLE_BASE
ln -s /export/home/oracle/oradata
ln -s /export/home/oracle/admin

```
$ORACLE_HOME/bin/dbca
```

↑

†


TEST:/opt/app/oracle/product/9.2.0:N

↑

†

spfile(SID).ora

mv $ORACLE_HOME/dbs/spfile(SID).ora $ORACLE_HOME/dbs/_spfile(SID).ora

cp $ORACLE_BASE/admin/(SID)/pfile/init.ora.xxxx $ORACLE_BASE/admin/(SID)/pfile/init(SID).ora
ln -s $ORACLE_BASE/admin/(SID)/pfile/init(SID).ora $ORACLE_HOME/dbs/init(SID).ora

$ORACLE_BASE/admin/(SID)/pfile/init(SID).ora

↑

†

     case $VERSION in
                 "6")  sqldba command=shutdown ;;
                 "internal")  $SQLDBA <<EOF
connect internal
shutdown
EOF
                   ;;
                 *)  $SQLDBA <<EOF
connect / as sysdba
shutdown
EOF
                   ;;
             esac

     case $VERSION in
                 "6")  sqldba command=shutdown ;;
                 "internal")  $SQLDBA <<EOF
connect internal

EOF
                   ;;
                 *)  $SQLDBA <<EOF
connect / as sysdba


EOF
                   ;;
             esac

↑

†

#!/bin/sh

ORA_HOME=/opt/app/oracle/product/9.2.0
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]; then
        echo "Oracle startup: cannot start"
fi

case "$1" in
'start')
       su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart "
       su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
       ;;
'stop')
       su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
       su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut "
;;
esac

cd /etc/rc2.d
ln -s ../init.d/dbora S98dbora
cd /etc/rc0.d
ln -s ../init.d/dbora K11dbora
cd /etc/rc1.d
ln -s ../init.d/dbora K11dbora

```
su oracle
cd ~
mv .login dot.login
```

↑

Enterprise Manager †

$ORACLE_HOME/bin/oemapp
$ORACLE_HOME/bin/oemapp dbastudio

↑

†

```
sqlplus "sys/sys@test as sysdba"
```
```
@utlxplan.sql
```

GRANT SELECT ON SYS.PLAN_TABLE TO PUBLIC; 
GRANT INSERT ON SYS.PLAN_TABLE TO PUBLIC; 
GRANT UPDATE ON SYS.PLAN_TABLE TO PUBLIC; 
GRANT DELETE ON SYS.PLAN_TABLE TO PUBLIC; 
CREATE PUBLIC SYNONYM PLAN_TABLE FOR SYS.PLAN_TABLE;

```
@plustrce.sql
```
```
grand plustrace to user
```