IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
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
May, 2019
- 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 »
March, 2019
- 28 March
How to Drop Database in Oracle Database 19c
Hi, Sometimes you may need to drop Oracle database especially in test or development databases.
Read More » - 27 March
How to Solve The Oracle Management Server (OMS) host and port specified via OMS_HOST and EM_UPLOAD_PORT is not available. Pass in a valid hostname and port number for the OMS to successfully deploy the agent.
Hi, You can get ” The Oracle Management Server (OMS) host and port specified via OMS_HOST and EM_UPLOAD_PORT is not available. Pass in a valid hostname and port number for the …
Read More » - 21 March
ORA-01033: ORACLE initialization or shutdown in progress Cloud Control 13c start AdminServer Could Not Be Started
Hi, You can get ” ORA-01033: ORACLE initialization or shutdown in progress ” error when you start Cloud Control 12c with emctl start oms command.
Read More » - 21 March
ORA-65096: invalid common user or role name During Create User in Oracle
You can get ” ORA-65096: invalid common user or role name ” error while creating new user in Oracle 12c.
Read More » - 19 March
Oracle Database Enable Archivelog Mode and Archivelog Deletion and Generation Frequency
Hi In this article I will tell you about the Oracle database enable Archive mode and what happens when it is enabled.
Read More » - 19 March
ORA-02095: specified initialization parameter cannot be modified and scope both and spfile
You can get ” ORA-02095: specified initialization parameter cannot be modified ” error when changing Oracle database 12c.
Read More » - 19 March
Alter System Set Command | Oracle Database Parameters Change
Hi, In this article, I will continue to explain the parameter files and their changing.
Read More » - 19 March
Oracle Database 12c Parameter Files ( Spfile & Pfile )
Hi, In this article, I will explain the parameter files that are very important for Oracle database. This parameter is created when opening the Oracle instance and then we can …
Read More »
