PLS-00553- Character set not recogonized.

[gd_1976]

Our sever containining the datafile went down.
I restored the datafiles from the back-up.
Let me give all the details of m my Database
Environment Variables:
NLS_lang :AMerican_America.WE8ISO8859P1
Ora_NLS33 : Blank (This is what They told me to do from Metalink. It seems it is optimal when set to blank)


Database which I created:
NLS_lang :AMerican_America.US7ASCII

After restoring the database, There were couple of triggers missing, so I loaded and compiled it.
It gave PLS-00553 error (Character set not recogonized).

Now, I created one more user. Created the same table and compiled the trigger. It worked. There was no compilation errors.


My question is : The problem came into picture only after restoring it.
SO, is ther any way I can change the NLS_characterset to
WE8ISO8859P1 from US7ASCII so that I will not have any problems in future when I try to restore from the back-ups.

Please clarify me or ask me if you need more details.

This is urgent.

Thanks,

GD_1976.

[xyz2000]

check oracle docs.

http://otn.oracle.com/docs/products/.../ch3.htm#47136


ALTER DATABASE [] CHARACTER SET ;
ALTER DATABASE [] NATIONAL CHARACTER SET ;


The database name is optional. The character set name should be specified without quotes, for example:

ALTER DATABASE CHARACTER SET WE8ISO8859P1;


read the docs before you try it.

[gd_1976]

HI XYZ,
Thanks for your suggestion.
I have a question for you.

My current character set: US7ascii
I can change it toWE8ISO8859P1 by issuing the
ALTER DATABASE CHARACTER SET WE8ISO8859P1;
Right.

Suppose, this are the steps. I take

1. shut down.
2. Take backuo.
3. Startup mount.
4. Issue the ALter statement.
5. Open the database.
6. Shutdown
7. Take the backup.

Suppose, the alter statement is causing some problems. Can I change the character set to US7ASCII and restore it form BACKUP # 1.

Will the database work?

Thanks,

GD_1976.

[xyz2000]

What kind backup do you use?

raman or os backup.

If you use operation system cold backup. I think you should be fine(NO GUI TOOLS). But if you use rman backup, you may have to set up your env
NLS_lang to AMerican_America.US7ASCII .
My work mostly on unix. All backup/recover is done on ksh scripts. No GUI tools. If you use GUI tools and works on NT, then I am not sure what will happen.

[gd_1976]

HI XYZ,
Thanks for your prompt suggestions.
I am going to take cold backup.
Furthermore, the problem I faced because of using GUI tool while taking the backup.
i Didn't change the NLS_lang to US7ascii while takling the backup.

Now, I will do that.

Thanks again.

GD_1976.