Tuesday, March 31, 2015

Oracle Enterprise Manager Cloud Control 12c Release 4 Installation on OEL 6.5

PS:When Installing 12EMGrid Controller .THis will implicitly install WebLogic Server 10.3.6

First of  all you will have to deconfig the Enterprise Manager Console (EM) of the EM Repository Database

[oracle@emgrid admin]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Mar 16, 2015 7:51:40 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: ORCL
Listener port number: 1521
Password for SYS user: 
Password for SYSMAN user: 
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 16, 2015 7:54:33 AM

Then Install following RPMs on OEL6.5

yum install make -y
yum install binutils -y
yum install gcc -y
yum install libaio -y
yum install glibc-common -y
yum install libstdc++ -y
yum install libXtst -y
yum install sysstat -y
yum install glibc-devel -y
yum install glibc -y
yum install libaio -y
yum install glibc-devel.i686 -y

Then you will have to configure database for  preticular values

SQL> ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
System altered.
SQL> ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>


Edit Following value for /etc/security/limits.conf  set the minimum value 4096

oracle   soft   nofile    4096 // default it was  1024

Then create  Following Folders

mkdir -p /u01/app/oracle/Middleware12C2
mkdir -p /u01/app/oracle/Agent12C2

Now Start running the Installer

cd /tmp/FULLGrid12c
./runInstaller.sh

This will start the installation window.

Unchecked the check box and click Next

















Choose skip ,Click Next

















Pre-chek is going on




 














  Create a new  Simple Enterprise Manager

















Choose the Middle ware Location and Agent Base Location.
Enter Host Name as a emgrid


















Enter Administrator Password  this is for weblogic Server administrations,Node Manager ,MDS administration,SYSMAN user account and OMS registration.
Enter database details for Repository.


















When you click Next  this will ask for a pop up  window.Click YES


















Click on Install.

















Installing ;)



















Enter following values to  .bash_profile
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
export OMS_HOME=/u01/app/oracle/Middleware12C2/oms
export AGENT_HOME=/u01/app/oracle/Agent12C2/core/12.1.0.4.0

# Start everything
$ORACLE_HOME/bin/dbstart $ORACLE_HOME
$OMS_HOME/bin/emctl start oms
$AGENT_HOME/bin/emctl start agent

# Stop everything
$OMS_HOME/bin/emctl stop oms -all
$AGENT_HOME/bin/emctl stop agent
$ORACLE_HOME/bin/dbshut $ORACLE_HOME
 

Friday, March 20, 2015

Enabling YUM Repository update on OEL6.5

Edit the /public-yum-ol6.repo file  resides in   /etc/yum.repos.d

vi /etc/yum.repos.d/public-yum-ol6.repo

enable the following locations

You Need to enable the following block's enabled value to 1 
[public_ol6_latest]
[public_ol6_UEK_latest]
















If you company has proxy settings,You may have to set the proxy settings like follows.

export http_proxy=ip:port/
ex:
export http_proxy=192.9.220.235:3128/

Then type  yum  list. You May list down all the rpms available.




Monday, March 2, 2015

Useful RMAN Commands(Deleting Archivelogs)


List archivelogs

RMAN> list archivelog all;
RMAN>list copy of archivelog  until time 'sysdate-7';
RMAN>list copy of archivelog  until sequence 1000;

Archivelog Deletion method

RMAN> delete archivelog all;
RMAN> delete archivelog  until time 'sysdate-7';
RMAN> delete archivelog until sequence 1000;
RMAN>delete archivelog from time 'sysdate-10';
RMAN> delete noprompt archivelog until time 'sysdate-10'; // this will not ask to confirm the   deletion.

Delete Obsolete Back ups

RMAN>delete obsolete;

RMAN>delete noprompt obsolete;//will not ask for conformation