EMCA Issues
821043Nov 22 2011 — edited Nov 24 2011All, 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