Export and Import Database link in Oracle 18c

In this post, we will export and import the database link with data pump in Oracle 18c. In next post, we will demonstrate to prevent the passwords of database link using keystores. First, we created the user for testing purpose. [oracle@18c OPatch]$ sqlplus system/sys@pdb18c2 SQL*Plus: Release 18.0.0.0.0 – Production on Wed May 30 10:12:42 2018 […]

Read More

Creating Schema-Only Accounts in Oracle 18c

In this post, we will create a schema-only user or we can say that user with no authentication, this feature introduced in Oracle 18c. Sometimes developers want to create a user which contain data only but not allowed to log in. [oracle@18c ~]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 – Production on Wed May […]

Read More

Privacy Policy

Who we are Our website address is: http://oracle-help.com. What personal data we collect and why we collect it Comments When visitors leave comments on the site we collect the data shown in the comments form, and also the visitor’s IP address and browser user agent string to help spam detection. An anonymized string created from […]

Read More

Now Unachievable Certificate OCM Cloud

Finally, I’ve successfully achieved Oracle Certified Master, Database Cloud Administrator. Here are the steps for Certified Oracle Database Masters: Hold an Oracle Database 11g/12c Administrator Master Certification Hold either the Oracle Real Application Clusters 11g and Grid Infrastructure Administrator Expert Certification or Oracle Exadata Database Machine Administrator Expert Certification Pass the exam Oracle Database Cloud Administration (1Z0-028) But Exam is already […]

Read More

License High Water Mark in Alert Log

License High Water Mark in Alert Log The message was originally intended to let you know the maximum number of users sessions were used between bounces so that you could check this against how many sessions you were licensed for. [root@localhost ~]# cat /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log |grep high License high water mark = 169 You can query […]

Read More

Managing Remote Archived Log File Retention

In the previous article of Automatic deletion of archived redo log, we have seen automatic deletion is enabled by default in the Logical Standby database. Automatic Deletion of Redo Log Files by SQL Apply LOG_AUTO_DEL_RETENTION_TARGET parameter is responsible for this. It has default value 1440 minutes. However, we can manage this parameter and set retention […]

Read More

Automatic Deletion of Redo Log Files by SQL Apply

Archive log files which are used by SQL apply process at Logical Standby database is said to be Foreign Archive Logs or Remote Archived Logs. Foreign Archive log files are managed by SQL Apply process. To know more about it Oracle Dataguard After all the redo entries of Archive log files are applied using SQL apply process, these […]

Read More

Securing Your Logical Standby Database

The logical standby database is in Read-Write mode means a fully updatable mode. A database can be accessed and potential data may be changed. So Oracle data guard provides a lock. We can configure GUARD on the database at a different level according to our requirement. Logical Standby Database Creation A user access can be […]

Read More

Setting Protection Modes in Dataguard

In this article, we will see parameters that we can set while setting different protection modes and its impact on primary database and standby database. Protection modes in Oracle Dataguard We have already seen Protection Modes in Data Guard Protection modes in Oracle Dataguard Now let us see Redo Transport Attributes required for setting different protection […]

Read More

Logical Standby Database Creation

In the previous article, we have seen Preparation and consideration we need to see before creating Logical Standby Database. Preparing to Create a Logical Standby Database We can use following steps to create Logical Standby Database. Prerequisites : Physical Standby database already created. Step 1: Check Physical Standby Database is created and is synchronized with […]

Read More