Home » RDBMS Server » Server Utilities » 9i to 10g upgrade through import error
9i to 10g upgrade through import error [message #251855] Mon, 16 July 2007 23:47 Go to next message
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.
Re: 9i to 10g upgrade through import error [message #251857 is a reply to message #251855] Mon, 16 July 2007 23:54 Go to previous messageGo to next message
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.
Re: 9i to 10g upgrade through import error [message #251859 is a reply to message #251855] Tue, 17 July 2007 00:11 Go to previous messageGo to next message
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
Re: 9i to 10g upgrade through import error [message #251981 is a reply to message #251855] Tue, 17 July 2007 10:47 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
pooja_g wrote on Mon, 16 July 2007 22:47
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.



SQL> select OPEN_MODE from v$database;

READ WRITE


As imp/exp works only in open stage not in mount not in nomount.
Re: 9i to 10g upgrade through import error [message #254985 is a reply to message #251981] Mon, 30 July 2007 05:55 Go to previous message
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.
Previous Topic: Creating a Batch File
Next Topic: export LOB and CLOB from one to another database
Goto Forum:
  


Current Time: Wed Dec 25 10:18:38 CST 2024