Solved

IMPORT PBs

Posted on 2004-09-08
1
1,183 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
1 Comment
 
LVL 23

Accepted Solution

by:
seazodiac earned 250 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
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 how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

910 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now