Recent Articles

GUI DBCA tool the error code “Exception:TNS-04414

GUI DBCA tool the error code “Exception:TNS-04414

March 12, 2020 | By | Add a Comment

SymptomsWhilst using GUI DBCA tool the error code “Exception:TNS-04414: file error” is reported. Cause Some DBCA operations require to read and parse the net admin files, TNSNAMES.ORA, LISTENER.ORA and SQLNET.ORA.If there is any syntax issues with those files, including control characters, etc, Then the operation can fail. SOLUTION: Use the GUI Net manager tool to […]

Read More

Oracle Database 18c: New features for DBA

Oracle Database 18c: New features for DBA

February 17, 2020 | By | Add a Comment

Oracle Databse 18c comes with some cool new features for DBAs. during this article I’ll list my preferred ones. Just one note: i feel the name “Autonomous Database” is sort of misleading, because it means a number of the new features might be wont to configure your database as “autonomous” where previous versions required some […]

Read More

Do not use cylinder 0 of the disk for creating raw partitions?

Do not use cylinder 0 of the disk for creating raw partitions?

January 29, 2020 | By | Add a Comment

No matter how much I stress it, I cannot overemphasize the importance of this tip. In fact, it is not even tip; it is well documented in Oracle RAC manuals. However, if you are using RAC, chances are that you have not read the Oracle RAC documentation. The non-RAC documentation covers this point in a […]

Read More

Deprecated Initialization Parameter in Oracle 12c Release 2

Deprecated Initialization Parameter in Oracle 12c Release 2

March 21, 2019 | By | Add a Comment

To understand changes and replacements in parameter settings, review the parameters are following. O7_DICTIONARY_ACCESSIBILITY Initialization Parameter: The formatting parameter O7_DICTIONARY_ACCESSIBILITY controls restrictions on SYSTEM privileges. If the parameter is about to TRUE, then access to things within the SYS schema is allowed. The default setting is fake. This default setting prevents system privileges that permit […]

Read More

What is DBaaS DBA Role in Oracle Cloud?

What is DBaaS DBA Role in Oracle Cloud?

March 20, 2019 | By | Add a Comment

The role of Oracle DBAs has been constantly evolving past the 1990s. For a long duration of time, around the 70s, 80s, and 90s, the deal has been quite different, but not easy for sure. That has grown to become substantially different today, but not easy, and maybe something totally new in the next two […]

Read More

A Simple Shell Script Example

A Simple Shell Script Example

January 30, 2019 | By | Add a Comment

A Simple Shell Script Example Combining various command options can lead to hideously complex commands. If you are loath to type such long-winded commands on a regular basis, Unix and Linux offer the shell script option, which merits a brief detour. Here is you can find out the simple practical approach of shell script. You […]

Read More