An Oracle database startup issue that results from the loss of registry entries in the Windows registry.
Environment Description:
1.windows 2008 Operating System X64bit
2.Oracle Database 11.2.0.1 32bit
3.sqlplus/as sysdba not go in, error:
C:\user\administrator>sqlplus/as sysdbaerror 6 initializing sql*plusmessage file SP1<LANG>.MSB not Foundsp2-0750:you need to set Oracle_home to your ORACLE software directory
Episode:
Perhaps some people will ask: Sqlplus can't enter, how do you conclude that this Oracle database is 32bit, I use the following method to determine:
Enter into the Bdump, open a TRC, in the TRC file in front of a few lines can be seen.
Checked Discovery: Missing registry entries as below
Hkey_local_machine\software\wow6432node\oracle
So:
I am in my win 7 64bit environment, installed the Oracle database 11.2.0.1 32bit Server Software, and then the win 7 in the hkey_local_machine\software\ Wow6432node\oracle export, import in the Windows x64bit environment, then sqlplus/as SYSDBA can enter smoothly.
Maybe someone asked:
Hkey_local_machine\software\wow6432node\oracle---> Is this? Hkey_local_machine\software\oracle----> Why not this one?
Because this is 32bit, Oracle database Server software is installed on x64bit windows.
Additional Instructions:
1. The number of bits in the Oracle Database Server software must match the number of bits in the OS: either 32bit or X64bit, otherwise Oracle support is not supported. (Oracle does not support and can install, and can be used, is two concepts)
2. The number of bits in the Oracle Database Client Software may not match the number of OS bits.
An Oracle database startup issue that results from the loss of registry entries in the Windows registry.