Archive

Archive for May, 2011

Step By Step Installation of oracle identity managent 11g(11.1.1.3.0)–Linux

May 16, 2011 1 comment

In this article I will describe the step by step installaiton oracle identity and Access management 11g:

Environment Details:

$ cat redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)

$ uname -a
Linux idml11.ukatru.com 2.6.18-164.el5 #1 SMP Thu Sep 3 04:15:13 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

Step1)I am using existing oracle 11gR2 database(Database installation is not covered in this article)

$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0.2/db_1
$ export ORACLE_SID=idmdv1
$ cd bin
$ ./sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Mon May 16 10:31:43 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

Step2)RCU – Repository Creation Utility is java based tool (available only for Windows and Linux) to create schema in Database.(ofm_rcu_linux_11.1.1.3.3_disk1_1of1.zip)

Repository Creation Steps:

Download RCU (11.1.1.3.2) : Download RCU from here ensure to download version 11.1.1.3.2 or higher

Step3)Install oracle weblogic  server 10.3.3

Please down load weblogic 10.3.3 generic jar file from here  for linux x86_64 installation.

JDK Version:jdk1.6.0_21

Installation steps:

Step 3:SOA suite is required  for OIM (Oracle Identity Manager) for workflows

SOA 11.1.1.3 is patch-set only where as SOA 11.1.1.2 is base release hence you should first install SOA 11.1.1.2 and then upgrade it to SOA 11.1.1.3:

$ ./runInstaller
Starting Oracle Universal Installer…

Checking if CPU speed is above 300 MHz.    Actual 2526 MHz    Passed
Checking Temp space: must be greater than 150 MB.   Actual 8555 MB    Passed
Checking swap space: must be greater than 500 MB.   Actual 2434 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-05-16_06-37-35AM. Please wait …
Please specify JRE/JDK location ( Ex. /home/jre ), <location>/bin/java should exist :/usr/java/jdk1.6.0_21
$ Log: /u01/app/oraInventory/logs/install2011-05-16_06-37-35AM.log

Oracle SOA 11.1.1.3 Patchset Installation :

step by step installation of Oracle Identity Management:(ofm_iam_generic_11.1.1.3.0_disk1_1of1.zip)

After IDAM installation you should see three ORACLE_HOMEs under Middle ware home:

  • oracle_common – This Oracle_Home contains Java Required Files ()
  • Oracle_SOA1 – This Oracle_Home contains SOA related Files
  • Oracle_IDM1– This Oracle_Home contains IDAM (oam, oim, oaam, oapm & oin) related Files

Now We are going to create WebLogic Domain containing one Admin Server and five managed servers
a) Admin Server listening on port 7001
b) oim_server1 listening on port 14000
c) oam_server1 listening on port 14100
d) oaam_admin_server1 listening on port 14200
e) oaam_server_server1 listening on port 14300
f) soa_server1 listening on port 8001

/u01/app/oracle/product/Middleware/Oracle_IDM1/common/bin/config.sh


Start Admin Server from $DOMAIN_HOME/bin/startWebLogic.sh

<May 16, 2011 7:26:00 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STANDBY>
<May 16, 2011 7:26:00 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
<May 16, 2011 7:26:23 AM PDT> <Warning> <J2EE> <BEA-160195> <The application version lifecycle event listener oracle.security.jps.wls.listeners.JpsAppVersionLifecycleListener is ignored because the application em is not versioned.>
PostInstallConfigIntegration:oracle_ias_farm target auth registration is done.
<May 16, 2011 7:27:14 AM PDT> <Warning> <org.apache.myfaces.trinidadinternal.config.GlobalConfiguratorImpl> <BEA-000000> <Configurator services already initialized.>
ADF Library non-OC4J post-deployment (millis): 35
[EL Info]: 2011-05-16 07:27:38.429–ServerSession(1318997610)–EclipseLink, version: Eclipse Persistence Services – 1.1.0.r3634
[EL Info]: 2011-05-16 07:27:38.781–ServerSession(1318997610)–file:/u01/app/oracle/product/Middleware/Oracle_IDM1/oam/server/lib/oes-d8/jps-internal.jar-JpsDBDataManager login successful
<May 16, 2011 7:28:58 AM PDT> <Notice> <Log Management> <BEA-170027> <The Server has established connection with the Domain level Diagnostic Service successfully.>
<May 16, 2011 7:28:58 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN>
<May 16, 2011 7:28:59 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RESUMING>
<May 16, 2011 7:29:00 AM PDT> <Notice> <Server> <BEA-002613> <Channel “Default[3]” is now listening on 0:0:0:0:0:0:0:1:7001 for protocols iiop, t3, ldap, snmp, http.>
<May 16, 2011 7:29:00 AM PDT> <Notice> <Server> <BEA-002613> <Channel “Default[2]” is now listening on 127.0.0.1:7001 for protocols iiop, t3, ldap, snmp, http.>
<May 16, 2011 7:29:00 AM PDT> <Notice> <Server> <BEA-002613> <Channel “Default[1]” is now listening on fe80:0:0:0:20c:29ff:fea0:1c17:7001 for protocols iiop, t3, ldap, snmp, http.>
<May 16, 2011 7:29:00 AM PDT> <Notice> <Server> <BEA-002613> <Channel “Default” is now listening on 192.168.2.15:7001 for protocols iiop, t3, ldap, snmp, http.>
<May 16, 2011 7:29:00 AM PDT> <Notice> <WebLogicServer> <BEA-000331> <Started WebLogic Admin Server “AdminServer” for domain “oim_domain” running in Development Mode>
<May 16, 2011 7:29:00 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
<May 16, 2011 7:29:00 AM PDT> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
configuring Oracle Identity Manager 11.1.1.3.0 :

$ pwd
/u01/app/oracle/product/Middleware/Oracle_IDM1/bin
$ ./config.sh
Starting Fusion Middleware Configuration Wizard
ORACLE_HOME set as /u01/app/oracle/product/Middleware/Oracle_IDM1
PATH set as /u01/app/oracle/product/Middleware/Oracle_IDM1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin
LD_LIBRARY_PATH set as /u01/app/oracle/product/Middleware/Oracle_IDM1/lib
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 150 MB.   Actual 8555 MB    Passed
Checking swap space: must be greater than 500 MB.   Actual 2404 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-05-16_07-32-54AM. Please wait …$

Access OIM Admin Server using http://servername:OIM_Port/oim (default OIM Managed Server Port is 14000)

OIM Admin User-name is xelsysadm and password you entered during OIM configuration screen above

Advertisements

Step by step guide — Installing Oracle Identity Manager 9.1.0 on Linux

May 16, 2011 Leave a comment

Oracle Identity Manager Installation and Configuration Guide for BEA WebLogic Server
Release 9.1.0

Operating System:
*oiml9001*<oracle:>:/etc=>cat redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 8)
*oiml9001*<oracle:>:/etc=>uname -a
Linux oiml9001.ukatru.com 2.6.9-89.0.0.0.1.EL #1 Tue May 19 05:21:57 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

Database :
SQL*Plus: Release 10.2.0.1.0 – Production on Sun May 15 16:39:40 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

Step1:Install oracle database software version 10.2.0.1 and create database.
Step2:Install web logic server and create a domain.
Software : server103_generic.jar(weblogic 10.3.0)
Jdk Version : jdk1.6.0_05

Configuration:

/u01/app/oracle/product/bea/wlserver_10.3/common/bin/config.sh

Step3 : Prepare database to install OIM

Prepare oracle database :
/u01/OIM9101/installServer/Xellerate/db/oracle/prepare_xl_db.sh
## Enter the ORACLE HOME directory or Press [Enter] to
accept the default /u01/app/oracle/product/10.2.0.1/db_1 as ORACLE_HOME.

## Current database <ORACLE_SID> is oimdv1
Do you want to continue with this database [y,Y,n,N] ?

y

## Enter the Oracle Identity Manager user name

oimadmin

## Enter the password for Oracle Identity Manager (oimadmin) user

## Enter the tablespace to hold the Oracle Identity Manager user data

OIMTS01

## Enter the directory to store the datafile for the Oracle Identity Manager tablespace

/u01/oradata/oimdv1

## Enter the name of the datafile without the extension .dbf
(For e.g. xeltspace_01)

xeltspace_01

## Enter the Temporary tablespace for Oracle Identity Manager User

TEMP

Validating the given inputs…
Validating the given inputs is done.

Preparing the database for Oracle Identity Manager. Please wait…

Errors/warnings occurred during the database preparation. Please check the log
file prepare_xell_db.lst for more info.

Step4:Install OIM

Required jdk version: Java Version: 1.4.2_19

*oiml9001*<oracle:>:/u01/OIM9101/installServer=>./install_server.sh
Checking whether JAVA_HOME is set

Java Version: 1.4.2_19
JAVA_HOME is set.
Checking if the version is correct
JAVA Version is OK
/u01/j2re1.4.2_19

——————————————————————————-
Select a language to be used for this wizard.

[ ] 1  – Bulgarian
[ ] 2  – Croatian
[ ] 3  – Czech
[ ] 4  – Danish
[ ] 5  – Dutch
[X] 6  – English
[ ] 7  – Finnish
[ ] 8  – French
[ ] 9  – German
[ ] 10 – Greek
[ ] 11 – Hungarian
[ ] 12 – Italian
[ ] 13 – Japanese
[ ] 14 – Korean
[ ] 15 – Norwegian
[ ] 16 – Polish
[ ] 17 – Portuguese
[ ] 18 – Portuguese (Brazil)
[ ] 19 – Romanian
[ ] 20 – Russian
[ ] 21 – Simplified Chinese
[ ] 22 – Slovak
[ ] 23 – Slovenian
[ ] 24 – Spanish
[ ] 25 – Swedish
[ ] 26 – Traditional Chinese
[ ] 27 – Turkish

To select an item enter its number, or 0 when you are finished: [0]

——————————————————————————-
Oracle Identity Manager Server Installer: Welcome Message

Welcome to Oracle Identity Manager 9.1.0.1

Oracle Identity Manager9.1.0.1 is the most advanced, secure enterprise
provisioning system available for automatically granting and revoking user
access to enterprise applications and managed systems.

Before you install Oracle Identity Manager, you must complete the
preinstallation steps. Review the Oracle Identity Manager Installation Guide ,
and ensure that you have completed these steps. After you install the software,
there are postinstallation steps that you must complete before you can use
Oracle Identity Manager.

Press 1 for Next, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer: Admin User Information

Enter the password for System Administrator (xelsysadm).

User Password:
Confirm User password:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer: Oracle Identity Manager Application
Options

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

Select the Oracle Identity Manager application that you want to install:

[X] 1 – Oracle Identity Manager
[ ] 2 – Oracle Identity Manager with Audit and Compliance Module

To select an item enter its number, or 0 when you are finished: [0]

——————————————————————————-
Oracle Identity Manager Server Installer: Target directory

Oracle Identity Manager Install Location

Please specify a directory or press Enter to accept the default directory.

Destination Directory: [/opt/oracle] /u01/app/oracle/product/

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer: Database Server Selection

Select the database to be used for the Oracle Identity Manager repository:

[X] 1 – Oracle Database
[ ] 2 – Microsoft SQL Server

To select an item enter its number, or 0 when you are finished: [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer: Database Information

Provide database connectivity information:

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer: Authentication Information

Oracle Identity Manager 9.1.0.1  Server – Select Authentication

Select the Authentication mode for the Oracle Identity Manager Web Application.
If the SSO mode is selected, then enter the header value in the space provided.

[X] 1 – Oracle Identity Manager Default Authentication
[ ] 2 – SSO Authentication

To select an item enter its number, or 0 when you are finished: [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer: Application Server

Select the application server to be used to deploy Oracle Identity Manager:

[X] 1 – Oracle Weblogic
[ ] 2 – Oracle Application Server
[ ] 3 – JBoss Application Server
[ ] 4 – IBM WebSphere

To select an item enter its number, or 0 when you are finished: [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer: Cluster Information

Enter information about application server clustering.

The Application Server is clustered:

[ ] 1 – Yes
[X] 2 – No

To select an item enter its number, or 0 when you are finished: [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer : Oracle Weblogic Directory
Information

Provide the following information for the Oracle Weblogic Application
Server:
Enter the path of the directory.

Provide the location where the application server is installed:

Oracle Identity Manager Server Installer: Oracle Weblogic Application Server
Information

Enter the following information for Oracle Weblogic:

Host Name or IP Address: [localhost] oiml9001.ukatru.com

Admin Port: [7001]

WebLogic Server Name: [AdminServer]

WebLogic Server Port: [7001]

Login Name: [weblogic]

Password (Enter the password; DO NOT paste it):

Confirm Password (Enter the password; DO NOT paste it):

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer: Oracle Weblogic Domain Information

Enter the following information about Oracle Weblogic:

Enter the location of the Oracle Weblogic domain:
[/u01/app/oracle/product/bea/user_projects/domains]

Domain: [base_domain] oim_domain

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1] 1

——————————————————————————-
Oracle Identity Manager Server Installer: Application Server Configuration
Backup

Oracle Identity Manager Installer will install Oracle Identity Manager with the
configurations for your application server. If you have not backed up your
application server installation, then do so now. When you are ready, click NEXT
to proceed.

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]

——————————————————————————-
Oracle Identity Manager Server Installer: Summary

Oracle Identity Manager will be installed in the following location:

/u01/app/oracle/product

with the following features:

Oracle Identity Manager Server

for a total size:

140.9 MB

Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]
——————————————————————————-
Oracle Identity Manager Server Installer: Installing

Installing Oracle Identity Manager. Please wait…

|———–|———–|———–|————|
0%         25%         50%         75%        100%
||||||||||||||||||||||||||||||||||||||||||||||||||

Creating uninstaller…

Finalizing Vital Product Data Registry…

userLanguage = en
userCountry  = US
The Oracle Identity Manager installation log file is located at /u01/app/oracle/product/oim/xellerate/logs.

Post installation summary:
1. Refer to the documentation for Diagnostic Dashboard deployment.

——————————————————————————-
Oracle Identity Manager Server Installer: Completed

The Oracle Identity Manager Installer has successfully installed Oracle
Identity Manager. Choose Finish to exit the wizard.

Press 3 to Finish or 5 to Redisplay [3] 3

http://oiml9001.ukatru.com:7001/xlWebApp

StartOracle Identity Manager on UNIX:

Step1)Check database and listner is up and running
Step2)To start an Administrative Server on UNIX, run the OIM_HOME/xellerate/bin/xlStartServer.sh
In my case OIM_HOME=/u01/app/oracle/product/oim

Accessing the Administrative and User Console

http://<hostname>:7001/xlWebApp

Issues Faced during OIM installation:

Error:
[wlappc] java.lang.OutOfMemoryError: PermGen space

Please check metalink [ID 784359.1] for resolution:

OIM 9.1.0.1 Installation on Weblogic 10.3 Fails due to Memory Issues [ID 784359.1]

Pre-OIM Install
If this is a new install where OIM does not exist then you can define the USER_MEM_ARGS environment variable in the console before restarting the app server after defining the domain.

Example
export USER_MEM_ARGS=””-Xms512m -Xmx1024m -XnoOpt”
cd $DOMAIN_HOME
./startWebLogic.sh

Then you should be able to do an install with the app server having more memory available to it.
Before running the installer script (or setup_weblogic script), set the environment variables for USER_JAVA_OPTIONS:

export _JAVA_OPTIONS=-XX:MaxPermSize=512m

Step By Step Guide On Creating Physical Standby Using RMAN(Non ASM)

May 12, 2011 Leave a comment

This article is intend to explain Step by step guide on how to create a physical standby database using RMAN:

Step By Step Guide To Create Physical Standby Database.

Primary Database:oradv1
Physical Stand by Database:psoradv1

Primary Database Server : dbsl9001
Secondary Database Server dbsl9002

Step1:Add following tnsnames on both servers:

ORADV1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbsl9001.ukatru.com )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oradv1.ukatru.com)
)
)

PSORADV1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbsl9002.ukatru.com )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = psoradv1.ukatru.com)
)
)

Step2 : Backup the database that includes backup of datafiles, archivelogs and controlfile for standby

create following dir on both servers.

mkdir -p /u01/app/oracle/backup

run
{
allocate channel c1 type disk;
backup database plus archivelog format ‘/u01/app/oracle/backup/%d_%s_%t’;
}

Back up the current control file for stanby

run
{
allocate channel c1 type disk;
backup current controlfile for standby format ‘/u01/app/oracle/backup/%d_controlfile’;
}

Step3 : move the backups to stand by server.

Step 4: Make changes in the parameter files of both primary and standby database

Primary :
alter system set log_archive_dest_2=’SERVICE=psoradv1′ scope=both;

SQL> alter system set log_archive_dest_2=’SERVICE=psoradv1′ scope=both;

System altered.

SQL> create pfile=’/tmp/initoradv1.ora’ from spfile;

File created.

Stand by Server:
Copy the password file from primary.
*dbsl9001*<oracle:oradv1>:/u01/app/oracle/product/10.2.0.5/db_1/dbs=>scp orapworadv1 dbsl9002:/u01/app/oracle/product/10.2.0.5/db_1/dbs/orapwdpsoradv1
orapworadv1                                                                                                                100% 1536     1.5KB/s   00:00

create admin directoris on stand by server:
mkdir -p /u01/app/oracle/admin/psoradv1/adump
mkdir -p /u01/app/oracle/admin/psoradv1/bdump
mkdir -p /u01/app/oracle/admin/psoradv1/cdump
mkdir -p /u01/app/oracle/admin/psoradv1/udump
mkdir -p /u01/app/oracle/admin/psoradv1/pfile
mkdir -p /u01/app/oracle/admin/psoradv1/scripts

Copy the primary database parameter file and make necessary changes :
*.audit_file_dest=’/u01/app/oracle/admin/psoradv1/adump’
*.background_dump_dest=’/u01/app/oracle/admin/psoradv1/bdump’
*.control_files=’/oradata/psoradv1/control01.ctl’,’/oradata/psoradv1/control02.ctl’,’/oradata/psoradv1/control03.ctl’
*.core_dump_dest=’/u01/app/oracle/admin/psoradv1/cdump’
db_file_name_convert=’/oradata/oradv1/’,’/oradata/psoradv1/’
*.db_name=’oradv1′
db_unique_name=’psoradv1′
instance_name=’psoradv1′

*dbsl9002*<oracle:psoradv1>:/u01/app/oracle/product/10.2.0.5/db_1/bin=>./rman target /

Recovery Manager: Release 10.2.0.5.0 – Production on Thu May 12 14:15:56 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount;

Oracle instance started

Total System Global Area     331350016 bytes

Fixed Size                     2096056 bytes
Variable Size                100664392 bytes
Database Buffers             222298112 bytes
Redo Buffers                   6291456 bytes

RMAN> set dbid=1470870068;

executing command: SET DBID

RMAN> restore standby controlfile from ‘/u01/app/oracle/backup/ORADV1_controlfile’;

Starting restore at 12-MAY-11
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output filename=/oradata/psoradv1/control01.ctl
output filename=/oradata/psoradv1/control02.ctl
output filename=/oradata/psoradv1/control03.ctl
Finished restore at 12-MAY-11

RMAN>  sql ‘alter database mount standby database’;

sql statement: alter database mount standby database
released channel: ORA_DISK_1

configure channel 1 device type disk format ‘/u01/app/oracle/backup/%d_%s_%t’;

RMAN> restore database;

Starting restore at 12-MAY-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata/psoradv1/system01.dbf
restoring datafile 00002 to /oradata/psoradv1/undotbs01.dbf
restoring datafile 00003 to /oradata/psoradv1/sysaux01.dbf
restoring datafile 00004 to /oradata/psoradv1/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/10.2.0.5/db_1/dbs/0jmc58dt_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/product/10.2.0.5/db_1/dbs/0jmc58dt_1_1 tag=TAG20110512T140133
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 12-MAY-11

RMAN> list backup of archivelog all;

RMAN> list backup of archivelog all;

List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— —————
5       25.70M     DISK        00:00:01     09-MAY-11
BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20110509T222259
Piece Name: /tmp/oradv1_backup_750723779_7p1

List of Archived Logs in backup set 5
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
—- ——- ———- ——— ———- ———
1    19      237630     09-MAY-11 246085     09-MAY-11
1    20      246085     09-MAY-11 246103     09-MAY-11
1    21      246103     09-MAY-11 246186     09-MAY-11

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— —————
8       2.00K      DISK        00:00:01     09-MAY-11
BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20110509T222339
Piece Name: /tmp/oradv1_backup_750723819_10p1

List of Archived Logs in backup set 8
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
—- ——- ———- ——— ———- ———
1    22      246186     09-MAY-11 246205     09-MAY-11

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— —————
10      41.97M     DISK        00:00:03     10-MAY-11
BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20110510T121303
Piece Name: /u01/app/oracle/product/10.2.0.5/db_1/dbs/0cmbvpaf_1_1

List of Archived Logs in backup set 10
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
—- ——- ———- ——— ———- ———
1    19      237630     09-MAY-11 246085     09-MAY-11
1    20      246085     09-MAY-11 246103     09-MAY-11
1    21      246103     09-MAY-11 246186     09-MAY-11
1    22      246186     09-MAY-11 246205     09-MAY-11
1    23      246205     09-MAY-11 266589     10-MAY-11

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— —————
13      3.00K      DISK        00:00:01     10-MAY-11
BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20110510T121335
Piece Name: /u01/app/oracle/product/10.2.0.5/db_1/dbs/0fmbvpbg_1_1

List of Archived Logs in backup set 13
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
—- ——- ———- ——— ———- ———
1    24      266589     10-MAY-11 266607     10-MAY-11

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— —————
15      82.96M     DISK        00:00:03     12-MAY-11
BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20110512T140129
Piece Name: /u01/app/oracle/backup/ORADV1_18_750952889

List of Archived Logs in backup set 15
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
—- ——- ———- ——— ———- ———
1    19      237630     09-MAY-11 246085     09-MAY-11
1    20      246085     09-MAY-11 246103     09-MAY-11
1    21      246103     09-MAY-11 246186     09-MAY-11
1    22      246186     09-MAY-11 246205     09-MAY-11
1    23      246205     09-MAY-11 266589     10-MAY-11
1    24      266589     10-MAY-11 266607     10-MAY-11
1    25      266607     10-MAY-11 272503     10-MAY-11
1    26      272503     10-MAY-11 316060     12-MAY-11

BS Key  Size       Device Type Elapsed Time Completion Time
——- ———- ———– ———— —————
18      2.00K      DISK        00:00:01     12-MAY-11
BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20110512T140200
Piece Name: /u01/app/oracle/backup/ORADV1_21_750952920

List of Archived Logs in backup set 18
Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
—- ——- ———- ——— ———- ———
1    27      316060     12-MAY-11 316077     12-MAY-11

RMAN>  recover database until sequence 28;

Starting recover at 12-MAY-11
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=27
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/backup/ORADV1_21_750952920
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/backup/ORADV1_21_750952920 tag=TAG20110512T140200
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archive log filename=/oradata/psoradv1_1_27_750720628.dbf thread=1 sequence=27
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: ‘/oradata/psoradv1/system01.dbf’

media recovery complete, elapsed time: 00:00:04
Finished recover at 12-MAY-11

Note : No need to worry about the below errors
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: ‘/u01/oracle/product/ora10g/oradata/standby/data/sys01.dbf’

create standby redo log files from both prim and standby databases:

put the standby database in recover managed mode

*dbsl9002*<oracle:psoradv1>:/u01/app/oracle/product/10.2.0.5/db_1/bin=>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Thu May 12 15:05:47 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ‘/oradata/psoradv1/redo04.log’ SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ‘/oradata/psoradv1/redo05.log’ SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ‘/oradata/psoradv1/redo06.log’ SIZE 50M;

ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 ‘/oradata/oradv1/redo04.log’ SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 ‘/oradata/oradv1/redo05.log’ SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ‘/oradata/oradv1/redo06.log’ SIZE 50M;

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Database altered.

Categories: Dataguard

clone oracle database home software 10.2.0.5 to another machine

Cloning is the process of copying an existing Oracle installation to a different location and updating the copied bits to work in the new environment.

OS :

<oracle:>:/etc=>cat redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)

<oracle:>:/etc=>uname -r
2.6.18-164.el5

Database software : 10.2.0.5

<oracle:>:/u01/app/oracle/product/10.2.0.5/db_1/bin=>./sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 – Production on Sun May 8 13:34:59 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

HostName :oral8001

create a tar file using following command:

<oracle:>:/home/oracle=>cd /u01/app/oracle/product/10.2.0.5/db_1/

<oracle:>:/u01/app/oracle/product/10.2.0.5/db_1=>tar -zcvf /tmp/dbhome10205.tgz .

Destination Hostnmae : oral8002

copy zip file from oral8001 to oral8002

:/tmp=>scp dbhome10205.tgz oral8002:/u01/app/oracle/product/10.2.0.5/db_1
root@oral8002’s password:

dbhome10205.tgz                                                                                                            100%  874MB  35.0MB/s   00:25

Log into oral8002 machine as oracle and .

cd /u01/app/oracle/product/10.2.0.5/db_1

tar –zxvf ./dbhome10205.tgz

###############################################################

<oracle:>:/home/oracle/admin/scripts/general/bin=>cat clone_db
#!/bin/sh
E01=ORACLE_HOME=/u01/app/oracle/product/10.2.0.5/db_1
E02=ORACLE_HOME_NAME=OraDb10g_home1

C01=”-O’CLUSTER_NODES={oral8002}'”
C02=”-O’INVENTORY_LOCATION=/u01/app/oraInventory'”

perl /u01/app/oracle/product/10.2.0.5/db_1/clone/bin/clone.pl  $E01 $E02 $C01 $C02

##############################################################

<oracle:>:/home/oracle/admin/scripts/general/bin=>./clone_db
./runInstaller -silent -clone -waitForCompletion  “ORACLE_HOME=/u01/app/oracle/product/10.2.0.5/db_1” “ORACLE_HOME_NAME=OraDb10g_home1” ‘CLUSTER_NODES={oral8002}’ ‘INVENTORY_LOCATION=/u01/app/oraInventory’ -noConfig -nowait
Starting Oracle Universal Installer…

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-05-08_02-01-00PM. Please wait …Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.

You can find a log of this install session at:
/u01/app/oraInventory/logs/cloneActions2011-05-08_02-01-00PM.log
.
Performing tests to see whether nodes  are available
……………………………………………………… 100% Done.

Installation in progress (Sunday, May 8, 2011 2:01:17 PM PDT)
…………………………………………………………………                                                     75% Done.
Install successful

Linking in progress (Sunday, May 8, 2011 2:01:27 PM PDT)
Link successful

Setup in progress (Sunday, May 8, 2011 2:02:26 PM PDT)
Setup successful

End of install phases.(Sunday, May 8, 2011 2:02:30 PM PDT)

OUI-10234:Failed to copy the root script, /u01/app/oraInventory/orainstRoot.sh to the cluster nodes oral8002.
Please copy them manually to these nodes and execute the script.
WARNING:A new inventory has been created on one or more nodes in this session. However, it has not yet been registered as the central inventory of this system.
To register the new inventory please run the script at ‘/u01/app/oraInventory/orainstRoot.sh’ with root privileges on nodes ‘oral8002’.
If you do not register the inventory, you may not be able to update or patch the products you installed.
The following configuration scripts need to be executed as the “root” user in each cluster node.
#!/bin/sh
#Root script to run
/u01/app/oraInventory/orainstRoot.sh #On nodes oral8002
/u01/app/oracle/product/10.2.0.5/db_1/root.sh #On nodes oral8002
To execute the configuration scripts:
1. Open a terminal window
2. Log in as “root”
3. Run the scripts in each cluster node

The cloning of OraDb10g_home1 was successful.
Please check ‘/u01/app/oraInventory/logs/cloneActions2011-05-08_02-01-00PM.log’ for more details.

[root@oral8002 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory to 770.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete
[root@oral8002 ~]# /u01/app/oracle/product/10.2.0.5/db_1/root.sh
Running Oracle 10g root.sh script…

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME=  /u01/app/oracle/product/10.2.0.5/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …

Creating /etc/oratab file…
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.

Categories: oracle-install

Oracle Enterprise Manager 11g Grid Control Release 1 (11.1.0.1.0) Installation on RedHat Linux x86-64

Grid Control 11.1.0.1.0 Installation:

Operating  System:Red Hat Enterprise Linux Server release 5.4 (Tikanga)

emgcl001<oracle:>:/etc=>uname -a
Linux emgcl001.ukatru.com 2.6.18-164.el5 #1 SMP Thu Sep 3 04:15:13 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

Please download software from the following link.

Oracle Enterprise Manager 11g Grid Control Release 1 (11.1.0.1.0)

Prerequisite:
Grid Control 11g uses WebLogic Server instead of the OC4J traditional with version 10.1 and 10.2. Grid Control will deploy on an existing WLS function in the grid Control Installation.

Obtain the wls1032_generic.jar for installation of WLS on 64bit platforms.
WLS will be installed from this source in execution of a java command (example):
/usr/java/jdk1.6.0_21/bin/java -d64 -jar wls1032_generic.jar

$ /usr/java/jdk1.6.0_21/bin/java -d64 -jar wls1032_generic.jar
Extracting 0%……………………………………………………………………………………….100%
May 5, 2011 9:12:49 PM java.util.prefs.FileSystemPreferences$2 run
INFO: Created user preferences directory.

Click on Next to start the WLS installation

Specify the Middleware Home dir and click on Next.

If this option is declined, the user is asked about the certainty of this decision in an Are You Sure? pop-up window, to which the “Yes” answer can be given.
In either case, once the desired option is given, select Next to proceed.

For Grid Control , choose Typical and then Next.

Select Next once the jdk 1.6 location is verified.

The default can be accepted by selecting Next.

Select Next to accept the choices and begin WLS installation.


Uncheck the Run Quickstart option and select Done.

I am using existing database for em repository database and make sure the following prerequisites were met.

dbsl8001<oracle:oradv11>:/home/oracle=>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri May 6 12:18:13 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

Typical initialization parameter
Parameter Value
job_queue_processes 10
db_block_size 8192
timed_statistics TRUE
open_cursors 300
session_cached_cursors  300
aq_tm_processes 1
compatible <currently installed Oracle Database release> (default)
undo_management AUTO
undo_retention 10800
undo_tablespace <any acceptable name>
processes 500
log_buffer 1048576
statistics_level TYPICAL

/u01=>./runInstaller
Starting Oracle Universal Installer…

Checking Temp space: must be greater than 150 MB.   Actual 8235 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 2687 MB    Passed

select Next to proceed

The installation type should be selected from the Select Installation Type screen.
Note that in this version, options for Additional Management Agent and Grid Control with a New Database are not offered.
Agent installation through a GUI-based OUI is not offered in version 11.1.0.1.0.
The 11.1.0.1.0 Grid Control installer is not equipped for installation of a database as an option.
Select Next after the Installation type is selected.

On the Secure Oracle Management Service screen, enter the following:
– Agent registration password (remember for future use)
– Access type for agent to OMS (http/https or https only)
– Access type to console URL (http/https or https only)
Select Next when all determinations are complete.

Use the URL provided in the Finish window to access the Grid Control web application, which should be active as the configuration assistants complete. Use the sysman account for login.


%d bloggers like this: