如何恢复或更改Oracle sysdba密码 [英] How to recover or change Oracle sysdba password

问题描述

我们正在使用一个oracle数据库，在该数据库中进行设置的人员已经很久了，因此不知道sysdba密码，但需要它.我们具有对该框(在Linux上)的root访问权限.有什么方法可以恢复或更改系统密码?

We are working with an oracle database in which the person that set it up is "long gone" and thus do not know the sysdba password, but need it. We have root access to the box (its on linux). Is there any way to recover or change the sys passwords?

推荐答案

您是否尝试过以已安装的Oracle用户身份登录Linux

Have you tried logging into Linux as your installed Oracle user then

sqlplus "/ as sysdba"

登录后，您可以更改密码.

When you log in you'll be able to change your password.

alter user sys identified by <new password>;

祝你好运:)

这篇关于如何恢复或更改Oracle sysdba密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！