主页 / dba / 问题

问题[rac](dba)

Martin Hope
lear1
Asked: 2021-03-15 11:07:12 +0800 CST
  • 0

使用命令同时修补 GI Home 和 DB Home 后：

.oraenv
+ASM1
opatchauto apply /patchlocation

我应该从 DB home 还是 GI home 运行 ./datapatch？或者不管来自哪个家庭？谢谢

oracle rac
Martin Hope
lear1
Asked: 2020-09-14 04:56:58 +0800 CST
  • 0

系统：

[oracle@hostname:/opt/oraclegrid/18]$ uname -a
SunOS hostname 5.11 11.4.24.75.2 sun4v sparc sun4v

数据库：

Oracle 18c 18.10 (April 2020 patch), RacOneNode setup

补丁

OPatch Version: 12.2.0.1.21

我发现，GRID/DB home 中的 .patch_storage 文件夹在文件系统上占用了很多空间。我尝试使用 opatch util cleanup 实用程序（此实用程序应该清理此文件夹）但没有任何反应。这是输出：

[oracle@hostname:/opt/oraclegrid/18]$ du -hs .patch_storage/
 4.1G   .patch_storage
[oracle@hostname:/opt/oraclegrid/18]$ opatch util cleanup
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.


Oracle Home       : /opt/oraclegrid/18
Central Inventory : /opt/oraInventory
   from           : /opt/oraclegrid/18/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.4.0
Log file location : /opt/oraclegrid/18/cfgtoollogs/opatch/opatch2020-09-13_14-47-13PM_1.log

Invoking utility "cleanup"
OPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.
You will be still able to rollback patches after this cleanup.
Do you want to proceed? [y|n]
y
User Responded with: Y

Backup area for restore has been cleaned up. For a complete list of files/directories
deleted, Please refer log file.

OPatch succeeded.
[oracle@hostname:/opt/oraclegrid/18]$ du -hs .patch_storage/
 4.1G   .patch_storage

日志输出：

[Sep 13, 2020 2:47:14 PM] [INFO]    CUP_LOG: Trying to load HomeOperations object
[Sep 13, 2020 2:47:14 PM] [INFO]    CUP_LOG: HomeOperations provider not available
[Sep 13, 2020 2:47:14 PM] [INFO]    CUP_LOG: This is unusual state. HomeOperations object is null, but it should not be null if HomeOperations create went thru. CUP is not available
[Sep 13, 2020 2:47:14 PM] [INFO]    OPatch invoked as follows: 'util cleanup -invPtrLoc /opt/oraclegrid/18/oraInst.loc '
[Sep 13, 2020 2:47:14 PM] [INFO]    Runtime args: [-Xmx1536m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/opt/oraclegrid/18/cfgtoollogs/opatch, -DCommonLog.LOG_SESSION_ID=, -DCommonLog.COMMAND_NAME=ut
il, -DOPatch.ORACLE_HOME=/opt/oraclegrid/18, -DOPatch.DEBUG=false, -DOPatch.MAKE=false, -DOPatch.RUNNING_DIR=/opt/oracle/18/OPatch, -DOPatch.MW_HOME=, -DOPatch.WL_HOME=, -DOPatch.COMMON_COMPONENTS_HOME=, -DO
Patch.OUI_LOCATION=/opt/oraclegrid/18/oui, -DOPatch.FMW_COMPONENT_HOME=, -DOPatch.OPATCH_CLASSPATH=, -DOPatch.WEBLOGIC_CLASSPATH=, -DOPatch.SKIP_OUI_VERSION_CHECK=, -DOPatch.NEXTGEN_HOME_CHECK=false, -DOPatc
h.PARALLEL_ON_FMW_OH=]
[Sep 13, 2020 2:47:14 PM] [INFO]    Heap in use : 24 MB
                                    Total memory: 307 MB
                                    Free memory : 282 MB
                                    Max memory  : 1365 MB
[Sep 13, 2020 2:47:14 PM] [INFO]    Oracle Home       : /opt/oraclegrid/18
                                    Central Inventory : /opt/oraInventory
                                       from           : /opt/oraclegrid/18/oraInst.loc
                                    OPatch version    : 12.2.0.1.21
                                    OUI version       : 12.2.0.4.0
                                    OUI location      : /opt/oraclegrid/18/oui
                                    Log file location : /opt/oraclegrid/18/cfgtoollogs/opatch/opatch2020-09-13_14-47-13PM_1.log
[Sep 13, 2020 2:47:14 PM] [INFO]    Patch history file: /opt/oraclegrid/18/cfgtoollogs/opatch/opatch_history.txt
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-TIME] Loading raw inventory
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 54 (MB)
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 54 (MB)
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-TIME] Raw inventory loaded successfully
[Sep 13, 2020 2:47:16 PM] [INFO]    Invoking utility "cleanup"
[Sep 13, 2020 2:47:16 PM] [INFO]    [OPSR-TIME] Cleaning up backup
[Sep 13, 2020 2:47:16 PM] [INFO]    OPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.
                                    You will be still able to rollback patches after this cleanup.
                                    Do you want to proceed? [y|n]
[Sep 13, 2020 2:47:16 PM] [INFO]    Start to wait for user-input at Sun Sep 13 14:47:16 CEST 2020
[Sep 13, 2020 2:47:19 PM] [INFO]    Finish waiting for user-input at Sun Sep 13 14:47:19 CEST 2020
[Sep 13, 2020 2:47:19 PM] [INFO]    User Responded with: Y
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :
[Sep 13, 2020 2:47:19 PM] [INFO]    Cannot delete as either pathToBeDeleted is empty or it does not contain .patch_storage :

这是一个错误吗？还是我做错了什么？最新版本的 opatch 是否不再支持此命令？感谢你们

oracle rac
Martin Hope
Gryu
Asked: 2019-06-18 16:09:56 +0800 CST
  • 3

我有一个由两个节点 (OL6) 和 ASM 组成的 Oracle 12c RAC。我用它来学习。出于某种原因，我想增加它的临时表空间大小。现在大约50M。我已经考虑过使用SELECT * FROM dba_temp_free_space;命令。我想把它增加到2048M。

我知道，如何在通常的配置中增加它：

ALTER DATABASE TEMPFILE '/u02/oradata/my_sid/temp01.dbf' RESIZE 2048M;

知道临时表空间文件的路径。

我试图获取有关数据库文件的信息，以查看是否有一些文件名称中包含“temp”一词：

select * from dba_data_files;

但我只有下一个文件的名称：

+DATA/ORCL/DATAFILE/system.287.970304491
+DATA/ORCL/DATAFILE/sysaux.288.970304523
+DATA/ORCL/DATAFILE/users.290.970304549
+DATA/ORCL/DATAFILE/undotbs1.289.970304547
+DATA/ORCL/DATAFILE/undotbs2.295.970304621

那么，如何获取tempXX.dbf文件的正确路径并调整其大小呢？

oracle-12c rac
Martin Hope
emilly
Asked: 2018-06-29 18:45:10 +0800 CST
  • 1

我的应用程序正在生产中的真实集群应用程序 (RAC) 中工作。我是 RAC 的新手，看过这个视频。

看完后我的理解

  1. RAC使用多个节点只对内存中的数据进行数据处理，但仍然使用一个节点存储数据
  2. 处理可以像应用索引、按子句排序、任何函数等
  3. 所以它是处理级别的负载分配而不是数据存储级别

我的理解正确吗？

oracle rac
Martin Hope
Prabhakar
Asked: 2018-05-05 11:17:16 +0800 CST
  • 0

ASMCA Oracle 实用程序

嗨大师们，

在 OEL 7.5 上运行ASMCA 实用程序时，Oracle 无法呈现该工具的 GUI。我单击退出按钮，下一个屏幕显示为一条垂直线（上面附有屏幕）。没有选项可以展开窗口。

有没有人遇到过这种类型的问题？如果您对此有解决方案，请告诉我。

任何帮助表示赞赏。

谢谢普拉巴卡

oracle rac
Martin Hope
CyberOptic
Asked: 2015-02-05 03:59:50 +0800 CST
  • 0

我不是 DB 甚至 Oracle 专家，但我想了解 Oracle 何时以及为何向客户端返回不同的非 VIP 地址，假设这是正确的行为？

监听器.ora

LISTENER_DB-A =
(DESCRIPTION_LIST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DB-A-VIP)(PORT = 1521)(IP = FIRST))
       # this is the VIP 10.0.0.15
    )
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.10)(PORT = 1521)(IP = FIRST))
    )
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
  )
)

这里，Oracle服务器连接IP地址10.0.0.15后，将10.0.0.10地址返回给客户端。这是我对上述行为的网络嗅探：

客户端到甲骨文

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.15)(PORT=1521)))
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVER=DEDICATED)
(SERVICE_NAME=my_db)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=5)(DELAY=5))))

甲骨文到客户

(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=DB-A))(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.10)(PORT=1521)))

我知道这种行为不是强制性的，因为我已经看到 Oracle 服务器在没有上述重定向的情况下做出响应。服务器以这种方式运行的原因是什么？提前致谢！

oracle rac
Martin Hope
Krish
Asked: 2014-09-09 22:09:42 +0800 CST
  • 0

我想知道 SERVICE_NAME 是否始终配置为 Oracle 独立和 RAC 设置，或者它是可选设置。

在我的代码中，我想使用 SERVICE_NAME 连接到数据库。但是，如果 SERVICE_NAME 并不总是存在，那么我将不得不选择使用 SID 进行连接。请指教。

oracle rac
Martin Hope
reneton
Asked: 2014-07-18 10:53:10 +0800 CST
  • 1

这可能是一个转储问题，但我已经阅读了很多不同的东西，所以我不再确定了。我试图理解 Oracle RAC 的概念，所以我一直在阅读 Oracle 的数据表。我以为我确实理解这个概念，但后来我用谷歌搜索，发现一些图片令人困惑，现在我不再确定了。

RAC 概念基于多个（物理）服务器共享它们的内存 (HD) 并显示为一个逻辑数据库。数据没有存储在其他（物理）设备中，例如 nas？我对吗？

在此处输入图像描述

谢谢

oracle rac