win XP SP2 에서 Oracle 11g 설치를 처음으로 해봤다.
설치 완료 후 서비스 관리자 항목을 보던중 아래와 같은 오류 메세지를 뿌리며 서비스가 구동이 되지 않더라...
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
다음 오류로 인해 Enterpirse Manager 구성을 실패했습니다.
Database Control을 시작하는 중 오류가 발생했습니다.
자세한 내용은 C:\oracle\administrator\cfgtoollogs\dbca\orcl\emConfig.log에 있는 로그 파일을 참조하십시오.
나중에 C:\oracle\Administrator\product\11.1.0\db_1\bin\emca스크립트를 수동으로 실행하여 Enterprise Manager로 이 데이터베이스 구성을 재시도 할 수 있습니다.
-----------------------------------------------------------------------------------------
데이터베이스 구성 파일은 C:\oracle\Administrator에 설치되었으며 설치 시 선택한 다른 구성 요소는 C:\oracle\Administrator\product\11.1.0\db_1에 설치되었습니다. 실수로 이들 구성 파일을 삭제하지 않도록 주의하십시오.
설치 프로그램에서 "Oracle Windows 인터페이스" 구성 요소 그룹에 제품을 설치했습니다. Microsoft Visual Studio에서 Oracle Database를 사용하여 완벽한 개발 작업을 수행할 수 있도록 지원하기 위해 Oracle은 Oracle Technology Network에서 "Oracle Developer Tools for Visual Studio .NET"의 최신 버전을 다운로드하여 설치할 것을 권장합니다.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
문제를 해결 해보고자 구글링을 하다가 찾은 자료 -
문제시 자삭 하겠지만... 참조 경로는 아래와 같다.
http://pavandba.wordpress.com/2010/05/18/em-dbconsole-not-started-and-giving-net-helpmsg-3547/
내용인 즉 Oracle 10g 기준으로 em을 재구성 하는 내용 ;;;
원본 파일이라 수정은 차후 정리하여 새로 작성 하겠음...
1) i checked the status of dbconsole as follows
C:\Documents and Settings\oracms>emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://cmsp-database.klpcph.local:5500/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.
——————————————————————
Logs are generated in directory N:\oracle\product\10.2.0\db/cmsp-database.klpcph.local_KLPPROD01/sys
man/log
2) then i tried starting dbconsole and got following error
C:\Documents and Settings\oracms>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://cmsp-database.klpcph.local:5500/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control …The OracleDBConsoleKLPPROD01 service is s
tarting…………………………………………………………………………………
……………………………………………………………………………………….
……………………
The OracleDBConsoleKLPPROD01 service could not be started.
A service specific error occurred: 1.
More help is available by typing NET HELPMSG 3547.
3) then i tried to find out what this message is
C:\Documents and Settings\oracms>NET HELPMSG 3547
A service specific error occurred: ***.
EXPLANATION
A service-specific error occurred.
ACTION
Refer to the Help or documentation for that service to determine the problem.
as you can see we cannot understand what is the exact problem here…
4) sometimes this problem may occur because SYSMAN and DBSNMP users got locked. so i checked their account status
C:\Documents and Settings\oracms>sqlplus “/ as sysdba”
SQL*Plus: Release 10.2.0.4.0 – Production on Tue May 18 08:26:24 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Release 10.2.0.4.0 – 64bit Production
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
—————————— ——————————–
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
so from above, its clear that both the user accounts are open
5) then i checked if agent is running or not
C:\Documents and Settings\oracms>emctl status agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
—————————————————————
Agent is Not Running
6) because agent is not running, i tried to start it
C:\Documents and Settings\oracms>emctl start agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
The service name is invalid.
More help is available by typing NET HELPMSG 2185.
as mentioned i tried to check what this message is…
C:\Documents and Settings\oracms>NET HELPMSG 2185
The service name is invalid.
EXPLANATION
You tried to start a service that is not configured on this system.
ACTION
Check the spelling of the service name or check the configuration information for the service using
the Services option from Server Manager.
7) restarting the server could be a solution, but we cannot do that if it is a production database. so i recreated repository
Do remember, recreating enterprise manager repository will not have any impact on database functionality
before recreating, take out the info like
Database hostname
Database SID
Listener port number
password for SYS user
password for DBSNMP user
password for SYSMAN user
also, it is important that DBSNMP and SYSMAN user’s account should be opened
use the following command to recreate repository
C:\Documents and Settings\oracms>emca -config dbcontrol db -repos recreate
STARTED EMCA at May 18, 2010 8:28:24 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: KLPSTAGE01
Database Control is already configured for the database KLPSTAGE01
You have chosen to configure Database Control for managing the database KLPSTAGE01
This will remove the existing configuration and the default settings and perform a fresh configurati
on
Do you wish to continue? [yes(Y)/no(N)]: y
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
—————————————————————–
You have specified the following settings
Database ORACLE_HOME ……………. N:\oracle\product\10.2.0\db
Database hostname ……………. klpdbscph601.klpcph.local
Listener port number ……………. 1521
Database SID ……………. KLPSTAGE01
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: y
this successfully created repository and started my dbconsole