orcl

Ulaz u Oracle: https://localhost:1158/em/    username:sys  pass:Manager1 SYSDBA

Sve moguce sifre:
		virtualka: (administrator/Passw0rd$)
		oracle admin users: (sys,system/Manager1)
		host login: (administrator/Passw0rd$,Passw0rd)
		global db name: (orcl/Manager1)

Za sve zadatke ako ne pise drukcije, pocinjemo iz database sucelja

ISHOD 6
-------

zad1.(vjezba 2, str 8)
Database home stranica, setup u gornjem desnom kutu, administrators gore lijevo,
create, upisati ime, npr. BI, review pa finish.

zad2.(vjezba 2, str 15)
Preferences gore desno, preferred credentials gore lijevo. Set Credentials u redu
u kojem je Database Instance. Promijenit PWe ako treba.
(system / Manager1; sys / Manager1; administrator / Passw0rd$). Test pa Apply.

zad3.(vjezba 2, str 11)
Setup gore desno, blackouts lijevo, create, ispuniti obrazac do targeta
(type database instance, odaberi orcl, move right), zatim next.
Odaberi datum, vrijeme, trajanje. Next pa Finish.

ISHOD 7
-------

zad1.(vjezba 3, str 6)
Start -> Net Manager. Local, Service Naming, Edit, Create.
Upisati Net Service Name: testorcl i next, tcp/ip i next,
Host Name: localhost, Port Number: 1521 i next, Service Name: orcl i next,
Test, Change login Username: system, pass: Manager1, test. Zatim Close pa Finish.
Klikni na File, Save Network Configuration, File i Exit

zad2.(vjezba 5, str 7(mozda od 2 do 7))
Database sucelje, Server gore sredina, Klikni na Redo Log Groups gore lijevo, ako postoji
vise grupa, svaku zasebno klikni i klikni na view te prepisi fajle i direktorije.

zad3.(vjezba 5, str 9)
Klikni na Server gore sredina, Klikni na TableSpaces gore lijevo, klikni Create,
upisi ime(tstest), odaberi Locally Managed, Permanent, Read Write, klikni na Add,
upisi ime(tstest01.dbf), u file size upisi 5 MB(zadano u zad), odaberi auto extend i
Increment 300 kb(zadano u zad). Klikni Continue. Klikni na Storage i klikni Ok.

zad4.(vjezba 5, str 2)
Server, Automatic Undo Management, Undo Retention Settings:
procitaj (Undo Retention npr. 15 min, Undo Tablespace for this instance npr. 60MB)

ISHOD 8
-------

zad1 (vjezba 6, str 1)
Server, Security(Users), klikni Create, popuni, Ok

zad2 (vjezba 7, str 8)
U database-u smo, Schema(pored Servera), Tables pod Database Objects, klikni Create,
odaberi Standard i Continue, Name: osobe, Schema: test2, Tablespace: ako ne pise
u zadatku odaberi FSDATA, popunjavamo i kad popunimo kliknemo ok.

zad3 (vjezba 6, str 5)
Server, Users, Klikni na Orausr1 pisat ce u zadatku, Klikni na edit, Klikni Quotas,
pod tablespaceom ts3 pod Quota odaberi Unlimited, Klikni Apply.

zad4 (vjezba 7, str 26)
Schema, Views, Create, Name: neko ime, Schema: odaberi test2, u Query Text pisi naredbu
(npr. select ime, prezime from osobe), stisni ok


ISHOD 9
-------
******Flash se sada zove fast!!!!

zad1 (vjezba 8, str 2)
Ovaj sljedeci dio u cmdu ako treba povecati recovery area, u njemu ukucaj:
	sqlplus system/oracle
	(ako pita za user i password, upisi system/Manager1)
	alter system set db_recovery_file_dest_size=8G scope=both;
	exit

Sad radimo dalje u Manageru: Availability -> Recovery Settings. Čekiraj Archive mode,
upisi direktorij pod fast recovery koji se trazi u zadatku, set size na 1GB i apply.
Restartaj bazu.

zad2 (vjezba 8, str8)
Availability -> Backup Settings, dolje pod Host Credentials ako ne pise treba napisati
administrator/Passw0rd$, Parallelism = 2, Disk backup type:Image copy, Disk backup
location: prazno ostaviti (ili ako ne radi upisati lokaciju oz zadatka prije).
Klikni test disk backup. Klikni na policy, chekiraj Automatically backup...,
chekiraj Optimize (ostavi prazno polje za fajl), dolje pod Retention chekiraj
Retain backups that are necessary for... i upisi desno 20 dana. Dole jos selectat
Delete archived redo logs... i klik OK

zad3 (vjezba 8, str11)
Server-> Initialization parameters, ukucaj "db_unique_name" pod Name i klikni na Go.
Pod "Value" pise vrijednost koja se trazi pa ju prepisi(orcl). Server-> Control Files,
klikni Anvanced. Pod Database ID pise DBID vrijednost, kopiraj ju.

zad3 (vjezba 8, str27)
Schema -> Tables. Pod Schema upisi korisnika(test2) a pod Object name ime tablice (bonus).
Klikni Go pa onda edit. Klikni na options i odaberi yes za Row movement. Klikni apply