OS: Microsoft Windows Server 2012
DB: Oracle Database 11.2.0.3.0
команда
| автор |
|---|
| C:\>set | find "ORACLE" |
выдаёт:
| автор |
|---|
ORACLE_HOME=D:\oracle\product\11.2.0\dbhome_1
ORACLE_HOSTNAME=MY-SRV-BASE.COMPANY
ORACLE_SID=DB1.COMPANY
ORACLE_UNQNAME=DB1 |
команда
| автор |
|---|
| emctl status dbconsole |
выдаёт:
| автор |
|---|
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://MY-SRV-BASE.COMPANY:1158/em/console/aboutApplication
EM Daemon is not running.
------------------------------------------------------------------
Logs are generated in directory D:\oracle\product\11.2.0\dbhome_1/MY-SRV-BASE.COMPANY_ERP1/sysman/log |
При попытке открыть страницу
https://MY-SRV-BASE.COMPANY:1158/em/ появляется окно авторизации.
После ввода логин и пароля выходит сообщение:
| автор |
|---|
Error
Internal Error has occurred. Check the log file for details.
|
При попытке выполнить:
| автор |
|---|
emca -deconfig dbcontrol db
emca -config dbcontrol db -repos recreate |
после ввода ORACLE_SID с доменным суффиксом выдаёт:
| автор |
|---|
WARNING: ORA-12560: TNS:protocol adapter error
23.09.2015 17:28:27 oracle.sysman.emcp.DatabaseChecks throwDBUnavailableException
SEVERE:
Database instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again.
Some of the possible reasons may be :
1) Database may not be up.
2) Database is started setting environment variable ORACLE_HOME with trailing '/'. Reset ORACLE_HOME and bounce the database. |
если без доменного суффикса:
| автор |
|---|
23.09.2015 17:30:41 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01031: ┐┐┐┐┐┐┐┐┐┐ ┐┐┐┐┐┐┐┐┐┐┐┐
23.09.2015 17:30:41 oracle.sysman.emcp.DatabaseChecks throwDBUnavailableException
SEVERE:
Database instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again.
Some of the possible reasons may be :
1) Database may not be up.
2) Database is started setting environment variable ORACLE_HOME with trailing '/'. Reset ORACLE_HOME and bounce the database.
|
В трейс-файл D:\oracle\product\11.2.0\dbhome_1\MY-SRV-BASE.COMPANY_erp1\sysman\log\emdctl.trc пишется:
Куда копать?