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
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