Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

EMCA 10g Release 1


The EMCA command parameters have changed from Ora10gR1 to Ora10gR2; if you still have Release 1 installed you must be aware that the EMCA parameters used in that release were completely different to the parameters in 10gR2. I would go so far as to say that one of the very few things these releases have in common is the tool name.

EMCA 10gR1 syntax

emca [options] [list of parameters][options] = -[a|b|c|e <node>| f <node>|h|m|n <ndoe>|r|s|x <db>|RMI_PORT <port>|JMS_PORT <port>| AGENT_PORT <port>|DBCONSOLE_HTTP <port>]
EMCA 10 g Release 1syntax[list of parameters] = [HOST | SID | PORT | ORALCE_HOME | LISTENER | HOST_USER | HOST_USER_PWD | BACKUP_HOUR | BACKUP_MINUTE | ARCHIVE_LOG | EMAIL_ADDRESS | MAIL_SERVER | MAIL_SERVER_NAME | ASM_OH | ASM_SID | ASM_PORT | ASM_USER_ROLE | AMS_USER_NAME | ASM_USER_PWD | EM_HOME | DBSNMP_PWD | SYSMAN_PWD | SYS_PWD | CLUSTER_NAME | DB_NAME | SERVICE_NAME | ]

EMCA 10gR1 options

Parameter

Description...