Forum Stats

  • 3,734,237 Users
  • 2,246,916 Discussions
  • 7,857,196 Comments

Discussions

Installed Oracle VM VirtualBox, the Oracle DB Developer VM, downloaded the XE database ... but now .

Installed Oracle VM VirtualBox, the Oracle DB Developer VM, downloaded the XE database ... but now I'm lost, due to the online manual ...

When I try to run:  Run yum -y localinstall yum -y localinstall home/oracle/oracle-database-xe-18c-1.0-1.x86_64.rpm ... I got the notifications:

Loaded plugins: langpacks, ulninfo

Skipping: yum, filename does not end in .rpm.

Due to the Oracle 7 linux manual I don't know how to load yhe plugins langpacks and ulninfo and the filename really does end in rpm

Who can help me please?

I need the XE database next thuesday evening 8th June, for a training

Thanks in advance

Answers

  • cormaco
    cormaco Member Posts: 1,559 Bronze Crown

    The Oracle DB Developer VM already contains a database, no need to download and install one separately.

    Follow the instructions on this page:

    Once you are logged into the VM you have a running instance of Oracle Database 19.3 Linux x86-64

  • User_93FIZ
    User_93FIZ Member Posts: 3 Green Ribbon

    Thanks for your answer!!

    I follewed the instructions and came to a terminal with:|

    ------

    Database Information:

    Oracle SID   : orclcdb

    Pluggable DB : orcl

    Pluggable DB : ords create if required by running:

       'newpdbords' in the terminal - for ORDS pdb creation.

            (if 'sqlplus system/[email protected]' connects ORDS pdb has already been installed)

       'loadstorm' in the terminal for spatial demo data - takes a few minutes.

    ALL PASSWORDS ARE : oracle

    *** Please note that this appliance is for testing purposes only,

    as such it is unsupported and should not be used as a production environment.

    try JDBC REST driver: sql HRREST/[email protected]http://localhost:8080/ords/hrrest/

    [[email protected] ~]$

    ------

    But I don't know, what to do, which commands I have to use, where ...

    Please help again.

    Greetings from Harry

  • cormaco
    cormaco Member Posts: 1,559 Bronze Crown

    Try these commands in the terminal:

    Connect to the PDB as admin user: sqlplus sys/[email protected] as sysdba

    Once connected unlock the HR user: alter user HR unlock

    Then exit and reconnect as HR: sqlplus hr/[email protected]

    I can't test these right now but you get the idea. You can also try SQL Developer to connect to the database.

    I don't know what training you are taking, but IMO it is the trainer's job to tell you how to set up your environment.

  • User_93FIZ
    User_93FIZ Member Posts: 3 Green Ribbon

    Hello Cormaco,

    Thanks for helping me ...

    The online trainer helped me ‘on the road’…

    but I am the only one who uses a Oracle Virtual Box, the other 11 students use the Oracle Express Edition with the Oracle Installer with help from the Oracle-specialist on their work

    I installed:

    - VM Virtual Box

    - Oracle DB Developer VM

    - run: newpdbords

    - run loadstorm


    - run: sql HRREST/[email protected]http://localhost:8080/ords/hrrest/

    And yes, I started SQL-Developer and could connect tot he ORDS-database, as system, password oracle

    Then I run:

    - crcase.sql

    - and constraints.sql

    And YES, I have the right tables en views,

    but … there is no data in it, no content … almost there …

    What I’m doing wrong or what did i missed?

    When I try to import date, the program askes for file ..

    wher can I finf these?

    They are named: AFDELINGEN, CURSUSSEN, HELP, HISTORIE, INSCHRIJVINGEN, MEDEWERKERS, SCHALEN, UITVOERINGEN, REDO_DB, REDO_LOG, etc …

    Thuesday evening 15th of June I have my second Oracle-SQL training.

    Who could help me please?

    Thanks in advance.

  • cormaco
    cormaco Member Posts: 1,559 Bronze Crown
    They are named: AFDELINGEN, CURSUSSEN, HELP, HISTORIE, INSCHRIJVINGEN, MEDEWERKERS, SCHALEN, UITVOERINGEN,
    

    These tables are obviously part of your training. Again your trainer should provide you with a script to fill these tables.

Sign In or Register to comment.