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 DimCM: PostgreSQL: How to tell if extensions are installed
Password valid until infinity pcms_sys Password valid until infinity
CMS-XML Dim10: Install on UNIX errors when specifying Oracle database on remote server.
SQL>create user pcms_sys identified by pcms_sys default tablespace pcms_data temporary tablespace pcms_temp; SQL> grant connect,resource,dba to pcms_sys ; Once install completes user should revoke DBA from pcms_sys
CMS-XML DMCM: How to re-create the PCMS_SYS user
SQL> create user pcms_sys identified by pcms_sys; SQL> grant connect, resource to pcms_sys ; Log into DMDBA as system and then as PCMS_SYS, so the connection to PCMS_SYS has the correct privileges:
CMS-XML DIM10: How to unlock or change PCMS_SYS password
sqlplus> alter user pcms_sys account unlock; sqlplus> grant connect, resource to pcms_sys ; sqlplus> commit;
CMS-XML KM-Dim9: How to import a basedatase from a full system export file?
Now you are ready to perform the import of the basedatabase as follows: imp system/<password> file=<path:/filename.exp> fromuser=<basedatabasename> touser= <basedatabasename> buffer=100000 commit=y grants=n log=<path:/logfile.log> Once the import is complete, you will need to grant the requisite database table permissions within dmdba logged in as pcms_sys / pcms_sys @<alias>.
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 DMCM: How to move a base database from one server to another using EXPDP and IMPDP utilities
impdp system/<password>@<SID> schemas=<basedb> directory=dmp_dir dumpfile=<export-filename> logfile=<logfile> Once the import is complete, grant access to the PCMS_SYS schema by running DMDBA as follows: dmdba system/<password>@<SID>
PDF Upgrading from Dimensions 6.0 to 7.0
Stage 7 – Post-Installation Activities 53 connect system/<system_password> alter user pcms_sys identified by <pcms_sys_password>; grant connect, resource, dba to pcms_sys ; connect sys/<sys_password> grant select on dba_synonyms to pcms_sys ; Windows only step 4 Upgrade the PCMS_SYS information by running the following seven commands:
CMS-XML KM-Dim9: How do I change the password to PCMS_SYS?
KM-Dim9: How do I change the password to PCMS_SYS ?
CMS-XML KM-Dim9: How to clear out old net admin data from pcms_sys data after upgrades?
KM-Dim9: How to clear out old net admin data from pcms_sys data after upgrades?
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs