This content has been marked as final. Show 17 replies
emss wrote:Generally, one doesn't download/install sqlplus in a vacuum. It is simply the 'lowest common denominator user interface' that comes along with any installation of the oracle client. So just download/install the latest oracle 11.2 client.
I have been instructed by an Oracle support Tech to run a diagnostic .sql using Oracle SQL*Plus 10.2.0.0.0 or higher. I currently have 10.1.0.4.2.
This was acquired by Development Suite 10g. Therefore, I reinstalled today using current Oracle 10g version, and nothing chaned regarding SQL*Plus...same version as a year ago.
So, how do I acquire a 10.2.0 (or higher) version of SQL*Plus. I develop using a windows based client; Oracle EBS product 12.1.3; Database version 11g 188.8.131.52.0.
Edited by: emss on Jan 16, 2013 6:43 AM
If we knew what your original problem was, we might be able to shed some light on your requirement and why "oracle support" made the request as you interpreted it.
Thank you, but I'm still a little lost.
This web-page (http://www.oracle.com/technetwork/topics/winsoft-085727.html ) has instantclient_basic-nt-184.108.40.206.0 as a .zip file. All the versions on this page are for "NT".
I am not in an NT envirionment (Windows XP). Would I still use this .zip file or is there a different version to consider?
Edited by: emss on Jan 16, 2013 7:08 AM
Edited by: emss on Jan 16, 2013 7:09 AM
I am really confused on this download's installation.
I have downloaded the basic version, instantclient-nt-220.127.116.11.0.zip, and the instantclient-sqlplus-nt-18.104.22.168.zip. I extracted both to a common C:\ location.
Now what? How do I install instant client...there is not install.exe...???
As I mentioned, I currently use the Oracle Develeopment Suite 10g. Do I need to copy all the downloaded objects into a folder of the Development Suite.
Any help on this INSTANT install is greatly appreciated. I appologize for my ingnorance, but this download install simply doesn't make sense the first time trying to install.
Edited by: emss on Jan 16, 2013 8:03 AM
emss wrote:There's nothing to install. Just unzip the downloads into a common directory, and add that directory to your PATH. You'll need to create a tnsnames.ora file and add the environment variable TNS_ADMIN to point to that.
Still seeking a solution: How to install instant client? I've downloaded and unzipped and added the PATH as instructed...but nothing works.
The instructions might be a little indirect to actually locate, but they are [url http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html] here
As for the tnsname.ora and the tns_admin directory, I don't put that in the same directory to which I unzip the instant client, but along side it. So, if I put the instant client at 'c:\app\oracle\instant_client, then I put the tnsnames in 'c:\app\oracle\tns_admin'. Then I add 'c:\app\oracle\instant_client' to my PATH, and add a system environment variable TNS_ADMIN with a value of c:\app\oracle\tns_admin'.
You probably don't want the Instant Client. That's for people that are developing applications that want to install a stripped down version of the Oracle client along with their application.
If you go to the 11g database download page
and choose the "See All" link next to whatever platform you are using (I'm guessing either 32- or 64-bit Windows), you should see an option to download the Oracle Database 11g Release 2 Client (22.214.171.124.0) for Microsoft Windows. This should be a ~600 MB download. Download and install that-- you probably only need the runtime install when the installer asks.
Thank you for your help. Maybe I'm getting closer, but yet to launch a successful session. I've followed all the instructions and can start the version of sql*plus.exe in the instant client folder. However, I am not provided an Oracle Instance at log in.
In the past, I used the SQLPlusW.exe...which is unsupported in the 11g environment. I am trying hard to use Oracle's tool as designed, but this is incredibly difficult to configure and support (the first time).
I added the tnsnames.ora which has my companies setups. However when I start the sqlplus.exe, I receive no instance to log into. I get two messages after attempting a pw entry as follows: ORA-01034: ORACLE not available; and ORA-27101: shared memory realm does not exist.
Any pointers would be appreciated. The Oracle instances are on shared servers using Linux. I did download and install 11g2_r2 database too as well as the instant client download. Finally, I have a version of 10g Development suite fully installed. Like I said...really trying hard to upgrade the sql*plus version....
Edited by: emss on Jan 17, 2013 9:01 AM
Edited by: emss on Jan 17, 2013 9:03 AM
all objects documented below are located in C:\...TNS_Admin folder (instant client install path similar to path structure mentioned by EdStevens). The tnsnames.ora and SQLNet.ora1 were copied from Development_Suite\NETWORK\ADMIN.
Here are several key entries from tnsnames.ora :
Here is sqlnet.ora1 (not sure the 1 should be there...but I copied it from Development_Suite as is:
# sqlnet.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)
Here is Listener.Ora - looks totally wrong - likely created when I installed 11g_r2 is my guess
# listener.ora Network Configuration File: C:\Program Files\app\Oracle\tns_Admin\listener.ora
# Generated by Oracle configuration tools.
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\eswistak\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\eswistak\product\11.2.0\dbhome_1\bin\oraclr11.dll")
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ADR_BASE_LISTENER = C:\app\eswistak