Alter database.....

Hello,
I am having problems with my Oracle 8.1.7
I do not obtain more to go up the database for the following:  a time behind was given to one update in table NLS_DATABASE_PARAMETERS changing character set for a not recognized value for the ORACLE, today, when the database needed to be restarted gave the following error to me:  
Ora-12701:  CREATE DATABASE to character set is not known
Try to make the following :  
SHUTDOWN IMMEDIATE;  
STARTUP MOUNT;  
ALTER SYSTEM ENABLE RESTRICTED SESSION;  
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;  
ALTER DATABASE OPEN and again gave the error above (Ora-12701) with this does not obtain to execute ALTER DATABASE CHARACTER SET WEISO8859P1 without the DATABASE to be open.  
You knows what I can make?

Please help me!!!


Thanks,
Eduardo Mariano Pinto - from Brazil
eduardomarianoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kalosiCommented:
You should check the database charset in the controlfile. Try to export your control file with this command

alter database backup controlfile to trace;

a file should be created in your user_dump_dest directory. post the character set from the controlfile please.

david
baonguyen1Commented:
You can change character set and national characeter set by

ALTER DATABASE [<db_name>] CHARACTER SET <new_character_set>    
ALTER DATABASE [<db_name>] NATIONAL CHARACTER SET <new_NCHAR_character_set>  

However, this does not change the actual character codes, it only changes the character set declaration.

I think you can not change the above parameters by updating NLS_DATABASE_PARAMETERS  table. THis table  is used to store the NLS parameters that were used when the database was created.

Have you tried with kalosi advise ? I think you have to create a new database with a correct character set and restore from the latest backup.

If anyone has other ideas please advise.
Helena Markováprogrammer-analystCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ/Refund.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
SpazMODicCommented:
PAQed, with points refunded (50)

SpazMODic
EE Moderator

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.