oracle rac环境修改db_files参数

最新推荐文章于 2024-03-04 09:10:42 发布
最新推荐文章于 2024-03-04 09:10:42 发布
阅读量554 收藏
点赞数
文章标签： 数据库
一。情况修改不成功
调整前情况：
[oracle@racdb2 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    racdb1      
ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      
ora.racdb1.ons application    ONLINE    ONLINE    racdb1      
ora.racdb1.vip application    ONLINE    ONLINE    racdb1      
ora....B2.lsnr application    ONLINE    ONLINE    racdb2      
ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      
ora.racdb2.ons application    ONLINE    ONLINE    racdb2      
ora.racdb2.vip application    ONLINE    ONLINE    racdb2      
ora.shirac.db  application    ONLINE    ONLINE    racdb1      
ora....src1.cs application    ONLINE    ONLINE    racdb1      
ora....ac1.srv application    ONLINE    ONLINE    racdb1      
ora....src2.cs application    ONLINE    ONLINE    racdb1      
ora....ac1.srv application    ONLINE    ONLINE    racdb1      
ora....src1.cs application    ONLINE    ONLINE    racdb2      
ora....ac2.srv application    ONLINE    ONLINE    racdb2      
ora....src2.cs application    ONLINE    ONLINE    racdb2      
ora....ac2.srv application    ONLINE    ONLINE    racdb1      
ora....c1.inst application    ONLINE    ONLINE    racdb1      
ora....c2.inst application    ONLINE    ONLINE    racdb2   

[oracle@racdb2 ~]$ crs_stat 
NAME=ora.racdb1.LISTENER_RACDB1.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.racdb1.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.racdb1.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.racdb1.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.racdb2.LISTENER_RACDB2.lsnr
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb2

NAME=ora.racdb2.gsd
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb2

NAME=ora.racdb2.ons
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb2

NAME=ora.racdb2.vip
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb2

NAME=ora.shirac.db
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.shirac.id1_src1.cs
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.shirac.id1_src1.shirac1.srv
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.shirac.id1_src2.cs
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.shirac.id1_src2.shirac1.srv
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.shirac.id2_src1.cs
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb2

NAME=ora.shirac.id2_src1.shirac2.srv
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb2

NAME=ora.shirac.id2_src2.cs
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb2

NAME=ora.shirac.id2_src2.shirac2.srv
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.shirac.shirac1.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb1

NAME=ora.shirac.shirac2.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on racdb2

查看当前参数情况：
SQL> show parameter db_files
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     320

在shirac1上执行命令修改参数：
SQL> alter system set db_files=350 scope=spfile sid='*';

System altered.

停数据库：
[oracle@racdb2 ~]$ srvctl stop database -d shirac
[oracle@racdb2 ~]$ 

[oracle@racdb1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    racdb1      
ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      
ora.racdb1.ons application    ONLINE    ONLINE    racdb1      
ora.racdb1.vip application    ONLINE    ONLINE    racdb1      
ora....B2.lsnr application    ONLINE    ONLINE    racdb2      
ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      
ora.racdb2.ons application    ONLINE    ONLINE    racdb2      
ora.racdb2.vip application    ONLINE    ONLINE    racdb2      
ora.shirac.db  application    OFFLINE   OFFLINE               
ora....src1.cs application    ONLINE    OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src1.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....c1.inst application    OFFLINE   OFFLINE               
ora....c2.inst application    OFFLINE   OFFLINE            

启动数据库
[oracle@racdb2 ~]$ srvctl start database -d shirac 
PRKP-1001 : Error starting instance shirac2 on node racdb2
CRS-0215: Could not start resource 'ora.shirac.shirac2.inst'.

cluster状态
[oracle@racdb1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    racdb1      
ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      
ora.racdb1.ons application    ONLINE    ONLINE    racdb1      
ora.racdb1.vip application    ONLINE    ONLINE    racdb1      
ora....B2.lsnr application    ONLINE    ONLINE    racdb2      
ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      
ora.racdb2.ons application    ONLINE    ONLINE    racdb2      
ora.racdb2.vip application    ONLINE    ONLINE    racdb2      
ora.shirac.db  application    ONLINE    ONLINE    racdb2      
ora....src1.cs application    ONLINE    OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src1.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....c1.inst application    ONLINE    ONLINE    racdb1      
ora....c2.inst application    ONLINE    OFFLINE               

此时报错实例2起不来，sqlplus进去单独启动
[oracle@racdb2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 31 17:01:49 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  444596224 bytes
Fixed Size                  2021440 bytes
Variable Size             234883008 bytes
Database Buffers          205520896 bytes
Redo Buffers                2170880 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01174: DB_FILES is 350 buts needs to be 320 to be compatible

提示DB_FILES的值不一致
shirac2上
SQL> show parameter db_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     350

shirac1上
SQL> show parameter db_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     320

紧急将shirac2实例起来：
SQL> alter system set db_files=320 scope=spfile sid='shirac2';

System altered.

SQL> shutdown immediate;
ORA-01507: database not mounted

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

Total System Global Area  444596224 bytes
Fixed Size                  2021440 bytes
Variable Size             234883008 bytes
Database Buffers          205520896 bytes
Redo Buffers                2170880 bytes
Database mounted.
Database opened.

cluster状态：
[oracle@racdb1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    racdb1      
ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      
ora.racdb1.ons application    ONLINE    ONLINE    racdb1      
ora.racdb1.vip application    ONLINE    ONLINE    racdb1      
ora....B2.lsnr application    ONLINE    ONLINE    racdb2      
ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      
ora.racdb2.ons application    ONLINE    ONLINE    racdb2      
ora.racdb2.vip application    ONLINE    ONLINE    racdb2      
ora.shirac.db  application    ONLINE    ONLINE    racdb2      
ora....src1.cs application    ONLINE    OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src1.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....c1.inst application    ONLINE    ONLINE    racdb1      
ora....c2.inst application    OFFLINE   OFFLINE            

手动在cluster中启动实例
[oracle@racdb2 ~]$ srvctl start instance -d shirac -i shirac2
[oracle@racdb2 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    racdb1      
ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      
ora.racdb1.ons application    ONLINE    ONLINE    racdb1      
ora.racdb1.vip application    ONLINE    ONLINE    racdb1      
ora....B2.lsnr application    ONLINE    ONLINE    racdb2      
ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      
ora.racdb2.ons application    ONLINE    ONLINE    racdb2      
ora.racdb2.vip application    ONLINE    ONLINE    racdb2      
ora.shirac.db  application    ONLINE    ONLINE    racdb2      
ora....src1.cs application    ONLINE    OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src1.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....c1.inst application    ONLINE    ONLINE    racdb1      
ora....c2.inst application    ONLINE    ONLINE    racdb2   

启动服务：
[oracle@racdb2 ~]$ crs_start -all
Attempting to start `ora.shirac.id2_src1.cs` on member `racdb2`
Attempting to start `ora.shirac.id1_src1.cs` on member `racdb1`
Attempting to start `ora.shirac.id2_src2.cs` on member `racdb2`
Attempting to start `ora.shirac.id1_src1.shirac1.srv` on member `racdb1`
Attempting to start `ora.shirac.id1_src2.shirac1.srv` on member `racdb1`
Attempting to start `ora.shirac.id1_src2.cs` on member `racdb1`
Attempting to start `ora.shirac.id2_src1.shirac2.srv` on member `racdb1`
Start of `ora.shirac.id2_src2.cs` on member `racdb2` succeeded.
Start of `ora.shirac.id1_src1.cs` on member `racdb1` succeeded.
Start of `ora.shirac.id1_src2.cs` on member `racdb1` succeeded.
Start of `ora.shirac.id2_src1.cs` on member `racdb2` succeeded.
Start of `ora.shirac.id1_src2.shirac1.srv` on member `racdb1` succeeded.
Start of `ora.shirac.id2_src1.shirac2.srv` on member `racdb1` succeeded.
Start of `ora.shirac.id1_src1.shirac1.srv` on member `racdb1` succeeded.
CRS-0233: Resource or relatives are currently involved with another operation.

[oracle@racdb2 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    racdb1      
ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      
ora.racdb1.ons application    ONLINE    ONLINE    racdb1      
ora.racdb1.vip application    ONLINE    ONLINE    racdb1      
ora....B2.lsnr application    ONLINE    ONLINE    racdb2      
ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      
ora.racdb2.ons application    ONLINE    ONLINE    racdb2      
ora.racdb2.vip application    ONLINE    ONLINE    racdb2      
ora.shirac.db  application    ONLINE    ONLINE    racdb2      
ora....src1.cs application    ONLINE    ONLINE    racdb1      
ora....ac1.srv application    ONLINE    ONLINE    racdb1      
ora....src2.cs application    ONLINE    ONLINE    racdb1      
ora....ac1.srv application    ONLINE    ONLINE    racdb1      
ora....src1.cs application    ONLINE    ONLINE    racdb2      
ora....ac2.srv application    ONLINE    ONLINE    racdb1      
ora....src2.cs application    ONLINE    ONLINE    racdb2      
ora....ac2.srv application    ONLINE    ONLINE    racdb2      
ora....c1.inst application    ONLINE    ONLINE    racdb1      
ora....c2.inst application    ONLINE    ONLINE    racdb2      


二。情况修改成功
在shirac1:
SQL> show parameter instance_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      shirac1
SQL> show parameter db_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     320

在shirac2:
SQL> show parameter instance_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      shirac2
SQL> show parameter db_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     320

在shirac1:
SQL>  alter system set db_files=350 scope=spfile sid='shirac2';

System altered.

SQL> alter system set db_files=350 scope=spfile sid='shirac1';

System altered.


停数据库：
[oracle@racdb2 ~]$ srvctl stop database -d shirac
[oracle@racdb2 ~]$ 

cluster状态：
[oracle@racdb1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    racdb1      
ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      
ora.racdb1.ons application    ONLINE    ONLINE    racdb1      
ora.racdb1.vip application    ONLINE    ONLINE    racdb1      
ora....B2.lsnr application    ONLINE    ONLINE    racdb2      
ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      
ora.racdb2.ons application    ONLINE    ONLINE    racdb2      
ora.racdb2.vip application    ONLINE    ONLINE    racdb2      
ora.shirac.db  application    OFFLINE   OFFLINE               
ora....src1.cs application    OFFLINE   OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src1.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....c1.inst application    OFFLINE   OFFLINE               
ora....c2.inst application    OFFLINE   OFFLINE               


启动数据库：
[oracle@racdb2 ~]$ srvctl start database -d shirac


cluster状态：
[oracle@racdb2 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    racdb1      
ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      
ora.racdb1.ons application    ONLINE    ONLINE    racdb1      
ora.racdb1.vip application    ONLINE    ONLINE    racdb1      
ora....B2.lsnr application    ONLINE    ONLINE    racdb2      
ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      
ora.racdb2.ons application    ONLINE    ONLINE    racdb2      
ora.racdb2.vip application    ONLINE    ONLINE    racdb2      
ora.shirac.db  application    ONLINE    ONLINE    racdb1      
ora....src1.cs application    OFFLINE   OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac1.srv application    OFFLINE   OFFLINE               
ora....src1.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....src2.cs application    OFFLINE   OFFLINE               
ora....ac2.srv application    OFFLINE   OFFLINE               
ora....c1.inst application    ONLINE    ONLINE    racdb1      
ora....c2.inst application    ONLINE    ONLINE    racdb2    


修改后情况：
SQL> show parameter instance_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      shirac1
SQL> show parameter db_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     350


SQL> show parameter instance_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      shirac2
SQL> show parameter db_files

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer     350


参数已经修改成功，启动服务
[oracle@racdb1 ~]$ crs_start -all
Attempting to start `ora.shirac.id1_src1.cs` on member `racdb1`
Attempting to start `ora.shirac.id1_src1.shirac1.srv` on member `racdb2`
Attempting to start `ora.shirac.id1_src2.cs` on member `racdb1`
Attempting to start `ora.shirac.id2_src1.shirac2.srv` on member `racdb1`
Start of `ora.shirac.id1_src1.shirac1.srv` on member `racdb2` succeeded.
Attempting to start `ora.shirac.id1_src2.shirac1.srv` on member `racdb1`
Attempting to start `ora.shirac.id2_src2.cs` on member `racdb2`
Start of `ora.shirac.id1_src1.cs` on member `racdb1` succeeded.
Attempting to start `ora.shirac.id2_src1.cs` on member `racdb2`
Attempting to start `ora.shirac.id2_src2.shirac2.srv` on member `racdb1`
Start of `ora.shirac.id2_src1.cs` on member `racdb2` succeeded.
Start of `ora.shirac.id1_src2.cs` on member `racdb1` succeeded.
Start of `ora.shirac.id2_src1.shirac2.srv` on member `racdb1` succeeded.
Start of `ora.shirac.id2_src2.cs` on member `racdb2` succeeded.
Start of `ora.shirac.id1_src2.shirac1.srv` on member `racdb1` succeeded.
Start of `ora.shirac.id2_src2.shirac2.srv` on member `racdb1` succeeded.


[oracle@racdb1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora....B1.lsnr application    ONLINE    ONLINE    racdb1      
ora.racdb1.gsd application    ONLINE    ONLINE    racdb1      
ora.racdb1.ons application    ONLINE    ONLINE    racdb1      
ora.racdb1.vip application    ONLINE    ONLINE    racdb1      
ora....B2.lsnr application    ONLINE    ONLINE    racdb2      
ora.racdb2.gsd application    ONLINE    ONLINE    racdb2      
ora.racdb2.ons application    ONLINE    ONLINE    racdb2      
ora.racdb2.vip application    ONLINE    ONLINE    racdb2      
ora.shirac.db  application    ONLINE    ONLINE    racdb1      
ora....src1.cs application    ONLINE    ONLINE    racdb1      
ora....ac1.srv application    ONLINE    ONLINE    racdb2      
ora....src2.cs application    ONLINE    ONLINE    racdb1      
ora....ac1.srv application    ONLINE    ONLINE    racdb1      
ora....src1.cs application    ONLINE    ONLINE    racdb2      
ora....ac2.srv application    ONLINE    ONLINE    racdb1      
ora....src2.cs application    ONLINE    ONLINE    racdb2      
ora....ac2.srv application    ONLINE    ONLINE    racdb1      
ora....c1.inst application    ONLINE    ONLINE    racdb1      
ora....c2.inst application    ONLINE    ONLINE    racdb2      

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20957014/viewspace-731591/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20957014/viewspace-731591/

csu02808
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle rac修改参数sid,RAC 修改参数DB_FILES
weixin_39527292的博客
04-04 1049
这篇博客主要在生产环境下如何修改RAC下面的参数的步骤，过程和单实例有一点区别。DB_FILES 定义了oracle数据中数据文件的个数，当数据文件个数超过这个参数设定的值就会报ORA-00059这个错误。解决办法：show parameter db_files; --查看当前设置的值sqlplus / as sysdbaalter system set db_files=更大的值 scope...
RAC 修改参数DB_FILES
小楼一夜听春雨，深巷明朝卖杏花
06-29 5455
这篇博客主要在生产环境下如何修改RAC下面的参数的步骤，过程和单实例有一点区别。 DB_FILES 定义了oracle数据中数据文件的个数，当数据文件个数超过这个参数设定的值就会报ORA-00059这个错误。 解决办法： show parameter db_files; --查看当前设置的值 sqlplus / as sysdba alter system set db_f...
Oracle rac改参数,Oracle RAC环境修改db_files参数
weixin_39822629的博客
04-06 425
Oracle RAC环境修改db_files参数[日期：2012-07-03]来源：Linux社区作者：haozg_oracle[字体：大 中 小]一。情况修改不成功调整前情况：[Oracle@racdb2 ~]$ crs_stat -tName Type Target State Host---------------------------...
修改ORACLE DB_FILES
hoffmannlin的博客
11-03 1638
确认DB_FILES数量 SQL> show parameter db_files; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_files integer 200 检查是否由SPFILE或PFILE
ORACLE12c 修改 db_files
tang_jian_dong的博客
07-03 997
由于系统创建是时没有修改db_files大小， 现在不能增加数据文件。修改方法如下： 注意： 必须修改CDB的db_files大小， pdb的db_files大小仍然受限于 CDB的db_files大小。 也就是说必须修改数据库的db_files. 登录 sqlplus / as sysdba 修改db_files文件大小 alter system set db_files=300 scope=spfile; 停止数据库 shutdown immediate 启动数据库 ...
oracle_dba_code_examples201012.pdf
07-24
o Store Oracle DB files in the mounted points. # mkdir /mount_point/oradata # chown oracle:oinstall /mount_point/oradata # chmod 775 /mount_point/oradata /u01/oradata/prod1/control01.ctl /u05/oradata/...
Oracle 19c rac+adg.docx
12-21
3. 配置 RAC + ADG 参数：最后，需要配置 RAC + ADG 参数，包括配置日志归档、日志同步和数据保护等参数。 四、RAC + ADG 配置示例 下面是一个 RAC + ADG 配置示例： ``` HOST IP 192.168.189.211 rac1 HOST IP ...
window中oracle环境变量设置方法分享
01-21
>单击“环境变量”2、选择“Path”这一行，单击“编辑”，在“Path”的变量值文本框的最后面先加入一个分号“:”，然后再分号后面加入sqlplus文件的目录路径，如“C:\Program Files\oracle\product\10.2.0\db_1\BIN...
Python使用cx_Oracle模块将oracle中数据导出到csv文件的方法
01-21
# Export Oracle database tables to CSV files # FB36 - 201007117 import sys import csv import cx_Oracle connection = raw_input(Enter Oracle DB connection (uid/pwd@database) : ) orcl = cx_Oracle.connect...
Oracle性能究极优化
12-16
下面我们增加 SGA 重做日志的大小： DB3: Log Buffer Database Block Size 2K SGA Buffer Cache 128M SGA Shared Pool 128M SGA Redo Cache 16M Redo Log Files 16M Tablespaces Dictionary TPC Results Load Time ...
ORACLE之RAC集群环境修改db_files大小
浪子城
11-29 1275
随着数据量不断增大，每次手动或者程序监听自动增加表空间，都会逻辑划分一块磁盘用来存储。而逻辑磁盘的数量会受到oracle配置的影响。默认是200（我用的12C和18C版本都是200）。当逻辑磁盘数大小到200时，表空间就无法进行扩展了。
ORACLE 修改RAC参数
weixin_33845477的博客
11-25 510
2019独角兽企业重金招聘Python工程师标准>>> ...
oracle rac环境参数修改的问题
hayata的专栏
08-07 2665
在Oracle Rac集群环境里面，很多时候我们喜欢滚动升级，一个节点一个节点的修改
Oracle rac改参数,oracle rac环境参数修改的问题
weixin_29128423的博客
04-06 536
在Oracle Rac集群环境里面，很多时候我们喜欢滚动升级，一个节点一个节点的修改参数，但是有些参数是不是滚动的。今天我在群里面，就看到了一个这样的例子。这位网友出现的错误如下：SQL> host hostnameywwgrac1SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shu...
重庆思庄Linux技术分享-修改db_files参数演练
duanweifang的博客
05-23 580
数据库：oracle 19.14 + rac 系统：CentOS 7.9 修改db_files参数操作演练： SQL> show parameter db_files; NAME TYPE VALUE db_files integer 200 SQL> alter system set db_files=1000 scope=spfile sid=‘*’
oracle db_files超过,如何解决 Oracle 中 DB_FILES 限制引起的 ORA-00059 问题
weixin_30278943的博客
04-10 743
Oracle 数据库中 DB_FILES 定义了数据库中数据文件的个数 如果创建数据库文件时超过DB_FILES 定义的值就回报 ORA-00059 这个错误。那么如何解决这个 ORA-00059 问题呢，请参考以下教程。01、首先我们通过SQL查询出目前DB_FILES 定义值是多少。​ 通过 SSH 登录数据库服务器，如果是Oracle RAC 环境，登录任意一个节点都可以。通常使用的是 ...
Oracle 表空间和数据文件遇到的坑
最新发布
JiekeXu的博客
03-04 947
作者 | JiekeXu来源 |公众号 JiekeXu DBA之路（ID: JiekeXu_IT）如需转载请联系授权 |(个人微信 ID：JiekeXu_DBA)大家好，我是 JiekeXu,江湖人称“强哥”，很高兴又和大家见面了,今天和大家一起来看看Oracle 表空间和数据文件遇到的坑，欢迎点击上方蓝字“JiekeXu DBA之路”关注我的公众号，标星或置顶，更多干货第一时间到达！目 录...
Oracle静态参数修改以processes为例
zongzizz的博客
02-15 2451
Oracle静态参数修改以processes为例 静态参数修改需要重启数据库 第一步：修改参数 单实例 alter system set processes=8000 scope=spfile; RAC（在主节点上修改，一般为节点一） alter system set processes=8000 sid='*' scope=spfile; 第二步：重启数据库 单实例：shutdown immediate – startup RAC：多个节点的参数都修改完成后可同时重启数据库 srvctl sto
oracle 更改db files,修改db_files参数，是否影响业务？
weixin_33231055的博客
04-14 865
1、环境描述：Oracle 10g RAC ,在线修改db_files参数2、操作如下SQL> show parameter db_filesNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_files ...
oracle rac load_balance=off
05-24
当 `load_balance` 参数设置为 `off` 时，Oracle RAC 不会自动将新的连接路由到当前连接数最少的实例。相反，所有新连接都将被分配给当前实例，直到该实例的连接数达到 `SESSION_CACHED_CURSORS` 参数指定的限制。...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值