Re: 10g SQLPLUS connect problem

From: joel garry <joel-garry_at_home.com>
Date: Wed, 5 Aug 2009 09:56:37 -0700 (PDT)
Message-ID: <3e3ba0c3-9f3a-4144-9774-3095a7dd842d_at_b25g2000prb.googlegroups.com>

On Aug 5, 4:35 am, Shakespeare <what..._at_xs4all.nl> wrote:
> Rich schreef:
>
>
>
> > On Aug 2, 9:17 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> >> "Rich" <richma..._at_earthlink.net> a écrit dans le message de news:
> >> a151f7d1-1c4d-427a-95bd-5f6d82c9f..._at_l31g2000vbp.googlegroups.com...
> >> |
> >> | 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

--
_at_home.com is bogus.
"For a developer a cell phone is a toy, to a DBA it is an instrument
of the devil." -  Harrison Picot

Received on Wed Aug 05 2009 - 11:56:37 CDT