Returning Character Value

Oracle Function SUBSTR Examples

Posted on
Oracle Function SUBSTR by Examples SUBSTR is used to cut a sub-string from a string. 1. Cut the first word from the input string ‘Oracle SQL Functions’. SUBSTR searches for position 1 and following 6 characters. SQL> select substr(‘Oracle SQL Functions’, 1, 6) “SUBSTR” from dual; SUBSTR —— Oracle Even though we use 0 as […]
Data Guard

How to Resolve ORA-01017 in DGMGRL Switchover

Posted on
ORA-01017 in DGMGRL Switchover ORA-01017 means that the credentials you provides are not correct, either the username cannot be recognized by the database instance or the password does not match the user’s. In DGMGRL, ORA-01017 may cause switchover to be interrupted. But luckily, the interruptions are not serious. There’re two error patterns for ORA-01017 in […]
Data Guard

How to Configure 19c Data Guard Broker

Posted on
Suppose you have duplicated a 19c physical standby already, it’s time to build the data guard relationship between the primary and standby databases. In this post, we directly enable data guard broker to implement 19c data guard environment. Standby Redo Logs We have to add standby redo logs on both primary and standby database for […]
Data Guard

How to Duplicate a 19c Physical Standby Database

Posted on
You don’t have to create an empty database on the standby server for building a standby database. In this post, I will show you how to duplicate a 19c physical standby database from scratch by the following sections. Password File File Management Mode Parameter File Necessary Directories Name Resolution Connect Identifiers Listeners Force Logging RMAN […]
Installation and Upgrade

How to Install Oracle 19c Software Only with Silent Mode

Posted on
With Response File First of all, let’s take a look at the content of the response file. [oracle@primary-19c ~]$ ll db-19c-software-only-installation.rsp -rwx—— 1 oracle oinstall 605 Aug  1 10:24 db-19c-software-only-installation.rsp [oracle@primary-19c ~]$ cat db-19c-software-only-installation.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install.db.OSBACKUPDBA_GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba oracle.install.db.rootconfig.executeRootScript=true oracle.install.db.rootconfig.configMethod=ROOT Next, install Oracle 19c software with silent […]
Segment

Segments vs Schema Objects

Posted on
Segments vs Schema Objects No only showing all tables in Oracle, for better understanding the nature of table, you also need to know the definitions of segment and schema object in Oracle world. Segments A segment in an Oracle database is a set of extents that contains all the data for a specific logical storage […]
Data Guard

How to Build Asymmetric Standby Database for Data Guard

Posted on
Asymmetric Data Guard Usually we build data guard environments with the symmetric architecture design on primary and standby servers, that is, single-instance to single-instance or RAC to RAC. Practically, we could have downgraded standby servers in hardware specifications. For example, we may use 16 cores per instance on the primary side but use 8 cores […]