Tech by KJ

Configuring a Reports Server in Oracle WebLogic Forms & Reports 12.2.1  Step 1 - Execure the wlst.sh script [weblogic@testserver-k app]$ cd /u01/app/oracle/product/12.2.1/oracle_common/common/bin/ [weblogic@testserver-k bin]$ ./wlst.sh Step 2 - Connect using the correct credentials and execute the following commands. wls:/offline> connect ("weblogic","<weblogic_pwd>","<hostname>:7001") wls:/frsdomain/serverConfig/> createReportsServerInstance(instanceName='repserver1',machine='AdminServerMachine') Step 3 - Configure the reports server instance created. [weblogic@testserver-k app]$ vi $DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration/rwservlet.properties <?xml version="1.0" encoding="UTF-8"?> <rwservlet xmlns="http://xmlns.oracle.com/reports/rwservlet/" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <server>repserver1...

 WebUtil Configuration To configure WebUtil we have to configure a data source with the target database (in this case the target database is not the database we used for the RCU configuration) Step 1 - Add the correct tns entries of the target database into the tnsnames.ora file of your app server. [oracle@testserver-k ~]$ vi $ORACLE_HOME network/admin/tnsnames.ora <tns-alias> =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = <ip-of-target>)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = <service-name-of-target-database>)     )   ) [oracle@testserver-k ~]$ tnsping <tns-alias> Step 2 - Connect to the weblogic console to configure a jdbc data source. http://<ip-address>:7001/console Navigate to: Services > Data Sources Select Lock & Edit and create a new Generic Data Source You can select the necessary components that you nee...

Step 1 - Take a backup of the sign_webutil.sh script. [weblogic@testserver-k bin]$ cp sign_webutil.sh sign_webutil.sh_OG Step 2 - Find the java installation location in your server. [weblogic@testserver-k bin]$ which java path/to/your/java/bin Step 3 - Edit the hardcoded keytool and jarsigner paths as follows: FROM: error_text=` /u01/app/oracle/product/12.2.1/wlserver/../jdk/bin/keytool -genkey -dname "CN=$DN_CN, OU=$DN_OU, O=$DN_O, C=$DN_C" \         -alias $JAR_KEY -keypass $JAR_KEY_PASSWORD -keystore $KEYSTORE \         -storepass $KEYSTORE_PASSWORD -validity $VALIDDAYS` TO: error_text=` path/to/your/java/bin/keytool -genkey -dname "CN=$DN_CN, OU=$DN_OU, O=$DN_O, C=$DN_C" \         -alias $JAR_KEY -keypass $JAR_KEY_PASSWORD -keystore $KEYSTORE \         -storepass $KEYSTORE_PASSWORD -validity $VALIDDAYS` AND FROM: error_text=` /u01/app/oracle/product/12.2.1/wlserver/../jdk/bin/jar...

 Creating a WebLogic Domain Step 1 - Launch the Configuration Wizard. [weblogic@testserver-k ~]$ $ORACLE_HOME/oracle_common/common/bin/config.sh ( If GUI doesn't work check this troubleshooting guide ) Select the following Templates: Oracle Forms [Forms] Oracle Reports Application [reports] Oracle Enterprise Manager [em] Oracle HTTP Server (Collocated) [ohs] Oracle Reports Tools [ReportsToolsComponent] Oracle Reports Bridge [ReportsBridgeComponent] Oracle Reports Server [ReportsServerComponent] Step 2 - Add ' boot.properties ' file. Export the correct DOMAIN_HOME path. [weblogic@testserver-k ~]$ export DOMAIN_HOME=$ORACLE_HOME/user_projects/domains/base_domain [weblogic@testserver-k ~]$ mkdir -p $DOMAIN_HOME/servers/AdminServer/security Add the following entries to the boot.properties file. [weblogic@testserver-k ~]$ vi  $DOMAIN_HOME/servers/AdminServer/security/boot.properties username=weblogic password=<your_weblogic_password> [weblogic@testserver-k ~]$ mkd...

 Installing WebLogic 12.2.1 on Oracle Linux 8 Server Step 1 - Download the relevant Software Oracle Fusion Middleware 12c Infrastructure Java Development Kit 1.8.0_202 As a best practice place the downloaded software in a separate directory such as ' SOFTWARES ' Step 2 - Create the following groups and the weblogic user [root@testserver-k opc]# groupadd -g 54321 oinstall [root@testserver-k opc]# useradd -u 54321 -g oinstall weblogic Step 3 - Changed the password for weblogic user [root@testserver-k opc]# passwd weblogic Step 4 - Created the directories in which the WebLogic software will be installed [root@testserver-k opc]# mkdir -p /u01/app/oracle/product/12.2.1 [root@testserver-k opc]# mkdir -p /u01/app/oracle/config/domains [root@testserver-k opc]# mkdir -p /u01/app/oracle/config/applications [root@testserver-k opc]# chown -R weblogic:oinstall /u01 [root@testserver-k opc]# chmod -R 775 /u01/ Step 5 - Appended the following entri...

  Running RCU Configuration for Oracle WebLogic 12.2.1 Step 1 - To Complete the RCU Configuration create a database in the same server. Follow this guide to create a Oracle 19c Database Step 2 - To carry out the RCU configuration run the the Repository Configuration Utility (RCU). [weblogic@testserver-k ~]$ $MW_HOME/oracle_common/bin/rcu After successfully running the Repository Configuration Utility (RCU) follow the below guide to create a WebLogic Domain. Creating a WebLogic Domain