Re: Sqlplus window question

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 13 Mar 2006 01:49:13 -0800
Message-ID: <1142243353.695943.8270@v46g2000cwv.googlegroups.com>

Mangood wrote:
> Thanks Rauf your answer is very valuable to me. One more question
> regarding ORACLE_SID. I added registry key ORACLE_SIE under
> HKLM\Software\Oracle and set its value to my instance's sid. But still
> I'm not able to connect using sqlplus - so what is the purpose of this
> registry key ?. I thought that main purpose of registry settings is to
> replace environment variables - but it seems I was wrong (I'm able to
> connect to database when I set environment variable and that's great)

You have to create this key under the Oracle Home in the registry. Look for a file called oracle.key under your Oracle_Home\bin directory. Open it in notepad, this points to your HKLM\Oracle home location in the registry.

Alternately, you can add ORACLE_SID environment variable according to directions in my previous post.

Regards
/Rauf Received on Mon Mar 13 2006 - 03:49:13 CST