12c create statement to create cdb

最新推荐文章于 2024-09-19 16:47:21 发布

cnk45946

最新推荐文章于 2024-09-19 16:47:21 发布

阅读量154

点赞数

文章标签：数据库操作系统

1 描述

使用create statement创建CDB数据库。

2 操作环境

2.1 OS info

[oracle@host01 ~]$ lsb_release -a

LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

Distributor ID: OracleServer

Description: Oracle Linux Server release 6.5

Release: 6.5

Codename: n/a

[oracle@host01 ~]$ uname -a

Linux host01.example.com 2.6.32-431.el6.x86_64 #1 SMP Wed Nov 20 23:56:07 PST 2013 x86_64 x86_64 x86_64 GNU/Linux

[oracle@host01 ~]$

2.2 DB software info

Db software 12.1.0.2.0

[oracle@host01 ~]$ cat ~/.bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$PATH

###注意此处PATH仅添加了$ORACLE_HOME/bin####

3 概要信息

The instructions in this section apply to single-instance installations only.

Step 1: Specify an Instance Identifier (SID)

Step 2: Ensure That the Required Environment Variables Are Set

Step 3: Choose a Database Administrator Authentication Method

Step 4: Create the Initialization Parameter File

Step 6: Connect to the Instance

Step 7: Create a Server Parameter File

Step 8: Start the Instance

Step 9: Issue the CREATE DATABASE Statement

Step 12: (Optional) Run Scripts to Install Additional Options

Step 13: Back Up the Database.

Step 5为windows上的操作，此处省略。

Step 10 、Step 11为非cdb创建方式，此处省略。

4 详细步骤操作

Step 1: Specify an Instance Identifier (SID)

[oracle@host01 ~]$ export ORACLE_SID=orcl12c

Step 2: Ensure That the Required Environment Variables Are Set

[oracle@host01 dbs]$ echo $ORACLE_BASE

/u01/app/oracle

[oracle@host01 dbs]$ echo $ORACLE_HOME

/u01/app/oracle/product/12.1.0/dbhome_1

[oracle@host01 dbs]$ echo $ORACLE_SID

orcl12c

[oracle@host01 dbs]$

Step 3: Choose a Database Administrator Authentication Method

With a password file
With operating system authentication

Step 4: Create the Initialization Parameter File

[oracle@host01 dbs]$ pwd

/u01/app/oracle/product/12.1.0/dbhome_1/dbs

[oracle@host01 dbs]$ cat initorcl12c.ora

db_name='orcl12c'

memory_target=1G

control_files = (/u01/app/oracle/oradata/orcl12c/ora_control1, /u01/app/oracle/oradata/orcl12c/ora_control2)

[oracle@host01 dbs]$

Step 6: Connect to the Instance

[oracle@host01 dbs]$ echo $ORACLE_HOME

/u01/app/oracle/product/12.1.0/dbhome_1

[oracle@host01 dbs]$ echo $ORACLE_SID

orcl12c

[oracle@host01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 31 14:46:51 2016

Connected to an idle instance.

SQL>

Step 7: Create a Server Parameter File

[oracle@host01 dbs]$ echo $ORACLE_HOME

/u01/app/oracle/product/12.1.0/dbhome_1

[oracle@host01 dbs]$ echo $ORACLE_SID

orcl12c

[oracle@host01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 31 14:46:51 2016

Connected to an idle instance.

SQL> CREATE SPFILE FROM PFILE;

File created.

SQL>

Step 8: Start the Instance

[oracle@host01 dbs]$ echo $ORACLE_HOME

/u01/app/oracle/product/12.1.0/dbhome_1

[oracle@host01 dbs]$ echo $ORACLE_SID

orcl12c

[oracle@host01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 31 14:46:51 2016

Connected to an idle instance.

SQL> CREATE SPFILE FROM PFILE;

File created.

SQL> startup nomount

ORACLE instance started.

Total System Global Area 1073741824 bytes

Fixed Size 2932632 bytes

Variable Size 616562792 bytes

Database Buffers 448790528 bytes

Redo Buffers 5455872 bytes

SQL>

Step 9: Issue the CREATE DATABASE Statement

-Example 1: Creating a CDB Without Using Oracle Managed Files

[oracle@host01 ~]$ cat create_cdb.txt

CREATE DATABASE orcl12c

USER SYS IDENTIFIED BY oracle

USER SYSTEM IDENTIFIED BY oracle

LOGFILE GROUP 1 ('/u01/app/oracle/oradata/orcl12c/redo01a.log')

SIZE 100M BLOCKSIZE 512,

GROUP 2 ('/u01/app/oracle/oradata/orcl12c/redo02a.log')

SIZE 100M BLOCKSIZE 512,

GROUP 3 ('/u01/app/oracle/oradata/orcl12c/redo03a.log')

SIZE 100M BLOCKSIZE 512

MAXLOGHISTORY 1

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 1024

CHARACTER SET AL32UTF8

NATIONAL CHARACTER SET AL16UTF16

EXTENT MANAGEMENT LOCAL

DATAFILE '/u01/app/oracle/oradata/orcl12c/system01.dbf'

SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

SYSAUX DATAFILE '/u01/app/oracle/oradata/orcl12c/sysaux01.dbf'

SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED

DEFAULT TABLESPACE deftbs

DATAFILE '/u01/app/oracle/oradata/orcl12c/deftbs01.dbf'

SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE tempts1

TEMPFILE '/u01/app/oracle/oradata/orcl12c/temp01.dbf'

SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED

UNDO TABLESPACE undotbs1

DATAFILE '/u01/app/oracle/oradata/orcl12c/undotbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED

ENABLE PLUGGABLE DATABASE

SEED

FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/orcl12c/',

'/u01/app/oracle/oradata/orcl12c/pdbseed/')

SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED

SYSAUX DATAFILES SIZE 100M

USER_DATA TABLESPACE usertbs

DATAFILE '/u01/app/oracle/oradata/orcl12c/pdbseed/usertbs01.dbf'

SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

[oracle@host01 ~]$ echo $ORACLE_HOME

/u01/app/oracle/product/12.1.0/dbhome_1

[oracle@host01 ~]$ echo $ORACLE_SID

orcl12c

[oracle@host01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 31 15:23:03 2016

Connected to:

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

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter system set ENABLE_PLUGGABLE_DATABASE=true;

alter system set ENABLE_PLUGGABLE_DATABASE=true

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set ENABLE_PLUGGABLE_DATABASE=true scope=spfile;

System altered.

SQL> startup nomount force;

ORACLE instance started.

Total System Global Area 1073741824 bytes

Fixed Size 2932632 bytes

Variable Size 616562792 bytes

Database Buffers 448790528 bytes

Redo Buffers 5455872 bytes

SQL> @create_cdb.txt

Database created.

SQL>

运行catcdb.sql脚本, 用时90分钟，生成50个日志文件。

[oracle@host01 ~]$ cat ~/.bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH

[oracle@host01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 31 15:57:41 2016

Connected to:

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

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> @?/rdbms/admin/catcdb.sql

Session altered.

Enter new password for SYS:

Enter new password for SYSTEM:

Enter temporary tablespace name: tempts1

Session altered.

Connected.

... ...

catcon: ALL catcon-related output will be written to utlrp_catcon_77831.lst

catcon: See utlrp*.log files for output generated by scripts

catcon: See utlrp_*.lst files for spool files, if any

catcon.pl: completed successfully

Connected.

Session altered.

Pluggable database altered.

PL/SQL procedure successfully completed.

Session altered.

PL/SQL procedure successfully completed.

Session altered.

Pluggable database altered.

Session altered.

SQL>

Step 12: (Optional) Run Scripts to Install Additional Options

If you plan to install other Oracle products to work with this database, then see the installation instructions for those products. Some products require you to create additional data dictionary tables. Usually, command files are provided to create and load these tables into the database data dictionary.

Step 13: Back Up the Database.

Take a full backup of the database to ensure that you have a complete set of files from which to recover if a media failure occurs.

5 个人总结

在执行完create_cdb.txt创建脚本后，需要执行catcdb.sql，This script installs all of the components required by a CDB.

注意如果环境变量中未定义perl的目录，则执行期间会报如下错误.

SQL> @?/rdbms/admin/catcdb.sql

... ...

Can't locate Term/ReadKey.pm in @INC (@INC contains: /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/) at /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pm line 189.

BEGIN failed--compilation aborted at /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pm line 189.

Compilation failed in require at /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl line 94.

BEGIN failed--compilation aborted at /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl line 94.

解决方法将ORACLE_HOME 下的 perl目录添加进PATH环境变量，like below:

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH

官方建议使用dbca创建cdb.因为这样创建好的数据库会启动到open状态。并且创建时间会大大缩短！创建时间会大大缩短！创建时间会大大缩短！

此硬件环境用时90分钟，生成50个日志文件。

关于官方文档Step 14: (Optional) Enable Automatic Instance Startup部分，由于需要安装GI，因此Step 14不做。

使用最少参数创建的cdb pfile，转换spfile启动后的参数如下:

SQL> show parameter

NAME TYPE VALUE

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

DBFIPS_140 boolean FALSE

O7_DICTIONARY_ACCESSIBILITY boolean FALSE

active_instance_count integer

aq_tm_processes integer 1

archive_lag_target integer 0

asm_diskgroups string

asm_diskstring string

asm_power_limit integer 1

asm_preferred_read_failure_groups string

audit_file_dest string /u01/app/oracle/product/12.1.0

/dbhome_1/rdbms/audit

NAME TYPE VALUE

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

audit_sys_operations boolean TRUE

audit_syslog_level string

audit_trail string NONE

awr_snapshot_time_offset integer 0

background_core_dump string partial

background_dump_dest string /u01/app/oracle/product/12.1.0

/dbhome_1/rdbms/log

backup_tape_io_slaves boolean FALSE

bitmap_merge_area_size integer 1048576

blank_trimming boolean FALSE

buffer_pool_keep string

NAME TYPE VALUE

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

buffer_pool_recycle string

cell_offload_compaction string ADAPTIVE

cell_offload_decryption boolean TRUE

cell_offload_parameters string

cell_offload_plan_display string AUTO

cell_offload_processing boolean TRUE

cell_offloadgroup_name string

circuits integer

client_result_cache_lag big integer 3000

client_result_cache_size big integer 0

clonedb boolean FALSE

NAME TYPE VALUE

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

cluster_database boolean FALSE

cluster_database_instances integer 1

cluster_interconnects string

commit_logging string

commit_point_strength integer 1

commit_wait string

commit_write string

common_user_prefix string C##

compatible string 12.0.0

connection_brokers string ((TYPE=DEDICATED)(BROKERS=1)),

((TYPE=EMON)(BROKERS=1))

NAME TYPE VALUE

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

control_file_record_keep_time integer 7

control_files string /u01/app/oracle/oradata/orcl12

c/ora_control1, /u01/app/oracl

e/oradata/orcl12c/ora_control2

control_management_pack_access string DIAGNOSTIC+TUNING

core_dump_dest string /u01/app/oracle/diag/rdbms/orc

l12c/orcl12c/cdump

cpu_count integer 2

create_bitmap_area_size integer 8388608

create_stored_outlines string

cursor_bind_capture_destination string memory+disk

NAME TYPE VALUE

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

cursor_sharing string EXACT

cursor_space_for_time boolean FALSE

db_16k_cache_size big integer 0

db_2k_cache_size big integer 0

db_32k_cache_size big integer 0

db_4k_cache_size big integer 0

db_8k_cache_size big integer 0

db_big_table_cache_percent_target string 0

db_block_buffers integer 0

db_block_checking string FALSE

db_block_checksum string TYPICAL

NAME TYPE VALUE

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

db_block_size integer 8192

db_cache_advice string ON

db_cache_size big integer 0

db_create_file_dest string

db_create_online_log_dest_1 string

db_create_online_log_dest_2 string

db_create_online_log_dest_3 string

db_create_online_log_dest_4 string

db_create_online_log_dest_5 string

db_domain string

db_file_multiblock_read_count integer 128

NAME TYPE VALUE

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

db_file_name_convert string

db_files integer 200

db_flash_cache_file string

db_flash_cache_size big integer 0

db_flashback_retention_target integer 1440

db_index_compression_inheritance string NONE

db_keep_cache_size big integer 0

db_lost_write_protect string NONE

db_name string orcl12c

db_performance_profile string

db_recovery_file_dest string

NAME TYPE VALUE

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

db_recovery_file_dest_size big integer 0

db_recycle_cache_size big integer 0

db_securefile string PREFERRED

db_ultra_safe string OFF

db_unique_name string orcl12c

db_unrecoverable_scn_tracking boolean TRUE

db_writer_processes integer 1

dbwr_io_slaves integer 0

ddl_lock_timeout integer 0

deferred_segment_creation boolean TRUE

dg_broker_config_file1 string /u01/app/oracle/product/12.1.0

NAME TYPE VALUE

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

/dbhome_1/dbs/dr1orcl12c.dat

dg_broker_config_file2 string /u01/app/oracle/product/12.1.0

/dbhome_1/dbs/dr2orcl12c.dat

dg_broker_start boolean FALSE

diagnostic_dest string /u01/app/oracle

disk_asynch_io boolean TRUE

dispatchers string

distributed_lock_timeout integer 60

dml_locks integer 888

dnfs_batch_size integer 4096

dst_upgrade_insert_conv boolean TRUE

NAME TYPE VALUE

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

enable_ddl_logging boolean FALSE

enable_goldengate_replication boolean FALSE

enable_pluggable_database boolean TRUE

event string

exclude_seed_cdb_view boolean TRUE

fal_client string

fal_server string

fast_start_io_target integer 0

fast_start_mttr_target integer 0

fast_start_parallel_rollback string LOW

file_mapping boolean FALSE

NAME TYPE VALUE

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

fileio_network_adapters string

filesystemio_options string none

fixed_date string

gcs_server_processes integer 0

global_context_pool_size string

global_names boolean FALSE

global_txn_processes integer 1

hash_area_size integer 131072

heat_map string OFF

hi_shared_memory_address integer 0

hs_autoregister boolean TRUE

NAME TYPE VALUE

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

ifile file

inmemory_clause_default string

inmemory_force string DEFAULT

inmemory_max_populate_servers integer 0

inmemory_query string ENABLE

inmemory_size big integer 0

inmemory_trickle_repopulate_servers_ integer 1

percent

instance_groups string

instance_name string orcl12c

instance_number integer 0

NAME TYPE VALUE

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

instance_type string RDBMS

instant_restore boolean FALSE

java_jit_enabled boolean TRUE

java_max_sessionspace_size integer 0

java_pool_size big integer 0

java_restrict string none

java_soft_sessionspace_limit integer 0

job_queue_processes integer 1000

large_pool_size big integer 0

ldap_directory_access string NONE

ldap_directory_sysauth string no

NAME TYPE VALUE

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

license_max_sessions integer 0

license_max_users integer 0

license_sessions_warning integer 0

listener_networks string

local_listener string

lock_name_space string

lock_sga boolean FALSE

log_archive_config string

log_archive_dest string

log_archive_dest_1 string

log_archive_dest_10 string

NAME TYPE VALUE

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

log_archive_dest_11 string

log_archive_dest_12 string

log_archive_dest_13 string

log_archive_dest_14 string

log_archive_dest_15 string

log_archive_dest_16 string

log_archive_dest_17 string

log_archive_dest_18 string

log_archive_dest_19 string

log_archive_dest_2 string

log_archive_dest_20 string

NAME TYPE VALUE

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

log_archive_dest_21 string

log_archive_dest_22 string

log_archive_dest_23 string

log_archive_dest_24 string

log_archive_dest_25 string

log_archive_dest_26 string

log_archive_dest_27 string

log_archive_dest_28 string

log_archive_dest_29 string

log_archive_dest_3 string

log_archive_dest_30 string

NAME TYPE VALUE

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

log_archive_dest_31 string

log_archive_dest_4 string

log_archive_dest_5 string

log_archive_dest_6 string

log_archive_dest_7 string

log_archive_dest_8 string

log_archive_dest_9 string

log_archive_dest_state_1 string enable

log_archive_dest_state_10 string enable

log_archive_dest_state_11 string enable

log_archive_dest_state_12 string enable

NAME TYPE VALUE

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

log_archive_dest_state_13 string enable

log_archive_dest_state_14 string enable

log_archive_dest_state_15 string enable

log_archive_dest_state_16 string enable

log_archive_dest_state_17 string enable

log_archive_dest_state_18 string enable

log_archive_dest_state_19 string enable

log_archive_dest_state_2 string enable

log_archive_dest_state_20 string enable

log_archive_dest_state_21 string enable

log_archive_dest_state_22 string enable

NAME TYPE VALUE

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

log_archive_dest_state_23 string enable

log_archive_dest_state_24 string enable

log_archive_dest_state_25 string enable

log_archive_dest_state_26 string enable

log_archive_dest_state_27 string enable

log_archive_dest_state_28 string enable

log_archive_dest_state_29 string enable

log_archive_dest_state_3 string enable

log_archive_dest_state_30 string enable

log_archive_dest_state_31 string enable

log_archive_dest_state_4 string enable

NAME TYPE VALUE

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

log_archive_dest_state_5 string enable

log_archive_dest_state_6 string enable

log_archive_dest_state_7 string enable

log_archive_dest_state_8 string enable

log_archive_dest_state_9 string enable

log_archive_duplex_dest string

log_archive_format string %t_%s_%r.dbf

log_archive_max_processes integer 4

log_archive_min_succeed_dest integer 1

log_archive_start boolean FALSE

log_archive_trace integer 0

NAME TYPE VALUE

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

log_buffer big integer 5064K

log_checkpoint_interval integer 0

log_checkpoint_timeout integer 1800

log_checkpoints_to_alert boolean FALSE

log_file_name_convert string

max_dispatchers integer

max_dump_file_size string unlimited

max_enabled_roles integer 150

max_shared_servers integer

max_string_size string STANDARD

memory_max_target big integer 1G

NAME TYPE VALUE

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

memory_target big integer 1G

nls_calendar string

nls_comp string BINARY

nls_currency string

nls_date_format string

nls_date_language string

nls_dual_currency string

nls_iso_currency string

nls_language string AMERICAN

nls_length_semantics string BYTE

nls_nchar_conv_excp string FALSE

NAME TYPE VALUE

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

nls_numeric_characters string

nls_sort string

nls_territory string AMERICA

nls_time_format string

nls_time_tz_format string

nls_timestamp_format string

nls_timestamp_tz_format string

noncdb_compatible boolean FALSE

object_cache_max_size_percent integer 10

object_cache_optimal_size integer 102400

olap_page_pool_size big integer 0

NAME TYPE VALUE

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

open_cursors integer 50

open_links integer 4

open_links_per_instance integer 4

optimizer_adaptive_features boolean TRUE

optimizer_adaptive_reporting_only boolean FALSE

optimizer_capture_sql_plan_baselines boolean FALSE

optimizer_dynamic_sampling integer 2

optimizer_features_enable string 12.1.0.2

optimizer_index_caching integer 0

optimizer_index_cost_adj integer 100

optimizer_inmemory_aware boolean TRUE

NAME TYPE VALUE

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

optimizer_mode string ALL_ROWS

optimizer_secure_view_merging boolean TRUE

optimizer_use_invisible_indexes boolean FALSE

optimizer_use_pending_statistics boolean FALSE

optimizer_use_sql_plan_baselines boolean TRUE

os_authent_prefix string ops$

os_roles boolean FALSE

parallel_adaptive_multi_user boolean TRUE

parallel_automatic_tuning boolean FALSE

parallel_degree_level integer 100

parallel_degree_limit string CPU

NAME TYPE VALUE

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

parallel_degree_policy string MANUAL

parallel_execution_message_size integer 16384

parallel_force_local boolean FALSE

parallel_instance_group string

parallel_io_cap_enabled boolean FALSE

parallel_max_servers integer 64

parallel_min_percent integer 0

parallel_min_servers integer 8

parallel_min_time_threshold string AUTO

parallel_server boolean FALSE

parallel_server_instances integer 1

NAME TYPE VALUE

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

parallel_servers_target integer 32

parallel_threads_per_cpu integer 2

pdb_file_name_convert string

pdb_lockdown string

pdb_os_credential string

permit_92_wrap_format boolean TRUE

pga_aggregate_limit big integer 2G

pga_aggregate_target big integer 0

plscope_settings string IDENTIFIERS:NONE

plsql_ccflags string

plsql_code_type string INTERPRETED

NAME TYPE VALUE

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

plsql_debug boolean FALSE

plsql_optimize_level integer 2

plsql_v2_compatibility boolean FALSE

plsql_warnings string DISABLE:ALL

pre_page_sga boolean TRUE

processes integer 120

processor_group_name string

query_rewrite_enabled string TRUE

query_rewrite_integrity string enforced

rdbms_server_dn string

read_only_open_delayed boolean FALSE

NAME TYPE VALUE

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

recovery_parallelism integer 0

recyclebin string on

redo_transport_user string

remote_dependencies_mode string TIMESTAMP

remote_listener string

remote_login_passwordfile string EXCLUSIVE

remote_os_authent boolean FALSE

remote_os_roles boolean FALSE

replication_dependency_tracking boolean TRUE

resource_limit boolean TRUE

resource_manager_cpu_allocation integer 2

NAME TYPE VALUE

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

resource_manager_plan string

result_cache_max_result integer 5

result_cache_max_size big integer 2624K

result_cache_mode string MANUAL

result_cache_remote_expiration integer 0

resumable_timeout integer 0

rollback_segments string

sec_case_sensitive_logon boolean TRUE

sec_max_failed_login_attempts integer 3

sec_protocol_error_further_action string (DROP,3)

sec_protocol_error_trace_action string TRACE

NAME TYPE VALUE

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

sec_return_server_release_banner boolean FALSE

serial_reuse string disable

service_names string orcl12c

session_cached_cursors integer 50

session_max_open_files integer 10

sessions integer 202

sga_max_size big integer 1G

sga_target big integer 0

shadow_core_dump string partial

shared_memory_address integer 0

shared_pool_reserved_size big integer 8808038

NAME TYPE VALUE

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

shared_pool_size big integer 0

shared_server_sessions integer

shared_servers integer 0

skip_unusable_indexes boolean TRUE

smtp_out_server string

sort_area_retained_size integer 0

sort_area_size integer 65536

spatial_vector_acceleration boolean FALSE

spfile string /u01/app/oracle/product/12.1.0

/dbhome_1/dbs/spfileorcl12c.or

NAME TYPE VALUE

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

sql92_security boolean FALSE

sql_trace boolean FALSE

sqltune_category string DEFAULT

standby_archive_dest string ?/dbs/arch

standby_file_management string MANUAL

star_transformation_enabled string FALSE

statistics_level string TYPICAL

streams_pool_size big integer 0

tape_asynch_io boolean TRUE

temp_undo_enabled boolean FALSE

thread integer 0

NAME TYPE VALUE

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

threaded_execution boolean FALSE

timed_os_statistics integer 0

timed_statistics boolean TRUE

trace_enabled boolean TRUE

tracefile_identifier string

transactions integer 222

transactions_per_rollback_segment integer 5

undo_management string AUTO

undo_retention integer 900

undo_tablespace string UNDOTBS1

unified_audit_sga_queue_size integer 1048576

NAME TYPE VALUE

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

use_dedicated_broker boolean FALSE

use_indirect_data_buffers boolean FALSE

use_large_pages string TRUE

user_dump_dest string /u01/app/oracle/product/12.1.0

/dbhome_1/rdbms/log

utl_file_dir string

workarea_size_policy string AUTO

xml_db_events string enable

SQL>

6 资料参考引用

Database Administration	Administrator's Guide	2 Creating and Configuring an Oracle Database
Database Administration	Administrator's Guide	37 Creating and Configuring a CDB