RAC集群安装错误集合

1.VIP验证报错

[INS-40912] Virtual host name:dena3vip is assigned to annother system

该错误是由于hosts里面配置的VIP ip被占用导致,更换掉IP即可

2.启动数据库提示 ORA-01092: ORACLE instance terminated. Disconnection forced ORA-30013: undo tablespace 'UNDOTBS1' is currently in use

SQL> startup;
ORACLE instance started.

Total System Global Area 1670221824 bytes
Fixed Size            2253824 bytes
Variable Size         1291848704 bytes
Database Buffers      369098752 bytes
Redo Buffers            7020544 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30013: undo tablespace 'UNDOTBS1' is currently in use
Process ID: 18539
Session ID: 16 Serial number: 5

改错误是由于实例所对应的undo_tablespace不一致,导致undo_tablespace出现争用。备份好spfile,修改对应undo_tablespace即可

该问题在创建数据库的时候提示过,但只是警告,被我忽略了。我怀疑是环境变量的ORACLE_SID与Policy-Managed创建出来的SID不一致导致的(未做测试,只是猜测)

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1670221824 bytes
Fixed Size            2253824 bytes
Variable Size         1291848704 bytes
Database Buffers      369098752 bytes
Redo Buffers            7020544 bytes
Database mounted.
SQL> create pfile='/home/oracle/pfile.ora' from SPFILE='+DGSYSTEM01/dena/spfiledena.ora';

File created.

SQL> show parameter undo_tablespace;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
undo_tablespace              string     UNDOTBS3
SQL> alter system set undo_tablespace=UNDOTBS2;
alter system set undo_tablespace=UNDOTBS2
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01219: database not open: queries allowed on fixed tables/views only


SQL> alter system set undo_tablespace=UNDOTBS2 scope=spfile;

System altered.

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 1670221824 bytes
Fixed Size            2253824 bytes
Variable Size         1291848704 bytes
Database Buffers      369098752 bytes
Redo Buffers            7020544 bytes
Database mounted.
Database opened.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL>
原文地址:https://www.cnblogs.com/Roobbin/p/14128369.html