Hi, I will share with you Step by Step Oracle SQL Tutorials For Beginners.
Read More »Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
Oracle Tutorial | Advanced Oracle Database Tutorials for Senior Oracle DBA
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
Flashback Database, Table, Query Tutorials For Beginners in the Oracle Database
RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA
Oracle EBS 12.2.9 Enable SSL with Self-Signed Certificate and Disable HTTP
Author : Cihan Gedik Email : [email protected] Linkedin : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group : …
Read More »Oracle Application Database Administrator ( APPS DBA ) Training
GC overhead limit exceeded error Weblogic java.lang.OutOfMemoryError
Bulk and Individual Password Reset For Oracle E-Business ( EBS ) Users
Oracle Database 19c Certified With EBS 12.2
Oracle E-Business ( EBS ) Workflow Troubleshoot SQL and Commands
Oracle EBS ( E-Business Suite ) Tutorials for Junior Oracle Apps DBA
EBS 12.1 Function not available to this responsibility
EBS 12.1.3 apachectl startssl libdb.so.2: cannot open shared object file: No such file or directory
REP-0004: Warning: Unable to open user preference file in Oracle EBS 12.2
Exadata X8M-2 Image Upgrade Operation Step By Step For Image Version 20.1.9 With Best Practices
Exadata X8M-2 Image Upgrade Operation Step By Step For Image Version 20.1.9 With Best …
Read More »Exadata X8M-2 Multi-Rack Introduction
How to Clear ILOM FMA Faults And Reset The SP on Exadata or Other Servers
How to Shutdown and Startup Exadata and Oracle Databases
Exadata Temp Tablespace Migration To Flash Disk
Oracle EBS 12.2.9 Enable SSL with Self-Signed Certificate and Disable HTTP
Author : Cihan Gedik Email : [email protected] Linkedin : https://www.linkedin.com/in/cihan-gedik-13b55065/ Group : …
Read More »Oracle Application Database Administrator ( APPS DBA ) Training
GC overhead limit exceeded error Weblogic java.lang.OutOfMemoryError
Bulk and Individual Password Reset For Oracle E-Business ( EBS ) Users
Oracle Database 19c Certified With EBS 12.2
OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value
I got ” OGG-02039 Failed to set logmining server parameter MAX_SGA_SIZE to value ” error …
Read More »OGG-15121 Error obtaining the list of tables for: Does not match any catalog name
OGG-01433 Failed to validate table. The table is compressed and extract will not be able to extract data from Oracle logs
OGG-00041 Data source not specified.
OGG-00446 Checkpoint table GGSCHKPT does not exist
Execute Immediate in Oracle
I will explain Execute Immediate in Oracle in this post.
Read More »Oracle SQL Date Comparison
Alter table rename column in Oracle
Rename Table in Oracle
NEXTVAL and CURRVAL function in Oracle
UTL_FILE FOPEN in PL/SQL
I will explain UTL_FILE FOPEN in PL/SQL in this post.
Read More »DBMS_OUTPUT.PUT_LINE in PL/SQL
Alter Session Set NLS_DATE_FORMAT in Oracle with Examples
PL/SQL Conversion/Decoding/NULL-Related Functions
PL/SQL Datetime Functions
How to Manage An Oracle VM Server Hypervisor Using XM Commands
Hi, I will explain How to Manage An Oracle VM Server Hypervisor Using XM Commands …
Read More »Oracle VM Manager Step by Step Installation for Monitoring Oracle VM Server
Oracle VM Server ( OVS ) Architecture and Step by Step OVS Installation -2
Oracle VM Server ( OVS ) Architecture and Step by Step OVS Installation -1
Recent Posts
January, 2021
- 3 January
Python Flask Merhaba Dünya
Merhaba, bu yazıda Flask’a başlangıç yapacağız. IDE olarak ben PyCharm kullanıyorum, yeni bir proje oluştururken Flask kütüphanelerini hazır olarak ekliyor, pek zaman kaybetmemiş oluyoruz. Hatta bizim için ilk Hello Word …
Read More » - 3 January
MySQL Router HA with Keepalived | MySQL InnoDB Cluster
keepalive provides frameworks for both load balancing and high availability. The load balancing framework relies on the well-known and widely used Linux Virtual Server (IPVS) kernel module, which provides Layer …
Read More »
December, 2020
- 29 December
MySQL InnoDB Cluster with MySQL Shell MySQL Router using just Docker containers
Setting up MySQL InnoDB Cluster with MySQL Shell (plus MySQL Router) using just Docker containers. MySQL InnoDB cluster provides a complete high availability solution for MySQL. Each MySQL server instance …
Read More » - 29 December
ORA-19750: change tracking file | ORA-19751 ORA-17502 ORA-15046 ORA-17503 ORA-15012
I got ” ORA-19750: change tracking file | ORA-19751 ORA-17502 ORA-15046 ORA-17503 ORA-15012 ” error in Oracle database during Open resetlogs.
Read More » - 29 December
Error 1017 received logging on to the standby | ORA-16191
I got ” Error 1017 received logging on to the standby | ORA-16191 ” error in Production for Oracle Dataguard.
Read More » - 28 December
RMAN-12008: could not locate backup piece | RMAN-12009
I got “ RMAN-12008: could not locate backup piece | RMAN-12009 ” error in Oracle database during RMAN Restore datafile.
Read More » - 18 December
How to Distribute the RMAN Backups for Multiple Disks in Oracle
I will explain How to Distribute the RMAN Backups for Multiple Disks in Oracle in this post.
Read More » - 17 December
ORA-17503: ksfdopn Failed to open file | ORA-01565 ORA-17503 ORA-01034 ORA-27121
I got “ ORA-17503: ksfdopn Failed to open file | ORA-01565 ORA-17503 ORA-01034 ORA-27121 ” error in Oracle database during startup.
Read More » - 16 December
How to Create Drop ( Remove ) or Resize ACFS File System in Oracle
I will explain How to Create Drop ( Remove ) or Resize ACFS File System in Oracle in this post.
Read More » - 16 December
RMAN-06169: could not read file header | RMAN-06056: could not access datafile
I got ” RMAN-06169: could not read file header | RMAN-06056: could not access datafile ” error in Oracle database.
Read More » - 16 December
ORA-12906: cannot drop default temporary tablespace
I got ” ORA-12906: cannot drop default temporary tablespace ” error in Oracle database.
Read More » - 16 December
ORA-15001: diskgroup “DATA” does not exist or is not mounted | ORA-15018 ORA-15001 RMAN-06956
I got ” ORA-15001: diskgroup “DATA” does not exist or is not mounted | ORA-15018 ORA-15001 RMAN-06956 ” error in Oracle database.
Read More » - 16 December
dbms_lock.sleep Grant Execute Privilege in Oracle
I will explain dbms_lock.sleep Grant Execute Privilege in Oracle in this post.
Read More » - 16 December
MRP0: Background Media Recovery terminated with error 1274 | ORA-01274: cannot add data file
I got ” MRP0: Background Media Recovery terminated with error 1274 after adding a Datafile ” error in Oracle dataguard ( Standby Site ).
Read More » - 15 December
RMAN-06571: datafile 1 does not have recoverable copy
I got ” RMAN-06571: datafile 1 does not have recoverable copy ” error in Oracle database during restore database.
Read More » - 15 December
ORA-01167: two files are the same file | ORA-01503: CREATE CONTROLFILE failed
I got ” ORA-01167: two files are the same file | ORA-01503: CREATE CONTROLFILE failed ” error in Oracle database during controlfile creation.
Read More » - 15 December
ORA-01678: parameter db_file_name_convert must be pairs of pattern and replacement strings
I got ” ORA-01678: parameter db_file_name_convert must be pairs of pattern and replacement strings ” error in Oracle database.
Read More » - 15 December
ORA-07217: sltln: environment variable cannot be evaluated
I got ” ORA-07217: sltln: environment variable cannot be evaluated ” error in Oracle database during catalog files.
Read More » - 15 December
ORA-14060: data type or length of a table partitioning column may not be changed
I got ” ORA-14060: data type or length of a table partitioning column may not be changed ” error in Oracle database during startup 2 nodes Oracle RAC.
Read More » - 15 December
ORA-39046: Metadata remap REMAP_TABLESPACE has already been specified.
I got ” ORA-39046: Metadata remap REMAP_TABLESPACE has already been specified ” error in Oracle database during startup 2 nodes Oracle RAC.
Read More » - 13 December
ORA-01617: cannot mount: 2 is not a valid thread number
I got ” ORA-01617: cannot mount: 2 is not a valid thread number ” error in Oracle database during startup 2 nodes Oracle RAC.
Read More » - 12 December
Oracle 21c is Available and Oracle 21c New Features
I will explain Oracle 21c is Available and Oracle 21c New Features in this post. Let’s review the Oracle 21c New Features .
Read More »
November, 2020
- 30 November
DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error
I will explain the DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error in this post. let’s review the DDL_LOCK_TIMEOUT Parameter | ORA-00054: resource busy error.
Read More » - 30 November
ORA-12990: duplicate option specified
I got ” ORA-12990: duplicate option specified ” error in Oracle database during import ( impdp ).
Read More » - 30 November
ORA-14639: SUBPARTITIONS clause can be specfied only for Hash Composite Range Hash table/partition
I got ” ORA-14639: SUBPARTITIONS clause can be specfied only for Hash Composite Range Hash table/partition ” error in Oracle database during table creation.
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial











