Oracle Home

How to Move ORACLE HOME

Posted on
Allow me to ask you a question before going further: why would you like to move ORACLE HOME to another place? You may leave your comment below this post, I am curious about it. As for me, it’s because my client like old-fashioned file structure and don’t like Optimal Flexible Architecture (OFA) to be used, […]
Listener

How to Add Static Service Registered in Listener

Posted on
Static Service Registration Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service can be used to service external connections with or without a running instance on the server. According to Oracle 18c Advanced Features of Oracle Net Services, the use […]
Listener

How to Resolve The listener supports no services

Posted on
The Listener Supports Services
The listener supports no services I newly created a database called SMALLDB, but I can’t see any service registered with the new LISTENER2 which is listening to incoming connections from port 1522. The listener showed “The listener supports no services”. In fact, this message tells us that the listener is working fine, but no dynamic […]
Data Guard

Building a Physical Standby Database (02/14) – Prepare configuration files on both sides

Posted on
Building a Physical Standby Database (01/14) – Install an empty database on standbyThere are four configuration files needs to be prepared on both sides, the first three are network-related, the last one is for remote authentication of users with SYSDBA:/etc/hostsRegister all domain information of four nodes on it, for example:[root@primary01 ~]# vi /etc/hosts#Public10.1.1.1    primary01.example.com […]