-
restarting oracle
i have oracle 8.1.7 at office. due to frequent power outages, which is a very common thing here, all other computers turn off except the main server which has a separate dedicated ups. so the users previously logged in are never logged out. once the generator fires up, everybody logs in again and the server has double the number of users logged in. is there any way thru vb6 to either restart the oracle service in the main server, remotely or to view and disconnect users who are logged in more than once? any help is appreciated. please note that the main server is running win2k advanced server and the client computers have oses starting from windows 95 to windows xp.
-
Re: restarting oracle
Just restarting the service later means that anybody who has already re-connected will be "booted" from the server, which I'm sure they wont appreciate.
Is there an issue with the number of licenses in use (legally and/or restricting access), or is it just annoying? If there isn't an issue it may be best to just restart the service out of working hours if you can (using the scheduling facilities in windows possibly).
If the UPS is aware of the main power going down, it would probably be a good idea to look into the UPS options within Windows (as the UPS sends information which Windows can respond to).
I'm not sure what options are available, but I would expect that you will have the option to stop/restart a service based on a warning flag that is fired when the UPS goes into action.
-
Re: restarting oracle
actually there is a restriction in the nimber of users to be logged on at any given time. so once there is a power failure and the generator is started, there will be more than the limited users trying to log in. so some are logged in and most are not. also the server becomes slow and there is "access violation error are sql level 1" or something like that when that happens.
what i wish to do is restart the oracle service remotely from my computer as soon as the generator starts so that i dont have to restart the whole server.
i can do it manually. but then it would be very irritating as power failures can occur as frequently as twice a day to 4 or 5 times a day.
and yes, it would be a nice thing to look into the ups options. but i dont know how to restart the oracle service programmatically.
thanx for the comments and suggestions.
i really need to get this solved. its giving me major headaches.