| MIGRATION FAIL [message #271908] |
Wed, 03 October 2007 06:20  |
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 #272089 is a reply to message #271948] |
Thu, 04 October 2007 00:30  |
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 #272286 is a reply to message #272113] |
Thu, 04 October 2007 07:53 |
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';
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
