Blog

“CIOLook dergisi, Veritabanı Teknolojilerinde Lider Yenilikler adlı Ekim 2024 sayısında, veritabanı teknolojileri alanında tanınmış bir isim olan, kariyerini Oracle Veritabanı sistemlerinde uzmanlaşmaya ve gelecek nesil uzmanlara mentorluk yapmaya adamış, bireylerin kariyerlerini dönüştürmelerine, rekabetçi bir sektörde özgüven ve yetkinlik geliştirmelerine olanak tanıyan DBMaster Bilgi Teknolojileri A.Ş.’nin Kurucusu ve CEO’su #TalipHakanOzturk’ü ağırlamaktan mutluluk duyuyor.”

Hello Everyone, In this blog post, I will give you information about Oracle 23ai features and how to install it. We need Oracle Linux 9 to perform these operations. 1. We will edit the “/etc/selinux/config” file SELINUX=disabled: [root@oracle ~]# cat /etc/selinux/config [root@oracle ~]# vi /etc/selinux/config 2. We will stop/disable firewall service and check firewall status: […]

Hello, Oracle Database 23ai is available in the cloud and as Free Developer Edition as of now. You can watch the announcement of Larry Ellison together with Juan Loiza EVP about Oracle’s Strategy for Data Management in 23ai. https://youtu.be/4yobT4rtmeo “Oracle Database 23ai is a game changer for enterprises worldwide, and because of the importance of […]

Hello Everyone, In this blog post, I will continue to give you information about oracle data redaction. Also, we can use function_parameters with “Fixed Character Formats”. Oracle Data Redaction provides special predefined formats to configure policies that use fixed characters. As can be seen in the link I provided as an example below, we have […]

Hello Everyone, In this blog post, I will give you information about oracle data redaction. We need to use dbms_redact package. The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application. DBMS_REDACT Package: grant execute on sys.dbms_redact to […]

Postgresql açık kaynak olması ve arkasında çok büyük ve güncel, geliştirici grubunun olması nedeniyle kurumlar tarafından son yıllarda katlanarak tercih edilmeye edilmeye başlandı. OLAP nedir? Açılımı Çevrimiçi Analitik İşleme olan bu veri işleme teknolojisi çok boyutlu verileri birden çok açıdan analiz etmeyi sağlar. Raporlama, satış pazarlama, stratejik planlama gibi verinin farklı açılardan yorumlanması gereken alanlarda […]

Clickhouse Veritabanı: Hızlı ve Ölçeklenebilir Veri Depolama ve Analiz Platformu   Giriş: Veri, günümüzün dijital dünyasında büyük bir hızla artmaktadır. İnternet kullanımının yaygınlaşması, akıllı cihazların ve nesnelerin interneti teknolojisinin yaygınlaşmasıyla birlikte, milyarlarca insan ve cihaz tarafından üretilen veri miktarı hızla artmaktadır. Bu verilerin depolanması, işlenmesi ve analiz edilmesi, şirketlerin ve kuruluşların rekabetçi avantaj elde etmeleri […]

Hello, When your Exadata database servers cannot be turned on from the operating system you can turn on it using the diagnostic iso image. Copy the diag.iso from any database server or storage cell to your desktop machine, for example to Downloads Folder. The diagnostic ISO image is available on all Exadata database servers and […]

You can find the steps to shutdown/startup The Exadata & RDBMS Services and cell/compute nodes On An Exadata  as below. Shutdown database and cluster services srvctl stop database -d dbmaster crsctl stop crs Shutdown cell services dcli -l root -g cell_group cellcli -e “alter cell shutdown services all” For reboot test of cell group (dcli […]

The Oracle Database Appliance saves time and money by simplifying deployment, maintenance, and support of database solutions for organizations of every size. Optimized for the world’s most popular database–Oracle Database–it integrates software, compute, storage, and network resources to deliver database services for a wide range of custom and packaged online transaction processing (OLTP), in-memory database, […]

Hi, In this blog post, I want to share the required steps for Startup, Shut Down, Reset, or Power Cycle the Oracle MiniCluster S7-2 Engineered System. Notify affected users that the server will be shut down. Log into one of the nodes as an MCMU administrator such as mcinstall mcinstall@dpwadm-n1:/var/home/mcinstall % mcmu status -G -k […]

Hello, In this blog post, I will describe the necessary steps to export data from Autonomous Database for Other Oracle Databases. Oracle recommends using the latest Oracle Data Pump version for exporting data from Autonomous Database to other Oracle databases. Firstly we need create a directory in Autonomous Database. CREATE DIRECTORY creates the database directory […]

Hello, In this blog post, I want to describe necessary steps to import data using Oracle Data Pump on Autonomous Database. You need to use Oracle Data Pump Export to export your existing Oracle Database schemas to migrate them to Autonomous Database using Oracle Data Pump Import. Oracle Data Pump Export provides several export modes, […]

Hello, In this blog post, I will describe how to create database links from Other Databases to Autonomous Database and from Autonomous Database to Other Databases. Use DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK to create database links from an Autonomous Database to another database. To use database links with Autonomous Database the target database must be configured to use TCP/IP […]

Hello, In this blog post, I will describe how to load data into an existing table in Autonomous Database with the SQL Developer Web import from file feature. Before loading data, we need to create the table in Autonomous Database. The file formats that you can upload with the SQL Developer Web upload feature are […]