How to Build 18c RAC – 1 of 4 – Preparing Two Database Servers Suppose that you have prepared servers including two database servers, storage and name server. Now you are ready to go on installing grid infrastructure. Please note that, I have put all lengthy configuration work in the previous post, so we don’t […]
Network Design for RAC Let’s see the network design of our cluster database. [root@primary01 ~]# vi /etc/hosts # Public 192.168.10.11 primary01 primary01.example.com 192.168.10.12 primary02 primary02.example.com # Private 192.168.24.11 primary01-priv primary01-priv.example.com 192.168.24.12 primary02-priv primary02-priv.example.com # VIP 192.168.10.111 primary01-vip primary01-vip.example.com 192.168.10.112 primary02-vip primary02-vip.example.com # SCAN # 192.168.10.81 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.82 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.83 primary-cluster-scan primary-cluster-scan.example.com […]
Assuming that you have created a ACFS file system for the database creation. Then you can go on reading this post. Create a Database on ACFS First of all, make sure everything is ready including ACFS mount point which is /u02/oradata1 in this case. [grid@primary01 ~]$ crsctl status resource ora.data.oradata1.acfs -t ——————————————————————————– Name […]
Compare Two Tables’ Column Names Whenever you concern the differences between two tables’ definition, you can use queries to compare the columns of two tables. For example, a table named EMPLOYEES_2 which is very similar with the original table EMPLOYEES. And we’d like to know the differences in columns. We can compare both tables like […]
ORA-00947 With respect to ORA-00913: too many values, column list mismatching can result another type of error, called ORA-00947: not enough values. Let’s see how we reproduce the error. First of all, we create an empty table employees_2 from employees. SQL> create table employees_2 as select * from employees where 1 = 2; Table created. […]
Normal Way to Create ACFS File System The steps that create ACFS file system by ASMCA can be simplified as such: 1. Use a disk group to create a volume. 2. Use the volume to create ACFS file system. Later in this post, I will introduce a shortcut in ASMCA that can do all the […]
To isolate non-crucial backups from crucial data in the current disk group DATA, a separate new disk group with new disks is needed to put all backups. For meeting our new requirement, we plan to create a disk group called FRA, i.e. Fast Recovery Area, by ourselves. The utility that we are going to use […]
ORA-00913 When SELECT Let’s see a SQL statement containing a subquery that can reproduce ORA-00913 for an example. SQL> select * from employees where department_id in (select department_id, manager_id from departments where location_id = 1700); select * from employees where department_id in (select department_id, manager_id from departments where location_id = 1700) […]
ORA-00600 [3020] Found MRP shutdown with ORA-00600 [3020] in alert log of a standby database due to inconsistency of a newly created data file. Wed Nov 21 18:32:12 2018 Errors in file /oracle/admin/ORCL/bdump/orcl_mrp0_4589393.trc: ORA-00600: internal error code, arguments: [3020], [1786773511], [1], [37836], [320123], [72], [], [] ORA-10567: Redo is inconsistent with data block (file# 854, […]
Redirect Web Pages As time goes by, we may want to change URL of website into optimized ones for search engines in order to rank higher. Furthermore, replacing old domain name into a keyword-focused one to reconstruct our URL strategies. Therefore, We need skills to redirect web pages to new URL. Here I list 5 […]