Home » RDBMS Server » Server Administration » problem starting oracle 8i and logging
problem starting oracle 8i and logging [message #125215] Thu, 23 June 2005 17:12 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Oct 21 13:02:49 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.