Want to watch this again later? Sign in to add this video to a playlist. Installing Oracle Client and Inserting TNS Connection file Full client 32 bit: http:// Full client 64 bit: http:// Also see my Stackoverflow http://stackoverflow.
![Installing Oracle Instant Client Installing Oracle Instant Client](http://danielstudds.com/wp-content/uploads/2010/05/4-select-default-table.png)
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. It’s all about – do it once and forget it. Here’s 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.
6 Responses to Connect from.NET to Oracle without installing the Oracle Client. Installing PHP and the Oracle Instant Client for Linux and Windows. For PHP 5.5, OCI8 2.0 and Oracle Database 12c Release 1. By Christopher Jones. March 2015.
Background: A legacy client-server database accessing.NET Windows Form application deployed by ClickOnce. In order to communicate with the database, Oracle Client 8i is installed on every client machine. Clearly installation jobs are disturbing. Another problem is distributed transaction not being supported until Oracle Client 9i. It should be better to implement a WCF service…. If you want to use SQL Server Management Studio, you want to install the full Oracle client, not the Instant Client. The full Oracle client is on the same download page as the Oracle database. Connecting to Oracle using C# without using Oracle Developer Tools for Visual Studio.NET. Managing Oracle connectivity with a minimal footprint using Oracle Instant Client. 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.
Create a C: \oracle directory on your C drive (if you don’t already have one) and move both files into C: \oracle. Unzip both filesfirst unzip instantclient- basic- win. Win. Zip. Click Extract to here …End result should be a new folder called instantclient_1. C: \oracle: Setup your system %PATH% and %TNS_ADMIN% variables. In Windows explorer LEFT pane, right click on My Computer icon and click Properties. 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: \oracle\instantclient_1.
Make sure it’s before all other path values that point to your OLD Oracle clients, then click. Ok. Now find a variable called TNS_ADMIN – it could be in either panel (System / User), if you don’t have such variable, create it in the User panel by clicking New: Variable Name: TNS_ADMIN. Variable Value: C: \oracle\instantclient_1. 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: \oracle\instantclient_1. If you don’t – then create a new tnsnames.
Installing PHP and the Oracle Instant Client for Linux and Windows For PHP 5.4 and Oracle Database 11g Release 2. By Christopher Jones. Updated April 2012.
XRACQ_MYSERVICE_TAF =. DESCRIPTION =. (ADDRESS = (PROTOCOL = TCP)(HOST = vip- qarac. PORT = 1. 52. 1)).
ADDRESS = (PROTOCOL = TCP)(HOST = vip- qarac. PORT = 1. 52. 1)). ADDRESS = (PROTOCOL = TCP)(HOST = vip- qarac. PORT = 1. 52. 1)). ADDRESS = (PROTOCOL = TCP)(HOST = vip- qarac. PORT = 1. 52. 1)).
LOAD_BALANCE = yes). CONNECT_DATA =. (SERVER = DEDICATED). SERVICE_NAME = XRACQ_MYSERVICE_TAF.
FAILOVER_MODE =. (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 window’s prompt – enter the following: sqlplus user/pass@TNS_ALIAS where: user: is the database username given to you by the DBA. DBA. TNS_ALIAS: The alias you setup in the tnsnames. C: \> sqlplus xxx/xxxxxxxx@XRACQ_MYSERVICE_TAF.
SQL*Plus: Release 1. Production on Wed Aug 2. Copyright (c) 1. 98.
Oracle. All rights reserved. Oracle Database 1. Enterprise Edition Release 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 xxxxxx/xxxxxxxx@xxxxxxxxxxx. SQL*Plus: 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. Here’s 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 \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLERemove the NLS_LANG from there (select it and delete)Re- 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 you’d 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 I’ve 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.