Подскажите, пожалуйста куда копать или дайте ссылку на решение.
На другом серваке развернул базу и поднял ее из бекапа. После пытаюсь создать и запустить консоль. В логах висит сообщение, что подключилось и ничего не происходит.
1.
2.
3.
DROP USER mgmt_view CASCADE;
DROP ROLE mgmt_user;
DROP USER sysman CASCADE;
Сделано. Поскольку сервер поднимался с нуля, папки не захломлены файлами от старого репозитоария.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
C:\app\orcladm\product\11.2.0\dbhome_1\BIN>emca -config dbcontrol db -repos recreate
STARTED EMCA at 24.11.2017 16:25:52
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: budget
Listener port number: 1521
Listener ORACLE_HOME [ c:\app\orcladm\product\11.2.0\dbhome_1 ]:
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 ................ c:\app\orcladm\product\11.2.0\dbhome_1
Local hostname ................ oraclestdb.minfin.sam.ru
Listener ORACLE_HOME ................ c:\app\orcladm\product\11.2.0\dbhome_1
Listener port number ................ 1521
Database SID ................ budget
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes
24.11.2017 16:26:39 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at c:\app\orcladm\cfgtoollogs\emca\budget\emca_2017_11_24_16_25_52.log
.
И вот на этом месте все зависает.
Лог
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
CONFIG: SQLEngine created successfully and connected
24.11.2017 16:26:39 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_DOMAIN value: minfin.sam.ru
24.11.2017 16:26:39 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: budget.minfin.sam.ru
24.11.2017 16:26:39 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Copying file c:\app\orcladm\product\11.2.0\dbhome_1\sysman\config\emd.properties to c:\app\orcladm\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp
24.11.2017 16:26:39 oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file c:\app\orcladm\product\11.2.0\dbhome_1\sysman\config\emd.properties has been copied to c:\app\orcladm\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp
24.11.2017 16:26:39 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Copying file c:\app\orcladm\product\11.2.0\dbhome_1\sysman\config\emoms.properties to c:\app\orcladm\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp
24.11.2017 16:26:39 oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file c:\app\orcladm\product\11.2.0\dbhome_1\sysman\config\emoms.properties has been copied to c:\app\orcladm\product\11.2.0\dbhome_1\sysman\config\emoms.properties.emca.tmp
24.11.2017 16:26:39 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Copying file c:\app\orcladm\product\11.2.0\dbhome_1\sysman\emd\targets.xml to c:\app\orcladm\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp
24.11.2017 16:26:39 oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file c:\app\orcladm\product\11.2.0\dbhome_1\sysman\emd\targets.xml has been copied to c:\app\orcladm\product\11.2.0\dbhome_1\sysman\emd\targets.xml.emca.tmp
24.11.2017 16:26:39 oracle.sysman.emcp.util.ClusterUtil isHASInstalled
CONFIG: isHAInstalled: false
24.11.2017 16:26:39 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: HOST: oraclestdb.minfin.sam.ru
24.11.2017 16:26:39 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=budget.minfin.sam.ru)))
24.11.2017 16:26:39 oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database budget : oraclestdb.minfin.sam.ru
24.11.2017 16:26:39 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: oraclestdb.minfin.sam.ru
24.11.2017 16:26:39 oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1521
24.11.2017 16:26:39 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
24.11.2017 16:26:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
24.11.2017 16:26:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: budget, oracleHome: c:\app\orcladm\product\11.2.0\dbhome_1, and user: SYS
24.11.2017 16:26:39 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
То ли я мало жду, то ли что-то хочет от меня оркл, а я его не понимаю.
