How to install Oracle and the Creo Elements/Direct Manager Server Database Server on different servers
The Creo Elements/Direct Manager Server Database Server can be installed and run on a different server from the Oracle database. Communication between Creo Elements/Direct Manager Server and the database is handled by the Oracle TNS Listener service and Oracle Net Services. Setup of this configuration is optional. The typical server with Oracle does not use this setup. This document provides additional installation instructions to configure Oracle and Creo Elements/Direct Manager Server if you choose this configuration.
When you complete the installation, you will have two server systems: an Oracle server and a Creo Elements/Direct Manager Server Database Server. The steps to install and configure your servers are:
a. Install Oracle 11g server software.
b. Use the Database Configuration Assistant to create an Oracle instance.
c. Create tablespaces.
d. Import the Oracle data from a pre-existing instance.
e. Configure a Net Listener (if one was not already configured).
f. Run the Creo Elements/Direct Manager Server installation to update the database.
g. Uninstall Creo Elements/Direct Manager Server from the Oracle computer.
a. Install Oracle 11g client software with SQL*Plus and the Oracle provider for OLE DB. OLE DB is part of the Oracle Windows Interfaces.
b. Install or reconfigure Creo Elements/Direct Manager Server on the Creo Elements/Direct Manager Server Database Server.
 |
You must not configure and run more than one Creo Elements/Direct Manager Server Database Server that accesses a single instance of an Oracle database.
|
On the Oracle server
1. Install Oracle 11g server
Software and Patches:
Install Oracle 11g server.
Apply the Oracle Patches to update Oracle.
2. Create an Oracle instance
Use the Oracle Database Configuration Assistant to create an Oracle instance.
Click > > > > > .
Follow the instructions on the Oracle screens, using the following information to complete the installation:
a. Step 1: Operations
Select Create a Database and click Next.
b. Step 2: Database Templates
Select Transaction Processing and click Next.
c. Step 3: Database Identification
▪ Name: Type name.server, where name is the Oracle SID (usually WM) and server is the name of your Oracle server.
▪ SID: The name that you typed above is used to correctly set the SID field.
Click Next.
d. Step 4: Management Options
Accept the defaults and click Next.
e. Step 5: Database Credentials
Type a password (and confirm it). You will need this password later in this installation, so you may want to write it down. Click Next.
f. Step 6: Storage Options
File System is the default. Click Next.
g. Step 7: Database File Locations
Use Database File Locations from Template is the default. Click Next.
h. Step 8: Recovery Configuration
Accept the defaults and click Next.
i. Step 9: Database Content
Accept the defaults and click Next.
j. Step 10: Initialization Parameters
Click the Character Sets tab and set the character set. This must match the character set of the instance that will be imported.
With the 17.0 release, Creo Elements/Direct Manager Server installs new databases with AL32UTF8 as the Database Character Set and AL16UTF16 as the National Character Set. With the 2007 (15.00) release, CoCreate Manager Server installs new databases with UTF8 as the Database Character Set and National Character Set. Previous releases used one of the following character sets:
▪ WE8ISO8859P1
▪ JA16SJIS
▪ WE8ROMAN8
▪ JA16EUC
▪ Database Character Set
Select one of the character sets.
▪ National Character Set
▪ Default Language
Default Date Format
Set the default language and default date format to your local values.
Click Next.
k. Step 11: Database Storage
Click Next.
l. Step 12: Creation Options
Click Create Database and click Finish.
Using SQL*Plus, grant permissions to the medmgr user.
a. Open a command window.
b. Run SQL*Plus. This is where you need the password that you assigned in step 5 above.
sqlplus system/mypassword
grant connect,resource,dba to medmgr identified by medmgr;
exit
grant connect,resource,dba to medmgr identified by medmgr;
exit
3. Create Tablespaces
Importing an existing instance requires that Oracle tablespaces already exist. The tablespace names depend on the database language.
If your database does not have managed files enabled, you can enable managed files with the SQL command:
SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = 'your_database_path';
|
Language
|
Commands
|
|
English
|
CREATE TABLESPACE WM_ARCHIVEFS;
CREATE TABLESPACE WM_CLASSINFOS;
CREATE TABLESPACE WM_CNC_FILSET;
CREATE TABLESPACE WM_HISTORY;
CREATE TABLESPACE WM_MAINTENANCE;
|
|
French
|
CREATE TABLESPACE WM_ARCHIVEFS;
CREATE TABLESPACE WM_CLASSINFOS;
CREATE TABLESPACE WM_FICHS_ARBO_CLASS;
CREATE TABLESPACE WM_HISTOR;
CREATE TABLESPACE WM_MAINTENANCE;
|
|
German
|
CREATE TABLESPACE WM_ARCHIVDATEISYST;
CREATE TABLESPACE WM_CNC_DATEISATZ;
CREATE TABLESPACE WM_KLASSENINFOS;
CREATE TABLESPACE WM_PROTOKOLL;
CREATE TABLESPACE WM_WARTUNG;
|
|
Italian
|
CREATE TABLESPACE WM_ARCHIVEFS;
CREATE TABLESPACE WM_CLASSINFOS;
CREATE TABLESPACE WM_CNC_FILSET;
CREATE TABLESPACE WM_CRONOLOGIA;
CREATE TABLESPACE WM_MAINTENANCE;
|
|
Japanese
|
Refer to the query at the end of this table
|
|
Spanish
|
CREATE TABLESPACE WM_ARCHIVEFS;
CREATE TABLESPACE WM_CLASSINFOS;
CREATE TABLESPACE WM_CNC_FILSET;
CREATE TABLESPACE WM_HISTORY;
CREATE TABLESPACE WM_MAINTENANCE;
|
The database query to list tablespace names is:
SQL> ALTER SYSTEM SET DB_CREATE_FILE_DEST = 'your_database_path';
4. Import the existing instance
You must export from an existing Oracle instance. For a new installation, a complete installation must be run on a supported system, and that database exported.
a. Open a command window.
b. Set the environment variable, NLS_LANG, to the appropriate value for your database. The syntax is
set NLS_LANG=language_country.characterset
For example:
set NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
c. Navigate to the directory that contains the exported database file. Run the Oracle import utility with the user medmgr and the medmgr password.
imp medmgr/medmgr
d. Type the name of your exported database file at the Import file: prompt. The default values should work fine for the rest of the inputs. Make sure that you import all tables.
When the import utility finishes, continue with configuring a Listener.
5. Configure a Listener
Use the Oracle Net Configuration Assistant to configure a Listener. Normally Oracle creates the Listener when the database is created.
The default Listener port is 1521. To configure a different port:
a. Create a new System Environment Variable.
▪ Variable name: ORACLE_TNS_PORT
▪ Variable value: Port number
b. Click OK in all of the dialog boxes. Reboot the system for this change to take effect.
c. Use the newly configured Listener port in step 5 (below).
Click > > > > > .
a. Select Listener configuration and click Next.
b. Select Add and click Next. (Or, you can use the Reconfigure option to verify that it already exists.)
c. The first listener that you configure defaults to "LISTENER". Click Next.
d. Select TCP and click Next.
e. The default port is 1521. Click Next.
f. Click No to not configure another listener, and exit the Net Configuration Assistant.
Verify that the database service is running.
OracleOraDb11g_home1TNSListener
6. Run the Creo Elements/Direct Manager Server installation to update the database
Install Creo Elements/Direct Manager Server, updating your database.
a. Select Custom Install.
b. On the Choose Components screen, make sure you are installing the Database Server. This updates the database.
c. Finish the installation.
7. Uninstall Creo Elements/Direct Manager Server from the Oracle computer
Uninstall Creo Elements/Direct Manager Server.
On the Creo Elements/Direct Manager Server Database Server
1. Install Oracle 11g client software
Software and Patches:.
Install Oracle 11g client. The client install must include the Oracle Provider for OLE DB and SQL*Plus. Only the Administrator Client is preconfigured to include both of these requirements.
Apply the Oracle Patches to update Oracle.
|
|
You must not install Oracle database server software on the same system or the database will be installed locally.
|
2. Install or reconfigure Creo Elements/Direct Manager Server on the Database Server
Select Custom Install.
On the Configure the Oracle Database Server screen use the Oracle server as the value for Oracle Database Host Name. Use the value of the Oracle SID on the Oracle server for the Oracle SID.
The install directory of the Creo Elements/Direct Manager Server installation contains logfiles and tracefiles which can be checked for a successful installation.
Troubleshooting
If the Database Server can't communicate with the Oracle server, try setting up a Local Net Service manually and check that a SQL*Plus connection is possible.
◦ Use the Oracle Net Configuration Assistant to set up a Local Net Service which can connect to the Oracle SID on the Oracle server.
◦ On the Database Server computer:
a. Click > > > > > .
b. Welcome: Select Local Net Service Name configuration and click Next.
c. Net Service Name Configuration: Select Add and click Next.
i. Service Name: Type the global database name used when the instance was created with the Database Configuration Assistant, for example:
WM.ora_server
Click Next.
ii. Select Protocols: Select TCP and click Next.
iii. TCP/IP Protocol: Type the hostname of the server computer, for example:
ora_server
Accept the standard port and click Next.
iv. Test: Click Yes, perform a test. Click Next
v. Connecting: If you get an ORA-01017: invalid username/password error:
▪ Click Change Login and set medmgr as the Username and use the medmgr password.
Once you have a successful test, click Next.
vi. Net Service Name: The Net Service Name (for example, WM) must match the Oracle SID on the Oracle server.
vii. Another Net Service Name: Select No and click Next.
viii. Net Service Name Configuration Done: Click Next.
d. Click Finish.
◦ Check that the Database Server can connect to the Oracle database.
On the Database Server computer:
a. Click > > > > >
b. In the Log On dialog:
▪ User Name: Type medmgr
▪ Password: Type the medmgr password.
▪ Host String: Type the Net Service Name (e.g. WM).
▪ Click OK.
c. You should see a message indicating a connection.
d. Type
SELECT * FROM V$INSTANCE;
to verify that the proper connection is established.
e. Type "EXIT;" to close SQL*Plus.