Re: problem starting SQLPLUS

From: Joel Garry <joel-garry_at_home.com>
Date: 29 Dec 2005 15:32:48 -0800
Message-ID: <1135899168.338369.142200@g14g2000cwa.googlegroups.com>

lakshmananl wrote:
> 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

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

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?

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

Received on Thu Dec 29 2005 - 17:32:48 CST