Database (237) 썸네일형 리스트형 61 - [Oracle 19C] Oracle Net Manager (netmgr) Add Listener.ora Add tnsnames.ora 60 - [Oracle 19C] Oracle net configuration assistant(netca) Tools to configure listeners - Oracle Net Manager(netmgr) - Oracle Net Configuration Assistant(netca) - Listener Control utility - Enterprise Manager Cloud Cntrol - Database Configuration Assistant(allows you to create a listener when you create a CDB) # add listener [oracle@test admin]$ netca Oracle Net Services Configuration: Configuring Listener:LISTENER_TEST Listener configuration complete. .. 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.. 58 - [Oracle 19C] Starting multi-instance & listener [oracle@test trace]$ echo $ORACLE_SID orcl [oracle@test trace]$ export ORACLE_SID=hong [oracle@test trace]$ echo $ORACLE_SID hong [oracle@test trace]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 30 13:57:01 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System G.. 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.. 55 - [Oracle 19C] The default listener - exercise 리스너 파일(listener.ora)이 어떤 역할을 하는지 몇가지 테스트를 통해서 확인해 봅시다 listener.ora 내용 [oracle@test admin]$ ll 합계 16 -rw-r----- 1 oracle oinstall 328 11월 11 00:59 listener.ora drwxr-xr-x 2 oracle oinstall 64 4월 17 2019 samples -rw-r--r-- 1 oracle oinstall 1536 2월 14 2018 shrept.lst -rw-r----- 1 oracle oinstall 187 11월 11 00:59 sqlnet.ora -rw-r----- 1 oracle oinstall 1015 11월 28 15:54 tnsnames.ora [oracle@test ad.. 54 - [Oracle 19C] The default listener LISTERNER is automatically populated with available database services through a feature called dynamic service registration. LISTERNER listens on the following TCP/IP protocol address: ADDRESS=(PROTOCOL=TCP) (HOST=HOST_NAME) (PORT=1521)) Without any configuration, you can access your database instance immediately through LISTERNER. If the listerner name is LISTERNER and it cannot be resolved, a .. 이전 1 ··· 20 21 22 23 24 25 26 ··· 30 다음
