Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PLEASE HELP!!! Error ORA-12154

Re: PLEASE HELP!!! Error ORA-12154

From: miguel <jmiguel_at_cet.pt>
Date: 1998/10/21
Message-ID: <01bdfce9$cee2ee00$0a0a2c0a@jmiguel.intra.cet.pt>#1/1

ORA-12154 TNS:Could not resolve service name

Cause:The service name specified is not defined 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 Administrator's Guide. If possible regenerate the configuration files using the Oracle Network Manager.

Pedro Silva <Pedro.Silva_at_rnl.ist.utl.pt> wrote in article <700ivq$ikg$1_at_ci.ist.utl.pt>...
> I've tried to install Oracle 7 (7.2 I think) and I create a database,
> but when I try to access it I receive a ERROR: ORA-12154 General
 Connection
> Error. Can't connect database or unavaiable.
>
> I have all the TCP/IP installed AND working, and I also use the
 correct
> hostname when creating database in installation.
>
> I am desperate because of this...
> Already tried in 3 different machines with NT 4.0, NT 3.51 and W95. I
> need it working in NT 4.0.
>
> What can I do? Also the error isn't specified in the manual.
>
> Please help me!!!
> THANKS!!
>
> Reply to: Pedro.Silva_at_rnl.ist.utl.pt
>
>
>
Received on Wed Oct 21 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US