Message-Id: <10710.124541@fatcity.com> From: arun@ssind.stpn.soft.net (Arun Aggarwal) Date: Thu, 14 Dec 2000 15:19:20 +0530 Subject: Re: no listener Just set the ORACLE_SID environment variable before starting the svrmgrl. In Windows NT, from command prompt set ORACLE_SID = (ORCL by default) then start the svrmgrl. this Should solve your problem Arun ----- Original Message ----- From: "Ura!" To: "Multiple recipients of list ORACLE-L" 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@ymz.yaroslavl.ru > Ura! > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ura! > INET: ura@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@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