I am a db beginner. I want to practice sqlplus on my computer(Vista). I thought I can install sqlplus without Oracle on my computer. I downloaded sqlplus the basic and instant client packages. Then I unzip them to c:\instantclient and run sqlplus, then tried to login sqlplus but failed for ORA-12560: TNS:protocol adapter error. I searched help from google and created tnsnames.ora following your advise but was not able to catch every detail. Here is the sqlplus zip files and the unzip directory on my computer. I have cygwin on my computer, here is the log I entered from my xterm prompt:
Nancy@Nancy-PC /cygdrive/c/instantclient/instantclient_11_1$ echo $TNS_ADMINC:\instantclient\instantclient_11_1Nancy@Nancy-PC /cygdrive/c/instantclient/instantclient_11_1$ echo $ORACLE_SIDorclNancy@Nancy-PC /cygdrive/c/instantclient/instantclient_11_1$ echo $ORACLE_HOME/cygdrive/c/product/11.1.0/bin
Instantclient Basic Win32 11.1 0.6 0 Zip
Installing OCI8 with Instant Client on WindowsAfter installing the Apache HTTP Server, you can install Oracle Instant Client and configure PHP toconnect to a remote Oracle database.To install:1. Download the Instant Client Basic package for Windows from the Instant Client page on the OracleTechnology Network: ... lient.htmlThe Windows 32 bit ZIP file is called instantclient-basic-win32-11.1.0.6.0.zip and is around 42 MB insize.If you need to connect to Oracle 8i, then install the Oracle 10g Instant Client.On some Windows installations, to use Oracle 10g Instant Client you may need to locate a copy ofmsvcr71.dll and put it in your PATH.2. Create a new directory (for example, C:\instantclient_11_1). Unzip the downloaded file into the newdirectory.3. Edit the Windows environment and add the location of the Oracle Instant Client files,C:\instantclient_11_1, to the PATH environment variable, before any other Oracle directories. Forexample, on Windows XP, use Start > Settings > Control Panel > System > Advanced > EnvironmentVariables, and edit PATH in the System Variables list.If you are using a tnsnames.ora file to define Oracle Net connect names (database aliases), copy thetnsnames.ora file to C:\instantclient_11_1, and set the user environment variable TNS_ADMIN toC:\instantclient_11_1.Set any other required Oracle globalization language environment variables, such as NLS_LANG. Ifnothing is set, the default local environment is used. See the Globalization chapter, for moreinformation on globalization with PHP and Oracle.Unset any Oracle environment variables that are not required, such as ORACLE_HOME andORACLE_SID.4. Install PHP following the steps in the previous section, Installing OCI8 Using a Local Database onWindows.
Распаковываем instantclient-basic-win32-10.2.0.4.zip в нужное место, в моем случае это C:\Program Files\Oracle\instantclient_10_2 (этот путь будет везде использоваться дальше по тексту, так что заменяйте на свой).
Распаковываем instantclient-odbc-win32-10.2.0.4.zip в нужное место, в моем случае это C:\Program Files\Oracle\instantclient_10_2 и запускаем оттуда odbc_install.exe
2ff7e9595c
Comments