Now is time to add our ssh key into the pageant, you can download from the following link
- https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html
Open pageant and load private key
Oracle Cloud with WebLogic and ATP database - Create instance (Linux VM)
Click on Create Instance - this will give you possibilities to create new VM server
Oracle Database Migration from non-cdb to pdb - components issue
We decide to create a new CDB container instance with version 12.2.0.1 in order to plug into non-cdb database which is converted to pdb.
The task is very simple, we have to create a new pluggable database with NOCOPY option due to the fact that all data files are in place and we don't need to use COPY option because all datafiles are on the correct location.
If you are trying to load the script in Oracle Sql Developer near to 100MB you may need to change the memory parameter in the configuration file sqldeveloper.conf - location sqldeveloper\bin
Error:
Fix
Add on file sqldeveloper.conf following parameter -> AddVMOption -Xmx4096M and restart SqlDeveloper
Have fun
Exporting..... takes time in some case :)
Error:
UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3905
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5203
ORA-06512: at line 1