◎筱米加步枪◎.Blog

Happy coding

64位Windows7下安装Oralce10g客户端过程.

筱米加步枪 posted @ 2011年3月01日 09:54 in [ 数据库 ] with tags 64位 oracle Windows7 , 4283 阅读

本想尝试在不安装客户端的情况下使用PLSQL访问数据库服务器 .但是后来还是失败了.

于是在Windows7(64位)下安装了Oracle10g的客户端后,使用PLSQL尝试连接,总提示一个空白框.很无奈.百度谷歌了许久才找到解决方法.

摘自网上的:

1.到oracle官网下载Oracle InstantClient,我下的是instantclient-basiclite-win32-10.2.0.4.zip,把它解压缩到oracle安装目录product下,其中还有一个目录为10.2.0.在其中的db_1/NETWORK/ADMIN目录下拷贝tnsnames.ora文件到InstantClient解压目录.
2.非登录状态下进入PL/SQL developer,进入首选项,在connection中设置Oracle_Home和OCI Library,其中Oracle_Home设置为InstantClient的解压目录,OCI Library设置为该目录下的oci.dll.

最后设置环境变量:

set path=instantclient的路径
set TNS_ADMIN=tnsnames.ora文件的目录

使用PLSQL尝试登录,成功.

PS:如果出现ORA-12705:无法访问NLS数据文件,或者指定的环境无效错误,把环境变量中NLS_LANG的变量删除掉

KVS Question Paper 说:
2022年9月29日 01:40

KVS Sample Paper 2023 Pdf Download for Kendriya Vidyalaya Sangathan Class 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 & 12 Arts, KVS Question Paper Science & Commerce Stream Practice Paper Suggestions with Past years old exam Solved Question Bank for all Regional Students of English Medium, Hindi Medium & Urdu Medium Studying in KVS Schools across the Country. All the Kendriya Vidyalaya Sangathan Board Students can download the Sample Paper Suggestions with Model Papers along with Previous Years old Exam Solved Question Bank for all Languages & Subjects of the Course.

whatsapp fotos aus s 说:
2023年7月25日 04:52

Der Download des WhatsApp-Status ist über die Tools oder Anwendungen auf Ihrem Smartphone möglich. Sie benötigen keine Drittanbieteranwendung, um WhatsApp-Statusvideos oder -bilder auf Ihrem Android oder iPhone zu speichern. whatsapp fotos aus status speichern Aber die Drittanbieter-App wird verwendet, um den WhatsApp-Status einfach herunterzuladen. WhatsApp-Storys Statusinformationen Fotos oder Videos auf dem Telefon. Aber beide werden innerhalb von 24 Stunden gelöscht. Sie können sie also aus einem anderen Ordner kopieren und an einem sicheren Ort speichern.

SEBA 9th Class Boo 说:
2023年7月27日 00:21

SEBA Follows CBSE Curriculum These Textbooks are Updated as per the Syllabus Prescribed by Assam Board. Students of Assam Class Should follow Prescribed Textbooks while Preparing for Exam. Our Team Refer to the Respective Subject Textbook while Preparing the Final Important questions. Students Best Practice Study Materiel about Assam 9th Textbooks 2024 are the Fact that they are so Comprehensible that SEBA 9th Class Books 2024 it does not require the aid of a Subject Literate.Board of Secondary Education, Assam commonly known as SEBA Regular organization High School Education, Assam State Textbook Production and Publication Corporation


登录 *


loading captcha image...
(输入验证码)
or Ctrl+Enter