Oracle 10g installation

Table of contents

• 1 Oracle Server 10g Server / Standard Edition - and Standard Edition One Installation
• 2 Creating a IDL Konsis-Supply Database
• 2.1 Creating an empty Oracle Database
• 2.2 Tip for adjustment a Unicode Database
• 3 Configuration the database connection
• 3.1 Listener - Configuration
• 3.2 Local Net Service Name Configuration
• 4 Manuel Setup a Database for IDL Konsis
• 4.1 Creating own tablespace KONSIS
• 4.2 Creating Database-User
• 4.3 Loading the IDL Konsis Database-Content
• 4.4 Loading the Database with IMPORT Program of Oracle
• 4.5 Information for the installation of a database to an existing instance
• 5 Establishing an Oracle 32 Bit Client
• 5.1 Installation of the Oracle 32 Bit Client Software
• 5.2 Configuration of the Client Database-Connection
• 5.3 Oracle-Client on Windows 98

( Screen - Shots of Oracle Version 10.1.0.2.0 )

After the CD is stored in the CD-Device the installation-program runs automatically.

After successful download and unpacked files run SETUP.

Tip: Only the most important masks of the "Oracle Universal Installer" are shown here.

Selection of the installations method.

Oracle has three methods to install Oracle.

1. Basic-Installation without creating a database
2. Basic-Installation with creating a database
3. Extended Installation

Select the method "Basic Installation without creating a database" and the installation type you have ordered with your oracle license.

Later we create the database with "The Database Configuration Assistant".

With < Next > starts the installation.

If the next two messages comes, continue with the next two points:

• The warning "Cannot initialise OCR" confirm with < OK > ...and
• the error "OS-Error with the start of the service: OracleCSService" confirm with < Ignore >.

After the files are copied from the CD, confirm still the end and go to point 2.

Start the "Database Configuration Assistant" under Start / All Programs / Oracle - OraDb10g_home1 / Configuration and Migration Tools.

Confirm the greetings with < Next > and use step 1 to 12.

Step 1: Operations

Select "Create a Database".

Step 2: Database Templates

Select the template "General Purpose" from the following list to create a database.

Step 3: Database Identification

Enter "IDLDB" for "Global Database Name" and "SID".

Step 4: Management Options

Select "Configure the Database with Enterprise Manager" and "Use Database Control for Database Management".

Step 5: Database Credentials

Select "Use Different Passwords" and assign the individual passwords.

Step 6: Storage Option

Select "File System" for Database storage.

Step 7: Database File Locations

Select "Use Common Locations for All Database Files". If necessary enter a new common location.

Step 8: Recovery Configuration

Select "Specify Flash Recovery Area". The specified area must have enough free disk place. Archiving is not enabled, unless your local DBA wants it.

Step 9: Database Content

"Sample schemas" is not enabled.

Step 10a: Initialization Parameters Memory

Select Typical - Allocate memory, and enter a percentage, which corresponds to at least 216 MB of the physical memory.

Step 10b: Initialization Parameters Sizing

Set 8 MB for sort area size.

Step 10c: Initialization Parameters Character Sets

If the language under the operating system is "WE8MSWIN1252" choose Use the default as "Character Set. Otherwise "Choose from the list of character sets" this character set. For Unicode choose "Unicode AL32UTF-8".

Step 10d: Initialization Parameters Connection Mode

select "Dedicated Server Mode".

Step 11: Database Storage

"Database Storage" confirm with "Next".

Step 12: Creation Options

Select "Create database" from the options. Confirm with "Finish" and the installation starts.

Two examples for the "Initialization Parameters":

For 1 GB physical memory ...:

Importent to set the following parameter: NLS_LENGTH_SEMANTICS=CHAR after the installation the Oracle Instance with character set UTF-8 (Unicode).

1. Start (open) the command line.
2. Enter: SQLPLUS .
3. Connect with User SYS and Password xy as sysdba .
4. Enter: select * from V$NLS_PARAMETERS; .
5. Control the parameter: NLS_LENGTH_SEMANTICS=BYTE .
6. Enter: alter system set nls_length_semantics=CHAR scope=BOTH; .
7. Enter: shutdown abort .
8. Enter: startup .
9. Entere: select * from V$NLS_PARAMETERS; .
10. Control the parameter: NLS_LENGTH_SEMANTICS=CHAR .
11. Enter: disconnect .
12. Enter: exit .
13. Enter again: exit .
14. Start (open) the explorer .
15. Change (go) to the directory 'pfile' from the Oracle installation.
16. For the Oracle Instance Unicode an example: D:\oracle\product\10.2.0\admin\unicode\pfile
17. Open with an editor the file INIT.ORA.252007134958 (Example) .
18. Insert into the group # NLS : nls_length_semantics=CHAR
19. Save the file and close the editor.

Start the " Net Configuration Assistant " under Start / All Programs / Oracle - OraDb10g_home1 / Configuration and Migration Tools.

Step 1: Welcome

Select "Listener - configuration".

Step 2: Listener

Select "Add"

Step 3: Listener - Name

The listener get a name, e.g.: "Listener". Later you find this name under Windows General view "Services" and shoud be started.

Step 4: Select Protocols

Confirm the selected protocol "TCP".

Step 5: TCP/IP - Protocol

Confirm the standard Port number of 1521.

Step 6: More Listeners ?

"Wood you like to configure another Listener ?" confirm with "NO".

Step 7: Configuration done

Confirm the "Listener Configuration complete!", and continue automatically with 3.2.2 "Add" under "Local Net Service Name Configuration".

Start the "Net Configuration Assistant" under Start / All Programs / Oracle - OraDb10g_home1 / Configuration and Migration Tools.

Step 1: Welcome

Select "Local Net Service Name Configuration".

Step 2: Net Service Name Configuration

Select "Add".

Step 3: Select Protocols

Confirm the selected protocol "TCP".

Step 4: TCP/IP Protocol

Enter the host-name for the computer where the database is located. The Host should be reachable via ping in a Prompt (DOS) window! Select standard port number 1521".

Step 5: Test

A connection test can be performed to the database.

Step 6: Net Service Name

Enter "IDLDB" for this net service name. Later you find this name under Windows General View "Services" and shoud be started.

Step 7: Another Net Service Name

Confirm with "NO" for another net service name.

Step 8: Done

Confirm the message "Net service name configuration complete!" and close the program.

Create Tablespace KONSIS:

1. SQL-Plus is used to register SYSTEM/PASSWORD of the database. To find under Start / All Programs / Oracle - OraDb10g_home1 / application development.
2. " Execute the SQL-Command by customising the path of the parameter DATAFILE and the size of SIZE:
3. CREATE TABLESPACE KONSIS LOGGING DATAFILE 'D:\ORACLE\ORADATA\IDLDB\KONSIS.DBF' SIZE 800M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
4. " closing SQL-Plus by : disconnect or continue with point 4.2.2.

There should exist a database-user named idldb with the right authorities. This is the master of all IDL Konsis-Tables.

The table-space KONSIS is assigned to the user IDLDB. In this space all IDL Konsis-Tables shall be generated.

Running of IDL Konsis requires one user IDLADMIN and all IDL Konsis-User with CONNECT-rights to the database. The maximum lengths of the User-Id and Password should not exceed 8 digits. It is recommended to allocate Temporary Table-space for all user explicitly TEMP.

The User IDLADMIN has the function of < Administrator > in the application IDL Konsis.

1. SQL-Plus is used to register SYSTEM/PASSWORD of the database. To find under Start / All Programs / Oracle - OraDb10g_home1 / application development.
2. Is the user IDLDB still existent after an aborted installtion, delete the user IDLDB with the order: DROP USER idldb cascade; for a clean status please.
3. Creating the user IDLDB:
4. CREATE USER IDLDB PROFILE DEFAULT IDENTIFIED BY idldb DEFAULT TABLESPACE KONSIS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK;
5. Assigning rights:
6. GRANT CONNECT TO IDLDB;
7. GRANT RESOURCE TO IDLDB;
8. GRANT UNLIMITED TABLESPACE TO IDLDB;
9. Creating the user IDLADMIN:
10. CREATE USER IDLADMIN PROFILE DEFAULT IDENTIFIED BY admin DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
11. Assigning rights:
12. GRANT CONNECT TO IDLADMIN;
13. and rights to rules:
14. GRANT ALTER SESSION TO CONNECT;
15. GRANT CREATE VIEW TO RESOURCE;
16. GRANT CREATE SYNONYM TO RESOURCE;
17. Closing SQL-Plus by disconnect.

1. On a computer with Windows put the IDL Konsis-CD "Delivery Database" in the CD device.
2. Start "LieferDB_Oracle.cmd" in the directory "LieferDB" and it opens a "Input-Window".
3. Enter the database name (for example IDLDB).
4. Enter the user name IDLDB.
5. Enter the password for user IDLDB.

Repeat this inputs for two times.

If there exists an export-file of the Oracle database the Import-option of Oracle can be used to load the database. Standard naming of the export-file on IDL Konsis-Installation CD is IDLDB_EXP.DMP, and the Version of the exported Oracle DB is standing in the name of the directory!

The Export-file should be copied before importing it to for reading it from there, because the CD isn't so fast as a disc-device when the IMPORT-Command is activated.

Tip: When you want change datas between two databases with Import and Export, you have look implicitly that the character set are equal of the two databases. Example: Character set "Unicode" and "Not Unicode" are incompatible.

• The User idldb should exist now and be empty!
• If the User idldb isn't empty, the User idldb should be deleted and created new as described in Chapter 4.2.
• The following instructions should be entered into a Prompt (DOS) Window; the path for the parameter FILE and LOG should be customised before:
• - set oracle_sid=idldb
• - imp system/passwort full=y file=C:\idl\import\idldb_exp.dmp log=C:\idl\import\idldbimp.log

The advantage of this procedure is speed and simplicity.

During installations to an existing authority occasionally the request is needed to update the user service class. All tables and views are set to PUBLIC. Through this every user can access all tables. The users of the other authority also therefore come about SQL orders from the IDL Konsis system to the data. To stop this, a role of KONSIS laid out which gets all rights to the tables and views. The PUBLIC rights can be withdrawn from the tables and views again with that. Only the users which will work directly with IDL Konsis get the role of KONSIS allocated now. Scripts (packages) were, made these in the SQL -- can plus be executed for this:

For handling this situation there are defined scripts (packages), which can be executed under SQLPlus.

Konsis_rolle_xx.sql

- generates the role of KONSIS and takes the DBA rights away from the user IDLDB if allocated.

Pck_admin_table_privileges.sql

- generates a package to remove the rights of one user to another user.

Pck_move_index,sql

- generates a package for moving the indicies of one to the other tablespace.

exec_move_public.sql

- example script for moving the Grant rights of PUBLIC to the role of KONSIS.

exec_move_all_index.sql

- example script for moving the indices of Tablespace KONSIS to INDX.

The user IDLADMIN and all further users need the role of KONSIS.

Moving the indices to the Tablespace INDX only is needed if for performance reasons the Tablespace was laid out on another disc.

ATTENTION:

After every IDL Konsis-update, the modification of the rights of the role of KONSIS has to be maintained by using SQL-Plus services again.

The required files are on the IDL Konsis CD "Delivery" in the folder < \DBSAVE\ORACLE\KONSIS-ROLLE-xx-ENG.ZIP. >

Required is the CD: "Oracle 10g Client"

The Oracle Instant Client is not possibly to install, because the OLEDB-driver is not supported.

After mounting the CD the installation-program starts automatically and confirm "Welcome" with "Next".

Step 1: File Locations

Enter the full path of the file you want to install, or confirm the defaults.

Step 2: Installation Types

Select "Custom" as type of installation.

Step 3: Available Product Components

Select additional available product components < Java Client >, <JDBC/THIN Interface>, <OCI (Oracle Call Interface) >, < SQLPlus >, < Network Utilities > and < Windows Interfaces >.

Step 4: Oracle Services for Microsoft Transaction Server

Select Port - Number 2030 for MTS - Recovery Service

Step 5: Summary

Confirm the summery of selected components to start the installation.

After the installation starts automatically "Net Configuration Assistant" with chapter 5.2.1 - "Welcome".

By Manuel configuration go to chapter 3.2 Configuration of Local Net Service Name.

Step 1: Welcome

Confirm without selected "Perform typical installation.

Step 2: Naming Methods Configuration

Select "Local naming" as method.

Step 3: Service Name

Enter the "Service name" from the Oracle database , which is running on the server. Default name is IDLDB

Step 4: Select Protocols

Select the protocol TCP used for the database you want to access.

Step 5: TCP/IP Protocol

Enter the host-name for the computer where the database is located. The Host should be reachable via ping in a DOS window! Select standard port number 1521.

Step 6: Test

A connection test can be performed to the database.

Step 7: Net Service Name

Enter "IDLDB" for this net service name.

Step 8: Another Net Service Name

Confirm with "NO" for another net service name.

Confirm the message "Net service name configuration complete!" and close the program.

Working connections to the server on Windows 95/98-platforms requires the parameter SQLNET.AUTHENTICATION_SERVICES=(NONE)

in the file < Oracle.Installation.Path >\ Network\Admin\sqlnet.ora.