Re: 10g SQLPLUS connect problem
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 05 Aug 2009 13:35:59 +0200
Message-ID: <4a796ea1$0$197$e4fe514c_at_news.xs4all.nl>
Rich schreef:
>> "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
Date: Wed, 05 Aug 2009 13:35:59 +0200
Message-ID: <4a796ea1$0$197$e4fe514c_at_news.xs4all.nl>
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 Received on Wed Aug 05 2009 - 06:35:59 CDT