Author's details

Name: Aaron Myers
Date registered: March 30, 2014
URL: https://www.balddba.com

Latest posts

  1. Ransomeware Attack — February 7, 2023
  2. RMAN table recovery error — May 20, 2022
  3. Getting and formatting index ddl — September 17, 2021
  4. pythonGit private repository — September 2, 2020
  5. cx_Oracle ORA-24418 — April 30, 2020

Author's posts listings

Apr 24

New Server

My old web server has been retired. I have been moving sites the last couple of days to a new box. I took the time to virtualize the machine and set everything up properly. The old box was starting to show it’s age with lots of modified configuration files and outdated software. The website seems …

Continue reading »

Jan 04

Monitoring Online ASM Datafile Moves

I’m moving a ~7TB database online as the development group that uses it doesn’t want to take any down time. Thankfully the database isn’t horribly active right now so moving the data files online isn’t causing a huge problem. The only other times I have moved data files online was in an incredibly busy database …

Continue reading »

Oct 17

Reporting Database Sizes

I frequently need to pull size information about a large number of databases. OEM has an interesting capacity planning feature, but some times I just want the raw data. This is the base query I start with and add on additional information or slice it in different ways to fit what I need. I run …

Continue reading »

Jan 23

ORA 600 [kcbAdoptBuffers_pw]

We hit this bug the other day. The oracle note references creating an index as part of this bug. As far as I can tell, we weren’t doing that when we hit this. It is a vendor application though, and I know they do some DDL such as creating tables on the fly. I was …

Continue reading »

Dec 07

Setting up SSL ACL in 12cR2

Before you can connect to a website you need to setup the oracle wallet. Start by going to the website you are going to be connecting to. In this case I am just using my own site. I am also using Safari on OSX, the steps differ slightly depending on operating system and browser. After …

Continue reading »

Nov 30

13C OMS and TLSv1.2

A while ago I deployed OEM 13c to manage and monitor our databases. We have a lot of different systems on different architectures and operating systems. For the most part the move from OEM12c to OEM 13c was pretty smooth. As part of this process we were instructed to lock everything down to TLSv1.2, which …

Continue reading »

Oct 12

Loading Execution Plan for AWR

Create a new tuning set BEGIN DBMS_SQLTUNE.CREATE_SQLSET(sqlset_name => ‘0uff0s72zg781_tuning_task10’); END; / Load the execution plan into the tuning set DECLARE cur sys_refcursor; BEGIN open cur for select value(p) from table(dbms_sqltune.select_workload_repository( begin_snap => 77002, end_snap => 77003, basic_filter => ‘sql_id IN (”0uff0s72zg781”) AND plan_hash_value = ”2294492662”’)) p; dbms_sqltune.load_sqlset(‘0uff0s72zg781_tuning_task10’, cur); close cur; END; / Apply the plan …

Continue reading »

Aug 31

ORA-31617: unable to open dump file “/export/data.dmp” for write

This morning a user came to me because they were getting what appeared to be a Permission error FLASHBACK automatically enabled to preserve database integrity. Starting “myschema”.”SYS_EXPORT_SCHEMA_06″: Estimate in progress using BLOCKS method… Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 252.1 GB ORA-31693: Table data object “myschema”.”mytable” failed to load/unload and is being …

Continue reading »

Aug 31

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

On a non-production database I was getting the following error when trying to delete archive logs with RMAN. RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=+RECO/DBP1/ARCHIVELOG/2017_05_07/thread_1_seq_32041.11548.943352263 thread=1 sequence=32041 This database does not have any golden gate processes associated with it, so why doesn’t Oracle want to …

Continue reading »

Aug 31

ORA-02396: exceeded maximum idle time, please connect again

I was doing a schema import last night, over a database link. Lack of sleep had set in and I was getting the following error Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [INDEX:”SCHEMA_OWNER”.”TABLE2″] ORA-02396: exceeded maximum idle time, please connect again ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95 ORA-06512: at “SYS.KUPW$WORKER”, line 11259 …

Continue reading »

Older posts «

» Newer posts