Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
CMS-XML Dim: How to manually create Oracle user PCMS_SYS and what Oracle privileges are required
To check for the presence of the PCMS_SYS user type the following commands: $ sqlplus system /<system_password>@<dsn> SQL> select * from all_users where username = 'PCMS_SYS';
CMS-XML KM-Dim9: Installing Dimensions schema using non-system account - What Oracle minimum roles required?
||privilege|| ' to < user >; from
CMS-XML Dim: Install: When installing Dimensions CM and it asks for the Oracle system user password, is this password stored anywhere?
Dim: Install: When installing Dimensions CM and it asks for the Oracle system user password, is this password stored anywhere?
CMS-XML KM-Dim10: When user trying to apply patch, the Oracle System account has been locked ORA-2800: the account is locked.
When user trying to apply patch, the Oracle System account has been locked ORA -2800 : the account is locked.
CMS-XML Dim12: Upgrading to Dimensions CM 12.2 will prompt for Oracle system password when server components only is selected
Even when the user attempts to upgrade server components only (and thus not the database schema), the upgrade installer will prompt for and require the correct Oracle system password. If it is not provided the installation will fail.
CMS-XML 10.x / 2009Rx / 12.x : dmdba statistics compute => DBA2800067E Error: Operation not allowed. Ensure user 'INTERMEDIATE' has the DBA role or all of the required privleges
Connected to system @dim12 ( oracle ) SYSTEM> connect to intermediate/intermediate@dim12 Connected to intermediate@dim12 (oracle)
CMS-XML Dim CM: CREATE ANY PROCEDURE and DROP ANY PROCEDURE privileges required to run "upgrade all"
The System Administration Guide contains a section called " Oracle Privileges Required for DMDBA Commands" where you can find a list of privileges that need to be assigned to an Oracle user if you are not going to be using the SYSTEM account for DMDBA operations. Unfortunately even with this list of privileges assigned the "upgrade all /force" command fails with the following message:
CMS-XML 10.1.x / Oracle 10g : why requiring to set UNDO_MANAGEMENT to MANUAL ?
user is in the process to migrate from Dimensions 8 to 10.
CMS-XML Dim10: When running Oracle full system export for backup as Scheduled Task, it returns ORA-12520: error
First, user needs to make sure server mode is set correctly in tnsnames.ora and listener.ora User needs to run ...lsnrctl services... through command window.
CMS-XML KM-Dim7: How to use a Unix database server with NT Dimensions servers to avoid requiring a Unix login for each Dimensions user
Configure an NT Dimensions Server in parallel with your present Unix system which will continue to serve as the Oracle Server. This eliminates the need for each Dimensions user to have a Unix logon.
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs