Search <book_title>...

APTARE IT Analytics Installation and Upgrade Guide for Windows

Last Published: 2022-09-01

Product(s): APTARE IT Analytics (10.6)

Upgrading the Oracle database application binaries (Windows)

Log in to the Portal server as an Administrator. Oracle requires that you are logged in using an account that has administrative privileges.
Download the executable file to your Windows Portal server.
Double-click the executable file.
```
sc_dbinstaller_<versionNumber>_win.exe
```
The version number could be, for example, 193000
The InstallAnywhere installation wizard will begin extracting files.
Once the files have been extracted, the Introduction window will display. Click Next to begin the installation process.
Read and accept the end-user license agreement (EULA) and click Next.
Review the Pre-Installation Summary, which summarizes the product components that will be installed and describes the available and required disk space for these components.
Note:
The requirements shown on the following example screen may not match the requirements displayed on your installation screen. Refer to the actual Pre-Installation Summary screen for the current requirements.
Click Install to start the installation/upgrade of the Oracle application binaries, which internally detects the existing Oracle installed on server, checks the version compatibility, and places files into the C:\opt folder on your Windows server.
- The progress bar displays the component being installed and the progress of the installation overall.
- The command prompt window will briefly display the process being executed.
- The Oracle application binaries will be installed on the C:\ drive. The database itself, however, can be created on an alternate drive during the Portal installation.
Enter the name of a valid user account for the Oracle Service User and click Next. For the upgrade process, the Oracle Service User must be same as the user used during existing Oracle Service user.
At this point, the Oracle upgrader will take over the session and start its process in the Windows command prompt window.
When the Oracle Universal Installer completes its process successfully, press Enter.
The command prompt window once again takes over to start the Oracle services.
In the Starting Services command prompt window, enter the password for the account that you have identified as the Oracle service user. You will not see your keystrokes echoed in the window.
You will be prompted twice for the Oracle Service User password, but the prompts are different:
```
Enter password for Oracle service user:
```
```
Enter <account name>'s password:
```
If you enter an incorrect password, you will be prompted to enter the correct password. If you enter the incorrect password too many times, the account can get locked.
See Account lockout.
Return to the InstallAnywhere window and click Done.
Update the portal.properties file with the new Oracle connection string.

See Task 4: Installing Portal application binaries (Windows).

Uninstall the Oracle application binaries

You may need to uninstall Oracle if you are moving the Portal and database to a new Windows server.

See Oracle already exists on the portal server.

Note:

Throughout this process, there may be some messages indicating a failure to delete a file or directory because it is in use. These messages can be ignored, as subsequent steps in the process will remove them.

Go to the Oracle installation folder to access the uninstaller that is relevant only for Oracle 19c.
```
c:\opt\Oracle19cSetup
```
Double-click deInstallAll12c.bat.
This process not only removes the files from the c:\opt\Oracle12cSetup folder, but it also removes all references in the operating system, such as registry entries.