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
SQL> create user pcms_sys identified by <pcms_sys_password> default tablespace PCMS_DATA temporary tablespace PCMS_TEMP; SQL> grant connect, resource, create view to pcms_sys ; SQL> exit;
CMS-XML DMCM 12.1: How to manually create the PCMS_SYS schema
SQL> create user pcms_sys identified by pcms_sys; SQL> grant connect, resource to pcms_sys ; SQL> commit;
CMS-XML Dim12: Install: There were errors creating the PCMS_SYS schema
Dim12: Install: There were errors creating the PCMS_SYS schema
CMS-XML 10.x / 2009Rx / 12.x / can PCMS_SYS schema get a different name than PCMS_SYS ?
10.x / 2009Rx / 12.x / can PCMS_SYS schema get a different name than PCMS_SYS ?
CMS-XML 10.x / 2009Rx / 12.x : is it mandatory/required to get PCMS_SYS schema password set to PCMS_SYS for installation or upgrade ?
10.x / 2009Rx / 12.x : is it mandatory/required to get PCMS_SYS schema password set to PCMS_SYS for installation or upgrade ?
CMS-XML During Dimensions upgrade get error like "The operation failed because an index or statistics with name already exists..."
During a Dimensions CM Schema upgrade, may get an error similar to the following: Connected to PCMS_SYS (Microsoft SQL Server) Connected to dbo@dimprddb (Microsoft SQL Server)
CMS-XML DimCM: Error: Setup was unable to create the DIMENSIONS database.
In some situations, the error may not be very clear. In one case, the customer was installing into an MS SQL Server database, using a PCMS_SYS password that contained a quote character ("). This caused the script to fail to run correctly because of the way that windows and windows batch files process and parse parameters.
CMS-XML Dim12: How to install example or sample schema into an existing installation
cmd /e:on /c install_oracle.cmd system manager pcms_sys entry_level "c:\program files\serena\dimensions 12.1\cm" "c:\program files\serena\dimensions 12.1\cm\libs\demo\entry_level\" c:\temp\ dim12 entry2 dmsys dmsys "bob" "joe" "pete" "fred" "steve"
CMS-XML KM-Dim7: Network Administration Tool gives the error 'Error:This utility can only work against a Dimensions 7.0 schema' when attempting to connect.
Edition 2.0 of this document contains the additional information required to successfully upgrade to Dimensions 7.0.. The specific scripts can be found documented on page 94 of the guide under 'Post Installation Activities'. The two-stage update involves running convert_to_70.bat and a series of scripts to update the PCMS_SYS schema, which is where the Network Administration information is held.
CMS-XML Dim10: Error detected in /opt/serena/dimensions/10.1/cm/dbms/common/grant_pcms_sys.sql, line 45
To fix this issue: Connect to the Oracle instance via sqlplus as user pcms_sys (default password is pcms_sys ): sqlplus pcms_sys/<password>
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs