Solution to ora-12899 errors in Oracle databases, oracleora-12899

Solution to ora-12899 errors in Oracle databases, oracleora-12899

ORACLE may cause various problems and errors, the ORA-12899 is a problem that occurred some time ago when I imported data to my local machine. but fortunately, this problem has been solved. Now let's share the solution;

ORA-12899 appears, is caused by character set, Chinese occupies 3 bytes in the UTF-8, ZHS16GBK occupies 2 bytes, and the source dmp file character set is ZHS16GBK inverted data, now you want to import to the library where the target character set is UTF-8, so a ORA-12899 appears
In fact, you only need to modify the ORACLE character set to solve this problem;

However, when I modified the character set, I found that I forgot the password of the sys account. This is a tragedy, so I had to change the password of the sys user first.

Changing the password is also divided into several situations. Let me list them one by one:

1. Forget the logon password of a user except SYS and SYSTEM.

Log On As a sys (or SYSTEM) user.

CONN SYS/PASS_WORD AS SYSDBA;

Use the following statement to modify the user password.

ALTER USER user_name IDENTIFIED BY newpass;

Note: The password cannot be full of numbers. It cannot start with a number. Otherwise: ORA-00988: Password missing or invalid

2. Forget the password of the SYS user or the SYSTEM user.

If you forget the password of the SYSTEM user, you can use the SYS user to log on. Then, use the alter user password command.

Change the password.

CONN SYS//PASS_WORD AS SYSDBA; ALTER USER SYSTEM IDENTIFIED BY newpass; 

If you forget the password of the SYS user, you can use the SYSTEM user to log on. Then, use the alter user password command.

Change the password.

CONN SYSTEM//PASS_WORD ; ALTER USER SYSTEM IDENTIFIED BY newpass; 

3. If the passwords of SYS and SYSTEM users are forgotten or lost.

This is particularly important.

You can use ORAPWD. EXE to change the password.

Start Menu-> Run-> enter 'cmd', open the Command Prompt window, and enter the following command:

orapwd file=D:/oracle/product/10.2.0/db_1/database/pwdctcsys.ora password=newpass 

This command re-generates the Database Password File. The password file is located in the ORACLE_HOME directory.
/Database directory.

This password is used to change the password of the sys user. The password of other users except sys and system will not change.

After the password is changed, you can change it as a dba. If it is not a dba, you will be prompted to have insufficient permissions when executing the modification command.

Start --> Run --> cmd, and then enter :"sqlplus sys/oracle@192.168.0.1/orcl as SYSDBA"

If you cannot enter the database normally, you need to manually enter the user name and password. after entering the database, the "SQL>" prompt will appear. Execute the following commands in sequence,

SQL>SHUTDOWN IMMEDIATESQL>STARTUP MOUNTSQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;SQL>ALTER DATABASE OPEN;SQL> ALTER DATABASE CHARACTER SET ZHS16GBK ;ALTER DATABASE CHARACTER SET ZHS16GBK*ERROR at line 1:ORA-12712: new character set must be a superset of old character set

The INTERNAL_USE command does not check the character set superset:

SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;SQL>SHUTDOWN IMMEDIATESQL>STARTUP

At this time, this ORA-12899 has been completely resolved, You can import data...

PS: I would like to add the following:What is the *. ora file used in oracle?

Why is there no *. ora file in 10 Gb?

Is *. ora in 9i equal to *. dbf in 10 Gb?

When creating a table<A href = 'http://www.eysky.cn 'target =' _ blank '> space </a>Hour

DATAFILE is used to specify the location and size of the data file. However, I have seen some articles using

*. Ora file, suchDATAFILE 'D:\\ORACLE\\ORADATA\\ORA92\\LUNTAN.ora' SIZE 5M , Some

Use the *. dbf file, as shown in figureDATAFILE 'D:\\ORACLE\\ORADATA\\ORA92\\LUNTAN.dbf' SIZE 5M .

The online statement is. dbf-data file,. tmp-temporary file,. log-redo log file,. ctl-Control file

. Ora-parameter file,. dat-Oracle System File

Only the file type is identified by the extension. For data files, either ora, dat, or dbf is the same and there is no difference. I personally think the same is true. I don't know what your comments are like?

Summary

The above is a small series to introduce you to Oracle Database ora-12899 error solution, hope to help everyone, if you have any questions please leave a message, small series will reply to you in a timely manner. Thank you very much for your support for the help House website!