To upgrade the Oracle database manually and then upgrade the server:
- From the Windows Start menu, open a Command Prompt window.
- To update the schema using the AlterSchemaObjects.sql script located in \db scripts\ORACLE\Developer\Upgrade in the software installation files, enter the following at the command prompt:
sqlplus - SQL*Plus is the command line application for Oracle Database.
-s - Run SQL*Plus without SQL*Plus messaging.
<adminuser> - The administrative user for the instance of the Oracle server.
<adminpwd>@<instance> - The password for the administrative user and the name of the instance.
<scriptlocation>\<scriptname> - The path to the location of the script and the name of the script to be run.
schema_owner - The schema owner name is limited to 20 characters.
password - The password used for the schema owner account and the schema_app account.
Statement with generic parameters:
sqlplus -s <adminuser>/<adminpwd>@<instance> @"<script location>\<script name>" schema_owner password
Example with default install parameters:
sqlplus -s system/password@xe @"E:\Setup\db scripts\ORACLE\Developer\AlterSchemaObjects.sql" ODServer password
- Confirm the parameters and run the script.
To upgrade the Microsoft SQL database manually and then upgrade the server:
- From the Windows Start menu, open a Command Prompt window.
- To upgrade the database using the AlterDBObjects.sql script located in \db scripts\MSSQL\Developer\Upgrade in the software installation files, enter the following at the command prompt:
sqlcmd - The command line application for the Microsoft Sequel server.
-E - Use a trusted connection to the Microsoft Sequel server. To use a login and password, use the -U <LOGINID> -P <password> parameters.
-S <servername> - The name of the Microsoft SQL server.
-i "<scriptfile>" - The path to the script file and the name of the script file.
-v DBOwner="<owner name>" - The database account that owns the database.
-v DBName="<database name>" - The name of the database to be upgraded.
Statement with generic parameters:
sqlcmd -E -S <servername> -i <scriptfile> –v DBOwner="<VALUE1>" -v DBName="<VALUE2>"
Example with default install parameters:
sqlcmd -E -S "mysqlserver" -i "E:\Setup\db scripts\MSSQL\Developer\AlterDBObjects.sql" -v DBOwner="ODServer" -v DBName="ODDevContent"
- Confirm the parameters and run the script.
- Confirm the parameters and run the script.
- Close the Command Prompt window.
To upgrade the server with an Oracle database, launch the Setup.exe file located in the root folder in the software installation files. If a Security Warning appears, click Run. You are then prompted to choose the language for the Installer, and the Install Wizard appears. During installation, you will proceed through these screens in the Install Wizard.
- License Key: Depending on the product you are installing, this screen may appear. If it does, click Browse to navigate to the location of the license key file (usually license.xml).
- Welcome: From this screen, you can access the Installation and Upgrade manuals in Adobe Acrobat format.
- Setup Type: From the Configuration list, select Developer Server or Developer Server and Client.
- Language Selection: Choose the language for the Developer server and library. This sets the default language for the templates and publishing styles in the library.
- Software Requirements: Third-party applications are required for installation. If the applications are not present, this screen appears notifying you which applications are needed. You can choose not to continue and abort the installation. If you choose to continue, the applications are installed. If one of them is the .NET framework, the .NET Installer may prompt you to close the Installer. Ignore this warning and do not shut down the Installer.
- Select Program Folder: This screen appears if you selected Server and Client from the Configuration list on the Setup Type screen. You can indicate the desired program folder or accept the default.
- Choose Destination Location: You can accept the default target location, or click Change to specify a different one.
- Choose Web Site: The Available websites list contains the list of all web sites available to the user, allowing you to choose the most appropriate one. Preference is given to secure web sites. In the Application (virtual directory) name box, enter the virtual directory name used in the previous release. You also select the mode to use to authenticate the users, either Windows or Standard. Later, when you supply the credentials for the initial Profile, you must choose the same authentication mode.
Note: The web server and the database server must be in the same local network.
- Virtual Directory Options: On the previous screen, you specified an existing virtual directory. On this screen, confirm that choice by selecting the Replace existing virtual directory option.
- Database System: Choose Oracle Database.
- Oracle .NET Data Provider: A specific version of the Oracle .NET Data Provider must be installed for the Developer to work correctly. This screen appears if the correct version is not present. In the Path field, enter the physical location to which you want to install the software. In the Name field, enter the name of the Oracle Home.
- SQL Script Options: If you have already run the scripts to update the database, click the Yes, the scripts have already been run for this version option. If you want the installer to update the database, click the No, the scripts have not been run, let the installer run them option.
- Internet Information Services Option: During installation, the Internet Information Services will need to be stopped and restarted. You can choose to continue with the installation or cancel it and install at a later time.
- Oracle Database Login: If the scripts have not been run, enter a valid system account name, password, and host string to connect to the Oracle Database server. This account must have permissions to update the schema and the tablespace. If the scripts have already been run to update the database, enter a user name, password and host string that has access to the user schema created to run the application. If the scripts have already been run, the Profile Credentials screen appears next.
Note: Host String represents the name you assign for TNS connectivity in the tnsnames.ora file. This typically identifies the machine, port number and SID of the Oracle database. If you need to connect to a remote Oracle database you will need to supply the host:port/service_name; for example, "myservername:1521/orcl". In some environments a tnsname.ora might not be present. If you are not sure, it is highly recommended that you supply the host/service_name or host:port/service_name (if remote).
- Schema Options: If this screen appears, choose Use existing schema if you have already run the upgrade scripts, or Update schema if you have not run the scripts.
- Profile Credentials: If you chose to install the server with standard authentication, enter a user name and password for the default admin user, and confirm the password. If you chose to install with Microsoft Windows authentication, allow the system to use the current Microsoft Windows account or specify another valid Microsoft Windows user account and password.
- Folder permission: The server or server and client installation needs certain permissions to complete installation. If the installer detects any missing permission(s) it displays this screen, which lists the name of the folder, the user name, and the permission it needs before the installer can continue.
Click Yes, grant permission to the folders to automatically grant the permissions to the folders. If the permissions cannot be applied, this screen reappears. This option is highly recommended. Click No, ignore permission and attempt to continue installation to ignore the permission check and try to continue the installation. If the permissions are not set properly, the installation will fail. Use this option if you know that the permissions are already applied. Click Retry to recheck the folders without applying any permissions. The permissions must be applied manually.
- Ready to Install: The Installation Wizard is ready to install the software. Click Back to review or modify any settings.
- Setup Status: This screen appears while the files are being installed, the schema and virtual directory are being created, and IIS is being configured.
- Installshield Wizard Complete: During the installation a file might be in use by the operating system on the computer; this will require a reboot to complete the installation. Also, make sure to run Windows update to get the latest patches from Microsoft.
To upgrade the server with a Microsoft SQL Server database, launch the Setup.exe file located in the root folder in the software installation files. If a Security Warning appears, click Run. You are then prompted to choose the language for the Installer, and the Install Wizard appears. During installation, you will proceed through these screens in the Install Wizard.
- License Key: Depending on the product you are installing, this screen may appear. If it does, click Browse to navigate to the location of the license key file (usually license.xml).
- Welcome: From this screen, you can access the Installation and Upgrade manuals in Adobe Acrobat format.
- Setup Type: From the Configuration list, select Developer Server or Developer Server and Client.
- Language Selection: Choose the language for the Developer server and library. This sets the default language for the templates and publishing styles in the library.
- Software Requirements: Third-party applications are required for installation. If the applications are not present, this screen appears notifying you which applications are needed. You can choose not to continue and abort the installation. If you choose to continue, the applications are installed. If one of them is the .NET framework, the .NET Installer may prompt you to close the Installer. Ignore this warning and do not shut down the Installer.
- Select Program Folder: This screen appears if you selected Server and Client from the Configuration list on the Setup Type screen. You can indicate the desired program folder or accept the default.
- Choose Destination Location: You can accept the default target location, or click Change to specify a different one.
- Choose Web Site: The Available websites list contains the list of all web sites available to the user, allowing you to choose the most appropriate one. Preference is given to secure web sites. In the Application (virtual directory) name box, enter the virtual directory name used in the previous release. You also select the mode to use to authenticate the users, either Windows or Standard. Later, when you supply the credentials for the initial Profile, you must choose the same authentication mode.
Note: The web server and the database server must be in the same local network.
- Virtual Directory Options: On the previous screen, you specified an existing virtual directory. On this screen, confirm that choice by selecting the Replace existing virtual directory option.
- Database System: Choose Microsoft SQL Server.
- SQL Script Options: If you have already run the scripts to create the database, click the Yes, the scripts have already been run for this version option. If you want the installer to create the database, click the No, the scripts have not been run, let the installer run them option.
- Internet Information Services Option: During installation, the Internet Information Services will need to be stopped and restarted. You can choose to continue with the installation or cancel it and install at a later time.
- Microsoft SQL Server Login: This screen appears if the scripts have not yet been run to upgrade the database. From the Database server list, select the desired Microsoft SQL server. If the scripts have not been run, select Windows Authentication or SQL Server Authentication to connect to the database. If you select Microsoft SQL Server authentication, enter an existing login name and password that has database administrator access to the server.
- Select Microsoft SQL Server: This screen appears if the scripts have been run to upgrade the database. Choose the server on which the existing database is installed.
- Choose Database: Select the existing database.
- Database Options: If this screen appears, choose Use existing database if you have already run the upgrade scripts, or Update database if you have not run the scripts.
- Profile Credentials: If you chose to install the server with standard authentication, enter a user name and password for the default admin user, and confirm the password. If you chose to install with Microsoft Windows authentication, allow the system to use the current Microsoft Windows account or specify another valid Microsoft Windows user account and password.
- Folder permission: The server or server and client installation needs certain permissions to complete installation. If the installer detects any missing permission(s) it displays this screen, which lists the name of the folder, the user name, and the permission it needs before the installer can continue.
Click Yes, grant permission to the folders to automatically grant the permissions to the folders. If the permissions cannot be applied, this screen reappears. This option is highly recommended. Click No, ignore permission and attempt to continue installation to ignore the permission check and try to continue the installation. If the permissions are not set properly, the installation will fail. Use this option if you know that the permissions are already applied. Click Retry to recheck the folders without applying any permissions. The permissions must be applied manually.
- Ready to Install: The Installation Wizard is ready to install the software. Click Back to review or modify any settings.
- Setup Status: This screen appears while the files are being installed, the database and virtual directory are being created, and IIS is being configured.
- Installshield Wizard Complete: During the installation a file might be in use by the operating system on the computer; this will require a reboot to complete the installation. Also, make sure to run Windows update to get the latest patches from Microsoft.