9i Problems - please help

Please does anyone have any pointers about the following two problems?

System is a 9i, v9.0.1.x.x, running on Win2000 Server, with Service packs 1 & 2 applied.

First problem didn't exist at the beginning of the week. Try to start Enterprise Manager. Click for "Standalone". Main window of OEMapp opens normally, database appears on tree structure. Click on dbase name to log in. Now get an error pop-up "Character Set Not Supplied!! DB Conversion". All log in attempts thenm fail. First thought was NLS_LANG had been fiddled with, but upon checking it didn't seem to be set at all - but this had not been a problem earlier in the week. Don't understand what's going on? Anyone seen this before?

Second problem: TNSlsnr won't start any more, but again it used to. Now gives message in log file "missing listener name 'S' in listener.ora" All well and good, but no listener set up file has this 'S' as a name. All the brackets seem to match up.

Please don't say "RTFM" - I don't have an FM to R, or I would do.

Thanks in advance for any help,

Pete. Received on Sat Oct 04 2003 - 02:50:40 CDT