![]() 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. 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. 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). • vpnclient-linux-x86_64-4.8.00.0490-k9.tar.gz Note VPN client fails to install on Linux kernel version is 2.6.31 and above. The workaround is to downgrade to one. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |