Interview Questions

Oracle

Oracle Client Installation in Linux

ORACLE CLIENT INSTALLATION IN LINUX

  • Download oracle client (Version -> 10201_client_linux_x86_64.cpio.gz)
  • gzip -d 10201_client_linux_x86_64.cpio.gz
  • cpio -idmv < 10201_client_linux_x86_64.cpio
  • LINUX USER/GROUP creation

    The following local UNIX group and user must exist on the system:

    * The oinstall group (the Oracle Inventory group)
    * The oracle user (the Oracle software owner)

Oracle Export and Import command

1. Log-on to server where Oracle is installed, go to $ORACLE_HOME/bin/

Export schema oracle_db/oracle_db from orcl using the following command,

exp userid= oracle_db/oracle_db@orcl file=/tmp/oracleDBExport.dmp rows=(n) statistics=none

2. Go to /tmp/ folder and check oracleDBExpor.dmp file is available.

3. Log-on to server where schema is to be imported, go to $ORACLE_HOME/bin/

Execute the following command