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