CODEWITHSUNDEEP
oracle11gsqlplus
user3213758
user3213758

Reputation: 103

Sqlplus - creating new users

I have downloaded Oracle - OraDb11g_home1 and I want to use sqlplus. The problem is, when I open sqlplus, it's prompts me for username and password which I don't think I have. Is there a way to log in as a default super user and create a new account?

Thanks

Upvotes: 2

Views: 5732

Answers (1)

venergiac
venergiac

Reputation: 7717

Start SQL*Plus:

C:\> sqlplus /NOLOG

Connect as SYSDBA:

SQL> CONNECT / AS SYSDBA

change password and connect again.

ALTER USER username ACCOUNT UNLOCK;

ALTER USER username IDENTIFIED BY password;

Upvotes: 1

Related Questions