acle升级后,默认是通过主机名hostname来启动listener.ora的,而主机名去对应ip地址,一般走的是/etc/hosts,需要在/etc/hosts里面添加主机名和ip地址的对应。所以去修改/etc/hosts
4、修改hosts启动oracle实例
(1)修改主机名
[root@ht_121_90 ~]# more /etc/hosts
127.0.0.1 hch_test_121_90 hch_test_121_90.
192.168.121.90 hch_test_121_90 ht_121_90
(2)启动oracle实例
[root@ht_121_90 ~]#
SQL> startup;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 1040189552 bytes
Database Buffers 553648128 bytes
Redo Buffers 7360512 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 1605
Session ID: 191 Serial number: 3
SQL>
5、治疗升级后遗症
看到有“ORA-39700: database must be opened with UPGRADE option”这样的提示,就知道了升级没有完全成功,还需要执行一些系统的sql脚本
(1)执行升级脚本
SQL> @$ORACLE_HOME/rdbms/admin/utlu112s.sql
......
SQL> @$ORACLE_HOME/rdbms/admin/catuppst.sql
......执行实际比较长
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=true SCOPE=SPFILE;
(2)重启数据库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup;
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 1040189552 bytes
Database Buffers 553648128 bytes
Redo Buffers 7360512 bytes
Database mounted.
Database opened.
SQL>
设置默认的路径为新的路径
su - oracle
vim /home/oracle/.bash_profile
将 /home/oracle/app/oracle/product/11.2.0改成 /home/oracle/app/oracle/product/11.2.0.4
然后重新启动oracle实例
[oracle@ht_121_90 ~]$ rlwrap sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 17 20:36:25 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/app/oracle/product/11.2.0.4/dbhome_1/dbs/initpowerdes.ora'
SQL>
SQL> startup pfile='/oracle/pfile_20160317.ora';
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2253664 bytes
Variable Size 469765280 bytes
Database Buffers 1124073472 bytes
Redo Buffers 7319552 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL>
启动貌似找不到控制文件,去看后台alert日志
[root@ht_121_90 ~]# tail -f /oracle/app/oracle/diag/rdbms/powerdes/powerdes/trace/alert_powerdes.log
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Fri Mar 17 20:52:25 2017
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/data/oracle/powerdes/control01.ctl'
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information