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: installation help

Re: installation help

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Wed, 29 Aug 2001 02:42:35 GMT
Message-ID: <3B8C5697.33B55C1F@pro-ns.net>


Louis Mallette wrote:

> First I have install windows 2000 server on my penthium 2 (400 meg ram)
>
> 2- I have install Oracle 8i Entreprise Edition (server)
>
> 3- I name my database : home
>
> 4- When I go to Srvmgr:
>
> I wrote CONNECT INTERNAL/ORACLE and i have the Error ORA-12560 TNS:
> protocole Error
>
> 5- When I go to the Oracle SQLPlus app. and i try to connect like that
>
> id: system
> pass: manager
> Host string: home.world
>
> This Error append: ORA-12154 TNS:counld not resolve service name
>
> there are my Listener code
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = main)(PORT = 1521))
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = home.world)
> (ORACLE_HOME = d:\oracle\ora81)
> (SID_NAME = home)
> )
> )
>
> there are my tnsnames code
>
> home =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = main)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = home.world)
> )
> )
>
> How i can verifie that my host and my port number is the good one.

Your port number is what you see in listener.ora file, i.e. 1521. To test your host name, run ping command from dos window:

ping main

look at the output. If it chows correct ip address, hostname is correct. I don't remember if windows has hostname command. Try hostname from dos window. If such command exists, it will return your hostname.

By the way, are you sure listener is running?

>
> Where I can found that in windows 2000
Received on Tue Aug 28 2001 - 21:42:35 CDT

Original text of this message

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