Excerpt the DB-config to use in a VM /or: clone a DB-configuration

Apr 11, 2023 4:08PM

Hi Everyone,

I'm not new to Databases & SQL but to Oracle. And actually, I'm facing a challange where I require support.

We have on-premise installed an Oracle-DB, 19c, on AIX 7.2.

A collegue of mine want to duplicate this DB -not completely, just some parts- on a VM with Oracle Linux (running on Azure).

So, he created a DB

<code>

su oracle -c "source ~/.bashrc; dbca -silent -createDatabase -templateName General_Purpose.dbc \

-gdbname MyDB -sid mydb -responseFile NO_VALUE -characterSet WE8ISO8859P1 -sysPassword * \

-systemPassword * -createAsContainerDatabase false -databaseType MULTIPURPOSE \

-automaticMemoryManagement false -storageType FS -datafileDestination "/ORACLE" -ignorePreReqs"

</code>

and I forwarded to him a datapump export of 2 schemas. Of course, the import failed due to different configuration (e.g. missing tablespaces).

Database Administration (MOSC)