It's not a secret anymore!
The moose likes JDBC and the fly likes ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)" Watch "ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)" New topic
Author

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

ravindra patil
Ranch Hand

Joined: Sep 01, 2006
Posts: 196
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

Joined: Dec 20, 2006
Posts: 2343

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


OCUP UML fundamental
ITIL foundation
ravindra patil
Ranch Hand

Joined: Sep 01, 2006
Posts: 196
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 ..
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: ORA-28001: the password has expired (DBD ERROR: OCISessionBegin)
 
Similar Threads
Connect to the DB from Oracle forms 6i with existing Oracle 8.1.7.0.0 DB.
Axis Web Service not catching 0RA-28001 DB Password Expired exception
Verbose and Constructive SQL Exception error messages using Oracle?
getting error ORA-125 : TNS :no listener while try to login toad
Accessing LDAP Registry using Java API