{"id":98,"date":"2009-12-17T16:32:00","date_gmt":"2009-12-17T14:32:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2009\/12\/17\/oracle-create\/"},"modified":"2010-08-24T22:35:48","modified_gmt":"2010-08-24T20:35:48","slug":"oracle-create","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2009\/12\/17\/oracle-create\/","title":{"rendered":"ORACLE CREATE"},"content":{"rendered":"

create database manualy:<\/b>

<\/b>
* create PFILE
main changes:
– db_name
– control_files
– audit_file_dest
– background_dump_dest
– user_dump_dest
– core_dump_dest<\/p>\n

example init[dbname].ora<\/p>\n

*.__db_cache_size=939524096
*.__java_pool_size=16777216
*.__large_pool_size=16777216
*.__shared_pool_size=587202560
*.__streams_pool_size=33554432
*.control_files='[path]\/control1.ora’,'[path]\/control2.ora’,'[path]\/control3.ora’
*.audit_file_dest='[path]\/admin\/adump’
*.core_dump_dest='[path]\/admin\/cdump’
*.user_dump_dest='[path]\/admin\/udump’
*.background_dump_dest='[path]\/admin\/bdump’
*.compatible=’10.2.0.1′
*.db_block_size=8192
*.db_domain=”
*.db_file_multiblock_read_count=16
*.db_files=1500
*.db_name='[dbname]’
*.global_names=FALSE
*.job_queue_processes=10
*.log_archive_format='[dbname]%t%s%r.arc’
*.log_checkpoint_interval=10000
*.max_dump_file_size=’10240′
*.open_cursors=1000
*.optimizer_mode=’CHOOSE’
*.pga_aggregate_target=629145600
*.processes=400
*.query_rewrite_enabled=’true’
*.remote_login_passwordfile=’EXCLUSIVE’
*.service_names='[dbname]’
*.session_max_open_files=40
*.sga_target=1610612736
*.shared_pool_reserved_size=0
*.undo_management=’AUTO’
*.undo_retention=100000
*.undo_tablespace=’UNDO_TS’<\/div>\n

* create password file for new database:
orapwd file=orapw[dbname] password=[pass]<\/p>\n

* add new database to listener.ora and tnsnames.ora,<\/p>\n

* create dirs for new database file, <\/p>\n

* create dirs for trace logs as admin with subdirectories: adump, udump, cdump, bdump,<\/p>\n

* run script:<\/p>\n

spool crt_db.spool
startup nomount
create database [dbname]
user sys identified by [pass]
user system identified by [pass]
maxinstances 5
maxloghistory 5
maxlogfiles 10
maxlogmembers 5
maxdatafiles 1000
character set EE8ISO8859P2
national character set AL16UTF16
datafile '[path]\/system01.dbf’ size 512M autoextend on next 10M maxsize unlimited
sysaux datafile '[path]\/sysaux01.dbf’ SIZE 1024M
logfile group 1 ('[path]\/redo01.log’) size 100m,
group 2 ('[path]\/redo02.log’) size 100m,
group 3 ('[path]\/redo03.log’) size 100m
default temporary tablespace TEMP tempfile '[path]\/temp01.dbf’ size 2048M
undo tablespace UNDO_TS datafile '[path]\/undotbs01.dbf’ size 3000M autoextend off,
'[path]\/undotbs02.dbf’ size 512M autoextend on next 10M maxsize unlimited;
spool off<\/div>\n

* run script:<\/p>\n

spool catalog.spool
@$ORACLE_HOME\/rdbms\/admin\/catalog.sql
spool off
spool catproc.spool
@$ORACLE_HOME\/rdbms\/admin\/catproc.sql
spool off
spool catrep.spool
@$ORACLE_HOME\/rdbms\/admin\/catrep.sql
spool off
spool initjvm.spool
@$ORACLE_HOME\/javavm\/install\/initjvm.sql
spool off
spool dbmsrand.spool
@$ORACLE_HOME\/rdbms\/admin\/dbmsrand.sql
spool off
spool utlrp.spool
@$ORACLE_HOME\/rdbms\/admin\/utlrp.sql
spool off<\/div>\n","protected":false},"excerpt":{"rendered":"

create database manualy:* create PFILEmain changes:– db_name– control_files– audit_file_dest– background_dump_dest– user_dump_dest– core_dump_dest example init[dbname].ora *.__db_cache_size=939524096*.__java_pool_size=16777216*.__large_pool_size=16777216*.__shared_pool_size=587202560*.__streams_pool_size=33554432*.control_files='[path]\/control1.ora’,'[path]\/control2.ora’,'[path]\/control3.ora’*.audit_file_dest='[path]\/admin\/adump’*.core_dump_dest='[path]\/admin\/cdump’*.user_dump_dest='[path]\/admin\/udump’*.background_dump_dest='[path]\/admin\/bdump’*.compatible=’10.2.0.1′*.db_block_size=8192*.db_domain=”*.db_file_multiblock_read_count=16*.db_files=1500*.db_name='[dbname]’*.global_names=FALSE*.job_queue_processes=10*.log_archive_format='[dbname]%t%s%r.arc’*.log_checkpoint_interval=10000*.max_dump_file_size=’10240′*.open_cursors=1000*.optimizer_mode=’CHOOSE’*.pga_aggregate_target=629145600*.processes=400*.query_rewrite_enabled=’true’*.remote_login_passwordfile=’EXCLUSIVE’*.service_names='[dbname]’*.session_max_open_files=40*.sga_target=1610612736*.shared_pool_reserved_size=0*.undo_management=’AUTO’*.undo_retention=100000*.undo_tablespace=’UNDO_TS’ * create password file for new database:orapwd file=orapw[dbname] password=[pass] * add new database to listener.ora and tnsnames.ora, * create dirs for new database file, * create dirs for trace logs as admin with subdirectories: adump, udump, cdump, bdump, * run […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[15],"class_list":["post-98","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-create"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/98","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=98"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/98\/revisions"}],"predecessor-version":[{"id":173,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/98\/revisions\/173"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}