IP хаяг эсвэл HOSTNAME сольсноор бид REPO-г дахин тохируулах шаардлагатай.
Дараах алхамаар тохируулна.
node1.example.com - Хуучин hostname
node209.oracle.me - Шинэ hostname
[oracle@node209 bin]$
[oracle@node209 bin]$ export ORACLE_HOSTNAME=node1.example.com
[oracle@node209 bin]$
[oracle@node209 bin]$ echo $ORACLE_HOSTNAME
node1.example.com
[oracle@node209 bin]$ emca -deconfig dbcontrol db
STARTED EMCA at Feb 3, 2017 3:12:31 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Do you wish to continue? [yes(Y)/no(N)]: Y
log4j:ERROR No appenders could be found for category (emSDK.config).
log4j:ERROR Please initialize the log4j system properly.
Feb 3, 2017 3:13:15 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2017_02_03_03_12_31.log.
Feb 3, 2017 3:13:16 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 3, 2017 3:13:16 AM
[oracle@node209 bin]$
Хэрэв MGMT_AVAILABILITY synonym эсвэл MGMT_VIEW хэрэглэгчтэй холбоотой алдаа заавал уг объектуудыг устгана. Усгаагүй тохиолдолд REPO-г тохируулах явцад already exists эсвэл conflicts гэх алдаа зааж зогсох болно.
SQL> drop public synonym MGMT_AVAILABILITY;
Synonym dropped.
SQL>
SQL> drop user MGMT_VIEW cascade;
User dropped.
SQL>
Шинэ hostname-ийг тохируулж өгч дахин үүсгэх коммандыг ажиллуулна.
[oracle@node209 bin]$ export ORACLE_HOSTNAME=node209.oracle.me
[oracle@node209 bin]$
[oracle@node209 bin]$ echo $ORACLE_HOSTNAME
node209.oracle.me
[oracle@node209 bin]$
[oracle@node209 bin]$
[oracle@node209 bin]$ ./emca -config dbcontrol db -repos recreate
STARTED EMCA at Feb 3, 2017 4:08:00 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user: racle_4U
Password for DBSNMP user: racle_4U
Password for SYSMAN user: racle_4U
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Local hostname ................ node209.oracle.me
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ orcl
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Feb 3, 2017 4:08:12 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2017_02_03_04_07_59.log.
Feb 3, 2017 4:08:33 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Feb 3, 2017 4:12:50 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Feb 3, 2017 4:12:50 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Feb 3, 2017 4:18:22 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Feb 3, 2017 4:19:05 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Feb 3, 2017 4:21:23 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Feb 3, 2017 4:21:27 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Feb 3, 2017 4:21:27 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Feb 3, 2017 4:25:48 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Feb 3, 2017 4:25:48 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Feb 3, 2017 4:26:43 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Feb 3, 2017 4:26:43 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Feb 3, 2017 4:29:58 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Feb 3, 2017 4:29:58 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://node209.oracle.me:1158/em <<<<<<<<<<<
Feb 3, 2017 4:38:13 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/11.2.0/dbhome_1/bin/emctl config emkey -remove_from_repos
Feb 3, 2017 4:38:13 AM oracle.sysman.emcp.util.DBControlUtil secureEmkey
INFO: Failed to remove Em Key from Management Repository.
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 3, 2017 4:38:13 AM
https://node209.oracle.me:1158/em хаягаар хандаж шалгана. Лог дээр харагдаж байна.