Home » RDBMS Server » Enterprise Manager » backup and restore oracle 11g binaries (solaris 10 - oracle database enterprise 11g - 11.0.7.0)
backup and restore oracle 11g binaries [message #405869] Sat, 30 May 2009 13:46 Go to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Dear All,

I have installed oracle database enterprise 11g - 11.0.7.0 in /oracle/db/tech_st/11.1.0 (no db was created at this time). Lster, due to some disks reasons, I moved the binaries to /a01/oracle/db/tech_st/11.1.0 file system.

I made modifications to the oratab file, etc and was able to create a db using dbca and netca. During creation of DB using dbca, finally i got a message which says

EM comfiguration failed due to the following error:failed to unlock all em related accounts.
refer to log at /a01/oracle/db/tech_st/11.1.0/cfgtoollogs/dbca/cms2/emconfig.log.
you can try to reconfigure em by running /a01/oracle/db/tech_st/11.1.0/bin/emca script.


please fing attached the emconfig.log


thank you
  • Attachment: emConfig.log
    (Size: 36.73KB, Downloaded 2357 times)
Re: backup and restore oracle 11g binaries [message #405870 is a reply to message #405869] Sat, 30 May 2009 14:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Below is from attached log file.
Refer to the log file at /a01/oracle/db/tech_st/11.1.0/cfgtoollogs/dbca/cms2/emConfig.log for more details.

I am unclear from where you obtained posted information & your posts states "emconfig.log" [lower case config] while I see "emConfig.log" [UPPER CASE Config]

The likely fix is to
ALTER USER <schema_name> ACCOUNT UNLOCK;
Re: backup and restore oracle 11g binaries [message #405882 is a reply to message #405870] Sat, 30 May 2009 23:35 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
i have attached the emconfig.log
Re: backup and restore oracle 11g binaries [message #405883 is a reply to message #405869] Sat, 30 May 2009 23:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i have attached the emconfig.log
Yes.

Are you closer to a solution now?
Re: backup and restore oracle 11g binaries [message #405930 is a reply to message #405883] Sun, 31 May 2009 23:35 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
which <schema name> should i unlock?

Re: backup and restore oracle 11g binaries [message #406016 is a reply to message #405930] Mon, 01 June 2009 11:55 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
Refer to the log file at /a01/oracle/db/tech_st/11.1.0/cfgtoollogs/dbca/cms2/emConfig.log for more details.
May 28, 2009 3:35:31 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Failed to unlock all EM-related accounts


I recomment; Create database first; Later on manually you can cretae/re-create your oracle oem.

Thanks
Previous Topic: reconfigure the enterprise manager
Next Topic: Need guide line creating Replicate via OEM step by step
Goto Forum:
  


Current Time: Fri Nov 22 17:16:35 CST 2024