Re: TNS problem-question

[Wendy Biggs <biggswl@VT.EDU>]

Ben,

When *I* get "TNS:could not resolve service name" errors, it means that
I misspelled the sid.

I'm not sure how your program is logging your/a userid into the oracle
instance and so I can't say that your problem is the same... but
essentially Oracle is saying "I can't find an instance with that name in
the TNSNAMES file... it is possible but not likely that someone is
fiddling with the TNSNAMES file but more likely a misspelling or missing
link.

Are you familiar with the TNSNAMES.ORA file?

--wb
--
"It should be challenging, but not impossible, to come up with an
acceptable password."
Karen Herrington - New criteria for Oracle passwords



Ben Le wrote:
>
> Once in a while the following abort happens when we run the SQR program at
> the Unix prompt:
> "(SQR 5528) ORACLE OCILogon error 12154 in cursor 0:
>   ORA-12154: TNS:could not resolve service name
>   (SQR 4701) Cannot logon to the database.
>   SQR: Program Aborting."
>
> Then next day runs fine. Does any body encounters this problem? How do you
> fix it? Thanks in advance.
>
> Oracle 8.1.5
> Hp-Ux 11.1
> SQR 6.0 for Unix
> SCT Banner 4.x
>
> 
>--------------------------------------------------------------------------------------------------------------------------------
> Benjamin Le
> ITS, System Development
> Portland Community College
> 12000 SW 49th Ave. Portland, Oregon 97219
> (503)-977-4970  Fax: (503)-977-4987
> Mailto:ble@pcc.edu      http://www.pcc.edu
> 
>--------------------------------------------------------------------------------------------------------------------------------