Manually set local_listener at database level for service registration

Set local_listener at the database level  for service registration 



Set local_listener at DB levels 
-------------------------------------------

alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.43.200)(PORT=1521))'  scope=both;

alter system register ;


SQL> show parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      (ADDRESS = (PROTOCOL=TCP)(HOST
                                                 =192.168.43.36)(PORT=1521))

SQL>

sample listener.ora
-------------------------

[oracle@proddb19c admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/db_home/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.43.36)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@proddb19c admin]$

sample tnsnames.ora

----------------------------

[oracle@proddb19c admin]$ cat tnsnames.ora

orcl =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.43.36)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

      (UR = A)

   )

 )

[oracle@proddb19c admin]$

RPM required to enable X11 display

--------------------------------------------

yum install  xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-apps -y