The Oracle Weblogic installation includes several steps and needs to follow in the exact order as given below. The further sections in the document describe in detail about these steps.
1. Install Weblogic.
2. Create Database for Weblogic users.
3. Configure Weblogic Portal Domain.
4. Verify the installation.
Install Weblogic
Download the Weblogic v10.3.2 server from OTN. The file I have downloaded was portal103_win32.exe.
Run setup
1. Click on portal103_win32.exe to start installation wizard.
2. Click next on Instructions wizard.
3. Choose “Create a new middleware Home” Option
4. Type the new middleware home as “E:\Oracle\WLPORTAL”
5. Click Next to continue
6. Select “Custom” radio button as Install Type.
7. Click Next
8. Under “Weblogic Server”, select “Server Examples”. [Note that all other options are selected by default].
9. Under “Weblogic Portal”, select “Portal Examples”. [Note that all other options are selected by default].
10. Click Next
11. On JDK Selection wizard, Click next [Note that Sun JDK and Oracle JRockit are selected by default]
12. Click next again.
13. Click next on windows service wizard. [Default option selected is No]
14. Click next on select shortcut location. Default option is “All users”.
15. Click next again on summary wizard.
16. The wizard installs the product.
17. After installation completed; Uncheck Run Quick start.
Create Database
We will create an oracle database instance for Weblogic portal. The configuration required two separate schemas one for tracking the server and other one for portal. (It is not mandatory that two separate schemas are required, I choose that option for better table management).
Create Tables
The scripts to create oracle database for portal are available in E:\Oracle\WLPORTAL\wlportal_10.3\portal\db\oracle\admin. The location may vary depend on your installation. Review each of the database scripts carefully before running.
Create Weblogic Portal Schemas
1. Create Table spaces.
2. Open create_tablespaces.sql file in editor.
3. Replace the <
4. Change the location of the data file to “E:\PORTALDATA\WLPORTAL_DATA01.DBF”
5. Change the location of index data file to “E:\PORTALDATA\WLPORTAL_INDEX01.DBF”
6. Save the file and exit.
7. Open the create_users.sql in editor.
8. Replace the <
9. Save the file and exit.
10. Create the folder E:\PORTALDATA in your database server.
11. Login to oracle database as sysba. And execute the below scripts in order
12. @E:\Oracle\WLPORTAL\wlportal_10.3\portal\db\oracle\admin\create_tablespaces.sql
13. @E:\Oracle\WLPORTAL\wlportal_10.3\portal\db\oracle\admin\create_users.sql
14. Commit the database.
Create Weblogic Tracking Schemas
1. Open bt_create_tablespaces.sql file in editor
2. Change EVT_DATA_PATHNAME to E:\PORTALDATA\
3. Save the file and exit.
4. Open the bt_create_users.sql in editor.
5. Replace <
6. Save the file and exit.
7. Login to oracle database as sysba. And execute the below scripts in order
8. @E:\Oracle\WLPORTAL\wlportal_10.3\portal\db\oracle\admin\bt_create_tablespaces.sql
9. @E:\Oracle\WLPORTAL\wlportal_10.3\portal\db\oracle\admin\bt_create_users.sql
10. Commit the database.
11. Create tables for tracking.
12. Logout from database.
13. Login using WEBLOGIC_EVENT user [password will be [WEBLOGIC_EVENT]
14. Run the below scripts one by one.
15. @E:\Oracle\WLPORTAL\wlportal_10.3\p13n\db\oracle\bt_create_tables.sql
16. @E:\Oracle\WLPORTAL\wlportal_10.3\p13n\db\oracle\bt_create_fkeys.sql
17. @E:\Oracle\WLPORTAL\wlportal_10.3\p13n\db\oracle\bt_create_indexes.sql
18. @E:\Oracle\WLPORTAL\wlportal_10.3\p13n\db\oracle\bt_create_triggers.sql
19. @E:\Oracle\WLPORTAL\wlportal_10.3\portal\db\data\required\bt_insert_system_data.sql
20. @E:\Oracle\WLPORTAL\wlportal_10.3\portal\db\data\required\bt9_insert_system_data.sql
Configure Weblogic Security Store Database
1. Login to the database as weblogic user.
2. Run the SQL script E:\oracle\WLPORTAL\wlserver_10.3\server\lib\rdbms_security_store_oracle.sql
3. Commit the database.
Configure Weblogic Portal Domain
1. Run Weblogic Configuration
2. Select “Create a new Weblogic domain”
3. Click next
4. Select following options for domain configuration
a. Weblogic Portal 10.3.2
b. Weblogic Portal collaboration repository
c. Weblogic Advanced Web Services Extension
5. Click Next
6. Type domain name as “sandbox”. You may choose any name as your wish.
7. Click Next.
8. Type weblogic password as “Admin123”
9. Confirm the password
10. Click next
11. Select Production Mode option
12. Click Next
13. From configure JDBC Options do following configuration one by one.
12.1 Select appsGroupSpaceDataSource
12.2 Change vendor to Oracle
12.3 Select “Oracle’s Driver (Thin) for Instance Connections”
Note*: Do not select XA Connection
12.4 Type username as WEBLOGIC_EVENT
12.5 Type password as WEBLOGIC_EVENT
12.6 Type DBMS Service as WLPORTAL [This is your database SID]
12.7 Type your host name as
12.8 Port Number 1521
12.9 Uncheck appsGroupSpaceDataSource to save it.
12.10 Select cgDataSource
12.11 Change vendor to Oracle
12.12 Select “Oracle’s Driver (Thin XA) for Instance Connections”
12.13 Type username as WLPORTAL
12.14 Type password as Admin123
12.15 Type DBMS Service as WLPORTAL [This is your database SID]
12.16 Type your host name as
12.17 Port Number 1521
12.18 Uncheck cgDataSource to save it.
12.19 Repeat the above configuration for all other data sources – Except one change. Do not select XA driver for “cdDataSource-nonXA” and “portalDataSourceNeverXA”. [This doesn’t matter you can change it later from Admin console]
14. Click Next
15. Select appsGroupSpaceDataSource and Click on “Run Scripts” button. You can see the progress of the scripts in the panel in the right. Make sure that the scripts execute without errors (Warnings can be ignored). If you see insufficient privilege error, then grant all privileges to the weblogic_event user.
16. Select “p13nDataSource” and click Run Scripts button.
I got an error in these cases as insufficient privilege. I have granted all privileges to WLPORTAL user and got it run successfully.
17. Click next to continue.
18. check all the below mentioned configuration
a. Administration Server
b. JMS Distributed Destination
c. Managed Servers, Clusters and Machines
d. Deployments and Services
e. JMS File Store
f. RDBMS Security Store
19. Click next.
20. Check Enable SSL option.
21. Click next.
22. Click next again.
23. Click on Add button to create a server
24. Name the server as “PortalServer”
25. Click Next
26. Click Add button to create a machine.
27. Name the machine
28. Type the IP address of the server machine
29. Click next
30. Click Add button to create a cluster.
31. Name it as PortalCluster
32. Click Next
33. Add “PortalServer” and “AdminServer”to the “PortalCluster”.
34. Click Next
35. For the JMS option for “WseeFileStore”, select Cache-Flush as the write policy.
36. Click Next.
37. Select RDBMS as Oracle
38. Fill in the database connection details. Use the same username you have used to create the Weblogic Security store database.
39. Click on Test Connection to verify the settings.
40. Click Next
41. Click on “create” button to start creating the domain.
42. Check the “Start Server” button
43. Click “done” button to complete the wizard.
44. The wizard will close and the Weblogic Admin instance will start running.
45. During the startup you may see SQL errors that display “Unable to find table or view” error. We will correct the error shortly.
Configure the JDBC Data Source
This step is required only if you see SQL error “Table or view not existing” during startup. Log in to the admin console using the URL http://yourserver:7001/console.
Unlock the Weblogic Change Server and Click on JDBC Data Sources from console home. Click on a Data Source and then click “Connection Pool”. From the connection pool detail list, locate the “Advanced” link and click on it. From the advanced details, locate the sample polling SQL statement “SELECT COUNT (*) FROM SYSTABLES”. This is not a valid Oracle SQL. Change this to “SELECT COUNT (*) FROM TAB” and Save it. While saving if you see errors such as “Non-transactional” data source, then choose the oracle driver as oracle.jdbc.OracleDriver and save it. Do this change for all the data sources. Do remember to “Activate” the changes to take effect.
Verify the Installation
To start the managed “PortalServer” instance we just created, go to the folder “E:\oracle\WLPORTAL\user_projects\domains\devdomain\bin”. Type the command below to start the managed server.
startManagedWeblogic.cmd PortalServer
Note that PortalServer is the name of the server we have created during installation.
Provide the username, password for starting the WebLogic. Wait for a minute to start the server.
Deploy the Portal Administration Application
The installation above will give only the framework necessary for developing and deploying portal applications. It will be nice to work with a portal administration application to browse the portal, create pages etc. The Weblogic server comes with a default sample administration application. You can install this to the newly managed server.
Do not install your portal applications to the AdminServer. Install only to the PortalServer.
1. Login to the admin console
2. Unlock the change manager.
3. Click on Deployments.
4. Click on “install” button.
5. Select the file “E:\oracle\WLPORTAL\wlportal_10.3\samples\lib\j2ee-modules\wlp-sample-lookandfeel-web-lib.war”.
6. Install this file and select the “PortalServer” as the target.
7. Similarly, install “E:\oracle\WLPORTAL\wlportal_10.3\samples\lib\j2ee-modules\wlp-sample-widgets-web-lib.war” module to PortalServer.
8. Click on Activate changes in Change manager.
9. Click on Unlock again.
10. Click on Deployments and Click “Install” button.
11. Select the folder “D:\oracle\WLPORTAL\wlportal_10.3\samples\applications” and select “portalApp” application.
12. Install this to the PortalServer server.
13. Click on activate to take the change.
14. Stop the AdminServer and PortalServer.
15. Restart AdminServer and PortalServer.
16. To access the portal use the URL http://yourserver:7003/portalAppAdmin/.
17. Note that the port number 7003 is the port number configured for PortalServer.
18. You can login to the Weblogic Portal using username “weblogic” and the administrator password.
njoy
Sajith
3 comments:
Great work, Thanks!
Hi,
I need to change the IP address now post installation of the Cluster,Admin ,Managed Servers, Machines of weblogic Server 10.3.2. Any guidelines on this. Pramod.
Nice work. Do you have any link or documents to of upgrading the portal domain 10.3.2 to 10.3.6 ? pls share your email id to jagadish24@gmail.com
Post a Comment