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 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 Creating an Oracle system DSN on 10.2.x and getting an error - sqlstate=im004
sql_handle_env failed" then it is likely you have not set up some required permissions as detailed on resolution. If you have a metalink acount you can reference
CMS-XML Problem: #1131 DBA CAN LOG IN TO ORACLE ENVIRONMENT, BUT USERS CANNOT
Tracker's Who function requires that the V$SESSION be public on each Oracle database that Tracker runs on. In Oracle 7.0 and 7.1, you must specifically set V$SESSION as public. To do this, run the Oracle 7 script UTLMONTR.SQL against the database immediately after it has been created.
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.
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs