Oracle start without DBA Group

My user account was indirectly a member of the ora_dba group, via my administrator rights, but it seems I need to be directly a member of the group to login / as sysdba.

That said, the short, bullet point method is as follows:

Cd %ORACLE_HOME%\database
set ORACLE_SID=dbadb01.
Rename the current password file pwddbadb01.ora to pwddbadb01.ora.keep.
Copy another password file, for which I did know the SYS password, to pwddbadb01.ora.
Sqlplus sys/known_password as sysdba.
startup.
exit.
Delete pwddbadb01.ora.
Rename pwddbadb01.ora.keep to pwddbadb01.ora.

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com 標誌

您的留言將使用 WordPress.com 帳號。 登出 /  變更 )

Google photo

您的留言將使用 Google 帳號。 登出 /  變更 )

Twitter picture

您的留言將使用 Twitter 帳號。 登出 /  變更 )

Facebook照片

您的留言將使用 Facebook 帳號。 登出 /  變更 )

連結到 %s