Production environment Oracle RAC cluster test best method (support Oracle 11g/12c/18c/19c RAC installation post test process)
1, Oracle RAC cluster test background
A large and medium-sized manufacturing company has built a set of business system ERP system for new projects. The database environment of this system is Oracle RAC (RHEL Linux7+O ...
Posted by sgtbash on Wed, 20 May 2020 12:29:41 +0200
If the server is powered off and restarted or restarted within the plan, the database instance and monitoring need to be started manually after the server's operating system is started. This paper introduces how to configure the start and shutdown of Oracle database as a system service, and automatically start / shut down the Oracle instance a ...
Posted by Khrysller on Sat, 25 Apr 2020 07:22:50 +0200
New tablespaces and corresponding users in Oracle Database
Create tablespace and temporary tablespace data files
Create a tablespace data file
SQL> CREATE TABLESPACE rec_news LOGGING DATAFILE '/home/oracle/OracleDB/user/rec_news/rec_news.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 5120M EXTENT MANAGEMENT LOCAL;
Posted by SpasePeepole on Wed, 01 Apr 2020 03:05:27 +0200
There are too many connections in the test environment. It is found that all the links are in the second rac node. No one calls or cares about the test environment
Manually test the specified instance:
SQL*Plus: Release 22.214.171.124.0 Producti ...
Posted by V on Tue, 26 Nov 2019 18:36:24 +0100
ASM Filter Driver is a new function that can replace ASMLIB and udev settings. It can replace ASMLIB and manual settings of udev rules files, and most importantly, I/O Filter functions. The so-called I/O Filter function can reject all invalid I/O requests. The main function is to prevent accidental overwriting of the underlying disk of the ASM ...
Posted by ruiner17 on Fri, 19 Jul 2019 13:04:51 +0200