Install TOMCAT in oracle AIX
Below steps for installing tomcat in oracle 1.Pre-req: Install Java 8 For Apache Tomcat 9 to be installed and configured properly, you need to have Java version 8 installed on…
Read MoreExport and Import in AWS Cloud
Below is the steps to do export and import in AWS Cloud Environment 1.CONNECT TO PROD AWS CLOUD FROM LOCAL PROD DB sqlplus root/<root_password>@awscld 2.EXPORT DECLARE hdnl NUMBER; BEGIN hdnl := DBMS_DATAPUMP.OPEN( operation => ‘EXPORT’, job_mode => ‘SCHEMA’, job_name=>null); DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => ‘<DUMP_NAME>‘, directory => ‘DATA_PUMP_DIR’, filetype => dbms_datapump.ku$_file_type_dump_file); DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => ‘<EXPDUMP_LOG_NAME>‘, directory => ‘DATA_PUMP_DIR’, filetype => dbms_datapump.ku$_file_type_log_file); DBMS_DATAPUMP.METADATA_FILTER(hdnl,’SCHEMA_EXPR’,’IN (”<SCHEMA_NAME>”)’); DBMS_DATAPUMP.START_JOB(hdnl); END; / 3.CHECK THE STATUS OF THE EXPORT BY USING BELOW QUERY SELECT text FROM table(rdsadmin.rds_file_util.read_text_file(‘DATA_PUMP_DIR’,'<DUMP_LOG_NAME>’)); 4.MOVE THE DUMP FILE TO AWS DEV CLOUD Move the DUMP to AWS DEV CLOUD…
Read More