Share this page

# Test database connection to a project (for Oracle environments only)

Available in versions: 2021 R2 and later

## Description

For Oracle environments only: Tests the connection to the database for a specific project.

## URL

Copy code

    /Admin/rest/v1/projects/verifyprojectdbconnection

## Remarks

None

## HTTP Method

POST: Tests a project's connection to the Oracle database server.

## Request

Headers:

Content-Type: application/xml

Accept: application/json, application/xml

Cookies:

ADM_LWSSO={AdmLwssoCookie};

Request Body:

An XML describing the project and other optional details.

The fields in the request are:

Element | Description
--- | ---
SchemaCredentialsDetails | ProjectId. The ID of the project for which the Oracle database connection should be tested (it can be retrieved from the Get Projects REST API). The Lab schema is considered as a particular project with ProjectId=1. Password. The password to use to test the connection in plain text. If null, LoadRunner Enterprise tests the connection with the password currently in use by LoadRunner Enterprise. You can provide a Base64 encrypted value for the password if it is prefixed with “{a3f701a2-475d-4fe3-89f3-cc7db85a272c}:” (without the quotes), and then encrypted with the prefix.

Request Example
Copy code

    <SchemaCredentialsDetails>
        <ProjectId>1038</ProjectId>
        <Password>MyCustomPassword</Password>
    </SchemaCredentialsDetails>

## Response

Headers:

None

Cookies:

None

HTML Return Code:

One of the HTTP Return Codes.

HTML Body:

Returns data on the database connection.

## See Also

Get all Projects
Create a project
Get or update project by project ID
Get projects by Query
Remove Projects
Update database connection to a project (for Oracle environments only)

Tips to improve your search results... LoadRunner Enterprise Administration REST API Reference LRE Admin REST API All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic(Undefined variable: _rscC_Basic_Variables.VersionLabel)