oracle linux 6.5 安装 oracle 12cR2数据库(3)-手工静默建CDB库

时间:2022-06-12 23:43:40

 

参考步骤:

dbca -silent -createDatabase -templateName General_Purpose.dbc 

 -gdbname oradb.example.com -sid oradb -responseFile NO_VALUE 

 -characterSet AL32UTF8 -memoryPercentage 30 -emConfiguration LOCAL 

 

Enter SYSTEM user password: 

password 

Enter SYS user password: 

password 

Copying database files 

1% complete 

3% complete 

... 

 

 

案例:

 

第一步,执行dbca静默安装命令:

[oracle@db01 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname CDBT -sid CDBT -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 30 -

emConfiguration LOCAL -createAsContainerDatabase true -sysPassword oracle -systemPassword oracle[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.

CAUSE:

a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].

b.The password entered is a keyword that Oracle does not recommend to be used as password

ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.

[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.

CAUSE:

a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].

b.The password entered is a keyword that Oracle does not recommend to be used as password

ACTION: Specify a strong password. If required refer Oracle documentation for guidelines.

Copying database files

1% complete

2% complete

18% complete

33% complete

Creating and starting Oracle instance

35% complete

40% complete

41% complete

42% complete

46% complete

51% complete

52% complete

53% complete

55% complete

Completing Database Creation

56% complete

58% complete

59% complete

62% complete

65% complete

66% complete

Executing Post Configuration Actions

100% complete

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/CDBT/CDBT.log" for further details.

 

输出提示用户密码是弱密码不符合要求,忽略

 

 

第二步,创建可插拔数据库PDB

 

[oracle@db01 ~]$ export ORACLE_SID=CDBT

[oracle@db01 ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 12.2.0.1.0 Production on Mon May 8 21:02:07 2017

 

Copyright (c) 1982, 2016, Oracle. All rights reserved.

 

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

 

SQL> create pluggable database pdbt1 admin user pdb1adm identified by oracle file_name_convert=('/u01/app/oracle/oradata/CDBT/pdbseed','/u01/app/oracle/oradata/CDBT/pdbt1'

);

Pluggable database created.

#只有手工创建的CDB才有种子pdb文件 DBCA创建的只有pdbseed目录,但无内容

 

查询pdb的状态为mounted,注意mounted状态其实就是close状态

SQL> show pdbs

 

将pdb库置为打开open

SQL> alter pluggable database all/PDBT1 open;

SQL> show pdbs

 

CON_ID CON_NAME             OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

     2 PDB$SEED             READ ONLY NO

     3 PDBT1             READ WRITE NO

 

 

参考:

Adm guide book:Creating a Database with DBCA

 

语法:

template_name

[-cloneTemplate]

-gdbName global_database_name

[-sid database_system_identifier]

[-createAsContainerDatabase {true | false}

[-numberOfPDBs integer]

[-pdbName pdb_name]]

[-sysPassword sys_user_password]

[-systemPassword system_user_password]

[-emConfiguration {DBEXPRESS | CENTRAL | BOTH | NONE}

-dbsnmpPassword DBSNMP_user_password

[-omsHost EM_management_server_host_name

-omsPort EM_management_server_port_number

-emUser EM_admin_username

-emPassword EM_admin_user_password]]

[-dvConfiguration {true | false}

-dvUserName Database_Vault_owner_username

-dvUserPassword Database_Vault_owner_password

-dvAccountManagerName Database_Vault_account_manager

-dvAccountManagerPassword Database_Vault_account_manager_password]

[-olsConfiguration {true | false}]

[-datafileDestination directory | -datafileNames text_file_location]

[-redoLogFileSize integer]

[-recoveryAreaDestination destination_directory]

[-datafileJarLocation jar_file_location]

[-storageType {FS | ASM}

[-asmsnmpPassword asmsnmp_password]

-diskGroupName disk_group_name

-recoveryGroupName recovery_area_disk_group_name]

[-characterSet database_character_set]

[-nationalCharacterSet database_national_character_set]

[-registerWithDirService {true | false}

-dirServiceUserName directory_service_user_name

-dirServicePassword directory_service_password

-walletPassword wallet_password]

[-listeners list_of_listeners]

[-variablesFile variable_file]

[-variables variable_list]

[-initParams parameter_list]

[-sampleSchema {true | false}]

[-memoryPercentage integer]

[-automaticMemoryManagement]

[-totalMemory integer]

[-databaseType {MULTIPURPOSE | DATA_WAREHOUSING | OLTP}]

-serviceUserPassword Windows_Oracle_Home_service_user_password

 

 

Parameter

Required/Optional

Description

-templateName template_name

Required

Name of an existing template in the default location or the complete path to a template that is not in the default location

-cloneTemplate

Optional

Indicates that the template is a seed template

A seed template contains both the structure and the physical data files of an existing database. When the template file extension is .dbc, DBCA treats it as seed template by default.

-gdbName global_database_name

Required

Global database name in the form database_name.domain_name

-sid database_system_identifier

Optional

Database system identifier

The SID uniquely identifies the instance that runs the database. If it is not specified, then it defaults to the database name.

-createAsContainerDatabase {true | false}

Optional

Specify true to create a CDB.

Specify false, the default, to create a non-CDB.

When true is specified, the following additional parameters are optional:

  • -numberOfPDBs: Number of PDBs to create. The default is 0 (zero).
  • -pdbName: Base name of each PDB. A number is appended to each name if -numberOfPDBs is greater than 1. This parameter must be specified if -numberOfPDBs is greater than 0 (zero).

-sysPassword sys_user_password

Optional

SYS user password for the new database

-systemPassword system_user_password

Optional

SYSTEM user password for the new database

-emConfiguration {DBEXPRESS | CENTRAL | BOTH | NONE}

Optional

When DBEXPRESSCENTRAL, or BOTH is specified, specify the following additional parameters:

  • -dbsnmpPassword: DBSNMP user password
  • -omsHost: Enterprise Manager management server host name
  • -omsPort: Enterprise Manager management server port number
  • -emUser: Host username for Enterprise Manager administrator
  • -emPassword: Host user password for Enterprise Manager administrator

-dvConfiguration {true | false}

Optional

Specify false, the default, to indicate that the database will not use Oracle Database Vault.

Specify true to configure and enable Database Vault, or specify false to not configure and enable Database Vault.

When true is specified, the following additional Database Vault parameters are required:

  • -dvUserName: Specify the Database Vault owner username.
  • -dvUserPassword: Specify Database Vault owner password.
  • -dvAccountManagerName: Specify a separate Database Vault account manager.
  • -dvAccountManagerPassword: Specify the Database Vault account manager password.

-olsConfiguration {true | false}

Optional

Specify true to configure and enable Oracle Label Security.

Specify false, the default, to indicate that the database will not use Oracle Label Security.

-datafileDestination directory

Optional

Complete path to the location of the database's data files

Note: The -datafileDestination and -datafileNames parameters are mutually exclusive.

-datafileNames text_file_location

Optional

A text file containing database objects such as control files, tablespaces, redo log files, and the SPFILE matched to their corresponding file name mappings in name=value format

Note: The -datafileDestination and -datafileNames parameters are mutually exclusive.

-redoLogFileSize integer

Optional

Size of each online redo log in megabytes

-recoveryAreaDestination directory

Optional

Destination directory for the Fast Recovery Area, which is a backup and recovery area

-datafileJarLocation jar_file_location

Optional

Location of the database offline backup (for clone database creation only)

The data files for the seed database are stored in compressed RMAN backup format in a file with a .dfb extension.

-storageType {FS | ASM}

Optional

FS for file system

When FS is specified, your database files are managed by the file system of your operating system. You specify the directory path where the database files are to be stored using a database template, the -datafileDestination parameter, or the -datafileNames parameter. Oracle Database can create and manage the actual files.

ASM for Oracle Automatic Storage Management (Oracle ASM)

When ASM is specified, your database files are placed in Oracle ASM disk groups. Oracle Database automatically manages database file placement and naming.

When ASM is specified, specify the following additional parameters:

  • -asmsnmpPasswordASMSNMP password for ASM monitoring. This parameter is optional.
  • -diskGroupName: Database area disk group name. This parameter is required.
  • -recoveryGroupName: Recovery area disk group name. This parameter is required.

-characterSet database_character_set

Optional

Character set of the database

-nationalCharacterSetdatabase_national_character_set

Optional

National character set of the database

-registerWithDirService {true | false}

Optional

Specify true to register with a Lightweight Directory Access Protocol (LDAP) service.

Specify false, the default, to not register with an LDAP service.

When true is specified, the following additional parameters are required:

  • -dirServiceUserName: Username for the LDAP service
  • -dirServicePassword: Password for the LDAP service
  • -walletPassword: Password for the database wallet

-listeners list_of_listeners

Optional

A comma-separated list of listeners for the database

-variablesFile variable_file

Optional

Complete path to the file that contains the variable-value pairs for variables in the database template

-variables variable_list

Optional

A comma-separated list of name=value pairs for the variables in the database template

-initParams parameter_list

Optional

A comma-separated list of name=value pairs of initialization parameter values for the database

-sampleSchema {true | false}

Optional

Specify true to include sample schemas (EXAMPLE tablespace) in your database. Oracle guides and educational materials contain examples based on the sample schemas. Oracle recommends that you include them in your database.

Specify false to create the database without the sample schemas.

-memoryPercentage integer

Optional

The percentage of physical memory that can be used by Oracle Database

-automaticMemoryManagement

Optional

Forces the use of the MEMORY_TARGET initialization parameter

-totalMemory integer

Optional

Total amount of physical memory, in megabytes, that can be used by the new database

-databaseType {MULTIPURPOSE | DATA_WAREHOUSING | OLTP}

Optional

Specify MULTIPURPOSE if the database is for both OLTP and data warehouse purposes.

Specify DATA_WAREHOUSING if the primary purpose of the database is a data warehouse.

Specify OLTP if the primary purpose of the database is online transaction processing.

-serviceUserPasswordWindows_Oracle_Home_service_user_password

Required

For the Windows platform only, specify the Oracle Home User password if the Oracle Home was installed using an Oracle Home User.