I just took over this database about 2 weeks ago and it's been a big mess. Any way, I have a quick question, I try to bounce this database but I have no password for INTERNAL when I tried to log in through SVRMGRL. this is Oracle 184.108.40.206.0
I have the password for SYSTEM so I tried to log in as SYSTEM from SVRMGRL and I tried to shutdown the database and it's telling me that Insufficient privileges.
Please let me know any other way to shutdown this database and startup.
First delete the existing file then it will allow u to create the new file.
entries=5 means atmost u can give 5 users sysdba privileges.
by default it is only with internal.
to give the privilge to a user say mike
create a database use mike . the using internal
sql> grant sysdba to mike;
so next time u can log in as
sqlplus mike/ as sysdba
then u will be able to startup and shutdown database as mike also
entries=5 means other than internal any 4other users can be given sysdba privilege