the online part of the Oracle Beer events

Tag Christian

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 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 during

problem When adding a compute node to Grid Infrastructure on Exadata using and run 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/ The… Continue Reading →

multiple hardware alerts on Exadata x7-2 (compute node) alert history

One of our x7-2 compute nodes shows entries in the alert history like that: Problem Status : open Diag Engine : fdd 1.0 System  Manufacturer : Oracle Corporation Name : Exadata X7-2 Upgrade Part_Number : Exadata X7-2 Upgrade Serial_Number : <serial>  System Component  Manufacturer : Oracle Corporation Name… 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 →

© 2023 Oracle Beer Blog — Powered by WordPress

Theme by Anders NorenUp ↑