oracle 11g em配置数据库

oracle 11g em配置数据库

ora11g-> emca -config dbcontrol db

EMCA 开始于 2016-1-31 15:20:53
EM Configuration Assistant, 11.2.0.3.0 正式版
版权所有 (c) 2003, 2011, Oracle。保留所有权利。


输入以下信息:
数据库 SID: oradb
监听程序端口号: 1521
监听程序 ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db_1 ]: 
SYS 用户的口令:  e
DBSNMP 用户的口令: cle
SYSMAN 用户的口令:  e
通知的电子邮件地址 (可选): 
通知的发件 (SMTP) 服务器 (可选): 
ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db_1 ]: 
ASM SID [ +ASM ]: 
ASM 端口 [ 1521 ]: 
ASM 用户名 [ ASMSNMP ]: 
ASM 用户口令:  e
-----------------------------------------------------------------


已指定以下设置


数据库 ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1


本地主机名 ................ ora11g
监听程序 ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
监听程序端口号 ................ 1521
数据库 SID ................ oradb
通知的电子邮件地址 ............... 
通知的发件 (SMTP) 服务器 ............... 
ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
ASM SID ................ +ASM
ASM 端口 ................ 1521
ASM 用户角色 ................ SYSDBA
ASM 用户名 ................ ASMSNMP


-----------------------------------------------------------------
是否继续? [是(Y)/否(N)]: y
2016-1-31 15:21:46 oracle.sysman.emcp.EMConfig perform
信息: 正在将此操作记录到 /u01/app/oracle/cfgtoollogs/emca/oradb/emca_2016_01_31_15_20_52.log。
2016-1-31 15:21:51 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
信息: 正在将配置数据上载到 EM 资料档案库 (此操作可能需要一段时间)...
2016-1-31 15:23:07 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功上载配置数据
2016-1-31 15:23:08 oracle.sysman.emcp.ParamsManager getLocalListener
警告: 检索 ora11g 的监听程序时出错
2016-1-31 15:23:09 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
信息: 正在保护 Database Control (此操作可能需要一段时间)...
2016-1-31 15:23:43 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
信息: 已成功保护 Database Control。
2016-1-31 15:23:43 oracle.sysman.emcp.util.DBControlUtil startOMS
信息: 正在启动 Database Control (此操作可能需要一段时间)...
2016-1-31 15:24:20 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: 已成功启动 Database Control
2016-1-31 15:24:21 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: >>>>>>>>>>> Database Control URL 为 https://ora11g:1158/em <<<<<<<<<<<
2016-1-31 15:24:24 oracle.sysman.emcp.EMDBPostConfig invoke
警告: 
************************  WARNING  ************************


管理资料档案库已置于安全模式下, 在此模式下将对 Enterprise Manager 数据进行加密。加密密钥已放置在文件 /u01/app/oracle/product/11.2.0/db_1/ora11g_oradb/sysman/config/emkey.ora 中。请务必备份此文件, 因为如果此文件丢失, 则加密数据将不可用。


***********************************************************
已成功完成 Enterprise Manager 的配置
EMCA 结束于 2016-1-31 15:24:24
ora11g-> 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://ora11g:1158/em/console/aboutApplication

Oracle Enterprise Manager 11g is running. 

对应日志：

Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/ora11g_oradb/sysman/log 


2016-1-31 15:24:20 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: 已成功启动 Database Control
2016-1-31 15:24:20 oracle.sysman.emcp.util.PlatformInterface isPre112Home
配置: oracleHome: /u01/app/oracle/product/11.2.0/db_1 isPre112Home: false
2016-1-31 15:24:20 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: isLocalNodeDone: true localNode: null
2016-1-31 15:24:20 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2016-1-31 15:24:21 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: isLocalNodeDone: true localNode: null
2016-1-31 15:24:21 oracle.sysman.emcp.EMDBPostConfig addUrl
配置: 正在更新文件 /u01/app/oracle/product/11.2.0/db_1/install/readme.txt...
2016-1-31 15:24:21 oracle.sysman.emcp.util.FileUtil _copyFile
配置: 正在将文件 /u01/app/oracle/product/11.2.0/db_1/install/readme.txt 复制到 /u01/app/oracle/product/11.2.0/db_1/install/readme.txt.emca.util.tmp
2016-1-31 15:24:21 oracle.sysman.emcp.util.FileUtil backupFile
配置: 原始文件 /u01/app/oracle/product/11.2.0/db_1/install/readme.txt 已被复制到 /u01/app/oracle/product/11.2.0/db_1/install/readme.txt.emca.util.tmp
2016-1-31 15:24:21 oracle.sysman.emcp.EMDBPostConfig addUrl
配置: Writing the selected url to readme.txt 
2016-1-31 15:24:21 oracle.sysman.emcp.EMDBPostConfig addUrl
配置: Removing existing entries from readme.txt Enterprise Manager Database Control URL - (oradb) :
2016-1-31 15:24:21 oracle.sysman.emcp.util.FileUtil _copyFile
配置: 正在将文件 /u01/app/oracle/product/11.2.0/db_1/install/readme.txt.emca.util.tmp 复制到 /u01/app/oracle/product/11.2.0/db_1/install/readme.txt
2016-1-31 15:24:21 oracle.sysman.emcp.EMDBPostConfig addUrl
配置: 文件 /u01/app/oracle/product/11.2.0/db_1/install/readme.txt 已成功更新
2016-1-31 15:24:21 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: isLocalNodeDone: true localNode: null
2016-1-31 15:24:21 oracle.sysman.emcp.util.PlatformInterface isPre112Home
配置: oracleHome: /u01/app/oracle/product/11.2.0/db_1 isPre112Home: false
2016-1-31 15:24:21 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2016-1-31 15:24:21 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: isLocalNodeDone: true localNode: null
2016-1-31 15:24:21 oracle.sysman.emcp.EMDBPostConfig performConfiguration
信息: >>>>>>>>>>> Database Control URL 为 https://ora11g:1158/em <<<<<<<<<<<
2016-1-31 15:24:21 oracle.sysman.emcp.util.DBControlUtil prepareEmkeyCmdList
配置: Value of EMKEY_LOCATION : null/emkey.ora
2016-1-31 15:24:21 oracle.sysman.emcp.util.PlatformInterface addEnvVarToList
配置: Value for env var 'DISPLAY' is 'null', discarding the same
2016-1-31 15:24:21 oracle.sysman.emcp.util.PlatformInterface addEnvVarToList
配置: Value for env var 'TZ' is 'null', discarding the same
2016-1-31 15:24:21 oracle.sysman.emcp.util.PlatformInterface getEnvProps
配置: Returning env array from cache
2016-1-31 15:24:21 oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
配置: New Env List: [CLASSPATH=/u01/app/oracle/product/11.2.0/db_1/jlib/emca.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/srvm.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/srvmasm.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/cvu.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/emConfigInstall.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/ldapjclnt11.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/ldap.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/share.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/srvmhas.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/netcfg.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/http_client.jar:/u01/app/oracle/product/11.2.0/db_1/lib/http_client.jar:/u01/app/oracle/product/11.2.0/db_1/lib/xmlparserv2.jar:/u01/app/oracle/product/11.2.0/db_1/assistants/jlib/assistantsCommon.jar:/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emCORE.jar:/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emagentSDK.jar:/u01/app/oracle/product/11.2.0/db_1/oui/jlib/OraInstaller.jar:/u01/app/oracle/product/11.2.0/db_1/oui/jlib/OraPrereq.jar:/u01/app/oracle/product/11.2.0/db_1/inventory/prereqs/oui/OraPrereqChecks.jar:/u01/app/oracle/product/11.2.0/db_1/oui/jlib/OraPrereqChecks.jar:, CVS_RSH=ssh, DYLD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/lib:, EDITOR=vi, G_BROKEN_FILENAMES=1, HISTCONTROL=ignoredups, HISTSIZE=1000, HOME=/home/oracle, HOSTNAME=ora11g, LANG=zh_CN.UTF-8, LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/jdk/jre/lib/amd64/server:/u01/app/oracle/product/11.2.0/db_1/jdk/jre/lib/amd64:/u01/app/oracle/product/11.2.0/db_1/jdk/jre/../lib/amd64:/u01/app/oracle/product/11.2.0/db_1/lib:/u01/app/oracle/product/11.2.0/db_1/perl/lib:/u01/app/oracle/product/11.2.0/db_1/network/lib:/u01/app/oracle/product/11.2.0/db_1/lib32:/u01/app/oracle/product/11.2.0/db_1/network/lib32:/u01/app/oracle/product/11.2.0/db_1/lib:/lib:/usr/lib, LESSOPEN=|/usr/bin/lesspipe.sh %s, LIBPATH=/u01/app/oracle/product/11.2.0/db_1/lib:, LOGNAME=oracle, LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:, MAIL=/var/spool/mail/oracle, NEED_EXIT_CODE=1, NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat, NLS_DATE_FORMAT=yyyy-mm-dd hh24:mi:ss, NLS_LANG=american_america.AL32UTF8, ORACLE_BASE=/u01/app/oracle, ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1, ORACLE_HOSTNAME=ora11g, ORACLE_SID=oradb, ORACLE_TERM=xterm, ORACLE_UNQNAME=oradb, PATH=/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/home/oracle/bin:/home/oracle/bin, PWD=/home/oracle, QTDIR=/usr/lib64/qt-3.3, QTINC=/usr/lib64/qt-3.3/include, QTLIB=/usr/lib64/qt-3.3/lib, SHELL=/bin/bash, SHLIB_PATH=/u01/app/oracle/product/11.2.0/db_1/lib:, SHLVL=2, SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass, TERM=vt100, TMP=/tmp, TMPDIR=/tmp, TNS_ADMIN=/u01/app/oracle/product/11.2.0/db_1/network/admin, USER=oracle, XFILESEARCHPATH=/usr/dt/app-defaults/%L/Dt, _=/u01/app/oracle/product/11.2.0/db_1/jdk/jre/bin/java]
2016-1-31 15:24:21 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: 开始执行: /u01/app/oracle/product/11.2.0/db_1/bin/emctl config emkey -remove_from_repos 
2016-1-31 15:24:24 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: Exit value of 0
2016-1-31 15:24:24 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: 已成功执行 /u01/app/oracle/product/11.2.0/db_1/bin/emctl config emkey -remove_from_repos 
2016-1-31 15:24:24 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
Please enter repository password: 


The Em Key has been removed from the Management Repository.
Make a backup copy of OH/sysman/config/emkey.ora file and store it on another machine.
WARNING: Encrypted data in Enterprise Manager will become unusable if the emkey.ora file is lost or corrupted.


2016-1-31 15:24:24 oracle.sysman.emcp.util.PlatformInterface executeCommand
配置: stty: 标准输入: 无效的参数
stty: 标准输入: 无效的参数


2016-1-31 15:24:24 oracle.sysman.emcp.util.DBControlUtil secureEmkey
配置: 已从管理资料档案库中成功删除 EM 密钥。
2016-1-31 15:24:24 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2016-1-31 15:24:24 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: isLocalNodeDone: true localNode: null
2016-1-31 15:24:24 oracle.sysman.emcp.EMDBPostConfig invoke
警告: 
************************  WARNING  ************************


管理资料档案库已置于安全模式下, 在此模式下将对 Enterprise Manager 数据进行加密。加密密钥已放置在文件 /u01/app/oracle/product/11.2.0/db_1/ora11g_oradb/sysman/config/emkey.ora 中。请务必备份此文件, 因为如果此文件丢失, 则加密数据将不可用。


***********************************************************
2016-1-31 15:24:24 oracle.sysman.emcp.EMConfig restoreOuiLoc
配置: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui