Home » RDBMS Server » Server Administration » MIGRATION FAIL
MIGRATION FAIL [message #271908] Wed, 03 October 2007 06:20 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M

I m migrating one of my database in oracle 10g from oracle 8.1.5

for this i have to migrate in oracle 8.1.7 firstly is it so?

while i m doing the same i am getting the error when i run the migration script u0801050.sql

---------------------------------------------------------
JVMRMACTION

begin if :jvmrmaction = 'DOWNGRADE_8.1.7_TO_8.1.6' then
*
ERROR at line 1:
ORA-06550: line 1, column 10:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
--------------------------------------------------------


i have already set
- ORACLE_HOME
- PATH
- ORA_NLS33
- ORACLE_BASE
- LD_LIBRARY_PATH
- ORACLE_PATH


kindly suggest
Re: MIGRATION FAIL [message #271923 is a reply to message #271908] Wed, 03 October 2007 06:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your character set? database and nls_lang

Regards
Michel
Re: MIGRATION FAIL [message #271934 is a reply to message #271923] Wed, 03 October 2007 07:04 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M

WE8S08859P1, AMERICAN

migration from oracle 8.1.5 to 0racle 8.1.7.4


Regards
TM
Re: MIGRATION FAIL [message #271936 is a reply to message #271923] Wed, 03 October 2007 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I meant full nls_lang (the last part is the character set)
WE8S08859P1 is the database cs or client one?

Regards
Michel
Re: MIGRATION FAIL [message #271941 is a reply to message #271936] Wed, 03 October 2007 07:10 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
NLS_LAN - is AMERICAN
NLS_CHARTERSET=WE8IS08859P1
NLS_NCHAR_CHARACTERSET=WE8IS08859P1
Re: MIGRATION FAIL [message #271948 is a reply to message #271941] Wed, 03 October 2007 07:40 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi michal

kindaly suggest
we are in the process of migrating our database.
.


thanks
Re: MIGRATION FAIL [message #272089 is a reply to message #271948] Thu, 04 October 2007 00:30 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello tkmittal1,

Have you ever patched your oracle v8.1.5?
Maybe you need to apply correction patches.

Regards,


mson77
Re: MIGRATION FAIL [message #272113 is a reply to message #272089] Thu, 04 October 2007 01:25 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
NO patch aplly

and i cant do the same
Re: MIGRATION FAIL [message #272286 is a reply to message #272113] Thu, 04 October 2007 07:53 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello tkmittal1,

What is the NLS_LANG setting on the client machine?

What is the database character set?


COLUMN parameter FORMAT a30;
COLUMN value     FORMAT a20;
SELECT *
  FROM v$nls_parameters
 WHERE parameter LIKE '%CHARACTERSET';
Run ... copy and paste here... (inside the tag [code])
Regards,


mson77


[edited ==> complement]
Michel Cadot asked.
What is your character set? database and nls_lang

and the reason follows:
S. Wolicki wrote:
NLS_CHARACTERSET is a database parameter that declares what character set encoding is used to store CHAR, VARCHAR2, LONG, and CLOB datatypes (including any SQL and PL/SQL source,which is internally stored and processed more or less as VARCHAR2).
This parameter can be changed only in limited circumstances.

NLS_LANG is a client-side parameter that declares the character set encoding of text that OCI gets from applications or sends to them as content of character bind/define variables or as [PL/]SQL statements to be executed by the DB server.
The NLS_LANG value can be overridden internally by OCI applications.

As most Oracle tools are OCI-based, NLS_LANG declares the character set encoding in which they work, display error messages, accept parameter files, etc.

NLS_LANG defines also language and territory conventions to be used by many Oracle client tools and by database sessions.

Both parameters are crucial for correct working of DB in internationalized environment. Changing one of them does not influence the other directly but it does influence the communication between client and server and the character set conversion that Oracle performs based on what it thinks an application wants.

[Updated on: Thu, 04 October 2007 08:22]

Report message to a moderator

Previous Topic: Kernal Parameters VS RAM in Intalling 10.2.0.1
Next Topic: Upgrade 9iR2 to 10gR2 on different platform
Goto Forum:
  


Current Time: Thu Dec 08 22:22:22 CST 2016

Total time taken to generate the page: 0.09060 seconds