Oracle 11G Dataguard Setup (DUPLICATE)
Unlike the traditional construction mode (rMAN backs up the source database and copies the data to the target database), Oracle supports the construction of the...
Read More
Tag: oracle
Oracle Database Shutdown (Single-server Environment)
December 21, 2023
by Anvi Garg
No Comments
Many R & D operations personnel like to directly close Oracle database services to shut down the Windows environment, but there is a risk of...
Read More
Oracle 11.2 Installation Environment Requirements (Linux x86 OS)
December 21, 2023
by 王雅涵
No Comments
The Linux x86 OS architecture is officially certified by Oracle as the best environment for deploying Oracle 11.2. (Minimum configuration required for installation)
Read More
Oracle data pump
December 21, 2023
by Stephen Smith
No Comments
Data pump (EXPDP, IMPDP) is a new technology introduced in Oracle 10G. It is compatible with most of the previous data export and import tools...
Read More
Oracle client installation
December 21, 2023
by Mr. Maurice Page
No Comments
Applications access the Oracle database through the Oracle client. Therefore, you must install the Oracle client program globally on the operating system to access the...
Read More
Oracle data pump
December 21, 2023
by Katherine Walton
No Comments
Data pump (EXPDP, IMPDP) is a new technology introduced in Oracle 10G. It is compatible with most of the previous data export and import tools...
Read More
Oracle create user
December 21, 2023
by Deborah Smith
No Comments
I met a lot of colleagues in R&D and implementation. The user construction in production environment was a bit chaotic, the data storage was a...
Read More
Oracle often uses file templates for recovery
December 21, 2023
by Shane Stewart
No Comments
Colleague: something has happened. I have connected to the wrong server and uninstalled the database in the production environment. Can you restore it? Me: Do...
Read More
Oracle12c deployment, allowing remote access
December 21, 2023
by Riley Cochran
No Comments
The host of an Oracle database is set to localhost. The host of an Oracle database is set to localhost for remote access. D:\app\orcl\product\12.1.tns...
Read More
Oracle SQL statement minus function execution efficiency compared with join
December 21, 2023
by Jonathon Rocha
No Comments
We often compare select results. The commonly used function is minus. So when two tables have a large amount of data, what can be done...
Read More
The Oracle base
December 21, 2023
by 張承翰
No Comments
Narrow sense database database + database operating system Oracle: located in physical memory data structure, is the operating system of multiple background processes made of...
Read More
Problem resolved: ORA-04030 private memory exceeded
December 21, 2023
by Brian Tanner
No Comments
Ora-04030 error was reported in database during inspection today. How to solve the problem? Key words: ORA-04030, (PGA heap, KGH stack), (KXS-heap-c, KPRbalo Temp memory
Read More
Oracle exports the entire database and imports the entire database commands
December 21, 2023
by Mr. Oliver Jones
No Comments
1, export database do not enter SQLplus, directly in the CMD window command to execute the following command @ is the name of your database...
Read More
❤️ Vagrant installs any system, even Oracle database, in one click!! ☀️ Recommended ᕕ(ᐛ)ᕗ
December 21, 2023
by Victoria Parker
No Comments
If you are a novice and can't install Oracle database, you can download the box I packed and install it directly, then you can use...
Read More
Deploy Rman backup in Windows environment
December 20, 2023
by Lisa Tran
No Comments
Windows environment, Rman periodic backup deployment, this article introduces the weekly full plus incremental deployment mode. Backup policies and retention policies can be flexibly adjusted...
Read More
Oracle VARchar2 field type is converted to cloB type
December 20, 2023
by 張思穎
No Comments
We already have data in the table. How to convert the varCHAR2 type into CLOB type?
Read More
SQL > alter table Oracle partition table
December 20, 2023
by Julie Paton
No Comments
Why convert an ordinary table to a partitioned table? What are some ways to do that? As one of the three components of Oracle, partitioned...
Read More
Java concurrent Programming (1) Thread detail
December 19, 2023
by 張雅惠
No Comments
From the above description, we can know that the thread is the basic scheduling unit of THE CPU, and the multi-core resources of the CPU...
Read More
Basic Oracle SQL syntax
December 19, 2023
by Susan Monk
No Comments
This article introduces the basic concepts related to Oracle database, the basic writing method of building database and table, adding, deleting, modifying and checking, as...
Read More
How to upgrade Oracle DataGuard? Just read this one
December 19, 2023
by Joanne Patton
No Comments
With the widespread application of Oracle, the DataGuard has become the standard configuration of the database disaster recovery environment. When upgrading the Oracle database, you...
Read More
⭐️ What should I Pay attention to when inspecting the Oracle database? ⭐️ (some personal insights)
December 18, 2023
by Katie Lambert
No Comments
This is the NTH day for me to participate in the August Challenge. For details, see: August Challenge 🌲 Foreword 🌲 If you are given...
Read More
Oracle18c quick to get started
December 18, 2023
by Miss Kathleen Wilson
No Comments
It is true that it has not been updated for a long time, even the first sentence seems difficult to say. So a little comb,...
Read More
Oracle 11.2.0.4 deployment for Linux | More challenging in August
December 18, 2023
by Kirk Martin
No Comments
This section describes how to install and deploy an Oracle single-node database on the Linux platform in the production environment. The parameters you set can...
Read More
Oracle database check script | August more text challenge
December 18, 2023
by 司懿
No Comments
The database check script is common on BOTH Windows and Linux platforms. It can be used for routine o&M check or data migration, and can...
Read More
How to achieve “global Data consistency” in distributed architecture?
December 18, 2023
by 劉鈺婷
No Comments
In fact, the story stems from two traditional concepts in databases: "Snapshot Isolation" and "multi-version Concurrency Control" (MVCC). These two techniques roughly mean maintaining multiple...
Read More
Install Oracle RAC on Linux7
December 18, 2023
by Dr. Nathan Davis
No Comments
What is Oracle RAC? Features: So, how do you deploy an RAC database environment? The procedure is as follows: Create user groups, users, and directories,...
Read More
Java 11 has just been released, and these are some of the most exciting new features that will teach you how to write even better code
December 17, 2023
by 黃婷婷
No Comments
Today we'll take a look at what Java 11 is, what's special about it, and whether or not to upgrade to Java 11. Java SE...
Read More
Common commands of the Oracle database in Linux
December 17, 2023
by Stuart Cresswell
No Comments
From multiple dimensions of the Linux environment Oracle database commonly used commands, coverage is very wide, absolutely suitable for small white, Ollie to!
Read More
Oracle (Installation)
December 17, 2023
by Hilary Reed
No Comments
Record the silent installation of Oracle11gR2 on Linux CentOS7.5. 1. Official minimum configuration [MEMORY] 1 GB (official minimum requirement: 1 GB) [Hard disk] 40 GB...
Read More
Oracle (User)
December 17, 2023
by Ethan Mitchell
No Comments
1. View the current user 2. View all user names 3. Creating a New Oracle User 3.1 Accessing the Oracle Console 3.2 Creating a New...
Read More