Posts

Showing posts from April, 2020

Change the Hostname the Listener has been Configured with from Fully Qualified Domain Name to Localhost

Changing  the Hostname the Listener has been Configured  During the installation of E1Local instance on a Development Client, the listener is configured to listen on the hostname or Fully Qualified Domain Name (FQDN). Everything works fine on Development Client, but it is required to secure the inbound communication on Development Client and allow inbound connections only for localhost and exclude the communication using hostname or Fully Qualified Domain Name. In order to change the hostname the Listener was configured with during the E1Local installation on a Development Client, please follow the below action plan: Open a command prompt and change directory to E1Local\Bin folder Open a second command prompt and change directory to E1Local\Bin Connect to E1Local with the below command. Before this make sure that in sqlnet.ora, SQLNET.AUTHENTICATION_SERVICES=(NTS) is set. sqlplus / as sysdba Stop the listener with: lsnrctl stop   In listener.ora, chang...