ORACLE11G安装和升级11.2.0.1.0升级到11.2.0.4.0

ORACLE11G安装和升级
安装LINUX






















ip写入到hosts

vim /etc/selinux/config

yum install oracle-rdbms-server-11gR2-preinstall

自动创建了oracle用户了

创建密码

mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01

mkdir /software/11.2.0
mkdir /software/11.4.0
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
chown -R oracle:oinstall /software/11.2.0/database
chown -R oracle:oinstall /software/11.4.0/database
ls –l


ORACLE_HOSTNAME= oracle11g.local; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID PATH=$ORACLEB​ASE/product/11.2.0/db1​;exportORACLEH​OMEORACLES​ID=orcl;exportORACLES​IDPATH=ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$PATH;exportPATHLDL​IBRARYP​ATH=ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLEH​OME/jlib:ORACLE_HOME/rdbms/jlib; export CLASSPATH

export LANG=CN_em













安装后的检查

tnsnames.ora

OEM检查
emctl status dbconsole

emctl start dbconsole




ORACLE升级 11.2.0.1.0升级到11.2.0.4.0
升级前的查看
tail -1 /etc/oratab

cat /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

cat /u01/app/oraInventory/ContentsXML/inventory.xml

lsnrctl status

Select * from v$version;

Select comp_name,version,status from dba_registry;


创建新的oracle_home目录
mkdir -p /u01/app/oracle/product/11.2.0/db_2
chmod 775 /u01/app/oracle/product/11.2.0/db_2
临时设置oracle_home目录
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_2
echo $ORACLE_HOME

cd /software/11.4.0/database/
export LANG=en_US












升级数据库
/u01/app/oracle/product/11.2.0/db_2/bin/dbua





mkdir -p /u03/app/oracle/fra/rex/backup
chown -R oracle:oinstall /u03
chmod -R 775 /u03








ls -lh /u03/app/oracle/fra/rex/backup/

tail -2 /etc/oratab

cat /u01/app/oraInventory/ContentsXML/inventory.xml

查看admin目录下没有文件
ls -l /u01/app/oracle/product/11.2.0/db_2/network/admin/

把listener和tnsnames文件拷贝到新的oracle_home目录下
cp/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora /u01/app/oracle/product/11.2.0/db_2/network/admin/
cp/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora /u01/app/oracle/product/11.2.0/db_2/network/admin/

查看监听状态，不是更新的版本
lsnrctl status

停用监听状态lsnrctl stop

在启用监听

查看监听，版本正确了

OEM版本也正确了
emctl status dbconsole


/u01/app/oracle/product/11.2.0/db_2/bin/rman target /

select instance_name,host_name,status,version from v$instance;


Select comp_name,version,status from dba_registry
Where status <> ‘VALID’;

查看更新
Select
To_char(action_time, ‘DD-MON-YYYY HH:MI:AM’)upgrade_date,
Comments source_version,version target_version
From dba_registry_history
Where action = ‘UPGRADE’;

清除原来的ORACLE_HOME
cd /u01/app/oracle/product/11.2.0/db_1/deinstall/