IT Tutorial Latest Tutorials About Database, Application, Operating System, Network, Artifical Intelligence, Programming Languages Tutorials & Useful Scripts & Tips and Tricks Hi, I will explain DLM cross inst call completion and enq: RO – fast object …
Read More » June 8, 2020
Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course
Hi, I will share with you Step by Step Oracle SQL Tutorials For Beginners. 4,933 views la…
April 23, 2020
Oracle Tutorial | Advanced Oracle Database Tutorials for Senior Oracle DBA
Hi, I will share with you Step by Step Oracle Database Tutorials for Senior Oracle DBA. 4,511&…
April 15, 2020
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
Hi, I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial in the Oracle Data…
December 10, 2019
RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA
Hi, I will share with you Step by Step RMAN Backup, Restore and Recovery Tutorials For Beginners in …
5 hours ago
Introduction of DATA WAREHOUSE-What is DATA WAREHOUSE?
What is the Data Warehouse? A data warehouse is a repository that can be made of questioning and ana…
7 hours ago
Python Unsupervised Learning -5
Hello, in this article, we continue the topic Unsupervised Learning. Dimension reduction Dimension r…
15 hours ago
ORA-24247: network access denied by access control list (ACL)
Hi, I got ” ORA-24247: network access denied by access control list (ACL) ” error in Or…
15 hours ago
ORA-29273: HTTP Request Failed
Hi, I got ” ORA-29273: HTTP Request Failed ” error in Oracle database. 180&…
16 hours ago
ORA-01502 index or partition of such index is in unusable state | Rebuild & Drop Index
Hi, I got ” ORA-01502 index or partition of such index is in unusable state ” error in O…
-
DLM cross inst call completion | enq: RO – fast object reuse wait event and _db_fast_obj_truncate parameter during Truncate Table in Oracle 19c
-
Alter System Flush Buffer Cache in Oracle
-
Alter System Flush Shared pool in Oracle
-
enq: TM – contention | TM Contention Wait Events in Oracle
-
How to Add Datafile to Tablespace and Tablespaces Usage , Tablespace Size Check
-
Oracle XE Installation on Hortonworks Data Flow (HDF)
Hi, in this artile, i will show you how to install Oracle Express Edition (XE) …
Read More » -
Apache Nifi on Google Cloud
-
Microsoft Azure Open Source Big Data & Analytic Service – HDInsight
-
Goldengate Replication – Oracle To Bigdata
-
Apache Kafka Producer Example With Java
-
Python Unsupervised Learning -5
Hello, in this article, we continue the topic Unsupervised Learning. Dimension reduction Dimension reduction finds …
Read More » -
Python Unsupervised Learning -4
-
Introduction to gensim (Python)
-
Introduction to Natural Language Processing in Python – (Simple text preprocessing)
-
Introduction to Natural Language Processing in Python – (Words counts with bag-of-words )
-
Ways to Track Deleted Database in SQL Server
SQL Server’s Schema Changes History we can recognize the name of databases that were dropped …
Read More » -
Ways to Migrate SQL Server Database to Azure SQL Database
-
Know How to Recover Deleted Table in SQL Server 2012 Without Backup
-
Explore SQL Server Restore Database with Recovery vs No Recovery Options
-
Resolve SQL Server Database Stuck in Suspect Mode Issue Effeciently
-
How to Clear ILOM FMA Faults And Reset The SP on Exadata or Other Servers
Hi, I will explain How to Clear ILOM FMA Faults And Reset The SP on …
Read More » -
How to Shutdown and Startup Exadata and Oracle Databases
-
Exadata Temp Tablespace Migration To Flash Disk
-
Oracle 18c RAC Database Upgrade From 12c (12.1.0.2) to 18c (18.7.0.0.0) on Full Rack Exadata -2 Manual 18c Database Upgrade
-
Oracle 18c RAC Database Upgrade From 12c (12.1.0.2) to 18c (18.7.0.0.0) on Full Rack Exadata -1 29757256 Patch Apply
-
Android Programming -15 Custom Adapter
Hi guys in this tutorial we will continue the custom adapter. In my previous article, …
Read More » -
Android Programming -14 Custom Listview-2
-
Android Programming -13 Custom Listview
-
Android Programming -12 ArrayAdapter
-
Android Programming -11 Listview Component
-
OGG-02028 Failed to attach to logmining server error 24,377 – ORA-24377: invalid OCI function code
Hi, Sometimes You can get ” OGG-02028 Failed to attach to logmining server error 24,377 …
Read More » -
OGG-02636 The TABLE specification for the source table does not include a catalog name. The database requires a catalog name
-
OGG-02058 The Oracle source database is not configured properly to support integrated capture. The following configuration error must be fixed: No minimum supplemental logging is enabled
-
OGG-08223 ERROR: One or more containers must be specified when registering Extract for a container database.
-
ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions with OGG-01296 Error mapping from and OGG-01154
-
How to connect to Oracle from Your Windows Host to a VirtualBox Guest
I am sure that anyone who wants to work on a database or a data …
Read More » -
Windows İşletim Sistemi ile Oracle Linux Sanal Makinesinin haberleştirilmesi(Virtualbox)
-
Veri Ambarı Konsepti(OLAP,OLTP)
-
Tableau Server Architecture
Tableau Server has a high scalable architecture that many users can connect and receive service …
Read More » -
Tableau Sunucu Mimarisi
-
Introduction of DATA WAREHOUSE-What is DATA WAREHOUSE?
What is the Data Warehouse? A data warehouse is a repository that can be made …
Read More » -
Introduction of DATA WAREHOUSE-What is DATA?
-
Data Warehouse Architectures
-
Constraints ( Primary Key, Foreign Key , Unique Key, Not Null and Check ) in Oracle SQL | Oracle SQL Tutorials -30
Hi, I will explain Constraints ( Primary Key, Foreign Key , Unique Key, Not Null …
Read More » -
Alter Table and Alter Table Add or Drop Column in Oracle SQL | Oracle SQL Tutorials -29
-
SQL Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -28
-
Create Table ( CTAS ) and Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -27
-
SQL Subquery, Nested Queries and In Any All Operator in Subquery in Oracle SQL | Oracle SQL Tutorials -26
-
dbms_output.put_line in PL/SQL
I will explain dbms_output.put_line in PL/SQL in this post. 1,623 views last month, 8 views today
Read More » -
Alter Session Set NLS_DATE_FORMAT in Oracle with Examples
-
PL/SQL Conversion/Decoding/NULL-Related Functions
-
PL/SQL Datetime Functions
-
PL/SQL – Number Functions
-
Performance Tuning and SQL Tuning Tutorial in the Oracle Database
Hi, I will share with you Step by Step Performance Tuning and SQL Tuning Tutorial …
Read More » -
Bulk Insert and Bulk Update in Oracle Database
-
What is the Optimizer Hints and How to Use Hints in Oracle | Oracle Database Performance Tuning Tutorial -16
-
How to Create SQL Plan Baselines Using Enterprise Manager Cloud Control | Oracle Database Performance Tuning Tutorial -15
-
SQL Plan Management Using SQL Plan Baselines in Oracle | Oracle Database Performance Tuning Tutorial -14
-
Usefull Scripts For Couchbase Dba
Why Couchbase? Today’s mission-critical applications demand support for millions of interactions with end-users. Traditional databases …
Read More » -
MongoDB Backup and Restore Using MongoDump
-
How to Access MongoDB Instance 4.2?
-
How to Install MongoDB on Windows System?
-
How To Install MongoDB 4.2 on RedHat/ CentOS 7 systems
Recent Posts
May, 2020
-
4 May
TNS-12221: TNS illegal ADDRESS parameters
Hi, Sometimes You can get “TNS-12221: TNS:illegal ADDRESS parameters ” error. 140 views last month, 1 views today
Read More » -
4 May
Ways to Rebuild Master Database in SQL Server Easily
Summary: The Master database is a very important database because it holds the primary configuration of the SQL database. But in case if it is corrupted then the user has to face various issues, So we will discuss the ways to rebuild the master database in SQL Server. Many users …
Read More » -
4 May
TNS-12203: TNS unable to connect to destination
Hi, Sometimes You can get “TNS-12203: TNS:unable to connect to destination ” error. 173 views last month, 1 views today
Read More » -
4 May
TNS-12171: TNS could not resolve connect identifier: string
Hi, Sometimes You can get “TNS-12171: TNS:could not resolve connect identifier: string ” error. 178 views last month, 1 views today
Read More » -
4 May
TNS-12170: TNS: Connect timeout occurred
Hi, Sometimes You can get “TNS-12170: TNS:Connect timeout occurred ” error. 334 views last month, 1 views today
Read More » -
4 May
TNS-12162: TNS:net service name is incorrectly specified because of Missing ORACLE_HOME and ORACLE_SID
Hi, Sometimes You can get “TNS-12162: TNS:net service name is incorrectly specified ” error. 351 views last month, 1 views today
Read More » -
4 May
TNS-12154: TNS:could not resolve the connect identifier specified
Hi, Sometimes You can get “TNS-12154: TNS:could not resolve the connect identifier specified ” error. 155 views last month, 1 views today
Read More » -
4 May
TNS-03506: Failed to create address binding
Hi, Sometimes You can get ” TNS-03506: Failed to create address binding ” error. 123 views last month, 1 views today
Read More » -
3 May
Goldengate Performance
You should set STREAM_POOL_SIZE 2gb Disk quality and network bandwith should be high. You should add heartbeat source and target to analyezed lag. You should add batchsql , groupstransops 180000 and insertappend at replicat parameter file. You should do uncompress target table. You upgrade replicat integrated . You should add …
Read More » -
3 May
Goldengate Troubleshooting
Hi , General errors and solutions for goldengate operations 1-) After goldengate upgrade from 12c to 19c , mapping error for replicat. You should add keycols parameter to map statement . ACCOUNT_NO is uniq index or primary key. OGG-01296 Error mapping from ARMOR.CMF to ARMOR.CMF. MAP ARMOR.CMF, …
Read More »