If you want to use a Oracle Net service name, you must apply following steps to configure Oracle Net on the client side (tnsnames.ora) and on the server side (instance configuration):1.Configure tnsnames ora:mytns = (DESCRIPTION= (ADDRESS = (PROTOCOL = TCP)(HOST = pbell)(PORT = 1395)) (CONNECT_DATA= (SERVICE_NAME=myservice)))

2. Configure the instance with the right service name and to register to the right listeneralter system set service_names=myservice;alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=pbell)(PORT=1395))'alter system register;

Wait 60 seconds and check:$ tnsping mytns

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 25-MAY-2009 12:39:56