Forgot User and password

[Former Member]

Dear Gurus,

When am trying to open Oracle 10G via command prompt, I ran the SQLPLUS command but I forgot User and Password,

Please Let me know where can i find out that and get the user password otherwise How can I Reset .

Kindly advice me.

Regards

Anand

[Former Member]

Hi Anand,

If you are running on a SAP system, you can change the password by the command, below;

brconnect -u / u2013f chpass u2013u <user_name> -p <password>

Or execute the command, below;

command prompt -> sqlplus "/ as sysdba"
Then execute the command below, on SQLPlus
alter user <user> identified by <new_password>;

Best regards,

Orkun Gedik

[Former Member]

Try to connect as sysdba (As mentioned by other techie above)

OR

Contact your database administrators for username and the password (If your database is secured with user names and password)

Regards,

Nick Loy

[Former Member]

Hi,

Connect using the sysdba user

'sqlplus / as sysdba'

Regards,

Srikishan

[Former Member]

Dear All,

I try that all, but it will ask for User and Password , I am afraid , miss that both,

Now I want to Alter User and Password Please tell me advice.

[Former Member]

What procedure/command you are using to logon into sqlplus ?

You can't alter user/password without logon though !