Ora2Pg tool migrates Oracle to openGauss

hello! Hello everyone, I am [IT Bond], known as jeames007 in the world. I have more than 10 years of experience in DBA and big data work. A highly motivated [blogger in the field of big data]! Member of China DBA Alliance (ACDU), currently serving the industrial Internet Specialized in mainstream Oracle, MySQL, PG, Gaussian […]

09.Partitioning of Oracle tables

oracle basic system learning directory 01.CentOS7 silently install oracle11g 02.Oracle startup process 03. Start with simple sql 04.Oracle’s architecture 05.Oracle database objects 06.Oracle data backup and recovery 07.User and permission management 08.Oracle tables 09.Partitioning of Oracle tables 10.Oracle synonyms and sequences 11.Oracle’s view 12.Oracle index 13.Oracle connects to Java through JDBC 14.Transactions in Oracle 15.Oracle11g […]

oracle database (oracel11 version)

1. Understanding of oracle database 1.Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system from Oracle Corporation. It is a product that has always been in the leading position in the database field. It can be said that the Oracle database system is currently a popular […]

Oracle active/standby switchover, ogg recovery method (classic mode)

Foreword: This article mainly introduces how to recover the ogg process (classic mode) running in the main database and standby database when the Oracle database physical ADG primary and backup switches (switchover, failover). Test recovery scenario: 1 A switchover occurs between the active and standby devices, and the main database is the ogg source. 2 […]

Oracle(16)Managing Privileges

Table of Contents 1. Basic knowledge 1. Managing Privileges management permissions 2. System Privileges System privileges 3. System Privileges: Example System Privileges: Example 4. Who Can Grant or Revoke? Who can grant or revoke permissions? 5.The PUBLIC 6.SYSDBA and SYSOPER 7. Revoke with ADMIN OPTION Use ADMIN OPTION to revoke 8. Some Points Some system […]

oracle switches temporary table spaces, creates indexes, creates temporary tables, and creates large and small table spaces

1. The temporary table space of the switched database is temp1/the undo table space of the switched database is undotbs01 1. View the table space of the current database select tablespace_name from dba_tablespaces; It was found that there are no above two table spaces. 2. Create temp1 temporary table space and undotbs01 table space #Create […]

Oracle(15)Managing Users

Table of Contents 1. Basic knowledge 1. Users and Security Users and Security 2. Database Schema 3. Checklist for Creating Users Steps to create users 2. Basic operations 1. Create a user 2. OS Authentication Operating system authentication 3. Dropping a User 4. Getting User Information Obtaining user information Managing Users Goal: Create new database […]

Oracle11g ADG deployment

Zero, environment Main library: rhel 6.5 oracle 11.2.0.3 ip 192.168.18.66 ora11g Standby database: centos 7.9 orale 11.2.0.3 ip 192,168.18.77 ora11g_std 2. Main library installation (ignore this step in production environment) 1. Create users and groups [root@ora11g soft]# groupadd oinstall [root@ora11g soft]# groupadd dba [root@ora11g soft]# useradd -g oinstall -G dba oracle [root@ora11g soft]# passwd oracle […]

Section 27 Linux Installation of Oracle Database

Table of Contents 1. Deploy user groups depending on the environment 2.Install oracle 2.1. Path description 2.2. Create a new directory under root 2.3. Upload the oracle installation package 2.4. Modify host 2.5. Install necessary dependency packages 2.6. Modify kernel parameters (modify as needed) 2.7. Modify configuration 2.7.1. Configure user resource limits 2.7.2. Edit login […]