분류 전체보기 (668) 썸네일형 리스트형 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 .. 53 - [Oracle 19C] To create a new Instance If you wish to use a different listener port number, select 'Create a new listener.' ~/StudioProjects/oracle$ cat *.ora ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle88)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.com) ) ) [oracle@test admin]$ sqlplus sys/Manager123#@ORS as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 28 16:36:00 2023 V.. 52 - [Oracle 19C] Unplugging & Plugging part2 SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter pluggable database all open; Pluggable database altered. SQL> select con_id, name, open_mode from v$pdbs; CON_ID NAME OPEN_MODE ---------- -------------------- ---------- 2 PDB$SEEDREAD ONLY 3 ORCLPDBREAD WRITE 4 PDB1 READ WRITE 5 PDBTESTREAD WRITE SQL> alter session set container=pdbtest; Session altered. SQL> select.. 51 - [Oracle 19C] Unplugging & Plugging part1 Unplugging a PDB is disassociating the PDB from its CDB Plugging in a PDB is associationg a PDB with a CDB You can plug a PDB into the same or another CDB 1. Close the pdb1 2. Unplug pdb1 to xml 3. Drop the pdb1 but we keep the datafiles 4. Check compatibility 5. Plug the pdb1 using the xml SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter pluggable database all open.. 50 - [Oracle 19C] Cloning PDBs Cloning is copying a source PDB from a CDB and plugging the copy into the same CDB or another CDB Must be connected to a CDB and the current container must be the root Must have the CREATE PLUGGABLE DATABASE system privilege The CDB in which the PBD is being created must be in READ WRITE mode option) It is better you can put the PDB being cloned into READ ONLY mode before you can clone it SQL> s.. 이전 1 ··· 22 23 24 25 26 27 28 ··· 84 다음
