Re: Sqlplus window question

Mangood wrote:
> Hi everyone
> I installed oracle database on my home computer (version 9.2) and
> created using oradim new instance. Now I'm able to to connect to idle
> instance using command prompt sqlplus (I set ORACLE_SID environment
> variable earlier) but I can't connect using sqlplusw (windows version).
> I get ORA-12560 error. Does anyone have an idea what I'm doing wrong ?
>
> Thanks in advance.

Any variable/s you set inside a command prompt (DOS box), they are ONLY relevant in that window e.g. You can change the PATH environment variable in the command window for a particular program BUT this change is not global.

Having said that... Let's open a command prompt (I assume you are on Win2K or XP) by Start --> Run --> Type cmd and enter.

At the command prompt you set the oracle_sid variable (I assume your sid to be TEST),
C:\> set oracle_sid=TEST
Now you can launch either sqlplus (command line) or sqlplusw (GUI) from here and your oracle_sid variable will be relevant i.e. C:\> sqlplus /nolog
OR
C:\> sqlplusw /nolog
OR
Other Oracle utilities like exp or imp etc.

If you launch either of the programs outside the above command prompt then you MUST set the oracle_sid variable as a global environment variable by Right Click My Computer --> Properties --> Advanced --> Environment Variables.

I suggest you read up on some basic information about the platform where you are running Oracle i.e. OS, What are environment variables and how to set them and how are they relevant when launching programs etc etc. Importance of setting the correct environment before invoking processes is same on Windows and Unix so this knowledge is essential.

Regards
/Rauf Received on Sun Mar 12 2006 - 08:09:56 CST