Methods of Plsql and Toad applied to oracle11g64 bit

Source: Internet
Author: User

Newly installed Win7 system 64-bit, and installed the oracle11g client, found before the installation can use the Plsql and Toad are not available. I searched a lot of information on the Internet, there are two articles written I followed the operation, my problem has been resolved

Plsql Reference: http://dehuang420-sina-com.iteye.com/blog/1566054

Toad Reference: http://blog.sina.com.cn/s/blog_51beaf0e010100cy.html

I will combine my own experience to summarize this:

Plsql Configuration

1)Download Instantclient-basic-win32-11.2.0.1.0.zip(Must be 32-bit, do not make the wrong version, the Oracle website is downloaded), unzip it to the Oracle installation directory under product (native named: instantclient_11_2): D:\Oracle\app\dd\product\ Instantclient_11_2.
Copy a directory under the root directory of the database installation D:\Oracle\app\dd\product\11.2.0\dbhome_1\NETWORK to the Oracle client directory D:\Oracle\app\dd\product\ Instantclient_11_2 (in fact only need Network\admin\tnsnames.ora)
2)Configuring PL/SQL Developer
Set the OCI library and Oracle_home in the perference->connection, for example, the local settings are:
Oracle home:d:\oracle\app\dd\product\instantclient_11_2
OCI Library:d:\oracle\app\dd\product\instantclient_11_2\oci.dll
3)Setting Environment Variables
For Nls_lang environment variables, it is best to set to the same as the database side, first query the character set information from the database side:
Sql> Select Userenv (' language ') Nls_lang from dual;
Nls_lang
----------------------------------------------------
Simplified Chinese_china. Zhs16gbk
Right-click My Computer-Properties-advanced-environment variables-system environment variables:
1> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";
2&GT: New environment variable "tns_admin" with a value of "D:\Oracle\app\dd\product\instantclient_11_2"
Finally click "OK" to exit.

4) Start PL/SQL Developer. I'm not sure how other people are, my database column can not automatically get the Tnsnames.ora inside the configured databases, but the manual input, after landing normal use.

Toad Configuration

Toad is 32-bit software, because the 64-bit Oracle can not call Oci.dll and error, use the following methods can be resolved.

1) Note: do not install in the default c:/program Files (x86) directory, or you will get an error because the path of this band () cannot be resolved

2) as the first step

3) as in the third step

4) Change the registry parameters

Run regedit to find the key value hkey_local_machine/software/oracle/key_oradb11g_home1, export it, and then modify it in UE, adding " Wow6432node, then import into the registry, and then modify 1,2,3 in the diagram



You can also modify it directly in the text editor, as follows:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\Software\wow6432node\oracle\key_oradb10g_client32]

"Oracle_home" = "e:\\oracle\\product\\10.1.0\\instantclient_10_2"

"Oracle_home_name" = "Oradb10g_client32"

"Oracle_group_name" = "oracle-oradb10g_home1"

"Nls_lang" = "Simplified Chinese_china. ZHS16GBK "

"Oracle_bundle_name" = "Enterprise"

"OLE DB" = "E:\\ORACLE\\PRODUCT\\10.1.0\\DB_1\\OLEDB\\MESG"

"Stmtcachesize" = "0"

"Oracle_sid" = "ORCL"

"Mshelp_tools" = "E:\\oracle\\product\\10.1.0\\db_1\\mshelp"

"SQLPath" = "E:\\oracle\\product\\10.1.0\\db_1\\dbs"

"Oracle_home_key" = "software\\oracle\\key_oradb10g_home1"

"Oracle_base" = "e:\\oracle\\product\\10.1.0"

"Rdbms_control" = "E:\\oracle\\product\\10.1.0\\db_1\\database"

"Rdbms_archive" = "e:\\oracle\\product\\10.1.0\\db_1\\database\\archive"

"Ora_orcl_autostart" =hex (2): 54,00,52,00,55,00,45,00,00,00

"Ora_orcl_shutdown" =hex (2): 54,00,52,00,55,00,45,00,00,00

"Ora_orcl_shutdowntype" =hex (2): 69,00,6d,00,6d,00,65,00,64,00,69,00,61,00,74,00,\

65,00,00,00

"Ora_orcl_shutdown_timeout" =hex (2): 39,00,30,00,00,00

5) Running Toad is also unable to select the database, but can be manually entered after the connection.

In the XP environment, it is estimated to encounter a lack of msvcr71.dll errors, directly from the Internet to download a system32 and decompression after the client directory. :

Http://www.bkill.com/download/msvcr71_dll-15567.html

Methods of Plsql and Toad applied to oracle11g64 bit

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.