?
Solved

IMPORT PBs

Posted on 2004-09-08
1
Medium Priority
?
1,216 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 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

569 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