Oracle DBMS

Personal Oracle 7.3

[ Home ]

Umetni CD i pokreni Setup.exe

Izaberi postavke:

Language: English

Oracle Home: f:\orawin95

Custom instalation

select all items

TCP/IP

No Starter Database

Nakon završetka instalacije na MS DOS Promptu:

C:\> cd f:\orawin95\database - u tom se direktoriju trebaju nalaziti fileovi za kreiranje baze. Posebnu pažnju posveti fileu initorcl.ora (na VMS-u je to init.ora) – podesi parametre prema vlastitoj zamisli:

db_name = saora7

control_files = f:\orawin95\database\saora7_1.con

rollback_segments = saora7_rlbk1, saora7_rlbk2

F:\orawin95\database\> svrmgr23 – pokretanje Server Managera. Automatski krene dizanje baze koje ne uspije (This program has performed an illegal operation and will be shut down) jer “Can not mount DB” budući da je nismo ni instalirali.

Svrmgr> connect internal

Connected to an idle instance

Svrmgr> startup nomount

Oracle instance started.

Svrmgr> @p1_create_saora7.sql – kreiranje baze.

Osobitu pažnju posveti liniji “CHARACTER SET EE8MSWIN1250” jer bez nje u bazu nije moguće spremati HR znakove – svi alati ih imaju kod upisa, ali u bazu se spreme bez dijakritičkih znakova (č i ć kao c, ž kao z, itd.).

Statement processed.

Svrmgr> @p2_create_tablespaces.sql – kreiranje tablespaceova

Statement processed.

Svrmgr> @p3_cat_files.sql – pokretanje sistemskih sql-ova. Bitno je da se pokrene p3…sql i prozor minimizira jer ako output ide na ekran, to se kilavi oko 30 min.

Catalog.sql

Catproc.sql

Pupbld.sql

Catrep.sql

Statement processed

Time je baza kreirana. Useri sa sistemskim privilegijama su

system / manager i

sys / change_on_install

Kreiranje novog usera:

prijavi se u SQL*Plus kao user system

SQL> @p3_create_new_user.sql – važna napomena je da nakon kreiranja svakog usera treba kao user system propustiti pupbld.sql.

Developer/2000 v 2.0

Umetni CD i pokreni setup.exe.

Language: Croatian

Type: Developer, Typical installation

Nakon instalacije provjeri vrijednosti entryja u Windows Registryju na

HKEY_LOCAL_MACHINE – SOFTWARE – ORACLE

NLS_LANG = “CROATIAN_CROATIA.EE8MSWIN1250”, gdje je oblik ovog entryja slijedeći: language_territory.code_page (vrijednosti pogledaj u Helpu).

Do sada napravljenim koracima moguće je koristiti sve Oracle alate pod Hrvatskim jezikom – čak i Forms Builder “govori” Hrvatski pa drop-down meniji nisu File, Edit, Window i sl. već odgovarajući hrvatski prijevodi. Međutim, ako želiš raditi design pod engleskim jezikom, u registry je potrebno dodati novi entry: DEVELOPER_NLS_LANG = “ENGLISH”. Time se ne poništava runtime NLS koji i dalje ostaje hrvatski (super za end-usera).

Testna tablica i nad njom kreirana defaultna forma omogućavaju ispravan unos i dohvat podataka sa svim hrvatskim znakovljem.

Dodatak

Fileovi kreirani by myself:

P1_create_saora7.sql

CREATE DATABASE saora7
DATAFILE
'f:\orawin95\database\saora7_system1.dbs' SIZE 15M
LOGFILE
'f:\orawin95\database\saora7_11.rdo' SIZE 500K,
'f:\orawin95\database\saora7_12.rdo' SIZE 500K
CHARACTER SET EE8MSWIN1250
;

P2_create_tablespaces.sql

SET ECHO ON

CREATE ROLLBACK SEGMENT priv
STORAGE    (INITIAL 512K
                     NEXT 512K
                     MINEXTENTS 3
                    );

ALTER ROLLBACK SEGMENT priv ONLINE;

CREATE TABLESPACE saora7_user
DATAFILE 'f:\orawin95\database\saora7_user1.dbs' size 10M;

CREATE TABLESPACE saora7_index
DATAFILE 'f:\orawin95\database\saora7_index1.dbs' size 3M;

CREATE TABLESPACE saora7_rlbk
DATAFILE 'f:\orawin95\database\saora7_rlbk1.dbs' size 2M
DEFAULT STORAGE     (INITIAL 128K
                                     NEXT 128K
                                     PCTINCREASE 0
                                    );

CREATE TABLESPACE saora7_tmp
DATAFILE 'f:\orawin95\database\saora7_tmp1.dbs' size 2M
DEFAULT STORAGE     (INITIAL 128K
                                     NEXT 128K
                                     PCTINCREASE 0
                                    );

CREATE ROLLBACK SEGMENT saora7_rlbk1
STORAGE (INITIAL 64K NEXT 64K OPTIMAL 1M)
TABLESPACE saora7_rlbk;

CREATE ROLLBACK SEGMENT saora7_rlbk2
STORAGE (INITIAL 64K NEXT 64K OPTIMAL 1M)
TABLESPACE saora7_rlbk;

ALTER ROLLBACK SEGMENT saora7_rlbk1 ONLINE;

ALTER ROLLBACK SEGMENT saora7_rlbk2 ONLINE;

ALTER ROLLBACK SEGMENT priv OFFLINE;

DROP ROLLBACK SEGMENT priv;

P3_cat_files.sql

@%oracle_home%\rdbms73\admin\catalog.sql

@%oracle_home%\rdbms73\admin\catproc.sql

@%oracle_home%\dbs\pupbld.sql

@%oracle_home%\rdbms73\admin\catrep.sql

P4_create_new_user.sql

CREATE USER &&usr IDENTIFIED BY &pwd
DEFAULT TABLESPACE saora7_user
TEMPORARY TABLESPACE saora7_tmp;

GRANT CONNECT, RESOURCE TO &&usr;

UNDEFINE usr;
UNDEFINE pwd;

Initorcl.ora

# $Header: init.ora 1.2 94/10/18 16:12:36 gdudey Osd<desktop/netware> $ init.ora Copyr (c) 1991 Oracle
db_name = saora7
db_files = 20
compatible = 7.3.0.0.0

db_file_multiblock_read_count = 8 # INITIAL
# db_file_multiblock_read_count = 8 # SMALL
# db_file_multiblock_read_count = 16 # MEDIUM
# db_file_multiblock_read_count = 32 # LARGE

db_block_buffers = 200 # INITIAL
# db_block_buffers = 200 # SMALL
# db_block_buffers = 550 # MEDIUM
# db_block_buffers = 3200 # LARGE

shared_pool_size = 3500000 # INITIAL
# shared_pool_size = 3500000 # SMALL
# shared_pool_size = 6000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE

log_checkpoint_interval = 10000

processes = 50 # INITIAL
# processes = 50 # SMALL
# processes = 100 # MEDIUM
# processes = 200 # LARGE

dml_locks = 100 # INITIAL
# dml_locks = 100 # SMALL
# dml_locks = 200 # MEDIUM
# dml_locks = 500 # LARGE

log_buffer = 8192 # INITIAL
# log_buffer = 8192 # SMALL
# log_buffer = 32768 # MEDIUM
# log_buffer = 163840 # LARGE

sequence_cache_entries = 10 # INITIAL
# sequence_cache_entries = 10 # SMALL
# sequence_cache_entries = 30 # MEDIUM
# sequence_cache_entries = 100 # LARGE

sequence_cache_hash_buckets = 10 # INITIAL
# sequence_cache_hash_buckets = 10 # SMALL
# sequence_cache_hash_buckets = 23 # MEDIUM
# sequence_cache_hash_buckets = 89 # LARGE

# audit_trail = true # if you want auditing
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
# log_archive_start = true # if you want automatic archiving
log_archive_dest=%ORACLE_HOME%\DATABASE\ARCHIVE

# define directories to store trace and alert files
background_dump_dest=%RDBMS73%\trace
user_dump_dest=%RDBMS73%\trace

db_block_size = 2048
snapshot_refresh_processes = 1
remote_login_passwordfile = shared

# nadalje je moje
control_files = f:\orawin95\database\saora7_1.con
rollback_segments = saora7_rlbk1, saora7_rlbk2

# Ova dva nls-a nisu bitna za HR znakovlje
# nls_language = croatian
# nls_territory = croatia