Menu

18 Ocak 2017 Çarşamba

Oracle Change Listener Default Name

Oracle Change Listener Default Name


$ ps -ef | grep tns

oracle    9214     1  0 12:51 ?        00:00:00 /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr LISTENER -inherit


$ lsnrctl stop LISTENER
[oracle@easlan ~]$ lsnrctl stop

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully

$ $ORACLE_HOME/network/admin and modify Listener.ora

[oracle@easlan ~]$ cd /u01/app/oracle/product/11.2.0/db_1/network/admin/

SID_LIST_EASLAN=
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

EASLAN =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = easlan.localdomain)(PORT = 1521))
    )
  )


Step Four :

lsnrctl start EASLAN


Step Five :

SQL> show parameter local_listener

SQL> alter system set local_listener='(address=(protocol=tcp)(host=your-hostname)(port=1521))';
SQL> alter system register;

Hiç yorum yok:

Yorum Gönder