|
|
This appendix contains important information and instructions for changing from the flatfile data store to an Oracle database and vice versa.
To change from a flatfile data store to an Oracle database, follow the instructions in the following sections.
![]() | Caution This procedure creates a number of .dat files in the directory and might erase any current files in the directory with the same name. Make sure you have made backup copies of your .dat files before performing these steps. |
To migrate existing data to the Oracle database:
Step 1 Start the graphical user interface (GUI).
Step 2 In the General window, click Export.
The following prompt displays:
Directory to export to:
Step 3 Enter the full path to which to export the flatfile data store and click OK. CiscoSecure Global Roaming Server (GRS) places the data files in the directory.
Before you switch files, follow these steps to set the environment variables:
Step 1 Exit the GUI.
Step 2 From the command line, set the environment variables as follows:
ORACLE_HOME=directory ORACLE_SERVER=dbServer
where directory is the name of the directory in which Oracle is installed and dbServer is the name of the server on which Oracle is installed.
To change data stores using the GUI, follow these steps:
Step 1 Start the GUI.
Step 2 In the tree, click Properties.
Step 3 Click the Data Store tab.
Step 4 From the Data Store drop-down menu, click Oracle.
If Oracle is grayed out in the drop-down menu, repeat the steps in the section "Setting Environment Variables."
Step 5 Enter the username and password you use to log in to Oracle. The database directory and server information is filled in automatically. If this information is incorrect, repeat the steps in the section "Setting Environment Variables."
Step 6 Click Commit. The tree refreshes to reflect the information in the new Oracle database. If there is no local domain configured in the Oracle database, the Express Setup Wizard opens. See the "Express Setup Wizard" section for instructions.
To change data stores manually, follow these steps to complete the process.
Step 1 Edit the $GRSHOME/etc/grs.ini file and modify the following information in the [Database] section:
Step 2 Edit $GRSHOME/etc/.odbc.ini file and modify the following information:
Step 3 Edit $GRSHOME/etc/grs.sh file to add the following environment variables:
Step 4 Restart CiscoSecure GRS.
To change from an Oracle database to the flatfile data store, follow these steps:
Step 1 Start the GUI.
Step 2 In the tree, click Properties.
Step 3 Click the Data Store tab.
Step 4 From the Data Store drop-down menu, click Flatfile.
Step 5 Click Commit. The tree refreshes to reflect the information in the new Oracle database. If there is no local domain configured in the Oracle database, the Express Setup Wizard opens. See the "Express Setup Wizard" section for instructions.
Step 6 Restart CiscoSecure GRS.
The following example shows the type of information stored in the data store domains. The information in your own data store will be slightly different.
corporation.us MaxSessions: 10 RetryTimeout: 10 Number of Retries: 3 Add domain for Accounting: OFF Stripping Flags: Authen-false Author-false Acct-false Strip String: us Access Control Server (ACS) IpAddress Secret AuthenPort AcctPort --------------------------------------------------------------- 10.0.0.1 secret 1026 49
IP Pool/Address Checking: OFF _LOCAL_ACS_ MaxSessions: 5 RetryTimeout: 30 Number of Retries: 3 Add domain for Accounting: OFF Stripping Flags: Authen-true Author-true Acct-true Strip String: _LOCAL_ACS_ Network Access Servers (NAS) Name Secret Vendor/Protocol Type ___________________________________________________________________ 10.0.0.2 secret CSCO-T _DEFAULT_RADIUS_NAS_ secret CSCO-R
![]()
![]()
![]()
![]()
![]()
![]()
![]()
Posted: Wed Feb 24 12:10:07 PST 1999
Copyright 1989-1999©Cisco Systems Inc.