11G升级到12C

准备12C的安装包，修改权限和所有者
chown -R oracle:oinstall /software/
chmod -R 775 /software/

查看监听状态和版本
lsnrctl status

查看OEM版本和状态
emctl status dbconsole

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

Select comp_name,version,status from dba_registry
order by status;

创建新的ORACLE_HOME位置
mkdir -p /u01/app/oracle/product/12.1.0/dbHome_1
chown -R oracle:oinstall /u01/app/oracle/product/12.1.0/dbHome_1
chmod -R 775 /u01/app/oracle/product/12.1.0/dbHome_1

临时使用这个ORACLE_HOME
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbHome_1
echo $ORACLE_HOME


进入安装目录，安装
cd /software/12.1.1/database/
./runInstaller

先安装软件，不安装库





这里应该是新的ORACLE_HOME位置





使用root用户执行上面的脚本


查看OEM
emctl status dbconsole

停止OEM
emctl stop dbconsole

登入sqlplus

@ /u01/app/oracle/product/12.1.0/dbHome_1/rdbms/admin/emremove.sql

停止监听
lsnrctl stop

export ORACME_HOME=/u01/app/oracle/product/12.1.0/dbHome_1
echo $ORACLE_HOME

创建新的监听
/u01/app/oracle/product/12.1.0/dbHome_1/bin/netca

查看配置的新监听
lsnrctl status
升级数据库
/u01/app/oracle/product/12.1.0/dbHome_1/bin/dbua







mkdir -p /u03/app/oracle/fra/rex/backup11g
chmod -R 775 /u03/app/oracle/fra/rex/backup11g





查看升级结果



查看备份
ls -l /u03/app/oracle/fra/rex/backup11g

查看升级后的结果
tail -2 /etc/oratab

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

lsnrctl status

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

select * from v$version;

Select comp_name,version,status from dba_registry
order by status;

Select
To_char(action_time, 'DD-MON-YYYY HH:MI:AM')upgrade_date,
Comments source_version,version target_version
From dba_registry_history

show parameter compatible

alter system set compatible=‘12.1.0.0.0’ scope=spfile;

shutdown immediate

startup;

show parameter compatible

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

./deinstall



原来的就没有了
ls -l /u01/app/oracle/product/11.2.0/db_2/

vim .bash_profile
. .bash_profile

select name,cdb,open_mode from v$database;

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

登陆查看
https://oracle11g.local:5500/em/login