Subscribe to Posts by Email

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

AWS RDS : Oracle RDS Auditing (XML) Script

Hello,

We want to report general audit report daily from our databases who have made manual modifications to the database so it may be helpful for us to retrospect when needed.

How this report looks like, find useful?

User Schema Name Object INSERTS DELETES UPDATES ALTER GRANTS DROPS TRUNCATE ————– ——————– ———————– ——- ——- ——- […]

APACOUC Webinar – My Next Presentation – Building a Datalake

Hello All,

My Next Presentation in APACOUC Webinar Tour – Building a Datalake – registration link is now open.If any one interested, please register at below link.

August 18, 2017 – 19:00 AEST (3PM IST) – Suresh Gandhi presenting: Building a DataLake – More info or register Here

Other webinar registrations are also open http://www.apacouc.org/2017-webinar-tour.html

[…]

AWS EBS Snapshot Cleanup Script

Hello,

Today it’s another script, we have got piles of EBS snapshots (around 50,000) over period of 2 years.To give a bit background the EBS volume snapshots will be taken every 4 hours along with our rds snapshots to maintain the recover-ability for some of the lob objects. So each volume having 6 per day […]

AWS RDS: Stop & Start Script

Hello,

Well, many of you may already have this, but most of you have deployed this kind of script with lambda with a list of instances as input.

However, in my case the instances changes at least weekly as we build and terminate every two weeks and instances list is not constant, so with instances […]

ANZ Webinar Tour 2017 – Presentation Replay – DevOps for Databases

Hello All,

My latest presentation replay for DevOps for Databases is here.

And please watch out for My upcoming presentation:

August 18, 2017 – 19:00 AEST – Suresh Gandhi presenting: Building a DataLake , more information at http://www.apacouc.org/2017-webinar-tour.html

More replay’s at Youtube channel :

https://www.youtube.com/channel/UCRy6L_T302epD9YlXJT_udg

-Thanks

Suresh

ORA-28040: No matching authentication protocol Database driver error

Hi

Hope you might have already gone through below, just in case if not. All of our developer tools/ETL tools datastage/Informatica etc. are failing with ora-28040 once we upgraded to oracle 12c.

This is due to, As per Oracle, In Oracle 12.1 the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. This […]

ANZ Free Webinar Tour – Second Wave registrations

Hello All,

The Second wave of APACOUC – IAOUG ANZ Webinars registrations open now and you have more exciting presentations to come.

And I am presenting topic Devops for Databases which details about Devops Principles to databases, why they are hard to implement, creating your own framework, strategy, approach, tools that needed for each approach […]

Oracle Sharding – Updated Presentation & Webinar Recording

Hello All,

Thanks for joining and attached the updated presentation and webinar recording link.

Note: Please skip the first 10 Mins as the presentation is not shared properly. :).

Find other Recorded Webinars at https://www.youtube.com/channel/UCRy6L_T302epD9YlXJT_udg

Updated Presentation: Click Here

 

ANZ Webinar Tour – 2017 – Registrations Open

Hello All,

IAOUG and APACOUC proudly announces ANZ Webinar Tour – 2017.

The 2017 Webinar Tour will be running from July 3rd until August 25th with the participation of over 20 International Speakers that will be presenting over 50 interesting presentations, making it the largest webinar series ever made in the Oracle world!

Registration Links […]

Oracle Sharding : Part 2 – Installating & Configuring Shards

In Previous post of the series, I have written about an overview of Oracle Sharding and its features.

In this post, you will be seeing how to configure oracle shard and what steps are need to be performed.

Over all, I felt its very easy to setup and configurewhen compare to RAC setup. All you […]