做好备份!
停止归档:
SQL>shutdown immediate;
SQL>startup mount;
SQL>alter database noarchivelog;
SQL>alter database open;停止一切oracle相关服务:
$lsnrctl stop
$sqlplus “ /as sysdba”
SQL>shutdown immediate;
$ emctl stop dbconsole
$isqlplusctl stop
重启服务器:
$su -
输入root用户密码。Password:
#shutdown –r now
上传升级文件到服务器/soft目录给目录和里面包含的文件权限解压升级包
#chown -R oracle:oinstall /soft
#chmod -R 775 /soft
#unzip p8202632_10205_LINUX.zip
#export DISPLAY=:0
#xhost +
#su - oracle
$cd /soft
$cd Disk1
$./runinstaller
图形化界面软件升级完成
$dbua
图形化界面升级数据库完成
开归档
$sqlplus “/as sysdba”
SQL>shutdown immediate;
SQL>startup mount;
SQL>alter database archivelog
SQL>alter database open;
改归档路径
alter system set log_archive_dest_1='location=/oracle/oracle10g/log/archive_log';