Policy Server Oracle Server Wire Protocol configuration

book

Article ID: 32766

calendar_today

Updated On:

Products

CA Single Sign On Secure Proxy Server (SiteMinder) CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On SITEMINDER CA Single Sign On Federation (SiteMinder)

Issue/Introduction

 

When configuring an ODBC Data Source on a UNIX OS to connect to an
Oracle ODBC Data Source, the 'oraclewire.ini' data source template is
used to configure the 'system_odbc.ini' file.  The template files are
located in <Siteminder_home>/db.

The 'oraclewire.ini' data source template is a basic template.

Sample :

  [ODBC Data Sources]
  SiteMinder Data Source=DataDirect 7.1 Oracle Wire Protocol

  [SiteMinder Data Source]
  Driver=/opt/CA/siteminder/odbc/lib/NSora27.so
  Description=DataDirect 7.1 Oracle Wire Protocol
  HostName=nete_servername
  PortNumber=1521
  ServiceName=nete_serverid
  #SID=nete_serverid
  CatalogOptions=0
  ProcedureRetResults=0
  EnableDescribeParam=0
  EnableStaticCursorsForLongData=0
  ApplicationUsingThreads=1
  DMCleanup=2
  EnableTimestampWithTimeZone=1

The sample Data Source information includes the basic attributes
necessary to establish a connection to the database. Any additional
features or settings supported by the ODBC server would require that
the appropriate attribute be manually added to the Data Source.

 

Resolution

 

This is a list of all of the available Data Source attributes on the
SQL Wire Protocol driver for Oracle ODBC.

  AccountingInfo=
  Action=
  AlternateServers=
  ApplicationName=  
  ApplicationUsingThreads=1
  ArraySize=60000
  AuthenticationMethod=1
  BulkBinaryThreshold=32
  BulkCharacterThreshold=-1
  BulkLoadBatchSize=1024
  BulkLoadFieldDelimiter=
  BulkLoadOptions=0
  BulkLoadRecordDelimiter=
  CachedCursorLimit=32
  CachedDescLimit=0
  CatalogIncludesSynonyms=1
  CatalogOptions=0
  ClientHostName=
  ClientID=
  ClientUser=  
  ConnectionReset=0  
  ConnectionRetryCount=0
  ConnectionRetryDelay=3
  CryptoProtocolVersion=
  DataIntegrityLevel=0
  DataIntegrityTypes=
  DefaultLongDataBuffLen=1024
  DescribeAtPrepare=0  
  Description=
  Driver=C:\\Program Files (x86)\\CA\\siteminder\\bin\\NSORA27.DLL
  EditionName=
  EnableBulkLoad=0
  EnableDescribeParam=0
  EnableNcharSupport=0
  EnableScrollableCursors=1
  EnableServerResultCache=0  
  EnableStaticCursorsForLongData=0
  EnableTimestampWithTimeZone=0
  EncryptionMethod=0
  EncryptionLevel=0
  EncryptionTypes=
  ExtendedOptions=
  FailoverGranularity=0
  FailoverMode=0
  FailoverPreconnect=0
  FetchTSWTZasTimestamp=0
  GSSClient=native
  HostName=
  HostNameInCertificate=
  InitializationString=
  KeepAlive=0  
  KeyPassword=  
  KeyStore=
  KeyStorePassword=
  LoadBalanceTimeout=0
  LoadBalancing=0
  LocalTimeZoneOffset=
  LockTimeOut=-1
  LoginTimeout=15  
  LogonID=
  MaxPoolSize=100
  MinPoolSize=0
  Module=  
  Pooling=0
  PortNumber=
  ProcedureRetResults=0
  ProgramID=  
  QueryTimeout=0
  ReportCodepageConversionErrors=0
  ReportRecycleBin=0
  ServerName=
  ServerType=0
  ServiceName=
  SID=
  TimestampEscapeMapping=0  
  TNSNamesFile=
  TrustStore=
  TrustStorePassword=
  UseCurrentSchema=1
  ValidateServerCertificate=1
  WireProtocolMode=2

NOTE: The attributes in the example (above) reflect the hardcoded,
default values. Adding the attribute and modifying the value will
override the default value with the user-designated value.