Solution win7 64 pl / sql connection problem

2010-12-13  来源:本站原创  分类:Database  人气:115 

Solve the pl / sql connection problem:
1. To the official website to download oracle Oracle InstantClient, I was under instantclient-basiclite-win32-10.2.0.4.zip, unzip it to the
oracle product installation directory under the directory in which there is a 10.2.0. db_1/NETWORK/ADMIN directory in which the copy tnsnames.ora
InstantClient extract files to the directory.
2. Not logged into the PL / SQL developer, into the first option, set in the connection Oracle_Home and OCI Library, which
Oracle_Home set InstantClient decompression directory, OCI Library set to the directory oci.dll.
3. Finally, set the start PL / SQL developer's environment, PL / SQL developer to create a directory under the installation start.bat file, as follows:
@ Echo off
set path = E: \ develop \ oracle \ product \ instantclient_10_2
set ORACLE_HOME = E: \ develop \ oracle \ product \ instantclient_10_2
set TNS_ADMIN = E: \ develop \ oracle \ product \ instantclient_10_2
set NLS_LANG = AMERICAN_AMERICA.AL32UTF8
start plsqldev.exe
NLS_LANG first part of which must be AMERICAN_AMERICA, used in the latter part of the database character set. The red part of the oracle installation directory and then you can start start.bat

相关文章
  • Solution win7 64 pl / sql connection problem 2010-12-13

    Solve the pl / sql connection problem: 1. To the official website to download oracle Oracle InstantClient, I was under instantclient-basiclite-win32-10.2.0.4.zip, unzip it to the oracle product installation directory under the directory in which ther

  • Solve win7 64 位 pl / sql connection problem 2010-12-13

    Solve the pl / sql connection problem: 1 to oracle official website to download Oracle InstantClient, I was under the instantclient-basiclite-win32-10.2.0.4.zip, unzip it to the oracle product installation directory, under which there is a directory

  • 64位win7下pl/sql无法连接oracle解决方法 2014-06-30

    这篇文章主要介绍了64位win7下pl/sql无法连接oracle解决方法,需要的朋友可以参考下 1.pl/sql无法连接本机的oracle(ORA 12154:TNS:无法解析指定的连接标识符) 解决方法:pl/sql不能安装在Program Files(x86)文件夹下,要安装在Program Files文件夹下 2.pl/sql无法连接远程oracle(ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务) 解决方法:①在linux下找到oracle目录下的liste

  • PL SQL connection oracle (10g) database problem 2011-08-04

    windows7 PL SQL tool used to connect remote Oracle10g database, always pop up a small window, the white does not have any message, click "OK" and then back to the login screen, I see the network has a wireless connection there is a wired connect

  • window to use pl / sql login problem 2010-12-16

    Global database name, database name refers to the complete global database name such as orcl.zh.org sid is orcl zh.org is its domain The database is identified by its global database name. Global database name consists of two parts database_name.data

  • Solve win7 64-bit systems oracle connection problem 2011-08-26

    1 to oracle official website to download Oracle InstantClient, I was under the instantclient-basiclite-win32-10.2.0.4.zip, unzip it to the oracle product installation directory under the directory in which there is a 10.2.0. db_1/NETWORK/ADMIN direct

  • PL / SQL connection is not the solution to the problem 2011-05-31

    ORA-12170 TNS connect timeout Knowledge accumulated 2010-01-09 14:49:19 Read 815 Comments 0 Font Size: small subscription cmd-ipconfig/all see the IP address is changed. 1 Start Program ----- oracle ------ ---- configuration and migration tools -----

  • Win7 with PL / SQL DB connection blank message box when prompted 2011-08-11

    Right-click the icon and select Run as administrator you can. You can also right properties -> compatibility -> run as administrator will be selected.

  • On a uses pl / sql developer problem remotely connect to the database 2010-02-11

    Bahrain oracle10g today win2003 on after the server can connect to the database using plsql developer, but the client machine, but how are data connection closed, always reported or can not find what tns adapter error gradually getting better. One be

  • pl / sql developer of the character set problem 2010-12-15

    Today install pl / sql developer, connect remote database, the query results after the garbage. . . Resolved as follows: Create a file named "NLS_LANG" system environment variable, set its value "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and

  • Oracle Client PL / SQL Chinese garbled solution 2010-02-23

    Oracle Client PL / SQL Chinese garbled solution Keywords: database pl / sql developer field garbled English In the windows to create a named "NLS_LANG" system environment variable, set the value "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and

  • pl / sql, sqlplus, oracle failed to resolve can not connect 2011-05-30

    As the oracle service set to manual, every use, the need to start the service. Today, that connection is not started on (1) command line sqlplus, connect failed Tip: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

  • PL SQL Exception Handling 2010-03-23

    Exception Name ORACLE Error Description CURSOR_ALREADY_OPEN ORA-6511 attempting to open an already open cursor DUP_VAL_ON_INDEX ORA-0001 attempting to destroy the uniqueness of limit INVALID_CURSOR ORA-1001 attempting to use an invalid cursor INVALID

  • oracle instantclient basic + pl / sql installation and configuration 2010-06-24

    Using PL / SQL to connect Oracle, is the need to install the Oracle client software, oracle client personally think a little big, more consumption of resources. In fact, portable oracle provides us the tools: oracle instantclient package. Use this to

  • pl / sql developer of the character set issues 2010-12-15

    Today install pl / sql developer, connect the remote database, the query results after the garbled. . . Resolve as follows: Create a file named "NLS_LANG" the system environment variables, setting the value "SIMPLIFIED CHINESE_CHINA.ZHS16GB

  • PL / SQL tool to connect the remote ORALCE database approach 2010-08-24

    1, using ORACLE NET MANAGER tools 1) Open ORACLE NET MANAGER 2) increasing the "service name" NET service name first: fill out any The second step protocol: If the remote machine to connect ORACLE, select TCP / IP (internet protocol) The third s

  • Free installation of Oracle client to use PL / SQL Connect Oracle 2010-11-03

    We all know that, with the PL / SQL connection Oracle, is the need to install the Oracle client software. Are not to be thought not to install Oracle Oracle client connected directly to it? In fact, I always wanted to do this because the client was t

  • pl / sql to access remote database 2010-11-16

    / / Database configuration file directory E: \ oracle \ ora92 \ network \ admin \ tnsnames.ora (Database name) FWMSDB = (DESCRIPTION = (ADDRESS_LIST = server ip (ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.6.40) (PORT = 1521)) ) (CONNECT_DATA = (SERVICE

  • PL / SQL tool to connect to remote database approach ORALCE 2010-08-24

    1, the use of ORACLE NET MANAGER tools 1) Open ORACLE NET MANAGER 2) increasing the "service name" NET Services first name: fill in any The second step protocol: If the connection on the remote machine ORACLE, select TCP / IP (internet protocol)

  • pl / sql to access a remote database 2010-11-16

    / / Database configuration file directory E: \ oracle \ ora92 \ network \ admin \ tnsnames.ora (Database) FWMSDB = (DESCRIPTION = (ADDRESS_LIST = server ip (ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.6.40) (PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME