Installing Oracle 12.2 GoldenGate on Linux server

Installing Oracle 12.2 GoldenGate on Linux server

Description:-

Oracle Goldengate software delivered as a zip file (fbo_ggs_Linux_x64_shiphome.zip) So we must have expand the zip file using the unzip command before we can install the software.

Change the directory to where the software is reside. And unzip the oracle goldengate software bundle.

[oracle@ggsource goldengate]$ ls -ltr
total 464472
-rwxrwxr-x 1 oracle oracle 475611228 May 30 23:51 fbo_ggs_Linux_x64_shiphome.zip
[oracle@ggsource goldengate]$ unzip fbo_ggs_Linux_x64_shiphome.zip
Archive: fbo_ggs_Linux_x64_shiphome.zip
creating: fbo_ggs_Linux_x64_shiphome/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/OuiConfigVariables.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/productlanguages.properties

…….many lines are neglected for clarity…….

inflating: fbo_ggs_Linux_x64_shiphome/Disk1/install/detachHome.sh
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/install/clusterparam.ini
creating: fbo_ggs_Linux_x64_shiphome/Disk1/response/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
inflating: OGG-12.2.0.1-README.txt
inflating: OGG-12.2.0.1.1-ReleaseNotes.pdf

[oracle@ggsource goldengate]$ ls -ltr
total 464756
drwxr-xr-x 3 oracle oracle 4096 Dec 12 2015 fbo_ggs_Linux_x64_shiphome
-rw-r–r– 1 oracle oracle 1559 Jan 19 2016 OGG-12.2.0.1-README.txt
-rw-r–r– 1 oracle oracle 282294 Jan 19 2016 OGG-12.2.0.1.1-ReleaseNotes.pdf
-rwxrwxr-x 1 oracle oracle 475611228 May 30 23:51 fbo_ggs_Linux_x64_shiphome.zip

Create the /u01/app/oracle/product/gghome directory.

[oracle@ggsource ~]$ mkdir -p /u01/app/oracle/product/gghome
[oracle@ggsource ~]$ ls /u01/app/oracle/product
12.1.0.2    gghome

Run the Oracle GoldenGate 12.2.0.1 installer as the oracle user. The installer is located in the /goldengate/fbo_ggs_Linux_x64_shiphome/Disk1 directory.

[oracle@ggsource ~]$ cd goldengate/
[oracle@ggsource goldengate]$ cd fbo_ggs_Linux_x64_shiphome
[oracle@ggsource fbo_ggs_Linux_x64_shiphome]$ cd Disk1/
[oracle@ggsource Disk1]$ ls -ltr
total 16
drwxr-xr-x 4 oracle oracle 4096 Dec 12 2015 install
drwxr-xr-x 11 oracle oracle 4096 Dec 12 2015 stage
-rwxr-xr-x 1 oracle oracle 918 Dec 12 2015 runInstaller
drwxrwxr-x 2 oracle oracle 4096 Dec 12 2015 response


[oracle@ggsource Disk1]$ ./runInstaller
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 120 MB. Actual 4227 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4991 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-05-30_11-58-56PM. Please wait …[oracle@ggsource Disk1]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2018-05-30_11-58-56PM.log

Select “Oracle GoldenGate for Oracle Database 12c (799.0MB)” and click Next.

In the “Software Location” field enter the directory you created to host the Oracle GoldenGate software for the replication source,/u01/app/oracle/product/gghome and accept the default values for the Database Location (/u01/app/oracle/product/12.1.0.2/db_1) and Manager Port (7815.) Click Next.

Verify the fields we entered in the previous screens and click Install to start the installation.

The window displays the progress bar and keeps you informed about the installation process.

Click Close to dispose of the window. The Oracle GoldenGate software for the replication source is now installed.

Catch Me On:- Hariprasath Rajaram

LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter:  https://twitter.com/hariprasathdba

Oracle-18c Read-Only Oracle Home

Oracle-18c Read-Only Oracle Home

Description:-

The read-only Oracle home feature have all the configuration data and log files are placed outside of the read-only Oracle home. This read-only Oracle home, we can use as a software image that can be distributed across several servers.

Apart from the traditional ORACLE_BASE and ORACLE_HOME directories, the below directories are contain the files that used to be in ORACLE_HOME.

Benefits of a Read-Only Oracle Home:

It cab be provide patching and updating of Oracle databases without extended downtime.

ORACLE_BASE_HOME:

Both read-only ORACLE_HOME and read/write ORACLE_HOME, the user-specific files, instance-specific files, and log files placed in a location called as the ORACLE_BASE_HOME.

ORACLE_BASE_CONFIG:

Both read-only ORACLE_HOME and read/write ORACLE_HOME, the configuration files placed in a location called as ORACLE_BASE_CONFIG.

ORABASETAB:

The orabasetab file is used to define fundamental directories based on $ORACLE_HOME: ORACLE_BASE, ORACLE_BASE_HOME and ORACLE_BASE_CONFIG.

Now check the status of read-only oracle home using orabasetab file:

[oracle@orcl18c ~]$ cat $ORACLE_HOME/install/orabasetab

Enable the Read-Only Oracle Home:

Configure Oracle home as a read-only Oracle home after we have performed a software-only Oracle Database installation.

[oracle@orcl18c ~]$ cd $ORACLE_HOME/lib
[oracle@orcl18c lib]$ roohctl -enable -force

Now cheak whether the read-only oracle home is enable or not using orabasetab file.

[oracle@orcl18c ~]$ cat $ORACLE_HOME/install/orabasetab

Disable the Read-Only Oracle Home:

[oracle@orcl18c ~]$ cd $ORACLE_HOME/lib
[oracle@orcl18c lib]$ roohctl -disable -force

Catch Me On:- Hariprasath Rajaram

LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter:  https://twitter.com/hariprasathdba

 

Oracle 18c-Performing a Data Guard Failover using DBCS Console

Oracle 18c-Performing a Data Guard Failover using DBCS Console

Description:- 

  • In this article we are going to perform oracle 18c dataguard Failover step by steps using  DBCS (Oracle Database Cloud Service Console)
  • we can Perform the Failover Operation using DBCS (Oracle Database Cloud Service Console) Or dbaascli utility

Check this link how to create oracle database 18c  dataguard

  • Oracle 18c-Configure Data Guard On Oracle Cloud Service Here

Step1:-Open the Oracle Database Cloud Service console

Oracle 18c-Configure Data Guard Details

Step2:-Before Failover check the database level.

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Primary Side

Standby Side

Overview Picture

Step3:-Login in to any one of server

Step4:-Check the Dataguard Status Using dbaascli Command                                                                          dbaascli dataguard status

Step5:-Check the Dataguard configuration status

Step6:-From the menu we need select the Failover button, and then confirm the action.

Step7:-Failover operation is started using DBCS Console and databases in Maintenance mode

Step8:-Failover Successfully Completed using DBCS Console.

Step9:-After Failover check the database level.

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

 

Step10:-Check the Dataguard Status Using dbaascli Command

[oracle@chennai-dg01 ~]$ dbaascli dataguard status
DBAAS CLI version 1.0.0
Executing command dataguard status
SUCCESS : Dataguard is up and running
DETAILS:
Connected to “chennai_02”
Connected as SYSDBA.
Configuration – fsc
Protection Mode: MaxPerformance
Members:
chennai_02 – Primary database
chennai_01 – Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Properties:
FastStartFailoverThreshold = ’30’
OperationTimeout = ‘120’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
ConfigurationWideServiceName = ‘chennai_CFG’
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

Catch Me On:- Hariprasath Rajaram

LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter:  https://twitter.com/hariprasathdba

 

Oracle 18c-Performing a Data Guard Failover Using DBaascli Utility

       Oracle 18c-Performing a Data Guard Failover Using DBaascli Utility

Description:- 

  • In this article we are going to perform oracle 18c dataguard Failover step by steps using dbaascli utility
  • we can Perform the Failover Operation using  Or dbaascli utility Or DBCS (Oracle Database Cloud Service Console)

Check this link how to create oracle database 18c dataguard

  • Oracle 18c-Configure Data Guard On Oracle Cloud Service Here
  • Creating an Oracle 18c Database Cloud Service Instance Here

Let’s start the Demo:-
Both Primary and Standby database already configured
Check the link Oracle 18c-Configure Data Guard On Oracle Cloud Service Here 

Step1:-Open the Oracle Database Cloud Service console

Oracle 18c-Configure Data Guard Details

Step2:-Before Failover check the database level.   

Primary Side

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Standby Side

Overview Picture

Step3:-Login in to any one of server

Step4:-Check the Dataguard Status Using dbaascli Command                                                                          dbaascli dataguard status

Step5:-Check the Dataguard configuration status

Step6:-Start the failover using dbaascli Command

Login into primary server execute the dbaascli dataguard failover

Failover completed successfully using dbaascli utility

Step7:-After Failover check the database level.

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Step8:-Check the Failover Status using DBCS Console.

Step9:-Check the Dataguard Status Using dbaascli Command

[oracle@chennai-dg01 ~]$ dbaascli dataguard status
DBAAS CLI version 1.0.0
Executing command dataguard status
SUCCESS : Dataguard is up and running
DETAILS:
Connected to “chennai_02”
Connected as SYSDBA.
Configuration – fsc
Protection Mode: MaxPerformance
Members:
chennai_02 – Primary database
chennai_01 – Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Properties:
FastStartFailoverThreshold = ’30’
OperationTimeout = ‘120’
TraceLevel = ‘USER’
FastStartFailoverLagLimit = ’30’
CommunicationTimeout = ‘180’
ObserverReconnect = ‘0’
FastStartFailoverAutoReinstate = ‘TRUE’
FastStartFailoverPmyShutdown = ‘TRUE’
BystandersFollowRoleChange = ‘ALL’
ObserverOverride = ‘FALSE’
ExternalDestination1 = ”
ExternalDestination2 = ”
PrimaryLostWriteAction = ‘CONTINUE’
ConfigurationWideServiceName = ‘chennai_CFG’
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

 

Catch Me On:- Hariprasath Rajaram

LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter:  https://twitter.com/hariprasathdba

 

 

AIOUG Sangam & ODevCYatra Conference

Doyensys Team


Chennai AIOUG Team Hariharaputhran-Justin-Johnson-Ragu

 



ANIL-Markus


Kamran Agayev


Sandesh Rao-Hariharaputhran-Midhun Gandhi-Connor McDonald-Harish-Veeratteshwaran-Gavin Soorma-Himachalapathy

 


Arup Nanda


Syed Jaffar Hussain & Markus


Vinay Mistry, harish, Veeratteshwaran Sridhar, Himachalapathy Palani and Pravin Takpire-Pinto


Sandesh Rao-Skant

My AIOUG Sessions

Oracle AIOUG Chennai Chapter -Oracle 12c Multitenant Database Session


Oracle AIOUG Chennai Chapter -Oracle Database 18c New Features


Oracle AIOUG Chennai Chapter -Oracle Cloud Database Service Part-1


Oracle AIOUG Chennai Chapter -Are You Ready For Oracle Cloud Database Service part-2


Oracle AIOUG Chennai Chapter -Oracle Dataguard  Deep Drive-1


Oracle AIOUG Chennai Chapter -Oracle Flashback Deep Drive


Oracle AIOUG Chennai Chapter -Oracle Dataguard  Deep Drive-2


Oracle AIOUG Chennai Chapter -Database Security Assessment Tool


 

Oracle Database 12cR2 Installation in RHEL 7.4

Oracle Database 12cR2 Installation in RHEL 7.4

Description:

This article is about Oracle Database 12cR2 Installation in RHEL 7.4. In this article we are going to see all the prerequisite, oracle binary installation, post installation and database creation  to be done for Oracle 12cR2 Database.

Note:

The Hardware configuration for the server with memory of 8GB, swap 8GB and total hard disk capacity used is 250GB.

Kindly refer Here for RHEL 7.4 Installation in VMWare.

Pre-Install:

Step 1:

Change the hostname in the below file using any text editor if needed and reboot the server:

# cat /etc/hostname
prod101.oracledbwr.com

# shutdown -r now

Check the hostname once the server rebooted

# hostname

# cat /etc/hosts
192.168.1.211 prod101.oracledbwr.com prod101

Step 2:

Using any text editor, create or edit the /etc/sysctl.d/97-oracle-database-sysctl.conf file, and add or edit lines similar to:

# cat /etc/sysctl.d/97-oracle-database-sysctl.conf
kernel.sem = 250 32000 100 128
kernel.shmall = 2097152                #shmall 40 percent of the size of physical memory in pages /proc/sys/kernel/shmall
kernel.shmmax = 4294967296   #shmmax Half the size of physical memory in bytes. Here we have 8GB of RAM
kernel.shmmni = 4096
kernel.panic_on_oops = 1
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

To change the current values of the kernel parameters without reboot of server, execute the below command:
# /sbin/sysctl –system

Review the output. If the values are incorrect, edit the /etc/sysctl.d/97-oracle-database-sysctl.conf file, then enter this command again.

Confirm that the values are set correctly:
# /sbin/sysctl -a

Step 3:

Add the following lines to a file called “/etc/security/limits.d/oracle-database-server-12cR2-preinstall.conf” file:

# cat /etc/security/limits.d/oracle-database-server-12cR2-preinstall.conf
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728

Step 4:

The following packages are listed as required, including the 32-bit version of some of the packages. Many of the packages should be installed already.

binutils-2.23.52.0.1-12.el7 (x86_64)
compat-libcap1-1.10-3.el7 (x86_64)
glibc-2.17-36.el7 (i686)
glibc-2.17-36.el7 (x86_64)
glibc-devel-2.17-36.el7 (i686)
glibc-devel-2.17-36.el7 (x86_64)
ksh
libaio-0.3.109-9.el7 (i686)
libaio-0.3.109-9.el7 (x86_64)
libaio-devel-0.3.109-9.el7 (i686)
libaio-devel-0.3.109-9.el7 (x86_64)
libX11-1.6.0-2.1.el7 (i686)
libX11-1.6.0-2.1.el7 (x86_64)
libXau-1.0.8-2.1.el7 (i686)
libXau-1.0.8-2.1.el7 (x86_64)
libXi-1.7.2-1.el7 (i686)
libXi-1.7.2-1.el7 (x86_64)
libXtst-1.2.2-1.el7 (i686)
libXtst-1.2.2-1.el7 (x86_64)
libgcc-4.8.2-3.el7 (i686)
libgcc-4.8.2-3.el7 (x86_64)
libstdc++-4.8.2-3.el7 (i686)
libstdc++-4.8.2-3.el7 (x86_64)
libstdc++-devel-4.8.2-3.el7 (i686)
libstdc++-devel-4.8.2-3.el7 (x86_64)
libxcb-1.9-5.el7 (i686)
libxcb-1.9-5.el7 (x86_64)
make-3.82-19.el7 (x86_64)
net-tools-2.0-0.17.20131004git.el7 (x86_64) (for Oracle RAC and Oracle Clusterware)
smartmontools-6.2-4.el7 (x86_64)
sysstat-10.1.5-1.el7 (x86_64)

Verify the installed RPM’s by executing the following command:

# rpm -q binutils compat-libcap1 glibc-2.17 glibc-devel-2.17 ksh libaio libaio-devel libX11 \
libXau libXi libXtst libgcc libstdc++- libstdc++-devel libxcb make net-tools smartmontools sysstat

Step 5:

Create the required groups for Oracle Database 12cR2 Installation

# /usr/sbin/groupadd -g 54321 oinstall
# /usr/sbin/groupadd -g 54322 dba
# /usr/sbin/groupadd -g 54323 oper
# /usr/sbin/groupadd -g 54324 backupdba
# /usr/sbin/groupadd -g 54325 dgdba
# /usr/sbin/groupadd -g 54326 kmdba
# /usr/sbin/groupadd -g 54327 asmdba
# /usr/sbin/groupadd -g 54328 asmoper
# /usr/sbin/groupadd -g 54329 asmadmin
# /usr/sbin/groupadd -g 54330 racdba

Add “oracle” user with appropriate primary and secodary groups below

# /usr/sbin/useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,asmoper,asmadmin oracle
# passwd oracle

Step 6:

Create oraInst.loc file to mention the group of inventory location

# cat /etc/oraInst.loc
inventory_loc=/oradb/app/oraInventory
inst_group=oinstall

Create necessary directories for Oracle Binaries installation and provide appropriate permissions:

mkdir -p /oradb/app/oraInventory
mkdir -p /oradb/app/oracle/product/12.2.0.1/db_1
chown -R oracle:oinstall /oradb
chmod -R 775 /oradb

Step 7:

Set secure linux by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows

# cat /etc/selinux/config
SELINUX=permissive

Once the change is complete, restart the server or run the following command.

# setenforce Permissive

Step 8:

If we need to disable firewall in linux do the following:

# systemctl stop firewalld
# systemctl disable firewalld

Step 9:

As root user execute the following command:

xhost +

Step 10:

Login as oracle user set the following entry in .bash_profile

# su – oracle
# cat .bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export LC_ALL=C
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

Create an environment file for the database to be created with the following variables:

# cat /home/oracle/prod.env

# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=prod101.oracledbwr.com
export ORACLE_UNQNAME=PROD_PROD1
export ORACLE_BASE=/oradb/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
export ORACLE_SID=PROD
export PATH=/usr/sbin:/usr/local/bin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Oracle Installation:

Before starting the installation by “runInstaller” from the unzipped “linuxx64_12201_database.zip”, remember to set the display variable or “xhost +” as oracle user.

# su – oracle

#xhost +

Note:

Oracle as two options during the binary installation, first option is to install binary and create a database during the installation and the the second option is to install only the binaries. Here, we are going with the second option.

Step 1:

# pwd

/home/oracle

# unzip linuxx64_12201_database.zip

cd database

./runInstaller

Once, runInstaller is executed, the below GUI will started for Oracle 12cR2 Installation. In the first empty box provide your E-mail ID if you wish to receive updates from oracle, else uncheck and press “Next”.

Step 2:

As I said already, we are installing only the oracle binaries now. Hence, select “Install database software only” and press “Next”.

Step 3:

Since, we are going to install a standalone database, select option 1.

Step 4:

Select the appropriate option as per your licensing in the below screen and press “Next”.

Step 5:

Set the ORACLE_BASE and ORACLE_HOME directories for oracle binary installation as we already created during the Pre-install.

Step 6:

Select the appropriate groups created during the pre-install in the below screen and press “Next”.

Step 7:

Once, the pre-checks has been completed without any failures, start the installation by “Install” in the below screen.

See the progress of the oracle binaries installation below.

 

Post-Install:

Once the binaries are installed, when the below screen apprears run the “root.sh” from the newly installed ORACLE_HOME directory from the terminal and press ”OK” and “Close” the GUI from the next screen.

# /oradb/app/oracle/product/12.2.0.1/db_1/root.sh

Database Creation:

Once the oracle binaries are installed successfully, run the environment file which we created already during pre-install and start dbca for Database creation.

Step 1:

# pwd

/home/oracle

# . prod.env

# dbca

Here, since we are create a database for the first time in this server, almost all options are disabled except create database.

Step 2:

Select “Advanced Configuration” to create database custom configuration options like location of the database files, SGA & PGA and other parameters of the database.

Step 3:

Provide the Global database name and SID of the database. Also, uncheck “Create as Container database” since we create a normal database.

Step 4:

If you want place the datafiles in different directory other the default location, select option 2 and provide the directory.

Step 5:

Check “Specify Fast Recovery Area” to place the backups and select “Enable archiving”. Also, I am specifying custom location to place the archive logs. So, select “Edit archive mode parameters” and provide the location.

Step 6:

Provide the listener name and port# in the below screen.

Step 7:

Provide the appropriate SGA & PGA, processes, characterset from the below GUI.

Step 8:

Configure Enterprise Manager if needed, else uncheck and press “Next”.

Step 9:

Provide the password for administrative accounts.

Step 10:

Select “Create database” option and “All Initialization Parameters” to check the parameters of the database.

Step 11:

Click on Finish to start the database creation.

 

 

Catch Me On:- Hariprasath Rajaram

LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter:  https://twitter.com/hariprasathdba

Oracle 18c-Performing a Data Guard Switchover using dbaascli Utility

       Oracle 18c-Performing a Data Guard Switchover using dbaascli Utility 

Description:- 

  • In this article we are going to perform oracle 18c dataguard Switchover step by steps using dbaascli utility
  • we can Perform the Switchover Operation using  Or dbaascli utility Or DBCS (Oracle Database Cloud Service Console)

Check this link how to create oracle database 18c dataguard

  • Oracle 18c-Configure Data Guard On Oracle Cloud Service Here
  • Creating an Oracle 18c Database Cloud Service Instance Here

Let’s start the Demo:-
Both Primary and Standby database already configured
Check the link Oracle 18c-Configure Data Guard On Oracle Cloud Service Here 

Step1:-Open the Oracle Database Cloud Service consoleOracle 18c-Configure Data Guard Details

Step2:-Before Switchover check the database level.                                                                                      Primary Side

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;

Standby Side

Overview Picture

Step3:-Login in to any one of server

Step4:-Check the Dataguard Status Using dbaascli Command                                                                          dbaascli dataguard status

Step5:-Check the Dataguard configuration status

Step6:-Start the swithover using dbaascli Command

dbaascli dataguard switchover

Swithover completed successfully using dbaascli utility

Step7:-Restart the ORDS services.

[oracle@chennai-dg01 ~]$ /etc/init.d/ords restart
INFO: Stopping Oracle REST Data Services…
INFO: Oracle REST Data Services stopped
INFO: Starting Oracle REST Data Services…
INFO: Oracle REST Data Services bound to ports 8181,8080 25619
INFO: Oracle REST Data Services started with PID 25619

Step8:-Post checks after a switchoverPrimary Side

select name, db_unique_name, database_role, switchover_status, open_mode from v$database;Standby Side

Reference:-

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/data-guard-switchover-using-dbaascli.html

Catch Me On:- Hariprasath Rajaram

LinkedIn:    https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:   https://www.facebook.com/HariPrasathdba
FB Group:   https://www.facebook.com/groups/894402327369506/
FB Page:      https://www.facebook.com/dbahariprasath/?
Twitter:       https://twitter.com/hariprasathdba

 

 

Oracle Application Express 18.1 Installation

                                              Oracle Application Express 18.1 Installation

Installation Requires:-

Oracle Application Express release 18.1 requires an Oracle Database release 11.2.0.4 or later, including Enterprise Edition and Express Edition (Oracle Database XE).

Download APEX 18.1 software Here 

Click Accept button and download the Oracle APEX 18.1.0 software.

Step 1:-Unzip the APEX 18.1.0.00.45 software:

unzip apex_18.1.zip -d /oradb/

Step 2:-Create a new APEX tablespace,

CREATE TABLESPACE APEX DATAFILE ‘/oradb/app/oracle/oradata/clone/apex01.dbf’ SIZE 1G;

Step 3:-Check the Oracle Application Express  is installed:

SELECT comp_name, version, status FROM dba_registry WHERE comp_id=’APEX’;

no rows selected

Step 4:-Installation of APEX 18.1:-

SQL> @apexins APEX APEX TEMP /i/

Where:
apex_tbs – name of the tablespace for the APEX user.
apex_files_tbs – name of the tablespace for APEX files user.
temp_tbs – name of the temporary tablespace.
images – virtual directory for APEX images. Define the virtual image directory as /i/ for future updates. */

The above script create some SCHEMA on Database, you can test by querying view ALL_USERS.

SQL> select username,created from all_users where USERNAME like ‘%APEX%’;

USERNAME                                                         CREATED
—————————————-
APEX_PUBLIC_USER                                    29-MAY-18
APEX_180100                                                    29-MAY-18
APEX_INSTANCE_ADMIN_USER          29-MAY-18

Step 5:-Check the VERSION and STATUS is installed,

SELECT comp_name, version, status FROM dba_registry WHERE comp_id=’APEX’;

COMP_NAME                                   VERSION           STATUS
——————————————-
Oracle Application Express      18.1.0.00.45             VALID

Step 6:-Check APEX RELEASE VERSION:

select * from apex_release;

VERSION_NO             API_COMPAT        PATCH_APPL
———- ———- ———————
18.1.0.00.45                 2018.04.04                     APPLIED

Configuring APEX:
Step 7:-Run the Embedded PL/SQL Gateway configuration (EPG)

This script will load the Application Express images into XDB,
@apex_epg_config.sql <parent of apex directory>

SQL> @apex_epg_config.sql /oradb

Step 8:-Make sure that the following accounts are unlocked:

ALTER USER anonymous ACCOUNT UNLOCK;
ALTER USER xdb ACCOUNT UNLOCK;
ALTER USER apex_public_user ACCOUNT UNLOCK;
ALTER USER flows_files ACCOUNT UNLOCK;

Step 9:-Configure database parameters for APEX:

SHOW PARAMETER job_queue_processes

NAME                                    TYPE                 VALUE
———————————–
job_queue_processes integer                4000

SHOW PARAMETER shared_servers

NAME                                 TYPE                  VALUE
———————————–
max_shared_servers integer
shared_servers              integer                      1

Change the shared_servers parameter:

ALTER system SET shared_servers=5 scope=both;

Step 10:-Used to perform the final configuration steps for Oracle Application Express, including setting the XDB HTTP listener port and Application Express ADMIN password.

To user, you can use ADMIN by default, and email can be skipped.

Also you can change the HTTP port.But default port is 8080.

SQL>@/oradb/apex/apxconf.sql

PORT
———-
8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.

=========================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
=========================================================
Enter the administrator’s username [ADMIN]
User “ADMIN” does not yet exist and will be created.
Enter ADMIN’s email [ADMIN]
Enter ADMIN’s password []
Created instance administrator ADMIN.

Enter a port for the XDB HTTP listener [ 8080]
…changing HTTP Port

APEX configuration has been completed.

Step 11:-Check the HTTP port:

SQL> select dbms_xdb.gethttpport from dual;

GETHTTPPORT
———–
8080

Step 12:-Check the listener status and HTTP port is enabled,

[oracle@clone:apex clone] lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 29-MAY-2018 19:20:08

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=clone.localdomain.com)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 – Production
Start Date 25-MAY-2018 21:52:41
Uptime 3 days 21 hr. 27 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oradb/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File /oradb/app/oracle/diag/tnslsnr/clone/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clone.localdomain.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=clone.localdomain.com)(PORT=5500))(Security=(my_wallet_directory=/oradb/app/oracle/admin/CLONE/xdb_wallet))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clone.localdomain.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary…
Service “CLONE.localdomain.com” has 1 instance(s).
Instance “clone”, status READY, has 1 handler(s) for this service…
Service “cloneXDB.localdomain.com” has 1 instance(s).
Instance “clone”, status READY, has 1 handler(s) for this service…
The command completed successfully

Administration Services login page:

Step 13:-In Browser,Login as a ADMIN user:-

http://clone.localdomain.com:8080/apex/apex_admin

You have successfully logged into the Oracle APEX 18.1

 

Catch Me On:- Hariprasath Rajaram

LinkedIn:                  https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:                 https://www.facebook.com/HariPrasathdba
Facebook Group:   https://www.facebook.com/groups/894402327369506/
Facebook Page:      https://www.facebook.com/dbahariprasath/?
Twitter:                     https://twitter.com/hariprasathdba

 

 

 

 

 

Oracle-18c New Default Location of Oracle Database Password File

Oracle-18c New Default Location of Oracle Database Password File

Description:- 

The default location for the Oracle 18c Database password file is now in ORACLE_BASE instead of ORACLE_HOME.

  • Oracle Database password file placed in ORACLE_BASE instead of ORACLE_HOME its allows as Oracle home to be used as a static repository of database files.
  • This enables Oracle home to be configured in read-only mode and used as a software image that can be shared across multiple database servers. This simplifies patching and mass rollout as only one Oracle home image needs to be updated to distribute a patch to multiple database servers.

orapwd file=’$ORACLE_BASE/orapwtest18c’ password=oracle force=y format=12

Catch Me On:- Hariprasath Rajaram

LinkedIn:                  https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:                 https://www.facebook.com/HariPrasathdba
Facebook Group:   https://www.facebook.com/groups/894402327369506/
Facebook Page:      https://www.facebook.com/dbahariprasath/?
Twitter:                     https://twitter.com/hariprasathdba