• Oracle 10g Software Download For Window…
• Oracle 10g Client Download

Sometimes basic things like installing the latest Oracle instantclient on the PCs of all of your developers can take considerable time. I typically setup a dedicated DBA Portal website wherever I work and then write up instructions for repetitive things like these. It’s all about – do it once and forget it. Here’s the copy of the writeup I did to install the latest 11g Oracle instantclient basic and instantclient sqlplus on win32: Download Software Go to Instant Client Downloads for Microsoft Windows (32-bit) download page: And download basic-win32 and sqlplus-win32 files to your PC (for example):. instantclient-basic-win32-11.1.0.7.0.zip. instantclient-sqlplus-win32-11.1.0.7.0.zip Create Oracle Directory Create a C: oracle directory on your C drive (if you don’t already have one) and move both files into C: oracle.

Hi Vitaliy Mogilevskiy, I am really grateful to this post. I don’t know anything about oracle.but i need to setup this instant client on my pc because i need to practice the sql plus commands as a student. I tried to create a tnsnames.ora file but when i try to run the sqlplus it gives an error: C: Documents and Settings Udit Parmarcd c: sq cl C: sq clsqlplus scott/tiger@UDIT SQL.Plus: Release 11.1.0.7.0 – Production on Thu Oct 8 21: Copyright (c) 1982, 2008, Oracle. All rights reserved. Udit, in simple terms, the purpose of Oracle Client is to connect you to the Oracle database using SQL.Net. On the Oracle database node (server) there’s a special program running called Oracle Listener.

The listener typically listens for incoming requests on PORT=1521, but a DBA can set it to anything. The error “ORA-12541: TNS:no listener” just tells you that there’s no Oracle listener running on server with IP address 192.168.1.2.

Also, you don’t need to configure the load balancing / fail-over parameters if you are connecting to a single/non-RAC database node. Here’s a simpler TNS alias that you can use (example): MYALIAS = (DESCRIPTION = (ADDRESSLIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dbnode.mydomain.com)(PORT = 1521)) ) (CONNECTDATA = (SERVICENAME = SERVICENAME.mydomain.com) ) ) To connect to remote database you need to know three pieces of information (get them from the DBA that is responsible for the remote database you are connecting to): 1. Db-host-name 2. Db-SERVICENAME You then construct the following TNS alias and store it in your tnsnames.ora: MYTNSALIAS = (DESCRIPTION = (ADDRESSLIST = (ADDRESS = (PROTOCOL = TCP)(HOST = db-host-name)(PORT = db-port)) ) (CONNECTDATA = (SERVICENAME = db-SERVICENAME) ) ) Once you have above information do this: 1. Open CMD and echo out TNSADMIN like this: Microsoft Windows XP Version 5.1.2600 (C) Copyright 1985-2001 Microsoft Corp. C: Documents and Settings usernameecho%TNSADMIN% C: oracle instantclient111 C: Documents and Settings usernamecd C: oracle instantclient111 C: oracle instantclient111notepad tnsnames.ora 2. Go to the directory returned by step# 1 and edit tnsnames.ora enter the TNS-alias you constructed (See above) and save the file.

Get correct username/password from DBA and try to connect: sqlplus username/password@MYTNSALIAS -HTH – Vitaliy. Hi Vitaliy, I now know how to make a tnsnames.ora file but the problem is that.i want to use this instant client not to connect to any remote database or something.and there is no one like Database Administrator here from whom i can get a username or password.i am using this instant client locally to practice sql plus commands as a student. Then what should i write in the “db-hostname” and “db-SERVICENAME”? And what username and password should i use? Thank you very much to explain the tnsnames.ora file clearly. 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.

Nancy, FYI: you don’t need Oracle Instant Client if you are installing Oracle Server software because full Oracle Client and sqlplus are part of the Oracle Server distro. It doesn’t hurt installing instant client but it’s not necessary. Also you should change your PATH variable to include the server’s ORACLEHOME directory before instant client’s. If you got Oracle Server installed and have selected to have your database created during installation then you should be able to login to ORACLE using sqlplus even if you don’t know the password (make sure your ORACLESID is setup, then: sqlplus /nolog connect / as sysdba That should get you in. You can then change your password using the following command alter user system identified by mynewpassword; PS: In 11g passwords are case sensitive by default. HTH, – Vitaliy. Nancy, That’s for Win 2008 Server 64bit Don’t’ you have Vista?

Is it 32 or 64 bit? The 32bit version win3211gR1database1013.zip would be in here — And as I mentioned to Udit, if you want to learn Oracle take the effort and install Linux workstation, then install the latest 11gR2 for Linux.

Why bother with 11gR1 if there’s 11gR2 out? Besides, Oracle on Linux is what you’d be mostly running these days in a real Data Center so why bother with Windows? DBA/admin stuff is very different (scripting etc.). Make you time count and get 64bit Linux installed (not that hard and it’s free from ) then get Oracle 11gR2 —! HTH, – Vitaliy. I have cygwin and maintaining some perl scripts for file management work. If I install Linux, will that break my cygwin stuff?

If not, I do hope to install Linux. Also I don’t know if mine Vista 32 bit or 64 bit, how I can tell? I just randomly chose 11R1. I was able to login to sqlplus but got error to connect and I can’t change password either: $ sqlplus /nolog SQL.Plus: Release 11.1.0.7.0 – Production on Mon Oct 12 15: Copyright (c) 1982, 2008, Oracle.

All rights reserved. SQL desc dual; SP2-0640: Not connected SP2-0641: “DESCRIBE” requires connection to server SQL alter user system identified by ‘nancy’; SP2-0640: Not connected SQL What is missing? My major goal is to practice as a developer but not DBA yet.

Thanks Nancy Yuan. Vitaliy, I installed 11gR1 Oracle Server software on my Vista. I still can’t login to sqlplus as SYSTEM directly but I followed your advise login ‘sqlplus /nolog’ and then ‘connect / as sysdba’ at the sql prompt. I finally got connected. $ sqlplus /nolog SQL.Plus: Release 11.1.0.7.0 – Production on Sat Oct 17 12: Copyright (c) 1982, 2008, Oracle. All rights reserved.

SQL connect / as sysdba Connected. SQL desc dual; Name Null? Type —————————————– ——– —————————- DUMMY VARCHAR2(1) SQL Thank you very much again for helping me the issue. Nancy, Once you are connect “as sysdba” you can do anything. You can for instance change SYSTEM password using the following command: alter user system identified by newpassword; connect system/newpassword If you want to learn Oracle get in the habit of using a non-privileged schema (do not use system).

Ok thanks, here’s more detail on my problem. We need to test our apps on 11g. We need to be compliant by 2010 on 11g.

Looking at the oracle site, I saw 11gR2 is out but only on linux. So I decided to go for it and install it on linux. But now, there is no 11gR2 client on windows and our apps run on windows and are doing OLE, ODBC, EXP and IMP work. So do I still go ahead with my plan and start testing with 11gR1 client on windows connected to 11gR2 server? If I test on 11gR1 server and client, will I need to test everything again on R2? Hum life simple pleasures. Hi Vitaliy Mogilevskiy, i am new in oracle i try to connect a remote oracle database followed by your tutorial.but when i run sqlplus in cmd the following error was given C: Documents and Settings USERsqlplus./.@TNSALIAS Error 6 initializing SQL.Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLEHOME to your Oracle software directory when i try with vs2008 through oracle client the following error was given: ora-12170 TNS:Connect Timeout occurred.

Pls help me thaks in advance. Hi, Vitaliy Mogilevskiy The following error was given when i try to connect through Microsoft odbc datasource in visual studio 2008. ERROR NA000 MicrosoftODBC driver for OracleOracleORA-12504: TNS:listener was not given the SERVICE NMAME in CONNECT.DATA ERROR IM006 MicrosoftODBC Driver Manager Drivers SQLSetConnectAttr failed ERROR 01000 Microsoft ODBC Driver Manager The driver doesn’t support the version of ODBC behavior that the application requested (see SOLSetEnvAttr). Simon, There are two scripts provided by Oracle called dbstart/dbshut. On Linux these scripts read /etc/oratab file where you specify which SID:ORACLEHOME should be automatically started or shutdown. You can incorporate dbstart/dbshut into a script which you’ll place into /etc/init.d/ (RedHat/OEL Linux).

Typically you’ll call it /etc/init.d/dbora This script should be able to process stop start restart parameters. Once that’s done you register the script with Linux services using chkconfig –add dbora, that will create /etc/rc.d/S99dbora and /etc/rc.d/K10dbora files which will be called at appropriate run levels, effectively stopping and starting the database for you. For more details please refer to the following Metalink Document: How to Configure a Linux x86 Box for Oracle DB Auto Start / Shutdown ID 281912.1 HTH, – Vitaliy. Bikash, The error “Error 6 initializing SQL.Plus Message file sp1.msb not found SP2-0750: You may need to set ORACLEHOME to your Oracle software directory” probably indicates that you have an erroneous ORACLEHOME variable set on your PC. You can check using the following command (from cmd): echo%ORACLEHOME% If the above command returns a directory to your “old” ORACLE Software you should remove this variable from your system, then restart cmd and try sqlplus once again. PS: your ODBC issues with ORA-12504 error is most likely caused by an incorrect TNS alias specification, make sure to get correct TNS alias from your DBA.

HTH, – Vitaliy. Thanks for the great post. I had previously installed 11GR2 server on Linux 64, and needed to get windows client working.

I followed your instructions, and it worked like a champ. Only issue I have now is that I am able to login with sqlplus as long as I am in the C: oracle instantclient111. This is where I put my tnsnames.ora file. However if I start sqlplus while in another directory, it times out and reprompts me to connect. It seems not to find tnsnames.ora. Is there an environment variable I am missing?

Thanks again for a great post – very helpful. 11g related question Since I installed my 11gR2 server on linux, I figured I could use this server (11g) to backup (exp) schema of my other servers (10g and 9i).

But I quickly found that doing an EXP (11g client) of a 10g schema does not work. I get and ORA-00008 followed by ORA-00904. According to many on the web, this is normal when the EXP version does not match the server version. I assumed and hoped that would work, since the EXP 11g client is of higher version. I would like to be able to centrally do all my EXP from one server. Any way around this or suggestion on how to EXP schemas from 9i, 10g, 11g on one “backup” server? Thanks, Simon.

@Simon RMAN is meant to be used as a server side tool because in a real life-cycle of a database server (not in a lab) the software stacks will have many variations (patch-levels) from one node to the other. You should be using the RMAN utility right out of the same ORACLEHOME that the ORACLE server is running out of. What you want to centralize is your RMAN scripts and RMAN backup-set destination — not the actual RMAN utility. Good way of doing that is using NAS storage — put your RMAN scripts and RMAN backup sets on the NAS but run the actual backups from each individual ORACLE server node so you are using RMAN utility from the local ORACLEHOME.

@Simon – Place each schema into a separate TABLESPACE then backup the whole database. – Have a recovery instance setup for each of your databases — you need to have that anyway to test your recovery procedure. If you ever have to recover a schema because someone dropped a table/pkg etc. Recover the database on the recovery instance and get what you need from there.

Don’t rely on EXP/IMP to protect your data. For 10g and above look into flashback features.

This should take care of your schema based recoveries 100%. Hi Vitaliy, sqlplus on instantclient is working now. But as you said, i checked all the paths and tnsnames.ora,everything was fine.only problem i found was tnsnames.ora file was by mistake saved with hidden.txt extension.I changed it and sqlplus started working.

But what i don’t understand is how did my web-based sqlplus(isqlplus ) was working before with that file. If am not wrong will islplus doesn’t depend on same parameters as sqlplus to work from client pc? What exactly is the difference between sqlplus and isqlplus? Thank you very much.your suggestion made me look again into those files. I have a quick oracle question for you. I just installed oracle 11g on my desktop and would like to get access to it remotely from the outside. The problem that I am having is that apparently port 1521 is always closed from the outside.

From the inside I can do everything fine but the minute I try to get access to it from the outside it says that it cannot find a tns listener. I have turned off my windows xp firewall and have also eliminated my router by connecting my machine directly to the DSL line. The listener is up and running when I use netstat; however, it seems to be blocked at the oracle application and not the operating system level. I would appreciate any insights into this. @troy If you can connect to your 1521 port from local network (from another machine) but cannot from external network then it’s blocked at the network layer. Hi Vitaliy, I followed your tutorial above and everything went well up to the point of connecting to the remote database.

If I don’t use the “sqlplus user/pass@servicename” I get the “TNS-12560: TNS:protocol adapter error”. When I use “sqlplus user/pass@servicename” I get the “ORA-12170: TNS:Connect timeout occurred”. Now I just gor the “ORA-12154: TNS:could not resolve the connect identifier specified” using the same credentials as above. I do not have the sqlnet.ora defined. Do I need it?

I only have the tnsnames.ora. On a side note, I am able to connect to the database using the SQL Developer tool on the same machine. Please advise. Thanks in advance, Andrei.

Hi Vitaliy, I have oracle client 11.1.0.6 installed in my local pc.when i try to connect to remote server, sometimes connection fails with ORA-12545 connection failed as target or host doesn’t exist. Its not same always, it works sometimes if i keep trying to connect. My database am trying connect remotely is 11.1.0.7 and my client is 11.1.0.6.Will that be an issue? I checked all other parameters as per metalink, like locallistener, remote listenere and the tns entires.

Everything looks fine. Please help in solving this issue. Hello, I have followed the steps which you have given above and i reached the point where I use the command ‘sqlplus’ in the cmd. But the problem is, that when I execute it I receive the following message: ‘sqlplus’ is not recognized as an internal and external command,operable programme, or batch file. I am using Windows 7, 64bits and from the oracle site I have downloaded the corresponding versions of the sqlDeveloper,Java and InstantClient BASIC & sqlplus. As your article is for 32 bit OS, and mine is 64, do you think that this might be the problem or not?

In both cases, what do you suggest me to do? Thanks in advance I would really appreciate your help! @anony I’d suggest to startup sqlplus without login and then issue these commands: sqlplus /nolog whenever oserror exit failure whenever sqlerror exit failure connect YOURCONNECTSTRING @/dev/ora.pipe This will ensure that when there’s an error sqlplus will exit and give you a status 0; and you can then check for the exit code in the outer script: if $? -gt 0; then restartsqlplus fi One thing you have to watch-out for is TCP/IP Timeout which can be substantial issue that can “hang up” your sqlplus call for a while (depends on network configuration on the database server). Dear MVE Great page, not everyone is willing to share their knowledge these days!

I have installed an oracle server in my laptop and configured name alias and listener.I’m trying to connect to it via another laptop in a wireless home network. I know I,m suppose to create a tnsnames.ora on the client machine. I downloaded the instant client, but their is no oracle product path on my non server laptop to set the path to. Basically i want to connect to a server via a computer with no oracle products installed.

I’m sure I,m missing something obviously stupid!!! I can get the tnsnames from the server and configure it, but cant install sqlplus!! Regards Amir. Hi and thanks for a nice article that helped me a lot. I ran into one problem using your approach tho, and that was that you say to “add a User variable” for TNSADMIN.

This does not work if you say have a web site running on the NETWORK SERVICE account, because you cannot log on to the account and add user variables. Adding all the variables as System Variables solves the problem.

Oracle 10g Software Download For Window…

Took me a while to figure out, but now it works. Also I added variables for “ORAHOME” and “ORACLEHOME” pointing to the same folder as the TNSADMIN variable. Not sure if it is required. Again, thanks! Keep up the good work.

Hello MVE, I facing a problem. I hope you could help me out. Situation is, I have two different network. One is Class B type and other is Class C network.

I am running an Asp.net web server in B and Oracle database server in C. I have configured oracle instant client in my asp.net web server(B) with editing path variable.

The Problem is Oracle database server(C) is in Linux platform and can not pingable from B network. But I need access the database. I’ve installed Oracle client in a windows PC in C network that is pingable from B network. Now question is, is it feasible to deploy this kind of architecture?

Note: I’m getting tns:connection time out message while trying to connect oracle client in C network. Hi Vitaly can you help me. The context is Windows Vista – 10.0.0.109 – Instantclient 11gr2 Windows 2000 – 10.0.0.204 – Oracle Database 9i tnsnames.ora is in instantclient112 directory: ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.109)(PORT = 1521)) (CONNECTDATA = (SERVER = DEDICATED) (SERVICENAME = orcl) ) ) I have created a data source name and tested it successfuly but when I create a link to this db in Microsoft Access using this dsn, i get message “ODBC call failed ORA-12541 TNS NoListener”. Database and listener are started on the server side. Note that I can connect to the database via sqlplus: sqlplus hr/hr@orcl Thanks. I’m running on a Windows Server 2008 R2.

I’ve downloaded Version 11.2.0.2.0 of Instant Client Basic, Instant Client Package – SQL.Plus, and Instant Client Package – ODBC. Following your (excellent) instructions I was able to successfully connect to my Oracle 9i database using SQL.Plus. I have some old “Classic ASP” code that needs to connect to this same Oracle 9i DB. On my old NT server I was able to use Microsoft’s MSDAORA provider. This provider is no longer supported and not supplied with Win28k R2 server.

Oracle 10g Client Download

So, I need a provider to use. I tried OraOLEDB but get the message “Provider cannot be found”. Also I don’t see any Oracle drivers listed in the Windows ODBC Data Source Administrator. I had hoped that installing the Instant Client would have actually installed a provider/driver.

Would prefer OLEDB but ODBC will work. I assume there’s something I haven’t yet done. Hello Vitaly, Im working as an IT Professional in an org. I had to install oracle 10g client for win7 64 bit.I have installed administrator console one tat machine.everything was done perfectly and we got tns names folder also. In the below line ADDRESS = (PROTOCOL = TCP)(HOST = QABLR)(PORT = 1521)) instead of QABLR for host we are givin an ip address and wen we try to save it, it throws an error which says something something ending with access denied.

The employee has admin access to the system and we have made everything fine but the prob stil exists. Can you please suggest me on this.and is dis info enough for you to come to an understanding about my issue?? Please help Regards, Sreekar. Hi, I have done the below steps but still getting the error “ORA-12154: TNS:could not resolve the connect identifier specified”.

I’m trying to connect using “PL/SQL Developer” software. Can anybody please suggest me what more settings do I need to check?? Thanks a lot for your response. I have downloaded instant client “instantclient-basic-nt-11.2.0.3.0.zip” and unzipped it. The folder paths are now: “C: oracle instantclient-basic-nt-11.2.0.3.0 instantclient112” 2. Set the TNSADMIN system variable to point to the above path as well as “C: oracle instantclient-basic-nt-11.2.0.3.0” 3.

Included the same 2 paths at the beginning of ‘path’ system variable 4. Placed tnsnames.ora(it’s perfectly tnsnames.ora, not tnsnames.ora.txt) file under “C: oracle instantclient-basic-nt-11.2.0.3.0 instantclient112” 5. The content of tnsnames.ora is as shown: MYDB = (DESCRIPTION = (ADDRESSLIST = (ADDRESS = (PROTOCOL = TCP)(HOST = poulpi6srv)(PORT = 1521)) ) (CONNECTDATA = (SERVICENAME = POULPI6) ) ) 6. There is no other version of Oracle installed on my local machine (neither instant Client nor the full version). Please i need help.

I am trying to Create a test Environment on a linux VM. From the Vm,Every thing seems to be fine. I can Start the Listerner and this is what i get After i start it. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Roman-OEL)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ———————— Alias REMOTELISTENER2 Version TNSLSNR for Linux: Version 11.2.0.1.0 – Production Start Date 15-AUG-2013 06:52:44 Uptime 0 days 0 hr. 1 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /home/Roman/app/Roman/product/11.2.0/dbhome2/network/admin/listener.ora Listener Log File /home/Roman/app/Roman/diag/tnslsnr/Roman-OEL/remotelistener2/alert/log.xml Listening Endpoints Summary (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Roman-OEL)(PORT=1521))) Services Summary Service “ORCL” has 1 instance(s). Instance “ORCL”, status UNKNOWN, has 1 handler(s) for this service Service “PLSExtProc” has 1 instance(s). I Was also able to connect to Database Roman@Roman-OEL $ sqlplus / as sysdba SQL.Plus: Release 11.2.0.1.0 Production on Thu Aug 15 06: Copyright (c) 1982, 2009, Oracle.

All rights reserved. ERROR: ORA-01031: insufficient privileges Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL.Plus Roman@Roman-OEL $ sqlplus /nolog SQL.Plus: Release 11.2.0.1.0 Production on Thu Aug 15 06: Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL connect sys/fundtech as sysdba Connected to an idle instance. SQL startup ORACLE instance started. Total System Global Area 841162752 bytes Fixed Size 1339768 bytes Variable Size 566234760 bytes Database Buffers 268435456 bytes Redo Buffers 5152768 bytes Database mounted.

Database opened. Further more,I can run Query and all of that. Please see my listerner settings # listener.ora Network Configuration File: /home/Roman/app/Roman/product/11.2.0/dbhome2/network/admin/listener.ora # Generated by Oracle configuration tools. Hello V, I have an application that is bundled with Oracle Instant client.the application uses the instant client to connect remotely to an oracle database using sqlplus. I get the error message TNS:protocol adapter error when i want to connect to the database. I have checked the environment variable and the PATH is “C: oracle instantclient” TNSADMIN is “C: oracle instantclient”. The oracle installation didn’t come with a tnsnames.ora file, so i created one in the instant client folder with the details below and: UBATEST.WORLD = (DESCRIPTION = (ADDRESSLIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.4.71)(PORT = 1521)) ) (CONNECTDATA = (SID = UBADB) ) ) But I still get the error message TNS:protocol adapter error please advise George.

» » » Here Oracle Instant Client Installation The Oracle Instant Client is a light-weight, freely distributable implementation of an Oracle client. A big advantage of the Instant Client is it does not need a formal installation. Instead, it can be unzipped and used without any fuss. Download The links below provide the general downloads page and the Linux x86-64 specific downloads, which will be used in this article. There are a number of downloads available, depending on which features you require.

The Linux versions also come with an RPM option, but as this requires root privilege to install, it may not be considered so desirable. The basic download provides all the core functionality necessary to make basic connections from Java. In this case, I wanted to make SQL.Plus connections, so I downloaded the following zip files.

instantclient-basic-linux.x64-11.2.0.4.0.zip. instantclient-sqlplus-linux.x64-11.2.0.4.0.zip Installation Installation couldn't really be simpler. $ mkdir /software $ cd /software $ unzip /tmp/instantclient-basic-linux.x64-11.2.0.4.0.zip $ unzip /tmp/instantclient-sqlplus-linux.x64-11.2.0.4.0.zip Use When using the Instant Client, we need to make sure the LDLIBRARYPATH environment variable is set to point to the location where the software was unzipped. In this case, I also set the PATH environment variable.

$ export LDLIBRARYPATH=/home/tomcat/software/instantclient112 $ export PATH=$PATH:$LDLIBRARYPATH $ sqlplus scott/tiger@//myhost.example.com:1521/myservice That's it! For more information see:. Hope this helps.