Oracle VirtualBox 7.0.10 Download and Installation (Step 1)

 Dear all,

In this post i am going to show you how install Oracle VirtualBox 7.0.10 on Windows Machine.

Download VirtualBox from Below url :

https://www.virtualbox.org/wiki/Downloads

a.   If above Virtual box is not supported then download the supported version from virtualbox.org.

Click on  VirtualBox-7.0.10-158379-Win …  it will prompt one window you click on YES then you will see below snap.

Click on Next from the above snap..

On Custom Setup screen, keep as default and click next

In my case I have changed the path to install this VM because I have already installed one version in C drive so this one I have selected D:/

On Warning: Network Interfaces screen, click yes.

Missing Dependencies Click Yes ..

Now we are ready to Install :

 Installation is in Progress :

Click on Finish ..

This concludes the Oracle Virtual Box installation ..

Home Page :

To Continue to this post i am going to install OEL 7.3 On this Machine .. Stpe2 

Thanks,

Srini
 

Oracle DBA Training Batch 1 starts from 19th Jul 2023

Dear All,

RACSINFOTECH conducting Oracle DBA Training from 19th Jul 2023 7:30PM IST ( its free training batch 1 ) .

This training conducting Free of cost because it will useful for jobseekers and students those who are looking for jobs in IT post studies .

Note: This training is of Basic L1 and L2 Oracle DBA Knowledge and  not for the professionals  who are already working in this field. 

Guys this batch already started you can watch those sessions here .. 

https://www.youtube.com/channel/UCpQ8qfpjm-dG7r1QAwKMimQ 

Thanks,

Srini

RMAN Convert Transportable with Data Pump Highlevel step by step actions

 Dear All,

In this post i am sharing RMAN Convert Transportable with Data Pump .

ON-PREM

• Check the DPUMP_DIR already exists

 • Alter tablespace dbaltab read only;

 expdp system/oracle12@oracleprem:1539/xepdb1 TRANSPORT_TABLESPACES=DBALTAB TRANSPORT_FULL_CHECK=YES DIRECTORY=dpump_dir dumpfile=exp_dbaracsinfo_con_tts.dmp logfile=exp_dbaracsinfo_con_tts.log

$mkdir -p /opt/oracle/conv_df

 RMAN> CONVERT TABLESPACE DBALTAB to platform='Linux x86 64-bit' format '/opt/oracle/conv_df/%U';

$scp -i /home/oracle/.ssh/id_rsa /opt/oracle/dumps/exp_dbaracsinfo_con_tts.dmp oracle@120.41.126.36:/u01/app/oracle/admin/export/.

$ scp -i /home/oracle/.ssh/id_rsa /opt/oracle/conv_df/data_D-XE_I-2908503447_TS[1]DBALTAB_FNO-14_01uk3kl3 oracle@120.41.126.36:/u01/app/oracle/admin/export/.

SQL> Alter tablespace dbaltab read write;

 On OCI

SQL> Drop user dbaracsinfo cascade;

SQL> Drop tablespace dbaltab including contents and datafiles;

• Create directory dpump_dir as ‘/u01/app/oracle/admin/export’;

 • Select name from v$datafile , get the path

 cp /u01/app/oracle/admin/export/data_D-XE_I-2908503447_TS-DBALTAB_FNO[1]14_01uk3kl3 +DATA/OCI18_FRA1B5/9A182239BFCB2161E0530200000AF690/DATAFILE/dbaltab01.d bf

• Create the user on destination environment

SQL>  create user dbaracsinfo identified by OCIDbsytem007## temporary tablespace temp;

SQL> Grant create session to dbaracsinfo;

 User created.

 • Perform the import

 $ impdp system/OCIdbasystem2##@10.1.0.2:1521/pdb1.sub12192155370.vcndbal.oraclevcn.c om DIRECTORY=dpump_dir TRANSPORT_DATAFILES='+DATA/OCI18_FRA1B5/9A182239BFCB2161E0530200000AF6 90/DATAFILE/dbaltab01.dbf' dumpfile=exp_dbaracsinfo_con_tts.dmp

Login check data and make the tablespace as read write

 SQL> alter tablespace dbaltab read write;

Tablespace altered

Thanks,

Srini