Krasimir Kovachki

Oracle Cloud with WebLogic and ATP database - Configure ssh connection with Putty on Windows and MAC

posted on 18 Jan 2020 by kkovachki in Blog Welcome, Oracle, Oracle Cloud

Now is time to add our ssh key into the pageant, you can download from the following link - https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html Open pageant and load private key [image:293] More »

Oracle Cloud with WebLogic and ATP database - Create instance (Linux VM)

posted on 18 Jan 2020 by kkovachki in Blog Welcome, Oracle, Oracle Cloud

Oracle Cloud with WebLogic and ATP database - Create instance (Linux VM) Click on Create Instance - this will give you possibilities to create new VM server  [image:285] More »

Oracle Database Migration from non-cdb to pdb - components issue

posted on 12 Aug 2019 by kkovachki in Blog Welcome, Oracle, Oracle 12c

Oracle Database Migration from non-cdb to pdb - components issue We deside to create new CDB conteiner instance with version 12.2.0.1 in order to plug into non-cdb database which is converted to pdb. Task i very simple, we have to create new pluggabe… More »

Oracle SqlDeveloper java.lang.OutOfMemoryError: Java heap space - fix

posted on 14 Sep 2018 by kkovachki in Blog Welcome

If you are trying to load the script in Oracle Sql Developer near to 100MB you may need to change the memory parameter in the configuration file sqldeveloper.conf - location sqldeveloper\bin Error: [image:241] Fix Add on file  sqldeveloper.conf… More »

DataPump - Export - Import - 12.1 - ORA-31623: a job is not attached to this session via the specified handle

posted on 23 Aug 2018 by kkovachki in Blog Welcome

Exporting..... takes time in some case :) Error: Shell UDE-31623: operation generated ORACLE error 31623… More »

Oracle 12c - DG - ORA-16598: Oracle Data Guard broker detected a mismatch in configuration

posted on 21 Aug 2018 by kkovachki in Blog Welcome, Oracle RAC, Oracle 12c

Preliminary information: AIX OS Oracle 12.2 GI infrastructure Oracle 12.1 Database as Primary with two instances as RAC AIX OS Oracle 12.1 Database as Physical Standby database with a single instance on Oracle Restart - ASM This is what customer… More »

Oracle 12c 18c Oracle Grid Infrastructure ONS setup and debug from local and remote side

posted on 14 Aug 2018 by kkovachki in Blog Welcome, Oracle RAC, Oracle 12c, Oracle 18c

Purpose of this post is to share how you can debug ONS  - FAN events notification if you need to setup Weblogic / Data Source to be aware of the ONS  FAN events ONS is a very useful option if you are using Oracle RAC architecture but the prior actual… More »

Oracle Grid Infrastructure 18c installation and patching on Linux - step by step

posted on 24 Jul 2018 by kkovachki in Blog Welcome, Oracle 18c

This post have been added prior 18.3 official notes which means that we am going to patch initial verion of 18.0.0.0 with patch in order to be 18.3 version We will use software which dosent exist in edelivery anymore but there are new version :) Oracle… More »

ORA-39142: incompatible version number 4.2 in dump file - Bug 21480031

posted on 17 Jul 2018 by kkovachki in Blog Welcome

This morning start with the bug, unfortunately :( I have to export one schema from one place and import to other place but when i try to import schema i face the below error Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit… More »

ORA-00600 [qcisSetPlsqlCtx:tzi init] - out of place patching - Golden Home

posted on 08 Feb 2018 by kkovachki in Blog Welcome

'Golden Home" methodology: Golden Home is a very simple process for Oracle Software consolidation and maintenance process ( patching, upgrades etc.)  this is suitable for environment with a lot of databases by using pre-defined  home ( cloned oracle… More »

Patch 25755742: DATABASE PATCH SET UPDATE 12.1.0.2.170718

posted on 18 Dec 2017 by kkovachki in Blog Welcome

Patch 25755742: DATABASE PATCH SET UPDATE 12.1.0.2.170718 Today there was an interesting situation with Oracle PSU patching Here you will discover that Oracle opatchauto perform patching on the running database without any issue and database remain… More »

ORA-30012: undo tablespace 'UNDOTBS01' does not exist or of wrong type - Common mistake during oracle database duplicate process

posted on 24 Nov 2017 by kkovachki in Blog Welcome, Oracle 11g

ORA-30012: undo tablespace 'UNDOTBS01' does not exist or of wrong type - Common mistake during oracle database duplicate process Common mistake during oracle duplicate process: spfile configuration related to UNDO is not the same between source and… More »

Converting manually an administrator-managed Oracle RAC One Node to administrator-managed Oracle RAC with instance name renaming

posted on 28 Jun 2017 by kkovachki in Blog Welcome

The main goal of all this is to share the steps to Convert Oracle RAC One Node to Oracle RAC with instance name changes. What I mean by adding description instance name changes: Oracle RAC One Node instance names convention are setup automatically with… More »

How to Relocate Oracle RAC instance ( Full RAC with two active instances )

posted on 15 Jun 2017 by kkovachki in Blog Welcome

How to Relocate Oracle RAC instance ( Full RAC with two active instances ) Enviroment information: Oracle Grid Infrastructure 12c - 12.1.0.2.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 Oracle Grid Infrastructure with three nodes More »

Oracle DB - package DBMS_RANDOM is not random all the time :)

posted on 12 Jun 2017 by kkovachki in Blog Welcome

Hello  :) We as DBA all the time thinking how to avoid doing the same task twice by implementing different kind of improvement like automation scripts. Case from today is following... For internal purposes there are requirements to implement process for… More »

Oracle Database 12c Release 2 Enterprise Edition - Software installation ( Oracle Home ) and CDB with PDB Creation in silent mode

posted on 07 Jun 2017 by kkovachki in Blog Welcome

During the BGOUG event I have discovered a lot of new features which should be tested and validated and this make me drive to install new version of Oracle 12cR2  :) You can simple download - Oracle Database 12c Release 2 Enterprise Edition  and Oracle… More »

Where is Oracle Database PSU 11.2.0.4.170117 (CPUJan2017)

posted on 16 May 2017 by kkovachki in Blog Welcome

In the past days some of my colleagues just ask me... "Do you know where i can find Jan PSU for 11.2.0.4 database" ??? [image:154] Hmm... Good question it should be in the Metalink.. BUT Oracle set "there's no database/GI PSU for this cycle", check the… More »

Oracle 12c - ASM - Error - ORA-00020: maximum number of processes (500) exceeded -TIP - Memory Calculation

posted on 13 Mar 2017 by kkovachki in Blog Welcome, Oracle RAC, Oracle 11g, Oracle 12c

After a lot of work today, i try to get some time to share very short finding which is very useful in order to prevent the max process on ASM instance. There was an issue with one of the newly created Oracle GI 12c - 12.1.0.2 due to massive migration… More »

Rapid Upgrade 11.2.0.4 Standard Edition to 12.2.0.1 Standard Edition

posted on 13 Mar 2017 by kkovachki in Blog Welcome, Oracle 12c

Rapid Upgrade 11.2.0.4 Standard Edition to 12.2.0.1 Standard Edition More »

How to download Oracle 12c Standard Edition - 12.1.0.2 and 12.2.0.1

posted on 07 Mar 2017 by kkovachki in Blog Welcome, Oracle 12c

I am going to present a way how-to dowload Oracle Database 12c Standard Edition - 12.1.0.2 Maybe there is a question .. why i need to add such post? Normally it's should be simple, Go to Oracle Website and download or from Oracle Metalink Support....yes… More »

Rapid Upgrade 11.2.0.3 or 11.2.0.4 to 12.2.0.1 - Step One

posted on 06 Mar 2017 by kkovachki in Blog Welcome, Oracle 11g, Oracle 12c

Today, I am going to show you how to upgrade 11.2.0.4 to 12.2.0.1 in rapid way ( you can apply the same process with 11.2.0.3 )  Maybe as start point you have to check following post where you can find all new features of the release and what is… More »

Oracle Database 12c Release 2 (12.2) - just arrived in the official Oracle site

posted on 02 Mar 2017 by kkovachki in Blog Welcome, Oracle 12c

  Yoooo, today is great day to start testing on a upgrade from low version and all new features. I will try to give you more and more on the features testing and how to implement it More »

How to apply OCW patch on database home - 21352649 - OCW Patch Set Update : 11.2.0.4.8 (21352649)

posted on 22 Feb 2017 by kkovachki in Blog Welcome

This morning one of my colleagues "Birata" just ask me "How to apply OCW  patch on database home"? Prerequisites: Download new Opatch version and update oracle home on destination home for patching Patch # 6880880 - Select a Release: 11.2 -… More »

DRAFT - Oracle GI 12c - Apply - Patch 24412235: GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.161018 (OCT2016)

posted on 09 Feb 2017 by kkovachki in Blog Welcome

------- DRAFT I am very happy to share my patching process on the testing system, as preparation for production patching. I have the following architecture: Two node Oracle RAC Cluster 12c without any PSU - just 12.1.0.2.0 :) ----- full details will be… More »

Bulgarian Oracle Users are forbidden for free credits!

posted on 08 Feb 2017 by kkovachki in Blog Welcome

[image:79] Bulgarian Oracle Users are forbidden for free credits! Very reasonable question, Why? what is the reason for such message ? BGOUG is very useful group but without having free credits to test Oracle cloud how we can be up-to-date and able to… More »