Oracle® Warehouse Builder Installation and Administration Guide for Windows and Linux Oracle® Warehouse Builder Installation and Administration Guide for Windows and Linux
Preface “Preface”
Audience “Audience”
Documentation Accessibility “Documentation Accessibility” Accessibility of Code Examples in Documentation “Accessibility of Code Examples in Documentation” Accessibility of Links to External Web Sites in Documentation “Accessibility of Links to External Web Sites in Documentation” Deaf/Hard of Hearing Access to Oracle Support Services “Deaf/Hard of Hearing Access to Oracle Support Services”
Related Documents “Related Documents”
Conventions “Conventions”
Overview of Installation and Configuration Architecture “Overview of Installation and Configuration Architecture”
Choosing an Appropriate Installation Configuration “Choosing an Appropriate Installation Configuration”
Architecture and Components of Oracle Warehouse Builder “Architecture and Components of Oracle Warehouse Builder”
Single Computer Topology “Single Computer Topology” Single Computer Topology for Oracle Database 11g Release 2 “Single Computer Topology for Oracle Database 11g Release 2”
Separate Client and Database Server Topology “Separate Client and Database Server Topology” Two Computer Topology; Separate Client and Database Server Installations “Two Computer Topology; Separate Client and Database Server Installations”
Multiple Database Topology “Multiple Database Topology” Multiple Database Topology “Multiple Database Topology”
Separate Client, Control Center Service, and Database Server Topology “Separate Client, Control Center Service, and Database Server Topology” Separate Client, Control Service Center, and Database Server Topology “Separate Client, Control Service Center, and Database Server Topology”
Control Center Agent Topology “Control Center Agent Topology” Control Center Agent Topology “Control Center Agent Topology”
Installing Oracle Warehouse Builder on the Server “Installing Oracle Warehouse Builder on the Server”
Installing OWB on Oracle Database 11g Release 2 “Installing OWB on Oracle Database 11g Release 2”
Working with the OWB Standalone Install Package “Working with the OWB Standalone Install Package” To obtain Oracle Warehouse Builder standalone software: “To obtain Oracle Warehouse Builder standalone software:”
Installing Oracle Warehouse Builder Through Oracle Universal Installer “Installing Oracle Warehouse Builder Through Oracle Universal Installer” To run Oracle Universal Installer: “To run Oracle Universal Installer:”
After the Install “After the Install”
Silent Install Response Values “Silent Install Response Values”
Configuring Oracle Warehouse Builder for Windows “Configuring Oracle Warehouse Builder for Windows”
Configuring OWB Installed as Part of Oracle Database 11g Release 2 “Configuring OWB Installed as Part of Oracle Database 11g Release 2” To unlock OWBSYS and OWBSYS_AUDIT accounts: “To unlock OWBSYS and OWBSYS_AUDIT accounts:”
Configuring OWB Installed as a Standalone Instance “Configuring OWB Installed as a Standalone Instance”
About Configuring OWB Installed as a Standalone Instance “About Configuring OWB Installed as a Standalone Instance”
Cleaning an Oracle Warehouse Builder Repository “Cleaning an Oracle Warehouse Builder Repository” To clean an existing Oracle Warehouse Builder repository: “To clean an existing Oracle Warehouse Builder repository:”
Creating an OWBSYS Schema with Repository Objects “Creating an OWBSYS Schema with Repository Objects” To set-up an OWBSYS schema with repository objects: “To set-up an OWBSYS schema with repository objects:”
Configuring the Control Center Service “Configuring the Control Center Service” To configure the Control Center service: “To configure the Control Center service:”
Unlocking the OWBSYS and OWBSYS_AUDIT Accounts “Unlocking the OWBSYS and OWBSYS_AUDIT Accounts” To unlock OWBSYS and OWBSYS_AUDIT accounts: “To unlock OWBSYS and OWBSYS_AUDIT accounts:”
Setting the OWB Home for Remote Installations “Setting the OWB Home for Remote Installations”
Creating the First Workspace in the Repository “Creating the First Workspace in the Repository” To create a workspace: “To create a workspace:”
Configuring Oracle Warehouse Builder for Linux “Configuring Oracle Warehouse Builder for Linux”
Configuring OWB Installed as Part of Oracle Database 11g Release 2 “Configuring OWB Installed as Part of Oracle Database 11g Release 2” To unlock OWBSYS and OWBSYS_AUDIT accounts: “To unlock OWBSYS and OWBSYS_AUDIT accounts:”
Configuring OWB Installed as a Standalone Instance “Configuring OWB Installed as a Standalone Instance”
About Configuring OWB Installed as a Standalone Instance “About Configuring OWB Installed as a Standalone Instance”
Cleaning an Oracle Warehouse Builder Repository “Cleaning an Oracle Warehouse Builder Repository” To clean an existing Oracle Warehouse Builder repository: “To clean an existing Oracle Warehouse Builder repository:”
Creating an OWBSYS Schema with Repository Objects “Creating an OWBSYS Schema with Repository Objects” To set-up an OWBSYS schema with repository objects: “To set-up an OWBSYS schema with repository objects:”
Configuring the Control Center Service “Configuring the Control Center Service” To configure the Control Center service: “To configure the Control Center service:”
Unlocking the OWBSYS and OWBSYS_AUDIT Accounts “Unlocking the OWBSYS and OWBSYS_AUDIT Accounts” To unlock OWBSYS and OWBSYS_AUDIT accounts: “To unlock OWBSYS and OWBSYS_AUDIT accounts:”
Setting the OWB Home for Remote Installations “Setting the OWB Home for Remote Installations”
Creating the First Workspace in the Repository “Creating the First Workspace in the Repository” To create a workspace: “To create a workspace:”
Uninstalling Oracle Warehouse Builder “Uninstalling Oracle Warehouse Builder”
About Uninstalling Oracle Warehouse Builder “About Uninstalling Oracle Warehouse Builder”
Deleting the Workspace Users “Deleting the Workspace Users” To delete workspace users: “To delete workspace users:”
Deleting the Workspace “Deleting the Workspace” To delete the workspace: “To delete the workspace:”
Deleting the Schema Objects “Deleting the Schema Objects” To grant access to Enterprise Manager: “To grant access to Enterprise Manager:”
Deleting a Repository from an Oracle Database “Deleting a Repository from an Oracle Database” To delete the repository: “To delete the repository:”
Uninstalling the Oracle Warehouse Builder Software “Uninstalling the Oracle Warehouse Builder Software” To uninstall the OWB software: “To uninstall the OWB software:”
Migrating Oracle Warehouse Builder from Earlier Releases “Migrating Oracle Warehouse Builder from Earlier Releases”
Migrating the Repository on the Same Database Instance “Migrating the Repository on the Same Database Instance”
Preparing for Repository Migration “Preparing for Repository Migration” To prepare for a repository upgrade on Windows: “To prepare for a repository upgrade on Windows:” To prepare for a repository upgrade in Linux: “To prepare for a repository upgrade in Linux:”
Upgrading an OWB 11g R1 Repository “Upgrading an OWB 11g R1 Repository” To perform an in-place repository upgrade of an 11g R1 repository: “To perform an in-place repository upgrade of an 11g R1 repository:”
Upgrading an OWB 10g R2 Repository “Upgrading an OWB 10g R2 Repository”
Exporting a Repository to a File “Exporting a Repository to a File” To export a repository to a file: “To export a repository to a file:”
Importing a File into a Repository “Importing a File into a Repository” To import a file into a repository: “To import a file into a repository:”
Migrating the Repository to a Different Oracle Database Instance “Migrating the Repository to a Different Oracle Database Instance”
Exporting a Repository “Exporting a Repository”
Importing a Repository “Importing a Repository”
Upgrading Locations “Upgrading Locations”
Installing Optional Components “Installing Optional Components”
Modifying the OC4J Startup Script “Modifying the OC4J Startup Script” To modify the OC4J startup script: “To modify the OC4J startup script:”
Configuring Control Center Agent Server-side Logging “Configuring Control Center Agent Server-side Logging” To set up the Control Center Agent server-side logging: “To set up the Control Center Agent server-side logging:”
Configuring the Audit Data Source “Configuring the Audit Data Source” To configure the audit data source: “To configure the audit data source:”
Configuring Control Center Agent Security Roles “Configuring Control Center Agent Security Roles” To configure Control Center Agent security roles: “To configure Control Center Agent security roles:”
Creating JMS Queues “Creating JMS Queues” To create JMS Queues: “To create JMS Queues:”
Setting the PATH Environment Variable “Setting the PATH Environment Variable” To set the PATH environment variable: “To set the PATH environment variable:”
Deploying the Control Center Agent to OC4J “Deploying the Control Center Agent to OC4J” To deploy the Control Center Agent to OC4J: “To deploy the Control Center Agent to OC4J:”
Configuring the Control Center Agent Web Service (jrt-web.war) “Configuring the Control Center Agent Web Service (jrt-web.war)” To check that the Web Service is running: “To check that the Web Service is running:” To test the Web Service: “To test the Web Service:” To use the Web Service with a secure website (available only to admin users): “To use the Web Service with a secure website (available only to admin users):”
Enabling Control Center Agent Audit Table Logging “Enabling Control Center Agent Audit Table Logging”
Configuring OWBSYS Audit Connection Pool “Configuring OWBSYS Audit Connection Pool” To configure the OWBSYS Audit Connection Pool: “To configure the OWBSYS Audit Connection Pool:”
Configuring an Audit Table Data Source “Configuring an Audit Table Data Source” To configure the audit table data source: “To configure the audit table data source:”
Installing JDBC Drivers for OC4J “Installing JDBC Drivers for OC4J” To install the JDBC drivers for OC4J: “To install the JDBC drivers for OC4J:”
Overview of Control Center Agent Files “Overview of Control Center Agent Files”
ODL Job Log Files “ODL Job Log Files”
Control Center Agent Run-Time Log File “Control Center Agent Run-Time Log File”
JobID File “JobID File”
Control Center Agent Settings “Control Center Agent Settings”
JRTAdministratorMBean “JRTAdministratorMBean” To change Control Center Agent settings with the JRTAdministratorMBean “To change Control Center Agent settings with the JRTAdministratorMBean”
Installing Code Templates “Installing Code Templates” To install a Code Template: “To install a Code Template:”
Configuring the Repository Browser Environment “Configuring the Repository Browser Environment”
Changing the Session Timeout “Changing the Session Timeout”
Integrating with E-Business Suite “Integrating with E-Business Suite” To enable access to EBS data and metadata: “To enable access to EBS data and metadata:”
Installing Third-Party Name and Address Data “Installing Third-Party Name and Address Data” To integrate with third-party name and address data libraries: “To integrate with third-party name and address data libraries:”
Integrating with Oracle Workflow “Integrating with Oracle Workflow” To enable integration with Oracle Workflow: “To enable integration with Oracle Workflow:”
Managing Configurations “Managing Configurations”
About Configuration Management “About Configuration Management” Oracle Warehouse Builder Configuration Management “Oracle Warehouse Builder Configuration Management”
Creating Configurations Templates “Creating Configurations Templates” To create a configuration template: “To create a configuration template:”
Editing Configuration Templates “Editing Configuration Templates” To edit a configuration template: “To edit a configuration template:”
Activating Configurations “Activating Configurations” To activate a configuration: “To activate a configuration:”
Configuring Objects “Configuring Objects” To configure an object: “To configure an object:”
Managing the Control Center and Repository “Managing the Control Center and Repository”
Overview of OWB Control Center and Repository Management “Overview of OWB Control Center and Repository Management”
Starting and Stopping the Control Center Service “Starting and Stopping the Control Center Service”
Displaying and Managing Control Center Configuration “Displaying and Managing Control Center Configuration”
Managing Control Center Deployment and Execution Jobs “Managing Control Center Deployment and Execution Jobs”
OWB Repository and Location Administration Utilities “OWB Repository and Location Administration Utilities”
OWB Administrative Utilities “OWB Administrative Utilities”
abort_exec_request “abort_exec_request”
abort_unit_request “abort_unit_request”
deactivate_all “deactivate_all”
deactivate_deployment “deactivate_deployment”
deactivate_execution “deactivate_execution”
delete_warehouse_object “delete_warehouse_object”
display_platform_property “display_platform_property”
expedite_exec_request “expedite_exec_request”
grant_error_table_privileges “grant_error_table_privileges”
grant_upgrade_privileges “grant_upgrade_privileges”
list_requests “list_requests”
print_exec_details “print_exec_details”
print_running_exec_details “print_running_exec_details”
purge_audit_template “purge_audit_template”
reset_repository “reset_repository”
rtrepos_report “rtrepos_report”
service_doctor “service_doctor”
set_ccs_home “set_ccs_home”
set_platform_property “set_platform_property”
set_platform_property_from_file “set_platform_property_from_file”
set_repository_password “set_repository_password”
show_service “show_service”
sqlplus_exec_background_template “sqlplus_exec_background_template”
sqlplus_exec_template “sqlplus_exec_template”
start_service “start_service”
stop_service “stop_service”
UpdateControlCenter “UpdateControlCenter”
UpdateLocation “UpdateLocation”
Managing the Control Center Agent “Managing the Control Center Agent”
Starting and Stopping the Control Center Agent “Starting and Stopping the Control Center Agent” To start the CCA: “To start the CCA:” To stop the CCA: “To stop the CCA:”
About the cca_admin Utility “About the cca_admin Utility”
Starting the cca_admin Utility “Starting the cca_admin Utility”
cca_admin Commands “cca_admin Commands”
cleanUpJobLogFilesForGivenTimeInterval “cleanUpJobLogFilesForGivenTimeInterval” Using cleanUpJobLogFilesForGivenTimeInterval Command “Using cleanUpJobLogFilesForGivenTimeInterval Command”
cleanUpNLeastRecentJobLogFiles “cleanUpNLeastRecentJobLogFiles” Using cleanUpNLeastRecentJobLogFiles command “Using cleanUpNLeastRecentJobLogFiles command”
connect “connect” Using connect Command “Using connect Command”
disconnect “disconnect” Using disconnect Command “Using disconnect Command”
exit “exit” Using exit Command “Using exit Command”
getCacheJobStatusSize “getCacheJobStatusSize” Using getCacheJobStatusSize Command “Using getCacheJobStatusSize Command”
getCacheLogNo “getCacheLogNo” Using getCacheLogNo Command “Using getCacheLogNo Command”
getKmPermissionsFile “getKmPermissionsFile” Using getKmPermissionsFile Command “Using getKmPermissionsFile Command”
getLogRoot “getLogRoot” Using getLogRoot Command “Using getLogRoot Command”
getMaxAbortTimeout “getMaxAbortTimeout” Using getMaxAbortTimeout Command “Using getMaxAbortTimeout Command”
getMaxRuntimeFileSizeMB “getMaxRuntimeFileSizeMB” Using getMaxRuntimeFileSizeMB Command “Using getMaxRuntimeFileSizeMB Command”
getMaxRuntimeLogSizeMB “getMaxRuntimeLogSizeMB” Using getMaxRuntimeLogSizeMB Command “Using getMaxRuntimeLogSizeMB Command”
getRuntimeLogEncoding “getRuntimeLogEncoding” Using getRuntimeLogEncoding Command “Using getRuntimeLogEncoding Command”
getRuntimeLogFileLocation “getRuntimeLogFileLocation” Using getRuntimeLogFileLocation Command “Using getRuntimeLogFileLocation Command”
getRuntimeLogLevel “getRuntimeLogLevel” Using getRuntimeLogLevel Command “Using getRuntimeLogLevel Command”
help “help” Using help Command “Using help Command”
isKmSecurityNeeded “isKmSecurityNeeded” Using isKmSecurityNeeded Command “Using isKmSecurityNeeded Command”
isLogToAuditTable “isLogToAuditTable” Using isLogToAuditTable Command “Using isLogToAuditTable Command”
isLogToOdl “isLogToOdl” Using isLogToOdl Command “Using isLogToOdl Command”
isShowRuntimeLoggerLogHostAddr “isShowRuntimeLoggerLogHostAddr” Using isShowRuntimeLoggerLogHostAddr Command “Using isShowRuntimeLoggerLogHostAddr Command”
isShowRuntimeLoggerLogHostId “isShowRuntimeLoggerLogHostId” Using isShowRuntimeLoggerLogHostId Command “Using isShowRuntimeLoggerLogHostId Command”
isShowRuntimeLoggerLogMsgClassPath “isShowRuntimeLoggerLogMsgClassPath” Using isShowRuntimeLoggerLogMsgClassPath Command “Using isShowRuntimeLoggerLogMsgClassPath Command”
isShowRuntimeLoggerLogMsgLogLevel “isShowRuntimeLoggerLogMsgLogLevel” Using isShowRuntimeLoggerLogMsgLogLevel Command “Using isShowRuntimeLoggerLogMsgLogLevel Command”
isShowRuntimeLoggerLogUserId “isShowRuntimeLoggerLogUserId” Using isShowRuntimeLoggerLogUserId Command “Using isShowRuntimeLoggerLogUserId Command”
readSettings “readSettings” Using readSettings Command “Using readSettings Command”
reset “reset” Using reset Command “Using reset Command”
setCacheJobStatusSize “setCacheJobStatusSize” Using setCacheJobStatusSize Command “Using setCacheJobStatusSize Command”
setCacheLogNo “setCacheLogNo” Using setCacheLogNo Command “Using setCacheLogNo Command”
setKmPermissionsFile “setKmPermissionsFile” Using setKmPermissionsFile Command “Using setKmPermissionsFile Command”
setKmSecurityNeeded “setKmSecurityNeeded” Using setKmSecurityNeeded Command “Using setKmSecurityNeeded Command”
setLogRoot “setLogRoot” Using setLogRoot Command “Using setLogRoot Command”
setLogToAuditTable “setLogToAuditTable” Using setLogToAuditTable Command “Using setLogToAuditTable Command”
setLogToOdl “setLogToOdl” Using setLogToOdl Command “Using setLogToOdl Command”
setMaxAbortTimeout “setMaxAbortTimeout” Using setMaxAbortTimeout command “Using setMaxAbortTimeout command”
setMaxRuntimeFileSizeMB “setMaxRuntimeFileSizeMB” Using setMaxRuntimeFileSizeMB Command “Using setMaxRuntimeFileSizeMB Command”
setMaxRuntimeLogSizeMB “setMaxRuntimeLogSizeMB” Using setMaxRuntimeLogSizeMB Command “Using setMaxRuntimeLogSizeMB Command”
setRuntimeLogEncoding “setRuntimeLogEncoding” Using setRuntimeLogEncoding Command “Using setRuntimeLogEncoding Command”
setRuntimeLogLevel “setRuntimeLogLevel” Using setRuntimeLogLevel Command “Using setRuntimeLogLevel Command”
setShowRuntimeLoggerLogHostAddr “setShowRuntimeLoggerLogHostAddr” Using setShowRuntimeLoggerLogHostAddr Command “Using setShowRuntimeLoggerLogHostAddr Command”
setShowRuntimeLoggerLogHostId “setShowRuntimeLoggerLogHostId” Using setShowRuntimeLoggerLogHostId Command “Using setShowRuntimeLoggerLogHostId Command”
setShowRuntimeLoggerLogMsgClassPath “setShowRuntimeLoggerLogMsgClassPath” Using setShowRuntimeLoggerLogMsgClassPath Command “Using setShowRuntimeLoggerLogMsgClassPath Command”
setShowRuntimeLoggerLogMsgLogLevel “setShowRuntimeLoggerLogMsgLogLevel” Using setShowRuntimeLoggerLogMsgLogLevel Command “Using setShowRuntimeLoggerLogMsgLogLevel Command”
setShowRuntimeLoggerLogUserId “setShowRuntimeLoggerLogUserId” Using setShowRuntimeLoggerLogUserId Command “Using setShowRuntimeLoggerLogUserId Command”
settingsToString “settingsToString” Using settingsToString Command “Using settingsToString Command”
showAllJobLogFiles “showAllJobLogFiles” Using showAllJobLogFiles Command “Using showAllJobLogFiles Command”
Managing Content “Managing Content”
About Snapshots and Metadata Loader “About Snapshots and Metadata Loader” Comparison of Snapshots and Metadata Loader “Comparison of Snapshots and Metadata Loader”
Using Snapshots “Using Snapshots”
Creating Snapshots “Creating Snapshots” To create a snapshot: “To create a snapshot:”
Adding Components to a Snapshot “Adding Components to a Snapshot” To add new components to the snapshot: “To add new components to the snapshot:”
Managing Snapshots “Managing Snapshots” Metadata Change Management Window “Metadata Change Management Window”
Managing Snapshot Access Privileges “Managing Snapshot Access Privileges” To change snapshot access privileges: “To change snapshot access privileges:”
Comparing Snapshots “Comparing Snapshots” Two compare two snapshots: “Two compare two snapshots:” To compare the current version of an object with a snapshot version: “To compare the current version of an object with a snapshot version:”
Converting a Full Snapshot to a Signature Snapshot “Converting a Full Snapshot to a Signature Snapshot” To convert a full snapshot: “To convert a full snapshot:”
Restoring Workspace Objects From Snapshots “Restoring Workspace Objects From Snapshots” To restore objects from a snapshot: “To restore objects from a snapshot:”
Exporting and Importing Snapshots “Exporting and Importing Snapshots” To export a snapshot: “To export a snapshot:” To import a snapshot: “To import a snapshot:”
Deleting Snapshots “Deleting Snapshots” To delete a snapshot: “To delete a snapshot:” To delete components from a snapshot: “To delete components from a snapshot:”
Snapshot Performance “Snapshot Performance”
Using the Metadata Loader “Using the Metadata Loader”
Exporting Metadata from the Design Center “Exporting Metadata from the Design Center” To export metadata from a workspace using the Design Center: “To export metadata from a workspace using the Design Center:”
Importing Metadata Using the Design Center “Importing Metadata Using the Design Center”
Importing Objects “Importing Objects” To import objects from an export file using the Design Center: “To import objects from an export file using the Design Center:”
Combining Import Modes and Matching Criteria “Combining Import Modes and Matching Criteria” Import Mode Results “Import Mode Results”
Import Different Base Languages “Import Different Base Languages”
Different Base Languages in the Import File and Target Repository “Different Base Languages in the Import File and Target Repository”
Importing Supported Languages “Importing Supported Languages”
Import Validation Rules “Import Validation Rules”
Upgrading Metadata from Earlier Releases “Upgrading Metadata from Earlier Releases”
Changes to Workspace Objects When Upgrading from OWB 9.2 “Changes to Workspace Objects When Upgrading from OWB 9.2”
Changes to Workspace Objects When Upgrading from OWB 10.1, 10.2 or 11.1 “Changes to Workspace Objects When Upgrading from OWB 10.1, 10.2 or 11.1”
Checking for Warnings and Error Messages “Checking for Warnings and Error Messages”
Design Center Metadata Management Dialog Boxes “Design Center Metadata Management Dialog Boxes”
Metadata Export Dialog Box “Metadata Export Dialog Box”
Export Advanced Options Dialog Box “Export Advanced Options Dialog Box”
Languages “Languages”
Administration “Administration”
Metadata Import Dialog Box “Metadata Import Dialog Box”
Import Advanced Options Dialog Box “Import Advanced Options Dialog Box”
Languages “Languages”
Administration “Administration”
Name Conflicts “Name Conflicts”
File Summary Dialog Box “File Summary Dialog Box”
Metadata Upgrade Dialog Box “Metadata Upgrade Dialog Box”
Metadata Progress Dialog Box “Metadata Progress Dialog Box”
Metadata Loader Utilities “Metadata Loader Utilities”
Metadata Export Utility “Metadata Export Utility”
Metadata Import Utility “Metadata Import Utility”
Multiple Session Concurrency and MDL “Multiple Session Concurrency and MDL”
Metadata Loader Log File “Metadata Loader Log File”
About Metadata Loader Results “About Metadata Loader Results”
Managing Versions and History with the Metadata Loader “Managing Versions and History with the Metadata Loader”
Accessing the Metadata Loader “Accessing the Metadata Loader”
About Metadata Loader Control Files “About Metadata Loader Control Files”
Managing Security “Managing Security”
About Metadata Security “About Metadata Security”
About the Security Service “About the Security Service” To view default security settings: “To view default security settings:”
Evaluating Metadata Security Strategies “Evaluating Metadata Security Strategies”
Minimal Metadata Security Strategy (Default) “Minimal Metadata Security Strategy (Default)”
Multiuser Security Strategy “Multiuser Security Strategy” To implement security for multiple users: “To implement security for multiple users:”
Full Metadata Security Strategy “Full Metadata Security Strategy” To implement full metadata security for multiple users: “To implement full metadata security for multiple users:”
Registering Database Users “Registering Database Users”
Registering Existing Database Users “Registering Existing Database Users” To register existing database users: “To register existing database users:”
Creating New Oracle Database Users “Creating New Oracle Database Users” To create a new database user: “To create a new database user:”
Changing Database Default Roles “Changing Database Default Roles” Fix Now “Fix Now” Fix Later “Fix Later”
Editing User Profiles “Editing User Profiles” To edit a user profile: “To edit a user profile:”
Roles “Roles”
Default Object Privilege “Default Object Privilege” Securing Metadata Objects Throughout their Life Cycle “Securing Metadata Objects Throughout their Life Cycle”
Object Privileges “Object Privileges” FULL CONTROL “FULL CONTROL” EDIT “EDIT” COMPILE “COMPILE” READ “READ”
System Privileges “System Privileges”
Support for a Multiple-user Environment “Support for a Multiple-user Environment”
Read/Write Mode “Read/Write Mode”
Read-Only Mode “Read-Only Mode”
Defining Security Roles “Defining Security Roles” To create a new role: “To create a new role:”
Everyone Role “Everyone Role”
Administrator Role “Administrator Role”
Editing Role Profiles “Editing Role Profiles” To alter default security privileges for a role: “To alter default security privileges for a role:”
Users “Users”
Applying Security Properties on Specific Metadata Objects “Applying Security Properties on Specific Metadata Objects” To change security properties of a specific metadata object: “To change security properties of a specific metadata object:”
Security Tab “Security Tab” Propagating Security Properties to Child Objects “Propagating Security Properties to Child Objects”
Example: Using Security Properties to Freeze a Project Design “Example: Using Security Properties to Freeze a Project Design”
Security Enforcement “Security Enforcement” Privileges Required for the Execution of Operations “Privileges Required for the Execution of Operations”
Managing Passwords in Warehouse Builder “Managing Passwords in Warehouse Builder”
Credential Memory on Logon Panel “Credential Memory on Logon Panel”
Changing Passwords that Access Warehouse Builder “Changing Passwords that Access Warehouse Builder” Changing Passwords that Access Design Repositories “Changing Passwords that Access Design Repositories” Changing Passwords that Access Control Centers “Changing Passwords that Access Control Centers”
Encrypting Passwords to Warehouse Builder Locations “Encrypting Passwords to Warehouse Builder Locations”
Troubleshooting the Installation and Setup “Troubleshooting the Installation and Setup”
General Steps for Troubleshooting Warehouse Builder “General Steps for Troubleshooting Warehouse Builder”
Inspecting Log Files in Warehouse Builder “Inspecting Log Files in Warehouse Builder” Log Files for Installation Errors “Log Files for Installation Errors” Log Files for Metadata Import and Export Errors “Log Files for Metadata Import and Export Errors” Log File for Validation Errors “Log File for Validation Errors” Log File for Generation Errors “Log File for Generation Errors” Log Files for Deployment and Execution Errors “Log Files for Deployment and Execution Errors” Log File for Name and Address Server Errors “Log File for Name and Address Server Errors”
Error Messages Related to Installation “Error Messages Related to Installation” Causes and Actions “Causes and Actions”
Troubleshooting Other Installation Problems “Troubleshooting Other Installation Problems” Causes and Actions “Causes and Actions”
Checking Java Virtual Machine (JVM) “Checking Java Virtual Machine (JVM)”
Generating Log Files for a Specific Warehouse Builder Component “Generating Log Files for a Specific Warehouse Builder Component”
Checking the System Path of Oracle Warehouse Builder “Checking the System Path of Oracle Warehouse Builder” To verify the system path for Oracle Warehouse Builder on Windows: “To verify the system path for Oracle Warehouse Builder on Windows:” To verify the system path for Oracle Warehouse Builder on Linux: “To verify the system path for Oracle Warehouse Builder on Linux:”
Configuring OWB for RAC “Configuring OWB for RAC” Naming RAC Service Nodes “Naming RAC Service Nodes”