| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: installation help
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
![]() |
![]() |