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;
You have explained it very well. Thank you for making us understanding in simpler manner. Thank you sir
good information
Nice explanation sir,
Can you please create a new video about asm disk