共计 3189 个字符,预计需要花费 8 分钟才能阅读完成。
Oracle 的家目录进行快速克隆,对 同类型机器配置 很高效的!
01、确认你在克隆数据库时,原数据库已经关闭
sqlplus / as sysdba;
shutdown immediate ;
lsnrctl stop
ps –ef|grep ora_ ### 查看 oracle 进程
02、对 $ORACLE_BASE 目录下的 product 进行备份
zip –r product.zip product
03、移动到目标机器或目标目录解压
unzip –d target_path product.zip # 或者在目标目录下 unzip product.zip
04、删除解压后的 product/network/admin 下面的 ora 文件
rm *.ora ### 清理监听文件
05、运行 runinstaller
$ORACLE_HOME/oui/bin/runinstaller –silent –clone ORACLE_BASE=’productd 的当前目录 ’ ORACLE_HOME=’oracle_home 目录 ’ ORACLE_HOME_NAME=’ 这个名字随便取一个 ’
注:运行以上命令,会出现一个字符界面的进度条,全部运行完后。你运行一个脚本 root.sh, 以 root 运行,一路回车就 ok 了。
cd product/11.2.0/dbhome_1/oui/bin | |
[oracle@oracle-111 bin]$ ./runInstaller -silent -clone ORACLE_HOME='/data/clone_oracle/product/11. | |
2.0/dbhome_1' ORACLE_HOME_NAME='clone' Starting Oracle Universal Installer... | |
Checking swap space: must be greater than 500 MB. Actual 1535 MB Passed | |
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-02-27_06-41-44AM. Please w | |
ait ...[oracle@oracle-111 bin]$ Oracle Universal Installer, Version 11.2.0.4.0 ProductionCopyright (C) 1999, 2013, Oracle. All rights reserved. | |
You can find the log of this install session at: | |
/data/oraInventory/logs/cloneActions2017-02-27_06-41-44AM.log | |
Values for the following variables could not be obtained from the command line or response file(s) | |
: ORACLE_BASE | |
Cloning cannot continue. ### 第一次没指定 ORACLE_BASE 目录导致的错误 | |
[oracle@oracle-111 bin]$ ./runInstaller -silent -clone ORACLE_BASE='/data/clone_oracle' ORACLE_H | |
OME='/data/clone_oracle/product/11.2.0/dbhome_1' ORACLE_HOME_NAME='clone' -noConfig -nowaitStarting Oracle Universal Installer... | |
Checking swap space: must be greater than 500 MB. Actual 1535 MB Passed | |
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2017-02-27_06-43-34AM. Please w | |
ait ...[oracle@oracle-111 bin]$ Oracle Universal Installer, Version 11.2.0.4.0 ProductionCopyright (C) 1999, 2013, Oracle. All rights reserved. | |
You can find the log of this install session at: | |
/data/oraInventory/logs/cloneActions2017-02-27_06-43-34AM.log | |
.................................................................................................. | |
.. 100% Done. | |
Installation in progress (Monday, February 27, 2017 6:43:59 AM CST) | |
.............................................................................. | |
78% Done.Install successful | |
Linking in progress (Monday, February 27, 2017 6:44:08 AM CST) | |
Link successful | |
Setup in progress (Monday, February 27, 2017 6:46:56 AM CST) | |
Setup successful | |
End of install phases.(Monday, February 27, 2017 6:47:47 AM CST) | |
WARNING: | |
The following configuration scripts need to be executed as the "root" user. | |
/data/clone_oracle/product/11.2.0/dbhome_1/root.sh ### 以 root 身份运行 root.sh 文件 | |
To execute the configuration scripts: | |
1. Open a terminal window | |
2. Log in as "root" | |
3. Run the scripts | |
The cloning of clone was successful. | |
Please check '/data/oraInventory/logs/cloneActions2017-02-27_06-43-34AM.log' for more details. | |
[oracle@oracle-111 bin]$ cd .. |
06、设置 oracle 环境变量
cd ~
vim .bash_profile ### 根据需求进行修改
#export ORACLE_SID=mvp | |
export ORACLE_BASE=/data/clone_oracle | |
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 | |
export LD_LIBRARY_PATH=$ORACLE_HOME/lib | |
export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss' | |
export PATH=$ORACLE_HOME/bin:/usr/local/bin:$PATH:$HOME/bin |
07、建立数据库实例及监听
netca ### 监听
dbca ### 实例
#### 启动新建的实例
sqlplus / as sysdba;
startup
exit;
更多 Oracle 相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12
本文永久更新链接地址:http://www.linuxidc.com/Linux/2017-03/141335.htm
