 | |
How can I alter the parameter nls_sort
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: How can I alter the parameter nls_sort -
06-24-2008
, 02:40 AM
|
On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjack... (AT) gmail (DOT) com wrote: I used "alter system set nls_sort = binary_ci scope = spfile" to change the default value of the parameter nls_sort.Then I restarted the service of the database instance.I saw the instance value has changed.Now the problem is when I create a new connection the value of nls_sort was not binary_ci but binary.I don't know why the session value was not changed. any advice will be appreciated! Thanks a lot Jack.Lee Instance settings can be, and usually are, overridden by session specific values. Oracle always sends a series of alter session statements immediately after logon. Those can be changed by setting a registry string value in the correct hive for Windows, or by setting an environment variable on Unix in your .profile. You can also use an execute immediate statement in an after logon database trigger. Hth -- Sybrand Bakker Senior Oracle DBA |
Thank u very much!
Jack.Lee
#12
| |||
| |||
|
|
On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjack... (AT) gmail (DOT) com wrote: I used "alter system set nls_sort = binary_ci scope = spfile" to change the default value of the parameter nls_sort.Then I restarted the service of the database instance.I saw the instance value has changed.Now the problem is when I create a new connection the value of nls_sort was not binary_ci but binary.I don't know why the session value was not changed. any advice will be appreciated! Thanks a lot Jack.Lee Instance settings can be, and usually are, overridden by session specific values. Oracle always sends a series of alter session statements immediately after logon. Those can be changed by setting a registry string value in the correct hive for Windows, or by setting an environment variable on Unix in your .profile. You can also use an execute immediate statement in an after logon database trigger. Hth -- Sybrand Bakker Senior Oracle DBA |
Thank u very much!
Jack.Lee
#13
| |||
| |||
|
|
On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjack... (AT) gmail (DOT) com wrote: I used "alter system set nls_sort = binary_ci scope = spfile" to change the default value of the parameter nls_sort.Then I restarted the service of the database instance.I saw the instance value has changed.Now the problem is when I create a new connection the value of nls_sort was not binary_ci but binary.I don't know why the session value was not changed. any advice will be appreciated! Thanks a lot Jack.Lee Instance settings can be, and usually are, overridden by session specific values. Oracle always sends a series of alter session statements immediately after logon. Those can be changed by setting a registry string value in the correct hive for Windows, or by setting an environment variable on Unix in your .profile. You can also use an execute immediate statement in an after logon database trigger. Hth -- Sybrand Bakker Senior Oracle DBA |
Thank u very much!
Jack.Lee
#14
| |||
| |||
|
|
On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjack... (AT) gmail (DOT) com wrote: I used "alter system set nls_sort = binary_ci scope = spfile" to change the default value of the parameter nls_sort.Then I restarted the service of the database instance.I saw the instance value has changed.Now the problem is when I create a new connection the value of nls_sort was not binary_ci but binary.I don't know why the session value was not changed. any advice will be appreciated! Thanks a lot Jack.Lee Instance settings can be, and usually are, overridden by session specific values. Oracle always sends a series of alter session statements immediately after logon. Those can be changed by setting a registry string value in the correct hive for Windows, or by setting an environment variable on Unix in your .profile. You can also use an execute immediate statement in an after logon database trigger. Hth -- Sybrand Bakker Senior Oracle DBA |
Thank u very much!
Jack.Lee
#15
| |||
| |||
|
|
On Mon, 23 Jun 2008 01:59:37 -0700 (PDT), gzjack... (AT) gmail (DOT) com wrote: I used "alter system set nls_sort = binary_ci scope = spfile" to change the default value of the parameter nls_sort.Then I restarted the service of the database instance.I saw the instance value has changed.Now the problem is when I create a new connection the value of nls_sort was not binary_ci but binary.I don't know why the session value was not changed. any advice will be appreciated! Thanks a lot Jack.Lee Instance settings can be, and usually are, overridden by session specific values. Oracle always sends a series of alter session statements immediately after logon. Those can be changed by setting a registry string value in the correct hive for Windows, or by setting an environment variable on Unix in your .profile. You can also use an execute immediate statement in an after logon database trigger. Hth -- Sybrand Bakker Senior Oracle DBA |
Thank u very much!
Jack.Lee
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.