Notices: This section not yet converted to new layout. Download stats are rolling back out.

test-oracleconnect.powershell (Install)

0.1.0

Package test results are passing.

This package was approved by moderator dtgm on 5/8/2016.

Installs Powershell script test-oracleconnect.ps1 which can be used for testing Oracle connectivity.

Install

choco install test-oracleconnect.powershell

To install test-oracleconnect.powershell (Install), run the following command from the command line or from PowerShell:

C:\> choco install test-oracleconnect.powershell

To upgrade test-oracleconnect.powershell (Install), run the following command from the command line or from PowerShell:

C:\> choco upgrade test-oracleconnect.powershell

Files

Hide
  • tools\chocolateyinstall.ps1 Show
    $ErrorActionPreference = "Stop"
    $packageName = 'test-oracleconnect.powershell'
    $version = "0.1.0"
    
    $psFile = Join-Path $(Split-Path -parent $MyInvocation.MyCommand.Definition) "test-oracleconnect.ps1" 
    Install-ChocolateyPowershellCommand $packageName $psFile
  • tools\test-oracleconnect.ps1 Show
    #######################
    <#
    .SYNOPSIS
    Tests Oracle Connections using odp.net2, odp.net4, oledb, odbc, odp.netmanaged, ldap, or all
    .DESCRIPTION
    The test-oracleConnect.ps1 tests Oracle connections using odp.net2, odp.net4, oledb, odbc, odp.netmanaged, ldap or all
    .EXAMPLE
    ./test-oracleconnect.ps1 -UserId scott -Password tiger - DataSource HR -Test all
    .NOTES
    Version History
    v1.0   - Chad Miller - 11/27/2015 - Initial release
    v2.0   - Chad Miller - 03/30/2016 - Added LDAPServer param/Remove ManagedDriverdll path
    #>
    [CmdletBinding()]
        param(
        [Parameter(Mandatory=$true)]
        [string]$UserId,
        [Parameter(Mandatory=$true)]
        [string]$Password,
        [Parameter(Mandatory=$true)]
        [string]$DataSource,
        [Parameter(Mandatory=$false)] 
        [ValidateSet("all","odp.net2","odp.net4","oledb","odbc","odp.netmanaged","ldap")]
        [string[]]$Test = ("all","odp.net2","odp.net4","oledb","odbc","odp.netmanaged","ldap"),
        #Full Path to Oracle.ManagedDataAccess.dll
        [Parameter(Mandatory=$false)]
        [string]$ManagedDriverDll,
        [Parameter(Mandatory=$false)]
        #LDAPServer:portnumber
        [string[]]$LDAPServer
    )
    
    
    $all = @("odp.net2","odp.net4","oledb","odbc","odp.netmanaged","ldap")
    
    #######################
    function Test-odp.net2 {
    
        try {
            add-type -AssemblyName "Oracle.DataAccess, Version=2.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"
            $conn = New-Object Oracle.DataAccess.Client.OracleConnection("User Id=$UserId;Password=$Password;Data Source=$DataSource")
            $conn.open()
            New-Object psobject -property @{Test="Test-odp.net2";Args="$DataSource";Result=$true;Message=$null}
        }
        catch { new-object psobject -property @{Test="Test-odp.net2";Args="$DataSource";Result=$false;Message="$($_.ToString())"} }
        finally { $conn.Dispose() }
    
    } #Test-odp.net2
    
    #######################
    function Test-odp.net4 {
    
        try {
            add-type -AssemblyName "Oracle.DataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342"
            $conn = New-Object Oracle.DataAccess.Client.OracleConnection("User Id=$UserId;Password=$Password;Data Source=$DataSource")
            $conn.open()
            New-Object psobject -property @{Test="Test-odp.net4";Args="$DataSource";Result=$true;Message=$null}
        }
        catch { new-object psobject -property @{Test="Test-odp.net4";Args="$DataSource";Result=$false;Message="$($_.ToString())"} }
        finally { $conn.Dispose() }
    
    } #Test-odp.net4
    
    #######################
    function Test-oledb {
    
        try {
            $conn = New-Object System.Data.OleDb.OleDbConnection("User Id=$UserId;Password=$Password;Data Source=$DataSource;Provider=OraOLEDB.Oracle")
            $conn.open()
            New-Object psobject -property @{Test="Test-oledb";Args="$DataSource";Result=$true;Message=$null}
        }
        catch { new-object psobject -property @{Test="Test-oledb";Args="$DataSource";Result=$false;Message="$($_.ToString())"} }
        finally { $conn.Dispose() }
    
    } #Test-oledb
    
    #######################
    function Test-odbc {
    
        try {
            $conn = New-Object System.Data.Odbc.OdbcConnection("DRIVER={Oracle ODBC Driver};UID=$UserId;PWD=$Password;DBQ=$DataSource;DBA=R;")
            $conn.open()
            New-Object psobject -property @{Test="Test-odbc";Args="$DataSource";Result=$true;Message=$null}
        }
        catch { new-object psobject -property @{Test="Test-odbc";Args="$DataSource";Result=$false;Message="$($_.ToString())"} }
        finally { $conn.Dispose() }
    
    } #Test-odbc
    
    #######################
    function Test-odp.netmanaged {
    
        try {
            Add-Type -Path "$ManagedDriverDll"
            $conn = New-Object Oracle.ManagedDataAccess.Client.OracleConnection("User Id=$UserId;Password=$Password;Data Source=$DataSource")
            $conn.open()
            New-Object psobject -property @{Test="Test-odp.netmanaged";Args="$DataSource";Result=$true;Message=$null}
        }
        catch { new-object psobject -property @{Test="Test-odp.netmanaged";Args="$DataSource";Result=$false;Message="$($_.ToString())"} }
        finally { $conn.Dispose() }
    
    } #Test-odp.netmanaged
    
    #######################
    function Test-ldap {
    
        try { 
            Add-Type -AssemblyName System.DirectoryServices.Protocols
    
            #Use LDAP servers from ldap.ora if LDAPServer param not specified
            if ($LDAPServer -eq $null) {
                $ht = gc "$((get-itemproperty -path 'HKLM:\SYSTEM\CurrentControlSet\Control\Session Manager\Environment' -Name TNS_ADMIN).TNS_ADMIN)\ldap.ora" |
                foreach { $_ -replace '\(|\)' } | ConvertFrom-StringData
                $LDAPServer = $ht.DIRECTORY_SERVERS -replace ' ' -split ','
            } 
        
            $LDAPServer | foreach {
                    try {
                        $name=$_; $conn = New-Object System.DirectoryServices.Protocols.LdapConnection($name)
                        $conn.AuthType = [System.DirectoryServices.Protocols.AuthType]::Anonymous
                        $conn.Bind()
                        new-object psobject -property @{Test="Test-ldap";Args="$name";Result=$true;Message=$null}
                    }
                    catch { new-object psobject -property @{Test="$($PSCmdlet.MyInvocation.MyCommand.Name)";Args="$name";Result=$false;Message="$($_.ToString())"}  }
                    finally { $conn.Dispose() }
            }
        }
        catch { new-object psobject -property @{Test="Test-ldap";Args=$null;Result=$false;Message="$($_.ToString())"}  }
    
    } #Test-ldap
    
    #######################
    # Run Tests 
    #######################
    
    if ($Test -contains "all") {
         $all | foreach { invoke-expression "Test-$_" }
    }
    else {
        foreach ($t in $Test) {
            invoke-expression "Test-$t"
        }
    }
    

Virus Scan Results

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.

Dependencies

This package has no dependencies.

Package Maintainer(s)

Software Author(s)

  • Chad Miller

Tags

Version History

Version Downloads Last updated Status

Discussion for the test-oracleconnect.powershell (Install) Package

Ground rules:

  • This discussion is only about test-oracleconnect.powershell (Install) and the test-oracleconnect.powershell (Install) package. If you have feedback for Chocolatey, please contact the google group.
  • This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
  • The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
  • Tell us what you love about the package or test-oracleconnect.powershell (Install), or tell us what needs improvement.
  • Share your experiences with the package, or extra configuration or gotchas that you've found.
  • If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.

comments powered by Disqus
Chocolatey.org uses cookies to enhance the user experience of the site.
Ok