Archive

Posts Tagged ‘Oracle’

libXp.so.6: cannot open shared object file

November 16, 2007 doquent 1 comment

Encountered the above error while installing Oracle 10g on Fedora Core 6 running on AMD Athlon X2 64-bit architecture. Looking for a solution found this excellent thread which has pointers to other useful resources for installing Oracle on Linux as well.

However, the solution that worked for my particular setup was the following:

yum install libXp

Categories: Etc Tags: , , , , , , , ,

Import Database from Oracle Dump

October 18, 2007 doquent 1 comment

This post is probably too elementary and simplistic for anyone with Oracle administration experience. However, developers who normally don’t perform administration tasks may find it handy for setting up a DEV Oracle database.

Suppose you need to import an Oracle dump file for creating a local database copy for development purposes. The following steps can be used as a guideline.

  1. Prerequisites:
    1. Oracle database server software has been installed.
    2. An Oracle instance (say orcl) has been set up.
  2. Create a tablespace for the imported the data and associate a user with it. It can be accomplished with a script along the lines of the following. Replace the italicized tablespace name and user name/password with your own values. You can also change the database file path. Run this script when connected as SYSDBA.
    set echo on
    spool c:\temp\orcl.log
    CREATE TABLESPACE MY_TABLESPACE DATAFILE
    'C:\oracle\product\10.2.0\oradata\orcl\MY_TABLESPACE.DBF' SIZE 512M REUSE;
    ALTER DATABASE DATAFILE 'C:\oracle\product\10.2.0\oradata\orcl\MY_TABLESPACE.DBF'
    AUTOEXTEND ON NEXT 256M MAXSIZE 2048M;
    GRANT CONNECT TO myuser IDENTIFIED BY myuserpassword;
    GRANT CREATE ANY VIEW,RESOURCE,UNLIMITED TABLESPACE to
    myuser;
    ALTER USER myuser DEFAULT TABLESPACE MY_TABLESPACE
    TEMPORARY TABLESPACE TEMP;
    GRANT select_catalog_role TO myuser;
    spool off
    disconnect;
    exit;
  3. Import the dump file using the command-line utility present in the bin folder, e.g. C:\oracle\product\10.2.0\db_1\BIN. The command line would look like,
    imp myuser/myuserpassword@ORCL file=c:\temp\mydb.dmp full=yes log=c:\temp\imp.log
Categories: Etc Tags: , , , , ,