Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question (Please help)

Re: Newbie question (Please help)

From: Adnan Jamil <adnanjamil59_at_hotmail.com>
Date: Sun, 23 Feb 2003 19:17:08 -0800
Message-ID: <awd6a.899$os6.121707@news20.bellglobal.com>

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:Xns932BA32C090DBSunnySD_at_68.6.19.6...
> "Adnan Jamil" <adnanjamil59_at_hotmail.com> wrote in
> news:Ync6a.859$os6.110592_at_news20.bellglobal.com:
>
> >
> > "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
> > news:Xns932B943DBB45ESunnySD_at_68.6.19.6...
> >> "Adnan Jamil" <adnanjamil59_at_hotmail.com> wrote in
> >> news:jHb6a.523$kf7.104623_at_news20.bellglobal.com:
> >>
> >> > Hello Gurus,
> >> >
> >> > I have installed Oracle 8.0.5 on Windows 2000 on my home PC just
> >> > for doing PL/SQL practice. Oracle installed without any error but
> >> > when I open SQL Plus 8.00 and enter username & password
> >> > (System/Manager), I am getting following error message. Can anyone
> >> > guide me, how can I connect with oracle database and stop this
> >> > error. Thanks for your help. Error Is:-
> >> >
> >> > ORA-12203: TNS:unable to connect to destination.
> >> >
> >> > What TNS should I enter and from where I can get it.
> >> >
> >> > Thanks
> >> >
> >> > Adnan
> >> >
> >> >
> >> >
> >>
> >> If/when you are directly logged on to the Oracle DB server system,
> >> you do NOT need to connect to the DB via SQL*Net and therefore do
> >> NOT need TNS either.
> >>
> >> Just properly establish
> >> PATH
> >> LD_LIBRARY_PATH
> >> ORACLE_HOME
> >> ORACLE_SID
> >> and you should be into the DB without any delay.
> >>
> >> When all else fails, RTFM!
> >>
> >>
> >> HTH & YMMV
> >>
> >>
> >> HAND!
> >>
> >
> > Hi Ana,
> >
> > Thanks for your reply. I have checked/fixed all the paths and now I am
> > getting new message. When I entered username & password
> > (system/Manager) " ORACLE NOT AVAILABLE "
> >
> > Should I mount oracle database and how it could be.....
> >
> > Please help
> >
> > Thanks
> >
> >
> >
> >
> >
>
> NO OS! :-(
> NO OS version! :-(
> No version of Oracle! :-(
>
> Did you even bother to start the DB?

I am using Oracle 8.0.5 on Windows 2000 ver 5 (Build 2195 Service Pack 3)

Thanks Received on Sun Feb 23 2003 - 21:17:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US