This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)

 
ravindra patil
Ranch Hand
Posts: 234
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I Have oracle 11 g ,

i used to get password expire alert some days back but i ignored it so now i want to connect my DB, but i am getting
ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) when i try to access DB ,
is there any solution or i need to reinstall my database,

even when i try to create new database i get error like no sufficient privileges
please help
 
Jan Cumps
Bartender
Posts: 2608
14
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you login to the database with that user with SQL*Plus?
If you are still in the grace period, you will should prompted to provide a new password.

For OCI, hae a look at this: OCIPasswordChange()
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96584/oci16100.htm

This call is useful when the password of an account has expired and OCISessionBegin() returns an error (ORA-28001) or warning that indicates that the password has expired
 
ravindra patil
Ranch Hand
Posts: 234
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well i could able to login using sql+
finally i call DB expert .. he tried whole day now we reinstall it ... so my whole day wasted in this ..
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic