本文祥细阐述了Oracle单机版3升级到4的祥细过程
????系统环境检查
Oracle版本:[oracle@MES~]$sqlplus-v
Linux版本:[oracle@MES~]$cat/etc/redhat-release
????检查升级条件
SYS@PROD>colcomp_namefora35SYS@PROD>colversionfora20SYS@PROD>colnamefora20SYS@PROD>setlinesize1000SYS@PROD>setpagesize1000SYS@PROD>SELECTCOMP_NAME,VERSION,STATUSFROMSYS.DBA_REGISTRY;
--兼容性查看
SYS@PROD> col name for a40
SYS@PROD> col value for a30
SYS@PROD> SELECT name, value FROM v$parameter WHERE name = "compatible";
????数据库全备
✨1RMAN备份
确认归档是否打开:SYS@PROD>archiveloglist
[oracle@MES~]$rmantarget/RMAN>backupdatabaseplusarchivelogdeleteinputformat‘/home/bak/full_%U.dbf’;
✨2EXPDP备份
[root@MES ~]# mkdir -p /home/oracle/DEMP_EXP
[root@MES oracle]# chown -R oracle:oinstall /home/oracle/DEMP_EXP
[root@MES oracle]# ll
SYS@PROD> create directory expdp as "/home/oracle/DEMP_EXP";
SYS@PROD> grant read,write on directory EXPDP to SCOTT;
SYS@PROD> select * from dba_directories;
[oracle@MES ~]$ expdp scott/tiger directory=expdp dumpfile=full.dmp full=y logfile=full.log
????关闭数据库和监听
✨1关闭数据库
✨2关闭监听
[oracle@MES~]$env|grepora
????解压4的安装包
[root@MES~]#mkdir/soft[root@MESsoft]#unzipp13390677_112040_Linux-x86-64_1ofzip[root@MESsoft]#unzipp13390677_112040_Linux-x86-64_2ofzip
✨1修改权限
✨2执行安装
在oracle用户执行安装操作[oracle@MES~]$cd/soft/database/[oracle@MESdatabase]$ll[oracle@MESdatabase]$./runInstaller
????修改环境变量
????查看版本号
SQL> col comp_name for a35
SQL> col version for a20
SQL> col name for a20
SQL> set linesize 1000
SQL> set pagesize 1000
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
✨1处理OWB版本问题
SQL> @?/owb/UnifiedRepos/clean_owbsys.sql
SQL> @?/owb/UnifiedRepos/cat_owb.sql
SQL> @?/owb/UnifiedRepos/reset_owbcc_home.sql
再次查看:
文章为作者独立观点,不代表股票交易接口观点