Oracle Em

1. em 재구성을 위해 정보를 입력합니다.

C: \> emca -deconfig dbcontrol db

...
Enter the following information:
Database SID: orcl  (설치할 때 입력한 SID 를 입력합니다~~)

Continue? [Is (Y) / No (N)]: y
...

2. 기존의 정보를 삭제합니다.

C: \> emca -repos drop

...

Enter the following information:
Database SID: orcl (설치할 때 입력한 SID 입력)
Listener port number: 1521 (설치할 때 입력한 Listener 포트 입력)
SYS user's password: (설치할 때 입력 비밀번호 입력)
SYSMAN user password: le 
SYSMAN user passwords: 
Continue? [Is (Y) / No (N)]: y 
...
Information: successfully deleted data repository has successfully completed the

configuration of Enterprise Manager 
...

3. 지금부터 새로 만듭니다.

C: \> emca -config dbcontrol db -repos create
...
Enter the following information:
Database SID: orcl  (새로 만들 SID 를 입력합니다..)
Listener port number: 1521 (Listener 포트를 입력합니다)
Listener ORACLE_HOME [D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1]:

SYS user's password: (비밀번호를 입력합니다~~~)
DBSNMP user's password: 
SYSMAN user password: 
SYSMAN user password: the email address (optional): (옵션이니깐 패스~~)
Notice copies (SMTP) server (optional): (이것두 패스~~)
...
Continue? [Is (Y) / No (N)]: y
...

Have successfully completed the configuration of Enterprise Manager
EMCA ends at 2010-7-16 9:56:19

4. em 상태를 확인합니다. (ORACLE_UNQNAME 환경에러라고 나오는데 5번에서 입력)

C: \> emctl status dbconsole 
Environment variable ORACLE_UNQNAME not defined.

Please set ORACLE_UNQNAME to database unique name. 

5. ORACLE_UNQNAME 을 설정합니다.

C: \> set ORACLE_UNQNAME = orcl

6. 다시 em 의 상태를 확인합니다.

C: \> emctl status dbconsole 
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved. 
https: / / 192.168.0.228:1158 / em / console / aboutApplication 
Oracle Enterprise Manager 11g is running. 
-------------------------------------------------- ---------------- 
Logs are generated in directory D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1/192.168.0.228_orcl/sysman/log

7. 완료