You can use ODP. Net to implement. net programs to access the database as sysdba.

Source: Internet
Author: User
Oracle ODP. NET database access connection string

Connection string attribute

Default Value Description
Connection lifetime 0 Maximum life time (in seconds) of the connection when the database connection is returned to the connection pool, its creation time will be compared with the current time. If the time exceeds the time specified by the connection lifetime, it will be released. If the value is 0, it is considered as the maximum connection time.
Connection timeout 15 Maximum time (in seconds) to wait for a free connection from the pool
Data Source Empty string Oracle Net service name that identifies the database to connect
DBA privilege Empty string Administrative privileges: sysdba or sysoper
Decr pool size 1 Controls the number of connections that are closed when an excessive amount of established connections are unused
Enlist True Enables or disables Serviced components to automatically enlist in distributed transactions when this value is true, all existing database connections in the pool will be added to the transaction context of its creation thread. If the transaction context does not exist, no changes are made.
Incr pool size 5 Controls the number of connections that are established when all the connections in the pool are used
Max pool size 100 Maximum number of connections in a pool
Min pool size 1 Minimum number of connections in a pool
Password Empty string Password for the user specified by user ID
Persist Security info False Enables or disables the retrieval of password in the connection string
Pooling True Enables or disables Connection Pooling
Proxy user ID Empty string User Name of the proxy user
Proxy Password Empty string Password of the proxy user
User ID Empty string Oracle user name

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.