Valid from: Valid from:
Application Component
Application Component VersionVersion ISPA
ISPA Server Server 10.15.2 10.15.2 or or higherhigher ISPA
ISPA Client Client 5.2.0.x 5.2.0.x or or higherhigher ISPA
ISPA Oracle Oracle DBS DBS 11.2.0.111.2.0.1 ISPA
ISPA DB DB 1.2.11.2.1
This document describes the installation and configuration of the ISPA database IDB. This document describes the installation and configuration of the ISPA database IDB.
ISPA Database
ISPA Database
Technical Administration Manual
Technical Administration Manual
1.1
1.1 Purpose Purpose of of this this document document ... ... 44 1.2
1.2 Explanation Explanation of of Symbols Symbols used ...used ... ... 44 1.3
1.3 Additional Documents ... Additional Documents ... ... 44 1.4
1.4 Required Required Installation Installation Media ...Media ... ... 44
2.1
2.1 Requirements Requirements ... 5... 5 2.2
2.2 Preparation Preparation ... 5... 5 2.2.1
2.2.1 Create Create user user group group “ora_dba”“ora_dba” ... 5... 5 2.2.2
2.2.2 Add your administration user to the user group “ora_dba” Add your administration user to the user group “ora_dba” ... ... 66 2.2.3
2.2.3 Restart Restart your your Computer Computer ... ... 66 2.2.4
2.2.4 Create a Create a Network Share Network Share for for Backup (optional) ...Backup (optional) ... ... 66 2.3
2.3 Install Install IDB IDB ... ... 77 2.3.1
2.3.1 Extracting Extracting the the Oracle Oracle Files Files ... ... 77 2.3.2
2.3.2 Starting Starting the the Installation Installation Wizard ...Wizard ... ... 77 2.3.3
2.3.3 Definition of Definition of the the Backup Backup Destination Destination Folders Folders ... ... 88 2.3.4
2.3.4 Definition Definition of of the the Backup Backup Settings Settings ... ... 99 2.3.5
2.3.5 Starting Starting the the Installation Installation Process ...Process ... ... 1313
3.1
3.1 Creation of Creation of ISPA ISPA Database AdDatabase Administration Icon ... ministration Icon ... 1616 3.2
3.2 Configuration Configuration of of Backup Backup Schedules ...Schedules ... ... 1616 3.3
3.3 Oracle Oracle Services Services ... ... 1717
6.1
6.1 “Fixing Up” the IDB“Fixing Up” the IDB ... 25... 25
7.1
7.1 Path Path configuration configuration Overview Overview ... ... 2727 7.1.1
7.1.1 Installation Installation Path Path ... ... 2727 7.1.2
7.1.2 Backup Backup Path...Path... ... 2727 7.2
7.2 Change Change Backup Backup Path Path ... ... 2828 7.2.1
7.2.1 UNC UNC path path ... ... 2929 7.2.2
7.2.2 Local Local Dump Dump Path ... Path ... 3131
List of Contents
List of Contents
Introdu
Introduction ction ... 4... 4
Instal
Installation lation of of IDB IDB ... ...
Verifi
Verification cation of of the the IDB IDB InstalInstallation ...lation ... .... 1616
Creati
Creating ng an an Empty Empty DatabaDatabase ...se ... ... 1919 Creati
Creation on of of Backup ...Backup ... 21... 21 Restor
Restore e ... 23... 23
Change
7.3
7.3 Changing Changing Backup Backup Parameters ... Parameters ... 3232
9.1
9.1 Installation doInstallation do es es not stnot start ... art ... 3737 9.1.1
9.1.1 Installation does Installation does not start not start without any without any Warning ...Warning ... ... 3737 9.1.2
9.1.2 .NET .NET Error Error Messages ... Messages ... 3737 9.2
9.2 Insufficient Insufficient Memory Memory ... ... 3737 9.3
9.3 ORACLE ORACLE or or SCORE SCORE are are not not checked checked ... ... 3838 9.4
9.4 Oracle InstaOracle Installation has llation has not not finished finished successfully successfully ... ... 3838 9.5
9.5 Tasks Tasks were were not not created ...created ... ... 3838 9.6
9.6 Oracle SOracle Services ervices were nwere not ot created ...created ... ... 3838 9.7
9.7 Importing a Importing a Backup has Backup has finished with finished with Errors Errors ... ... 3838 9.8
9.8 Creating Creating a a Backup Backup has has finished finished with with errors errors ... ... 3838 9.9
9.9 IDB Installer IDB Installer does does not run not run with Administrator with Administrator Rights Rights ... ... 3838 9.10
9.10 Fixup Fixup has has not not completed completed successfully successfully ... ... 3939 9.11
9.11 IDB Administration IDB Administration does not does not run with run with administrator rights ... administrator rights ... 3939 9.12
9.12 ORACLE ORACLE listener listener does does not not start ...start ... ... 4040 Update
Update IDB IDB ... ... 3434 Trouble
The "ISPA Database Technical Administration Manual" describes the installation, configuration and The "ISPA Database Technical Administration Manual" describes the installation, configuration and administration of the IDB. The document is addressed to the technical administrator of the ISPA administration of the IDB. The document is addressed to the technical administrator of the ISPA system in the workshops and sales companies. The following topics are covered:
system in the workshops and sales companies. The following topics are covered:
Installation of the Oracle Server and the IDB.Installation of the Oracle Server and the IDB.
Configuration of Backup and Restore.Configuration of Backup and Restore.
Problem handling.Problem handling.
These These
Areas marked with this symbol provide you with additional
Areas marked with this symbol provide you with additional ..
The following additional documents are referenced in this document: The following additional documents are referenced in this document:
ISPI Planning GuideISPI Planning Guide
This document is referenced by This document is referenced by
ISPA Client Technical Administration Manual, ISPI Next 1407ISPA Client Technical Administration Manual, ISPI Next 1407
ISPA Light Technical Administration Manual, ISPI Next 1407ISPA Light Technical Administration Manual, ISPI Next 1407
You need one of the following media for installation: You need one of the following media for installation:
Blu-ray Disc provided with all installation packages for the setup of a new dealer (disc one ofBlu-ray Disc provided with all installation packages for the setup of a new dealer (disc one of four
four – – ISPI Next Applications). ISPI Next Applications).
NAS/Shared Storage with installation packages provided online via the ISPI Admin Client.NAS/Shared Storage with installation packages provided online via the ISPI Admin Client.
Introduction
Introduction
1.1
1.1 Purpose of this document
Purpose of this document
1.2
1.2
Explanation of Symbols used
Explanation of Symbols used
hint / caution
hint / caution has to be read carefully, because otherwise problems can be caused. has to be read carefully, because otherwise problems can be caused.
information information
1.3
1.3 Additional Documents
Additional Documents
1.4
The IDB can be installed on the ISPA Hub or another external device. The installation described here, creates a new and empty database together with the required Oracle Server 11gR2.
The ISPA Hub or external database server hardware and including the operating system is installed. For technical details please refer to the “ISPI Planning Guide”.
All important Windows updates have to be installed especially the updates for .Net.
For the installation administrator rights are required.
The files listed in the following table are required for the installation. Please make sure, that these files are available on your NAS / shared storage. The files can be provided from an offline installation medium (Blu-ray Disc) or downloaded via ISPI Admin Client from the central BMW systems.
ISPA Oracle DBS BMW_ISPI_TRAC_OracleDBS_<version>.exe e.g. BMW_ISPI_TRAC_OracleDBS_11.2.0.1.exe ISPA DB BMW_ISPI_TRAC_IDB_<version>.msi
e.g. BMW_ISPI_TRAC_IDB_1.2.1.0.msi
Before starting the installation you have to carry out the following tasks on the target system:Login to your Windows OS with your administration user
Go to the local user management:
Press the „
Type in “ ”.
Press “
Click on the “
Right click on the groups list and se lect “
Enter the group name “
Installation of IDB
2.1 Requirements
Package name Name of install package on NAS / shared storage
Table 1: Package names and corresponding install packages
2.2 Preparation
2.2.1 Create user group “ora_dba”
Windows Key“. lusrmgr.msc Return“. Groups” folder. New Group...”. ora_dba”.
Click “
Click “ .
Go to the local user management:
Press the „
Type in “ ”.
Press “
Click on the “ ” folder.
Double click your current account.
Select the tab “
Click on “
Enter “
Click on “ ”.
Confirm with “
Confirm with “
To activate the group settings above you have to restart Windows.
Press the „ ”.
Type in “
Press “
Wait until Windows has restarted.
If you want to store the backups of your IDB on an external device within your network, you have to create a network share on this device.
Please create a user with a password that
Select the destination folder where you want to store the backups.
Share this folder to the network with write access for the user you have created before. Later on during installation of the IDB, this information is required to configure the backup parameters.
Create”. Close
2.2.2 Add your administration user to the user group “ora_dba”
Windows Key“. Return“. Users administration Member of”. Add...”.
ora_dba” into the text area. Check Names
OK”. OK”.
2.2.3 Restart your Computer
Windows Key shutdown t 0”. Return“.
2.2.4 Create a Network Share for Backup (optional)
Copy both install packages for “ISPA Or acle DBS” and “ISPA DB” (see table in chapter 2.1) from your NAS/Shared Storage into a temporary local folder on the ISPA Hub or your external database server.
During the installation you may have to accept “User Access Control” and “Firewall” messages. In order to install IDB correctly, you must allow every access.
Start the install package for “ISPA Oracle DBS” and wait until the extraction has completed:
When the file extracting has completed without any error, the window will be closed. Otherwise you will receive an error message.
Now start the install package for “ISPA DB” (see table in chapter 2.1) and the required files will be copied to the target directory. Then the installation starts.
If the installation does not start automatically, please refer to chapter 9.1 “Troubleshooting: Installation does not start”.
2.3 Install IDB
2.3.1 Extracting the Oracle Files
Select your preferred ” for the and the click on “
In the next step, you must not change the preconfigured paths to integrate the IDB into the default BMW folder hierarchy.
If you change the preconfigured paths, the ISPI Admin Client cannot retrieve and upload the log files of the IDB in case support is needed.
Confirm this screen without any changes and click on “
“Language IDB installation IDB Administration dialog and Continue”.
2.3.3 Definition of the Backup Destination Folders
For the daily backups of your IDB you now have to configure the required parameters.
2.3.4.1 Target Directory to store the Backup Files
This can either be a local Dump path on your computer where the IDB is installed, or the path to an external device within your network (UNC path).
To prevent a data loss, it is recommended to use a network share that is backed up also to offline media. In case of loss of the hardware (local server or network share) the backups might be lost also.
If you want to store the backup on your local computer, you can select the target directory or define a new folder using the button:
2.3.4 Definition of the Backup Settings
Local Dump path
After having selected the target directory, it will be displayed in the field left to the button:
To store the backup files on an external device within your network, click on the radio button for the UNC path and define the required parameters:
the full path to the network share you have defined in chapter
2.2.4 “Create a Network Share for Backup (optional)” (
the user you have defined on the target device with
access to the network share (
the password defined for the UNC username (
the domain of the UNC username ( ).
Browse
UNC path
required)
UNC username write
required).
UNC password required).
After you have clicked on the Test button and not all required para meters have been defined, the following hints will be displayed:
After having defined the UNC parameters you can test the connectivity with a click on the and an error message is displayed:
Check the UNC parameters you have entered and try again, until the Test button turns to Test button. If the test failed, the Test button will turn to red
2.3.4.2 Number of Backup Copies and Backup Times
Accept or change the number of backups in minimum is
You will need about 200 MB free space per backup in your target backup directory. For instance you should have 2800 MB free space for the minimum amount of 14 backups.
Define start time for
Define your backup configuration and confirm with a click on “ and proceed with the Oracle installation.
Maximum of saved backups. The default and 14.
Backuptime 1 and Backuptime 2.
If you want to abort the IDB installation, click on “ ” and confirm the following message with “
Otherwise click on “
The next screen will give you an overview, how long the installation will take.
Be sure, and
“Troubleshooting: ORACLE or SCORE are not checked”.
To start the Oracle installation click on “ ”.
Cancel Yes”:
No” and proceed with the Oracle installation.
2.3.5 Starting the Installation Process
ORACLE SCORE are checked. Otherwise please refer to chapter 9.3
The progress of the installation is displayed, and each installation step executed is recorded.
After the installation has been completed, a confirmation message will be displayed:
Then confirm with “ ” and the installation of the IDB is completed and the Installer window can be closed.
After the installation of the IDB has been completed, two the daily database backups of your IDB.
Close
If .NET messages are displayed, please refer to chapter 9.1.2 “Troubleshooting: .NET Error Messages”.
If the Oracle installation did not complete successfully, please refer to chapter 9.4 “Troubleshooting: Oracle Installation has not finished successfully ”.
The following chapters describe how to verify the installation of the IDB. Additionally these steps are also required for analysis, if problems during the daily operations are encountered, e. g. the database is not running or the expected backups are not available.
When the installation has completed successfully, additionally an icon with the shortcut to the “ ” tool is created on the desktop of the local machine:
To verify the Backup Schedules perform the following steps:
Press the “ ” and type “
Select the .
Verification of the IDB Installation
3.1 Creation of ISPA Database Administration Icon
IDB Administration
3.2 Configuration of Backup Schedules
Windows Key task scheduler”. The result should be:
Open “
two tasks (2):
IDB Backup 1 with Status “
IDB Backup 2 with Status “
If these tasks are not available, please refer to chapter 9.5 “Troubleshooting: Tasks were not created”.
To verify the Oracle Services have been created successfully, perform the following teps:
Press the “ ” and type “ The result should be:
Task Scheduler Library” (1) and there you should find the folder IDB with the following
Ready” Ready”
3.3 Oracle Services
Select “Services” and check, whether the following “ screen:
The Oracle Services with Status “Running” in the picture above have also to be in Status “Running” on your ISPA Hub.
If these
chapter 9.6 “Troubleshooting: Oracle Services were not created”.
If the status of the Oracle listener “OracleOraDb11g_home1TNSListener” is not “ please refer to chapter 9.12 “Troubleshooting: ORACLE listener does not start”.
Oracle Services” are shown in the services
Oracle Services are not shown or are not in the correct status, please refer to
To create an empty database is usually necessary only during rollout or if you want to start from scratch without restoring an existing database.
For the Restore of an existing the creation of an empty database is NOT required.
Start the “
Select the radio button “
Confirm with “
To install a completely new and empty database, confirm with “
Creating an Empty Database
IDB Administration” icon on your desktop:
Create an empty database”. Start creation of an empty database”.
Be always sure, that you really want to create an empty database and delete the existing data!
The progress of the creation of an empty database is always displayed on the screen. After completion the following message is displayed:
Confirm with “
When the empty database has been created successfully, continue with one the following steps:
If you use the ISPA Client (with or without DMS integration) and you want to start with an empty database, continue to initialize and configure the IDB as described in chapter 9 of the “ISPA Client Technical Administration Manual”.
If you use ISPA Light and you want to start with an empty database, continue with the initial configuration of ISPA Light as described in chapter 9 of the “ISPA Light Technical Administration Manual”.
OK” and then close the IDB Administration.
(1)
Sometimes it may be necessary to create an instant backup besides the automatically created backups, e.g. if you have to setup a new server hardware or you plan to install updates.
To create an “instant” backup of the IDB, start the “ your desktop.
Select the radio button “
“ ”.
To backup the database, confirm with “
After the backup has been completed successfully, the backup is stored at the configured backup destination and a confirmation message will be displayed:
Creation of Backup
IDB Administration” icon on
Backup database” and start the backup with a click on the button Start Backup
Confirm this message with “
Additionally check, whether the backup files will appear in the destination folder configured or in the default folder %ProgramFiles%\BMW\ISPI\TRAC\IDB\SCORE) including the log files (in .zip format).
If the backup has not been completed successfully, please refer to chapter 9.8 “Troubleshooting: Creating a Backup has finished with errors”.
The restore of an existing database might be necessary:
After hardware problems on the device the IDB is installed on.
After you encountered other problems, e. g. a corrupt database.
If you want to replace your existing database server by another hardware.
Migration of the database to another server.
To restore your IDB from backup, start the “ on your desktop.
Select the radio button “ ” for existing backups:
Select the backup you want to restore, usually the latest one:
Restore
IDB Administration” icon Import database” and “Browse
Now click on “
Confirm the following message with “ ” to start the import:
After the import has completed successfully, a confirmation message will be displayed: Start import”:
Confirm this message with “
If the Import has not been completed successfully, please refer to chapter 9.7 “Troubleshooting: Importing a Backup has finished with Errors”.
A “Fixup” is
The “Fixup” script is a maintenance utility that is included with the ISPA Client. It checks the database and rebuilds all indices and views. If you have installed ISPA Full / ISPA Basic you have to run the “Fixup” after each database import.
Enter the following command from a command line on the ISPA Hub:
C:\Program Files (x86)\BMW\ISPI\TRAC\ISPA-Client Starter\ISPAStartHub.exe –fcs –tkpm fixup –m –b
After the “Fixup” has started successfully the following screen will be displayed:
You just need to run the “Fixup” per database restore.
Otherwise if the “Fixup” did not complete successfully (with error messages) or does not respond, please refer to chapter 9.10 “Troubleshooting: Fixup has not completed
OK”.
6.1 “ ixing Up” the IDB
not required with ISPA Light !
How to start the “ ixup”
If you want to change the backup settings of your IDB during daily operations, start the “ ” icon on your desktop.
Click on “
The current backup settings will be displayed:
Change Backup Configuration
IDB Administration
The path configuration in frame
The backup settings in frame without “Edit Configuration”.
The path configuration consists of the categories “I
To possibility to change the installation path for and the is reserved for Support personnel only.
Otherwise changes may cause unpredictable results and the database is not longer available for your ISPA system!
This can either be a local Dump path on your computer where the IDB is installed, or the path to an external device within your network (UNC path).
To prevent a data loss, it is recommended to use a network share that is backed up also to offline media. In case of loss of the hardware (local server or network share) the backups might be lost also.
(1) can be changed only after clicking the button “Edit Configuration”.
(2) can be changed directly
7.1 Path configuration Overview
nstallation Path” and “Backup Path”.
7.1.1 Installation Path
Oracle IDB
To change the backup path configuration proceed with the following steps.
Click on button ”
Then confirm the following message with “
adapt the existing configuration for the UNC path or the local Dump path.
switch from UNC path to a local Dump path.
Switch from a local Dump path to UNC path.
7.2 Change Backup Path
Edit Configuration”.
Yes”.
To store the backup files on an external device within your network, the radio button for the UNC path has to be activated and the required parameters have to be defined.
If you want to switch from Dump path to UNC path you have to create first the Backup Share on a remote device within your network as defined in chapter 2.2.4 “Create a Network Share for Backup (optional)”.
The parameters to define an UNC path are:
the full path to the network share you have defined in
chapter 2.2.4 “Create a Network Share for Backup (optional)” ( the user you have defined on the target device with access to the network share ( ).
the password defined for the UNC username ( the domain of the UNC username (
After having changed or defined the UNC parameters, test the connectivity with a click on the button.
If the test failed, an error message will be displayed: 7.2.1 UNC path
UNC path
required)
UNC username write
required
UNC password required).
UNC domain optional).
Check the UNC parameters you have entered and try again, until the test is successful.
To save your changes click on “
Finally confirm the next message with “
Close the
Save” and confirm with “Yes”:
OK”:
If you want to store the backup on your local computer, you can select or change the target directory or define a new folder using the button behind the
After having selected the target directory, it will be taken over as local
To save your changes click on “ 7.2.2 Local Dump Path
Browse Dump path:
Dump path. Save” and confirm with “Yes”.
Finally confirm the next message with “
Close the
The following backup settings can be changed without „
The
The
To save your changes click on “
OK”:
IDB Administration with “Close”.
7.3 Changing Backup Parameters
Enable changes“:
Backuptime 1 and/or Backuptime 2.
Backup amount, i.e. the number of backups to be stored at the target location configured. Language to be used for the IDB Administration.
Finally confirm the next message with “
Close the
OK”:
If there is a new version available for the IDB, perform the following steps to update your existing IDB. For the correct name of the current msi-file and probable installation details please refer to the release notes always provided with a new release.
Copy the install package for “ISPA DB” (see table in chapter 2.1) from your NAS/Shared Storage into a temporary local folder on the ISPA Hub or your external database server.
During the installation you may have to accept “User Access Control” and
“Firewall” messages. In order to install IDB correctly, you must allow every access.
Now start the install package for “ISPA DB” (see table in chapter 2.1) and the required files will be copied to the target directory. Then the installation starts.
If the installation does not start automatically, please refer to chapter 9.1 “Troubleshooting: Installation does not start”.
Select the for the IDB installation dialogue:
Update IDB
Confirm the Installation paths without any changes (recommended) with “
Confirm the Backup Configuration (or probably change it) and confirm with “
Start the IDB Update with “
The progress of the update is displayed, and each installation step executed is recorded: Continue”:
Continue”:
When the installation of the IDB Update is completed, confirm with “ window can be closed.
To check the correctness of the IDB Update installed, verify your IDB installation as described in chapter 3 “Verification of the IDB Installation”.
If you have started the install package “ISPA DB” (see table in chapter 2.1) but the installation window does not start, start the “IDB-Installer .exe” from path
“%ProgramFiles%\BMW\ISPI\TRAC\IDB\IDB-Installer\”.
During the ORACLE install process, you might be prompted with messages, that some parts of the .NET Framework are not found.
In this case there possibly is no .NET Framework installed on the target system. If you are running the installation under Windows Server 2012 you have to install the most recent .NET version as a feature.
If the most recent .NET Framework is already installed and you are prompted, that some parts of the .NET Framework 3.5 are not found (see figure below), you can ignore those messages and click them away as often as they appear. They have no impact on a successful installation.
Please check the system requirements! If the system does not have enough free memory, this will result in a corrupt Oracle installation.
Troubleshooting
9.1 Installation does not start
9.1.1 Installation does not start without any Warning
9.1.2 .NET Error Messages
You can face this behaviour, if the IDB installation has found an existing Oracle installation or an uncompleted uninstall. To prevent malfunction, you should install the IDB on a freshly installed Windows computer.
If you get an error during the Oracle installation, the IDB will not work properly. Please contact your Support.
If the expected 2 scheduled tasks are not shown, run “
times and save your changes. Then check the tasks again. If the problem still exists, please contact your Support.
Oracle services are not created, if the Oracle installation has run into an error. Restart the Oracle Services or restart your ISPA Hub. If this does not solve the problem, please contact your Support.
Restart “
successfully, please try to restore another backup. If this fails again, please contact your Support.
Ensure that you are running “ 9.9) and there
is sufficient free disk space available on your selected backup device. Restart “
your Support.
If your IDB Installer does not run with administrator rights, please check, that
“%ProgramFiles%\BMW\ISPI\TRAC\IDB\IDB-Installer\IDB-Installer.exe” has the “Run this program as an administrator” flag.
Go to “%ProgramFiles%\BMW\ISPI\TRAC\IDB\IDB-Installer\” and follow the instructions in 9.11 “IDB Administration does not run with administrator rights” for the “IDB-Installer.exe”.
9.3 ORACLE or SCORE are not checked
9.4 Oracle Installation has not finished successfully
9.5 Tasks were not created
IDB Administration”, enter your desired backup
9.6 Oracle Services were not created
9.7 Importing a Backup has finished with Errors
IDB Administration” and try to restore again. If the import again does not complete
9.8 Creating a Backup has finished with errors
IDB Administration” with administration rights (see chapter
IDB Administration” and retry to backup your database again. If it fails again, please contact
If the Fixup has not completed successfully, try to use another dump file. If it fails again, please contact your Support.
If backup or restore displays the message, the “ arted with
Administrator rights, please check that
“%ProgramFiles%\BMW\ISPI\TRAC\IDB\IDB- Administration\IDB- Administration.exe” has the “ ” flag.
Right click on “ ”.
Click “ ”.
Select the “
Open “
Set “ ” (see Figure below).
Click “
Click “
Now the “IDB Administration” starts for all users with administration rights.
To allow everybody to start backup or restore might cause less effort in administration. But this may cause problems if done by unauthorized or untrained staff!
9.10 Fixup has not completed successfully
9.11 IDB Administration does not run with administrator rights
IDB Administration” has not been st
Run this program as an administrator IDB-Administration.exe
Properties
Compatibility” tab.
Change settings for all users” (your decision). Run this program as an administrator
OK”. OK”.
