Couldn't this also be
somealias_or_servicename1 eg mydb= (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP) (HOST=dbserver.yourdomain.com_or_IPADDRESS) (PORT=1521_or_port_matching_in_listener.ora) ) ) (CONNECT_DATA= (SERVICE_NAME=servicename1))) > In the init.ora for the database: > service_names = servicename1, servicename2, ... > > In the tnsnames.ora; > > servicename1= > (DESCRIPTION_LIST= > (DESCRIPTION= > (ADDRESS_LIST= > (ADDRESS=(PROTOCOL=TCP) > (HOST=dbserver.yourdomain.com) > (PORT=1521) > ) > ) > (CONNECT_DATA= (SERVICE_NAME=servicename1))) > > HTH > > Jared > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).