OraFAQ Forum: Server Administration » problem starting oracle 8i and logging

Home » RDBMS Server » Server Administration » problem starting oracle 8i and logging

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem starting oracle 8i and logging [message #125215]

Thu, 23 June 2005 17:12

sureddi
Messages: 10
Registered: June 2005
Location: Houston

Junior Member

Hi,

I have a problem with oracle 8.i.

I installed oracle 8i(8.1.7) on windows server.Its worked fine.when i restart my system it was not working what was the reason.Before restarting IMP and EXP are not working at command prompt.So I restarted Now that are recognizing.But now oracle Problem.How to make oracle Running when my sytem starts.I check in the task manager Listner.ora is not running how to make it run when system starts and what are the files should run to make oracle run properly.

my listner file is below

# LISTENER.ORA Network Configuration File: D:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

STRACIT =
(DESCRIPTION_LIST =
(DESCRIPTION =

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev1)(PORT = 1521))
)
)

)

SID_LIST_STRACIT =
(SID_LIST =

(SID_DESC =
(GLOBAL_DBNAME = STRACIT)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = STRACIT)
)
)

My TNSNames.ora file is below

EXTPROC_CONNECTION_DATA.PICS-TDH.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

INST1_HTTP.PICS-TDH.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = STRACIT)
(PRESENTATION = http://admin)
)
)

STRACIT.PICS-TDH.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = STRACIT)
)
)

Bye
Sri

Report message to a moderator

Re: problem starting oracle 8i and logging [message #125310 is a reply to message #125215]

Fri, 24 June 2005 06:50

munishmsh
Messages: 15
Registered: May 2005
Location: Bangalore

Junior Member

First of all go to the Control Panel>>Adminstrator Tools>> Services and start the Oracle Service and also the Listener.

Otherwise start the service and then at the comamnd prompt type lsnrctl
C:\>
C:\> lsnrctl
LSNRCT> start
LSNRCTL> status

Hope that it should work again. If not just let me know.

Regards,
Munish

Report message to a moderator

Re: problem starting oracle 8i and logging [message #125423 is a reply to message #125215]

Fri, 24 June 2005 19:07

bodger
Messages: 3
Registered: June 2005

Junior Member

I found many problems getting SQL*Net to work, and one thing I would do if I were you is use the default listener name which is LISTENER. I was never successful using another name and it gave me so much trouble I don't care what it is called now it is working Cool

Use lsnrctl to start it because the Services in Control Panel will not give you error messages.

Report message to a moderator

Previous Topic:	Oradim is not creating OracleStartSid services
Next Topic:	Why the value of sequence will change after reboot?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 22 12:20:06 CDT 2025