Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

startup in read only mode

Status
Not open for further replies.

naushi

ISP
Jan 18, 2002
89
US
Is there another way to put the database in read only mode than

startup mount
alter database open read only....and it works

but when I later try to close the database with 'alter database close' it tells me there is a session open which is not true. I then try to do a shutdown immediate and it waits for ever probably trying to close a session that it thinks is open hence the waiting. I wind up doing 'shutdown abort'. BTW this feature does not work in 8.0.x Regards,
Naushi Hussain
Naushi.hussain@honeywell.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top