starting database in restricted mode automatically
I would like to start oracle database in restricted session mode.
I am able to do this using SQL/PLUS by
and after that could alter the system into normal mode.
But I would like to open my database automatically when the server
starts. I would like the database to be opened in restricted mode.
So I tried to open database using oradim utility but could not achive. I also tried to write this into the parameter file. But I do not know if it works or not or I do not know the name of the parameter for enabling restrict session mode.
So is there any way to do this.
Thank you very much..
You say I could use task scheduler, but in what way?
I know that I primitively can use batch file and can write in
the oradim command to open database. But oradim does not take
any parameter for restrict session mode. I mean I could not say to oradim to open database in restrict session mode. I could only startup in restrict mode using sql startup command.
And when oracle is openening it read from the parameter file. I tried to write in the parameter file for enabling restrict session mode but cant.
Yes before any user is connected to the database, I have to disable triggers automatically , because the other database will be replicated to this database.
Also I appreciate the user saying that the database is opened for use, why I am opening in restrict mode. Of course database is for use....