Thursday 20 May 2021

Install Error [DBT-50000] Unable to check for available memory 19c

 

  • Install Error [DBT-50000] Unable to check for available memory

We recently got error while installing database on 16GB physical RAM machine.  we can also install using response file to avoid this error or use below command on command prompt.

dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false


  • Open comand prompt with adminstrator option 

cd D:\WINDOWS.X64_193000_db_home\bin

D:\WINDOWS.X64_193000_db_home\bin>

dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false




Monday 17 May 2021

Oracle Cloud Infrastructure examples

 Oracle Cloud Infrastructure examples


OCI - Configuring connection to the instance from Putty session

OCI - Connection from AppTier ( Public Subnet ) to DBTier (Private Subnet)

OCI - Create Instance and connect on linux machine

OCI - Create Virtual Cloud Network

OCI - Expdp utilities dumpfile to bucket object storage directly

OCI - Rotating Wallets for autonomous database

OCI - Clone Autonomous database

OCI- Patch - Applying patch for upgrading database time zone from 32 to 35

OCI - Delete files from directory in autonomous database

OCI - Moving Data from Autonomous Databases to on Premises database using impdp

OCI - Load CSV object data on OCI autonomous database

OCI- Moving data to Autonomous database using expdp -impdp

OCI- Cloud Sql developer connection

OCI -Shell command

OCI - Create Schema using Web sql developer

OCi - Instance wallet download

OCI - Sql developer connection using instance wallet 19c

OCI - Autonomous connection 19c database using 12c oracle client and database

OCI : Create DIRECTORIES for expdp impdp on autonomous database

OCI - Create object storage buckets



PT - IOSTAT MPSTAT Performance Monitoring commands

PT -  IOSTAT  MPSTAT  Performance Monitoring commands 

iostat 


  • iostat cpu  performance output at every 2 seconds
iostat -c 2 



  • iostat  overlall  performance output at every 2 seconds
iostat 2 




  • MPSTAT performance output  at every 2 second 
mpstat 


mpstat 2 


iostat -ykx sda -d 2

-d displays the statistics every 2 seconds
-k displays the statistics in kilobytes
sda is the partition that we are interested in displaying its statistics
-y to omit first report with statistics since the system boot
-x to display more information