Find Answers

Filter Search Results
All Operating Systems:
All Products:
All Solution Types:
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
CMS-XML MCLG: Suggested rebuild maintenance to improve performance with Oracle projects
From sqlplus as user system , check that the biggest segment type in each tablespace (query 1 below) is smaller than the biggest free segment in the tablespace returned by the second query: sqlplus system/<password>@<sid> SQL> select segment_type, tablespace_name, max(MB) from
CMS-XML MCLG: How to move existing Collage projects, users and groups to a new Collage server or installation.
Create a backup of the project schema either using Collage's backup tool ( System | Setup | Projects | Backup) or the standard Oracle tools. This will create a .dmp file.
PDF Serena Collage Installation and Setup Guide
NOTE Collage provides a script, called CreateSystemUser_Oracle.sql, which a DBA can use to create Oracle system users with all of the privileges required to manage Collage users and schemas. Once installation is complete, you can find this script in the sql/config directory, under the Collage installation directory.
CMS-XML MCLG: About installing and setting up the correct Oracle JDBC drivers for Collage
... sure the correct Oracle JDBC drivers are ... ... Log all the users off, and ... ... Make sure the Oracle client installed on ... compatible with the Oracle Server version. ... are in the system PATH environment variable ... ... C:\ oracle \ ora 92\bin ... C:\ oracle \product\ ... \BIN ( Oracle 10g) ... ... part of the system PATH environment variable ... ... to update the system PATH, you ... ... PATH for the user who runs the ... ... set on the Oracle server. Default on Oracle 10g
CMS-XML MCLG: How to create the admin database on Oracle after the install is finished.
... 9i < Oracle system username> < Oracle system password> ... Oracle 9i system manager ... 9i < Oracle system username> < Oracle system password> ... Oracle 9i system manager ... lines in the Oracle section of this ... ... 9i < Oracle system username> < Oracle system password> ... Oracle 9i system manager ./ database-create-admin Oracle 9i < Oracle system username> < Oracle system password> ... ./ database-create-admin Oracle 9i system manager ... Start Collage and the password for the admin user will be admin.
CMS-XML MCLG: Cannot save files larger than 64K on Oracle
In some configurations, when the project was stored on Oracle , users could not save files larger than 64K. Issue found in Release: 4.6.0 Fixed bugs in this hot fix
CMS-XML MCLG: Improving performance when running Collage with Oracle
Select the Tools | Database Tools | Analyze option. This will bring up a dialog to analyze a group of objects in the system .
CMS-XML MCLG: Backup of an Oracle project gives error "can't exec: exp doesn't exist"
$ORACLE_HOME is not setup correctly for the user who is running Oracle . For example, if Oracle is installed on Unix and runs as root, then the profile for the root user must set $ORACLE_HOME. Without this setting, Collage will not be able to perform the backup.
CMS-XML MCLG: How to setup a Data Source for Oracle
JDBC URL jdbc:oracle:thin:@server:1521:database Where "server" is the host name of the Oracle server, and "1521" is the listening port, and "database" is the name of the database/SID to connect to JDBC Driver Oracle Custom Class oracle.jdbc.driver.OracleDriver Asset Driver Not Checked User username
CMS-XML MCLG: Using the AssetQuery component to filter assets by a metadata field of type date on Oracle
For additional examples of available SQL function calls, see the Oracle SQL documentation. Example 1: Display a list of all press releases for the current year. <nexus:component classid="nexus/components/AssetQuery" code="/ System /Components/nexusComponents.jar" root="/WebSite/PressRoom/" Filter="A.AssetType='Press Release'"
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs