Re: ORA-12154

If you've created a new db, ensure that there is a Listener service for the new DB instance.

Check LISTENER.ORA (at least on Windows NT) to see if the service for the new DB instance exists.

Otherwise, stop the service and add the service & restart the service.

HTH Adwait

Ken Mizuta wrote:
>
> Joe Trubisz wrote:
> >
> > Hi...
> >
> > We have a Oracle database running on a SunOS 7.1.3 system and we are trying to
> > access it via Personal Oracle 7, via TCP and WIndows-95. We are using SQL*NET
> > V2. When we try to start a sqlplus session, we get a ORA-12154 error which is
> > not listed in any of the error codes. Can anyone help here????
> >
> > As an aside, someone heard that when you type in the host string at the
> > sqlplus prompt, you should use TNS: rather than T:. Not that it makes a diff
> > regarding the prior question, but is this true??
> >
> > Thanks in advance,
> > Joe
>
> 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.
>
> As for the tns: instead of t:, it's the first I've ever heard. I
> have never known anyone to use tns:. In fact, I tried it and it didn't
> work. I get ORA-6401: Invalid driver designator.
>
> --
> ____________________________________________
> / Kenichi Mizuta
> //// / Oracle Corporation (Redwood Shores, CA)
> |0 0| / Applications Division
> _ooO_ \U/_Ooo_/ email: kmizuta_at_us.oracle.com
> The comments and opinions expressed herein are mine and
> do not necessarily represent those of Oracle Corporation.
 

-- 
=============================================
AumSoft Consultants,  | Solving business     
202 Calvert Dr. #105  | problems through     
Cupertino CA 95014    | technology           
adwait_at_scruznet.com   | VB, SQL Server,      
(408) 255-2083 (Voice)| Telephony, SQLWindows
=============================================