Changes between Version 29 and Version 30 of OracleTestSetup


Ignore:
Timestamp:
May 4, 2017, 1:46:41 PM (7 years ago)
Author:
Mariusz Felisiak
Comment:

Updated instruction due to the new version of the Oracle Developer Day VM.

Legend:

Unmodified
Added
Removed
Modified

  • OracleTestSetup

    v29 v30  
    1010===============================================
    1111
    12 Oracle provides pre-built virtual machine images with Oracle Database 12c Release 1 Enterprise Edition (12.1.0.2.0) for developers in form of an OVA archive which can be imported by VirtualBox. The archive can be downloaded `here`__ (or alternately a different one can be chosen from `this list`__) after signing up for an *Oracle Developer Network* account.
     12Oracle provides pre-built virtual machine images with Oracle Database 12c Release 2 Enterprise Edition (12.2.0.1.0) for developers in form of an OVA archive which can be imported by VirtualBox. The archive can be downloaded `here`__ (or alternately a different one can be chosen from `this list`__) after signing up for an *Oracle Developer Network* account.
    1313
    14 .. __: http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
    15 .. __: http://www.oracle.com/technetwork/community/developer-vm/index.html
     14.. __: https://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
     15.. __: https://www.oracle.com/technetwork/community/developer-vm/index.html
    1616
    1717The server will probably be somewhat slower than if you install it directly on the host machine, but using a VM has a slightly simpler setup, there's a somewhat smaller chance you'll pollute your host system completely and in case something goes wrong, you can always just remove the virtual machine, import a fresh copy and start again.
    1818
    19 #. Download the OVA file from http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html and import it into VirtualBox (File -> Import Appliance). You'll have to accept an extensive license agreement.
     19#. Download the OVA file from https://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html and import it into VirtualBox (File -> Import Appliance). You'll have to accept an extensive license agreement.
    2020
    21 #. By default, the VM will be configured to have one NAT network interface and active port forwarding on port 1521. The database server itself starts automatically and listens on port 1521 (which is the default port for the Oracle listener), therefore you can connect to Oracle server using ``127.0.0.1:1521``. VM image uses ``cdb1`` as Oracle *SID* and ``oracle`` as pluggable DB.
     21#. By default, the VM will be configured to have one NAT network interface and active port forwarding on port 1521. The database server itself starts automatically and listens on port 1521 (which is the default port for the Oracle listener), therefore you can connect to Oracle server using ``127.0.0.1:1521``. VM image uses ``orcl12c`` as Oracle *SID* and ``orcl`` as pluggable DB.
    2222
    2323#. The server comes with more than thirty user accounts created beforehand. Password for all accounts is ``oracle``.  Crucial users are ``sys`` and ``system`` because both of them have "*sysdba*" privilege (which means full control over DB and privileges to do everything). You can use them to create new test accounts in ``orcl`` container.
    … …  
    2525   As for other credentials on the virtual machine, if you want to login as a regular user, just use ``oracle``/``oracle``, the root password is ``oracle`` as well. However, in order to run the test suite, you just need to boot the machine up, you don't need to start anything manually.
    2626
    27 #. Install *instantclient* on your host system (the one where you'll be running the test suite). On Debian or Ubuntu you can download the RPM packages ("Instant Client Package - Basic", "Instant Client Package - SDK" and "Instant Client Package - SQL*Plus" for 12.1.0.2.0) from http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html and install using alien::
     27#. Install *instantclient* on your host system (the one where you'll be running the test suite). On Debian or Ubuntu you can download the RPM packages ("Instant Client Package - Basic", "Instant Client Package - SDK" and "Instant Client Package - SQL*Plus" for 12.2.0.1.0) from https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html and install using alien::
    2828
    29    $ sudo alien -i oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
    30    $ sudo alien -i oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
    31    $ sudo alien -i oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
     29   $ sudo alien -i oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
     30   $ sudo alien -i oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
     31   $ sudo alien -i oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
    3232
    3333   After installing the client, you need to add links to Oracle shared libraries and ``sqlplus``::
    3434
    35    $ sudo echo "/usr/lib/oracle/12.1/client64/lib/" > /etc/ld.so.conf.d/oracle.conf
     35   $ sudo -- bash -c 'echo "/usr/lib/oracle/12.2/client64/lib/" > /etc/ld.so.conf.d/oracle.conf'
    3636   $ sudo ldconfig
    3737   $ sudo ln -s /usr/bin/sqlplus64 /usr/bin/sqlplus
Back to Top