Oracle数据库的默认用户名和密码 [英] Default username and password for Oracle database

问题描述

我在安装Oracle DB时忘记输入sys，system和hr密码，然后单击OK，但现在使用SQ * Plus，它需要这些凭据才能在命令提示符下登录.如何获取默认用户名和密码?

I forgot to feed sys, system and hr password while Oracle DB installation and hit OK but now for SQ*Plus it needs those credentials for login in command prompt.How to get default user name and password?

推荐答案

您只需登录即可:

sqlplus / as sysdba

然后将密码提供给各个用户:

Then give password to the respective users :

ALTER USER <username> IDENTIFIED BY <password>;

您可以为所有三个用户执行此操作.

You can do that for all the three users.

我希望您不在12c上.否则，您需要提及您正在使用哪个容器.例如，如果您正在使用可插拔数据库(例如PDBORCL)，则需要执行以下步骤:

I hope you are not on 12c. Else, you need to mention which CONTAINER are you working with. For example, if you are working on pluggable database, let's say PDBORCL, you need to do following steps :

1. connect / as sysdba;

2. 更改会话以设置各个用户所属的容器.

1. connect / as sysdba;

2. alter session to set the container of which the respective users are a part of.

alter session set container=PDBORCL;

然后按照相同的步骤更改用户密码.

Then follow the same steps to change the passwords for the users.

这篇关于Oracle数据库的默认用户名和密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！