Re: installation help

Regarding the ORA-12560 error:

   is the service "OracleServiceHOME" started?

        C:\> net start ORacle ServiceHOME

   is the environment variable "ORACLE_HOME set?"

        C:\> set ORACLE_SID=HOME

Regarding the ORA-12154 error:

  is the parameter

        NAMES.DEFAULT_DOMAIN   populated in the file sqlnet.ora?

   try:

        C:\> tnsping home. < notice the use of the period

   as this will prevent the default domain from being appended.

Also:

   svrmgrl uses a bequeathed connection, not a tns connection.

in the initHOME.ora - what is the value(s) for the parameter "service_names"?

> home =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = main)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = home.world)
> )
> )

hth,

Paul

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.
> Where I can found that in windows 2000
Received on Thu Aug 30 2001 - 01:23:50 CDT