Menu
Usage Tracking is a very important feature of Oracle BI. Level and it can store all query execution information in a table in the database. Table in another schema but we're going to use the same schema, named SUPPLIER2 in the example.
Troubleshooting
Problem
Customer wishes to send their 'database' to Cognos Support (for analysis). How can the customer export their user/schema (from inside the Oracle database) to send to IBM Support?
Environment
Controller application repository database hosted on modern version of Oracle (for example 11G or 12C)
Resolving The Problem
Use the Oracle command EXPDP (compatible with recent versions of Oracle, such as 10G, 11G and 12C) to export the Controller schema to a 'DMP' file.Steps:
Imagine a scenario where:- Database name = ccr
- Controller schema name = controllerlive
- Oracle database's SYS password = mypassword
- Oracle's SYSTEM password = mypassword
In this scenario, ask your Oracle DBA (administrator) to:
1. Check that your Oracle server is configured to have a 'data pump' folder.
If one does not exist, then you can create one by:
- Create a folder (for example 'E:DATA_PUMP_DIR') on your Oracle server, for use by the data pump feature
- Run the following script to configure the data pump folder:
CONN sys/mypassword@ccr AS SYSDBA
CREATE OR REPLACE DIRECTORY data_pump_dir AS 'E:DATA_PUMP_DIR';
GRANT READ, WRITE ON DIRECTORY data_pump_dir TO controllerlive,system;
Example:
2. If your Oracle database server is based on Windows, launch a command prompt (CMD)
3. Run the following command:
expdp SYSTEM/mypassword@ccr schemas=controllerlive directory=data_pump_dir dumpfile=controllerlive.dmp logfile=controllerlive.log
4. Open the data pump folder
5. Locate the new DMP file (created by the above script)
6. Compress this file (for example to ZIP or 7z)
7. Please send both the compressed file and the log file (for example 'controllerlive.log') to IBM Support
Internal Use Only
- Oracle 9i (Controller 8.1.x, 8.2.x, 8.3.x, 8.4.x)
- Oracle 10G (Controller 8.2.x, 8.3.x, 8.4.x, 8.5.x, 10.1)
Method #2 - EXP
Oracle have deprecated the 'EXP' and 'IMP' commands. Therefore, you cannot use this method when using Oracle 11G.1. Export the database using the Oracle 'EXP' command. This will create a '.DMP' file
- See attached document 'Exporting - Importing Controller Oracle DB - Oracle 9i or 10G.pdf' for precise steps.
2. Compress this DMP file (for example to a ZIP or 7-ZIP file)
3. Send the ZIP (or 7z) file to IBM Support (for them to import via the 'IMP' command).
Related URL
[{'Business Unit':{'code':'BU002','label':'Business Analytics'},'Product':{'code':'SS9S6B','label':'Cognos Controller'},'Component':'Controller','Platform':[{'code':'PF033','label':'Windows'}],'Version':'All Versions','Edition':'All Editions'}]
Document Information
Modified date:
12 August 2019
12 August 2019
Troubleshooting
Problem
Customer wishes to send their 'database' to Cognos Support (for analysis). How can the customer export their user/schema (from inside the Oracle database) to send to IBM Support?
Environment
Controller application repository database hosted on modern version of Oracle (for example 11G or 12C)
Resolving The Problem
Use the Oracle command EXPDP (compatible with recent versions of Oracle, such as 10G, 11G and 12C) to export the Controller schema to a 'DMP' file.Steps:
Imagine a scenario where:- Database name = ccr
- Controller schema name = controllerlive
- Oracle database's SYS password = mypassword
- Oracle's SYSTEM password = mypassword
In this scenario, ask your Oracle DBA (administrator) to:
1. Check that your Oracle server is configured to have a 'data pump' folder.
If one does not exist, then you can create one by:
- Create a folder (for example 'E:DATA_PUMP_DIR') on your Oracle server, for use by the data pump feature
- Run the following script to configure the data pump folder:
CONN sys/mypassword@ccr AS SYSDBA
CREATE OR REPLACE DIRECTORY data_pump_dir AS 'E:DATA_PUMP_DIR';
GRANT READ, WRITE ON DIRECTORY data_pump_dir TO controllerlive,system;
Example:
2. If your Oracle database server is based on Windows, launch a command prompt (CMD)
3. Run the following command:
expdp SYSTEM/mypassword@ccr schemas=controllerlive directory=data_pump_dir dumpfile=controllerlive.dmp logfile=controllerlive.log
4. Open the data pump folder
5. Locate the new DMP file (created by the above script)
6. Compress this file (for example to ZIP or 7z)
7. Please send both the compressed file and the log file (for example 'controllerlive.log') to IBM Support
Internal Use Only
- Oracle 9i (Controller 8.1.x, 8.2.x, 8.3.x, 8.4.x)
- Oracle 10G (Controller 8.2.x, 8.3.x, 8.4.x, 8.5.x, 10.1)
Method #2 - EXP
Oracle have deprecated the 'EXP' and 'IMP' commands. Therefore, you cannot use this method when using Oracle 11G.1. Export the database using the Oracle 'EXP' command. This will create a '.DMP' file
- See attached document 'Exporting - Importing Controller Oracle DB - Oracle 9i or 10G.pdf' for precise steps.
2. Compress this DMP file (for example to a ZIP or 7-ZIP file)
3. Send the ZIP (or 7z) file to IBM Support (for them to import via the 'IMP' command).
Related URL
[{'Business Unit':{'code':'BU002','label':'Business Analytics'},'Product':{'code':'SS9S6B','label':'Cognos Controller'},'Component':'Controller','Platform':[{'code':'PF033','label':'Windows'}],'Version':'All Versions','Edition':'All Editions'}]
Document Information
Modified date:
12 August 2019
12 August 2019