emss wrote:Have you looked at the SQLPlus User Guide and Reference, [url http://docs.oracle.com/cd/E11882_01/server.112/e16604/toc.htm] here
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
Of course, you use your own username, password and db name.
c:> sqlplus scott/tiger@orcl
emss wrote:Other variations you might be interested in
That did it! Thank you! It was how I was lauching the executable.
Edited by: emss on Jan 17, 2013 1:39 PM
C:\Users\estevens\Documents\sql>sqlplus SQL*Plus: Release 220.127.116.11.0 Production on Thu Jan 17 16:21:42 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: estevens@orcl Enter password: Connected to: Oracle Database 11g Release 18.104.22.168.0 - 64bit Production With the Automatic Storage Management option SQL>
On that second example, you can't see it but when I entered my password 'boomersooner' I appended the tns name, so entered 'boomersooner@orcl'
C:\Users\estevens\Documents\sql>sqlplus estevens SQL*Plus: Release 22.214.171.124.0 Production on Thu Jan 17 16:23:48 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 11g Release 126.96.36.199.0 - 64bit Production With the Automatic Storage Management option SQL>