Re: 10g SQLPLUS connect problem

From: Shakespeare <>
Date: Wed, 05 Aug 2009 21:06:12 +0200
Message-ID: <4a79d80a$0$189$>

joel garry schreef:
> On Aug 5, 4:35 am, Shakespeare <> wrote:
>> Rich schreef:
>>> On Aug 2, 9:17 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
>>>> "Rich" <> a écrit dans le message de news:
>>>> |
>>>> | I am using 10g Express Edition on Windows XP.
>>>> |
>>>> | I click on Start -> Oracle Database 10g Express Edition -> Go to
>>>> | Database Home Page
>>>> |
>>>> | I enter my system username and password no problem.
>>>> |
>>>> | Then I try to do the same thing in SQLPLUS. I enter the same system
>>>> | name and password and I get the following error:
>>>> |
>>>> | Error:
>>>> | ORA-12560 TNS:protocol adapter error
>>>> |
>>>> | Why does oracle database home page understand my system name and
>>>> | password and not SQL Plus.
>>>> ORACLE_SID is not set.
>>>> Regards
>>>> Michel
>>> Thanks for the reply Mike.
>>> Total Newbie here. What would I need to do in order to set ORACLE_SID.
>>> Regards
>> Before starting SQLPLUS, set an environment variable: ORACLE_SID=XE
>> or connect using username/password_at_xe
>> Shakespeare

> I was under the impression the environment all gets set in the
> registry for automatic use when you install XE?
> Rich, do you have more than one Oracle selection under your start-->
> programs? Are you going to the command line and running sqlplus, or
> selecting under xe programs? Do you have more than one user login on
> your computer? Is there other Oracle software on your computer?
> For me, if I select sqlplus under the xe programs menu it goes right
> in to sqlplus, and I can then connect to whatever oracle user I want.
> If I go into the command line and say sqlplus / as sydsba, I'm also
> right in - no changing directories or anything. If I say set at the
> command line, there are no Oracle enviroment variables, just a
> reference to the %oracle_home%\bin in the path. XE did all this
> automatically on install. I suspect if it is different for you, there
> is something you are not telling us - perhaps several tries at
> installing?
> The suggestions given by Shakespeare and Michel are assuming you are
> at the command line.
> If you are conversant with registry editors, you might take a look at
> see what it says about oracle_home and oracle_sid (I think, it's been
> a while since I've looked).
> jg
> --
> is bogus.
> "For a developer a cell phone is a toy, to a DBA it is an instrument
> of the devil." - Harrison Picot

Just tested this on my PC. Still had to set ORACLE_HOME and ORACLE_SID....

But I have multiple ORACLE_HOMe's on my system (one is for oracle client). Got the same errors as the OP.

Shakespeare Received on Wed Aug 05 2009 - 14:06:12 CDT

Original text of this message