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
Happy New Year 2017
Wishing everyone a very happy and prosperous 2017. May all your dreams come true and ..... Work Hard, Stay Positive !! Cheers !!
“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 18.104.22.168 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 22.214.171.124.6 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>:<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 126.96.36.199 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
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
Happy New Year 2016!
Hello Everyone!! I would like to take this opportunity to thank you all for visiting my blog and to wish you and your family a Happy New Year 2016!!! Cheers!!!