how to create listener ora and tnsnames ora files for oracle DB

Поделиться
HTML-код
  • Опубликовано: 10 сен 2024
  • how to create listener ora and tnsnames ora files for oracle DB
    listener.ora
    LISTENER_DBTECH =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.209.186)(PORT = 1621))
    )
    )
    )
    SID_LIST_LISTENER_DBTECH =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = dbtech)
    (ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
    )
    )
    tnsnames.ora
    dbtech=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.209.186)(PORT = 1621)))(CONNECT_DATA =(SERVICE_NAME=dbtech)))
    sqlplus sys/welcome@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.209.186)(PORT = 1621)))(CONNECT_DATA =(SERVICE_NAME=dbtech)))' as sysdba
    ALTER SYSTEM SET LOCAL_LISTENER='(ADDRESS=(PROTOCOl=TCP)(HOST=192.168.209.186)(PORT=1621))' SCOPE=BOTH;

Комментарии • 3

  • @shivarajulvekar5752
    @shivarajulvekar5752 3 месяца назад

    You have explained it very well. Thank you for making us understanding in simpler manner. Thank you sir

  • @dareanddashing2871
    @dareanddashing2871 5 месяцев назад

    good information

  • @nageswarareddyallu3365
    @nageswarareddyallu3365 7 месяцев назад

    Nice explanation sir,
    Can you please create a new video about asm disk