Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question (Please help)
"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 Received on Sun Feb 23 2003 - 20:00:03 CST