lundi 27 mars 2017

Install Oracle Enterprise Manager 12c (12.1.0.4) on Linux

1 System prerequisites

1.1.                       Hardware requirements
  • RAM : 8GB or More
  • Raid 1 disks with minimum 50GB for Oracle Software
  • Raid 5 disks with minimum 100GB  for Oracle Management Repository Database
  • Swap : 8GB
1.2.                     Software requirements

·         Oracle Linux  6.5 (x86_64)

1.3.                     Oracle Enterprise Linux 6.5
1.3.1.      Group Packages needed
  • Base System > Base
  • Base System > Client management tools
  • Base System > Compatibility libraries
  • Base System > Hardware monitoring utilities
  • Base System > Large Systems Performance
  • Base System > Network file system client
  • Base System > Performance Tools
  • Base System > Perl Support
  • Servers > Server Platform
  • Servers > System administration tools
  • Desktops > Desktop
  • Desktops > Desktop Platform
  • Desktops > Fonts
  • Desktops > General Purpose Desktop
  • Desktops > Graphical Administration Tools
  • Desktops > Input Methods
  • Desktops > X Window System
  • Development > Additional Development
  • Development > Development Tools
  • Applications > Internet Browser
1.3.2.  Additional Packages

Install the following packages if they are not already present.

binutils-2*x86_64*
glibc-2*x86_64* nss-softokn-freebl-3*x86_64*
glibc-2*i686* nss-softokn-freebl-3*i686*
compat-libstdc++-33*x86_64*
glibc-common-2*x86_64*
glibc-devel-2*x86_64*
glibc-devel-2*i686*
glibc-headers-2*x86_64*
elfutils-libelf-0*x86_64*
elfutils-libelf-devel-0*x86_64*
gcc-4*x86_64*
gcc-c++-4*x86_64*
ksh-*x86_64*
libaio-0*x86_64*
libaio-devel-0*x86_64*
libaio-0*i686*
libaio-devel-0*i686*
libgcc-4*x86_64*
libgcc-4*i686*
libstdc++-4*x86_64*
libstdc++-4*i686*
libstdc++-devel-4*x86_64*
make-3.81*x86_64*
numactl-devel-2*x86_64*
sysstat-9*x86_64*
compat-libstdc++-33*i686*
compat-libcap*

SELINUX=permissive
Firewall=Disable

1.3.3.  Other manual setup

·         The /etc/hosts file must contains the following qualified name of the server:
<IP-address>  <fully-qualified-machine-name>  <machine-name>
e.g
127.0.0.1       localhost
10.253.15.181   oem-srv12.mtncameroon.net    oem-srv12
·         Add the following lines in the /etc/sysctl.conf file :
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
#kernel.shmmax = 536870912
kernel.shmmax = 4126760960
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
And then, run the following command to change the current kernel parameters :
/sbin/sysctl -p
·         Add the following lines in the /etc/security/limits.conf file :
oracle              soft    nproc   16384
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240


·         Create the new groups and user :
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 asmadmin
groupadd -g 506 asmdba
groupadd -g 505 asmoper
 
useradd -u 502 -g oinstall -G dba,asmdba,oper oracle
passwd oracle

Notes:
a.      Set the password for the “oracle” user
b.      On this installation, we do not use ASM.

·         Amend the /etc/security/limits.d/90-nproc.conf file, as described below :
# Change this
*          soft    nproc    1024
 
# To this
* - nproc 16384

·         Create the directories in which the oracle software (Oracle Database, Oracle Management Server and Oracle Management agent) will be installed:
mkdir -p /u01/app/oracle/product/11.2.0/db_1
 
mkdir -p /u01/app/Middleware
mkdir -p /u01/app/Agent
chown -R oracle:oinstall /u01
chmod -R 775 /u01

2.   Oracle Database installation

2.1.                     Profile configuration
As oracle user, add the following lines at the end of the “.bash_profile” file:
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=server_name.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=emrep; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
OMS_HOME=/u01/app/Middleware/oms; export OMS_HOME
AGENT_HOME=/u01/app/Agent; export AGENT_HOME
ORACLE_SID=emrep; export ORACLE_SID

PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

2.2.                    Installation and Database creation

·         If you’re using X emulation, then set the DISPLAY environmental variable:

Export DISPLAY=<server_name>:0.0

·         After unpack the two files:
unzip p10404530_112030_Linux-x86-64_1of7.zip
unzip p10404530_112030_Linux-x86-64_2of7.zip
·         And start the Oracle Universal Installer (OUI) by using the following command on database directory:
./runInstaller
·         At the end of software installation, create the repository database with 3 redo log groups and a least 300Mo of each redo log member.

·         Make the following initialization parameter changes and restart the instance :


ALTER SYSTEM SET processes=600 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;

startup force




3.    Cloud control 12c installation
Copy and unzip the cloud control 12c media and start the installation by executing the “runInstaller” script:

unzip em12104_linux64_disk1
unzip em12104_linux64_disk2
unzip em12104_linux64_disk3


./runInstaller


·         Uncheck the security update checkbox and click the “Next” button :



·         If you wish to check for updates, enter the required details. In our case, we check the “Skip” option. We can check for updates later.



·         If you are performed the prerequisites as described, the installation should pass all prerequisite check. Click the “Next” button :


·         Select “Create the new Enterprise Manager System” and choose the Advanced Option :



·         Enter the middleware and the agent locations and then, click “Next” button :



·         Select the management plug-ins, you want to configure. It’s also possible to remove or add after you install Enterprise Manager. Click to “Next” button.

We can notice that Enterprise Manager Agent doesn’t exist for MySQL and Postgres Databases.


·         Enter the weblogic and node manager password and then, click “Next” button :


·         Specify the OMR database host name, the listener port, the service name and SYS password. Click “Next” button.
Note: The listener must be started on the hostname and the OMR database must be opened.


·         If you are performed the default 11g installation, you will need to deconfigure Enterprise Manager Database control by executing the following command :

$ emca -deconfig dbcontrol db -repos drop -SYS_PWD <sys pasword> -SYSMAN_PWD <sysman password>


·         On the first warning, click the “Yes” button:

·         Specify the SYSMAN and the agent registration password and click “Next” button.



·         Click “Next” button

·         Click “Install” button


·         As root user, open terminal and execute the “allroot.sh” script. When the script is finish, return to this window and click “Ok” button :

·         Make note of the URLs, then click the "Close" button to exit the installer. A copy of this information is available in the "/u01/app/oracle/oms12cr4/oms/install/setupinfo.txt" file

·         The login screen is available from a browser using the URL provided in the previous screen ("https:// https://10.252.34.27:7802/em"). Log in with the username "sysman" and the password you specified during your installation.

Once logged in, you are presented with the "Accessibility Preference" screen. Click the "Save and Continue" button and you are presented with the the "License Agreement" screen. Click the "I Accept" button and you are presented with the homepage selector screen. On the right side of the screen it lists the post-installation setup tasks you need to work through:




How to fix errors : -         ORA-38760: This database instance failed to turn on flashback database -         ORA-38780: Restore poin...