Re: sqlplus fails on local connect

If you are on Windows, open the registry and set the LOCAL registry key to your database name:
\\HKEY_LOCAL_MACHINE\Software\ORACLE
LOCAL = test
Under unix, set the environment variable ORACLE_SID to test: export ORACLE_SID=test (bash)
setenv ORACLE_SID test (csh)

Jeroen van Veldhuizen
Developer

Robert Lehr wrote:

> I cannot connect to my local database, i.e. on the same machine,
> via sqlplus with this command:
>
> sqlplus scott/tiger
>
> but this will work:
>
> sqlplus scott/tiger_at_test
>
> I know that I have connected to oracle databases before (and
> continue to do so) with the first command. Why doesn't it
> work? I have my ORACLE_HOME and ORACLE_SID set correctly.
> It has nothing to do with the listener.
>
> I am sorry for such a simple, stupid question. But, after
> years of using oracle, I am simply frustrated with this one.
>
> Thanks ahead of time.
> Bozzio.
Received on Sun Apr 22 2001 - 22:13:35 CEST