Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Closed Thread
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old March 18th, 2004, 04:22 AM
SeaBird505 SeaBird505 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 25 SeaBird505 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 54 m 50 sec
Reputation Power: 0
Oracle 8i Intelligent Agent Service problem

Hi!
We successfully installed Oracle 8i (8.1.7 ee) on Intel P-IV (Xeon) server running Windows 2000 Advanced server (Service Pack 2). It was working properly until now. There was no problem in implementing the tricks useful in installation. After that, database service "OracleService<DBName>" presented problem by not automatically starting on computer startup but it was tamed by "Oradim" command added to startup folder.

All was going smoothly for about a month now but when I rebooted the server PC yesterday, the service "Oracle<HomeName>Agent" failed to start. Along with it the DataGatherer and TNSListener services also failed (Only db service OracleService<DBName> starts but very very slowly). The Windows Event Viewer descriped the problme for Agent service as ,"The Oracle<HomeName>Agent service terminated with the following error: %%3221356551 ". The Event ID is always 7023 for this error. The rest of services just don't give any error codes. It is also stated that nothing has been installed/Uninstalled on this PC in the last several days and no configration changes, in tnsnames.ora, sqlnet.ora, listener.ora, win registry has been made. The TCP/IP configration are intact and NTFS folder and file rights are properly defined.

Starting the service using "Net Start <service_name>" also failed with the message,"System error 7 has occured, Storage control blocks will be destroyed".

Searching online, I also performed some steps in correcting the problem like backup and delete all *.q, snmp_ro.ora, snmp_rw.ora, services.ora files. But to no help. The log files in Oracle_Home\network\logs also dont record the problem even after setting the trace level to Admin or 16. The Agent service simply refuses to start...

Reinstalling Oracle (over existing one, not first removing it altogether. We simply cann't do this now for data loss!!!) or just the Intelligent Agent itsself using univeral installer also fails at the end when it tries to start the intellegent Agent Service Oracle<HomeName>Agent. This time the error described is "O/S error in starting service".

Is this something to do with Xeon server coz the same Oracle 8i is installed much before than this on another P-IV server (not xeon) running the same Op system and it never presented us this problem todate. Its also worth mentioning that this problem occured before as well, on the second day we installed Oracle 8i the first time on Xeon. Since there was no data then, we simply removed oracle, cleared registry and started all over again BUT now it cann't be done.

Any help shall be highly appreciated.

With Regards, Rashid.
SeaBird505 at yahoo.com

Reply With Quote
  #2  
Old March 18th, 2004, 07:00 AM
SeaBird505 SeaBird505 is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 25 SeaBird505 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 54 m 50 sec
Reputation Power: 0
Problem Resolved :)

Thanks everyone who stops by this thread... I got the solution and its working now

The oracle homefolder was accessable to Administrator only, when I also added 'Everone' to the permission list , all started working normally. Everyone is dangerous to add but it is good for now....

Reply With Quote
Closed Thread

Viewing: Dev Shed ForumsDatabasesOracle Development > Oracle 8i Intelligent Agent Service problem


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
Stay green...Green IT