Category Archive: Oracle

Apr 30

cx_Oracle ORA-24418

I am writing a web portal for a bunch of database tasks, and storing information in an oracle database. I am creating a connection pool but seeing this error. This looks like an ORA-24418 out of sessions error. However when I check the database, there are only 120 of the 1200 available sessions being consumed. …

Continue reading »

Mar 19

Patching 19.3 to 19.6

I’m not going to go through the entire patching process, there are lots of other sites that can walk you through this. What I am going to talk about is some issues that I had after patching. The patch to the binaries went fine, however when I tried to run Datapatch against my database, I …

Continue reading »

May 14

ORA-01422: exact fetch returns more than requested number of rows

The other night on of my databases started throwing the following error. From the RMAN trace The solution here is actually quite simple, the rout table, which stores previous rman output from previous runs so that it can displayed in OEM had excessive rows in it. Since we don’t really use OEM to track our …

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 »

Older posts «