September, 2019

• 6 September

  What Is In-Memory?

  

  Hi everyone, Today i try to explain Oracle Database 12c In-Memory. In-Memory is a very important subject for Database and DWH. Oracle DB to store data in row format at …

  Read More »

August, 2019

• 16 August

  OCI Error !! – [Errno 12] Timeout on https://www.ksplice.com/yum/uptrack/ol/7Server/x86_64/repodata/repomd.xml:

  

  Hi friends, i want to explain OCI (Oracle Cloud Infrastructure yum problem and solution method. If you currently using Oracle Cloud, you should know basic Cloud Architecture. Oracle takes most …

  Read More »
• 15 August

  [FATAL] [INS-10101] The given response file response/grid_install.rsp is not found.

  

  Hi friends, We may need to install Oralce database or grid without using an GUI. To do this, we need to edit the rsp file and start the installation from …

  Read More »
• 9 August

  Oracle Cloud Add Disk To Virtual Machine

  

  Hi, we will see how to add disk to the machine we created in Oracle Cloud. The best advantage to using Cloud, when you need to new one no physical …

  Read More »
• 7 August

  Oracle Cloud Create Virtual Machine And Connect

  

  Hi everyone, in this tutorial i will show you how to create Virtual Machine on Oracle Cloud. Oracle Linux 8 Installation   Oracle organizes many events to promote cloud products …

  Read More »
• 7 August

  Python connect Oracle Database

  

  Hi everyone, today i will show you how to connect Oracle database using python. Python is very popular and easy to learn programing language. We may need to connect to …

  Read More »
• 7 August

  RMAN-00554: initialization of internal recovery manager package failed and RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied

  

  Hi friends,   Today i want to show you some possible error while installing Data Guard. In Data Guard installation we need to connect auxilary database(standby) from Primary. connect auxiliary …

  Read More »
• 1 August

  ORA-12547: TNS:lost contact Error

  

  When I connect to Oracle database, I got ” ORA-12547: TNS:lost contact ” error.

  Read More »

July, 2019

• 4 July

  ORA-12631: Username retrieval failed on Windows login with sqlplus

  

  Hi, You can get ” ORA-12631: Username retrieval failed ” error when login Oracle database.  

  Read More »

June, 2019

• 28 June

  ORA-00020: maximum number of processes exceeded and alter system set processes

  

  Sometimes you may get ” ORA-00020: maximum number of processes exceeded ” error while login oracle database via sqlplus and Application may encounter TNS errors.

  Read More »
• 26 June

  How to Install Enterprise Manager Cloud Control 13c ( EM 13c ) Agents on Microsoft Windows Target Hosts

  

  I will explain How to Install Enterprise Manager Cloud Control 13c ( EM 13c ) Agents on Microsoft Windows Target Hosts in this article. Let’s review the Install EM Cloud …

  Read More »
• 25 June

  ORA-01180: can not create datafile 1 ORA-01110 RMAN-03002 Error Solution During RMAN Restore Operation

  

  Hi, When I try to create Test database from Production via RMAN Restore, I got ” ORA-01180: can not create datafile 1 ORA-01110 RMAN-03002 ” errors.

  Read More »
• 21 June

  What is the Database Auditing in Oracle

  

  I will explain What is the Oracle Database Auditing in this article.  

  Read More »
• 18 June

  Oracle SQL Tutorials – Chapter 3 (Part 3 of 3)

  CONVERSION FUNCTIONS TO_CHAR (DATE) TO_CHAR(date, ‘format’) It’s case-sensitive and must be written between quotes. It must contain a valid date format. Let’s list the hire dates of employees like below. …

  Read More »
• 18 June

  Oracle SQL Tutorials – Chapter 3 (Part 2 of 3)

  NUMERIC FUNCTIONS ROUND Let’s try some different usages of the ROUND function. SELECT ROUND (45.923), ROUND (45.943, 1), ROUND (45.924, 2), ROUND (44.923, -1), ROUND (55.923, -2) FROM DUAL;   …

  Read More »
• 18 June

  Oracle SQL Tutorials – Chapter 3 (Part 1 of 3)

  Chapter 3 – Single Row Functions Charcter Functions Numeric Functions Date Functions Converting Functions NVL Function Decode Function CASE Statement   SQL FUNCTIONS SQL Functions can be classiifed under 2 …

  Read More »

May, 2019

• 29 May

  Online Table Redefinition and Partitioning using DBMS_REDEFINITION in Oracle

  

  Hi, I will explain Online Table Partitioning using the DBMS_REDEFINITION in Oracle database in this article.

  Read More »
• 29 May

  Partitioning Types ( Range , List, Hash, Interval .. ) in Oracle Database

  

  Hi, I will explain Partitioning Types in Oracle Database in this article.

  Read More »
• 29 May

  Partitioning in Oracle Database

  

  Hi, I will explain you a beautiful technology such as Partitioning that exists in almost all Database management systems In this article.

  Read More »
• 28 May

  ORA-38760: This database instance failed to turn on flashback database and Drop Restore Point

  

  When you startup Oracle Database, you can get ” ORA-38760: This database instance failed to turn on flashback database ” error.

  Read More »
• 23 May

  Oracle ORAchk | Database Health Check with Orachk

  

  I will explain how to perform Database Health Check with Oracle ORAchk in this article. Let’s review the ORAchk – Database Health Check  

  Read More »
• 23 May

  How to Move Audit Trail tables to New Tablespaces in Oracle

  

  Hi, I will explain how to move audit tables ( SYS.aud$ and SYS.fga_log$ ) to new tablespaces in Oracle  

  Read More »
• 22 May

  How to Read or Analyze an AWR ( Automatic Workload Repository ) Report in Oracle -2

  

  Hi, I will continue to explain How to Analyze or Interpret an AWR report in Oracle in this article.

  Read More »
• 17 May

  Oracle Enterprise Manager Cloud Control Architecture and Step by Step Installation Oracle Enterprise Manager ( OEM )

  

  Hi, I will explain Oracle Enterprise Manager Cloud Control architecture and installation in this article.

  Read More »
• 17 May

  How to Find OMS Home and Start and Stop Enterprise Manager Cloud Control 13c

  

  I will explain How to Find OMS Home and Start and Stop Enterprise Manager Cloud Control 13c in this post.  

  Read More »