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
March, 2019
- 11 March
Oracle Business Intelligence Discoverer 11.1.1.7 installation and integration with Oracle EBS 12.2.6 -3
Hi, I will continue to tell Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS 12.2.6 in this post. You should read first article before this article.
Read More » - 11 March
Oracle Business Intelligence Discoverer 11.1.1.7 installation and integration with Oracle EBS 12.2.6 -2
Hi, I will continue to tell Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS 12.2.6 in this post. You should read first article before this article.
Read More » - 11 March
Oracle Business Intelligence Discoverer 11.1.1.7 installation and integration with Oracle EBS 12.2.6 -1
Hi, I will tell Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS 12.2.6 in this post.
Read More » - 6 March
ORA-01031: insufficient privileges with SYSDBA Priviliges
Hi, Although sys user is most priviliged user in Oracle database but also you can get ORA-01031: insufficient privileges SYSDBA.
Read More » - 6 March
ORA-12545 connect failed because target host or object does not exist
Hi, You can get ” ORA-12545 connect failed because target host or object does not exist ” error when connect to database via Toad or PLSQL Developer.
Read More » - 6 March
ORA-19809: limit exceeded for recovery files
Hi, You can get ORA-19809: limit exceeded for recovery files error during the rman operations or database startup.
Read More » - 5 March
CLSRSC-507: The root script cannot proceed during root.sh Oracle 12c RAC installation
Hi, When I install Oracle 12c RAC ( Real application cluster ) i got ” CLSRSC-507: The root script cannot proceed on this node Node2 because either the first-node operations …
Read More » - 4 March
RMAN-06429: RCVCAT database is not compatible with this version of RMAN
Hi, When connect to RMAN catalog databasei you can get RMAN-06429: RCVCAT database is not compatible with this version of RMAN error because of version incompatibility between RMAN catalog database and …
Read More » - 4 March
Oracle ORA-00600 [krhpfh_03-1209] on convert to SNAPSHOT STANDBY
Hi, You can get ORA-600 error frequently in Oracle database, this error is internal Oracle error or bug code.
Read More » - 3 March
ORA-29701: unable to connect to Cluster Synchronization Service and ORA-01078
Hi, After Oracle 18c Automatic Storage management software is completed, i tried to start ASM instance but i got ” ORA-29701: unable to connect to Cluster Synchronization Service ” error.
Read More » - 3 March
ORA-00845:MEMORY_TARGET not supported on this system
Hi, After Oracle 18c Automatic Storage management software is completed, i tried to start ASM instance but i got ORA-00845:MEMORY_TARGET not supported on this system error.
Read More » - 1 March
PRVF-0002 : could not retrieve local node name
Hi, You can take PRVF-0002 : could not retrieve local node name error when you install Oracle database 12c R2.
Read More » - 1 March
ora-01555: snapshot too old: rollback segment number
Hi, If you get ORA-01555: snapshot too old error when you execute any query, then you have a problem with undo management or undo tablespaces.
Read More » - 1 March
ORA-28040: No matching authentication protocol
You can get ” ORA-28040: No matching authentication protocol ” error because of Oracle Client incompatibility when you upgrade Oracle database from 11g to 12c or Oracle 18c, 19c,
Read More »
March, 2018
- 2 March
ORA-01111: name for data file | ORA-01110: data file | MRP0: Background Media Recovery terminated with error 1111
You can get ” ORA-01111: name for data file | ORA-01110: data file | MRP0: Background Media Recovery terminated with error 1111 ” error in you dataguard after adding new …
Read More » - 1 March
ORA-15041 diskgroup DATA or RECO space exhausted with ORA-19504 ORA-17502
Hi, When you try to restore database, you can get ORA-19504 ORA-17502 ORA-15041 diskgroup space exhausted error.
Read More »
February, 2018
- 26 February
Oracle Database Startup and Shutdown Steps
Hi Guys, In this article, I will explain the startup and shutdown modes of Oracle database.
Read More »