Solved

IMPORT PBs

Posted on 2004-09-08
1
1,201 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 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

726 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