Search
Tag Cloud
10.2 10.2.0.5 11.1 11.2 ADR alertlog ASM bug bundle patch cleanupDeploy database database appliance digest diskgroup enterprise manager gi grid control grid infrastructure GrindInst hashes LinkedIn listener localhost monitoring oak oakcli ODA odachk OEM one-off ORA oracle oracle database appliance password patch bundle PLSQL privileges RAC REDO sha1 solaris troubleshooting usable_file_mb x-windws xtermCategories
-
Recent Posts
Blogroll
Tag Archives: ORA
ORA-29283: invalid file operation using UTL_FILE.FREMOVE
I’ve been breaking my head over a problem I had with the UTL_FILE.FREMOVE command trying to remove a file created by another (not oracle) process. On *nix command line, logged in as user oracle (same as database) I’m able to … Continue reading
Posted in Database
Tagged database, FREMOVE, LinkedIn, ORA, oracle, PLSQL, solaris, troubleshooting, UTL_FILE, UTL_FILE.FREMOVE
Leave a comment
ORA-600 [kkpo_rcinfo_defstg:objnotfound] on a 11.2 RAC instance
RECOMMENDATION: Set the deferred_segment_creation parameter to FALSE for 11.2 RAC databases! Recently our monitoring picked up an ORA-600 from the alertlog of one of our 11.2 RAC instances. ORA-00600: internal error code, arguments: [kkpo_rcinfo_defstg:objnotfound],[87421], [], [], [], [], [], [], … Continue reading
ORA-19809: limit exceeded for recovery files
In our cloning procedures we use the RMAN “DUPLICATE” command for duplicating databases. This all went fine for a long time until one moment we start getting errors during the duplication process (from the point where media recovery gets started). … Continue reading
Posted in Database
Tagged 11.2, bug, database, LinkedIn, ORA, oracle, RMAN, troubleshooting
Leave a comment
ORA-00245: control file backup operation failed
A snapshot controlfile is a read consistent copy of a database controlfile which RMAN creates because the controlfile is changed constantly. As of Oracle 11.2 (11.2.0.2 to more precise) the snapshot controlfile must be on a location shared by all … Continue reading
Posted in RAC
Tagged 11.2, 11.2.0.2.0, alertlog, database, database appliance, LinkedIn, ODA, ORA, oracle, RAC, troubleshooting
1 Comment
Simulating ORA-errors
Sometimes it can be useful to simulate a problem in your database by simulating an ORA-error. After we had a nasty bug with Grid Control (GC suddenly wasn’t able to monitor the alertlog of 10.2.0.5 databases anymore, see my post … Continue reading
Posted in Database
Tagged ADR, alertlog, database, dbms_system.ksdwrt, enterprise manager, grid control, LinkedIn, ORA, oracle, simulation, troubleshooting
Leave a comment