sbd

Start: sqlplus / as sysdba > startup > quit | lsnrctl start (lub status) | emctl start dbconsole | su > root123 > /sbin/dhclient (do ip) |
4 2) Server > Initialization Parameters > Current > Name > job > Go > Return > Apply 4) Enterprise Manager > Database > Shutdown > Host Credentials (Username i Password: oracle) > Ok >> Advanced Options (Immediate) > Cancel > Yes > Refresh > Ok 5) …..itd
1. utworzyć nowy lokalny netservice o nazwie NS_<student_id> i parametrach naza coś IP <ip_wm_studenta>, port 1521
3. Ustawić parametr serwera JOB_QUEUE_PROCESSESS na 25 Server > Initialization Parameters > znalezienie JOB_QUEUE_PROCESSESS > zamiana wartości na 25


1. NETSERVICE: HOME -> listener (value) -> (Related Links) Net Services Administration -> (Drop-down) -> Local Naming -> oracle/oracle -> create -> Net Service Name = cokolwiek -> User Service Name = oracle -> Addresses ADD -> Fill port and Host -> OK
2. TABLESPACE: Server -> Tablespaces -> Create -> Fill name, another default -> Add Datafile -> fill File Name -> change File Size -> OK
3. PARAMETR SERWERA: Server -> Initalization Parameters -> search for job* -> change value -> APPLY
4. ROLE: (Security) Roles -> Create -> Name = nazwa_roli -> Object Privileges -> Drop-down = Table -> ADD -> Select Table Objects = nazwa_tabeli -> Available Privileges = uzupełnić (INSERT, ITP) -> OK
Dodatkowo: dziedziczenie ról Roles -> Create -> Roles -> Edit List -> wybór roli -> OK
5. USER: Server -> (Security) Users -> Create -> Fill Name, password, Tablespace (?), profile (down-drop)  -> Roles -> Edit List -> odpowiednie role ->  OK -> System Privileges -> Edit List -> odpowiednie uprawnienia -> OK -> Apply
6. USER: Server -> (Security) Users -> Create -> Fill Name, password, Tablespace (?), profile (down-drop)  -> Roles -> Edit List -> odpowiednie role ->  OK -> General -> Status = locked or Action drop-down = Lock User -> Apply
7. PROFIL: Server -> (Security) Profiles -> Create -> Fill fields, to co wymagają -> OK
Server -> Initialization Parameters -> Name field: resource_limit -> GO -> set to TRUE -> APPLY
8. TABELA: Schema -> (Database Object) Tables -> Create -> Leave default -> Continue -> Fill Name, Schema, Tablespace -> Fill table fields -> OK
9. INDEX: Schema -> (Database Object) Indexes -> Create -> Fill name, schema -> select table name -> populate columns -> add value order = 1 to index column -> OK

VIEWS: Schema -> (Database Object) Views -> Create -> fill name, schema -> query text (select) -> OK