11g database 单机创建database control,遇到问题:
(1) listener 没起,lsnrctl start
(2)日志报 没权限:orapwd 重建密码文件
(3)ORACLE_UNQNAME export ORACLE_UNQNAME=$ORACLE_SID
(4)手工建库后,有些脚本没执行:补执行(看提示)
Connected to an idle instance.
SQL> startup ;
ORACLE instance started.
Total System Global Area 836976640 bytes
Fixed Size 1339740 bytes
Variable Size 507514532 bytes
Database Buffers 322961408 bytes
Redo Buffers 5160960 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rhel6 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-NOV-2014 13:39:35
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@rhel6 ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 20-NOV-2014 13:39:41
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/rhel6/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 20-NOV-2014 13:39:41
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/rhel6/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@rhel6 ~]$ clear;
[oracle@rhel6 ~]$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Nov 20, 2014 1:40:20 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: ocm
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN 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 ................ /u01/app/oracle/product/11.2.0
Local hostname ................ rhel6
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0
Listener port number ................ 1521
Database SID ................ ocm
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Nov 20, 2014 1:40:46 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/ocm/emca_2014_11_20_13_40_19.log.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/ocm/emca_2014_11_20_13_40_19.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/ocm/emca_2014_11_20_13_40_19.log for more details.
[oracle@rhel6 ~]$ tail -100 ^C
[oracle@rhel6 ~]$ tail -100 /u01/app/oracle/cfgtoollogs/emca/ocm/emca_2014_11_20_13_40_19.log
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_rhel6.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/oui
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Homes to scan for used ports: [/u01/app/oracle/product/11.2.0]
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME /u01/app/oracle/product/11.2.0
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking JMS port: null from /u01/app/oracle/product/11.2.0/oc4j/j2ee/OC4J_DBConsole
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking RMI port: null from /u01/app/oracle/product/11.2.0/oc4j/j2ee/OC4J_DBConsole
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking HTTP port: null from /u01/app/oracle/product/11.2.0/oc4j/j2ee/OC4J_DBConsole
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.PortManager getAgentPort
CONFIG: Cannot parse EMD_URL correctly. No port identified
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking Agent port: null from /u01/app/oracle/product/11.2.0/sysman/config/emd.properties
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Cannnot parse EMD_URL correctly. No port identified
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.FileUtil getProperties
CONFIG: Error reading file /u01/app/oracle/product/11.2.0/install/staticports.ini
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.PortManager getFreePorts
CONFIG: /u01/app/oracle/product/11.2.0:rhel6:null:ocm:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_rhel6.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: AGENT_PORT_rhel6 value: 3938
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_rhel6.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DBCONTROL_HTTP_PORT_rhel6 value: 1158
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT_rhel6.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: JMS_PORT_rhel6 value: 5540
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT_rhel6.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: RMI_PORT_rhel6 value: 5520
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.EMDBPreConfig getFreePorts
CONFIG: Ports assigned for Node: rhel6 : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
CONFIG: File: /u01/app/oracle/product/11.2.0/rhel6_ocm/sysman/emd/agntstmp.txt:rhel6 does not exists.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=rhel6)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ocm)))
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database ocm : rhel6
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: rhel6
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1521
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: ocm, oracleHome: /u01/app/oracle/product/11.2.0, and user: SYS
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: ORA-01031: insufficient privileges
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1898)
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3230)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:203)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/ocm/emca_2014_11_20_13_40_19.log for more details.
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3245)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:203)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
Nov 20, 2014 1:40:47 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/oui
[oracle@rhel6 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 20 13:49:59 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter romote_login
SQL> show parameter remote_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_dependencies_mode string TIMESTAMP
remote_listener string
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
result_cache_remote_expiration integer 0
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rhel6 ~]$ orapwd
Usage: orapwd file=entries=force=ignorecase=nosysdba=where
file - name of password file (required),
password - password for SYS will be prompted if not specified at command line,
entries - maximum number of distinct DBA (optional),
force - whether to overwrite existing file (optional),
ignorecase - passwords are case-insensitive (optional),
nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
There must be no spaces around the equal-to (=) character.
[oracle@rhel6 ~]$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=sys entries=5
[oracle@rhel6 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 20 13:51:49 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> conn sys/sys as sysdba
Connected.
SQL> show user;
USER is "SYS"
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rhel6 ~]$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Nov 20, 2014 1:52:11 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: ocm
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN 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 ................ /u01/app/oracle/product/11.2.0
Local hostname ................ rhel6
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0
Listener port number ................ 1521
Database SID ................ ocm
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Nov 20, 2014 1:52:33 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/ocm/emca_2014_11_20_13_52_11.log.
Nov 20, 2014 1:52:33 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 20, 2014 1:52:35 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Nov 20, 2014 1:52:35 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 20, 2014 1:56:44 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 20, 2014 1:56:47 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 20, 2014 1:57:19 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 20, 2014 1:57:20 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for rhel6
Nov 20, 2014 1:57:22 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Nov 20, 2014 1:57:22 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Nov 20, 2014 1:57:46 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Nov 20, 2014 1:57:46 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 20, 2014 1:59:09 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Nov 20, 2014 1:59:09 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 20, 2014 1:59:37 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 20, 2014 1:59:37 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is <<<<<<<<<<<
Nov 20, 2014 1:59:40 PM 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: /u01/app/oracle/product/11.2.0/rhel6_ocm/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 Nov 20, 2014 1:59:40 PM
[oracle@rhel6 ~]$
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28743704/viewspace-1340280/,如需转载,请注明出处,否则将追究法律责任。