Solved

IMPORT PBs

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

Join & Write a Comment

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
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 video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

758 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

22 Experts available now in Live!

Get 1:1 Help Now