Exemplos de conexão Oracle

Owned by Tiago Alex dos Santos (Unlicensed)
Last updated: Nov 07, 2023 by Ezequiel de Lima
1 min read

Conexão pelo Serviço do Oracle, normalmente usado no Oracle cloud devido instalação do client no ambiente.

[AGRO_IMPLANTACAO] Database=TESTE User_Name=VIASOFT Password= DriverName=DevartOracle DriverUnit=DBXDevartOracle DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver210.bpl MetaDataPackageLoader=TDBXDevartOracleMetaDataCommandFactory,DbxDevartOracleDriver210.bpl ProductName=DevartOracle GetDriverFunc=getSQLDriverORA LibraryName=dbexpoda40.dll VendorLib=C:\app\client64\primedb\product\19.0.0\client_1\bin\oci.dll MaxBlobSize=-1 LocaleCode=0000 Oracle TransIsolation=ReadCommitted RoleName=Normal LongStrings=True EnableBCD=false UseQuoteChar=False CharLength=0 UseUnicode=False UnicodeEnvironment=False IPVersion=IPv4 BlobSize=-1 ErrorResourceFile= HostName= Execute01=ALTER SESSION SET NLS_LANGUAGE = "BRAZILIAN PORTUGUESE" Execute02=ALTER SESSION SET NLS_TERRITORY = BRAZIL Execute03=ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY' Execute04=ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'

 

Conexão por SID, normalmente usado com instalação locais em Windows:

[AGROTITAN] DriverName=DevartOracleDirect Hostname=127.0.0.1:1521:ORCL2 RoleName=Normal User_Name=VIASOFT Password= CharSet=WE8ISO8859P1 BlobSize=-1 ErrorResourceFile= LocaleCode=0000 Oracle TransIsolation=ReadCommitted GetDriverFunc=getSQLDriverORADirect LibraryName=dbexpoda40.dll VendorLib=dbexpoda40.dll EnableBCD=False DriverUnit=DBXDevartOracle DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver240.bpl MetaDataPackageLoader=TDBXDevartOracleMetaDataCommandFactory,DbxDevartOracleDriver240.bpl ProductName=DevartOracle MaxBlobSize=-1 LongStrings=True UseQuoteChar=False CharLength=0 UseUnicode=False UnicodeEnvironment=False IPVersion=IPv4 Execute01=ALTER SESSION SET NLS_LANGUAGE = "BRAZILIAN PORTUGUESE" Execute02=ALTER SESSION SET NLS_TERRITORY = BRAZIL Execute03=ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY' Execute04=ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,' Execute05=ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'MM/DD/RR HH24:MI:SSXFF' Execute06=ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'MM/DD/YYYY HH24:MI:SSXFF TZR'

 

Conexão DF-e por SID, pode ser utilizado para a conexão do Server Agro também, caso a anterior não se adeque.

[IMPLANTACAO] DriverName=DevartOracleDirect Hostname=127.0.0.1:1521:ORCL User_Name=VIASOFT Password=330370080971721821921721821921721821921721821921721821921721821921721821921620580960470881921721821921721821921721821921721821921721821921721821921721720250 DriverUnit=DBXDevartOracle GetDriverFunc=getSQLDriverORADirect LibraryName=dbexpoda40.dll VendorLib=C:\app\client64\PC\product\19.0.0\client_1\bin\oci.dll BlobSize=-1 LocaleCode=0000 Oracle TransIsolation=ReadCommitted ProductName=DevartOracle IPVersion=IPv4 DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver240.bpl MetaDataPackageLoader=TDBXDevartOracleMetaDataCommandFactory,DbxDevartOracleDriver240.bpl CharSet=WE8ISO8859P1 ErrorResourceFile= UnicodeEnvironment=False UseQuoteChar=False UseUnicode=False EnableBCD=False Execute01=ALTER SESSION SET NLS_LANGUAGE = "BRAZILIAN PORTUGUESE" Execute02=ALTER SESSION SET NLS_TERRITORY = BRAZIL Execute03=ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY' Execute04=ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'