ORA-00093: pga_aggregate_limit must be between 2048M and 100000G

Error:

SQL>  startup pfile=initmylab1.ora

ORA-00093: pga_aggregate_limit must be between 2048M and 100000G

ORA-01078: failure in processing system parameters

Above error occurs while setting PGA_AGGREGATE_LIMIT to value less than 2GB in oracle 12c onwards version database instances ..

Step by step guide to install Oracle 19c ASM DB on Linux Virtual Machine : Easy 5 steps

Follow the 5 steps to setup oracle 19c grid infrastructure & database on ASM hosted on oracle Linux x86-64 platform 

Step 1 -->  Create & install Oracle Linux Virtual machine
Step 2 --> Additional setting on network , OS & installing dependent packages

Step 3 --> Download Oracle Software's , Install ASM libraries & Configure ASM disk

Step 4 --> Installing & configuring grid infrastructure 19c 

Step 5 --> Installing & configuring oracle 19c container database 

Lets begin ...

ORA-39001: invalid argument value ORA-39142: incompatible version number 5.1 in dump file

ORA- Error:

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-39142: incompatible version number 5.1 in dump file " "

While importing a oracle dump file on 12c (12.1)  exported by 19c (19.0) in Linux using data pump  

How to cure migraine headache completely ;100% solution based on personal experience 8 simple remedies

Sharing my personal experience how did I managed to cure migraine headache episodes which used to strike every 14 days and now almost none.

For last 2 years my migraine headache intensity has increased a lot may be due to corona lockdown , working from home , Bad habbits of seating for long hours. which had adverse effect on life style and one of the most contributing factor to migraine strokes.

After reading through many articles , watching videos of many world class neurologists , yoga gurus and in fact getting consulted from doctors have prepared this article to get rid of migraine.

I will not waste more words here explaining what causes migraine and how to avoid it as I have already written here ... how to recover from migraine

"All we want is to improve blood circulation to brain "

Installing docker container on windows 10 for Linux virtual machine

Lets install docker on windows 10 x64 machine to launch Linux ubuntu image as a container service.

During installation i have came across multiple issues specially in second phase which you may or may not encounter.

Follow the steps and read through support article link in case steps doesn't match in your setup   

Step 1 : Pre-requisites for Docker Installation 

ORA-00313 open failed for members of log group of thread

Error:  

ORA-00313 open failed for members of log group of thread

Recovery is unrecoverable because 1 other slaves require space

20 Pre Upgrade Checklist for Migrating Oracle Database to New version

Taking appropriate steps prior to major oracle database upgrades helps to prevent any warning , slowness during or after migration to new oracle database version ..

Following 20 steps will cover most of the pre-upgrade checklist that can be followed for smooth upgrades ..

 

1. System/Sysaux/Undo tablespace adequate free space avoids errors during migration script execution , at least 1-2 GB free space to be maintained.