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