LISTENER (3) 썸네일형 리스트형 59 - [Oracle 19C] Creating static listener example 1. adding SID_LIST into listener.ora [oracle@test admin]$ echo $ORACLE_HOME /u01/app/oracle/product/19/db_1 SQL> show parameter instance NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ active_instance_count integer cluster_database_instances integer 1 instance_abort_delay_time integer 0 instance_groups string instance_mode string READ-WRITE instanc.. 57 - [Oracle 19C] Creating dynamic listener example 새로운 동적인 리스너를 추가하는 방법 1. tnsnames.ora 수정 - LISTENER2 추가 2. listener.ora 수정 - LISTENER2 추가 3. update local_listener [oracle@test ~]$ cd /u01/app/oracle/product/19/db_1/network/admin/ [oracle@test admin]$ ll 합계 28 -rw-r----- 1 oracle oinstall 452 11월 29 22:24 listener.ora -rw-r----- 1 oracle oinstall 328 11월 29 22:24 listener23112910PM2442.bak drwxr-xr-x 2 oracle oinstall 64 4월 17 2019 samples -rw-.. 56 - [Oracle 19C] The default listener - non-default port Non-default port - to change PORT as 1529 [oracle@test admin]$ cat listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/19/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1529)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) port is 1529 [or.. 이전 1 다음
