1. Oracle Database Commands and Tools:
- SQL*Plus: A command-line tool used for running SQL and PL/SQL commands and scripts against Oracle databases.- expdp (Export Data Pump): Used to export data and metadata from an Oracle database into a set of dump files.
- impdp (Import Data Pump): Used to import data and metadata from dump files into an Oracle database.
- DBCA (Database Configuration Assistant): DBCA is a utility provided by Oracle to simplify the creation, configuration, and management of Oracle databases.
- DBUA (Database Upgrade Assistant): DBUA is a utility provided by Oracle to automate the process of upgrading an existing Oracle database to a newer version.
- NETCA (Network Configuration Assistant): is a GUI utility that simplifies the configuration of Oracle network components.
- NETMGR (Oracle Net Manager): is a more advanced and flexible tool compared to NETCA, providing a graphical interface for detailed configuration of Oracle Net Services.
- RMAN (Recovery Manager): A command-line interface for performing backup and recovery operations in Oracle databases.
2. Golden Gate Commands:
- GGSCI (GoldenGate Software Command Interface): Used for managing, configuring, and monitoring Oracle GoldenGate processes.
- OGGCA (Oracle GoldenGate Configuration Assistant): A command-line tool for configuring Oracle GoldenGate instances.
- Logdump: A utility for viewing and analyzing trail files generated by Oracle GoldenGate.
- DEFGEN (Definition File Generator): A command-line tool used to generate definition files in heterogeneous environments.
3. Oracle Grid Infra Commands:
- CRSCTL (Cluster Ready Services Control Utility): Used to manage Oracle Clusterware components.
- SRVCTL (Service Control): Used for managing Oracle RAC databases and other resources within the cluster.
- ASMCMD (ASM Command Line Utility): A command-line tool for managing Oracle ASM instances and disks.
- CLUVFY (Cluster Verification Utility): A tool for verifying the integrity and proper configuration of Oracle RAC and Oracle Grid Infrastructure.
- CRSSTAT: A utility that provides a summary of the current status of all cluster resources.
- OCRCONFIG: Used to manage the Oracle Cluster Registry (OCR).
4. Additional commands:
-dbcli (Database Command Line Interface): Used on Oracle OCI Cloud to apply patches and upgrade oracle software like database oracle home.
- EMCLI (Oracle Enterprise Manager CLI): Used to manage and automate Oracle Enterprise Manager operations via scripts.
- OPatch: A tool for applying and rolling back patches in Oracle software installations.
- ADRCI (Automatic Diagnostic Repository Command Interpreter): Used for managing diagnostic data such as alert logs, trace files, and incidents.
- ORAPWD (Oracle Password Utility): Used for creating and managing password files for Oracle databases.
- ORAPKI (Oracle Public Key Infrastructure): is a command-line utility provided by Oracle for managing security credentials.
- DGMGRL (Data Guard Manager Command-Line Interface): is the primary command-line interface for managing Oracle Data Guard configurations.
- OPatch: A tool for applying and rolling back patches in Oracle software installations.
- ADRCI (Automatic Diagnostic Repository Command Interpreter): Used for managing diagnostic data such as alert logs, trace files, and incidents.
- ORAPWD (Oracle Password Utility): Used for creating and managing password files for Oracle databases.
- ORAPKI (Oracle Public Key Infrastructure): is a command-line utility provided by Oracle for managing security credentials.
- DGMGRL (Data Guard Manager Command-Line Interface): is the primary command-line interface for managing Oracle Data Guard configurations.
