レジストリ HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_XE環境変数は特に設定されません。PATH 環境変数には、直接 ORACLE_HOME 内の情報でパスが設定されています。 ▼ Oracle ドキュメント 15 パラメータおよびレジストリの構成 この中で代表的な内容の説明は以下のようになっています
ORACLE_SID ホスト・コンピュータ上のOracle Databaseインスタンスの名前を指定します。インスタンスのSIDがこのパラメータの値です。デフォルト値は、Oracle Universal Installerのデータベース識別情報ウィンドウのエントリです。 ORACLE_HOME Oracle製品がインストールされるOracleホーム・ディレクトリを指定します。このディレクトリはOracleディレクトリ階層のOracleベース・ディレクトリのすぐ下に置かれます。デフォルト値は、インストール中に指定するドライブ文字および名前です。SPFILE
###########################################
# Copyright (c) 1991, 2011, Oracle and/or its affiliates. All rights reserved.
###########################################
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Database Identification
###########################################
db_name=XE
###########################################
# File Configuration
###########################################
control_files=("C:\oraclexe\app\oracle\oradata\XE\control.dbf")
###############################diagnostic_dest=############
# Job Queues
###########################################
job_queue_processes=4
###########################################
# Miscellaneous
###########################################
compatible=11.2.0.0.0
diagnostic_dest=C:\oraclexe\app\oracle\.
memory_target=1024M
###########################################
# Processes and Sessions
###########################################
sessions=20
###########################################
# Security and Auditing
###########################################
audit_file_dest=C:\oraclexe\app\oracle\admin\XE\adump
remote_login_passwordfile=EXCLUSIVE
###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=XEXDB)"
shared_servers=4
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1
###########################################
# Backup and Recovery
###########################################
DB_RECOVERY_FILE_DEST_SIZE = 10G
DB_RECOVERY_FILE_DEST=C:\oraclexe\app\oracle\fast_recovery_area
C:\oraclexe\app\oracle\product\11.2.0\server\config\scripts にある、XE.bat が実行されます。その中に、『postDBCreation.sql』の実行処理があり、その中で SPFILE を作成しています。
DEFINE sysPassword = "&1"
connect "SYS"/"&&sysPassword" as SYSDBA
set echo on
spool C:\oraclexe\app\oracle\product\11.2.0\server\config\log\postDBCreation.log
connect "SYS"/"&&sysPassword" as SYSDBA
set echo on
//create or replace directory DB_BACKUPS as 'C:\oraclexe\app\oracle\fast_recovery_area';
begin
dbms_xdb.sethttpport('8080');
dbms_xdb.setftpport('0');
end;
/
create spfile='C:\oraclexe\app\oracle\product\11.2.0\server\dbs/spfileXE.ora' FROM pfile='C:\oraclexe\app\oracle\product\11.2.0\server\config\scripts\init.ora';
shutdown immediate;
connect "SYS"/"&&sysPassword" as SYSDBA
startup ;
select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual;
execute utl_recomp.recomp_serial();
select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual;
alter user hr password expire account lock;
alter user ctxsys password expire account lock;
alter user outln password expire account lock;
alter user MDSYS password expire;
@C:\oraclexe\app\oracle\product\11.2.0\server\apex\apxxepwd.sql "&1"
spool off;
exit
※ C:\oraclexe\app\oracle\product\11.2.0\server\config\log に結果のログがあります ネットワーク C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN に、tnsnames.ora があり、ネット・サービス名が定義されています。
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = layla)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
listener.ora には、DEFAULT_SERVICE_LISTENER が定義されており、ユーザーがクライアント側からサービス名を指定せずに、データベースに接続できるようにします。Oracle Database 11gでは、クライアントがデータベースに接続しようとすると、接続リクエストがリスナーに渡されます。リスナーは複数の異なるデータベースにサービスを実行していることがあります。サービス名がこのパラメータで構成されている場合、ユーザーは必ずしもサービス名を接続構文で指定する必要はありません。ユーザーがサービス名を指定した場合、リスナーは指定したデータベースにユーザーを接続します。サービス名を指定しない場合、リスナーはDEFAULT_SERVICE_listener_nameパラメータで指定されたサービス名にユーザーを接続します。▼ Oracle ドキュメント 7 Oracle Net Listenerパラメータ(listener.ora) 8 ネーミング・メソッドの構成 select * from V$PARAMETER
| NAME | VALUE |
| active_instance_count | |
| aq_tm_processes | 0 |
| archive_lag_target | 0 |
| asm_diskgroups | |
| asm_diskstring | |
| asm_power_limit | 1 |
| asm_preferred_read_failure_groups | |
| audit_file_dest | C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP |
| audit_sys_operations | FALSE |
| audit_trail | NONE |
| background_core_dump | partial |
| background_dump_dest | C:\oraclexe\app\oracle\diag\rdbms\xe\xe\trace |
| backup_tape_io_slaves | FALSE |
| bitmap_merge_area_size | 1048576 |
| blank_trimming | FALSE |
| buffer_pool_keep | |
| buffer_pool_recycle | |
| cell_offload_compaction | ADAPTIVE |
| cell_offload_decryption | TRUE |
| cell_offload_parameters | |
| cell_offload_plan_display | AUTO |
| cell_offload_processing | TRUE |
| circuits | |
| client_result_cache_lag | 3000 |
| client_result_cache_size | 0 |
| cluster_database | FALSE |
| cluster_database_instances | 1 |
| cluster_interconnects | |
| commit_logging | |
| commit_point_strength | 1 |
| commit_wait | |
| commit_write | |
| compatible | 11.2.0.0.0 |
| control_file_record_keep_time | 7 |
| control_files | C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF |
| control_management_pack_access | NONE |
| core_dump_dest | C:\oraclexe\app\oracle\diag\rdbms\xe\xe\cdump |
| cpu_count | 4 |
| create_bitmap_area_size | 8388608 |
| create_stored_outlines | |
| cursor_bind_capture_destination | memory+disk |
| cursor_sharing | EXACT |
| cursor_space_for_time | FALSE |
| db_16k_cache_size | 0 |
| db_2k_cache_size | 0 |
| db_32k_cache_size | 0 |
| db_4k_cache_size | 0 |
| db_8k_cache_size | 0 |
| db_block_buffers | 0 |
| db_block_checking | FALSE |
| db_block_checksum | TYPICAL |
| db_block_size | 8192 |
| db_cache_advice | ON |
| db_cache_size | 0 |
| db_create_file_dest | |
| db_create_online_log_dest_1 | |
| db_create_online_log_dest_2 | |
| db_create_online_log_dest_3 | |
| db_create_online_log_dest_4 | |
| db_create_online_log_dest_5 | |
| db_domain | |
| db_file_multiblock_read_count | 128 |
| db_file_name_convert | |
| db_files | 200 |
| db_flash_cache_file | |
| db_flash_cache_size | 0 |
| db_flashback_retention_target | 1440 |
| db_keep_cache_size | 0 |
| db_lost_write_protect | NONE |
| db_name | XE |
| db_recovery_file_dest | C:\oraclexe\app\oracle\fast_recovery_area |
| db_recovery_file_dest_size | 10737418240 |
| db_recycle_cache_size | 0 |
| db_securefile | PERMITTED |
| db_ultra_safe | OFF |
| db_unique_name | XE |
| db_unrecoverable_scn_tracking | TRUE |
| db_writer_processes | 1 |
| dbwr_io_slaves | 0 |
| ddl_lock_timeout | 0 |
| deferred_segment_creation | TRUE |
| dg_broker_start | FALSE |
| diagnostic_dest | C:\ORACLEXE\APP\ORACLE |
| disk_asynch_io | TRUE |
| dispatchers | (PROTOCOL=TCP) (SERVICE=XEXDB) |
| distributed_lock_timeout | 60 |
| dml_locks | 756 |
| dst_upgrade_insert_conv | TRUE |
| enable_ddl_logging | FALSE |
| event | |
| fal_client | |
| fal_server | |
| fast_start_io_target | 0 |
| fast_start_mttr_target | 0 |
| fast_start_parallel_rollback | LOW |
| file_mapping | FALSE |
| fileio_network_adapters | |
| filesystemio_options | |
| fixed_date | |
| gcs_server_processes | 0 |
| global_context_pool_size | |
| global_names | FALSE |
| global_txn_processes | 1 |
| hash_area_size | 131072 |
| hi_shared_memory_address | 0 |
| hs_autoregister | TRUE |
| ifile | |
| instance_groups | |
| instance_name | xe |
| instance_number | 0 |
| instance_type | RDBMS |
| java_jit_enabled | TRUE |
| java_max_sessionspace_size | 0 |
| java_pool_size | 0 |
| java_soft_sessionspace_limit | 0 |
| job_queue_processes | 4 |
| large_pool_size | 0 |
| ldap_directory_access | NONE |
| ldap_directory_sysauth | no |
| license_max_sessions | 0 |
| license_max_users | 0 |
| license_sessions_warning | 0 |
| listener_networks | |
| local_listener | |
| lock_name_space | |
| lock_sga | FALSE |
| log_archive_config | |
| log_archive_dest | |
| log_archive_dest_1 | |
| log_archive_dest_10 | |
| log_archive_dest_11 | |
| log_archive_dest_12 | |
| log_archive_dest_13 | |
| log_archive_dest_14 | |
| log_archive_dest_15 | |
| log_archive_dest_16 | |
| log_archive_dest_17 | |
| log_archive_dest_18 | |
| log_archive_dest_19 | |
| log_archive_dest_2 | |
| log_archive_dest_20 | |
| log_archive_dest_21 | |
| log_archive_dest_22 | |
| log_archive_dest_23 | |
| log_archive_dest_24 | |
| log_archive_dest_25 | |
| log_archive_dest_26 | |
| log_archive_dest_27 | |
| log_archive_dest_28 | |
| log_archive_dest_29 | |
| log_archive_dest_3 | |
| log_archive_dest_30 | |
| log_archive_dest_31 | |
| log_archive_dest_4 | |
| log_archive_dest_5 | |
| log_archive_dest_6 | |
| log_archive_dest_7 | |
| log_archive_dest_8 | |
| log_archive_dest_9 | |
| log_archive_dest_state_1 | enable |
| log_archive_dest_state_10 | enable |
| log_archive_dest_state_11 | enable |
| log_archive_dest_state_12 | enable |
| log_archive_dest_state_13 | enable |
| log_archive_dest_state_14 | enable |
| log_archive_dest_state_15 | enable |
| log_archive_dest_state_16 | enable |
| log_archive_dest_state_17 | enable |
| log_archive_dest_state_18 | enable |
| log_archive_dest_state_19 | enable |
| log_archive_dest_state_2 | enable |
| log_archive_dest_state_20 | enable |
| log_archive_dest_state_21 | enable |
| log_archive_dest_state_22 | enable |
| log_archive_dest_state_23 | enable |
| log_archive_dest_state_24 | enable |
| log_archive_dest_state_25 | enable |
| log_archive_dest_state_26 | enable |
| log_archive_dest_state_27 | enable |
| log_archive_dest_state_28 | enable |
| log_archive_dest_state_29 | enable |
| log_archive_dest_state_3 | enable |
| log_archive_dest_state_30 | enable |
| log_archive_dest_state_31 | enable |
| log_archive_dest_state_4 | enable |
| log_archive_dest_state_5 | enable |
| log_archive_dest_state_6 | enable |
| log_archive_dest_state_7 | enable |
| log_archive_dest_state_8 | enable |
| log_archive_dest_state_9 | enable |
| log_archive_duplex_dest | |
| log_archive_format | ARC%S_%R.%T |
| log_archive_local_first | TRUE |
| log_archive_max_processes | 4 |
| log_archive_min_succeed_dest | 1 |
| log_archive_start | FALSE |
| log_archive_trace | 0 |
| log_buffer | 5357568 |
| log_checkpoint_interval | 0 |
| log_checkpoint_timeout | 1800 |
| log_checkpoints_to_alert | FALSE |
| log_file_name_convert | |
| max_dispatchers | |
| max_dump_file_size | unlimited |
| max_enabled_roles | 150 |
| max_shared_servers | |
| memory_max_target | 1073741824 |
| memory_target | 1073741824 |
| nls_calendar | GREGORIAN |
| nls_comp | BINARY |
| nls_currency | \ |
| nls_date_format | RR-MM-DD |
| nls_date_language | JAPANESE |
| nls_dual_currency | \ |
| nls_iso_currency | JAPAN |
| nls_language | JAPANESE |
| nls_length_semantics | BYTE |
| nls_nchar_conv_excp | FALSE |
| nls_numeric_characters | ., |
| nls_sort | BINARY |
| nls_territory | JAPAN |
| nls_time_format | HH24:MI:SSXFF |
| nls_time_tz_format | HH24:MI:SSXFF TZR |
| nls_timestamp_format | RR-MM-DD HH24:MI:SSXFF |
| nls_timestamp_tz_format | RR-MM-DD HH24:MI:SSXFF TZR |
| O7_DICTIONARY_ACCESSIBILITY | FALSE |
| object_cache_max_size_percent | 10 |
| object_cache_optimal_size | 102400 |
| olap_page_pool_size | 0 |
| open_cursors | 300 |
| open_links | 4 |
| open_links_per_instance | 4 |
| optimizer_capture_sql_plan_baselines | FALSE |
| optimizer_dynamic_sampling | 2 |
| optimizer_features_enable | 11.2.0.2 |
| optimizer_index_caching | 0 |
| optimizer_index_cost_adj | 100 |
| optimizer_mode | ALL_ROWS |
| optimizer_secure_view_merging | TRUE |
| optimizer_use_invisible_indexes | FALSE |
| optimizer_use_pending_statistics | FALSE |
| optimizer_use_sql_plan_baselines | TRUE |
| os_authent_prefix | OPS$ |
| os_roles | FALSE |
| parallel_adaptive_multi_user | TRUE |
| parallel_automatic_tuning | FALSE |
| parallel_degree_limit | CPU |
| parallel_degree_policy | MANUAL |
| parallel_execution_message_size | 16384 |
| parallel_force_local | FALSE |
| parallel_instance_group | |
| parallel_io_cap_enabled | FALSE |
| parallel_max_servers | 0 |
| parallel_min_percent | 0 |
| parallel_min_servers | 0 |
| parallel_min_time_threshold | AUTO |
| parallel_server | FALSE |
| parallel_server_instances | 1 |
| parallel_servers_target | 64 |
| parallel_threads_per_cpu | 2 |
| permit_92_wrap_format | TRUE |
| pga_aggregate_target | 0 |
| plscope_settings | IDENTIFIERS:NONE |
| plsql_ccflags | |
| plsql_code_type | INTERPRETED |
| plsql_debug | FALSE |
| plsql_optimize_level | 2 |
| plsql_v2_compatibility | FALSE |
| plsql_warnings | DISABLE:ALL |
| pre_page_sga | FALSE |
| processes | 100 |
| query_rewrite_enabled | TRUE |
| query_rewrite_integrity | enforced |
| rdbms_server_dn | |
| read_only_open_delayed | FALSE |
| recovery_parallelism | 0 |
| recyclebin | OFF |
| redo_transport_user | |
| remote_dependencies_mode | TIMESTAMP |
| remote_listener | |
| remote_login_passwordfile | EXCLUSIVE |
| remote_os_authent | FALSE |
| remote_os_roles | FALSE |
| replication_dependency_tracking | TRUE |
| resource_limit | FALSE |
| resource_manager_cpu_allocation | 4 |
| resource_manager_plan | |
| result_cache_max_result | 5 |
| result_cache_max_size | 0 |
| result_cache_mode | MANUAL |
| result_cache_remote_expiration | 0 |
| resumable_timeout | 0 |
| rollback_segments | |
| sec_case_sensitive_logon | TRUE |
| sec_max_failed_login_attempts | 10 |
| sec_protocol_error_further_action | CONTINUE |
| sec_protocol_error_trace_action | TRACE |
| sec_return_server_release_banner | FALSE |
| serial_reuse | disable |
| service_names | XE |
| session_cached_cursors | 50 |
| session_max_open_files | 10 |
| sessions | 172 |
| sga_max_size | 645922816 |
| sga_target | 0 |
| shadow_core_dump | none |
| shared_memory_address | 0 |
| shared_pool_reserved_size | 9437184 |
| shared_pool_size | 0 |
| shared_server_sessions | |
| shared_servers | 4 |
| skip_unusable_indexes | TRUE |
| smtp_out_server | |
| sort_area_retained_size | 0 |
| sort_area_size | 65536 |
| spfile | C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\ SERVER\DBS\SPFILEXE.ORA |
| sql_trace | FALSE |
| sql92_security | FALSE |
| sqltune_category | DEFAULT |
| standby_archive_dest | %ORACLE_HOME%\RDBMS |
| standby_file_management | MANUAL |
| star_transformation_enabled | FALSE |
| statistics_level | TYPICAL |
| streams_pool_size | 0 |
| tape_asynch_io | TRUE |
| thread | 0 |
| timed_os_statistics | 0 |
| timed_statistics | TRUE |
| trace_enabled | TRUE |
| tracefile_identifier | |
| transactions | 189 |
| transactions_per_rollback_segment | 5 |
| undo_management | AUTO |
| undo_retention | 900 |
| undo_tablespace | UNDOTBS1 |
| use_indirect_data_buffers | FALSE |
| use_large_pages | TRUE |
| user_dump_dest | C:\oraclexe\app\oracle\diag\rdbms\xe\xe\trace |
| utl_file_dir | |
| workarea_size_policy | AUTO |
| xml_db_events | enable |
この中で、"XE" という文字列が含まれているのは以上です db_name XE db_unique_name XE instance_name xe service_names XE
|
|
【Oracleの最新記事】
- Oracle : sqlplus で、テーブルの create 文( DBMS_METADATA.GET_DDL ) と csv データを出力する
- Oracle : SQL Plus で、デッドロックテスト ( ORA-00060 )
- SQL*Plusだけで CSV を作成する
- Oracle11g XE( 無償 ) のインストールからテスト用販売管理データのロードまで
- Oracle Database 11g のJDBC実装では、SIDを使用したデータベースURL接続文字列は廃止されています
- SQLPlus : 置換変数の概要と使い方
- Oracle : スキーマ作成前にテーブルスペースの情報を取得する
- Oracle : 既存スキーマの状態をチェック
- サービス開始 : Oracle 10g Express
- Oracle 10g Express Edition のインストール
- Oracle : 貴重な擬似列 ROWID
