[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

IMPORT PBs

Posted on 2004-09-08
1
Medium Priority
?
1,208 Views
Last Modified: 2009-12-16
Hello,

I created a new TEST database in Oracle 9i under the Red Hat Enterprise 3 (WS) server.
I have an export dump file of about 117 Mbytes.

I tried to import the dump file to my new Test DB, but ran into the following PBs.

IMP-00058: Oracle Error 1034 encountered
ORA-01034: Oracle not available
ORA-27101: Shared Memory Realm does not exists
Linux Error 2: no such file or directory
IMP-00005: All available logon attempts have failed
IMP-00000: Import terminated successfully

What am I doing wrong ?
How can I go about resolving these issues ?

Note: I have 4-5 tablespaces, 16 rollback segments and about 10 users.
0
Comment
Question by:ptreves
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 23

Accepted Solution

by:
seazodiac earned 750 total points
ID: 12010612
Did you have LISTENER process up and running?

try

$lsnrctl status |grep "STATUS"




Is your database up and running?

$ps -ef | grep ora



see if your have oracle database process are up and running.
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question