June, 2019

• 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 »
• 17 May

  ORA-19802 ORA-16019 ORA-02097: parameter cannot be modified because specified value is invalid

  

  Hi, You can get ” ORA-02097: parameter cannot be modified because specified value is invalid ” error, when you set  db_recovery_file_dest parameter.

  Read More »
• 15 May

  ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

  

  Hi, You can get ” ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage” error when you take backup of Oracle database.

  Read More »
• 10 May

  Gather Database Stats , Schema Stats & Dictionary and Fixed Object Statistics via DBMS_STATS in Oracle

  

  I will explain how to Gather Database Stats , Schema Stats & Dictionary and Fixed Object Statistics via DBMS_STATS in Oracle Database in this article. Let’s go to review how …

  Read More »
• 10 May

  ORA-00392: log 5 of thread 1 is being cleared, operation not allowed ORA-00312

  

  Hi, When you open database with resetlogs option, you can get ” ORA-00392: log 5 of thread 1 is being cleared, operation not allowed” error.

  Read More »
• 8 May

  Introduction Oracle Machine Learning

  

  1.. Login to Oracle Machine Learning The Oracle Machine Learning home page is the default landing page when you log into Oracle Machine Learning. The home page provides you quick …

  Read More »
• 6 May

  How to Change Expired Oracle User Profile Password Lifetime to the Unlimited to Solve ORA-28002 error

  

  Hi, Sometimes you can get ” ORA-28002 The Password Will Expire in 7 Days Errors ” error when you log in database with application user.

  Read More »

April, 2019

• 25 April

  Error in invoking target ‘mkldflags ntcontab.o nnfgt.o’ of makefile

  Merhaba, bu yazımda Solaris(x86 64) üzerinde Grid & Database kurarken aldığım hatadan bahsetmek istedim. Hatayı grid kurulumunda aldım ancak görmezden gelmem beni database kurulumunda da sıkıntıya sokabileceğinden hemen çözmek istedim. …

  Read More »
• 24 April

  ORA-01591: lock held by in-doubt distributed transaction

  

  Hi, During table update or delete in the transaction, you can get ” ORA-01591: lock held by in-doubt distributed transaction ” error.

  Read More »
• 16 April

  Instance terminated by PMON in Oracle

  

  Hi, You can get error in Oracle that instance is terminated by PMON.

  Read More »
• 13 April

  Database Link ( Dblink ) in Oracle Database

  

  Hi, I will explain Database link or Network link in Oracle database in this article.    

  Read More »