Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EMCA Issues

821043Nov 22 2011 — edited Nov 24 2011
All, i'm installing Oracle 11.2.0.1.0 on Windows Server 2008.
I installed the database and everything ran smoothly apart from the Enterprise Manager did not create, and that was due to the system role already being created so it failed. I removed the repository following and recreated it, but now its hanging at this point:

-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ E:\oracle\product\11.2.0\dbhome_1

Local hostname ................ 169.xxx.xxx.xxx
Listener ORACLE_HOME ................ E:\oracle\product\11.2.0\dbhome_1
Listener port number ................ 1521
Database SID ................ ora112
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 22, 2011 5:26:42 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at E:\oracle\cfgtoollogs\emca\ora112\emca_2011_11_22_17_25_33.log.
Nov 22, 2011 5:26:43 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 22, 2011 5:30:25 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created

Nothing seems to happen after that.. the bottom contents of emca_2011_11_22_17_25_33.log are:

CONFIG: Starting execution: CMD /C E:\oracle\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.bat "E:\oracle\product\11.2.0\dbhome_1\sysman\admin\scripts;E:\oracle\product\11.2.0\dbhome_1\bin;" E:/oracle/product/11.2.0/dbhome_1/perl/bin\perl.exe E:\oracle\product\11.2.0\dbhome_1\sysman\admin\scripts\emca\emcaDbUtil.pl E:\oracle\product\11.2.0\dbhome_1 "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=169.254.185.142)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ora112)))" SYS SYSDBA declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end; ora112 1 SYSMAN_PWD

I can login to SQL*Plus using sys as sysdba - any help would really be appreciated..

Thanks,
Gareth
This post has been answered by oradba on Nov 24 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2011
Added on Nov 22 2011
11 comments
962 views