S3 Bucket – IllegalLocationConstraintException

A quick one !! Creating bucket failed with "IllegalLocationConstraintException" -- [ec2-user@ip-172-31-33-128 ~]$ aws s3api create-bucket --bucket labtestrand --region us-west-2 An error occurred (IllegalLocationConstraintException) when calling the CreateBucket operation: The unspecified location constraint is incompatible for the region specific endpoint this request was sent to. Solution -- [ec2-user@ip-172-31-33-128 ~]$ [ec2-user@ip-172-31-33-128 ~]$ aws s3api create-bucket --bucket labtestrand … Continue reading S3 Bucket – IllegalLocationConstraintException


“U” entries in MLOG$

Recently in a discussion with colleague, on what entries do MLOG$ have, the following was agreed to :- 1. "I" for insert 2. "D" for delete 3. "D" + "I" for update. Along with the above entries, you might notice "U" also. The "U" entry is for update. But then, on what condition do we … Continue reading “U” entries in MLOG$

Enabling Flashback – Be Cautious

Enabling flashback on database can take minutes and cause multiple database wait events degrading database performance. On a quite busy system, during the low peak hours, I tried to enable flashback on version database and multiple sessions waited on 1. buffer exterminate 2. enq: SQ - contention 3. latch: cbc contention 4. SGA: … Continue reading Enabling Flashback – Be Cautious

EM Express Login – Get Flash

I have 12c setup on OEL 6.7 on  OVM and while trying to access EM express, I was receiving the error Just for the notes, a user can log into EM Express using URL https://<hostname&gt;:<port>/em and port details can be found using lsnrctl status | grep HTTP or select dbms_xdb_config.getHttpsPort() from dual; Clicking on the … Continue reading EM Express Login – Get Flash

Fixed Table x$ktfbue has not statistics

While playing around db, I ran my usual script to check tablespace usage details and it took ~59 secs (Elapsed: 00:00:59.02), which was high. Ran the sql using "gather_plan_statistics" hint and below lines in the execution plan were of interest - | 34 | HASH GROUP BY | | 1 | 6 | 3 … Continue reading Fixed Table x$ktfbue has not statistics

Oracle ASMLib

This blog post is more of a note for myself on configuring ASMLib. ASMLib is an optional utility that can be used on Linux systems to manage Oracle ASM devices. ASMLib consists of the following components: An open source (GPL) kernel module package: kmod-oracleasm An open source (GPL) utilities package: oracleasm-support A closed source (proprietary) … Continue reading Oracle ASMLib

Tuned-adm and Oracle

"Tuned" in RHEL7/OEL7 is tuning daemon for automatically tuning the system via the use of tuning profile. It can also be configured to react to changes to improve performance of the server and also to make system settings persistent. "tuned-adm" is a command line tool that provides a number of different profiles to improve performance. … Continue reading Tuned-adm and Oracle

12cR1 RAC Installation on OEL7

To build Oracle Clusterware Database at Home, I believe , RAC ATTACK is the best place to learn. Its is a free curriculum and platform for hands-on learning labs related to Oracle RAC. While reviewing the article, I thought to perform 12cR1 RAC installation on OEL 7.2. Attached is the document :- 12c_RAC_on_OEL7 The attached article is … Continue reading 12cR1 RAC Installation on OEL7