Could you please stay away from marking arbitrary words with "CODE"-tags, please? CODE-tags are for marking code (as the name suggests) and terminal output, not for highlighting. Consider using bold or italic text for this instead.
To answer your question: that depends on how the dump was created. If it was created with the "exp" utility and the database schema is included in the export:
create the user, grant rights (import, create session and imp_full_database), then import with the "imp" utility:
sqlplus> create user <user> identified by <passwd> default tablespace <tblspc-name> quota unlimited on <tblspc-name>;
sqlplus> grant connect, create session, imp_full_database to <user>;
# imp <user>/<passwd>@<host> file=<dumpfile> log=<logfile> full=y
If the export was done with "expdp" then instead of the "imp" above use:
Set environment variables in your ~/.bash_profile
ORACLE_HOME=/usr/lib/oracle/11.2/client64
PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
export ORACLE_HOME
export LD_LIBRARY_PATH
export PATH
After this I am able to connect to the oracle server.
But the oracle client does not contains the /network/admin/ directory and also the tnsname.ora file.
So i created one to login to the server.
But the bin directory of oracle home contains adrci genezi sqlplus libraries. Whenever I try import, it never works.
Please help.
I think so I have not configured the client properly.
Log-out user and log-in again and now you're ready to use SQL*Plus and connect your server. Type in :