OraFAQ Forum: Server Utilities » 9i to 10g upgrade through import error

Home » RDBMS Server » Server Utilities » 9i to 10g upgrade through import error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

9i to 10g upgrade through import error [message #251855]

Mon, 16 July 2007 23:47

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

Hi,
I have import of schemas from oracle 9.2.0.8 on windows platform.I have a HP UNIX (64 bit) server, where i have installed oracle 10.2.0.3,I have created a database exact replica of 9i database.When i import a schema i get the following error,

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

The 10g database is up and running fine.Can anyone please shed light of the possible cause of error.I have 9i server installed of my local machine.

Report message to a moderator

Re: 9i to 10g upgrade through import error [message #251857 is a reply to message #251855]

Mon, 16 July 2007 23:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>The 10g database is up and running fine.
You offer no proof the assertion above is true.

When things do not appear to be as they should, they probably are not.

You don't use CUT & PASTE to show what was done that produced posted error messages.

When I have to choose between believing Oracle and a double digit poster; I'll believe Oracle EVERY time.

Report message to a moderator

Re: 9i to 10g upgrade through import error [message #251859 is a reply to message #251855]

Tue, 17 July 2007 00:11

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Pooja ur requirement is not clear to me . U said u imported schema in 9i and again u said u imported schema in 10g.

But according to error I can say you used import command before opening the oracle database. First , use startup and then use import operation..

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> host impdp system/t dumpfile=a.dmp directory=d

Import: Release 10.2.0.1.0 - Production on Tuesday, 17 July, 2007 11:08:27

Copyright (c) 2003, 2005, Oracle. All rights reserved.

UDI-00008: operation generated ORACLE error 1034
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Solaris-AMD64 Error: 2: No such file or directory
UDI-00003: all allowable logon attempts failed

Report message to a moderator

Re: 9i to 10g upgrade through import error [message #251981 is a reply to message #251855]

Tue, 17 July 2007 10:47

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

pooja_g wrote on Mon, 16 July 2007 22:47

SQL> select OPEN_MODE from v$database;

READ WRITE

As imp/exp works only in open stage not in mount not in nomount.

Report message to a moderator

Re: 9i to 10g upgrade through import error [message #254985 is a reply to message #251981]

Mon, 30 July 2007 05:55

pooja_g
Messages: 56
Registered: December 2005
Location: India

Member

Thanks guys,
The database is open,that error was due to wrong port in tnsnames.

Report message to a moderator

Previous Topic:	Creating a Batch File
Next Topic:	export LOB and CLOB from one to another database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 21:55:34 CDT 2024