Solutions to problems when installing database software

• When installing the Oracle database

Make sure that the Oracle installation directory cannot contain Chinese characters during installation.

(If the "loading Database Error areasqueries" error occurs during the first installation, it is generally because the Oracle installation directory contains Chinese characters)

1. Stop all Oracle services

2. delete the Oracle Installation Directory, which is mainly distributed in two places (such as the D disk and directory and the C disk program files). An error that cannot be deleted is prompted during deletion. Restart the machine and delete it again.

3. Delete contents in the Registry
HKEY_LOCAL_MACHINE/software deletes the Oracle directory
HKEY_LOCAL_MACHINE/system/CurrentControlSet/services key value starting with Oracle
Note: ensure that the Oracle installation directory cannot contain Chinese characters during installation.
If ArcSDE for Oracle is already installed, You cannot delete the key value with the ArcSDE keyword When deleting the Oracle key value. Otherwise, ArcSDE may fail to run.

When installing the SQL Server database

After you reinstall SQL Server2000, an error message is displayed when you install the database access component (MDAC:

SQL redist

Content: command line option syntax error. Type COMMAND /? For help.

Finally, I found the answer on the Microsoft Site. Yes:

This problem may occur if all the following conditions are true:

• You run the SQL Server 2000 sp3 setup. BAT file from a folder that contains double-byte character set (DBCS) characters in the folder name.

• An ODBC client program that uses the sqlsrv32.dll file is running on your computer.

The first point is that an error occurs if you put the installation file in a folder with dual-byte names. The Directory of the SQL Server2000 installation disk contains Chinese characters, and Chinese characters are so-called double bytes. Change the folder name to English and try again.