Check your environment. Bettya something is messed up after the 10.2.0.1 install. RF Robert G. Freeman Oracle Consultant/DBA/Author Principal Engineer/Team Manager The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One, Author of various geeky computer titles from Osborne/McGraw Hill (Oracle Press) Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com! BLOG: http://robertgfreeman.blogspot.com/ Sig V1.2 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of J. Dex Sent: Monday, August 13, 2007 8:47 AM To: oracle-l@xxxxxxxxxxxxx Subject: TNS:protocol adapter not loadable 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. Oddly, it is possible to login to the database from SQLPlus Worksheet and the Services shutdown and startup fine from the Services icon works without any problems. It just seems to be the command line. Has anyone else run into this? _________________________________________________________________ Booking a flight? Know when to buy with airfare predictions on MSN Travel. http://travel.msn.com/Articles/aboutfarecast.aspx&ocid=T001MSN25A07001 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l