Без рубрики

fixed by merge of 2 folders from rac nodes into single directory:

in addition to how to backup invalid object source : and drop them:

Unfortunately, the old Metalink note 175982.1 which used to describe the internal mnemonic’s has disappeared from My Oracle Support.       Modified: 16-AUG-2011 Type: BULLETIN Status: PUBLISHED   In this Document Purpose Scope and Application ORA-600 Lookup Error Categories Internal Errors Categorised by number range Internal Errors Categorised by mnemonic Applies to: Oracle Server … Читать далее

script to monitor tablespace usage, in this example warn me if tablespace usage is more than 85% and free space in in lower than 30GB same thing but for asm : check scheduler state ( last running job status ) check invalid objects check unusable index

How To Configure SSH for a RAC Installation [ID 300548.1]

Grid Oracle:

create procedure to create\drop restore point: create scheduler job to call os scripts create and assign credentials and pin scheduler job to first node ( where scripts placed ) drop_restore_point.sh create_restore_point.sh so, after all create and delete restore point looks like :

create shared storage: data: OCR: make disk shareable: add disk to virtual machine make disk partitions: 1. generate create partion table : need to automate create partition script no free vm to test 2. generate create asm disk: Normal storage how to:

[oracle@p00xxxdb01 ~]$ srvctl status database -d p00xxx PRCD-1027 : Failed to retrieve database p00xxx PRCD-1229 : An attempt to access configuration of database p00xxx was rejected because its version 11.2.0.2.0 differs from the program version 11.2.0.4.0. Instead run the program from /oracle/app/base/db/11.2.0.2. [oracle@p00xxxdb01 ~]$ srvctl upgrade database -d p00xxx -o /oracle/app/base/db/11.2.0.4 [oracle@p00xxxdb01 ~]$