Home » RDBMS Server » Security » connecting sqlplus without password (oracle 11.2.0 (Oracle IDE version 4.1.3.20.78))
connecting sqlplus without password [message #658979] Tue, 03 January 2017 04:53 Go to next message
raj85844
Messages: 26
Registered: November 2016
Location: chennai
Junior Member
Hi Team,

Wishing you a very happy new year !!!!

Here i tried to connect oracle as i forget my password and i am unable to connect requried your help in resolving the same

tried attempts
-----------------
1)from windows command prompt : Connect sqlplus username/password@localhost:1521:orcl
2)from sqlplus : username : xxxxx password : xxxxx (after 3 attempt the window closed )

As I am tring in my local machine to connect sqlplus as such not able to achieve the same due to incorrect password
so kindly help me out

Thanks
Raj
Re: connecting sqlplus without password [message #658980 is a reply to message #658979] Tue, 03 January 2017 05:04 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well you would need to connect as some other user that can reset your password - sysdba being the obvious choice.
Re: connecting sqlplus without password [message #659020 is a reply to message #658979] Wed, 04 January 2017 05:11 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
What Oracle error message (ORA-XXXXX) are you getting?
Re: connecting sqlplus without password [message #659225 is a reply to message #659020] Mon, 09 January 2017 23:14 Go to previous message
raj85844
Messages: 26
Registered: November 2016
Location: chennai
Junior Member
Yes i achived the same by connecting as /@server as sysdba then i was able to change the password for the rest of the users

Thanks friends
Previous Topic: DEBUG ANY PROCEDURE
Next Topic: To find user privileges on a table
Goto Forum:
  


Current Time: Thu Mar 28 08:08:55 CDT 2024