Oracle BIEE (Business Intelligence) 11g 11.1.1.6.0 Learning (1) installation

ORACLE products absolutely can be called Top x Artifact: Installation files must be large (small pipes do not let you next three days and three nights that is not called Oracle), the system memory must be large, hard disk space must be enough, the installation time must be long enough, the various configurations must be complex enough, the learning curve must be steep enough ... The most important thing is that the price of the product must be high enough! Only sell expensive, not sell right:) Hardware conditions: 1, memory at least 4G (less than this number, it is recommended not to play) 2, if playing in the virtual machine, hard disk recommended to stay at least about 60G Software Environment: 1. WINDOWS R2 2. ORACLE DATABASE 11G R2 (The above software environment is relatively easy to build for Microsoft programmers.) All Oracle Products In addition to the Windows environment, in other environments can also be set up, the need for friends to view official documents themselves) One, download all installation files 1.1 Oracle Database 11g R2 Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html 1.2 Repository Creation Utility (hereinafter referred to as RCU Library utility) Http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html (Pull to Can be seen in the middle of the lower position) 1.3 Oracle Business Intelligence Http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html Second, run the RCU repository utility to create the repository metadata Similar to ASP. NET, if you want to use Membership/role, you have to run aspnet_regsql.exe to create a heap of tables in SQL Server, the primary purpose of this step is to create default tablespaces, users, and bi-related tables in Oracle ... 2.1 Run Bin\rcu.bat Follow the prompts step by step It is important to note that the entire BI installation process involves many usernames and passwords (DB username/password, WebLogic username/password, and analytics username/password), if for learning purposes, It is recommended that all automatically created default user names not be modified (such as DEV_BIPLATFORM,DEV_MDS), all passwords are set to the same, such as Admin123, so that they do not forget The following is the RCU during operation 2.1 (a) 2.1 (b) 2.1 (c) 2.1 (c) 2.1 (d) 2.1 (E) 2.1 (f) The last step, click "Create", then wait to finish it. Third, run BI Setup program Run Bishiphome\disk1\setup.exe The user name will be used to log in to the BI system after the installation is complete, so the username must be remembered. Note: This step, if you are in the installation process with the same error, you can manually add a virtual network card in Device Manager Microsoft Lookback Adapter, and then you can continue to install the Here the schema user name, which is the user name created automatically during RCU run, Dev_biplatform Similarly, the MDS scheme user name in this step is automatically created during the RCU run This step takes a long time, especially at 25%, usually at least 30 minutes to 1 hours (depending on the machine configuration) This step also takes a lot of time, bad luck, and occasionally there will be a configuration failure (once failed, the usual solution is to redo the operating system, all over again) If you can get to this point, it basically means that you are not far from success. (nitpick: Everyone pay attention to the title of this picture, installation steps incredibly is15/, should be 15/ to, if the Oracle boss saw, estimated that the test staff to deduct wages, hehe) After the installation is complete, if you can successfully log in through Http://localhost:9704/analytics, the entire installation process is really done! Note: Through my 3 actual installation experience (2 successes, 1 failures), if the installation of Windows from the virtual machine, the entire set of installed, even if everything goes well, at least half a day. Finally, let's see: How can I start the bi again after the system restarts? First, start Oracle (This step can be skipped if Oracle related services are set to automatic) Start the Oracle Monitoring service net start Oracleoradb11g_home1tnslistener Start the Oracle DB service net start ORACLESERVICEORCL Usually two is enough, and if you want to manage db through a browser, you can also start the Oracle console service net start ORACLEDBCONSOLEORCL Once this service is started, it is possible to manage the DB in the browser, via https://localhost:1158/em/ Second, start WebLogic C:\obiee\user_projects\domains\bifoundation_domain\bin>startweblogic.cmd The first time you start, you will be prompted to enter the user name and password (see the execution prompt can), enter the user name, password, can do is only stare at the screen silly wait When the command-line window appears in the Server started in RUNNING MODE, it means that WebLogic is enabled. In this case, you can log in with Http://localhost:7001/console and http://localhost:7001/em in your browser. third, start bi_server1 You must wait until the WebLogic boot is complete before you can run the following command C:\obiee\user_projects\domains\bifoundation_domain\bin>startmanagedweblogic.cmd Bi_server1 Similarly, when the command-line window appears in the Server started in RUNNING mode, the bi Server1 starts up well Iv. Enabling BI other 5 services C:\obiee\instances\instance1\bin>opmnctl.bat Startall To verify that the service started successfully, open a different command-line window and enter C:\obiee\instances\instance1\bin>opmnctl.bat status If all 5 services are displayed alive (such as), then all boot completion, then http://localhost:9704/analytics/log in to the BI system, if the service does not show alive, you can continue to wait until the start is complete

Oracle BIEE (Business Intelligence) 11g 11.1.1.6.0 Learning (1) installation