Home » RDBMS Server » Enterprise Manager » Failed to connect to database instance (DBD ERROR: OCISessionBegin)
Failed to connect to database instance (DBD ERROR: OCISessionBegin) [message #276898] Fri, 26 October 2007 12:42 Go to next message
masoodnt10
Messages: 5
Registered: October 2007
Junior Member

I'm trying to connect to remote database from oracle enterprise manager ; the connection is going fine but when i try to connect to a database xyz it's giving error like shown below...


Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin)...
Re: Failed to connect to database instance (DBD ERROR: OCISessionBegin) [message #276899 is a reply to message #276898] Fri, 26 October 2007 12:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Alternatively you could use a schema that is not locked.
Re: Failed to connect to database instance (DBD ERROR: OCISessionBegin) [message #276900 is a reply to message #276898] Fri, 26 October 2007 12:51 Go to previous messageGo to next message
masoodnt10
Messages: 5
Registered: October 2007
Junior Member
Can you please write a bit detail how can i use a schema alternatively.

On one of my server there is a database xyz, I want to backup that database from oracle enterprise manager, I've tried system/manager but getting the above mentioned error...

it would be nice if you can write detail, how to solve this issue.

Re: Failed to connect to database instance (DBD ERROR: OCISessionBegin) [message #276929 is a reply to message #276900] Sat, 27 October 2007 01:08 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Please check...sysman or dbsnmp user schema is locked or not ???
if it is locked then please unlock first

alter user SYSMAN account unlock;
alter user DBSNMP account unlock;

Please Keep in mind don't change SYSMAN password directly.otherwise you have to reconfigure OEM respository.
If you want to change SYSMAN password then use below procedure.
http://dbataj.blogspot.com/2007/07/change-sysman-password.html



Regards
Taj

[Updated on: Sat, 27 October 2007 01:08]

Report message to a moderator

Previous Topic: Enterprise Manager 10gR2: exit codes and dependencies
Next Topic: Oracle 10g Installation on Windows XP
Goto Forum:
  


Current Time: Thu Mar 28 05:04:15 CDT 2024