{"id":2328,"date":"2012-01-06T06:12:35","date_gmt":"2012-01-06T14:12:35","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/2328\/installing-topteam-database-schema-for-oracle\/"},"modified":"2018-12-28T04:34:50","modified_gmt":"2018-12-28T12:34:50","slug":"installing-topteam-database-schema-for-oracle","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/2328\/installing-topteam-database-schema-for-oracle\/","title":{"rendered":"Installing TopTeam Database Schema for Oracle"},"content":{"rendered":"<p><!-- Start ScreenSteps Content --><\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">What is this article about?<\/h3>\n<div class=\"StepInstructions\">\n<p>This article illustrates the step-by-step process to install <i>TopTeam Database Schema<\/i> for <i>Oracle<\/i> on your computer.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Who should read this?<\/h3>\n<div class=\"StepInstructions\">\n<ul>\n<li>TopTeam Administrators<\/li>\n<li>IT Support<\/li>\n<\/ul>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Preparations<\/h3>\n<div class=\"StepInstructions\">\n<p>1. Download <i>TopTeam Application Server<\/i> installer from the <a href=\"https:\/\/customerportal.technosolutions.com\" target=\"_blank\">TechnoSolutions Customer Portal<\/a> (access to Customer Portal is available only to licensed customers) or the download link provided by TechnoSolutions Sales\/Support.<\/p>\n<p>The installer file name format is:<br \/>\n<i>TopTeamOraServerLic_Installer_<strong>&lt;TopTeam Application Server Version&gt;_DB_&lt;TopTeam Database Schema Version Required&gt;_&lt;Release Date&gt;.exe<\/strong><\/i><\/p>\n<p>E.g. TopTeamOraServerLic_Installer_3.0_Db_5.0_25Jan10.exe<\/p>\n<p>In the example above:<br \/>\n<strong>3.0 <\/strong>&ndash; is the version number of <i>TopTeam Application Server.<\/i><br \/>\n<strong>5.0 <\/strong>&ndash; is the TopTeam Database version which will be installed by this installer.<br \/>\n<strong>25Jan10<\/strong> &ndash; is the release date of this <i>TopTeam Application Server.<\/i><\/p>\n<p>2. Make sure that the Oracle client libraries, needed for <i>TopTeam Application Server<\/i> to connect to <i>Oracle Database<\/i>, are installed on the computer.<br \/>\nFor more information, refer to the article <a href=\"http:\/\/www.technosolutions.com\/kb\/911\/database-requirements-for-topteam\/\" target=\"_blank\">Database Requirements for TopTeam Repository.<\/a><\/p>\n<p>3. If you want to install and run <i>TopTeam Application Server as a Windows Service<\/i>, ensure that you have logged into the computer as a Windows Administrator.<\/p>\n<p>4. Ensure that you have a valid Username and Password of an Oracle User Account that has the permissions to create a database schema. This is required to install <i>TopTeam Database Schema<\/i> on Oracle.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 1. Run the TopTeam Application Server installer<\/h3>\n<div class=\"StepInstructions\">\n<p>Double-click the <i>TopTeam Application Server<\/i> installation file.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 2. The installation Wizard&#8217;s welcome screen displays<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250717840213.png\" width=\"497\" height=\"377\" alt=\"wpid-media_13250717840213.png\" \/>\n<\/div>\n<\/p><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 3. Read and accept the License Agreement for TopTeam Application Server <\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250718212273.png\" width=\"498\" height=\"376\" alt=\"wpid-media_13250718212273.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>Carefully read the License Agreement.<br \/>\nAfter reading the License Agreement, choose <i>I accept the agreement <\/i>and click <i>Next<\/i> to proceed with installation of <i>TopTeam Database Schema for Oracle<\/i>.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 4. Choose to install TopTeam Oracle Database Schema<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250718867683.png\" width=\"498\" height=\"380\" alt=\"wpid-media_13250718867683.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>Choose the option <i>TopTeam Oracle DB Schema<\/i> if you have already installed <i>TopTeam Application Server<\/i> and now want to install <i>TopTeam Database Schema on Oracle<\/i>.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 5. Install TopTeam Database Schema<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250721560383.png\" width=\"499\" height=\"380\" alt=\"wpid-media_13250721560383.png\" \/>\n<\/div>\n<\/p><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 6. Confirm to run the installer<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250721870013.png\" width=\"497\" height=\"378\" alt=\"wpid-media_13250721870013.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>Choose <i><strong>Yes<\/strong><\/i> to run the <i><strong>TopTeam Database Schema installer.<\/strong><\/i><\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 7. Final Confirmation<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250722122353.png\" width=\"497\" height=\"379\" alt=\"wpid-media_13250722122353.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>This will run the <i><strong>TopTeam Database Schema<\/strong> <strong>installer<\/strong><\/i> for Oracle.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 8. Welcome Screen for the TopTeam Oracle DB Schema installation displays<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250722339193.png\" width=\"706\" height=\"496\" alt=\"wpid-media_13250722339193.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>This installer will create database schema to store your <i><strong>Project data<\/strong><\/i>.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 9. Specify where do you want to install TopTeam database Schema<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250722691333.png\" width=\"705\" height=\"497\" alt=\"wpid-media_13250722691333.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>Choose<i> <strong>In<\/strong> <strong>New Oracle Usercode<\/strong> <\/i>to install <i>TopTeam repository<\/i> by creating a new database schema.<br \/>\nChoose <i><strong>In Existing Oracle Usercode<\/strong><\/i> to install <i>TopTeam repository<\/i> in an existing empty database schema.<\/p>\n<p>This article describes the steps with option 1.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 10. Connect to Oracle Database Server<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250724162513.png\" width=\"706\" height=\"493\" alt=\"wpid-media_13250724162513.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>Enter <i>Username<\/i> and <i>Password<\/i> of the Oracle User and Oracle Database Name that should be used to connect to Oracle Server.<br \/>\nYou must login as a Database Administrator to create new User and\/or create tables, triggers, etc. in an existing schema.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 11. Create TopTeam Database Schema<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250731222843.png\" width=\"704\" height=\"498\" alt=\"wpid-media_13250731222843.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<ol>\n<li>Enter <i>Database Username<\/i> and <i>Password<\/i> of the new <i>TopTeam Database Schema<\/i>.<\/li>\n<li>Choose <i>Default Tablespace<\/i> and <i>Temporary Tablespace<\/i> for the new <i>TopTeam Database Schema<\/i>.<\/li>\n<li>Click <i><strong>Create User<\/strong><\/i> to create the user and proceed to next step.<\/li>\n<\/ol>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250762403403.png\" width=\"308\" height=\"128\" alt=\"wpid-media_13250762403403.png\" \/>\n<\/div>\n<\/p><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 12. View SQL Scripts (optional) <\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250762946193.png\" width=\"670\" height=\"460\" alt=\"wpid-media_13250762946193.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>If you wish to review the SQL Commands being used to install <i>TopTeam Database Schema<\/i>, you can view them in this step.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 13. Summary<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250763273093.png\" width=\"665\" height=\"464\" alt=\"wpid-media_13250763273093.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>Click <i><strong>Install<\/strong><\/i> to begin the database installation process.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 14. TopTeam Database Schema for User Data has been installed<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250765146623.png\" width=\"667\" height=\"463\" alt=\"wpid-media_13250765146623.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>You have successfully installed <i>TopTeam Database Schema<\/i>.<\/p>\n<p>In case you encounter any error during installation, you can send this Log file to TechnoSolutions Support for investigation.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 15. Install TopTeam Sample Database Schema (optional, but highly recommended)<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13250765431723.png\" width=\"501\" height=\"382\" alt=\"wpid-media_13250765431723.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>Installation of <i><strong>Sample Database<\/strong><\/i> is optional. <i><strong>Sample Database<\/strong><\/i> is to be used only for training and evaluation purposes.<\/p>\n<p>Choose <i><strong>Yes<\/strong><\/i> if you want to run the <i>TopTeam Database Schema<\/i> installer for installing <i><strong>Sample Data<\/strong><\/i>.<br \/>\nClick <i><strong>Next<\/strong><\/i> to continue.<\/p>\n<p><i><strong>Sample Data<\/strong><\/i> will be installed using the <i>TopTeam Oracle Database Schema<\/i> installer.<br \/>\nYou can refer to the earlier steps in this article to install <i>TopTeam Sample Database Schema<\/i>.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">Step 16. TopTeam Database Schema has been installed<\/h3>\n<div class=\"StepImage\" style=\"margin:10px 0px;\">\n<img loading=\"lazy\" decoding=\"async\" style=\"padding:3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2018\/12\/wpid-media_13251621455363.png\" width=\"496\" height=\"382\" alt=\"wpid-media_13251621455363.png\" \/>\n<\/div>\n<div class=\"StepInstructions\">\n<p>You have successfully installed <i>TopTeam Database Schema<\/i>.<\/p>\n<p>Click <i><strong>Finish<\/strong><\/i> to exit the Wizard.<\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size:20px;\">See Also<\/h3>\n<div class=\"StepInstructions\">\n<p><a href=\"http:\/\/www.technosolutions.com\/kb\/159\/upgrading-topteam-database-schema-on-oracle-database\/\" target=\"_blank\">Upgrading TopTeam Database Schema on Oracle Database<\/a><\/p>\n<\/div><\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepInstructions\">\n<p>Revised: September 8th, 2016<\/p>\n<\/div><\/div>\n<\/p><\/div>\n<p><!-- End ScreenSteps Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What is this article about? This article illustrates the step-by-step process to install TopTeam Database Schema for Oracle on your computer. Who should read this? TopTeam Administrators IT Support Preparations 1. Download TopTeam Application Server installer from the TechnoSolutions Customer Portal (access to Customer Portal is available only to licensed customers) or the download link provided by TechnoSolutions Sales\/Support. The installer file name format is: TopTeamOraServerLic_Installer_&lt;TopTeam Application Server Version&gt;_DB_&lt;TopTeam Database Schema Version Required&gt;_&lt;Release Date&gt;.exe E.g. TopTeamOraServerLic_Installer_3.0_Db_5.0_25Jan10.exe In the example above: 3.0 &ndash; is the version number of TopTeam Application Server. 5.0 &ndash; is the TopTeam Database version which will be <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[281,280,7],"class_list":["post-2328","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-installation","tag-oracle"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-By","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2328","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=2328"}],"version-history":[{"count":8,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2328\/revisions"}],"predecessor-version":[{"id":46828,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2328\/revisions\/46828"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2328"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}