DBA to DA: Architecture

Showing posts with label Architecture. Show all posts

Monday, January 28, 2019

Linux: OSWatcher

Reporting Vineet Sachdeva January 28, 2019

OSWatcher is one of the best utilities provided by Oracle (Free of cost) and runs on almost all Operating Systems (Unix based only)

To Install OSW

Step 1. Download OSWatcher (Doc ID 301137.1)

Step 2. Untar
# Change version as per latest available.

$ tar -xf /tmp/oswbb812.tar

Step 3. Start OSW

$ cd /root/osw/oswbb
$ ./startOSWbb.sh 60 10 gzip

Step 4. Stop OSW
$ cd /root/osw/oswbb
$ ./stopOSWbb.sh

Other Details
1. CMD OPTIONS

First variable is the interval in seconds between 2 samples
Second Variable is total hours for which data is kept
Third Variable is the utility to zip to compress the files generated (acceps zip,gzip, None)
Fourth Variable is the path (optional) where to put the filess, when left blank it is the archive directory where the files are generated and kept.
Fourth variable cannot be provided without 3rd

I personally recommend 60 seconds interval with 30 days of data kept on the system for you to analyze.

2. Scheduling
To Schedule you can just schedule (cron) the OSWatcher to run every 10 minutes or so.
The key thing is OSWatcher does not starts if an instance of it is running. This makes it by default highly available, or if you want to be advanced you can create it as a service with help of sysadmin team or yourself.

Latest Downloads and Other OSWatcher related information available at -

OSWatcher (Includes: [Video]) (Doc ID 301137.1)

Friday, July 20, 2018

Oracle Database : Standard Edition vs Standard Edition one (SE vs SE1)

RAC Vineet Sachdeva July 20, 2018

We had an environment where Standard Edition one was required and engineers installed by mistake Standard Edition.

This caused us to stress due to licensing issue from Oracle.

However, to be free you should know that Standard Edition and Standard Edition One are the same install (as given by Oracle), it's just 2 different options given to you during installation, though the installation is same.

These 2 just differ in only feature (and licensing), you can have SE running on RAC however, SE1 is not supported for RAC.
If you do, then you pay :)

As per the Oracle document -

How to Install "Standard Edition One" (Doc ID 352618.1)

which confirms for Oracle Database - Standard Edition - Version 10.1.0.5 and later -

“Standard Edition One is a licensing edition. It is same as Standard Edition for a machine that has 1 or 2 processor sockets. No packaging differences. It was called Standard Edition One as it was originally Standard Edition for a 1 processor socket machine but with the release of 10g, we expanded it to a 1 or 2 processor socket machine.

So basically, if you install the Standard Edition, you will have the correct software.

The only difference between "Standard Edition One" and "Standard Edition" is that Standard Edition One must NOT be used on RAC, since there will be a licensing issue. It means that to install Standard Edition One, you have to install Standard Edition software and it can NOT / must NOT be used in a clustered environment (RAC).”