Skip to main content

 

 

 

 

Template:OutSystems/Documentation_KB/Breadcrumb_New_Layout

 

 

Template:OutSystems/OSLanguageSwitcher

 

 

 

OutSystems

Platform Tab in Oracle

Template:OutSystems/Documentation_KB/ContentCollaboration
  • Edit
    Collaborate with us
    Edit this page on GitHub
  • In the Platform tab, once you set the Database Provider property to Oracle, the following configurations become available.

    Database section

    This area contains general configurations for the Oracle database.

    Configuration Description Default value
    Naming Method The method to connect to the Oracle database server. Service Name
    Host The hostname or IP address to the database server.
    This option is only available when the 'Naming Method' is set to 'Service Name'.
    localhost
    Port The port on which the database service listens.
    This option is only available when the 'Naming Method' is set to 'Service Name'.
    1521
    Service Name The Oracle database service name.
    This option is only available when the 'Naming Method' is set to 'Service Name'.
    TNS Name An address name defined in the tnsnames.ora configuration file.
    This option is only available when the 'Naming Method' is set to 'TNS Name'.

    For advanced settings, click on the Advanced Settings link.

    Configuration Description Default value
    Advanced Connection Settings
    Runtime Applications Allows you to configure the behavior of database connections when used by OutSystems applications at runtime.
    OutSystems Services Allows you to configure the behavior of database connections when used by OutSystems services.
    Error Messages Language Allows you to set the NLS_LANGUAGE setting when connecting to your database.
    Check the Oracle documentation to learn what are the supported values.
    Linguistic Sorting Allows you to set the NLS_SORT parameter. Choose one of the following values:
    BINARY_AI – Collation-sensitive SQL operations use a binary sort that is accent-insensitive and case-insensitive.
    BINARY_CI – Collation-sensitive SQL operations use a binary sort that is case-insensitive, but accent-sensitive. Using this value can help prevent issues in languages where accents are relevant for SQL operations. For example, in Japanese "Seto" (セト) and "Zeto" (ゼト) would both be valid query results for the "セト" search when using the BINARY_AI linguistic sort.
    BINARY_AI
    Default Query Timeout Defines the default maximum time (in seconds) the platform waits for query execution (since establishing the database connection). 30
    1-Click Publish
    Database Update Query Timeout Defines the default maximum time (in seconds) the platform waits for query execution in a 1-Click Publish operation (since establishing the database connection). 600

    OutSystems supports Unicode for Oracle databases. To start developing with support for Unicode you need to ensure that your Oracle database is using the AL32UTF8 database character set.

    Administrator section

    The Administrator section allows you to configure the database user that manages the platform. This user owns the OutSystems metamodel tables, views, and indexes.

    Configuration Description Default value
    User Name of the user that's the owner of OutSystems metamodel tables. OSADMIN
    Password Password for the user.
    Tablespace Table space holding system tables. OSSYS
    Index Tablespace Table space holding all indexes of the platform. OSIDX

    Runtime section

    In this section you specify the login for the user that owns user tables.

    Configuration Description Default value
    User Name of the user that's the owner of tables created in the development environment. OSRUNTIME
    Password Password for the user.
    Tablespace Table space holding the tables created in the development environment. OSUSR

    Create/Upgrade Database button

    To create all the database objects (tables, indexes, views, etc) the platform requires, click Create/Upgrade Database.

    This button creates all necessary database objects (tables, indexes, views, stored procedures, etc) to run the Platform Server version you're installing.

    To install or upgrade OutSystems, follow the installation checklist.

    • Was this article helpful?