mls_date_format [message #63800] |
Tue, 09 November 2004 00:14 |
AL
Messages: 24 Registered: October 2000
|
Junior Member |
|
|
Hi,
I have oracle 9.2.0.4. on Redhat.
There are running several instances.
Now I have to crate one instance with the nls_date_format = "YYYY.MM.DD HH24:MI:SS". There are setted no values in the environment variables (and I don't want to because I don't want to change the settings of the other db's).
The standard value of the db's is DD-MON-RR. So I changed the value in the init.ora (spfile), but there are no effect!
Now I don't know why this causes no results!
Normally Session-Parameters are stronger than instance-parameters. And instance-parameters stronger than db-parameters.
But there are no session-parameters (no environment settings about nls_date), so the instance-parametrs should work!
I connect directly on the server, so no client-setting could disturb! Where is then the problem?
|
|
|
|
Re: mls_date_format [message #63804 is a reply to message #63802] |
Tue, 09 November 2004 02:48 |
AL
Messages: 24 Registered: October 2000
|
Junior Member |
|
|
Äh...sorry! My fault. My description was maybe a little bit confusing.
I meant I changed pfile AND Spfile and started which each one several times and there was no effect.
Where get this parameter its value from?
|
|
|
|
Re: mls_date_format [message #63808 is a reply to message #63805] |
Tue, 09 November 2004 04:07 |
AL
Messages: 24 Registered: October 2000
|
Junior Member |
|
|
OK...I take this thing now and kick it out of the window!
I made it like you described (changing nls_format_entry in pfile and started the instance directly with this pfile), but no effect!
I changed the entry in the spfile per Enterprise Manager and restarted it, no effect!
I changed (both spfile and pfile) the entries in a w2000 test-environment on an instance which have no entries about nls_date_format in the registry and restartet it several times, no effect!
When i logged in in linux as oracle-user and query my environment-variables with 'env', will I get all relevant settings?
Or could it be that an other entry like NLS_lang overwrite my pfile and spfile settings?
|
|
|
|
Re: mls_date_format [message #63811 is a reply to message #63810] |
Tue, 09 November 2004 05:11 |
AL
Messages: 24 Registered: October 2000
|
Junior Member |
|
|
There is nothing else exept nls_lang=AMERICAN_AMERICA.WE8ISO8859P1.
I made now a new test-instance with the new nls_date_format in my windows test-environment...no effect!
There must be something, which I overlook...
|
|
|
Re: mls_date_format [message #63817 is a reply to message #63810] |
Tue, 09 November 2004 22:25 |
AL
Messages: 24 Registered: October 2000
|
Junior Member |
|
|
Is it possible, that the nls_lang-Parameter overrides the nls_date_format from the pfile and spfile?
Is then the default value of nls_date_format at WE8ISO8859P1 and WE8MSWIN1252 DD-MM-RR?
And it is so impossible to change the nls_date_format for one specifisc instance execpt from changing the registry on the clients?
|
|
|