So how did you do the migration?
Did you change the character set of the database?
It may be better to raise this problem in the Database forum -
This forum is for migration from non-Oracle to Oracle databases.
Alternatively, raise it in whichever forum supports the product that is producing the PDF reports.
We follow the document "Export/import process for 12.0 or 12.1 using 11gR1 or 11gR2 (Doc ID 741818.1)"
And use the same script to create database as generated in Step 4.Generate target database instance creation script aucrdb.sql
Character set not changed, now next step is Upgrade database version from11gR1 to 11gR2. Can we change the character now and what will be the character set now? Is there any issue to change character set? Data loss / corruption?
Help us plz
'Database Version: 22.214.171.124' refers to 11g.
However your 'vi /opt/oracle/apps/tech_st/10.1.2/bin/reports.sh' refers to 10g.
Can you explain that?
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
SELECT * FROM NLS_DATABASE_PARAMETERS
What does this mean?
Mean the result of query SELECT * FROM NLS_DATABASE_PARAMETERS
and 11g database character set is AR8MSWIN1256
vi /opt/oracle/apps/tech_st/10.1.2/bin/reports.sh' refers to 10g. Oracle EBS R12 oracle home not a DB Oracle HOME
Hope you understand now.
So should they be the same?
Why are they different?
It for information to get the solution for PDF Reports problem that my Report out put is not showing in English there are some UN-readable characters in text.