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 How To: Oracle -- Permissions for TRKADMIN/Oracle Login for Administration
The following permissions are the minimum permissions necessary for Oracle Administration by a Tracker user or via specific role grant within Oracle . These permissions are given and may be used rather than the Oracle DBA role. The following is a list of permissions for the TRACKER SERVER ADMINISTRATOR.
CMS-XML KM-Dim7: Non-defaulted value for OS_AUTH_PREFIX causes ORA-01951 : role pre-prog_user not granted to 'ops$pcms'.
This error usually occurs when customers are utilizing their own Oracle and have a default prefix set for OS_AUTHENT_PREFIX other than the account type 'OPS$' which is what PVCS Dimensions is calling for (OPS$ accounts use operating-system userids as the basis for ORACLE usernames. This provides the advantage of not providing (another) userid and password to connect to an ORACLE database once the client has logged in to the operating system where the ORACLE database is running.
CMS-XML KM-Dim9: What Oracle permissions are required for DMDBA?
KM-Dim9: What Oracle permissions are required for DMDBA?
CMS-XML DIM CM: Upgrade can't connect to Oracle or complains about permissions
During the upgrade the installer asks for the Oracle admin user. At this stage it can happen that no connection to Oracle can be established or that the installer claims the admin user does not have the right permissions.
CMS-XML Error testing Oracle datasource: Only SQL_DRIVER_NOPROMPT is allowed
Error testing an Oracle datasource from the TeamTrack Administrator: Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled
CMS-XML DM: Upgrade 14.1.0 error ORA-01720: grant option does not exist for SYS.NLS_DATABASE_PARAMETERS
DM: Upgrade 14.1.0 error ORA -01720: grant option does not exist for SYS.NLS_DATABASE_PARAMETERS
CMS-XML Dim: ORA: Cannot start Oracle listener - TNS-12555: TNS:permission denied
LSNRCTL> start Starting /opt/serena/ oracle /11_2/bin/tnslsnr: please wait... TNSLSNR for Solaris: Version 11.2.0.3.0 - Production
CMS-XML Database Servers tab in Configurator does not allow same host name with different service name for Oracle
Database Servers tab in Configurator does not allow same host name with different service name for Oracle
CMS-XML Problem: User gets "unable to access project database. You may not have database permissions, or the database is missing" error connecting to a Tracker project on Oracle.
User gets the above error logging into a Tracker project on Oracle . User is using tracker / intersolv as DBMS userid / password to connect to Oracle. Using DBA userid and password works fine.
CMS-XML DimCM2009R2: SQL-1438(101015810) ORA-01438: value larger than specified precision allowed for this column
DimCM2009R2: SQL-1438(101015810) ORA -01438: value larger than specified precision allowed for this column
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs