Subject | No permission for shutdown access to database |
---|---|
Author | des.erwin |
Post date | 2011-03-22T14:34:27Z |
I have several scripts that needs to be executed on a database.
In the first batch I use the sysdba user.
For the second batch, i need to use another account due to specific rights.
The problem is that when the second batch starts, I get a message "No permission for shutdown access to database ...".
So, I want to shut down the database through another way and not using the sysdba account, because in that case only the sysdba can reconnect to the database. The second batch is using another account.
How can I achieve this?
Thanks in advance
In the first batch I use the sysdba user.
For the second batch, i need to use another account due to specific rights.
The problem is that when the second batch starts, I get a message "No permission for shutdown access to database ...".
So, I want to shut down the database through another way and not using the sysdba account, because in that case only the sysdba can reconnect to the database. The second batch is using another account.
How can I achieve this?
Thanks in advance