Re: TNS:protocol adapter not loadable

But if you must use windows, the 'Universal' (what is so universal about it, I don't know) installer contains the functionality to change your default home. It takes a bit of clicking around to find it, but it is there. I believe it was somewhere on the installed products screen.

Kind regards,
Eric.

2007/8/13, Jared Still <jkstill_at_gmail.com>:
>
> On 8/13/07, J. Dex <cemail_219_at_hotmail.com> wrote:
> >
> > I can no longer login to 9207 database on Windows 2003 from command
> > line. I
> > am getting ORA-12557: TNS:protocol adapter not loadable. The only
> > difference that I am aware of since this
> > last worked is that ORACLE_HOSTNAME Environment Variable was set and
> > 10.2.0.1
> > has been installed on the box.
> >
> >
> When you installed 10.2, the PATH was altered to put the 10.2 binaries
> ahead of
> those in the 9207 database.
>
> The Oracle Home Selector does not work with Oracle 10+.
>
> Ergo, you must manually set your environment for 9i when using the command
> line.
>
> This may or may not be the problem, but it seems a likely suspect.
>
> Oracle on Windows - Just say no.
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

--
http://www.freelists.org/webpage/oracle-l