problem starting SQLPLUS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lakshmananl - 28 Dec 2005 06:52 GMT

Help, we have client oracle ver 9.0.2 installed in AIX ver5 the profile
has been set. But when we give the command sqlplus, it is not starting
the appln and also does not prompt any error for the same. PLZ help in
the above problem.
thank you.
lakshman

Reply to this Message

Laurenz Albe - 28 Dec 2005 08:14 GMT

> Help, we have client oracle ver 9.0.2 installed in AIX ver5 the profile
> has been set. But when we give the command sqlplus, it is not starting
> the appln and also does not prompt any error for the same. PLZ help in
> the above problem.

Whatever an appln is that wants no errors from you...

What is the output of 'which sqlplus' ?

What is the output of 'ldd $(which sqlplus)' ?

What is the screen output if you enter 'sqlplus /nolog' ?

Yours,
Laurenz Albe

Reply to this Message

Joel Garry - 28 Dec 2005 22:00 GMT

Post the output of the following, entered at the shell:

printenv|grep ORA
printenv|grep TNS
printenv|grep TWO
ll `which sqlplus`

jg
--
@home.com is bogus.
"In 2005, for the first time in history, a woman won the pole position
at Indy. Who was it?"
"Uh, hah-hah, Lindsay Lohan?"
"She's fast, but not that fast." - Heard on radio.

Reply to this Message

lakshmananl - 29 Dec 2005 05:25 GMT

i got the following information after entering the the commands and i
have pasted them below for your reference.

Kindly help me in the issue.
$ echo $ORACLE_HOME
/opt/oracle/OraHome
$ printenv | grep ORA
ORACLE_HOME=/opt/oracle/OraHome
$ printenv | grep TNS
$ printenv | grep TWO
$ sqlplus

regards
lakshmanan

Reply to this Message

Joel Garry - 29 Dec 2005 23:32 GMT

> i got the following information after entering the the commands and i
> have pasted them below for your reference.
[quoted text clipped - 4 lines]
> $ printenv | grep ORA
> ORACLE_HOME=/opt/oracle/OraHome

What, no ORACLE_SID?

------------------------------------------------------------------------------
/home2/oracle$ unset ORACLE_SID
/home2/oracle$ sqlplus

SQL*Plus: Release 9.2.0.6.0 - Production on Thu Dec 29 15:14:26 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: abc
Enter password:
ERROR:
ORA-07217: sltln: environment variable cannot be evaluated.

Enter user-name:
--------------------------------------------------------------------------------

Try setting and exporting ORACLE_SID to your, well, SID.

> $ printenv | grep TNS
> $ printenv | grep TWO
> $ sqlplus

You need to use backquotes (the one under the tilde ~ and over the tab
on most keyboards) when you do:

ll `which sqlplus`

If you did that, it might mean you aren't setting $ORACLE_HOME/bin into
your PATH. I like to have a dot command that refers to a generic
script I put in /usr/local/bin that sets ORACLE_HOME, ORACLE_SID,
ORACLE_BASE, NLS_LANG, adds the bin to the PATH and unsets TWO_TASK
(because I rotate through several of these things with other dot
commands, and set things into my prompt). The more normal way to do
this is with oraenv. That should be in one of your common directories
(I forget which one for your platform, on mine it's /usr/local/bin).
Try just typing in oraenv and see what happens.

> regards
> lakshmanan

Also I'm wondering if you stty setting are getting goofed up somehow,
any tset or stty settings in your .profile? Are you using X-Windows or
telnet or what?

jg

Signature

@home.com is bogus.
http://www.gizmag.com/go/4936/

Reply to this Message