Linux

How to Build 18c RAC – 1 of 4 – Preparing Two Database Servers

Posted on
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 […]
ACFS

How to Create Database on ACFS

Posted on
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      […]
Query

How to Compare Two Tables Definition

Posted on
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 […]
SQL

How to Resolve ORA-00947: not enough values

Posted on
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. […]
ASM

How to Create a ASM Disk Group

Posted on
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 […]
Query

How to Resolve ORA-00913: too many values

Posted on
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)         […]
Data Guard

How to Resolve Standby ORA-00600 [3020]

Posted on
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, […]
HTML

How to Redirect Web Page

Posted on
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 […]