Startup 10g Windows Exclusive

[borntorun]

Hi,

Can someone tell me how I can start up oracle in exclusive mode so that i can issue an alter database command thank.

 

[Thargy]

borntorun,

startup restrict will only allow users with restricted privileges to access the database.

That should do what you want.

Regards

Tharg

Grinding away at things Oracular

 

[SantaMufasa]

BornToRun,

Here is the code to startup a database in EXCLUSIVE mode:

STARTUP EXCLUSIVE

Let us know if this resolves your need or if you have additional questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[markrem]

If you are not using RAC, then STARTUP is exclusive by definition of non-RAC. If you are using RAC then then command STARTUP EXCLUSIVE requires you first set initialization parameter CLUSTER_DATABASE=FALSE in the SPFILE, then shutdown all instances, and then start the one instance you want using STARTUP EXCLUSIVE.


MarkRem
Author, Oracle Database 10g: From Nuts to Soup

http://www.remidata.com/book_nuts2soup.htm

 

[karluk]

I don't see what "startup exclusive" has to do with issuing an alter database command. Perhaps you mean "startup restrict", as thargtheslayer suggests. However, it's not really necessary to be running in restricted mode to issue an alter database command, although it probably is a little bit safer.

 

[SantaMufasa]

BornToRun, I should have read beyond, "Can someone tell me how I can start up oracle in exclusive mode..." -- KarlUK is absolutely correct in wondering why you would want to "STARTUP EXCLUSIVE" to do an "ALTER <anything>..." command.

"STARTUP EXCLUSIVE" simply directs Oracle to not allow more than one Oracle Instance to manage a single database.

So, we should probably step back and ask you to post the entire "ALTER DATABASE..." command that you wish to execute.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]