Pinaki wrote:
>
> Hi,
> Connecting to export is creating a problem.I am using the Oracle
> Export tool.But after I enter the username/password_at_hoststring
> (SCOTT/TIGER_at_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_at_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
Received on Thu Jun 06 2002 - 04:42:30 CDT
