安装数据库完毕之后发现em无法登录,才想起来建数据时没注意到这回事,重新配置
Oracle@linux:~> sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 5 09:44:14 2012Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select * from v$version;BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - ProductionSQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@tbslinux:~> emca -config dbcontrol dbSTARTED EMCA at Jan 5, 2012 9:49:10 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: ticket
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/product/11g/db_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 settingsDatabase ORACLE_HOME ................ /oracle/product/11g/db_1Local hostname ................ tbslinux
Listener ORACLE_HOME ................ /oracle/product/11g/db_1
Listener port number ................ 1521
Database SID ................ ticket
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ............... -----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jan 5, 2012 9:50:32 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_49_09.log.
Jan 5, 2012 9:50:33 AM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: "job_queue_processes" must be greater than or equal to 1. Fix the error(s) and run EM Configuration Assistant again in standalone mode.
Jan 5, 2012 9:50:33 AM oracle.sysman.emcp.EMConfig perform
SEVERE: "job_queue_processes" must be greater than or equal to 1. Fix the error(s) and run EM Configuration Assistant again in standalone mode.
Refer to the log file at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_49_09.log for more details.
Could not complete the configuration. Refer to the log file at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_49_09.log for more details.
oracle@linux:~> sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 5 09:56:05 2012Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn / as sysdba
Connected.
SQL> alter system set job_queue_processes=5;System altered.SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@tbslinux:~>
oracle@linux:~> emca -config dbcontrol dbSTARTED EMCA at Jan 5, 2012 9:58:37 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: ticket
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/product/11g/db_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 settingsDatabase ORACLE_HOME ................ /oracle/product/11g/db_1Local hostname ................ tbslinux
Listener ORACLE_HOME ................ /oracle/product/11g/db_1
Listener port number ................ 1521
Database SID ................ ticket
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ............... -----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jan 5, 2012 9:59:03 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/cfgtoollogs/emca/ticket/emca_2012_01_05_09_58_36.log.
Jan 5, 2012 9:59:20 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jan 5, 2012 10:01:08 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jan 5, 2012 10:01:14 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Jan 5, 2012 10:01:14 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Jan 5, 2012 10:02:17 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Jan 5, 2012 10:02:17 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jan 5, 2012 10:03:59 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jan 5, 2012 10:03:59 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jan 5, 2012 10:07:42 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jan 5, 2012 10:07:42 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is
https://linux:1158/em <<<<<<<<<<<
Jan 5, 2012 10:07:51 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /oracle/product/11g/db_1/tbslinux_ticket/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost. ***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jan 5, 2012 10:07:51 AM
oracle@linux:~> emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://tbslinux:1158/em/console/aboutApplication - An instance of Oracle Enterprise Manager 11g Database Control is already running.以此为记 impdp导入数据无权限ORA-39213错误增加Oracle数据库最大连接数相关资讯 Oracle基础教程
- Oracle块编程返回结果集详解 (11/10/2013 10:45:58)
- Oracle基础教程之设置系统全局区 (08/22/2013 14:24:00)
- Oracle基础教程知识点总结 (06/18/2013 07:43:32)
| - Oracle基础教程之tkprof程序详解 (10/22/2013 11:49:50)
- Oracle基础教程之sqlplus汉字乱码 (07/18/2013 16:30:00)
- Oracle 管理之 Linux 网络基础 (02/16/2013 18:37:35)
|
本文评论 查看全部评论 (0)