AskOverflow.Dev

AskOverflow.Dev Logo AskOverflow.Dev Logo

AskOverflow.Dev Navigation

  • Início
  • system&network
  • Ubuntu
  • Unix
  • DBA
  • Computer
  • Coding
  • LangChain

Mobile menu

Close
  • Início
  • system&network
    • Recentes
    • Highest score
    • tags
  • Ubuntu
    • Recentes
    • Highest score
    • tags
  • Unix
    • Recentes
    • tags
  • DBA
    • Recentes
    • tags
  • Computer
    • Recentes
    • tags
  • Coding
    • Recentes
    • tags
Início / dba / Perguntas / 275460
Accepted
lear1
lear1
Asked: 2020-09-14 04:56:58 +0800 CST2020-09-14 04:56:58 +0800 CST 2020-09-14 04:56:58 +0800 CST

A limpeza do Oracle 18c opatch util não está funcionando

  • 772

Sistema:

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

Base de dados:

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

Opatch

OPatch Version: 12.2.0.1.21

Descobri que uma pasta .patch_storage em casas GRID/DB ocupa muito espaço no sistema de arquivos. Tentei usar o utilitário de limpeza opatch util (este utilitário deve limpar esta pasta), mas nada aconteceu. Aqui está a saída:

[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

Saída de registro:

[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 :

Isso é um inseto? Ou estou fazendo algo errado? Este comando não é mais suportado nas versões mais recentes do opatch? Obrigado pessoal

oracle rac
  • 1 1 respostas
  • 643 Views

1 respostas

  • Voted
  1. Best Answer
    Balazs Papp
    2020-09-15T15:13:11+08:002020-09-15T15:13:11+08:00

    opatch util cleanupnunca deveria excluir tudo em .patch_storage. Ele ainda exibe que limpa apenas 'restore.sh,make.txt' files and 'scratch,backup' directories.

    Normalmente, opatch util cleanupnão liberará uma quantidade significativa de espaço. Os arquivos abaixo .patch_storagesão necessários para reverter patches.

    • 1

relate perguntas

  • Backups de banco de dados no Oracle - Exportar o banco de dados ou usar outras ferramentas?

  • ORDER BY usando prioridades personalizadas para colunas de texto

  • Interface sqlplus confortável? [fechado]

  • Como encontrar as instruções SQL mais recentes no banco de dados?

  • Como posso consultar nomes usando expressões regulares?

Sidebar

Stats

  • Perguntas 205573
  • respostas 270741
  • best respostas 135370
  • utilizador 68524
  • Highest score
  • respostas
  • Marko Smith

    conectar ao servidor PostgreSQL: FATAL: nenhuma entrada pg_hba.conf para o host

    • 12 respostas
  • Marko Smith

    Como fazer a saída do sqlplus aparecer em uma linha?

    • 3 respostas
  • Marko Smith

    Selecione qual tem data máxima ou data mais recente

    • 3 respostas
  • Marko Smith

    Como faço para listar todos os esquemas no PostgreSQL?

    • 4 respostas
  • Marko Smith

    Listar todas as colunas de uma tabela especificada

    • 5 respostas
  • Marko Smith

    Como usar o sqlplus para se conectar a um banco de dados Oracle localizado em outro host sem modificar meu próprio tnsnames.ora

    • 4 respostas
  • Marko Smith

    Como você mysqldump tabela (s) específica (s)?

    • 4 respostas
  • Marko Smith

    Listar os privilégios do banco de dados usando o psql

    • 10 respostas
  • Marko Smith

    Como inserir valores em uma tabela de uma consulta de seleção no PostgreSQL?

    • 4 respostas
  • Marko Smith

    Como faço para listar todos os bancos de dados e tabelas usando o psql?

    • 7 respostas
  • Martin Hope
    Jin conectar ao servidor PostgreSQL: FATAL: nenhuma entrada pg_hba.conf para o host 2014-12-02 02:54:58 +0800 CST
  • Martin Hope
    Stéphane Como faço para listar todos os esquemas no PostgreSQL? 2013-04-16 11:19:16 +0800 CST
  • Martin Hope
    Mike Walsh Por que o log de transações continua crescendo ou fica sem espaço? 2012-12-05 18:11:22 +0800 CST
  • Martin Hope
    Stephane Rolland Listar todas as colunas de uma tabela especificada 2012-08-14 04:44:44 +0800 CST
  • Martin Hope
    haxney O MySQL pode realizar consultas razoavelmente em bilhões de linhas? 2012-07-03 11:36:13 +0800 CST
  • Martin Hope
    qazwsx Como posso monitorar o andamento de uma importação de um arquivo .sql grande? 2012-05-03 08:54:41 +0800 CST
  • Martin Hope
    markdorison Como você mysqldump tabela (s) específica (s)? 2011-12-17 12:39:37 +0800 CST
  • Martin Hope
    Jonas Como posso cronometrar consultas SQL usando psql? 2011-06-04 02:22:54 +0800 CST
  • Martin Hope
    Jonas Como inserir valores em uma tabela de uma consulta de seleção no PostgreSQL? 2011-05-28 00:33:05 +0800 CST
  • Martin Hope
    Jonas Como faço para listar todos os bancos de dados e tabelas usando o psql? 2011-02-18 00:45:49 +0800 CST

Hot tag

sql-server mysql postgresql sql-server-2014 sql-server-2016 oracle sql-server-2008 database-design query-performance sql-server-2017

Explore

  • Início
  • Perguntas
    • Recentes
    • Highest score
  • tag
  • help

Footer

AskOverflow.Dev

About Us

  • About Us
  • Contact Us

Legal Stuff

  • Privacy Policy

Language

  • Pt
  • Server
  • Unix

© 2023 AskOverflow.DEV All Rights Reserve