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

Home -> Community -> Usenet -> c.d.o.server -> Re: ServerManager (Can't connect on SQL*NetV2 ?)

Re: ServerManager (Can't connect on SQL*NetV2 ?)

From: Claudio Roca <factory_at_impsat1.com.ar>
Date: 1997/02/13
Message-ID: <3303820E.66EB@impsat1.com.ar>#1/1

Yasuhiro Yoshida wrote:
>
> Dear Oracle Users.
>
 

> [ Enviorment ]
> Server HP9000 HPUX10.01
> Oracle7.1.6.2.0
> Client Sun Solaris 2.5.1
>
> [ TestCase ]
> ---- ServerManager: Release 2.1.4.0.0 ----
> SVRMGR> connect system/manager_at_mammoth.test
> ORA-12154: TNS:could not resolve service name
> SVRMGR> connect system/manager_at_t:mammoth:test
> Connected.
>
> ---- SQL*Plus: Release 3.2.3.0.0 ----
> SQL> connect system/manager_at_mammoth.test
> Connected.
> SQL> connect system/manager_at_t:mammoth:test
> Connected.
>
> ---- SQL*DBA: Release 7.2.3.0.0 ----
> SQLDBA> connect system/manager_at_mammoth.test
> Connected.
> SQLDBA> connect system/manager_at_t:mammoth:test
> Connected.
>
> ====================================================
> Yasuhiro Yoshida
> yosida_at_wtank.csk.co.jp
> ====================================================
If you want to connect with the string '@mammoth.test', you have to define that name in a file named 'tnsnames.ora' in the server machine. If you don't do this TNS will never resolve the name. Take a look at that file, because if any parenthesys do not match TNS will never resolves too.
Hope this helps. Received on Thu Feb 13 1997 - 00:00:00 CST

Original text of this message

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