“You have to give a little… scripting for 12c+”

Karin Kriebisch 2
0 0
Read Time:2 Minute, 15 Second

or

Publishing a cleanup script for Oracle 12c+

At the moment I’m just for fun collecting Linux scripts from my direct colleagues. And while I was busy to think up a wiki page for internal use, for a moment I felt like Uncle Scrooge, gathering riches from other minds. Which, honestly, did not feel very pleasant. But then I remembered that I was actually giving them back, all the little scripts and snippets I will collect, hopefully enriched with comments, corrections and other improvements. But one script in particular I always wanted to give back to where I lent it from, the Incredible Depth and Bounty of the WorldWideWeb. The script I’m talking about is quite known in Oracle Land. It is called cleanhouse.sh and it is one of the best known cleaning scripts for Oracle database environments. It was used widely – I guess – up to Oracle 11g. Then Oracle choose to change some default path’s and locations of deeply ingrained parameters as the background dump dest…. and cleanhouse.sh became partly useless or ineffective.

Looking for a new cleanhouse script for 12c+

So, in 2019 I searched the internet again, but lo and behold, no 12c-version of this cleaning script in sight … No-one seems to have invested some time in adapting this script after years of using Oracle 12c? So I did my own adaptations for 12c-environs (incl. RAC) and other colleagues corrected my little scripting errors and now I think its time to give it back to the world. May it inspire others to do the same.

I know, this seems to be too little too late since Oracle 19c is already in full swing. I hope you can appreciate that I’m doing it anyhow and rather late than never. Until shortly, I would never even have considered doing it altogether. I thought that my contribution would be only inferior or just stating the obvious. In the meantime I learned that some people actually like my “Sort of Summary plus X”-approach. And I learn by scripting this way or writing blogs as well.

And here it is, my humble, little payback to the Oracle community: cleanhouse12c.zip.

I hope that someone still finds it useful and eventually drops me a line how (s)he adapted it. And any ideas for further improvement are never lost with me… So, thank you in advance and thank you from the bottom of my hart, to all the awe inspiring people like Shad Rich, Arup Nanda, Jonathan Lewis or the Carlos Sierra‘s of the world, for their wonderful, creative, rich, concise and freely given scripts I’m just trying to emulate! I envy you for that …

About Post Author

Karin Kriebisch

Karin is an experienced, broadly orientated Oracle consultant (senior DBA consultant (OCP)) and is specializing in Oracle Database Security (Oracle Implementation Specialist Security 11g). Karin uses to work in divers enterprise environments like pension fonds, banks or pharmaceuticals, where ITIL and Service Management software products (e.g. Assyst, Remedy, Jira, GLPI) play a big role. She is regularly working for custumers in development projects and migrations, so her experience lead her to pay special attention in the areas of maintenance and (database)infrastructure. Her knowledge embraces multiple operating systems like OpenVMS, Linux, HP-UX and of course Windows, and she is comfortable with Oracle Database versions starting with Oracle 7 up to 12c and virtualization environments like vmWare and Oracle Virtualbox. Add to this her ability of scripting (for Windows commandline and Powershell, *nix shells) and her knowlegde of Oracle applicatieservers (incl. WebLogic) to her portfolio and it makes her a technical allround Oracle specialist. Karin is very customer and service orientated and always strives to reach her goals. She has a very sharp analytical mind and a keen eye for the details in the big picture. Karin is a senior DBA at AMIS b.v. for more than 15 years and she still likes the changing environments she is able to work in and meeting new and interesting people all the time.
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

2 thoughts on ““You have to give a little… scripting for 12c+”

  1. Hi Karen,

    I use: purgeLogs: Cleanup traces, logs in one command (Doc ID 2081655.1)

    Kind regards,
    Ronnie Kalisingh

    1. Hi Ronnie,
      Thank you for this wonderful alternative! And for dropping me a line about it. I just adapted our comfy bash script because we had to and I have to admit I can handle bash more easily then perl. But I see the advantages in your alternative with versions above 12.2 Thank you for your tip!
      Best regards,
      Karin

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Next Post

AWS Config automated remediation

Introduction It is possible in AWS to check if your environment is compliant to your minimum standards. It is also possible to automatically change the environment to make it compliant again. Maybe not in a way that was designed by the developer – but compliant anyhow. Let me give an […]
%d bloggers like this: