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 DM: Upgrade 14.1.0 error ORA-01720: grant option does not exist for SYS.NLS_DATABASE_PARAMETERS
During an upgrade, in the portion that upgrades PCMS_SYS schema to 14.1.0, get an error like:
CMS-XML DimCM: Upgrade: DBI4502373E [Microsoft][SQL Server Native Client 11.0][SQL Server]The specified schema name "SCHEMANAME" either does not exist or you do not have permission to use it
When performing a DMDBA upgrade command to Dimensions 14.4, the following error may occur: -- Preparing to upgrade PCMS_SYS to 14.3.3.. DBI0004538E DBIO: Database I/O error occurred
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 KM-Dim9: When adding or editing the Item Library in Admin Console, the following error occurs: "element '-AdmAttrNames.library_node_name' not found"
This error will sometimes occur when the basedatabase has been imported from another server. The root cause is due to pcms_sys not having permissions to query the basedatabase tables.
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: At login Error: failed to query database. (SQL-0036-73(00DD55A8) ORA-00942: table or view does not exist
To resolve this error, add the grants in the following ways to those newly imported base datrabases: Add grants on the pcms_sys database objects (adjust the path accordingly for the relevant Operating System) dmdba pcms_sys/pcms_sys@<service>
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 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;
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs