host: RHEL 8.10
Official docker from oracle
docker pull container-registry.oracle.com/database/enterprise:12.2.0.1
docker pull container-registry.oracle.com/database/enterprise:19.3.0.0
I need to transfer databases from several old servers (about 7 databases). I want to physically place the databases on the host machine (/u01/...).
Please tell me how best to do this?
- expdp - impdp
- copying database files
With what parameters should the container be launched in order to:
- Import the database
- Connect the database to the copied database files
Do I need to create a separate space?
docker volume create oracle_data
I wanted to start creating a database through dbca. But the container does not have x11 installed.
[oracle@500e34ea9c2a /]$ dbca
DISPLAY not set.
Set DISPLAY environment variable, then re-run.
[oracle@500e34ea9c2a /]$ echo $DISPLAY
[oracle@500e34ea9c2a /]$ export DISPLAY=localhost:10.0
[oracle@500e34ea9c2a /]$ echo $DISPLAY
localhost:10.0
[oracle@500e34ea9c2a /]$ dbca
Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class sun.awt.X11.XToolkit
I managed to connect to the DBMS using SQL DEVELOPER