Home » Developer & Programmer » Forms » How to Shutdown oracle Database Through Forms 6i
How to Shutdown oracle Database Through Forms 6i [message #629973] Thu, 18 December 2014 05:46 Go to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
How to Shutdown oracle Database Through Forms 6i
Re: How to Shutdown oracle Database Through Forms 6i [message #629980 is a reply to message #629973] Thu, 18 December 2014 06:49 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
That strikes me as a really bad idea, so why do you want to do it?
Re: How to Shutdown oracle Database Through Forms 6i [message #629986 is a reply to message #629980] Thu, 18 December 2014 08:17 Go to previous messageGo to next message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
I agree with cookiemonster...why in the world would you want to allow an application the power of shutting down your database?!?!?
Re: How to Shutdown oracle Database Through Forms 6i [message #629993 is a reply to message #629973] Thu, 18 December 2014 08:47 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
i am not agree with your opinon i asked a solution

Re: How to Shutdown oracle Database Through Forms 6i [message #629998 is a reply to message #629993] Thu, 18 December 2014 09:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
BEGIN
execute immediate 'SHUTDOWN IMMEDIATE';
END;
Re: How to Shutdown oracle Database Through Forms 6i [message #630001 is a reply to message #629998] Thu, 18 December 2014 09:21 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
error while compiling following command

form execute immediate 'SHUTDOWN IMMEDIATE';
Re: How to Shutdown oracle Database Through Forms 6i [message #630004 is a reply to message #630001] Thu, 18 December 2014 09:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It appears that you only know enough WRT Oracle to be dangerous to yourself & everyone else who accesses this database.
You're On Your Own (YOYO)!
Re: How to Shutdown oracle Database Through Forms 6i [message #630005 is a reply to message #630004] Thu, 18 December 2014 09:28 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
i know
Re: How to Shutdown oracle Database Through Forms 6i [message #630006 is a reply to message #630005] Thu, 18 December 2014 09:31 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
Sir i want a solutions
Re: How to Shutdown oracle Database Through Forms 6i [message #630007 is a reply to message #630006] Thu, 18 December 2014 09:36 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
In order to be able to do this you need forms to connect to the DB as the sys user. Most DBAs, sensibly, don't allow this. So before telling you how - can you connect to the DB as sys using forms?
Cause if you can't then what you want isn't possible.
Re: How to Shutdown oracle Database Through Forms 6i [message #630008 is a reply to message #630007] Thu, 18 December 2014 09:44 Go to previous messageGo to next message
qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
How to grant a user to shutdown a database
Re: How to Shutdown oracle Database Through Forms 6i [message #630013 is a reply to message #630008] Thu, 18 December 2014 09:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
GRANT SYSOPER TO FORMS_USER;
Re: How to Shutdown oracle Database Through Forms 6i [message #630014 is a reply to message #630013] Thu, 18 December 2014 10:19 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Forms application can't run unless you are connected to a database. Shutting down the database would terminate your application as well (if this is the database you are connected to). Is that OK?

EXECUTE IMMEDIATE BlackSwan suggested won't work in Forms. You could, though, create a batch script which would shut the database down and then call that script from a form. Or, you could try with FORMS_DDL.

Anyway, that's really strange requirement. Why would you want to do that?
Re: How to Shutdown oracle Database Through Forms 6i [message #630015 is a reply to message #630014] Thu, 18 December 2014 10:50 Go to previous message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
Sometimes, we developers, have to educate customers when they ask for something that doesn't make sense or is hazardous. In my humble opinion, shutting down the database from a Form is both of these and whoever is asking you for the ability to shut down the database should be educated on why this is a "Bad Idea!"

As Littlefoot mentioned, if you shutdown the database from a Form, it will cause your Forms session to terminate as well. How are you going to restart the database after it's been shutdown? The DBA will still have to manually start up the database.

As you can tell by all of the replies asking "Why would you want to do that" that none of us think this is a good idea.

Craig...
Previous Topic: Java Beans in forms
Next Topic: Word Document open from oracle form 10 g
Goto Forum:
  


Current Time: Wed Apr 24 20:30:17 CDT 2024