oracle 11g installation and configuration guide

7/28/2019 Oracle 11g Installation and Configuration Guide

1/65

Oracle 11g

Installation and Configuration Guide

Part number: 5998-1358

Software version: iMC PLAT 5.1 (E0202)

Document version: 5P103-20111222


2/65

Legal and notice information

Copyright 2010-2011 Hewlett-Packard Development Company, L.P.

No part of this documentation may be reproduced or transmitted in any form or by any means withoutprior written consent of Hewlett-Packard Development Company, L.P.

The information contained herein is subject to change without notice.HEWLETT-PACKARD COMPANY MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THISMATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY

AND FITNESS FOR A PARTICULAR PURPOSE. Hewlett-Packard shall not be liable for errors containedherein or for incidental or consequential damages in connection with the furnishing, performance, oruse of this material.

The only warranties for HP products and services are set forth in the express warranty statementsaccompanying such products and services. Nothing herein should be construed as constituting anadditional warranty. HP shall not be liable for technical or editorial errors or omissions containedherein.


3/65

Support and other resources

Contacting HPFor worldwide technical support information, see the HP support website:

http://www.hp.com/support

Before contacting HP, collect the following information:

Product model names and numbers Technical support registration number (if applicable) Product serial numbers Error messages Operating system type and revision level Detailed questions

Subscription serviceHP recommends that you register your product at the Subscriber's Choice for Business website:

http://www.hp.com/go/wwalerts

After registering, you will receive email notification of product enhancements, new driver versions,firmware updates, and other product resources.

Related information

DocumentsTo find related documents, browse to the Manuals page of the HP Business Support Center website:

http://www.hp.com/support/manuals

For related documentation, navigate to the Networking section, and select a networking category. For a complete list of acronyms and their definitions, see HP A-Series Acronyms.

Websites HP.com http://www.hp.com HP Networking http://www.hp.com/go/networking HP manuals http://www.hp.com/support/manuals HP download drivers and software http://www.hp.com/support/downloads HP software depot http://www.software.hp.com

1
http://www.hp.com/supporthttp://www.hp.com/go/wwalertshttp://www.hp.com/go/wwalertshttp://www.hp.com/support/manualshttp://www.hp.com/http://www.hp.com/http://www.hp.com/go/networkinghttp://www.hp.com/go/networkinghttp://www.hp.com/support/manualshttp://www.hp.com/support/manualshttp://www.hp.com/support/downloadshttp://www.hp.com/support/downloadshttp://www.software.hp.com/http://www.software.hp.com/http://www.software.hp.com/http://www.hp.com/support/downloadshttp://www.hp.com/support/manualshttp://www.hp.com/go/networkinghttp://www.hp.com/http://www.hp.com/support/manualshttp://www.hp.com/go/wwalertshttp://www.hp.com/support


4/65

ConventionsThis section describes the conventions used in this documentation set.

GUI conventions

Convention Description

BoldfaceWindow names, button names, field names, and menu items are in bold text. Forexample, the New Userwindow appears; click OK.

> Multi-level menus are separated by angle brackets. For example, File > Create > Folder.

Symbols

Convention Description

CAUTIONAn alert that calls attention to important information that if not understood or followed canresult in data loss, data corruption, or damage to hardware or software.

IMPORTANT An alert that calls attention to essential information.

NOTE An alert that contains additional or supplementary information.

TIPAn alert that provides helpful information.

2


5/65

Contents

Overview 1Installation preparations 1

Checking required software packages 1Checking the disk space 2Adjusting kernel parameters 2Creating required user and groups 2Modifying the access right on the Oracle directory 3Creating the Oracle base directory, directory owner and access right 3Modifying the profile file 3Setting environment variables for the oracle user 3Checking the availability of environment variables 4Uploading the Oracle database to be installed 4

Installing Oracle database 11g 5Installing the Oracle database client 28Configuring a network service name 39Managing Oracle database 11g 48

Enabling the Oracle service manually 48Configuring Oracle database 11g 48Adding the database service for a listener 48Setting the maximum number of Oracle processes and Oracle connection limit 49Shutting down the Oracle service manually 49Configuring Oracle automatic startup 50Creating a database user 50Setting the character set for the Oracle client 51Setting database storage space 51

Setting database storage space in the web interface 51Setting database storage space through SQL sentences 53

Modifying database memory parameters 53Setting user password lifetime of the Oracle database 54Changing user passwords of the Oracle database 54

Using database administrators account to change the user password 55Updating the user password in the iMC configuration file 56Unlocking a database user 57

Installing iMC 58

FAQ 59

i


6/65

Overview

This document describes the configuration information you should pay attention to when you install anOracle Database 11g for iMC on the Linux operating system and after the installation.

The database version used in this guide is Oracle Database 11g. If you are using a different Oracledatabase version, the configuration procedure may differ slightly.

Before installing iMC, install Oracle Database 11g first. Then restart the operating system, and proceedwith the iMC installation.

This guide only provides a generic Oracle database installation procedure. You can configure yourOracle database based on system software and hardware to achieve optimized performance. Fordetailed installation procedure and parameter settings of Oracle databases, see Oracle DatabaseInstallation Guide, Oracle Database Quick Installation Guide, and Oracle Universal Installer andOPatch Users Guideat www.oracle.com.

Currently, you can install the database on a separate database server and save the iMC data on thedatabase server. To install the database on a separate database server, follow these guidelines:

On the iMC server, install an Oracle client with the same version as the database. Create a data file folder on the database server before you start the installation. When deploying

the iMC components, you can input the local path to the folder.

CAUTION:

Use the operating system of Linux 5.0.

1


7/65

Installation preparations

CAUTION:

Type rather than copy and paste commands during database installation to make them correctlyrecognized.

A 32-bit operating system must use the 32-bit Oracle database and a 64-bit operating system must usethe 64-bit Oracle database.

le Dat b sBefore installing Orac a a e 11g, log in to the system as a root user and complete configurations

red software packages on

as follows.

Checking required software packagesBefore installing the Oracle database, make sure that you have installed requithe operating system.

CAUTION:

The software packages must be 32-bit.

If you are running Linux AS 5, use rpm qa to check all the installed software packages, and use rpm -q

opy the software package to your local device and use the

stalled are:

- 47. 3

97- 5

- 2. 19

- 2

105- 2

5- 2

. 5- 2

2. 11

to check whether an rpm file is available.

When a software package is not installed, c

rpm -i xxx.rpm command to install it.The software packages that are to be in

bi nuti l s-2.15. 92. 0. 2- 18

compat - l i bstdc++- 33- 3. 2. 3

el f ut i l s- l i bel f - 0. 97- 5

el f ut i l s- l i bel f - devel - 0.

gl i bc-2. 3. 9. 4- 2. 19

gl i bc- common- 2. 3. 9. 4

gl i bc-devel - 2. 3. 9. 4- 2. 19

gcc- 3. 4. 5- 2

gcc- c++- 3. 4. 5

l i bai o- devel - 0. 3.

l i bai o- 0. 3. 105- 2

l i bgcc-3. 4. 5

l i bst dc++- 3. 4.

l i bst dc++- devel - 3. 4

make-3. 80- 5

sysstat - 5. 0. 5

uni xODBC- 2. 2. 11

uni xODBC- devel - 2.

1


8/65

NOTE:

You can locate uninstalled software packages in the server directory of your installation disk and use therpm ivh command to install them.

Checking the disk spaceBefore installing the Oracle database, make sure that the hard disk drive where the home directory islocated has at least 10 GB free space (The actual memory space requirements for the home directorydepend on the managed devices and the number of performance monitoring instances) and the harddisk drive where the /tmp directory is located has at least 400 MB free space. To view available spaceon hard disk drives, use the following command:

#df - k

Adjusting kernel parametersTo ensure the normal operation of the Oracle database, adjust the kernel parameters in the/etc/sysctl.conf directory using a text editor.

If you are running Linux AS 5, make sure that the following kernel parameters take the same or largervalues than those recommended:

kernel . shmal l =2097152

ker nel . shmmax=4294967295

ker nel . shmmni =4096

ker nel . sem=250 32000 100 128

f s. f i l e- max=65536

net . i pv4. i p_l ocal _por t _r ange=1024 65000

net . cor e. r mem_def aul t =4194304net . cor e. r mem_max=4194304

net . cor e. wmem_def aul t =262144

net . cor e. wmem_max=262144

After you adjust the kernel parameters, use the /sbin/sysctl -p /etc/sysctl.conf command to make themtake effect.

Creating required user and groupsYou must create the oracle user, the oinstall group, and the dba group before installing Oracle because:

Only the oracle user can install, start up, or shut down the Oracle database. The oinstall group user can install Oracle software The dba group user can manage the database.To create them, use these commands:

Execute the following commands as the root user:

groupadd oi nstal l

groupadd dba

useradd - g oi nst al l - G dba d / home/ or acl e m s / bi n/ bash or acl e

Set the Oracle user password:

2


9/65

passwd or acl e

Modifying the access right on the Oracle directoryTo enable the oracle user to execute the oracle database installation program, you need to modify theowner and access right of the directory where the Oracle database installation program is to be saved.

#chown - R or acl e: oi nst al l / home/ oracl e/

#chmod -R 775 / home/ or acl e/

Creating the Oracle base directory, directoryowner and access right

Use these commands:

mkdi r - p / u01/ app/

chown - R oracl e: oi nst al l / u01/ app/

chmod - R 775 / u01/ app/

Modifying the profile fileTo make the environment variables of the Oracle database take effect automatically with the systemloading, you need to modify the profile file as follows:

#su - r oot

#vi / etc/ prof i l e

ORACLE_BASE=/ u01/ app/ oracl e

ORACLE_HOME=$ORACLE_BASE/ pr oduct / 11. 1. 0/ db_1

ORACLE_SI D=or clPATH=$PATH: $ORACLE_HOME/ bi n: $HOME/ bi n

LD_LI BRARY_PATH=$ORACLE_HOME/ l i b

expor t ORACLE_BASE ORACLE_HOME ORACLE_SI D PATH LD_LI BRARY_PATH

where,

The directories for ORACLE_BASE and ORACLE_HOME are flexibly set specific to the directorystructure.

ORACLE_SID is the Oracle database instance ID. Note that you must specify consistentORACLE_SID in the subsequent installation procedure.

Save the file after setting the language environment variable.

Setting environment variables for the oracle userTo ensure normal startup and operation of the Oracle database, you must configure the environmentvariables for the oracle user. For example, set the environment variables in file .bash_profile in the homedirectory:

su - or acl e

vi . bash_prof i l e

1. Open the file and set the language environment variable according to the language your systemsupports.

3


10/65

4

LANG=en_US. UTF- 8

expor t LANG

2. Add the following line at the end of the text.umask 022

3. Save the file, exit the system, and re-log in as the oracle user.exi tsu - or acl e

expor t DI SPLAY=l ocal host : 0. 0

Checking the availability of environment variablesBefore installing the Oracle database, make sure that the environment variables have taken effect.Otherwise, you will fail to install the Oracle database. For more information, see How to verify if theenvironment variables take effect?.

Uploading the Oracle database to be installedCopy the Oracle installation package to the /home/oracle directory and decompress the package. Ifyou use the installation disk, just follow the guide of the disk.

Now, the preparation for installing the Oracle database is completed. Restart the operating system andthen proceed with the Oracle installation.


11/65

Installing Oracle database 11g

After restarting the operating system, log in to the system as the oracle user, and perform the followingcommand in the installation package directory:

$. / runI nstal l er

. NOTE:

Input a dot (.) in front of theslash (/) in the preceding command line.

Run the runInstallarprogram in the installation package to display the universal installation screen, asshown in Figure 1.

Figure 1Select an installation method

Select Advanced Installation and click Next to enter the installation type selection page as shownin Figure 2.

5


12/65

Figure 2Select installation type

Select Enterprise Edition and click Next to enter the installation location selection page, as shownin Figure 3.

6


13/65

Figure 3Select installation location

Use the default settings, and click Next to enter the product-specific prerequisite checks page, as shownin Figure 4.

7


14/65

Figure 4Product-specific prerequisite checks

In Figure 4, the installation program checks the environment settings and displays the check results.Manually verify the items that are flagged with warnings and items that require manual check, andmodify the environment settings. Then click Next. If no item needs to be verified manually, click Next toenter the configuration option selection page, as shown in Figure 5.

8


15/65

Figure 5Select configuration option

Use the default settings and click Next to enter the database configuration selection page, as shownin Figure 6.

9


16/65

Figure 6Select database configuration

SelectAdvanced and click Next to enter the privileged operating system groups configuration page, asshown in Figure 7.

10


17/65

Figure 7Configure privileged operating system groups

Use the default settings, and click Next to enter the Oracle configuration manager registration page, asshown in Figure 8.

11


18/65

Figure 8Register Oracle configuration manager

If you have purchased the Oracle license, select Enable Oracle Configuration Manager, type theauthorization information and click Next to enter the summary page, as shown in Figure 9.

12


19/65

Figure 9Summary

The summary page displays the settings you previously made. Click Install to start installing OracleDatabase 11g. Figure 10 shows the installation progress bar.

13


20/65

Figure 10Installation progress

After the installation, you will enter the database template page, as shown in Figure 11.

14


21/65

Figure 11Database template

Select Custom Database and click Next to enter the database identification page, as shown in Figure 12.

Figure 12Database identification

15


22/65

Enter the global database name and SID (the SID must be consistent with ORACLE_SID in Modifying theprofile file), and click Next to enter the management options configuration page, as shown in Figure 13.

Figure 13Management options

Use the default settings and click Next to enter the database credentials configuration page, as shown

in Figure 14.

16


23/65

Figure 14Database credentials

You can set different passwords for the database accounts SYS, SYSTEM, DBSNMP, and SYSMAN, oruse the same password for all accounts. Then click Next to enter the storage options configuration page,as shown in Figure 15.

CAUTION:

For iMC to correctly identify the password of the user SYS during installation, make sure that the passworddoes not contain any of the following characters:` ' \ " ! ( ) & | \\ $ ; @ < > / ^ \t

If you do not want to change the password of the user SYS, create a user with same privileges and makesure that the password does not contain any of the previous characters. For more information aboutcreating a database user, see Creating a database user.

17


24/65

Figure 15Storage options

Select File System, and click Next to enter the database file location configuration page, as shownin Figure 16.

Figure 16Database file locations

18


25/65

Select Use Database File Locations from Template and click Next to enter the database recoveryconfiguration page, as shown in Figure 17.

Figure 17Recover database configuration

Use the default settings, and click Next to enter the database content configuration page, as shown

in Figure 18.

19


26/65

Figure 18Set database content

Use the default settings and click Next.

On the initialization parameters configuration page, configure the memory settings according to theinstallation type and physical memory size, as shown in Figure 19.

20


27/65

Figure 19Set initialization parameters

Typical is selected by default. See Table 1 for setting the memory size.

Table 1Value for setting memory size

System memory For centralized database For standalone database4 G 1400 M 2400 M

6 G 2400 M 3600 M

8 G 3600 M 4800 M

10 G or larger 4500 M 5000 M

Click the Character Sets tab and set the character set for the database, as shown in Figure 20.

21


28/65

Figure 20Set the character set

NOTE:

You can set WE8ISO8859P1 for western European languages. Make sure the database character set isset correctly, or garbled characters may appear. For more information about setting database character

set, see Oracle Database Globalization Support Guideat www.oracle.com. If you are not sure of the language, select Use Unicode (AL32UTF8) for the database character set.

After setting the initialization parameters, click Next to enter the security settings page, as shownin Figure 21.

22


29/65

Figure 21Security settings

Use the default settings and click Next to enter the automatic maintenance tasks configuration page, asshown in Figure 22.

23


30/65

Figure 22Configure automatic maintenance tasks

Select Enable automatic maintenance tasks and click Next to enter the database storage configurationpage, as shown in Figure 23.

24


31/65

Figure 23Configure the database storage

Select Tablespaces> USERS from the navigation tree to enter the General page. Select Use bigfileTablespace and click Next to enter the database creation options page, as shown in Figure 24.

Figure 24Create database

25


32/65

Use the default settings and click Finish to start creating the database.

After the database is created, a configuration script window appears, as shown in Figure 25.

Figure 25Execute configuration scripts

Open a terminal window, log in as the root user, and execute the scripts. Then on the configuration scriptwindow, click OKto complete installation, as shown in Figure 26.

26


33/65

Figure 26Complete installation

27

Click Exit tocomplete installing the database.


34/65

Installing the Oracle database client

To deploy the iMC server and database server on different hosts, you must install the Oracle 11g clientwith the same version as the database server on the iMC server.

For installation preparations, see the chapter Installation preparations.

After restarting the operating system, log in to the system as an Oracle user. In the Oracle clientinstallation directory, execute the following command:

$. / runI nstal l er

The welcome page appears, as shown in Figure 27.

Figure 27Welcome page

Click Next to enter the inventory directory and credentials selection page, as shown in Figure 28.

28


35/65

Figure 28Specify inventory directory and credentials

Use default settings. Click Next to enter the installation type selection page, as shown in Figure 29.

29


36/65

Figure 29Select an installation type

Select Custom, and click Next to enter the location selection page, as shown in Figure 30.

30


37/65

Figure 30Select a location

Type the ORACLE_SID in the Name field. The value must be consistent with the ORACLE_SID of thedatabase server for a correct connection. Use defaults for other settings, and click Next to enterproduct-specific prerequisite check page, as shown in Figure 31.

31


38/65

Figure 31Product-specific prerequisite checks

The installation program checks the system environment, and displays the result. If your systemenvironment settings meet the requirement, click Next to enter available product components page, asshown in Figure 32; if not, you must modify your system environment variables as prompted before goingto the next step.

32


39/65

Figure 32Available product components

Select the following components: Oracle SQLJ Oracle Database Utilities Oracle Java Client SQL *Plus Oracle JDBC/THIN Interfaces Oracle Call Interface (OCI) Oracle ODBC Driver Oracle SQL DeveloperClick Next to enter the summary page, as shown in Figure 33.

33


40/65

Figure 33Summary page

Click Install to enter the installation page, as shown in Figure 34.

34


41/65

Figure 34Install the product

The script execution page shown in Figure 35 appears during installation.

35


42/65

Figure 35Execute the configuration scripts

Open a terminal window, and log in as the root user. Execute the scripts in the specified directory, asshown in Figure 36.

36


43/65

Figure 36Execute the scripts

After executing the scripts, close the terminal window and return to the script execution page. Click OKto enter the end of installation page, as shown in Figure 37.

37


44/65

Figure 37End of installation

38

Click Exit to complete the installation and start the database connectivity check process.


45/65

Configuring a network service name

CAUTION:

If iMC servers deployed in distributed mode do not use the same database, do not configure networkservice names with the same name but different configurations for the iMC servers.

When an iMC server does not use the local database server, you must configure a network service namefor the iMC server to connect to its database server. The network service name includes the parameters,such as the name, host name, protocol, and database name.

You can configure the network service name in the following ways:

Execute the command as an Oracle user:

net ca

The window for configuring an Oracle network service name appears.

Figure 38Welcome interface

Select Local Net Service Name configuration and click Next.

39


46/65

Figure 39Select an operation

SelectAdd and click Next. You can also select any other operation as needed.

Figure 40Service Name

40


47/65

Enter the service name of the database you want to access and click Next. An Oracle databases servicename is normally its global database name.

Figure 41Select a protocol

Select transmission protocol TCP and click Next.

41


48/65

Figure 42Configure host name and port number

Enter the IP address of the database server, select Use the standard port number of 1521, and click Next.

Figure 43Perform a test

SelectYes, perform a test and click Next.42


49/65

Figure 44Test interface

The interface displays the test result of connecting to the Oracle database server. If the connection fails,click Change Login to change the login username and password.

Figure 45Change username and password

43


50/65

Still use the username system, enter the password (which was set during the database installation), andclick OK.

Figure 46Test result

The interface shows that the connection is successful and you can access the Oracle database server.

Click Next.

44


51/65

Figure 47Enter a name for the network service name

Enter a name for the network service name. This name is automatically added to the list for selecting anetwork service name when you install iMC. Click Next.

Figure 48Whether to configure another network service name

45


52/65

If you want to configure another network service name, selectYes and click Next. If not, select No andclick Next.

Figure 49Complete network service name configuration

Click Next to complete network service name configuration.

46


53/65

Figure 50Finish

47

Click Finish.

To illustrate the network service name configuration, take the following application scenarios forexample:

Scenario 1:

If Server A (master iMC server), and Servers B and C (subordinate iMC servers) use local databases andhave been configured with network service names TNSNAME_A for connecting to Server A,TNSNAME_B for connecting to Server B, and TNSNAME_C for connecting to Server C, respectively, youmust configure the other two unavailable network service names for each server, for example,TNSNAME_B and TNSNAME_C for Server A. The configuration of the same network service name mustbe the same.

Scenario 2:

If Server A (master iMC server), and Servers B and C (subordinate iMC servers) use a separate databaseserver DBServer_D and have been configured with a network service name TNSNAME_D for connecting

to DBServer_D, Servers A, B, and C can use the network service name TNSNAME_D when you installiMC on them.

NOTE:

The network service names in the example are for illustration only.


54/65

Managing Oracle database 11g

To operate the database, you must log in to the system as oracle. Perform the commands in thesubsequent sections as the oracle user unless otherwise specified.

NOTE:

The following operations apply only to the Oracle database server.

Enabling the Oracle service manually1. Enable the listener controller

After rebooting the operating system, enable the listener controller using the following commands:

$ cd $ORACLE_HOME/ bi n$ . / l snrc t l s tar t

To view the status of the listener controller named lsnrctl, use the following command:

$ . / l snrc t l servi ce

2. Enable the Oracle databaseAfter ensuring that you have successfully started up the listener controller, start up the Oracle databasewith the following commands:

$ cd $ORACLE_HOME/ bi n

$ . / sql pl us sys/ or a123 as sysdba

SQL>st ar t up

SQL>exi t

where, sys is the name of the administrator user of the Oracle database, and the user password is ora123.After running the preceding commands, you can successfully start up the Oracle database.

Configuring Oracle database 11gAfter the installation, make some configurations by changing the configuration file directly, or using thetool netmgr offered by Oracle. The following parts of this section specify how to configure the Oracledatabase using netmgr. Tool netmgr locates in the $ORACLE_HOME/bin/ directory. To enable netmgr,use the following commands:

$ cd $ORACLE_HOME/ bi n/

$ . / netmgr &

Adding the database service for a listenerOn page Oracle Net Manager, select node LISTENER from the navigation tree. Select Database Servicesfrom the list box and then clickAdd Database. Specify the global database name, Oracle home directory,and the SID specified during the Oracle installation. Make sure the global database name and the SIDare the same as those configured in the database identification page (see Figure 12). The detailedconfigurations are shown in Figure 51.

48


55/65

Figure 51Add the database service for a listener

Setting the maximum number of Oracle processesand Oracle connection limit

By default, the Oracle database allows 150 connections at most. When multiple iMC modules aredeployed in centralized mode, or database errors occur on some iMC modules, you must set a propermaximum number of Oracle processes and a proper Oracle connection limit. For more informationabout the configuration procedure, see the chapter FAQ in HPIntelligent Management Center GettingStarted Guide.

Shutting down the Oracle service manuallyTo shut down the Oracle service, you need to shut down the Oracle database first, and then the listenercontroller.

1. Shut down the Oracle databasePerform the following commands:

$ . / sql pl us sys/ or a123 as sysdba

SQL>shut down i mmedi at e

SQL>exi t

where, sys is the name of the administrator user of the Oracle database, and the user password isora123.

2. Shut down the listener controller$ cd $ORACLE_HOME/ bi n

$ . / l snrc t l s top

49


56/65

Now, the Oracle service is shut down.

Configuring Oracle automatic startupTo achieve Oracle automatic startup at the Linux operating system startup, register Oracle as the system

service.1. Copy the script file named oracled.tar.gz to the Linux operating system and then use the following

command to unzip the file:

t ar - xzf oracl ed. t ar. gz

NOTE:

The oracled.tar.gz file is in the manual/db/Oracle directory of the iMC installation package.

2. Copy the unzipped file to the directory of /etc/rc.d/init.d/. (Execute the cp command as a rootuser.)

cp orac l ed /etc/ rc . d/ i ni t . d/

3. Modify the attribute value of the file to 755 with the command chmod. (Execute the chmodcommand as a root user.)

chmod R 755 or acl ed

4. Execute the service register command as a root user:chkconf i g - - add or acl ed

5. Edit the Oracle configuration file /etc/oratab, and change the last line:vi / et c/orat ab

Change the line:

or cl : / u01/ app/ or acl e/ pr oduct/ 11. 1. 0/ db_1: N

to:or cl : / u01/ app/ or acl e/ pr oduct/ 11. 1. 0/ db_1: Y

6. You can use the commands of service oracled start and service oracled stop to start and stopOracle services.

Creating a database userFollow these steps to create a database user:

1. Log in to the Oracle database as the user SYS:. / sql pl us sys/ i MC123 as sysdba

sys is the username and iMC123 is the password.2. Create a user imc:

cr eat e user i mc i dent i f i ed by i mcpassword;

imc is the username and imcpassword is the password.

CAUTION:

For iMC to correctly identify the password during installation, make sure that the password does notcontain any of the following characters:` ' \ " ! ( ) & | \\ $ ; @ < > / ^ \t

3.

Grant the sysdba privilege to the user:50


57/65

grant sysdba t o i mc;

NOTE:

Database users must be granted with the sysdba privilege for connecting to the database. Otherwise,deployment errors occur.

Setting the character set for the Oracle clientAfter installing the Oracle database using the previous steps, you must set the NLS_LANG environmentvariable to comply with the client language environment. To make the NLS_LANG environment variableautomatically take effect with the system loading, modify the /etc/profile file as follows:

To set the language environment variables for client character set NLS_LANG, use these commands fordifferent languages:

EnglishNLS_LANG=AMERI CAN_AMERI CA. WE8I S08859P1

export NLS_LANG

Other languagesSet a proper character set with the following format.

NLS_LANG=LANGUAGE_NATI ONAL. CHARACTERSET

export NLS_LANG

. TIP:

You can set WE8ISO8859P1 for western European languages. Make sure the character set is setcorrectly, or garbled characters may appear. For more information about setting the client character set,see Oracle Database Globalization Support Guideat www.oracle.com.

Setting database storage spaceIf you install the database by following the steps above, skip this section for you have specified big filetable space.

The size of a file in the Oracle database is up to 32 G. If no big file system is specified, you should addfiles to the USERS table space to provide storage space after installing the database.

The number of files then will be added depends on the disk space needed for all iMC components. Forexample, if iMC needs 190 G to manage more than 5000 devices, you should create at least six files

(190 G/32 G = 5.9375). If a database has several iMC components installed, create files according tothe total needed size of the components.

Setting database storage space in the web interface1. Log in to the operating system as the oracle user, and use the emctl start dbconsole command to

start up the web management system.

[ or acl e@l ocal host bi n] $ emct l st art dbconsol e

2. Access the website https://ip address:1158/em. ip address is the IP address of the Oracle server.3. Log in to the web interface as the SYSTEM user. Select Server> Datafiles, as shown in Figure 52.

51


58/65

Figure 52Database instance management interface

The data file management interface appears after you click Datafiles, as shown in Figure 53.

Figure 53Data file management interface

4. Select the data file of the USERS table space and click Go next to Create like to enter the page, asshown in Figure 54.

52


59/65

Figure 54Create a data file

5. Type the file name and file directory. You can also use the default directory for file directory. Whenfinishing all the settings, click OK.

Repeat these steps to add more data files. If your system has multiple disks, distribute the files on differentdisks for I/O load balancing.

Setting database storage space through SQL sentences1. Log in to your operating system as the oracle user, and then log in to the Oracle database as the

sys user with the following commands.

[ r oot @i MCSer ver ~] #su - oracl e

[ oracl e@i MCSer ver ~] $sql pl us sys/ syspassword@orcl as sysdba

syspassword is the password of the sys user, and orcl is the Oracle instance.

2. Perform the following SQL sentence to check the number of data files in the USERS table space andfile directory.

SQL> sel ect f i l e_name f r om dba_dat a_f i l es wher e t abl espace_name=' USERS' ;

FI LE_NAME

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

/ u01/ app/ or acl e/ or adat a/ or cl / user s01. dbf

The output shows that the files are saved in the directory /u01/app/oracle/oradata/orcl/.

3. Add users02.dbf in the directory. Use the following sentence to add a data file in the newdirectory.

SQL> al t er t abl espace USERS add dataf i l e ' / u01/ app/ oracl e/ oradata/ or cl / userdat a02. dbf '

si ze 100M aut oext end on next 100M maxsi ze UNLI MI TED;

You can add many data files with these steps.

Modifying database memory parametersIf the database memory parameters are not specified in the chapter Installing Oracle database 11g,follow these steps to set the memory parameters.

53


60/65

1. Log in to your operating system as the oracle user, and then log in to the Oracle database as thesys user with the following commands.

[ r oot @i MCSer ver ~] # su - oracl e

[ oracl e@i MCSer ver ~] $ sql pl us sys/ syspassword@orcl as sysdba


2. Set the MEMORY_TARGET with the following sentence. For the reference value, see Table 1.SQL> al t er syst em set MEMORY_TARGET=1700M scope=spf i l e;

Setting user password lifetime of the Oracledatabase

By default, the user password lifetime of the Oracle database is 180 days. You can follow these steps toset a password to Unlimited.

1. Log in to your operating system as the oracle user, and then log in to the Oracle database as thesys user with the following commands.

[ r oot @i MCSer ver ~] #su - oracl e

[ oracl e@i MCSer ver ~] $sql pl us sys/ syspassword@orcl as sysdba


2. Use the following commands to set and display the password of the sys user.SQL> sel ect * f r om dba_pr of i l es s wher e s. pr of i l e=' DEFAULT'

and r esour ce_name=' PASSWORD_LI FE_TI ME' ;

PROFI LE RESOURCE_NAME RESOURCE LI MI T

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

DEFAULT PASSWORD_LI FE_TI ME PASSWORD 180dys

The output shows that the lifetime of the user is 180 days.3. Use the following commands to set the user password to Unlimited.SQL> ALTER PROFI LE DEFAULT LI MI T PASSWORD_LI FE_TI ME UNLI MI TED;

The modification takes effect immediately without rebooting your database and the password will neverexpire.

Changing user passwords of the Oracle databaseIf a user password uses the default lifetime, you must change the password before the user runs for 180days. You can view all the existing iMC users in the $IMCROOT/common/conf/server-addr.xml file. The

username in each db-config represents a user account.

If your iMC components are not installed at the same time, query the expiration date of user passwordsby executing the following SQL sentence:

Sel ect * f r om dba_user s where username = dat abase username

54


61/65

Figure 55The query result

To change a user password, follow these steps:

1. Using database administrators account to change the user password2. Updating the user password in the iMC configuration fileIf the new password is the same as the one to be expired, you do not need to update the user passwordin the iMC configuration file.

If you change the password in Oracle or iMC without updating the iMC configuration files, the useraccount will be locked because of inconsistent passwords. For how to unlock a user account, seeUnlocking a database user.

The following examples illustrate how to change the password of user imc_config, and how to unlock theuser.

IMPORTANT:

Stop iMC before you change passwords. After you complete changing user passwords, start iMC.

Using database administrators account to change the userpassword

1. Query the password of the Oracle database user by executing the pwdmgr.sh -query scriptprovided by iMC.

Figure 56Query the password of the imc_config user

As shown in Figure 56, the password of the imc_config user is iMC5_u4b22q.

2. Log in to your operating system as the oracle user, and then log in to the Oracle database as thesys user with the following commands:

55


62/65

[ r oot @i MCSer ver ~] # su - oracl e

[ oracl e@i MCSer ver ~] $ sql pl us sys/ syspassword@orcl as sysdba


3. Execute the following SQL sentence to change the password of a specified user.SQL>al t er user i mc_conf i g i dent i f i ed by dbpasswd

dbpasswd is the new password of user imc_config.

Updating the user password in the iMC configuration fileUse the following commands to update the password of user imc_config in the iMC configuration file.

[ r oot @daemon8829 i MC] # cd depl oy/

[ r oot@daemon8829 i MC] # . / pwdmgr. sh modi f y 127. 0. 0. 1 or cl i mc_conf i g dbpasswd

Change password successf ul l y

dbpasswd is the new password of the user, and is the same as that configured in Using databaseadministrators account to change the user password. orcl is the Oracle instance, and 127.0.0.1 is the IP

address of the Oracle database. For information about the Oracle instance and the IP address of theOracle database, see the $IMCROOT/common/conf/server-addr.xml file.

If the password of an iMC component expires, change the database user password in the iMCconfiguration file by using the same commands.

NOTE:

The usernames and passwords used by the iMC modules are stored in cipher text in file\common\conf\ server-addr.xml in the installation path. You can use the ./pwdmgrcommand toobtain passwords in clear text or update the latest passwords to the file.

Usually, a user can use the database management tool to change the database password of a certainiMC module. To ensure communication between iMC and the database, use the ./pwdmgrcommandto update the corresponding password in file server-addr.xml. If iMC is deployed in distributed mode,you must update the password for every iMC server.

TIP:

You must set password sqlsql for the report database in iMC, or the database does not work.

If you have installed UAM/EAD V3.60 and its patches, change passwords for user ead in the followingconfiguration files.

Table 2Change passwords for user eadFile Variable name Remarks

iMC\uam\etc\uam.conf DBUserPassword If you are using E6301, E6301P01, orE6301H02, modify the value forvariable PlatDBUserPassword in theiMC\uam\etc\uam.conf file to thepassword for user imc_config. Theuamjob directory exists only in theE6301L03 and later versions.

iMC\portal\conf\portal.properties database.password

iMC\uamjob\conf\uamjob.properties database.password

iMC\ead\conf\server.xml password

If you have installed the DAM component, set the password in the iMC\dam\conf\server.xml file to thepassword for DAM database user account dam.

56


63/65

If you have installed the UAM, EAD, or CAMS E6301 version and changed the database user password,you must change the passwords of all database users listed in the iMC/deploy/conf/component-env.xml file before you can upgrade the components.

Unlocking a database userIf iMC services cannot start after you change user passwords, a user account is locked. To check whichuser account is locked, use the user accounts with passwords changed to log in to the Oracle system atthe command line interface (CLI). If a user account is locked, a message shown in Figure 57 appears.

57

Figure 57The user is locked

In this example, user imc_config is locked. Log in to the Oracle database as administrator sys, andexecute the following command to unlock the user:

SQL> ALTER USER i mc_conf i g ACCOUNT UNLOCK;

After the user is unlocked, change the password for the user in Oracle and iMC, and make sure that thetwo passwords are consistent.

If you do not want to lock a user that is attempting multiple times to log in with a wrong password,

execute the following command:SQL> ALTER PROFI LE DEFAULT LI MI T FAI LED_LOGI N_ATTEMPTS UNLI MI TED;

Use the command with caution because the database will never lock such user.


64/65

Installing iMC

After completing all the configurations, reboot your operating system and log in to it as the root user. Forinformation about how to install iMC, see iMC Installation Guide.

TIP:

After installing iMC, use the following commands to enable the iMC deployment monitoring agent.

root@Linux-105 /opt/iMC/deploy]# ./dms.sh start

root@Linux-105 /opt/iMC/deploy]# ./dma.sh

58


65/65

FAQ

How to handle the case where the system displays that the space is not enough when creating thedatabase instance?

Check whether you have the file in the etc/sysctl.conf directory correctly configured. For moreinformation, see Adjusting kernel parameters.

How to handle garbled characters displayed on iMC?

The garbled characters may be caused by the following reasons:

Incorrect character set for the databaseGarbled characters may appear if you set the character set that is incompatible to iMC. For example,you set the English character set for Chinese iMC system. To solve this problem, reinstall the Oracle

database, and select the correct character set. Incorrect character set for the clientsGarbled characters may appear when NLS_LANG is not correctly set or modified during iMC operation.To solve this problem, correct the environment variable and restart the server and iMC.

Incorrect environment variables for the server and the default installation of the Oracle databaseIf you install the Oracle database by using the default mode, the Oracle is set with the default characterset according to the LANG environment variables, which may not be correctly set. For example, if you usethe default installation where LANG is C to install a database of Japanese character set,

WE8ISO8859P1 will be set as the character set, so garbled characters appear. To solve this problem,follow the correct steps to re-install the Oracle database.

You can follow the steps as in to install the Oracle database.

TIP:

For more information about setting the database and client character sets, see Oracle DatabaseGlobalization Support Guidein the Oracle at www.oracle.com.

How to verify if the environment variables take effect?

Execute the command echo $variable name to verify if the configurations about the home directory,Oracle LIB, and Oracle instance take effect.

For example:

#echo $ORACLE_HOME

/ u01/ app/ or acl e/ pr oduct/ 11. 1. 0/ db_1

#echo $LD_LI BRARY_PATH

/ u01/ app/ oracl e/ pr oduct/ 11. 1. 0/ db_1/ l i b