Mastering Crontab: A Comprehensive Guide to Scheduled Tasks in Linux

Mastering Crontab: A Comprehensive Guide to Scheduled Tasks in Linux

Note: This article is an original work by Liu Feng from Anya Technology. Please respect intellectual property rights. When sharing, please indicate the source. No plagiarism, adaptation, or unauthorized reproduction is accepted. Introduction In the world of Linux, how can you make your computer automatically back up data every night, clean temporary files every Monday … Read more

Deploying Oracle 19c on Rocky Linux 9.6

Deploying Oracle 19c on Rocky Linux 9.6

Oracle 19c, as an enterprise-level relational database management system, can fully leverage its high performance and high availability advantages on Rocky Linux (a RHEL-compatible distribution). Given the limited installation documentation specifically for Oracle 19c on Rocky Linux 9.6, this article systematically organizes and optimizes the deployment process by combining Oracle’s official documentation with general installation … Read more

Steps to Install Oracle with a Graphical Interface on Linux

Steps to Install Oracle with a Graphical Interface on Linux

### 1. Create Groups and Users [root@localhost ~]# /usr/sbin/groupadd -g 54321 oinstall [root@localhost ~]# /usr/sbin/groupadd -g 54322 dba [root@localhost ~]# /usr/sbin/groupadd -g 54323 oper [root@localhost ~]# /usr/sbin/useradd -u 54321 -g oinstall -G dba,oper oracle ### 2. Create Working Directory and Set Permissions [root@localhost ~]# mkdir -p /u01/app/oracle/product/19.3.0/db_1 [root@localhost ~]# chown -R oracle:oinstall /u01/ [root@localhost ~]# … Read more

911 Stock Trading Diary (Oracle and ASIC Edition)

911 Stock Trading Diary (Oracle and ASIC Edition)

Let me discuss a few new changes. Last night, Oracle’s stock surged, with two highlights: one is that the orders for cloud computing data center construction significantly exceeded expectations, with North American investment banks generally predicting $100 billion, while in reality, a record $332 billion in orders were signed in the first quarter. Oracle is … Read more

IM Architecture: CPU Architecture: SIMD Vector Processing (IM-2.3)

IM Architecture: CPU Architecture: SIMD Vector Processing (IM-2.3)

Following Chapter 2 Oracle Database In-Memory Architecture (IM-2.2) This article is the second part of the IM architecture CPU Architecture: SIMD Vector Processing For data that needs to be scanned in the IM column store, the database uses SIMD (Single Instruction, Multiple Data) vector processing. The IM column store maximizes the number of column entries … Read more

What To Do When I/O Performance Drops After Virtualization?

What To Do When I/O Performance Drops After Virtualization?

This week, while studying in Chengdu, the schedule was tight, and we often had dinners in the evenings, leaving little time for fitness, causing our public account to fall silent. Regardless of how late it is today, I still want to share something; otherwise, I would feel guilty. Today, I saw a report stating that … Read more

Sharing Use Cases of Standard Huge Pages in Linux

Sharing Use Cases of Standard Huge Pages in Linux

Background Introduction An Oracle instance running on a cluster in RHEL is started using the systemd service (to facilitate cluster switching operations). During testing, it was found that standard huge pages were not being utilized. The specific situation is as follows: $ grep HugePages /proc/meminfo AnonHugePages: 0 kB ShmemHugePages: 0 kB FileHugePages: 0 kB HugePages_Total: … Read more

Troubleshooting: Handling Abnormal Disk Status After Replacing Disk Controller in Oracle Engineered Systems

Troubleshooting: Handling Abnormal Disk Status After Replacing Disk Controller in Oracle Engineered Systems

Troubleshooting: Handling Abnormal Disk Status After Replacing Disk Controller in Oracle Engineered Systems Our articles will be updated simultaneously on the WeChat public account IT Migrant’s Dragon Horse Life and the blog website ( www.htz.pw ). We welcome you to follow and bookmark, and also encourage everyone to share, but please indicate the source of … Read more

One-Click Installation of Oracle 11gR2 Database on Rocky Linux 10

One-Click Installation of Oracle 11gR2 Database on Rocky Linux 10

One-Click Installation Script Preparation steps before using the script Install the operating system Configure the host network Set up the software source; the script will configure it automatically, and you need to mount the ISO image Create a directory for storing software: mkdir /soft Upload the software package Upload the installation script Check Host and … Read more

Core Database Architecture Design Based on Virtualized Resource Pools in Production Environments

Core Database Architecture Design Based on Virtualized Resource Pools in Production Environments

This article provides insights into the application and practice of Oracle databases in PowerVM virtualization environments, serving as a reference for Oracle architecture design. The content is compiled by community expert Chen Yongfa based on technical discussions within the community. What factors and principles should be considered in the architectural planning and design of Oracle … Read more