ACFS

How to Create a 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. […]
ACFS

How to Create a ACFS File System on 18c by ASMCA

Posted on
ASMCA We call ASMCA by issuing asmca. [grid@primary01 ~]$ asmca Set User “root” Credential Click on “Settings” to proceed. Input root’s password in the field and then click Save. Expand “Volumes” on the tree. Create a New Volume Click on Create. button to create a new volume. Configure the new volume, then click on OK. […]
ASM

How to Create a ASM Disk Group

Posted on
Since we want all backup sets go to a dedicated disk group, so we need to create a new disk group FRA by ourselves. First of all, we call asmca to finish our task. [grid@primary01 ~]$ asmca Please note that, you have to call asmca by grid, not root. ASM configuration assistant opened. Expand Disk […]
Query

How to Resolve ORA-00913: too many values

Posted on
ORA-00913 Let’s see a SQL statement containing 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 […]
Redo Log File

How to Resize Redo Log Files

Posted on
Resize Redo Log Files The default size of redo logs during installation is 50MB which is too small for production databases. Of course, you can raise the size for your needs in OUI if you know where to change it. As for the databases that you took over from other DBA, 50MB of redo logs […]