An Oracle database startup issue that results from the loss of registry entries in the Windows registry.

Source: Internet
Author: User
Tags sqlplus

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.