Oracle 9i/10g

NEWS & TIPS

  • Site Access Keys
  • Top: Alt+t
    Previous: Alt+,
    Next: Alt+.
    Up: Alt+;
    (Note: use Ctrl on the Mac)

Oracle 9i Configuration

Author: Nedko Hristov

In order to get Cascade running you need to provide a database server where all data will be stored. This set of instructions discusses the process of getting started with Cascade using Oracle 9i.

Getting Started

Please download the example Cascade database:

In order to set the database up for Cascade server it is strongly recommended that you have an existing database with UTF-8 enabled character set. This is necessary to take advantage of Cascade Server's multi-language support. It is strongly recommended that you setup a separate tablespace for your Cascade database. You can start the process of the database preparation by creating the tablespace.

Preparing the Database

  1. Create a new tablespace called CascadeServer. The default size for the storage file can be as low as 35Mb but allowing for at least 100Mb is recommended. Set the datafile for autoincrement for 5MB each time the file gets full.
  2. Create a user CascadeServer with with CONNECT and RESOURCE privileges

Import

  1. Start 'imp'
  2. Log in with appropriate privileges
  3. When prompted for for a dump file to read from enter the filename (absolute or relative path): /backups/CascadeServer.DMP (UNIX) C:\backups\CascadeServer.DMP (WIN)
  4. On the next screen make sure you insert buffer is 15000 or more
  5. To import the file press 'Enter' on the next screen to accept the default: to not just list the contents ('no'). If you simply want to review the export file type 'yes'
  6. Type 'yes' again to accept to ignore error generation in case the tables we are trying to create already exist. (If you are aware that the table is already there and you just want to add rows type 'yes').
  7. Import grants - 'Enter' again for yes
  8. Import table data - 'Enter' again for yes
  9. On import entire file type 'yes' and press 'Enter'

Example Import Screen

C:\Downloads\oracle9i>imp

Import: Release 9.2.0.1.0 - Production on Wed Nov 2 16:34:35 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Username: system
Password:

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Import file: EXPDAT.DMP > C:\Downloads\oracle9i\CascadeServer.DMP

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no > yes

Import grants (yes/no): yes >

Import table data (yes/no): yes >

Import entire export file (yes/no): no > yes

. importing SYSTEM's objects into SYSTEM
. importing CascadeServer's objects into CascadeServer
. . importing table "CXML_ACCESS_RIGHTS" 990 rows imported
. . importing table "CXML_APP_ERRORS" 0 rows imported
. . importing table "CXML_ASSETFACTORY" 73 rows imported
. . importing table "CXML_ASSETFACTORYCONTAINER" 22 rows imported
. . importing table "CXML_AUDIT" 79 rows imported
. . importing table "CXML_BLOB" 420 rows imported
. . importing table "CXML_BLOCK" 139 rows imported
. . importing table "CXML_DBUPDATE" 1 rows imported
. . importing table "CXML_DESTINATION" 65 rows imported
. . importing table "CXML_DYNAMICMETADATAFIELD" 173 rows imported
. . importing table "CXML_DYNAMICMETADATAFIELDDEF" 12 rows imported
. . importing table "CXML_EMAILCERTIFICATE" 0 rows imported
. . importing table "CXML_EMAILTEMPLATES" 4 rows imported
. . importing table "CXML_ENTITYLOCK" 229 rows imported
. . importing table "CXML_ENTITYMETADATA" 1678 rows imported
. . importing table "CXML_ENTITYRELATION" 956 rows imported
. . importing table "CXML_FILE" 420 rows imported
. . importing table "CXML_FOLDER" 323 rows imported
. . importing table "CXML_FOLDERS_WFDEFS" 1 rows imported
. . importing table "CXML_GROUP" 13 rows imported
. . importing table "CXML_GROUP_MEMBERSHIP" 134 rows imported
. . importing table "CXML_LOGINS" 7 rows imported
. . importing table "CXML_MAIL" 0 rows imported
. . importing table "CXML_METADATASET" 18 rows imported
. . importing table "CXML_METADATASETCONTAINER" 4 rows imported
. . importing table "CXML_PAGE" 466 rows imported
. . importing table "CXML_PAGECONFIGSETCONT" 11 rows imported
. . importing table "CXML_PAGECONFIGURATION" 576 rows imported
. . importing table "CXML_PAGECONFIGURATIONSET" 59 rows imported
. . importing table "CXML_PAGEREGION" 715 rows imported
. . importing table "CXML_PERMISSIONS" 44 rows imported
. . importing table "CXML_PREFERENCES" 38 rows imported
. . importing table "CXML_PUBLISHRECORD" 0 rows imported
. . importing table "CXML_PUBLISHSET" 4 rows imported
. . importing table "CXML_PUBLISHSETCONTAINER" 3 rows imported
. . importing table "CXML_PUBLISHSETRECORD" 10 rows imported
. . importing table "CXML_RECYCLERECORD" 0 rows imported
. . importing table "CXML_REFERENCE" 6 rows imported
. . importing table "CXML_REMOTE_LAST_MODIFIED_LU" 0 rows imported
. . importing table "CXML_ROLES" 5 rows imported
. . importing table "CXML_ROLE_MEMBERSHIP" 77 rows imported
. . importing table "CXML_STRUCTUREDDATA" 6245 rows imported
. . importing table "CXML_STRUCTUREDDATADEFCONT" 26 rows imported
. . importing table "CXML_STRUCTUREDDATADEFINITION" 115 rows imported
. . importing table "CXML_STYLESHEET" 178 rows imported
. . importing table "CXML_SYMLINK" 33 rows imported
. . importing table "CXML_TARGET" 65 rows imported
. . importing table "CXML_TEMPLATE" 58 rows imported
. . importing table "CXML_TRANSPORT_FS" 4 rows imported
. . importing table "CXML_TRANSPORT_FTP" 2 rows imported
. . importing table "CXML_TRANSPORT_WEBDAV" 2 rows imported
. . importing table "CXML_USER" 16 rows imported
. . importing table "CXML_USERLEXICON" 13 rows imported
. . importing table "CXML_WORKFLOW" 2 rows imported
. . importing table "CXML_WORKFLOWACTION" 22 rows imported
. . importing table "CXML_WORKFLOWACTIONS" 0 rows imported
. . importing table "CXML_WORKFLOWCOMMENT" 0 rows imported
. . importing table "CXML_WORKFLOWDATA" 0 rows imported
. . importing table "CXML_WORKFLOWDEFCONTAINER" 4 rows imported
. . importing table "CXML_WORKFLOWDEFINITION" 11 rows imported
. . importing table "CXML_WORKFLOWHISTORY" 4 rows imported
. . importing table "CXML_WORKFLOWS" 0 rows imported
. . importing table "CXML_WORKFLOWSTEP" 16 rows imported
. . importing table "CXML_WORKFLOWTRIGGER" 20 rows imported
. . importing table "CXML_WORKFLOWTRIGGERPARAMETER" 6 rows imported
. . importing table "CXML_XML" 918 rows imported
. . importing table "CXML_XSLT" 6 rows imported
. . importing table "JMS_MESSAGES" 0 rows imported
. . importing table "JMS_TRANSACTIONS" 0 rows imported
. . importing table "PRINCIPAL_OBJECT" 11 rows imported
Import terminated successfully without warnings.

C:\Downloads\oracle9i>

Last modified on Mon, 11 Aug 2008 11:09:31 -0400

Comments

Top / Previous / Next / Up / Table of Contents