![]() 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……. And if you need any further Oracle DBA help – I can be reached at:.If you have any additional questions please join our Oracle DBA Community and post them there.If 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: SUBSCRIBE Additional Resources 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). Remove the NLS_LANG from there (select it and delete).Navigate to Windows Registry in \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.To fix the ORA-12705: Cannot access NLS data files or invalid environment specified error, go to your registry editor (run regedit from Start->Run) and then: ORA-12705: Cannot access NLS data files or invalid environment specified If you get the ORA-12705 error while running sqlplus: C:\>sqlplus Release 11.1.0.7.0 - Production on Wed Aug 26 16:58:33 2009 With the Partitioning, Real Application Clusters, OLAP, Data Mining Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production TNS_ALIAS: The alias you setup in the tnsnames.ora fileĮxample: C:\>sqlplus Release 11.1.0.7.0 - Production on Wed Aug 26 16:24:23 2009Ĭopyright (c) 1982, 2008, Oracle. Pass: is the database password given to you by the DBA In the CMD window’s prompt – enter the following: sqlplus where: user: is the database username given to you by the DBA In the Run Window type in: cmd and press Ok:. ![]() Open a new CMD window by going to Start-> Run.(ADDRESS = (PROTOCOL = TCP)(HOST = vip-qarac3)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip-qarac4)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip-qarac2)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = vip-qarac1)(PORT = 1521)) If you don’t – then create a new tnsnames.ora file, for example: XRACQ_MYSERVICE_TAF = If you already have an existing copy of tnsnames.ora file then place it to: C:\oracle\instantclient_11_1 and click Ok on the System Properties window to close it.Now click Ok on the Environment Variables screen.Variable Value: C:\oracle\instantclient_11_1 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 Make sure it’s before all other path values that point to your OLD Oracle clients, then click Ok In the Variable Value field paste the following: C:\oracle\instantclient_11_1. In the System Variables panel select Path variable and click Edit button: In Windows explorer LEFT pane, right click on My Computer icon and click Properties.Setup your system %PATH% and %TNS_ADMIN% variables then unzip instantclient-sqlplus-win32-11.1.0.7.0.zipĮnd result should be a new folder called instantclient_11_1 in your C:\oracle:.first unzip instantclient-basic-win32-11.1.0.7.0.zip.instantclient-sqlplus-win32-11.1.0.7.0.zipĬreate a C:\oracle directory on your C drive (if you don’t already have one) and move both files into C:\oracle.Go to Instant Client Downloads for Microsoft Windows (32-bit) download page:Īnd download basic-win32 and sqlplus-win32 files to your PC (for example): Here’s the copy of the writeup I did to install the latest 11g Oracle instantclient basic and instantclient sqlplus on win32: Download Software It’s all about – do it once and forget it. I typically setup a dedicated DBA Portal website wherever I work and then write up instructions for repetitive things like these. Sometimes basic things like installing the latest Oracle instantclient on the PCs of all of your developers can take considerable time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |