Re: TNS-03505: Failed to resolve name

From: AleX <korrozia_at_my-dejanews.com>
Date: Wed, 19 May 1999 23:46:02 GMT
Message-ID: <7hvifq$rs8$1@nnrp1.deja.com>

I think that you get 3505 when your computer name has () in it. Check SQLNET log file and see what the host parameter equals to.

In article <7hsak7$opb$1_at_oac2.hsc.uth.tmc.edu>,   "Andy B." <andyb_at_mdacc.tmc.edu> wrote:
> I'm still fairly new to Oracle and it's network components so bear
with me
> here...
>
> Config: RS/6000, AIX 4.2, Oracle 7.3.2
>
> I inheirited the above system with one instance (MAIN) and three
databases
> (DEV, TEST, PROD). I've created three new instances (DEVL, TEST,
PROD).
> All are up and running and I can connect to them from my NT
workstation. If
> the $ORACLE_SID is set, I can connect to the instance. What I can't
do is
> connect to the new instances without explicitly resetting the
$ORACLE_SID.
> I can't TNSPING them either. The original instance works every time
though.
>
> I've gone over the listener.ora and tnsnames.ora many times over and
can't
> figure out the problem. I've searched the file system for duplicates
and
> eliminated them when I found them, but still the problem persists.
>
> I manage NT systems in addition to this and have never had this
problem on
> them. I know I must be missing something fairly simple here...
>
> Does anyone have any ideas?
>
> Thanks in advance,
> Andy
>
>

--

                 Alex Shterenberg

"I hate people. I think they should suffer as much as  possible, and therefore I'm into those old communist

         dictatorships." - Euronymous, Mayhem

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 18:46:02 CDT