Oracle Financial Analyzer Installation and Upgrade Guide
Release 11i

Part No. A87523-01
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to beginning of chapter Go the next page

Renaming or Changing the Location of Shared Databases, 3 of 3


Modifying the Configuration File

Introduction

If you rename or move a shared database file, you must edit the system configuration file, ofasyscf.cfg, to reflect the changes you have made. This topic describes the changes that you need to make to the settings in this file.

System configuration file

The [Shared] section of the system configuration file (ofasyscf.cfg)contains the following settings:

[Shared]
SHAREDACCESS= . . .
SHAREDCFGPATH= . . .
SHAREDHOST= . . .
SHAREDPORT= . . .
SHAREDHOSTTYPE= . . .

If you rename or move the shared database files, you need to add settings to this file so that the system can find and access the files under their new names or in their new locations.

Settings to add

The following table lists the settings to add to the ofasyscf.cfg file if you rename or move the shared database files.

Note: When you add settings to the ofasyscf.cfg file, you must match the capitalization exactly as it is shown in this table.

IF you . . .  THEN add this line to the configuration file . . . 

rename the ofas database file, 

OFASNAME=new name of the ofas database. 

move the ofas database from the default SHARED directory, 

OFASPATH=new location of the ofas database. 

rename the ofastask database file, 

OFASTASKNAME=new name of the ofastask database. 

move the ofastask database from the default SHARED directory, 

OFASTASKPATH=new location of the ofastask database. 

rename the ofasctl database file, 

OFASCTLNAME=new name of the ofasctl database. 

move the ofasctl database from the default SHARED directory, 

OFASCTLPATH=new location of the ofasctl database. 

rename the ofaslck database file, 

OFASLCKNAME=new name of the ofaslck database. 

move the ofaslck database from the default SHARED directory, 

OFASLCKPATH=new location of the ofaslck database. 

Example: Renaming the ofas.db database

Configuration that requires the database to be renamed

If your system is configured so that a single instance of Express Server is associated with two or more Administrator workstations (one of which may be a Super administrator workstation), you need to rename the ofas.db database of one of the administrators so that each is known to the Express Server instance by a unique name.

Why a unique database name is required

When the ofas.db database reaches a maximum size of 2GB, Express Server creates an extension file and names it using the shared database name. The default name for this extension file would be ofas.001.

Note: Express Server automatically places the extension file in the directory that you specified in the ExtensionFilePath setting of the File I/O option in the Express Configuration Manager.

If you do not rename one of the ofas.db database files, conflicts can occur within Express Server if extension files become necessary.

Sample procedure: Renaming the ofas.db file

The following sample procedure describes renaming a database file:

  1. Rename the appropriate shared database file.

  2. Edit the appropriate system configuration file and add an OFASNAME setting in the [Shared] section of the file, as shown in the following example.

    [Shared]
    SHAREDACCESS= . . .
    SHAREDCFGPATH= . . .
    SHAREDHOST= . . .
    SHAREDPORT= . . .
    SHAREDHOSTTYPE= . . .
    OFASNAME=ofas1

    For detailed information about editing configuration files, refer to Chapter 4.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Contents
Go To Index
Index