TNS Errors - Please Help An Amateur

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Tue, 11 May 2004 05:27:08 GMT
Message-ID: <LuZnc.6237$eH1.3064955@newssvr28.news.prodigy.com>

I'm a relative amateur so please bear with me and hopefully someone can help me.

I had to uninstall my Oracle 9i and reinstall it and now I'm having problems connecting to my databases. I can connect just fine using Oracle Enterprise Manager but when I try to connect with SQLPlus I get different TNS errors depending on the host string I use.

I get either ORA-12514 or ORA-12154 and I am not sure whatsoever how to fix it. Before I had to remove Oracle it worked fine - though I did have help when I first installed Oracle before.

I'm hoping someone will take pity on me and try to help me out.

Thanks in advance,

Dereck L. Dietz
dietzdl_at_ameritech.net Received on Tue May 11 2004 - 00:27:08 CDT