Cloning an Oracle Home

事前作業

1. 檢查相依性套件是否已齊全。
2. 編輯 /etc/hosts
3. 調整 kernel 參數 /etc/sysctl.conf
4. 調整 /etc/security/limits.conf
5. 調整 /etc/pam.d/login
6. 關閉 firewall, SELinux
7. 建立 oracle 帳號及群組 dba
8. 建立 profile 及環境變數，決定 SID

開始安裝

環境變數為

ORACLE_BASE=/opt/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0.5.4/db_1; export ORACLE_HOME
ORACLE_SID=win; export ORACLE_SID

安裝步驟
用 root 執行

mkdir -p /opt/oracle/product/10.2.0.5.4/db_1
chown -R oracle:dba /opt/oracle

用 oracle 執行

su - oracle
cd /opt/oracle/product
mkdir clone_oracle/
cd clone_oracle/
tar xf /mnt/nas_na/alang/Oracle_Home_102054_Clone.tar 
mv 10.2.0/* ../10.2.0.5.4/db_1/

cd $ORACLE_HOME/network/admin/
rm *.ora
cd $ORACLE_HOME/dbs
rm -rf *

cd $ORACLE_HOME/oui/bin/
./runInstaller -silent -clone ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=ora_102054 

Setup in progress (Thursday, March 20, 2014 5:28:40 PM CST)
Setup successful

End of install phases.(Thursday, March 20, 2014 5:28:44 PM CST)
WARNING:
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root script to run
/opt/oracle/product/10.2.0.5.4/db_1/root.sh
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts

The cloning of ora_102054 was successful.
Please check '/opt/oracle/oraInventory/logs/cloneActions2014-03-20_05-27-04PM.log' for more details.

TIP:

如果出現 oraInventory 路徑錯誤，檢查檔案 /etc/oraInst.loc 內容

su -
/opt/oracle2/product/10.2.0.5.4/db_1/root.sh 

建立資料庫

任一種方式

1. 使用 SQL
2. 使用 dbca

安裝 Oracle 主程式

用 oracle 執行

su - oracle
cd /opt/oracle/product
mkdir -p 10.2.0.5.4/db_1
mkdir clone_oracle/
cd clone_oracle/
tar xf /mnt/nas_na/alang/Oracle_Home_102054_Clone.tar 
mv 10.2.0/* ../10.2.0.5.4/db_1/

export ORACLE_HOME=/opt/oracle/product/10.2.0.5.4/db_1
cd $ORACLE_HOME/network/admin/
rm *.ora
cd $ORACLE_HOME/dbs
rm -rf *

cd $ORACLE_HOME/oui/bin/
./runInstaller -silent -clone ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=ora_102054

...

Setup in progress (Friday, March 21, 2014 9:22:17 AM CST)
Setup successful

End of install phases.(Friday, March 21, 2014 9:22:22 AM CST)
WARNING:
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root script to run
/opt/oracle/product/10.2.0.5.4/db_1/root.sh
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts

The cloning of ora_102054 was successful.
Please check '/opt/oracle/oraInventory/logs/cloneActions2014-03-21_09-20-37AM.log' for more details.

以 root 執行

/opt/oracle/product/10.2.0.5.4/db_1/root.sh 

Running Oracle 10g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /opt/oracle/product/10.2.0.5.4/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

升級原有的 DB

以 oracle 執行
停止原 DB 服務

su - oracle
echo $ORACLE_HOME
/opt/oracle/product/10.2.0/db_1

lsnrctl stop 
ps -ef | grep -i listener

sqlplus / as sysdba
SQL> shutdown immediate
SQL> exit 

開始對 DB 作升級

export ORACLE_HOME=/opt/oracle/product/10.2.0.5.4/db_1
sqlplus / as sysdba

SQL> startup upgrade