Oracle® Business Intelligence Server Administration Guide > Completing Setup and Managing Oracle BI Repository Files > Process of Completing the Setup for a Repository File >

Add an Entry in the NQSConfig.INI File


After you build a repository and it is consistent, you need to add an entry in the NQSConfig.INI file for the repository. The entry allows the Oracle BI Server to load the repository into memory upon startup. Therefore, if you want your changes to take effect immediately, restart the Oracle BI Server. The NQSConfig.INI file is located in the following location:

[drive path]:\OracleBI\Config\

If errors occur in the file, you might not be able to restart the server. You can review the log messages in the log (NQServer.log) at the following location:

[drive path]:\OracleBI\server\Log\

For organizations that use Oracle Application Server, Oracle recommends that you use Oracle Application Server Control to modify configuration files. For organizations that use other application servers, Oracle recommends that you use JConsole. For more information, see Oracle Business Intelligence Infrastructure Installation and Configuration Guide.

CAUTION:  Although you can use an editor such as Windows Notepad, it's not recommended.

To add an entry in the NQSConfig.INI file

  1. Open the NQSConfig.INI file in an editor such as Notepad.
  2. In the repository section, add an entry for your new repository in this format:

    logical_name = repository_file_name ;

    For example, if the repository file is named northwind.rpd and the logical name you assign it is star, the entry will read as follows:

    star = northwind.rpd ;

    One of the repositories should be specified as the default and using the same repository name, the entry would read as follows:

    star = northwind.rpd, default;

    The logical name is the name end users have to configure when configuring a DSN in the Oracle BI ODBC setup wizard. Filenames consisting of more than a single word should be enclosed in single quotes. Save the configuration file after adding the entry. For more information about the NQSConfig.INI file, refer to Oracle Business Intelligence Infrastructure Installation and Configuration Guide.

  3. Save the file and restart the Oracle BI Server.

    For more information, see Starting the Oracle BI Server.

Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.