Does any one has the steps to secure Listener for 11g rel 2 (22.214.171.124) using SECURE_REGISTER_LISTENER ?
We are using TCP and using Data guard but NOT RAC.
I put the below entry in the listener.ora and did the stop and start of the listener but not sure if there is some additional steps. ( I saw on Google that there is some sql to update the local_listener but some just put this below entry and reload the listener).
I will check with experts.
I did the below 2 steps:---
1. Update listener.ora file with this entry
SECURE_REGISTER_LISFLLPRD = (TCP)
(Where LISFLLPRD is my listener name)
2. stop and start the listener.
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines