the online part of the Oracle Beer events

Category Allgemein

ORA-00942: when using Oracle Tuning Advisor

problem When you log in using enterprise user security and get permissions granted via global roles (LDAP/OUT etc.) and you execute a sql tuning advisor task for a statement of another user you got the ORA-00942 error message even if… Continue Reading →

node eviction due to diagsnap.pl process

problem Some day one of our Exadata compute nodes was evicted from cluster due to hangup of critical cluster process. analysis From crs log files we found out that server was evicted because the heartbeat didn’t answer anymore. We decided… Continue Reading →

segmentation_fault from root.sh during addnode.sh

problem When adding a compute node to Grid Infrastructure on Exadata using addNode.sh and run root.sh after we got a segmentation fault error message during step 4 of 19 like that: error message from logfile Using configuration parameter file: /app/grid/product/19.1.0.0/crs/install/crsconfig_params The… Continue Reading →

ORA-01017 when using srvctl start/stop database

When you try to use srvctl to start/stop a database you got this error: > srvctl start instance -d EAI01H -i EAI01H1 PRCR-1013 : Failed to start resource ora.eai01h.db PRCR-1064 : Failed to start resource ora.eai01h.db on node exa101s01 CRS-5017: The resource action… Continue Reading →

rman „forgets“ datafile backupset

We faced an issue (bug description in MoS note 2407835.1) with having a bigfile tablespace at maximum size (8k blocksize = 32TB). When backing up such a file rman seems to forget the related backupsets. When you list backupsets from within… Continue Reading →

© 2022 Oracle Beer Blog — Powered by WordPress

Theme by Anders NorenUp ↑