Tnsnames.ora

vi Editor Commands Reference for Oracle DBAs Every Oracle DBA on Unix or Linux ends up in vi whether they planned to or not. It opens by default when you crontab -e, it is what visudo drops you into, and it is the editor on most Oracle Linux and AIX hosts before anyone has installed nano or configured EDITOR. Knowing …

Sample tnsnames.ora Dedicated Server Entry (with ASM) Purpose The tnsnames.ora file is the client-side address book for Oracle Net. Each entry maps a short alias (SCR9) to a full network address — protocol, host, port, and target service. Without a working tnsnames.ora entry, sqlplus, rman, and any application using …