Configure Oracle Analytics Server Domain on Oracle ATP

Run the Configuration Assistant in silent mode to configure the Oracle Analytics Server standard topology on Oracle ATP.

Note:

The Configuration Assistant in silent mode supports only the TNS_ADMIN type connection string. Also, the TNS_ADMIN type connection string is supported only for SCHEMA_TYPE_EXISTING. The Oracle Autonomous Transaction Processing (ATP) database provides various services consumer groups. Oracle recommends you to always use “TP” ATP service name while running RCU and configuring Oracle BI Applications.

1. Extract the downloaded ATP wallet file to a new folder (for example, /scratch/wallet).
2. For silent mode, prepare a response file.

   Add the following parameters in the response file. These are examples. Make the appropriate changes as per your environment.

   [ENGINE]
   #DO NOT CHANGE THIS.
   Response File Version=1.0.0.0.0
   [GENERIC]
   #If false, omit the startup action at the end of the config assistant.
   PERFORM_BI_STARTUP=true
   SERVICE_INSTANCE_LIMIT=2
   #If empty string will default to BI logout page
   LOGOUT_URL=
   DOMAIN_NAME=bidomain
   DOMAINS_DIR=/scratch/Oracle/installation/Middleware/user_projects/domains
   CONFIGURE_BIEE=true
   CONFIGURE_BIP=true
   SERVICE_INSTANCE_MODE=SINGLE
   DOMAIN_WORK=LOCAL
   INSTALL_EXALYTICS_IN_MEMORY_SOFTWARE=false
   ADMIN_USER_NAME=WebLogic admin user name>
   ADMIN_PASSWORD=<WebLogic admin user password>
   ADMIN_CONFIRM_PASSWORD=<WebLogic admin user password>
   SCHEMA_TYPE=SCHEMA_TYPE_EXISTING
   EXISTING_DATABASE_TYPE=ORACLE_TNS_ALIAS
   DATABASE_TYPE=ORACLE
   FAN_CONNECT_STRING=<can be left blank>
   #In Windows, when you configure the Oracle Analytics Server domain, provide the 
   # connect string in the format below. Use "\\" as the path separator. 
   #Example: #CONNECT_STRING=biaoas2023_tp?TNS_ADMIN=C:\\biapps\\atp_wallet
   CONNECT_STRING=service_name?TNS_ADMIN=<ATP wallet extract folder> 
   EXISTING_DB_PREFIX=<Schema prefix set in RCU while crating BI schema>
   EXISTING_DB_PASSWORD=<DB password>
   PORT_RANGE_START=7001
   PORT_RANGE_END=7999
   #Location of static ports file.  Only set if PORT_RANGE_START is 'STATIC'
   STATIC_PORTS_FILE=
   #Select type of initial application.  Supported types are #APPLICATION_TYPE_BI_BUNDLE, APPLICATION_TYPE_EMPTY.
   APPLICATION_TYPE=APPLICATION_TYPE_EMPTY
   #Location of BI Bundle file to use as the initial application.  Only used if #APPLICATION_TYPE is APPLICATION_TYPE_BI_BUNDLE. 
   BI_BUNDLE_FILE=
   #Password which secures existing BI archive file, change if required 
   BI_BUNDLE_PASSWORD=<SECURE VALUE>
   #New password which will secure AppLite as it is modified with customer data, #change if required
   BI_APP_LITE_PASSWORD=<SECURE VALUE>
   BI_DEFAULT_SERVICE_INSTANCE_KEY=<if left blank then default will be set to SSI>
   

3. If your DOMAINS_DIR is for example: /scratch/Oracle/installation/Middleware/user_projects/domains, then create the same before running config.sh or config.cmd.
4. Change the directory to ORACLE_HOME/bi/bin.
5. Run configuration in silent mode as shown, assuming your response file, oas.resp is available.
   • Linux: ./config.sh -silent -responseFile /scratch/oas.resp
   • Windows: config.cmd -silent -responseFile c:/oas.resp

After you successfully configure Oracle Analytics Server, continue with the Edit Your Input File section. See Edit Your Input File.