Python Connector for Oracle

Connection parameters - Python Connector for Oracle

Connection parameters

The following table describes Oracle connection parameters you can use in the connect() module method.

Parameter Description

Direct

Enables the Direct mode. The possible values are True and False. The default value is False.

Host

The name or IP address of the database instance

HomeName

The location of the Oracle client on the user's machine. This parameter is available when Direct is False.

Port

The port number. The default value is 1521.

ServiceName

The name by which the client connects to the database instance. This parameter is available when Direct is True.

SID

The System Identifier (SID) of the database instance. This parameter is available when Direct is False.

UserName

The name of the database user

Password

The password of the database user

ConnectMode

The system privilege for the user who connects to the database instance. The privilege must be granted to the user before connecting to the instance.

The possible values are:

  • Normal – (Default) Connect as a normal user.
  • SysOper – Connect with the SysOper privilege.
  • SysDBA – Connect with the SysDBA privilege.
  • SysASM – Connect with the SysASM privilege.
  • SysBkp – Connect with the SysBkp privilege.
  • SysDG – Connect with the SysDG privilege.
  • SysKM – Connect with the SysKM privilege.

Schema

The schema search path

PoolId

The ID of a connection pool that will be used for a particular connection

DisablePooling

Disables connection pooling for a particular connection.

The possible values are True and False. The default value is False.

© 2022-2025 Devart. All Rights Reserved. Request Support Python Connectors Forum Provide Feedback