在 rac运行维护过程中，我们通常按照之前操作系统用于新环境， 近一次对rac19c集群操作时发现，相关参数命令有了很大的变化，rac12c以后更注重参数和操作的安全，命名方式更规范了。 我们已srvctl 命令为参考。 #### rac 19c ``` shell # 集群注册数据库服务为例 [grid@rac19c ~]$ srvctl add database -help Adds a database configuration to the Oracle Clusterware. Usage: srvctl add database -db <db_unique_name> -oraclehome <oracle_home> [-dbtype {RACONENODE | RAC | SINGLE} [-server "<server_list>"] [-instance <inst_name>] [-timeout <timeout>]] [-domain <domain_name>] [-spfile <spfile>] [-pwfile <password_file_path>] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY | FAR_SYNC}] [-startoption <start_options>] [-stopoption <stop_options>] [-startconcurrency <start_concurrency>] [-stopconcurrency <stop_concurrency>] [-dbname <db_name>] [-policy {AUTOMATIC | MANUAL | NORESTART | USERONLY}] [-serverpool "<serverpool_list>" [-pqpool <pq_server_pools>]] [-node <node_name>] [-diskgroup "<diskgroup_list>"] [-acfspath ""] [-eval] [-fixed] [-css_critical {YES | NO}] [-cpucount <cpu_count>] [-memorytarget <memory_target>] [-maxmemory <max_memory>] [-defaultnetnum <network_number>] [-verbose] -db <db_unique_name> Unique name for the database -oraclehome <path> Oracle home path -dbtype <type> Type of database: RAC One Node, RAC, or Single Instance -server "<server_list>" Candidate server list for RAC One Node database -instance <inst_name> Instance name prefix for administrator-managed RAC One Node database (default first 12 characters of <db_unique_name>) -timeout <timeout> Online relocation timeout in minutes -node <node_name> Node name (for single-instance databases) -domain <domain_name> Domain for database. Must be set if database has DB_DOMAIN set. -spfile <spfile> Server parameter file path -pwfile <password_file_path> Password file path -role <role> Role of the database (PRIMARY, PHYSICAL_STANDBY, LOGICAL_STANDBY, SNAPSHOT_STANDBY, FAR_SYNC) -startoption <start_options> Startup options for the database. Examples of startup options are OPEN, MOUNT, or "READ ONLY". -stopoption <stop_options> Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT. -dbname <db_name> Database name (DB_NAME), if different from the unique name given by the -db option -policy <dbpolicy> Management policy for the database (AUTOMATIC, MANUAL, NORESTART or USERONLY) -serverpool "<serverpool_list>" Comma separated list of database server pool names -pqpool "<pq_pool_list>" Comma separated list of parallel query server pool names -diskgroup "<diskgroup_list>" Comma separated list of disk group names -acfspath "" Comma separated list of ACFS paths where database's dependency will be set -startconcurrency <start_concurrency> Number of instances to be started simultaneously (or 0 for empty start_concurrency value) -stopconcurrency <stop_concurrency> Number of instances to be stopped simultaneously (or 0 for empty stop_concurrency value ) -eval Evaluates the effects of event without making any changes to the system -fixed Sets the HOSTING_MEMBERS attribute instead of the SERVER_POOLS attribute for a Single-Instance database(SIDB). -css_critical {YES | NO} Define whether the database or service is CSS critical -cpucount <cpu_count> Number of workload CPUs -memorytarget <memory_target> Target memory, in MB, used by the resource -maxmemory <max_memory> Maximum memory, in MB, used by the resource -defaultnetnum <network_number> Default network number for database services -verbose Verbose output -help Print usage ``` #### rac11g ``` shell ##集群注册数据库服务为例 [oracle@myasm ~]$ srvctl add database -help Adds a database configuration to be managed by Oracle Restart. Usage: srvctl add database -d <db_unique_name> -o <oracle_home> [-m <domain_name>] [-p <spfile>] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s <start_options>] [-t <stop_options>] [-n <db_name>] [-i <inst_name>] [-y {AUTOMATIC | MANUAL | NORESTART}] [-a "<diskgroup_list>"] -d <db_unique_name> Unique name for the database -o <oracle_home> ORACLE_HOME path -m <domain> Domain for database. Must be set if database has DB_DOMAIN set. -p <spfile> Server parameter file path -r <role> Role of the database (primary, physical_standby, logical_standby, snapshot_standby) -s <start_options> Startup options for the database. Examples of startup options are OPEN, MOUNT, or 'READ ONLY'. -t <stop_options> Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT. -n <db_name> Database name (DB_NAME), if different from the unique name given by the -d option -i <inst_name> Instance name -y <dbpolicy> Management policy for the database (AUTOMATIC, MANUAL, or NORESTART) -a "<diskgroup_list>" Comma separated list of disk groups -h Print usage ``` 通过以上我们可以发现，在19c中，''-db'' 后边跟数据库唯一名，11g是'-d'跟数据库唯一名，以此类推，而且19c参数多了很多，权限、资源管理也更加细化。