Installing Oracle instantclient basic and instantclient sqlplus on win. 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. Its all about do it once and forget it. Heres the copy of the writeup I did to install the latest 1. Oracle instantclient basic and instantclient sqlplus on win. Download Software. Go to Instant Client Downloads for Microsoft Windows 3. And download basic win. PC for example instantclient basic win. Create Oracle Directory. Create a C oracle directory on your C drive if you dont already have one and move both files into C oracle. Unzip both filesfirst unzip instantclient basic win. Installing OCI8 on Windows. When using Oracle 10gR2 client libraries on Windows, uncomment the php. When using Oracle 11gR2 or later. The Hortonworks Data Platform HDP is an enterprisegrade, hardened Apache Hadoop distribution that enables you to store, process, and manage large data sets. Apache. The following tables compare general and technical information for a number of relational database management systems. Hard Disk Paging File'>Hard Disk Paging File. Please see the individual products articles. Install Oracle 8I Windows 7 64 Bit' title='Install Oracle 8I Windows 7 64 Bit' />Win. Zip. Click Extract to here End result should be a new folder called instantclient1. C oracle Setup your system PATH and TNSADMIN variables. In Windows explorer LEFT pane, right click on My Computer icon and click Properties. MegaRAID SAS 93418i Add robust data protection to small and medium business SMB applications like email and file servers. Burleson Consulting is an altruistic company and we believe in sharing our Oracle extensive knowledge through publishing Oracle books and Oracle articles, video. Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. Click Advanced tab. Click Environment variables button In the System Variables panel select Path variable and click Edit button In the Variable Value field paste the following C oracleinstantclient1. E13212_01/wles/docs42/installadmin/wwimages/net_service_test.gif' alt='Install Oracle 8I Windows 7 64 Bit' title='Install Oracle 8I Windows 7 64 Bit' />Make sure its before all other path values that point to your OLD Oracle clients, then click. Ok. Now find a variable called TNSADMIN it could be in either panel System User, if you dont have such variable, create it in the User panel by clicking New Variable Name TNSADMIN. Variable Value C oracleinstantclient1. Click Ok. Now click Ok on the Environment Variables screenand click Ok on the System Properties window to close it. Setup tnsnames. ora file. If you already have an existing copy of tnsnames. C oracleinstantclient1. If you dont then create a new tnsnames. XRACQMYSERVICETAF. DESCRIPTION. ADDRESS PROTOCOL TCPHOST vip qarac. PORT 1. 52. 1. ADDRESS PROTOCOL TCPHOST vip qarac. PORT 1. 52. 1. ADDRESS PROTOCOL TCPHOST vip qarac. PORT 1. 52. 1. ADDRESS PROTOCOL TCPHOST vip qarac. PORT 1. 52. 1. LOADBALANCE yes. CONNECTDATA. SERVER DEDICATED. SERVICENAME XRACQMYSERVICETAF. FAILOVERMODE. TYPE SELECT. METHOD BASIC. RETRIES 1. DELAY 5. Test 1. Open a new CMD window by going to Start Run. In the Run Window type in cmd and press Ok in the CMD windows prompt enter the following sqlplus userpassTNSALIAS where user is the database username given to you by the DBA. DBA. TNSALIAS The alias you setup in the tnsnames. C sqlplus xxxxxxxxxxxXRACQMYSERVICETAF. SQLPlus Release 1. Production on Wed Aug 2. Learn To Speak &Amp; Talk The Hawaiian Language Audio Cd. Copyright c 1. 98. Oracle. All rights reserved. Oracle Database 1. Enterprise Edition Release 1. Windows Toolkit 2.5 Beta 1. Production. With the Partitioning, Real Application Clusters, OLAP, Data Mining. Real Application Testing options. Known Errors If you get the ORA 1. C sqlplus xxxxxxxxxxxxxxxxxxxxxxxxx. SQLlus Release 1. Production on Wed Aug 2. Copyright c 1. 98. Oracle. All rights reserved. ORA 1. 27. 05 Cannot access NLS data files or invalid environment specified. Enter user name. Heres the solution To fix the ORA 1. Cannot access NLS data files or invalid environment specified error, go to your registry editor run regedit from Start Run and then Navigate to Windows Registry in HKEYLOCALMACHINESOFTWAREORACLERemove the NLSLANG from there select it and deleteRe run the sqlplus test to make sure it works you will need to open a new CMD window for the registry changes to take place. Bonus PDFIf youd like to get a copy of this article in an easy to share PDF please sign up for my newsletter Confessions of an Oracle DBA where I share tips, scripts and tricks Ive learned during almost two decades in the tech field as an Oracle DBA SUBSCRIBEAdditional Resources. If you have any additional questions please join our Oracle DBA Community and post them there. And if you need any further Oracle DBA help I can be reached at http www. End. Vitaliy Mogilevskiy August 2. Posted In Operations. Tags instantclient basic, instantclient sqlplus, oracle instant client, win. Lab. 12. 8 Download. System requirements. CPU 5. 86 compatible or later Intel, AMD etc. Lab. 12. 8 presents a lot of graphical. MS Windows 2. 00. XP, Vista, Windows 7 1. No additional Oracle licenses requiredNo OEM, or PerformanceDiagnostic packs needed. Oracle Database Server, versions supported 8i, 9i, 1. Single instance, RAC and RAC One. Exadata Multitenant Container Database CDBPDB. Download the setup or zip file. LAB1. 28 6. 4 bit, version 1. May 2. 01. 7Which type of installation to useRegular Installation,Digitally signed. OCI 1. 1. 2. 0. 4 as optional feature. Length 1. 8,0. 38,7. Portable installation,also includes OCI 1. Length 2. 1,1. 18,0. SHA1 bd. 34. 7c. Portable installation,no OCI lab. Length 6,4. 45,5. SHA1 f. 68d. 62. LAB1. May 2. 01. 7Which type of installation to useRegular Installation,Digitally signed setup file, also includes OCI 1. Length 1. 7,3. 12,4. Portable installation,also includes OCI 1. Length 1. 6,8. 79,0. SHA1 c. 45. 9b. 24a. Portable installation,no OCI lab. Length 4,5. 60,3. SHA1 2a. 7d. 6c. LAB1. Linux version 1. May 2. Portable archive, includes. Wine and OCI 1. 1. Length 6. 2,3. 51,4. SHA1 dd. 68d. 11f. Authorization keycode. In order to activate your trial version, use this 2 day trial authorization key YRPZ 9. VL5 A6. P5. press here. The key expires on 1. If you need longer trial period, press. Previous versions. If for some reason you need the older version, visit Lab. Archive. New features history. Check the list of new features in all versions of the product New Features History. Lab. 12. 8 Freeware version. Please use this link Lab.