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 TNSrotocol adapter error

Why does oracle database home page understand my system name and
password and not SQL Plus.

"Rich" <richmarin (AT) earthlink (DOT) net> a écrit dans le message de news:
a151f7d1-1c4d-427a-95bd-5f6d82c9ffb9...oglegroups.com...
ORACLE_SID is not set.

Regards
Michel

On Aug 2, 9:17*pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

Thanks for the reply Mike.

Total Newbie here. What would I need to do in order to set ORACLE_SID.

Regards

Rich schreef:
Before starting SQLPLUS, set an environment variable: ORACLE_SID=XE
or connect using username/password@xe

Shakespeare

On Aug 5, 4:35*am, Shakespeare <what... (AT) xs4all (DOT) nl> wrote:
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
--
@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

joel garry schreef:
You're right. The SID is in the registry.

Shakespeare

joel garry schreef:
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

Shakespeare schreef:
So here's what I did: (sorry it's in Dutch)



SQL*Plus: Release 10.2.0.1.0 - Production on Wo Aug 5 21:02:38 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Voer gebruikersnaam in: system/osait01
ERROR:
ORA-12560: TNS: fout bij protocoladapter.


Voer gebruikersnaam in: system/osait01@xe
ERROR:
ORA-12154: TNS:kan opgegeven verbindings-ID niet herleiden


Voer gebruikersnaam in:
C:\Documents and Settings\William>set
ORACLE_HOME=C:\oraclexe\app\oracle\product
\10.2.0\server

C:\Documents and Settings\William>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Wo Aug 5 21:04:13 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: system/osait01
ERROR:
ORA-12560: TNSrotocol adapter error


Enter user-name: system/osait01@xe

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>


Shakespeare

Shakespeare schreef:
Wanneer je een connect-string meegeeft, in jouw geval XE, dan moet de oracle client die
terugvinden in zijn tnsnames.ora, en bij jou vindt hij die niet.

Geef je geen connect-string, dan probeert de client naar een locale gegevensbank te connecteren,
die bijvoorbeeld met de variabele LOCAL kan gedefinieerd worden, of TWO_TASK, op unix systemen.
Op Wijndoos systemen zal daar wel een alternatief voor bestaan, in het register bijvoorbeeld.
Maar bij jou mislukt dat ook met een ora-12560.

On Aug 5, 12:34*pm, "Gerard H. Pille" <g... (AT) skynet (DOT) be> wrote:
Babelfish babbles that as:
"When you give connect-string, in your case XE, then the oracle client
must who to retrieve in its tnsnames.ora does not find, and at you he
that. Give you none connect-string, then the client tries to a local
data bank at connecteren, which can be defined for example with the
variable LOCAL, or TWO_TASK, on unix systems. On wine box of systems
there, however, an alternative for will exist, in the register for
example. But at you failed that also with ora-12560."

Shouldn't there be an oracle home selector under start-->programs?

Good to see that XE, one of whose objectives is to be easy for
newbies, can tie experienced oracle people's brains in knots.
Speaking only for myself, of course. I blame Bill Gates.

jg
--
@home.com is bogus.
Balmer Is Not Gates. That shows that Gates isn't the worst.