Show page

Differences

This shows you the differences between two versions of the page.

--- bd:resurse:instalare_oracle [2019/03/04 21:14]
iulia.radulescu
+++ bd:resurse:instalare_oracle [2020/03/18 22:19] (current)
ciprian.truica
@@ Line 1: / Line 1: @@
 ===== Instalare Oracle =====
-=== Instalare Oracle cu Vagrant si VirtualBox ===
+==== Instalare Oracle folosind docker ====
+[[https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance|Tutorial Instalare Docker 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**
 . Clonati repository-ul de pe github:
+<code sql>
 git clone https://github.com/oracle/vagrant-boxes
+</code>
 . 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**
@@ Line 15: / Line 35: @@
 . cd vagrant-boxes/OracleDatabase/12.2.0.1
-. **vagrant up** - porneste masina virtuala si incepe instalarea Oracle - prima oara o sa dureze mai mult (aproximativ o ora)
+. Porniti masina virtuala - (doar) prima data va incepe automat instalarea Oracle utilizand arhiva descarcata - dureaza aproximativ 1 ora - apoi aceasta comanda porneste instalarea existenta:
-. Dupa instalare va conectati la masina virtuala cu **vagrant ssh**
+<code sql>
+vagrant up
+</code>
-. Setarea variabilelor de mediu pentru sqlplus. Fisierul ~/.bashrc ar trebui asa arate ca mai jos:
+. Dupa instalare va conectati la masina virtuala cu:
-ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/dbhome_1
+<code sql>
+vagrant ssh
+</code>
+. 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
@@ Line 29: / Line 57: @@
 export PATH
 export ORACLE_SID
+</code>
-. Conectati-va pe vagrant ca **oracle** - sudo su oracle
+. Conectati-va pe vagrant ca **oracle**
-. Conectati-va pe sqlplus ca sysdba (un rol privilegiat) - **sqlplus / as sysdba**
+<code sql>
+sudo su oracle
+</code>
-. Din sqlplus porniti instanta si baza de date daca acestea nu sunt deja pornite - **SQL> startup**
+. Conectati-va pe sqlplus ca sysdba (un rol privilegiat):
+<code sql>sqlplus / as sysdba</code>
+. 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>
 . Creati userul pe care veti lucra si acordati-i privilegii:
-**CREATE USER c##stud1 IDENTIFIED BY student;**
-**GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO c##stud1;**
+<code sql>
+CREATE USER c##stud1 IDENTIFIED BY student;
+GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO c##stud1;
 connect c##stud1/student
+</code>
 . Apoi rulati scriptul din resurse pentru a va crea tabelele.
-=== Raw Install ===
+. 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>
+. 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]]
@@ Line 50: / Line 124: @@
 <note important>Pentru Linux aveți grijă să vă uitați ce distribuții suportă.</note>
-=== Pre-Built Developer VMs ===
+==== 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 ===
+==== Oracle Live SQL ====
   * poate fi accesat [[https://livesql.oracle.com|aici]]
-=== Oracle Vagrant Boxes ===
+==== Oracle Vagrant Boxes ====
   * poate fi accesat [[https://github.com/oracle/vagrant-boxes/tree/master/OracleDatabase|aici]]
-=== Tutoriale Oracle Virtualbox ===
+==== Tutoriale Oracle Virtualbox ====
@@ Line 72: / Line 146: @@
 Daca mergeti pe varianta cu Vagrant instalati Oracle VirtualBox pana in versiunea 5.2 inclusiv - versiunea 6 nu functioneaza inca impreuna cu Vagrant.
 </note>

Laboratoare

Resurse

bd/resurse/instalare_oracle.1551726885.txt.gz · Last modified: 2019/03/04 21:14 by iulia.radulescu

Show page Old revisions

Media Manager Back to top