Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Ron Reidy Newsgroups: comp.databases.oracle.server Subject: Re: Problem in logging in to EXP Date: Thu, 06 Jun 2002 03:42:30 -0600 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <3CFF2E86.17913FDE@indra.com> X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 References: <96eccafc.0206052234.91a3f9d@posting.google.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: newsabuse@supernews.com Lines: 38 Xref: easynews comp.databases.oracle.server:149720 X-Received-Date: Thu, 06 Jun 2002 04:22:00 MST (news.easynews.com) Pinaki wrote: > > Hi, > Connecting to export is creating a problem.I am using the Oracle > Export tool.But after I enter the username/password@hoststring > (SCOTT/TIGER@HOSTSTRING for example) it says "NO > LISTENER,ORA-12154"...But I am able to connect to the database from > SQL PLUS using the same set of username/password@hoststring... > It would be really helpful if anybody could clarify where the problem > could be... > > Thanks, > Pinaki oerr ora 12154 12154, 00000, "TNS:could not resolve service name" // *Cause: The service name specified is not defined correctly in the // TNSNAMES.ORA file. // *Action: Make the following checks and correct the error: // - Verify that a TNSNAMES.ORA file exists and is in the proper // place and accessible. See the operating system specific manual // for details on the required name and location. // - Check to see that the service name exists in one of the // TNSNAMES.ORA files and add it if necessary. // - Make sure there are no syntax errors anywhere in the file. // Particularly look for unmatched parentheses or stray characters. // Any error in a TNSNAMES.ORA file makes it unusable. See // Chapter 4 in the SQL*Net V2 Administrator's Guide. If // possible, regenerate the configuration files using the Oracle // Network Manager. -- Ron Reidy Oracle DBA