Oracle Net Architecture

How to Resolve ORA-02082: a loopback database link must have a connection qualifier

by Ed Chen
April 22, 2017May 10, 2018
2 Comments

ORA-02082 When I tried to create a database link, it threw ORA-02082. SQL> create public database link BOSTON connect to SCOTT identified by SCOTT using… Read More »

Why Tnsping Hang

by Ed Chen
April 9, 2017March 25, 2023

sqlplus, tnsping or lsnrctl Hangs I can't cover all situations in this post, but I have some cases to share with you. Those hanging all… Read More »

How to Add a Public IP Address to Grid

by Ed Chen
January 15, 2017October 24, 2021

Strictly speaking, adding a public IP to server at OS-level is no problem, but you can't add any public IP to join any node of… Read More »

How to Add a SCAN VIP

by Ed Chen
December 23, 2016February 3, 2023

Preparation 1. Looking up SCAN name on DNS before adding a SCAN VIP [root@primary01 ~]# nslookup primary-cluster-scan Server: 10.0.0.199 Address: … Read More »

How to Resolve TNS-01106: Listener using listener name listener has already been started

by Ed Chen
December 15, 2016August 8, 2023
4 Comments

TNS-01106 Usually, TNS-01106 notifies you that the listener you want to start is already started. You don't have to start it again. If the listener… Read More »

How RAC Change Public IP

by Ed Chen
December 14, 2016February 13, 2023

Identify which interface that you should modify. [grid@oda0 ~]$ oifcfg getif -global bond0 10.0.18.0 global public ibbond0 192.168.2.0 global cluster_interconnect,asm OK, we found bond0 is… Read More »

How to Resolve The listener supports no services

by Ed Chen
November 5, 2016January 17, 2023
38 Comments

The listener supports no services Let's see the current status of listener. [oracle@primary01 ~]$ lsnrctl status ... Listener Log File /u01/app/oracle/diag/tnslsnr/primary01/listener/alert/log.xml… Read More »

What Symbols are Used in Oracle Database

by Ed Chen
May 5, 2016October 29, 2021

Several symbols that are used in Oracle might represent different meanings in different place. Question mark ? ORACLE HOME ? (a Question Mark) in a… Read More »

How RAC Change Subnet

by Ed Chen
January 16, 2016February 13, 2023

Oracle 12c uses 4 types of IP addresses to configure network of RAC: Public IP Private IP Virtual IP SCAN IP In which, Public IP,… Read More »

TNSPING, How and Why

by Ed Chen
July 22, 2014April 26, 2023

TNSPING Utility tnsping is a network testing utility provides by Oracle to test the availability of listener through the substrate of Oracle Net. Somebody may… Read More »

JavaScript is not enabled. Please enable it and reload the page.