ORCL.ANYWHERE.COM = <-- V805 is the service alias, ANYWHERE.COM is the domain (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = <-- section matches LISTENER.ORA (PROTOCOL = TCP) <-- protocol (Host = HOSTA.ANYWHERE.COM) <-- Database server host name or IP address (Port = 1521) <-- port the session will connect to ) ) (CONNECT_DATA = (SID = ORCL)) <-- sid = the database sid )The tnsnames.ora file should reside where your Oracle client software is installed in the folder networkadmin. The listener.ora will reside on the database server; in some cases, this may be your local machine if you have an Oracle database on your workstation or laptop. The listener.ora will contain information for your listener. When the listener is started, it will use the information in this file.
You can use the Oracle Net Configuration Assistant to create these files for you. On Windows NT, choose Start --> Programs --> Oracle – HOME_NAME --> Configuration and Migration Tools --> Net Configuration Assistant.
Dig Deeper on Oracle DBA jobs, training and certification
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.