Oracle beginners often encounter problems

Oracle beginners often encounter problems

1. Problem description:
BadImageFormatException is thrown when you try to load the Oracle client library. This problem occurs when the 32-bit Oracle client component is installed in 64-Bit mode.

Solution:
This is mainly because of the version of the installed Oracle client, which has 32-bit and 64-bit versions. If our VS project is 32bit (x86 Platform), then our Oracle client will correspond to 32bit. If the VS project is 64bit, We will correspond to 64bit clients.
Solution 1:
Change the target platform for VS project generation to Any CPU (Project attribute --> Generate --> Target Platform)
Solution 2:
Check whether the DLL referenced by your project is compiled on the x86 platform.
====================================
2. Problem description:
The INS-13001 environment does not meet the minimum requirements when installing oracle11g for win10 Systems

Cause:
I do not know the specific reason
Solution:
After upgrading the win10 system, you need to re-install Oracle, because when installing Oralce11g, There will be various incompatibility issues when using 64-bit, each time I install a 32-bit database.
After clicking setup.exe during installation, the following error occurs: The [INS-13001] environment does not meet the minimum requirements.
Open the decompressed database folder, find the stage, cvu, find the cvu_prereq.xml file, open it in notepad, and add content.
<OPERATING_SYSTEM RELEASE = "6.2">
<Version value = "3"/>
<Architecture value = "32-bit"/>
<Name value = "Windows 10"/>
<ENV_VAR_LIST>
<ENV_VAR NAME = "PATH" MAX_LENGTH = "1023"/>
</ENV_VAR_LIST>
</OPERATING_SYSTEM>
The main difference between this section and above is 6.2 and window10.
If you have installed 64-bit, you can change 32-bit to 64-bit! Save the changes. The error message is not displayed after you click setup.exe!
====================================
3. Problem Description
TNS: The Protocol configuration is incorrect (the specific description of the problem is not clear, which roughly means this)
ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor
Cause:
There are roughly three reasons for searching on the Internet: 1. Listening service not started 2. database instance service not started 3)

Solution:
First, check whether the listening service xxxxxxListener (the service suffix is Listener) is started normally.
Check whether the database instance service OracleServiceXXXX (XXXX is SID name) is started properly.
Check whether there is any ORACLE_SID field in the environment variable. If not, add the environment variable ORACLE_SID = XXXX (XXXX is your database SID), or you can add it in the registry, as I did not remember where to add it, you can search it online.
References: https://yq.aliyun.com/articles/33400
====================================
4. Problem Description
ORA-12631-UserName-retrival-failed (ora 12631 user name retrieval failed)
Cause:
Http://www.dbasupport.com/forums/showthread.php? 22246-ORA-12631-UserName-retrival-failed
It may be caused by the login authentication method of Oracle. Because TNS authentication is used by default, it is generally necessary to use the Local User account for installation. If it is a Domain User (Domain User account), you cannot log on for verification.

Solution:
Change the sqlnet. ora file in the Oracle main directory
SQLNET. AUTHENTICATION_SERVICES = (TNS)
Is
SQLNET. AUTHENTICATION_SERVICES = (NONE)
Search Keyword: ora 12631 Username retrieval failed