Differences
This shows you the differences between two versions of the page.
|
bd2:resurse:instalare_oracle [2019/09/19 09:34] ciprian.truica |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== Instalare Oracle ===== | ||
| - | |||
| - | === Instalare Oracle cu Vagrant si VirtualBox === | ||
| - | |||
| - | <note important>Pentru a modifica parola de root (sau parola de la orice alt user, inclusiv oracle) pe vagrant utilizati: | ||
| - | <code sql> | ||
| - | sudo passwd root | ||
| - | sudo passwd oracle | ||
| - | </code> | ||
| - | </note> | ||
| - | |||
| - | **Prerequisites** | ||
| - | |||
| - | VirtualBox 5.4 < 6 | ||
| - | |||
| - | Vagrant | ||
| - | |||
| - | Git bash pentru Windows | ||
| - | |||
| - | (Linkuri si instructiuni de instalare mai jos) | ||
| - | |||
| - | **Instalare** | ||
| - | |||
| - | 1. Clonati repository-ul de pe github: | ||
| - | <code sql> | ||
| - | git clone https://github.com/oracle/vagrant-boxes | ||
| - | </code> | ||
| - | |||
| - | 2. In folderul **vagrant-boxes/OracleDatabase/12.2.0.1** salvati .zip-ul pentru **Oracle 12.2.0.1** de [[https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html|aici]] - **Oracle Database 12c Release 2 LINUX** | ||
| - | |||
| - | 3. cd vagrant-boxes/OracleDatabase/12.2.0.1 | ||
| - | |||
| - | 4. Porniti masina virtuala - (doar) prima data va incepe automat instalarea Oracle utilizand arhiva descarcata - dureaza aproximativ 1 ora - apoi aceasta comanda porneste instalarea existenta: | ||
| - | |||
| - | <code sql> | ||
| - | vagrant up | ||
| - | </code> | ||
| - | |||
| - | 5. Dupa instalare va conectati la masina virtuala cu: | ||
| - | |||
| - | <code sql> | ||
| - | vagrant ssh | ||
| - | </code> | ||
| - | |||
| - | 6. Setarea variabilelor de mediu pentru sqlplus. Fisierul **~/.bashrc** ar trebui asa arate ca mai jos: | ||
| - | |||
| - | <code sql>ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/dbhome_1 | ||
| - | PATH=$ORACLE_HOME/bin:$PATH | ||
| - | LD_LIBRARY_PATH=$ORACLE_HOME/lib | ||
| - | ORACLE_SID=ORCLCDB | ||
| - | export ORACLE_HOME | ||
| - | export LD_LIBRARY_PATH | ||
| - | export PATH | ||
| - | export ORACLE_SID | ||
| - | </code> | ||
| - | |||
| - | 7. Conectati-va pe vagrant ca **oracle** | ||
| - | |||
| - | <code sql> | ||
| - | sudo su oracle | ||
| - | </code> | ||
| - | |||
| - | |||
| - | 8. Conectati-va pe sqlplus ca sysdba (un rol privilegiat): | ||
| - | |||
| - | <code sql>sqlplus / as sysdba</code> | ||
| - | |||
| - | 9. Din sqlplus porniti instanta si baza de date daca acestea nu sunt deja pornite | ||
| - | |||
| - | <code sql> SQL> startup </code> | ||
| - | |||
| - | Output-ul ar trebui sa fie urmatorul: | ||
| - | |||
| - | <code sql> | ||
| - | ORACLE instance started. | ||
| - | |||
| - | Total System Global Area 1207959552 bytes | ||
| - | Fixed Size 8792152 bytes | ||
| - | Variable Size 436209576 bytes | ||
| - | Database Buffers 754974720 bytes | ||
| - | Redo Buffers 7983104 bytes | ||
| - | Database mounted. | ||
| - | Database opened. | ||
| - | </code> | ||
| - | |||
| - | 10. Creati userul pe care veti lucra si acordati-i privilegii: | ||
| - | |||
| - | |||
| - | <code sql> | ||
| - | CREATE USER c##stud1 IDENTIFIED BY student; | ||
| - | GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO c##stud1; | ||
| - | connect c##stud1/student | ||
| - | </code> | ||
| - | |||
| - | 11. Apoi rulati scriptul din resurse pentru a va crea tabelele. | ||
| - | |||
| - | 12. Pentru a opri baza de date: | ||
| - | |||
| - | <code sql> SQL> shutdown </code> | ||
| - | |||
| - | Output-ul ar trebui sa fie urmatorul: | ||
| - | |||
| - | <code sql> | ||
| - | Database closed. | ||
| - | Database dismounted. | ||
| - | ORACLE instance shut down. | ||
| - | </code> | ||
| - | |||
| - | 13. Pentru a opri masina virtuala: | ||
| - | |||
| - | <code sql> | ||
| - | vagrant halt | ||
| - | </code> | ||
| - | |||
| - | |||
| - | === Raw Install === | ||
| - | Oracle Database 18c: | ||
| - | * [[https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-windows-180000-5066774.html|Windows x64]] | ||
| - | * [[https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html|Linux x64]] | ||
| - | <note important>Pentru Linux aveți grijă să vă uitați ce distribuții suportă.</note> | ||
| - | |||
| - | === Pre-Built Developer VMs === | ||
| - | * Download [[https://www.virtualbox.org/|Virtual Box]] | ||
| - | * mașina virtuală se găsește [[https://www.oracle.com/technetwork/community/developer-vm/index.html|aici]]. | ||
| - | |||
| - | === Oracle Live SQL === | ||
| - | * poate fi accesat [[https://livesql.oracle.com|aici]] | ||
| - | |||
| - | === Oracle Vagrant Boxes === | ||
| - | * poate fi accesat [[https://github.com/oracle/vagrant-boxes/tree/master/OracleDatabase|aici]] | ||
| - | |||
| - | === Tutoriale Oracle Virtualbox === | ||
| - | |||
| - | |||
| - | [[https://www.cyberciti.biz/faq/how-to-install-virtualbox-on-fedora-linux/|Instalare pe Fedora]] | ||
| - | |||
| - | [[https://www.linuxtechi.com/install-virtualbox6-ubuntu-18-04-centos-7/|Instalare pe Ubuntu 18.04/18.10/CentOS 7]] | ||
| - | |||
| - | <note important> | ||
| - | Nu uitati ca dupa instalare sa va adaugati user-ul la grupul vboxusers! | ||
| - | |||
| - | Daca mergeti pe varianta cu Vagrant instalati Oracle VirtualBox pana in versiunea 5.2 inclusiv - versiunea 6 nu functioneaza inca impreuna cu Vagrant. | ||
| - | </note> | ||
| - | |||
