I installed the database first, and there was no problem when debugging it with net. However, after generating the website, when connecting to the database, it prompted that the client version was too low (that’s what it meant). Then I installed a 9i client, and then I changed the relevant The service was changed to manual, and N days later it was discovered that the database could not start normally.
Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory.
The methods on the Internet for modifying oracle_home do not work.
So I uninstalled the client, and after restarting I found that Oracle was completely unusable. When I was about to uninstall, I found that Oracle prompted that there were no installed products.
The root cause of the error is that some information is added to the registry when installing the thin client or server.
1 There will be no problem when installing the thin client first and then the server, but the thin client no longer works at this time. All tnsnames are based on the path where the server is installed.
2 But it will be wrong to reverse the order, especially when the clients are not in the same directory (the streamlined client is usually in the oracle directory under the root directory of the system disk). Because the registry information has changed at this time. HKEY_LOCAL_MANCHINESOFTWAREORACLE, this directory entry will be deleted when you uninstall the thin client.
Solution 2: Just add or modify the above-mentioned relevant entries in the registry to the directory on the Oracle server.
This article comes from the CSDN blog. Please indicate the source when reprinting: http://blog.csdn.net/mzwang123/archive/2009/12/22/5053497.aspx