10G tns questions

I am doing a first time test install of a prod database on 10G (10.2), installed the software, installed grid control, then applied latest patch and created a blank database (from scratch) to import the contents from my prod db into. Things went ok other than my rapidly growing dislike for grid control as it will see the new database when I discover it but never show it in the databases tab. Anyway, for now thats merely an annoyance.

What has me pulling my hair out now is I get a ora-12537: TNS connection closed error when I try to connect from a client, local or remote. I have tnsnames set up and the service name matched the service name when I enter "services" at the lsnrctl prompt. I can tnsping it fine.

One thing I did do was when creating the db was give it a 9 character name when I added "test" to the prod db name, didnt think it would let me, but I tried it and it didnt complain but I noticed it truncated it when I query the name from v$database.

Anyway, I have tried having the tnsnames use service name set as the truncated name and tried using the SID instead, but both result in the 12537 error.

I also ran an oradim -delete -sid and then recreated it with the truncated sid just in case, but all to no avail. I can connect fine thru SQL locally when I set the ORACLE_SID and bypass the listener.

One other thing I have noticed is that I also now have more than one oracle home to deal with, I have a c:\oracle\product\10.1.0\em_1 which I assume is for the repository db created with grid control, and a 10.2.0\db_1 home that is for the database I created. I though that this was causing me some grief with the listener etc. but once the listener is up and running it shouldnt matter where it was started from, correct? I've made the tnsnames, listener and sqlbet ora files identical in both homes just to be sure.

Anything I may have missed here? Doc's aren't to helpful so far, but I'll keep slogging thru them.. Received on Mon Apr 02 2007 - 16:18:54 CDT