Oracle RAC cluster testing - production environment best practices (Oracle 11g/12c/18c/19 RAC)
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
Oracle database booting
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 of Oracle database based on database technology
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;
Ta ...
Posted by SpasePeepole on Wed, 01 Apr 2020 03:05:27 +0200
ORA-12537: TNS: connection closed
discover problems
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:
C:\Users\caoyf>sqlplus system/xxxx@192.168.xxx.xxx:1521/server_taf
SQL*Plus: Release 11.2.0.4.0 Producti ...
Posted by V on Tue, 26 Nov 2019 18:36:24 +0100
Migrating from Oracle ASMLIB to ASM Filter Driver
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