Re: ORA-12154
Date: 1996/07/17
Message-ID: <4sisp1$gq6_at_mailhost.qsp.co.uk>#1/1
In <4sgiqu$ao2_at_newsserv.cs.sunysb.edu>, trubisz_at_cs.sunysb.edu (Joe Trubisz) writes:
>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
Sorry, but I avoid sqlnet like the plague, but until you get a better answer, heres to error message:
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.
Bye,
Steve
| any similarity 'tween my opinions and that | | of my employers are purely hypothetical | | and should give no cause for alarm | --------------------------------------------Received on Wed Jul 17 1996 - 00:00:00 CEST