Komut Ortamında (Manuel) Veri Tabanı Oluşturma

Sunucumuzda bir instance (orcl) koşarken ikinci instance manuel oluşturacağız.
Şu an sisteme oracle kullanıcısı ile bağlıyım ve ilk kurulum aşamasında oluşturduğum orcl instance ı mevcut. Önce yeni oluşturacağımı instance ın adına karar veriyoruz.

$set ORACLE_SID=kargo
$export ORACLE_SID=kargo

1 2	$set ORACLE_SID=kargo $export ORACLE_SID=kargo

"/u01/app/oracle/product/10.2.0/db_1/dbs" dizinine initkargo.orcl adında pfile oluşturuyoruz. Siz pathleri kendinize göre değiştirebilirsiniz. İçeriği ;

*.db_name='kargo'
*.db_block_size=8192
*.sga_target=231735296
*.undo_management='AUTO'
*.control_files='/u01/app/oracle/oradata/kargo/control01.ctl'
*.user_dump_dest='/u01/app/oracle/admin/kargo/udump'
*.background_dump_dest='/u01/app/oracle/admin/kargo/bdump'
*.core_dump_dest='/u01/app/oracle/admin/kargo/cdump'

*.db_name='kargo'

*.db_block_size=8192

*.sga_target=231735296

*.undo_management='AUTO'

*.control_files='/u01/app/oracle/oradata/kargo/control01.ctl'

*.user_dump_dest='/u01/app/oracle/admin/kargo/udump'

*.background_dump_dest='/u01/app/oracle/admin/kargo/bdump'

*.core_dump_dest='/u01/app/oracle/admin/kargo/cdump'

Bu dizinlerin hepsinin oluşturulmuş olmalı ve gerekli hakların verilmiş olması gerekir. Oracle kullanıcısı ile oluşturmadı iseniz;

chown oracle:oinstall initkargo.ora komutu ile sahipligini değiştiriyoruz
chmod g+w initkargo.ora ile oinstall grubuna yazma hak veriyoruz.
CREATE SPFILE FROM PFILE='/u01/app/oracle/product/10.2.0/db_1/dbs/initkargo.ora';

chown oracle:oinstall initkargo.ora komutu ile sahipligini değiştiriyoruz

chmod g+w initkargo.ora ile oinstall grubuna yazma hak veriyoruz.

CREATE SPFILE FROM PFILE='/u01/app/oracle/product/10.2.0/db_1/dbs/initkargo.ora';

veri tabanını nomount modda açıp spfile ı oluşturuyoruz.

startup nomount;

1	startup nomount;

ORA-09925: Unable to create audit trail file Linux Error: 2: No such file or directory Additional information: 9925

1	ORA-09925: Unable to create audit trail file Linux Error: 2: No such file or directory Additional information: 9925

Gibi bir hata alırsanız klasörlerin yeri ve/veya hakları ile ilgili sorun olabilir.
create database komutu ile aşağıdaki dosyaları oluşturacağız.
- Redo Log files
- system.dbf and sysaux.dbf (files for SYSTEM tablespace)
- undo01.dbf file (for UNDO tablespace)
- temp_tbs.dbf file (for TEMPORARY tablespace)
- users.dbf (for DEFAULT PERMANENT tablespace)

CREATE DATABASE kargo
USER SYS IDENTIFIED BY kargo
USER SYSTEM IDENTIFIED BY kargo
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/kargo/redo01.log') SIZE 50 m,
GROUP 2 ('/u01/app/oracle/oradata/kargo/redo02.log') SIZE 50 m,
GROUP 3 ('/u01/app/oracle/oradata/kargo/redo03.log') SIZE 50 m
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET us7ascii
NATIONAL CHARACTER SET al16utf16
DATAFILE '/u01/app/oracle/oradata/kargo/system01.dbf' SIZE 325 m REUSE EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/kargo/sysaux.dbf'SIZE 400 m REUSE
DEFAULT TABLESPACE tbs_1 DATAFILE '/u01/app/oracle/oradata/kargo/users.dbf' SIZE 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/kargo/temp_tbs.dbf' SIZE 20m REUSE
undo TABLESPACE undotbs DATAFILE '/u01/app/oracle/oradata/kargo/undo01.dbf' SIZE 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

CREATE DATABASE kargo

USER SYS IDENTIFIED BY kargo

USER SYSTEM IDENTIFIED BY kargo

LOGFILE GROUP 1 ('/u01/app/oracle/oradata/kargo/redo01.log') SIZE 50 m,

GROUP 2 ('/u01/app/oracle/oradata/kargo/redo02.log') SIZE 50 m,

GROUP 3 ('/u01/app/oracle/oradata/kargo/redo03.log') SIZE 50 m

MAXLOGFILES 5

MAXLOGMEMBERS 5

MAXLOGHISTORY 1

MAXDATAFILES 100

MAXINSTANCES 1

CHARACTER SET us7ascii

NATIONAL CHARACTER SET al16utf16

DATAFILE '/u01/app/oracle/oradata/kargo/system01.dbf' SIZE 325 m REUSE EXTENT MANAGEMENT LOCAL

SYSAUX DATAFILE '/u01/app/oracle/oradata/kargo/sysaux.dbf'SIZE 400 m REUSE

DEFAULT TABLESPACE tbs_1 DATAFILE '/u01/app/oracle/oradata/kargo/users.dbf' SIZE 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/kargo/temp_tbs.dbf' SIZE 20m REUSE

undo TABLESPACE undotbs DATAFILE '/u01/app/oracle/oradata/kargo/undo01.dbf' SIZE 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

views,synonims ve pl/sql paketlerini oluşturmak için aşağıdaki scriptler çalıştırılır.

CONNECT / AS SYSDBA
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql

CONNECT / AS SYSDBA

@$ORACLE_HOME/rdbms/admin/catalog.sql

@$ORACLE_HOME/rdbms/admin/catproc.sql

PL/SQL procedure successfully completed. mesajını gördükten sonra.

shutdown immediate
startup

1 2	shutdown immediate startup

Komutlarını verip veri tabanını açabiliriz.

show parameters
NAME TYPE VALUE
O7_DICTIONARY_ACCESSIBILITY boolean FALSE
active_instance_count integer
aq_tm_processes integer 0
archive_lag_target integer 0
asm_diskgroups string
asm_diskstring string
asm_power_limit integer 1
audit_file_dest string /u01/app/oracle/product/10.2.0
/db_1/rdbms/audit
audit_sys_operations boolean FALSE
audit_syslog_level string
NAME TYPE VALUE
audit_trail string NONE
background_core_dump string partial
background_dump_dest string /u01/app/oracle/admin/kargo/bdump
backup_tape_io_slaves boolean FALSE
bitmap_merge_area_size integer 1048576
blank_trimming boolean FALSE
buffer_pool_keep string
buffer_pool_recycle string
circuits integer
cluster_database boolean FALSE
NAME TYPE VALUE
cluster_database_instances integer 1
cluster_interconnects string
commit_point_strength integer 1
commit_write string
compatible string 10.2.0
control_file_record_keep_time integer 7
control_files string /u01/app/oracle/oradata/kargo/control01.ctl

show parameters

NAME TYPE VALUE

O7_DICTIONARY_ACCESSIBILITY boolean FALSE

active_instance_count integer

aq_tm_processes integer 0

archive_lag_target integer 0

asm_diskgroups string

asm_diskstring string

asm_power_limit integer 1

audit_file_dest string /u01/app/oracle/product/10.2.0

/db_1/rdbms/audit

audit_sys_operations boolean FALSE

audit_syslog_level string

NAME TYPE VALUE

audit_trail string NONE

background_core_dump string partial

background_dump_dest string /u01/app/oracle/admin/kargo/bdump

backup_tape_io_slaves boolean FALSE

bitmap_merge_area_size integer 1048576

blank_trimming boolean FALSE

buffer_pool_keep string

buffer_pool_recycle string

circuits integer

cluster_database boolean FALSE

NAME TYPE VALUE

cluster_database_instances integer 1

cluster_interconnects string

commit_point_strength integer 1

commit_write string

compatible string 10.2.0

control_file_record_keep_time integer 7

control_files string /u01/app/oracle/oradata/kargo/control01.ctl