Re: 9i Problems - please help

> > 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
Thank you. I've done this all over the registry where the ora9i home was referred to. It had been set to AMERICAN_AMERICA.WE8ISO8859P1. Is that a Unix reference?

> Is it possible that you have more than one ORACLE_HOME and that the
> default home was changed?

Yes, i've found three of them, a v8i, the 9i i'm working with, and a 9.2 which is incompletely populated.

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

OK. I've set up for "ora9i". The other ones were called OraHome8i and OraHome92. Is the "OraHome" substring significant? I carried on anyway.

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

Thank you, yes, I did this today. Output didn't make much sense to me though.

The net effect of chasing round in the Admin Manager and the registry editor is that now I get a different message:

"internal error: oracle.jdbc.oci8.OCIEnv_at_424c48" The last few digits

seem to be different each time. I'm concerned that it refers to oci8.

I'm wondering if the 9i installation is not complete. I fired up the installer but the few omissions didn't seem relevant - WorkGroup and Wireless.

> > 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?

it's meant to be automatic on startup. Checking is with the "component services" tool. This says it has failed. Disabled that and ran manually from a 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>.

...not sure what I should have substituted here...  

> The service for the default listener is named
> 'OracleOraHome901TNSListener'.
>
> when you type:
>
> C:\> net start OracleOraHome901TNSListener
>
> what is the error message?

>

... but this says that the command completed without error. However, the bit which mentions the "ora9i" instance also says that status is "UNKOWN", which doesn't seem good?  

>
> 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,

yes, indeed, I can see much better how Admin manager and the registry tie
up. but I'm still missing a link somewhere

Thanks for your help so far, very informative day today,

Pete. Received on Mon Oct 06 2003 - 13:55:55 CDT