Re: 10g SQLPLUS connect problem

From: Rich <richmarin_at_earthlink.net>
Date: Wed, 5 Aug 2009 04:12:51 -0700 (PDT)
Message-ID: <0918d63a-5983-4240-8e60-5f60e53e7119_at_c29g2000yqd.googlegroups.com>

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 Received on Wed Aug 05 2009 - 06:12:51 CDT