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 […]
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 […]
Firewalld

How to Resolve TNS-12535: TNS:operation timed out

Posted on
TNS-12535 Let’s see how we reproduce TNS-12535. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 22-JUL-2014 19:03:21 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) […]
SQLNET

How to Resolve TNS-12545: Connect failed because target host or object does not exist

Posted on
TNS-12545 Let’s see how we reproduce TNS-12545. C:\Users\ed>tnsping compdb TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 – Production on 21-JUL-2014 19:10:59 Copyright (c) 1997, 2013, Oracle.  All rights reserved. Used parameter files: C:\oracle\app\client\ed\product\12.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = primary01)(PORT = 1521)) […]
Linux

How to Build 18c RAC – 1 of 4 – Preparing Two Database Servers

Posted on
Network Design for RAC Let’s see the network design of our cluster database. [root@primary01 ~]# vi /etc/hosts # Public 192.168.10.11 primary01 primary01.example.com 192.168.10.12 primary02 primary02.example.com # Private 192.168.24.11 primary01-priv primary01-priv.example.com 192.168.24.12 primary02-priv primary02-priv.example.com # VIP 192.168.10.111 primary01-vip primary01-vip.example.com 192.168.10.112 primary02-vip primary02-vip.example.com # SCAN # 192.168.10.81 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.82 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.83 primary-cluster-scan primary-cluster-scan.example.com […]
Listener

How to Resolve Endpoint Listener is Not Listening to Public IP

Posted on
I found that I can connect the database via VIP or SCAN, but not Public IP. I checked the endpoint listener. It did not listen the public IP. [grid@primary01 ~]$ cat $ORACLE_HOME/network/admin/endpoints_listener.ora #Backup file is  /u01/app/12.1.0/grid/network/admin/endpoints_listener.ora.bak.primary01 line added by Agent LISTENER_PRIMARY01=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=primary01-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)(IP=FIRST))))         # line added by Agent It was listening 127.0.0.1, no […]
Public IP

How to Change Public IP within Same Subnet of Grid

Posted on
Identify which interface that you should modify[grid@oda0 ~]$ oifcfg getif -globalbond0  10.0.18.0  global  publicibbond0  192.168.2.0  global  cluster_interconnect,asmOK, we found bond0 is the public IP interface.Modify /etc/sysconfig/network-scripts/ifcfg-bond0[root@oda0 ~]$ vi /etc/sysconfig/network-scripts/ifcfg-bond0…IPADDR=10.0.18.5#IPADDR=10.0.18.218…Modify /etc/hosts and DNS[root@oda0 ~]$ vi /etc/hosts…10.0.18.5    oda0 oda0.example.com#10.0.18.218    oda0 oda0.example.comRestart network[root@oda0 ~]$ service network restartYou may lost connection to the console.Restart clusterware stack by […]
Linux

/etc/hosts Does Not Work on Linux or Windows?

Posted on
/etc/hosts or C:WindowsSystem32driversetchosts is a file for resolving the domain name in a local manner. If you set it incorrectly, you will see no effects on resolving domain name. For example, we add a mapping record to the file like this:[root@test ~]# vi /etc/hosts…server01 10.7.132.12[root@test ~]# ping -c 4 server01ping: unknown host server01The above record is […]