20210316-Oracle 19C RAC open_links_per_instance参数问题

chenoracle

于 2025-03-23 09:04:44 发布

阅读量180

点赞数 3

分类专栏： Oracle 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/chenoracle/article/details/146451342

版权

Oracle 专栏收录该内容

32 篇文章

订阅专栏

在这里插入图片描述

说明：

近期测试，将open_links_per_instance参数改成0后,Oracle 11g RAC可以生效，Oracle 19.3 RAC无法启动实例，
先将问题记录下来，有时间在研究：

环境：

DB:Oracle 19.3 RAC(两个实例)
OS:Redhat 6.7

操作：

节点1：

SQL> show parameter open_link
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
open_links     integer 4
open_links_per_instance      integer 4

SQL> alter system set open_links_per_instance=0 scope=spfile sid='*';
System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

启动报错，无法nomount

SQL> startup
ORA-03113: end-of-file on communication channel

分析告警日志：没有对应的错误

###alert_cjc1.log
2021-02-24T17:10:57.599168+08:00
Starting ORACLE instance (normal) (OS id: 30044)
2021-02-24T17:10:57.895661+08:00
****************************************************
 Sys-V shared memory will be used for creating SGA 
 ****************************************************
2021-02-24T17:10:57.896841+08:00
**********************************************************************
2021-02-24T17:10:57.896920+08:00
Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 
2021-02-24T17:10:57.897110+08:00
 Domain name: user.slice
2021-02-24T17:10:57.897286+08:00
 Per process system memlock (soft) limit = 14G
2021-02-24T17:10:57.897455+08:00
 Expected per process system memlock (soft) limit to lock
 instance MAX SHARED GLOBAL AREA (SGA) into memory: 7682M
2021-02-24T17:10:57.897809+08:00
 Available system pagesizes:
  4K, 2048K 
2021-02-24T17:10:57.898180+08:00
 Supported system pagesize(s):
2021-02-24T17:10:57.898427+08:00
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
2021-02-24T17:10:57.898619+08:00
        4K       Configured              11           34698        NONE
2021-02-24T17:10:57.898922+08:00
     2048K             3773            3841            3773        NONE
2021-02-24T17:10:57.899116+08:00
RECOMMENDATION:
2021-02-24T17:10:57.899346+08:00
 1. For optimal performance, configure system with expected number 
 of pages for every supported system pagesize prior to the next 
 instance restart operation.
2021-02-24T17:10:57.903856+08:00
**********************************************************************
2021-02-24T17:11:01.066125+08:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2021-02-24T17:11:01.098878+08:00
Initial number of CPU is 4
Number of processor cores in the system is 4
Number of processor sockets in the system is 4
KSXRTEST ISGA: RM Channel count = 1
KSXRTEST ISGA: rcnt= 70 rmrcnt = 1
Capability Type : Network 
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Runtime Environment 
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems 
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Database Test 
capabilities requested : 3 detected : 0 Simulated : 0
kjidomenacan initialized to 0
Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/db/product/19.0.0/dbs/arch
Autotune of undo retention is turned on. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled

过一会再次启动也不行

[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 24 16:55:35 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected.
SQL> startup           
ORA-01081: cannot start already-running ORACLE - shut it down first

临时解决方案：

在节点2执行reset命令，回退参数。

SQL> alter system reset open_links_per_instance scope=spfile sid='*';

再次启动节点1，可以正常启动了。
欢迎关注我的公众号**《IT小Chen》**