Re: no listener

From: Arun Aggarwal <arun_at_ssind.stpn.soft.net>
Date: Thu, 14 Dec 2000 15:19:20 +0530
Message-Id: <10710.124541@fatcity.com>

Just set the ORACLE_SID environment variable before starting the svrmgrl.

In Windows NT, from command prompt

set ORACLE_SID = <your SID>(ORCL by default) then start the svrmgrl.

this Should solve your problem

Arun
----- Original Message -----
From: "Ura!" <ura_at_ymz.yaroslavl.ru>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, 14 December, 2000 01:25 PM Subject: TNS: no listener

> Hi dear ALL
> --------------------------------------
> ORA-12541 error occured.
> I am beginer oracle admin.
> I just now install Oracle server 8i on winNT4.
> I try to logon server as sysdba from svrmgrl
> connect sys/pass as sysdba
> and accept this error.
> My tnsnames file:
> ORANT.UAS =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = OraNT)
> )
> )

> ORANT =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = 127.0.0.1)
> (Port = 1521)
> )
> )
> (CONNECT_DATA = (SID = ORANT)
> )
> )
> My listener file:
> # D:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration
File:D:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
> # Generated by Oracle Net8 Assistant

> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> (PROTOCOL_STACK =
> (PRESENTATION = TTC)
> (SESSION = NS)
> )
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
> (PROTOCOL_STACK =
> (PRESENTATION = TTC)
> (SESSION = NS)
> )
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 2481))
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> )
> )

> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\Oracle\Ora81)
> (PROGRAM = extproc)
> )
> )
> Where is bug?

>
>
>
>
>


> --------------------------------------

> ura_at_ymz.yaroslavl.ru
> Ura!

>
>

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ura!
> INET: ura_at_ymz.yaroslavl.ru

>


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Dec 14 2000 - 03:49:20 CST