|
Установка oracle 19.3 и смена порта 1523 на 1521
|
|||
---|---|---|---|
#18+
Установил Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 При установке LISTENER-а не отобразилось задание порта... Или я что-то пропустил... Короче после установки имею порт 1523: # listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Centos77190-001)(PORT = 1523)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523)) ) ) # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_SIDBT = (ADDRESS = (PROTOCOL = TCP)(HOST = Centos77190-001)(PORT = 1523)) SIDBT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Centos77190-001)(PORT = 1523)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sidbt) ) ) [oracle@Centos77190-001 admin]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-NOV-2020 08:28:04 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Centos77190-001)(PORT=1523))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 21-NOV-2020 08:26:37 Uptime 0 days 0 hr. 1 min. 26 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/Centos77190-001/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Centos77190-001.moon.lan)(PORT=1523))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1523))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=Centos77190-001.moon.lan)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/admin/sidbt/xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "sidbt" has 1 instance(s). Instance "sidbt", status READY, has 1 handler(s) for this service... Service "sidbtXDB" has 1 instance(s). Instance "sidbt", status READY, has 1 handler(s) for this service... The command completed successfully --- И как бы все работает... решил поменять порт 1523 на 1521: # listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Centos77190-001)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_SIDBT = (ADDRESS = (PROTOCOL = TCP)(HOST = Centos77190-001)(PORT = 1521)) SIDBT = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Centos77190-001)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sidbt) ) ) [oracle@Centos77190-001 admin]$ lsnrctl reload LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-NOV-2020 08:13:55 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Centos77190-001)(PORT=1521))) The command completed successfully [oracle@Centos77190-001 admin]$ lsnrctl stop LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-NOV-2020 08:23:15 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Centos77190-001)(PORT=1521))) The command completed successfully [oracle@Centos77190-001 admin]$ lsnrctl start LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-NOV-2020 08:23:22 Copyright (c) 1991, 2019, Oracle. All rights reserved. Starting /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/Centos77190-001/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Centos77190-001.moon.lan)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Centos77190-001)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 21-NOV-2020 08:23:22 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/Centos77190-001/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Centos77190-001.moon.lan)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully [oracle@Centos77190-001 admin]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-NOV-2020 08:23:52 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Centos77190-001)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 21-NOV-2020 08:23:22 Uptime 0 days 0 hr. 0 min. 30 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/Centos77190-001/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Centos77190-001.moon.lan)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully --- Т.е. не выходит каменный цветок Может что-то еще надо стартовать или изменить ? Пришлось пока вернуть все обратно. ... |
|||
:
Нравится:
Не нравится:
|
|||
21.11.2020, 09:00 |
|
Установка oracle 19.3 и смена порта 1523 на 1521
|
|||
---|---|---|---|
#18+
Вопрос вроде не в портах, а в регистрации БД. Можно разбираться с динамической, можно прописать статическую. ... |
|||
:
Нравится:
Не нравится:
|
|||
21.11.2020, 09:35 |
|
Установка oracle 19.3 и смена порта 1523 на 1521
|
|||
---|---|---|---|
#18+
dmdmdm Вопрос вроде не в портах, а в регистрации БД. Можно разбираться с динамической, можно прописать статическую. Но LISTENER вроде после установки софта oracle устанавливается... и в нем прописывается порт... Я вот подумал, а если в Код: plsql 1.
удалить LISTENER и заново создать ? Такое пройдет ? Или По идее надо удалить БД... И устанавливать БД заново ? ... |
|||
:
Нравится:
Не нравится:
|
|||
21.11.2020, 09:47 |
|
Установка oracle 19.3 и смена порта 1523 на 1521
|
|||
---|---|---|---|
#18+
Можно и проблему "принтер не подключается" решать переустановкой Windows. ... |
|||
:
Нравится:
Не нравится:
|
|||
21.11.2020, 09:50 |
|
Установка oracle 19.3 и смена порта 1523 на 1521
|
|||
---|---|---|---|
#18+
dmdmdm Можно и проблему "принтер не подключается" решать переустановкой Windows. ... |
|||
:
Нравится:
Не нравится:
|
|||
21.11.2020, 09:52 |
|
Установка oracle 19.3 и смена порта 1523 на 1521
|
|||
---|---|---|---|
#18+
Владимир СА, Вам уже все подсказали: динамическая регистрация listener Дока LOCAL_LISTENER ALTER SYSTEM alter system... REGISTER Clause Specify REGISTER to instruct the PMON background process to register the instance with the listeners immediately. If you do not specify this clause, then registration of the instance does not occur until the next time PMON executes the discovery routine. As a result, clients may not be able to access the services for as long as 60 seconds after the listener is started. ... Код: plsql 1. 2.
... |
|||
:
Нравится:
Не нравится:
|
|||
21.11.2020, 10:13 |
|
|
start [/forum/topic.php?fid=52&tid=1880681]: |
0ms |
get settings: |
9ms |
get forum list: |
14ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
175ms |
get topic data: |
12ms |
get forum data: |
3ms |
get page messages: |
49ms |
get tp. blocked users: |
2ms |
others: | 18ms |
total: | 290ms |
0 / 0 |