Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ServerManager (Can't connect on SQL*NetV2 ?)
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