Benutzer-Werkzeuge

Webseiten-Werkzeuge


dba:install_dbconsole

DB Console für eine Oracle Datenbank 10g oder 11g anlegen

DB:10g, funktioniert aber auch so mit 11g

Pro Datenbank auf einem Host muss eine eigenen DB Console angelegt werden. Silent install String (auf passende Wert in der eigenen Umgebung anpassen):

set ORACLE_HOME=D:\oracle\1020\database
set ORACLE_SID=GPI
D:\oracle\1020\database\bin\emca.bat -config dbcontrol db -repos create -silent -DB_UNIQUE_NAME GPI -PORT 1521 -EM_HOME D:\oracle\1020\database -LISTENER LISTENER -SERVICE_NAME GPI -SID GPI -ORACLE_HOME D:\oracle\1020\database -HOST gpidbserver.local -LISTENER_OH D:\oracle\1020\database -LOG_FILE D:\oracle\admin\GPI\scripts\emConfig.log -DBSNMP_PWD pwd4oem -SYSMAN_PWD pwd4oem

Aufruf dann über http://gpidbserver.local:1158/em/


DB Console für eine Cluster Datenbank anlegen

DB:10g
OS:win

Informationen zusammenstellen:

  • Database unique name
  • Listener port number
  • Cluster name
  • Password for SYS user
  • Password for DBSNMP user
  • Password for SYSMAN user
  • Email address for notifications (optional)
  • Outgoing Mail (SMTP) server for notifications (optional)
  • ASM ORACLE_HOME e.g. /u01/app/asm/product/10.2.0
  • ASM port e.g. 1521
  • ASM user role e.g. SYSDBA
  • ASM username e.g. SYS
  • ASM user password

Vorbereitung: User DBSNMP account unlock und Passwort setzen

Auf dem Knoten 1:

# Oracle Home und SID der DB setzen

D:\oracle\1020\database\bin\emca.bat -config dbcontrol db -repos create -cluster

STARTED EMCA at Oct 14, 2010 5:32:13 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database unique name: GPIDB
Listener port number: 1521
Cluster name: crs
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional): xxxxx
Outgoing Mail (SMTP) server for notifications (optional): xxxxxx
ASM ORACLE_HOME [ D:\oracle\1020\database ]: D:\oracle\1020\ASM
ASM port [ 1521 ]:
ASM user role [ SYSDBA ]:
ASM username [ SYS ]:
ASM user password:
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ D:\oracle\1020\database

Database instance hostname ................ gpirac0DBT02
Listener port number ................ 1521
Cluster name ................ crs
Database unique name ................ GPIDB
Email address for notifications ............... xxxxxxxxx
Outgoing Mail (SMTP) server for notifications ............... xxxxxxx
ASM ORACLE_HOME ................ D:\oracle\1020\ASM
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ SYS

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Oct 14, 2010 5:43:33 PM oracle.sysman.emcp.EMConfig perform
INFO: This GPIDBtion is being logged at D:\oracle\1020\database\cfgtoollogs\emca\GPIDB\emca_2010-10-14_05-32-13-PM.log.
Oct 14, 2010 5:43:49 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Oct 14, 2010 5:46:04 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Oct 14, 2010 5:46:14 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating D:\oracle\1020\database\oc4j\j2ee\OC4J_DBConsole_gpirac0dbt02_GPIDB2 to remote nodes ...
Oct 14, 2010 5:46:14 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating D:\oracle\1020\database\oc4j\j2ee\OC4J_DBConsole_gpirac0dbt01_GPIDB1 to remote nodes ...
Oct 14, 2010 5:46:14 PM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir
INFO: Propagating D:\oracle\1020\database\oc4j\j2ee\isqlplus_gpirac0DBT02 to remote nodes ...
Oct 14, 2010 5:46:14 PM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir
INFO: Propagating D:\oracle\1020\database\oc4j\j2ee\isqlplus_gpirac0DBT01 to remote nodes ...
Oct 14, 2010 5:46:16 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating D:\oracle\1020\database\gpirac0dbt02_GPIDB2 to remote nodes ...
Oct 14, 2010 5:46:18 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating D:\oracle\1020\database\gpirac0dbt01_GPIDB1 to remote nodes ...
Oct 14, 2010 5:46:27 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Oct 14, 2010 5:47:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Oct 14, 2010 5:47:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://gpirac0DBT02:1158/em <<<<<<<<<<<
Oct 14, 2010 5:47:49 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
****************  Current Configuration  ****************
 INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

GPIDB2            gpirac0dbt02     gpirac0DBT02
GPIDB1            gpirac0dbt01     gpirac0DBT02


Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 14, 2010 5:47:49 PM

Deinstallation

Achtung! Nicht im Live System - DB wird evlt. gestoppt!!!

Cluster:

emca -deconfig dbcontrol db -repos drop -cluster

Weitere Infos

Falls man die Portnummer vergessen hat unter „$ORACLE_HOME/install/portlist.ini“ nachschauen!


Probleme mit den Umgebungsvariablen- OC4J Configuration issue.

Problem: emctl meldet einen OC4J Configuration issue

emctl status dbconsole
OC4J Configuration issue. /opt/oracle/product/11.2.0.4/dbhome_1/oc4j/j2ee/OC4J_DBConsole_gpirac1_GPIDB not found.

Lösung - Oracle Datenbank Name und der Oracle Host Name müssen genau auch den Pfald unter $ORACLE_HOME/oc4j/j2ee/OC4J* entprechen!

export ORACLE_UNQNAME=TNG3IP
export ORACLE_HOSTNAME=tng3db01
Diese Website verwendet Cookies. Durch die Nutzung der Website stimmen Sie dem Speichern von Cookies auf Ihrem Computer zu. Außerdem bestätigen Sie, dass Sie unsere Datenschutzbestimmungen gelesen und verstanden haben. Wenn Sie nicht einverstanden sind, verlassen Sie die Website.Weitere Information
dba/install_dbconsole.txt · Zuletzt geändert: 2016/04/22 21:12 von gpipperr