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

User_93FIZ

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

cormaco

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

Follow the instructions on this page:

https://www.oracle.com/database/technologies/databaseappdev-vm.html

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

User_93FIZ

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

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

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

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.