• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2208
  • Last Modified:

Run emca from command line

I installed 10g server software only.  Now I'm trying to configure Enterprise Manager Database Control
I put in this command line:

-bash-3.00$ $ORACLE_HOME/bin/emca -config dbcontrol AA60 -repos create -silent -respFile '/udata/10g_R_1/Disk1/response/emca.rsp' -HOST ION -SID AA60 -PORT 1521 -ORACLE_HOME '/u01/app/oracle/product/10.1.0/db_1' -HOST_USER oracle -HOST_USER_PWD xoxomos -EMAIL_ADDRESS xoxomos@ion.net -MAIL_SERVER_NAME smtp.ion.edu -dbsnmp_pwd wiz0ora -sysman_pwd wiz0ora

And get :  
Incorrect usage:
oracle.sysman.emcp.EMConfigAssistant [options] [list of parameters]
Options:
        -a          :configure for an ASM database
        -b          :configure for automatic backup
        -c          :configure a cluster database
        -d          :run EMCA from within the development view
        -e <node>   :remove a node from the cluster
        -f <file>   :specify the file name that contains parameter values
        -h          :help
        -m          :configure for central mode
        -n <node>   :add a new node to the cluster
        -r          :skip creation of repository schema
        -s          :silent mode (no user prompts
        -x <db>     :deletion of a SID or DB

The script will prompt for any required data that is not specified in a configuration file.  The script always prompts for all required passwords.  If you use a configuration file, the file may contain any of the following specifications, as shown, with the specified values correctly filled in:

Parameters for single instance databases:
        HOST=<Database hostname>
        SID=<Database SID>
        PORT=<Listener port number>
        ORACLE_HOME=<Database ORACLE_HOME>
        LISTENER=<Listener name>
        HOST_USER=<Host user name for automatic backup>
        HOST_USER_PWD=<Host user password for automatic backup>
        BACKUP_HOUR=<Automatic backup hour in number>
        BACKUP_MINUTE=<Automatic backup minute in number>
        ARCHIVE_LOG=<Archive log>
        EMAIL_ADDRESS=<Email address for automatic notification>
        MAIL_SERVER_NAME=<Email gateway for automatic notification>
        ASM_OH=<ASM ORACLE_HOME>
        ASM_SID=<ASM SID>
        ASM_PORT=<ASM port>
        ASM_USER_ROLE=<ASM user role>
        ASM_USER_NAME=<ASM user name>
        ASM_USER_PWD=<ASM user password>
        EM_HOME=<Enterprise Manager ORACLE_HOME>
        DBSNMP_PWD=<Password for dbsnmp>
        SYSMAN_PWD=<Password for sysman>
        SYS_PWD=<Password for sys>

Parameters for cluster databses:
        HOST=<Database Instance hostname>
        PORT=<Listener port number>
        LISTENER=<Listener name>
        ORACLE_HOME=<Database ORACLE_HOME>
        CLUSTER_NAME=<Cluster name>
        DB_NAME=<Database name>
        SERVICE_NAME=<Service name>
        HOST_USER=<Host user name for automatic backup>
        HOST_USER_PWD=<Host user password for automatic backup>
        BACKUP_HOUR=<Automatic backup hour in number>
        BACKUP_MINUTE=<Automatic backup minute in number>
        ARCHIVE_LOG=<Archive log>
        EMAIL_ADDRESS=<Email address for automatic notification>
        MAIL_SERVER_NAME=<Email gateway for automatic notification>
        ASM_OH=<ASM ORACLE_HOME>
        ASM_PORT=<ASM port>
        ASM_USER_ROLE=<ASM user role>
        ASM_USER_NAME=<ASM user name>
        ASM_USER_PWD=<ASM user password>
        EM_HOME=<Enterprise Manager ORACLE_HOME>
        DBSNMP_PWD=<Password for dbsnmp>
        SYSMAN_PWD=<Password for sysman>
        SYS_PWD=<Password for sys>

How do i set up that command line
0
xoxomos
Asked:
xoxomos
  • 4
  • 2
1 Solution
 
paquicubaCommented:
Try:
-bash-3.00$ $ORACLE_HOME/bin/emca -config dbcontrol db -repos create -silent -respFile '/udata/10g_R_1/Disk1/response/emca.rsp' -HOST ION -SID AA60 -PORT 1521 -ORACLE_HOME '/u01/app/oracle/product/10.1.0/db_1' -HOST_USER oracle -HOST_USER_PWD xoxomos -EMAIL_ADDRESS xoxomos@ion.net -MAIL_SERVER_NAME smtp.ion.edu -dbsnmp_pwd wiz0ora -sysman_pwd wiz0ora

Or:

emca -config dbcontrol db -repos create

STARTED EMCA at May 22, 2006 8:17:17 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: PROD                                                          <<-------- Pass SID at runtime
Database Control is already configured for the database PROD
You have chosen to configure Database Control for managing the database PROD
This will remove the existing configuration and the default settings and perform
 a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]:    <<--------- Yes, You will be prompted for the rest
0
 
xoxomosAuthor Commented:

Yes, i forgot to mention.  I'm trying on 10.1.0.  That is exactly how it worked for me also in 10.2.0.

-bash-3.00$ emca -config dbcontrol db -repos create
Incorrect usage:
oracle.sysman.emcp.EMConfigAssistant [options] [list of parameters]
Options:
        -a          :configure for an ASM database
        -b          :configure for automatic backup
        -c          :configure a cluster database
        -d          :run EMCA from within the development view
        -e <node>   :remove a node from the cluster
        -f <file>   :specify the file name that contains parameter values
        -h          :help
        -m          :configure for central mode
        -n <node>   :add a new node to the cluster
        -r          :skip creation of repository schema
        -s          :silent mode (no user prompts
        -x <db>     :deletion of a SID or DB

The script will prompt for any required data that is not specified in a configuration file.  The script always prompts for all required passwords.  If you use a configuration file, the file may contain any of the following specifications, as shown, with the specified values correctly filled in:

Parameters for single instance databases:
        HOST=<Database hostname>
        SID=<Database SID>
        PORT=<Listener port number>
        ORACLE_HOME=<Database ORACLE_HOME>
        LISTENER=<Listener name>
        HOST_USER=<Host user name for automatic backup>
        HOST_USER_PWD=<Host user password for automatic backup>
        BACKUP_HOUR=<Automatic backup hour in number>
        BACKUP_MINUTE=<Automatic backup minute in number>
        ARCHIVE_LOG=<Archive log>
        EMAIL_ADDRESS=<Email address for automatic notification>
        MAIL_SERVER_NAME=<Email gateway for automatic notification>
        ASM_OH=<ASM ORACLE_HOME>
        ASM_SID=<ASM SID>
        ASM_PORT=<ASM port>
        ASM_USER_ROLE=<ASM user role>
        ASM_USER_NAME=<ASM user name>
        ASM_USER_PWD=<ASM user password>
        EM_HOME=<Enterprise Manager ORACLE_HOME>
        DBSNMP_PWD=<Password for dbsnmp>
        SYSMAN_PWD=<Password for sysman>
        SYS_PWD=<Password for sys>
0
 
paquicubaCommented:
You only need EMCA in 10g R1

-bash-3.00$ emca
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
xoxomosAuthor Commented:
I'm not seeing a SYSAUX tablespace anywhere.  With 10.2 the configuration assistant created a SYSAUX??
0
 
xoxomosAuthor Commented:
The response file has an entry to create the SYSAUX tablespace or not.  I did not.
0
 
xoxomosAuthor Commented:
You need to include entries there to build a repository.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now