对于想了解带有allowCustomSqlDatabase=“true”的ASP.NETSessionState不会调用指定的数据库的读者，本文将是一篇不可错过的文章，并且为您提供关于HowToSet

对于想了解带有allowCustomSqlDatabase =“true”的ASP.NET SessionState不会调用指定的数据库的读者，本文将是一篇不可错过的文章，并且为您提供关于 How To Set a NLS Session Parameter At Database Or Schema Level For All Connections?、./runInstaller: line 97: /home/oracle/database/install/.oui: Permission denied、.net – 为什么在使用带有AutoGenerateColumns =“True”的DataGrid时会忽略DataAnnotations、Application log save debug - how log data is persisted to database table的有价值信息。

• 带有allowCustomSqlDatabase =“true”的ASP.NET SessionState不会调用指定的数据库
• How To Set a NLS Session Parameter At Database Or Schema Level For All Connections?
• ./runInstaller: line 97: /home/oracle/database/install/.oui: Permission denied
• .net – 为什么在使用带有AutoGenerateColumns =“True”的DataGrid时会忽略DataAnnotations
• Application log save debug - how log data is persisted to database table

带有allowCustomSqlDatabase =“true”的ASP.NET SessionState不会调用指定的数据库

<sessionState allowCustomsqlDatabase="true" mode="sqlServer" sqlConnectionString="Data Source=MysqLservername;Initial Catalog=DR_ASPState;Integrated Security=true;Connect Timeout=15;" />

SELECT @appId = AppId
FROM [ASPState].dbo.ASPStateTempApplications
WHERE AppName = @appName

declare @p2 int
set @p2=NULL
exec dbo.TempGetAppID @appName='/LM/W3SVC/10/ROOT',@appId=@p2 output
select @p2

SELECT @appId = AppId
FROM [ASPState].dbo.ASPStateTempApplications
WHERE AppName = @appName

aspnet_regsql.exe -S *servername* -E -ssadd -sstype c –d DR_ASPState

How To Set a NLS Session Parameter At Database Or Schema Level For All Connections?

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=335038610424309&parent=DOCUMENT&sourceId=115001.1&id=251044.1&_afrWindowMode=0&_adf.ctrl-state=eqr5gy0az_53

APPLIES TO:
Oracle Database - Enterprise Edition - Version 8.0.3.0 to 11.2.0.3 [Release 8.0.3 to 11.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.
PURPOSE
How to define some NLS session parameters for all clients, regardless of the used NLS_LANG (or other NLS parameter) setting on the client side

SCOPE
Anyone who want to control NLS settings from the server side.

DETAILS
Why to set a NLS session parameter at Database or Schema level for all connections?
The client side NLS setting will override the instance NLS settings like documented in Note 241047.1 The Priority of NLS Parameters Explained.

So you have no "server side" control on the used NLS session settings as they are derived from the client side.

However, if you like to overwrite some NLS session parameters for all clients, regardless of the used NLS_LANG (or other NLS parameter) setting on the client side then you can do that, for most environments, in the way described in this note.
Please note that:

* Oracle recommends you to define always the (correct) NLS_LANG.
The <characterset> part of the NLS_LANG is a (very important) client only parameter and cannot be set or defined from server side for a session.
Why this is so important is documented in Note 158577.1 and note 179133.1

* This is *not* working for some JDBC drivers , see Note 115001.1 NLS_LANG Client Settings and JDBC Drivers
And may also not work for other 3the party connection methods,if the connector issues from the driver itself alter sessions after the logon procedure of Oracle is done then they will override the trigger.

* When using a PL/SQL package procedure called by the logon trigger and this has any unhandled exceptions or raises any exceptions, then the logon trigger fails. When the logon trigger fails, the logon fails, that is, the user is denied permission to log in to the database

* We do NOT recommend to have several "after logon" triggers, for setting NLS parameters seen the execution order may differ. See Note 121196.1 Fire Sequence of Database Triggers
How to set a NLS session parameter at database level for all connections ?
Create an event trigger like this:
(Example for the NLS_TIMESTAMP_TZ_FORMAT parameter)

CREATE OR REPLACE TRIGGER sys.global_nls_session_settings AFTER LOGON ON DATABASE
BEGIN
execute immediate ''alter session set NLS_TIMESTAMP_TZ_FORMAT =''''DD/MM/YYYY HH24:MI:SS TZR TZD'''''';
END;
/
How to set a NLS session parameter at schema level for all connections ?
You can also create a logon trigger for one schema:
(Example for the NLS_DATE_FORMAT and NLS_NUMERIC_CHARACTERS parameter for the scott schema)
CREATE OR REPLACE TRIGGER sys.schema_nls_session_settings AFTER LOGON ON SCOTT.SCHEMA
BEGIN
execute immediate ''alter session set NLS_DATE_FORMAT=''''DD/MM/YYYY HH24:MI:SS'''''';
execute immediate ''alter session set NLS_NUMERIC_CHARACTERS=''''.,'''''';
END;
/
What NLS parameters can be set using logon triggers?
The parameters which can be set like this, are all the NLS parameters you can do an alter session for:

8i and up:

NLS_CALENDAR 
NLS_COMP 
NLS_CREDIT 
NLS_CURRENCY 
NLS_DATE_FORMAT 
NLS_DATE_LANGUAGE 
NLS_DEBIT 
NLS_ISO_CURRENCY 
NLS_LANGUAGE 
NLS_LIST_SEPARATOR 
NLS_MONETARY_CHARACTERS 
NLS_NUMERIC_CHARACTERS 
NLS_SORT 
NLS_TERRITORY 
NLS_DUAL_CURRENCY
NLS_TIMESTAMP_FORMAT
NLS_TIMESTAMP_TZ_FORMAT

new in 9i/10g:
NLS_LENGTH_SEMANTICS
NLS_NCHAR_CONV_EXCP
note: NLS_TIME_FORMAT and NLS_TIME_TZ_FORMAT are used internally only and should NOT be set or altered

Again, the client character set CANNOT be set or defined this way.
How to see if there are logon triggers?
This select gives you all defined after logon triggers:

conn / as sysdba
select OWNER, TRIGGER_NAME, TRIGGER_BODY from DBA_TRIGGERS where 
 trim(TRIGGERING_EVENT) = ''LOGON''
/
select OWNER, TRIGGER_NAME, TRIGGER_BODY from DBA_TRIGGERS where 
 upper(TRIGGER_NAME) = ''LOGON_PROC''
/

REFERENCES
NOTE:115001.1 - NLS_LANG Client Settings and JDBC Drivers
NOTE:241047.1 - The Priority of NLS Parameters Explained (Where To Define NLS Parameters)
	
 	
Was this document helpful?
 
 	 	 
 	
Document Details
 
Email link to this documentOpen document in new windowPrintable Page
	
Type:
Status:
Last Major Update:
Last Update:
BULLETIN
PUBLISHED
16-Jul-2015
06-Dec-2016

 	 	 

 	
Related Products
 
	
Oracle Database - Enterprise Edition
Oracle Database - Enterprise Edition
 	 	 
 	
Information Centers
 
			
Information Center: Overview Database Server/Client Installation and Upgrade/Migration [1351022.2]

Index of Oracle Database Information Centers [1568043.2]

インフォメーション・センター: データベースおよび Enterprise Manager 日本語ドキュメント [1946305.2]

Information Center: Overview of Database Security Products [1548952.2]

 	 	 
 	
Document References
 
 	 	 
 	
Recently Viewed
 
	How To Set a NLS Session Parameter At Database Or Schema Level For All Connections? [251044.1]	

	NLS_LANG Client Settings and JDBC Drivers [115001.1]	

	IF: High Requests on dc_rollback_segments [1951703.1]	

	WebLogic Server：使用XA Datasource发生 - 获取“XAER_NOTA：XID无效”异常 [2357599.1]	

	How to Validate Network and Name Resolution Setup for the Clusterware and RAC [1054902.1]	

Show More
 	 	 
Didn''t find what you are looking for?Ask in Community...

 
Related
 
 
Products
 
Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > RDBMS
Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > RDBMS > NLS Conversion issues, Characterset Conversion, Characterset issues (lossy and truncation data)

./runInstaller: line 97: /home/oracle/database/install/.oui: Permission denied

chown -R oracle:install database

chmod -R 755 database

.net – 为什么在使用带有AutoGenerateColumns =“True”的DataGrid时会忽略DataAnnotations

<display(Name:="My Name")>

<displayName("My Name")>

Private Sub OnGeneratingColumn(sender As Object,e As System.Windows.Controls.DataGridAutoGeneratingColumnEventArgs) Handles Grid.AutoGeneratingColumn
    Dim pd As System.ComponentModel.PropertyDescriptor = e.PropertyDescriptor
    e.Column.Header = pd.displayName
End Sub

Public Class modelQ016
    <display(shortname:="DB Name")>
    Public Property dbnAME As String
    ...

Dim pd As System.ComponentModel.PropertyDescriptor = e.PropertyDescriptor
        Dim displayAttrib As System.ComponentModel.DataAnnotations.displayAttribute =
            pd.Attributes(GetType(ComponentModel.DataAnnotations.displayAttribute))
        If Not displayAttrib Is nothing Then
            e.Column.Header = displayAttrib.ShortName
        End If

Application log save debug - how log data is persisted to database table

Created by Jerry Wang, last modified on Jan 05, 2015

Error message 从 application ui 上抛出，

Application 点击 save button 时，call BAL_DB_SAVE 进行 log 的 persistence 处理：

首先将待保存的 log 数据进行压缩：

最后待保存的数据存储在 structure C_S_DB 里：

BALHDR_I 存放的是 header 信息：

BALDAT_I 里存放的是待保存的压缩之后的数据:

在 update function module 里进行 DB update：

OPEN SQL 操作：

更新完毕后，比较 SE16 里和 SLG1 tcode 里的 data：

本文同步分享在 博客 “汪子熙”（CSDN）。
如有侵权，请联系 support@oschina.cn 删除。
本文参与 “OSC 源创计划”，欢迎正在阅读的你也加入，一起分享。

我们今天的关于带有allowCustomSqlDatabase =“true”的ASP.NET SessionState不会调用指定的数据库的分享就到这里，谢谢您的阅读，如果想了解更多关于 How To Set a NLS Session Parameter At Database Or Schema Level For All Connections?、./runInstaller: line 97: /home/oracle/database/install/.oui: Permission denied、.net – 为什么在使用带有AutoGenerateColumns =“True”的DataGrid时会忽略DataAnnotations、Application log save debug - how log data is persisted to database table的相关信息，可以在本站进行搜索。