Previous Topic

Next Topic

Book Contents

Book Index

Oracle

Using Oracle requires that you first configure Oracle itself, establish the database, and create Oracle users. VSys One will automatically create the empty tables within your database the first time it starts up.

Linked Graphic

Field name

Description

Use Oracle's OCI drivers

VSys One can use its own direct drivers to connect to Oracle, which bypasses the need for installing Oracle's proprietary client. If this option is checked, VSys One will use and require Oracle's drivers. (Unless you are having problems, leave this unchecked.)

Server address

(Use Oracle's OCI drivers is unchecked)

Enter the IP address (e.g. 192.168.2.1) or DNS-resolvable name (e.g. vsysdata.myorg.com) of the server which holds your data.

Server address

(Use Oracle's OCI drivers is checked)

Enter the server name known to Oracle in your local Oracle configuration.

User that owns data tables

If the user ID that you log in to Oracle with is not the user that owns the VSys One tables, enter the name of the user that owns the tables here. VSys One will create Oracle synonyms when it starts so that the logged-in user can reference the tables as if it owns them. Leave this blank if the logged-in user is the user that owns the tables.

Oracle instance

Optional – if entered, this should be the name of the specific instance of Oracle to connect to on a machine with multiple instances running.

Oracle port

Optional – if entered, this should be the TCP port on which Oracle is listening for connections. Normally you'd leave this blank.

Default server login ID

When users are prompted to log in to Oracle, this ID will be provided by default.

Default server password

When users are prompted to log in to Oracle, this password will be provided by default.

See Also

Connecting VSys One to a Database

SQL Server

NexusDB