Name: Aaron Myers
Date registered: March 30, 2014
URL: https://www.balddba.com
Apr 24
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 …
Jan 04
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 …
Oct 17
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 …
Jan 23
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 …
Dec 07
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 …
Nov 30
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 …
Oct 12
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 …
Aug 31
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 …
Aug 31
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 …
Aug 31
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 …
Recent Comments