Exporting for an Oracle 12 import
Exporting the database when planning to import it back in Oracle 12 requires the use of the expdp command.
Procedure
- Copy the file
expdp.parfrom C:\IShCD\yyyymmdd.CD.InfoShare<version_num>.ProjectName.IT\Database\Dump\Oracle\expdp to the dump directory (DATA_PUMP_DIR) on the database server.Note: The dump directory should be in the line of C:\Oracle\admin\<DatabaseName>\dpdump. - Goto the database server.
- Adapt the file names for the
DUMPFILEandLOGFILEin the expdp.par file. - Open a Command Prompt and set the following variables:
Set ORACLE_SID=ISH
Set ORACLE_HOME depending on your Oracle version:
Oracle 11 set ORACLE_HOME=c:\oracle\product\11.2.0\dbhome_1 Oracle 12 set ORACLE_HOME=c:\oracle\product\12.1.0\dbhome_1 Note: All commands must be entered in the same window, ensuring that every environment variable set is available throughout the process. The next steps presume that you use the same shell with these variables set correctly. - Start sqlplus as sysdba
- Check if there is a dump directory "DATA_PUMP_DIR"
SELECT directory_path FROM dba_directories WHERE directory_name ='DATA_PUMP_DIR'; - Make sure the dedicated
isourcedatabase user has read and write access to the directoryGRANT read, write ON DIRECTORY data_pump_dir TO isource; - Exit SQLPlus, so you are back at the command prompt.
- Execute the following command
expdp parfile="C:\Oracle\admin\<DatabaseName>\dpdump\expdp.par" - Provide the user name and password for the dedicated
isourcedatabase user.The dump file is exported in the dump directory, you can import it back after you have uninstalled the old version of Content Manager.