Creating an Empty Admin Database
After installing FlexNet Manager for Engineering Applications Admin for the first time, you must create a FlexNet Manager for Engineering Applications Admin database. For this procedure, you need the user name and password of an administrative user in the DBMS who has privileges to create a database. Parameters that you supplied using the Admin Configurator are also used.
Important:The scripts that create the Admin database and its tables will create a completely new database. As a result, any data in an existing database of the same name will be lost when you run the scripts.
To create the Admin database:
| 1. | If FlexNet Manager for Engineering Applications Admin is running, stop the server. It cannot be running when you run the command (loaddb) to create the database. |
You can stop FlexNet Manager for Engineering Applications Admin from the command line (see the section, {Hyperlink}Stopping the Admin Server from the Command Line{Default ¹ Font} on page {Hyperlink}1{Default ¹ Font}) or, if you configured the Admin server to run as a Windows service, you can stop the service from the Windows Services pane.
| 2. | Start the database server if it is not already running. Refer to documentation provided by the database server vendor for information about starting and configuring the database. |
Note:Ensure that the user who starts the database server has the same locale as the user who creates the database. See the section, User Account Requirements (for Installing and Using FlexNet Manager for Engineering Applications), in Prerequisites for Installing FlexNet Manager for Engineering Applications.
| 3. | If you are using an Oracle database, a tablespace of the name specified during installation in the Admin Configurator must be created before proceeding to the next step. See the section, Configuring Oracle, in Configuring Database Servers for FlexNet Manager for Engineering Applications for guidelines. |
| 4. | At the command line, change to the admin_install_directory and run the following command: |
flexnet loaddb
| 5. | To create the FlexNet database and to add the FlexNet database user, you must initially connect to the DBMS as a database administrator. When prompted, enter the name and password of the database administrative user. Depending on the database, the sa (MS SQL Server) , system (Oracle) or postgres (PostgresSQL) user account will be required to run flexnet loaddb. |
The script drops the database (if it exists), creates the database, creates tables, adds the FlexNet database user, adds a FlexNet Manager for Engineering Applications Admin user, and adds configuration data.
When the FlexNet database is created, the following FlexNet Manager for Engineering Applications Admin user is created automatically and assigned the system administrator role:
| • | User Name: admin |
| • | Password: admin |