{データベースの作成その他}listener.oraの送受信バッファを設定

演習

 

https://docs.oracle.com/cd/F19136_01/netrf/oracle-net-listener-parameters-in-listener-ora.html#GUID-0997093A-6725-4876-ADC0-E94132E07887


cdh
cd network
cd admin

cat listener.ora

vi listener.ora

LISTENER_2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = mmm111.example.com)(PORT = 1622)
      (RECV_BUF_SIZE=11784)(SEND_BUF_SIZE=11280))
  )
SID_LIST_LISTENER_2 =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl.example.com)
      (SID_NAME = orcl)
      (ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
    )
  )

lsnrctl start listener_2
lsnrctl status listener_2

sqlplus test/test@mmm111:1622/orcl.example.com