After Oracle install forgot username or password + Create new login user

The newly installed oracle11g, unexpectedly in use when the user name and password is not remembered at the time of installation.

Don't worry, open the sqlplus.

Follow the steps below to create a new login user:

The first step: Log in with sys sys/Password as sysdba any character here can be logged on.

Sys/manager as Sysdba

Once the login is successful, you can create a new user.

Step Two:

Create user

Grammar:

Create user username identified by password create user admin identified by ORCL;

To unlock the user you just created: ALTER user Username account Unlock/lock

Alter user admin account unlock; User Unlocked

Alter user admin account lock; User Lock

Grant new logged on user Create permission

Syntax: GRANT CREATE SESSION to user name

Grant create session to admin;

Grant the newly created user database administrator rights

Grammar:

Grant DBA to User name; Grant dba to admin;

Switch to the newly created user login

Syntax: CONNECT user name/password

Connect ADMIN/ORCL;

Delete User

Syntax: DROP user username

Drop user admin;

Note that all actions must be added at the end of the ";" To perform successfully

Forget user name or password after Oracle installation + Create new login user