instance (2) 썸네일형 리스트형 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.. 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 다음