Thursday, August 8, 2019

config.sh step (step 10 in the supplement) was stuck while starting bi_server1 with DB archiver error (connect as sysdba only until freed)

OAC: Downloading Snapshots Throwing Error: “A connection to the server has failed.(status=504)”

On Oracle Analytics Cloud (OAC) 18.2.1 version,

Unable to download the snapshot and failed with the following error - "A connection to the server has failed" as shown below




As a workaround, metadata command line utilities can be used to export the bar from source and import the bar on the target VM.
  1. Take a snapshot of the system as it exists now.
  2. Restore the snapshot that needs to be migrated.

Detailed Steps:
  1. SSH into the source OAC VM and run a command line utility to generate/export a BAR file.
  2. Use the below command to generate/export the snapshot bar file.
cd /bi/app/public/bin
Example:
./export_archive bootstrap /u01/app/oracle/tools/home/oracle/exportdir/ --loglevel DEBUG --logdir /u01/app/oracle/tools/home
This will prompt for a password to use in order to encrypt the BAR file (The same as that of the bar file generation that occurs on Analytics Console UI page)

      3. Copy this BAR file into the target OAC VM.
      4. Restore the BAR on the target.


cd /bi/app/public/bin
Example:
./import_archive bootstrap /u01/app/oracle/tools/home/oracle/exportdir/1536578078486/bootstrap.bar --loglevel DEBUG --logdir /u01/app/oracle/tools/home/oracle/logdir/

     5. On the source, go back to SAC UI and restore to the backup snapshot created by step 1.

Friday, August 2, 2019

Timeout Issues : ODI


01. How to set up the Timeout for the graphical environment (ODI Studio)?

ODI12c
The Oracle Data Integrator Timeout parameter (in seconds) is set in the ODI 12c Studio tool menu bar from ODI > Tools > Preferences > ODI > System, as shown below:


Modifications of these "Parameters" only impact the local ODI Studio on which the modifications have been performed.

ODI 11g

The Oracle Data Integrator Timeout parameter (in seconds) is set in the ODI 11g Studio tool menu bar from ODI > User Parameters > Property "Oracle Data Integrator Timeout".
The default value is 30 seconds.

02. How to set up the Timeout for the Agents (standalone Agent, colocated Agent, and J2EE Agent)?

The Oracle Data Integrator Timeout of any ODI 12c Agent might be configured from ODI Studio > Topology, by setting the desired number of seconds into the "JDBC connection timeout" property from the physical Agent > "Properties" tab, as shown below:


03. Additional settings for the J2EE Agent


In the WLS Admin Console, go to the deployment of the ODI J2EE Agent, and modify the Session Timeout field to the desired number of seconds.


Additionally, the connection timeout, and the number of retries to establish the connection can also be increased by configuring the JDBC Data Source parameters in WLS Admin Console.

Go to Services > Data Sources entry. Edit the desired Data Source (odiMasterRepository, odiWorkRepository, etc). Go to the Configuration > Connection Pool tab. Click on the "Advanced" link at the bottom of page, and set the Connection Creation Retry Frequency, Login Delay, and Inactive Connection Timeout fields to the desired values.

Also notice the oracle.net.CONNECT_TIMEOUT property (milli-seconds) in the Connection Pool tab > "Properties" text box.



Java heap space error while importing the custom mappings into test environment: : ODI 11g/12c


We are trying to import (smart import) our custom mappings into the test environment and we are getting the java heap space error.






Syntax for setting the Java properties


  • ODI configuration files: product.conf, odi.conf and ide.conf
Increase it to below values in the mentioned files:



  • ODI command files: setODIDomainEnv.cmd, and setODIDomainEnv.sh

Migrating BIAPPS Configration : BIACM (Data Load Parameters, Domains and Mappings, Reporting Parameters)

The migration of functional setup data (Data Load Parameters, Domains and Mappings,
Reporting Parameters) is performed by an export of the setup data from Configuration Manager
in the source environment and then an import of the data into Configuration Manger in the
target environment.

To migrate functional setup data:

1 Log into Configuration Manager in the source environment (for example, development)
as a user with BI Applications Administrator privileges. Navigate to Setup Data Export
and Import: Export Setup Data using the left hand Tasks pane.

2  From the Table tool bar on the Export Setup Data page, click on the Export icon to
display the New Data Entry Dialog: Export. In the Export dialog:
           a. Provide a meaningful name for the export file name
           b. Select the following objects to export:
                        · Data Load Parameters
                        · Domains and Mappings
                        · Reporting Parameters

NOTE: Do not select System Setups. System setups have already been completed as part of Step 1 Creating a Target Test or Production Environment .




3. Click on the Export button. In the File Dow

nload dialog, click Save to save the ZIP file to location that you specify.

4. Copy the ZIP file exported in step 3 above to a file location that is accessible from the
machine that will run the target Configuration Manager browser window.

5. Log into Configuration Manager in the target environment (for example, test) as a user
with BI Applications Administrator privileges. Navigate to Setup Data Export and Import:
Import Setup Data using the left hand Tasks pane.

6. From the Table tool bar on the Import Setup Data page, click on the Import data icon to
display the New Data Entry Dialog: Import Data.

7. In the Import Data dialog, browse to locate the ZIP file copied to the location in step 4
above.

8. Click OK to import the functional setup data into the target Configuration Manager. The
Import table is updated with details of the import.

ODI Load Plan got stuck at Index Creation Step: Oracle BIAPPS 11g

The reason why it is getting stuck is because of the PARALLEL_LEVEL parameter value passed greater than 1 in (DBMS_PARALLEL_EXECUTE.RUN_TASK ) DBMS package.

Sample parameters passed as below :

DBMS_PARALLEL_EXECUTE.RUN_TASK('CREATE_INDEXES_17813500', l_sql_stmt, DBMS_SQL.NATIVE, parallel_level => 2) ;

ODI Load Plan Screenshot:



There are two possible reason when your load plan will get stuck up.

01. If the below DB parameter is 0 and parallel_level => {more than 1}, then your load plan will get stuck.

SQL> show parameter job_queue_processes 

NAME TYPE VALUE 
------------------------------------ ----------- ------------------------------ 

job_queue_processes integer 0 

02. If your dbms_scheduler was disabled, kindly enable the same.


Execution of PL/SQL package (DBMS_PARALLEL_EXECUTE.RUN_TASK) with below parameters: