Example of the tnsnames.ora file
Prev Setting up the Oracle database instance Next

Example of the tnsnames.ora file

The tnsnames.ora file is a configuration file that defines connection parameters for your Oracle database instance. By default, tnsnames.ora resides in the following location:

Solaris

Oracle_HOME/network/admin

Windows

Oracle_HOME\network\admin

The following is an example of the tnsnames.ora file:

CCER =
	(DESCRIPTION = 
		(ADDRESS = (PROTOCOL = TCP) (HOST = host.symantecexample.com) 
(PORT = 1521)
		(CONNECT_DATA = 
			(SERVER = DEDICATED)
			(SERVICE_NAME = CCER)
	)
)
Prev Up Next
Verifying that the Oracle TNS listener is running Home Example of the listener.ora file