Hi all!
This is my first posting since I registered oracle community.
Actually, I am working as junior IT developer and therefore I do not have lots of knowledge about IT technology.
I faced serious problem by changing NLS_CHARSET on my development server.
I was trying to preprocess dataset before doing analysis but I needed to change character set because of dataset's characteristic.
So I changed NLS_CHARSET with updating sql query on server and restart related services to apply.
Since then oracle server is not working. I tried to export dump file to protect data but not worked as well.
In conclusion, Every commands are not executed so I cannot change NLS_CHARACTSET anymore.
I googled to find out but I could not and the below list is what I did by googling.
1. Re-start server and services - worked but not resolved
2. unmount database - worked but not resolved
3. recover database - not worked(ORA-00911: invalid character)
4. open database - not worked(ORA-00911: invalid character)
5. edit registry key - worked but not resolved
6. Explore ORACLE_HOME directory to find config file which has NLS_CHARACTERSET information
What can I do without re-install oracle server? Hopefully, I want to edit the config If config file is existed.
If not existed, please let me know how to backup my database without using expdp command.
Thanks for reading and I am waiting for your valued feedback.
Have a good day!