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
August, 2021
- 1 August
Streams Pool Size in Oracle
I will explain Streams Pool Size in Oracle in this post.
Read More » - 1 August
Alter database open resetlogs in Oracle
I will explain Alter database open resetlogs in Oracle in this post.
Read More » - 1 August
How to Create Tablespace ( Bigfile, Permanent, Undo and Temp ) in Oracle
I will explain How to Create Tablespace ( Bigfile, Permanent, Undo and Temp ) in Oracle in this post.
Read More » - 1 August
RMAN Restore Database in Oracle
I will explain RMAN Restore Database in Oracle in this post.
Read More »
July, 2021
- 31 July
Autoextend Tablespace in Oracle
I will explain Autoextend Tablespace in Oracle in this post.
Read More » - 31 July
Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS in Oracle
I will explain Gather Schema Stats using DBMS_STATS.GATHER_SCHEMA_STATS in Oracle in this post.
Read More » - 31 July
Oracle Rename Database using NID Utility
I will explain Oracle Rename Database using NID Utility in this post.
Read More » - 28 July
ORA-12840: cannot access a remote table after parallel/insert direct load txn
I got ” ORA-12840: cannot access a remote table after parallel/insert direct load txn ” error in the Oracle database.
Read More » - 27 July
ORA-39095: Dump file space has been exhausted | filesize parameter
I got ” ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes ” error in the Oracle database.
Read More » - 26 July
ORA-19025: EXTRACTVALUE returns value of only one node
I got ” ORA-19025: EXTRACTVALUE returns value of only one node” error in the Oracle database.
Read More » - 26 July
Why low-code development platforms are gaining increasing popularity?
What does it take to create a business app? A large budget, a team of skilled developers, and plenty of time and patience, one might argue, but it’s exactly this …
Read More » - 17 July
Merge Join Cartesian in Oracle
I will explain Merge Join Cartesian in Oracle in this post.
Read More » - 17 July
Alert Log file location in Oracle
I will explain Alert Log file locations in Oracle in this post.
Read More » - 17 July
Listener Log file location in Oracle
I will explain Listener Log file location in Oracle in this post.
Read More » - 16 July
SQL*Net message from client wait in Oracle
I will explain SQL*Net message from client wait in Oracle in this post.
Read More » - 15 July
GV$ARCHIVED_LOG AND GV$LOG_HISTORY Views in Oracle
I will explain GV$ARCHIVED_LOG AND GV$LOG_HISTORY Views in Oracle in this post.
Read More » - 14 July
Oracle Disable Constraints & Enable Constraints
I will explain how to Disable Constraints & Enable Constraints in Oracle in this post.
Read More » - 13 July
Convert Physical Standby To Snapshot Standby Database ( Read / Write Mode ) in Oracle
I will explain how to Convert Physical Standby To Snapshot Standby Database in Oracle in this post.
Read More » - 12 July
ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 32
I got ” ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 32 into a target database with TSTZ version 18. ” error in …
Read More » - 12 July
ORA-01613: instance UNNAMED_INSTANCE_3 (thread 3) only has 0 logs – at least 2 logs required to enable.
I got ” ORA-01613: instance UNNAMED_INSTANCE_3 (thread 3) only has 0 logs – at least 2 logs required to enable. ” error in the Oracle database.
Read More » - 12 July
ORA-01618: redo thread is not enabled – cannot mount
I got ” ORA-01618: redo thread is not enabled – cannot mount ” error in the Oracle database when i add new nodes to the Oracle RAC.
Read More » - 12 July
ORA-12911: permanent tablespace cannot be temporary tablespace
I got ” ORA-12911: permanent tablespace cannot be temporary tablespace ” error in the Oracle database.
Read More » - 8 July
ORA-00600: internal error code, arguments: [kccsbck_first], [1], [2154662377]
I got ” ORA-00600: internal error code, arguments: [kccsbck_first], [1], [2154662377] ” error in the Oracle database.
Read More » - 6 July
SYS.USER$ Password | Save an Oracle user password
I will explain SYS.USER$ password | Save an Oracle user password in this post.
Read More » - 5 July
DBMS_JOB and dbms_job.submit in Oracle
I will explain DBMS_JOB and dbms_job.submit in Oracle in this post.
Read More »