0

1) I installed Oracle 12c (64 bit windows)12.2.0.1.0 2) I installed sql developer and tried to connect to the database, I realized I forgot user name and password. I dont even remember if I entered one , I tried all I can remember. Nut I continue to get status - failure ora01017 invalid username and password;logon failed.

I used SID as ORCL , authentication type default , & local host & role as default. Can someone please help me ? I'm total new to Oracle. How can I check what username and password I created while installing oracle database?

Thank you so much for your help!

4
  • 1
    Is there a reason you don't just uninstall and start from scratch, making sure, you notate the information for the user?
    – Ramhound
    Commented Apr 17, 2019 at 20:58
  • Not sure about windows but Linux have sysdba group which allow a local user to connect to the database over the socket. 'sqlplus / as sysdba' when logged in as a user of sysdba group and environment variables are set.
    – Aroly7
    Commented Apr 17, 2019 at 21:04
  • i have no choice to do re-install and spend another hour on this. Commented Apr 17, 2019 at 21:05
  • @user8371676 see last part
    – Aroly7
    Commented Apr 17, 2019 at 21:07

1 Answer 1

0

You can connect using the local user as sysdba and change the sys password.

REF the last article is relevant

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .