Home » Infrastructure » Linux » Exp on Window / Imp on Linux - Problem (IMP-00038)
Exp on Window / Imp on Linux - Problem (IMP-00038) [message #198702] Wed, 18 October 2006 05:14 Go to next message
oliver.neumann
Messages: 4
Registered: October 2006
Junior Member
Hi all,

I am trying to migrate an oracle database from Windows (2003 Server) to Linux (Debian Sarge 3.1).

The versions/NLS settings are:

Windows:
Quote:
Oracle 9.2.0.1.0
NLS_LANGUAGE GERMAN Language
NLS_TERRITORY GERMANY Territory
NLS_CURRENCY $ Local currency
NLS_ISO_CURRENCY GERMANY ISO currency
NLS_NUMERIC_CHARACTERS ., Numeric characters
NLS_CHARACTERSET WE8ISO8859P15 Character set



Linux:
Quote:
Oracle 10.2.0.1.0
NLS_LANGUAGE AMERICAN Language
NLS_TERRITORY AMERICA Territory
NLS_CURRENCY $ Local currency
NLS_ISO_CURRENCY AMERICA ISO currency
NLS_NUMERIC_CHARACTERS ., Numeric characters
NLS_CHARACTERSET WE8ISO8859P15 Character set



Now I try to export a tablespace with a user account on Windows and import the dump on the Linux machine.

Unfortunately I get the following error when trying to imp the dump:

Quote:

$ imp

Import: Release 10.2.0.1.0 - Production on Mi Okt 18 11:45:44 2006

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

Username: ffm
Password:

Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production

Import file: expdat.dmp > /root/FFM.DMP

Enter insert buffer size (minimum is 8192) 30720>

IMP-00038: Could not convert to environment character set's handle
IMP-00000: Import terminated unsuccessfully



Where can be the problem? Do I have to add special parameters to exp/imp when trying to generate/import a dump from version 9 to version 10?

Please help.
Re: Exp on Window / Imp on Linux - Problem (IMP-00038) [message #198714 is a reply to message #198702] Wed, 18 October 2006 05:49 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The biggest problem is that you need to be at least patchset 9.2.0.4 to upgrade directly to 10.2.

How did you transfer the file to the Linux box? If you ftp'ed the file, you need to ensure you use BIN mode.

In addition, you should set the 10.2 NLS_LANG setting to that of the 9.2 database.
Re: Exp on Window / Imp on Linux - Problem (IMP-00038) [message #198735 is a reply to message #198714] Wed, 18 October 2006 06:50 Go to previous messageGo to next message
oliver.neumann
Messages: 4
Registered: October 2006
Junior Member
Thanks for the quick answer.

ebrian wrote on Wed, 18 October 2006 12:49
The biggest problem is that you need to be at least patchset 9.2.0.4 to upgrade directly to 10.2.


How can I upgrade the windows box? Is there an upgrade executable available at oracle.com or do I have to reinstall the whole db-server?

Quote:
How did you transfer the file to the Linux box? If you ftp'ed the file, you need to ensure you use BIN mode.


I transfered the fiel via SAMBA share on the linux machine. I guess it should then be a binary transfer.

Quote:
In addition, you should set the 10.2 NLS_LANG setting to that of the 9.2 database.


Can I do that on the running Database and if not, how can I set this whiel creating a database? The oracle installer only asked for a charset but not for the NLS_LANG.
Re: Exp on Window / Imp on Linux - Problem (IMP-00038) [message #198742 is a reply to message #198735] Wed, 18 October 2006 07:21 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
oliver.neumann wrote on Wed, 18 October 2006 06:50
Is there an upgrade executable available at oracle.com or do I have to reinstall the whole db-server?

You'll need to obtain the 9.2.0.4 patch (at least this level) from Metalink and install it on the 9.2.0.1 database. There is a readme with the patch that describes how to apply it.

Quote:
I transfered the fiel via SAMBA share on the linux machine. I guess it should then be a binary transfer.

With the SAMBA transfer you should be ok.

Quote:
Can I do that on the running Database and if not, how can I set this whiel creating a database? The oracle installer only asked for a charset but not for the NLS_LANG.

Specifying the Value of NLS_LANG describes the parameter and how to set it.
Re: Exp on Window / Imp on Linux - Problem (IMP-00038) [message #198757 is a reply to message #198742] Wed, 18 October 2006 08:02 Go to previous messageGo to next message
oliver.neumann
Messages: 4
Registered: October 2006
Junior Member
ebrian wrote on Wed, 18 October 2006 14:21
oliver.neumann wrote on Wed, 18 October 2006 06:50
Is there an upgrade executable available at oracle.com or do I have to reinstall the whole db-server?

You'll need to obtain the 9.2.0.4 patch (at least this level) from Metalink and install it on the 9.2.0.1 database. There is a readme with the patch that describes how to apply it.


Unfortunately I have no account at metalink.oracle.com and I also have no CSI as we are only using oracle for internal development for our customers. How can I get an CSI without having a support contract at Oracle's?

Quote:
Quote:
Can I do that on the running Database and if not, how can I set this whiel creating a database? The oracle installer only asked for a charset but not for the NLS_LANG.

Specifying the Value of NLS_LANG describes the parameter and how to set it.


Ok, will try this.

[Updated on: Wed, 18 October 2006 08:02]

Report message to a moderator

Re: Exp on Window / Imp on Linux - Problem (IMP-00038) [message #198778 is a reply to message #198757] Wed, 18 October 2006 08:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I don't know of any other way to get access to Metalink without having a valid CSI.

You may want to check with your customer; I would think (or at least hope) they have a CSI number.
Re: Exp on Window / Imp on Linux - Problem (IMP-00038) [message #198977 is a reply to message #198778] Thu, 19 October 2006 08:31 Go to previous messageGo to next message
oliver.neumann
Messages: 4
Registered: October 2006
Junior Member
ebrian wrote on Wed, 18 October 2006 15:45
I don't know of any other way to get access to Metalink without having a valid CSI.

You may want to check with your customer; I would think (or at least hope) they have a CSI number.


Ok, will check that.

Another thing: I now created the database with German_Germany.WE8ISO8859P15 using "dbca" and the user oracle with whom the db is started has NLS_LANG as environment var set to this value.

But when I do a "select * from sys.props$" I still get AMERICA_AMERICAN.WE8ISO8859P15 as NLS settings. Is that ok? How can I show the db's values?
Re: Exp on Window / Imp on Linux - Problem (IMP-00038) [message #199166 is a reply to message #198977] Fri, 20 October 2006 13:11 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Did you change the database character set to WE8ISO8859P15 and then specify the nls_language to GERMANY and nls_territory to GERMAN in DBCA ? If so, I'm not sure why it is showing AMERICA_AMERICAN.WE8ISO8859P15. AMERICA_AMERICAN happens to be the default if a different one is not specified during DB creation.

The WE8ISO8859P15 character set can support both the GERMAN & AMERICA (English) language, however if you want to change the nls_language and nls_territory for the system, I believe you will have to recreate the database. The parameters themselves can be changed, but only at the session level.

If you recreate the database with DBCA, this time just generate the scripts with DBCA and verify that the init file that it generates has GERMAN and GERMANY set for nls_language and nls_territory respectively. If everything looks ok, you can either run the scripts to create the database or re-run DBCA.
Previous Topic: Nfs problem
Next Topic: Linux Oracle 10g-Error---ORA- 12514
Goto Forum:
  


Current Time: Sun Dec 04 18:45:33 CST 2016

Total time taken to generate the page: 0.07592 seconds