| Exp on Window / Imp on Linux - Problem (IMP-00038) [message #198702] |
Wed, 18 October 2006 05:14  |
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 #198735 is a reply to message #198714] |
Wed, 18 October 2006 06:50  |
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 #198757 is a reply to message #198742] |
Wed, 18 October 2006 08:02 |
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 #198977 is a reply to message #198778] |
Thu, 19 October 2006 08:31 |
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 |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
