# Tworzenie nowej instancji bazy danych W DB Oracle w ver >19

<span lang="PL">Weryfikacja uprawnień w katalogach /oracle/db/ (775)</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-d4m2llfg.png)</span>

<span lang="PL">Oraz weryfikacja uprawnień dla katalogu /tmp (1777)</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-6a1nhnkb.png)</span>

<span lang="PL">Do zmiany będziemy potrzebować program xming oraz putty z skonfigurowanym X11 forwarding.</span>

<span lang="PL"> </span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-je8swkdc.png)</span>

<span lang="PL">Zalogowanie bezpośrednio na serwer, za pomocą konta oracle jest wymagane dla dobrego przepięcia zmiennej display i możliwości uruchamiania aplikacji graficznych poprzez ssh.</span>

<span lang="PL">Po zalogowaniu wywołałem Database Configuration Assistant, poprzez komendę **dbca**</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-eyxvhqo0.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-rnzkavie.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-yov1misv.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-po98m6wg.png)  
</span>

<span lang="PL">Zweryfikowanie nazwy bazy danych na aktualnie działającym systemie : </span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-e2jhtmmg.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-9kcvzjjy.png)  
</span>

<span lang="PL">Database name oraz sid został zapisany małymi literami, by zgadzał sie z punktami montowania na serwerze. Zrzut jest sprzed tej zmiany.</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-eagpmott.png)  
</span>

<span lang="PL">Utworzenie dwóch sekretów w Secret Serverze oraz wypełnienie okna : </span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-cqjun87d.png)  
</span>

<span lang="PL"> </span>

<span lang="PL">[<span lang="EN-US" style="mso-ansi-language: EN-US;">EWE013 - DB - ENTIADEV - system</span>](https://latimer.bcc.com.pl/SecretServer/app/#/secret/49643/general)</span>

<span lang="PL">[<span lang="EN-US" style="mso-ansi-language: EN-US;">EWE013 - DB - ENTIADEV - sys</span>](https://latimer.bcc.com.pl/SecretServer/app/#/secret/49642/general)</span>

<span style="mso-ansi-language: EN-US;"> </span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-leyvewky.png)  
</span>

<span lang="PL"> </span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-bwapfwbk.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-jwcdohgc.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-ozlcoxtb.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-bfgpawp6.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-x8jr154y.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-sxcnk7b4.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-mbnirh8v.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-sxwb5il5.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-mbkb2m6g.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-firgktff.png)  
</span>

<span lang="PL">Usunięcie plików redologów, ponieważ w późniejszych krokach utworzę ję z komend SQL:</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-ebw0u4o5.png)  
</span>

<span lang="PL">I utworzonie tymczasowych redologów o numerach 15 i 16 </span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-lfxomazf.png)  
</span>

<span lang="PL">Zmiana wielkości redologów na 100MB</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-6px2igrj.png)![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-smm2ubbe.png)</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-oo9ejyal.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-c3v0gquk.png)  
</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-puzh1jgi.png)</span><span lang="PL"> </span>

<span lang="PL">Po pomyślnym zainstalowaniu bazy danych, połączyłem się sqldeveloperem do instancji entiadev by dodać prawidłowe pliki redologów: </span>

<span lang="PL"> </span>

```sql
ALTER DATABASE
ADD LOGFILE GROUP 1 ('/oracle/db/entiadev/redoA/redo_g01m1.log', '/oracle/db/entiadev/mredoA/redo_g01m2.log')
SIZE 100M;

ALTER DATABASE
ADD LOGFILE GROUP 2 ('/oracle/db/entiadev/redoB/redo_g02m1.log', '/oracle/db/entiadev/mredoB/redo_g02m2.log')
SIZE 100M;

ALTER DATABASE
ADD LOGFILE GROUP 3 ('/oracle/db/entiadev/redoA/redo_g03m1.log', '/oracle/db/entiadev/mredoA/redo_g03m2.log')
SIZE 100M;

ALTER DATABASE
ADD LOGFILE GROUP 4 ('/oracle/db/entiadev/redoB/redo_g04m1.log', '/oracle/db/entiadev/mredoB/redo_g04m2.log')
SIZE 100M;

ALTER DATABASE
ADD LOGFILE GROUP 5 ('/oracle/db/entiadev/redoA/redo_g05m1.log', '/oracle/db/entiadev/mredoA/redo_g05m2.log')
SIZE 100M;

ALTER DATABASE
ADD LOGFILE GROUP 6 ('/oracle/db/entiadev/redoB/redo_g06m1.log', '/oracle/db/entiadev/mredoB/redo_g06m2.log')
SIZE 100M;
```

<span lang="PL"> </span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-blbgfehl.png)  
</span>

<span lang="PL">Oraz usunąć „dummy” pliki redologów potrzebnych do instalacji:</span>

```
SELECT GROUP#, MEMBER, STATUS FROM V$LOGFILE;

ALTER DATABASE DROP LOGFILE GROUP 15;
ALTER DATABASE DROP LOGFILE GROUP 16;
```

<span lang="PL">Weryfikacja czy zostały tylko grupy 1-6:</span>

<span lang="PL" style="mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-cds45v6x.png)</span>

<span lang="PL">Dla większej czytelności prompta sql, do pliku glogin.sql dodałem :</span>

<span lang="PL">Dodałem także dodatkowe tablespace o którym była mowa w zgłoszeniu :  
</span>[https://servicedesk.all-for-one.com/servicecase/881538](https://servicedesk.all-for-one.com/servicecase/881538)

```
CREATE TABLESPACE RAN
DATAFILE '/oracle/db/entiadev/oradata/ENTIADEV/datafile/RAN.dbf' SIZE 1600M;

CREATE TABLESPACE KOLEKTOR
DATAFILE '/oracle/db/entiadev/oradata/ENTIADEV/datafile/KOLEKTOR.dbf' SIZE 1900M;

CREATE TABLESPACE KOLEKTOR_SMS
DATAFILE '/oracle/db/entiadev/oradata/ENTIADEV/datafile/KOLEKTOR_SMS.dbf' SIZE 300M;

CREATE TABLESPACE KOLEKTOR_DD
DATAFILE '/oracle/db/entiadev/oradata/ENTIADEV/datafile/KOLEKTOR_DD.dbf' SIZE 1600M;
```

<span style="font-size: 9.0pt; mso-bidi-font-size: 8.0pt; mso-ansi-language: EN-US; mso-no-proof: yes;">![](https://bookstack.vm.local/uploads/images/gallery/2023-05/embedded-image-n4aybaso.png)  
</span>

<span style="mso-ansi-language: EN-US;"></span>