Re: 9i Problems - please help

Pete <div.kid_at_home.com> wrote in message news:<3F7E7BD0.FB618F5E_at_home.com>...
> 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?

the nls_lang value is an atribute of the ORACLE_HOME. you can check its value in the windows regsitry:

HKLM\SOFTWARE\ORACLE\HOMEn (the Oracle 901 home) NLS_LANG : REG_SZ : AMERICAN_AMERICA.WE8MSWIN1252 Is it possible that you have more than one ORACLE_HOME and that the default home was changed?

You can edit/view the default home in the Oracle Home Selector (Oracle Installation Products >> Home Selector)  or via the Oracle Administration Assistant for NT.

I'd recommend setting tracing to ADMIN for your oracle client and examine the trace files. You can perform that in the Oracle Net Manager tool.

> 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.
>
> Pete.

I didn't use 901 much, so I'm working from a 92 home. how are you starting the listener, via the MMC, or from the command line?

the NT service for the listener would have the listener name included at the end of its name, e.g.
'OracleOraHome901TNSListener'||<listener_name>.

The service for the default listener is named 'OracleOraHome901TNSListener'.

when you type:

C:\> net start OracleOraHome901TNSListener

what is the error message?

when you type:

d:\oracle\ora92\bin> lsntcrl
LSNRCTL> start listener

what message is returned?
If no service exists, it will create one for you.

I'd recommend using the Net Manager tool to edit the listener.ora file.
If the file is hosed, delete the file and create a new one with the Net Manager tool. Then you can create the service by the commands listed above

If all else fails, you can delete the service and delete the listener.ora file.
You can re-create the default listener and service without the use of a listener.ora file, but you will have to manually set a password each time it is started, if you want to protect the listener with a password.

hth,

Pd Received on Sat Oct 04 2003 - 14:41:21 CDT