Friday, March 21, 2014

RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row due to ORA-04031 shared memory issue

Rman backup failed while checking to connect the Rman client thrown with the error of ORA-04031 Shared memory issue .

 rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Mar 21 03:28:58 2014

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

connected to target database: TEST (DBID=92535020)
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
ORACLE error from target database:
ORA-04031: unable to allocate 36424 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","krbmror")

Cause :

ORA - 04031 RMAN not able to connect to database due to shared memory issue 

Solution:

1.Add more space to shared memory to take effect with Rman .

Check the shared memory allocated for database and assign more if needed else try to flush shared memory and connect again via RMAN it will allow to take connection.

SQL > show parameter shared;
shared_pool_reserved_size            big integer 10M
shared_pool_size                     big integer 200M

SQL > alter system set shared_pool_size=400M scope=spfile;

Bounce database to take effect .

Add more space to shared_pool_size for permanent solution 

2. Else flush shared_pool and check connecting Rman again 

SQL> alter system flush shared_pool;

System altered.

==============================================================
rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Mar 21 03:44:29 2014

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

connected to target database: TEST (DBID=92535020)

RMAN> exit


Posted by at No comments:

Thursday, March 20, 2014

Quick Reference to RDBMS Database Patchset And PSU Patch Numbers (Doc ID 753736.1)

From 8i to 11.2.0.4 Complete list of  Patchset version includes PSU releases refererence Oracle Metalink note (Doc ID 753736.1) 

Patchset/PSUPatch Number Description
11.2.0.4.013390677 11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER
   
11.2.0.3.816902043 DATABASE PATCH SET UPDATE 11.2.0.3.8 (INCLUDES CPUOCT2013)
11.2.0.3.716619892 DATABASE PATCH SET UPDATE 11.2.0.3.7 (INCLUDES CPUJUL2013)
11.2.0.3.616056266 DATABASE PATCH SET UPDATE 11.2.0.3.6 (INCLUDES CPUAPR2013) 
11.2.0.3.514727310 DATABASE PATCH SET UPDATE 11.2.0.3.5 (INCLUDES CPUJAN2013):
11.2.0.3.414275605 DATABASE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES CPUOCT2012)
11.2.0.3.313923374 DATABASE PATCH SET UPDATE 11.2.0.3.3 (INCLUDES CPU JUL2012):
11.2.0.3.213696216 DATABASE PATCH SET UPDATE 11.2.0.3.2 (INCLUDES CPU APR2012)
11.2.0.3.113343438 DATABASE PATCH SET UPDATE 11.2.0.3.1 (INCLUDES CPU JAN2012)
11.2.0.310404530 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
    
11.2.0.2.1116619893 DATABASE PATCH SET UPDATE 11.2.0.2.11 (INCLUDES CPUJUL2013)
11.2.0.2.1016056267 DATABASE PATCH SET UPDATE 11.2.0.2.10 (INCLUDES CPUAPR2013) 
11.2.0.2.914727315 DATABASE PATCH SET UPDATE 11.2.0.2.9 (INCLUDES CPUJAN2013):
11.2.0.2.814275621 DATABASE PATCH SET UPDATE 11.2.0.2.8 (INCLUDES CPUOCT2012)
11.2.0.2.713923804 DATABASE PATCH SET UPDATE 11.2.0.2.7 (INCLUDES CPU JUL2012)
11.2.0.2.613696224 DATABASE PATCH SET UPDATE 11.2.0.2.6 (INCLUDES CPU APR2012)
11.2.0.2.513343424 DATABASE PATCH SET UPDATE 11.2.0.2.5 (INCLUDES CPU JAN2012)
11.2.0.2.412827726 DATABASE PSU 11.2.0.2.4 (INCLUDES CPUOCT2011)
11.2.0.2.312419331 DATABASE PSU 11.2.0.2.3 (INCLUDES CPUJUL2011)
11.2.0.2.211724916 DATABASE PSU 11.2.0.2.2 (INCLUDES CPUAPR2011)
11.2.0.2.110248523 DATABASE PSU 11.2.0.2.1
11.2.0.210098816 11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER
    
11.2.0.1.612419378  DATABASE PSU 11.2.0.1.6 (INCLUDES CPUJUL2011)
11.2.0.1.511724930 DATABASE PSU 11.2.0.1.5 (INCLUDES CPUAPR2011)
11.2.0.1.410248516 DATABASE PSU 11.2.0.1.4 (INCLUDES CPUJAN2011)
11.2.0.1.39952216 DATABASE PSU 11.2.0.1.3 (INCLUDES CPUOCT2010)
11.2.0.1.29654983 DATABASE PSU 11.2.0.1.2 (INCLUDES CPUJUL2010)
11.2.0.1.19352237 DATABASE PSU 11.2.0.1.1
    
11.1.0.7.1717082366 [*]  
11.1.0.7.1616619896 [*] DATABASE PATCH SET UPDATE 11.1.0.7.16 (INCLUDES CPUJUL2013)
11.1.0.7.1516056268  [*] DATABASE PATCH SET UPDATE 11.1.0.7.15 (INCLUDES CPUAPR2013) 
11.1.0.7.1414739378 [*] DATABASE PATCH SET UPDATE 11.1.0.7.14 (INCLUDES CPUJAN2013)
11.1.0.7.1314275623 [*] DATABASE PATCH SET UPDATE 11.1.0.7.13 (INCLUDES CPUOCT2012)
11.1.0.7.1213923474 DATABASE PATCH SET UPDATE 11.1.0.7.12 (INCLUDES CPU JUL2012)
11.1.0.7.1113621679 DATABASE PATCH SET UPDATE 11.1.0.7.11 (INCLUDES CPU APR2012)
11.1.0.7.1013343461 DATABASE PATCH SET UPDATE 11.1.0.7.10 (INCLUDES CPU JAN2012)
11.1.0.7.912827740 DATABASE PSU 11.1.0.7.9 (INCLUDES CPUOCT2011)
11.1.0.7.812419384 DATABASE PSU 11.1.0.7.8 (INCLUDES CPUJUL2011)
11.1.0.7.711724936 DATABASE PSU 11.1.0.7.7 (INCLUDES CPUAPR2011)
11.1.0.7.610248531 DATABASE PSU 11.1.0.7.6 (INCLUDES CPUJAN2011)
11.1.0.7.59952228 DATABASE PSU 11.1.0.7.5 (INCLUDES CPUOCT2010)
11.1.0.7.49654987 DATABASE PSU 11.1.0.7.4 (INCLUDES CPUJUL2010)
11.1.0.7.39352179 DATABASE PSU 11.1.0.7.3 (INCLUDES CPUAPR2010)
11.1.0.7.29209238 DATABASE PSU 11.1.0.7.2 (INCLUDES CPUJAN2010)
11.1.0.7.18833297 DATABASE PSU 11.1.0.7.1 (INCLUDES CPUOCT2009)
11.1.0.76890831 11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER
    
10.2.0.5.1216619894 [*] DATABASE PATCH SET UPDATE 10.2.0.5.12 (INCLUDES CPUJUL2013):
10.2.0.5.1116056270  [*] DATABASE PATCH SET UPDATE 10.2.0.5.11 (INCLUDES CPUAPR2013)
10.2.0.5.1014727319 [*] DATABASE PATCH SET UPDATE 10.2.0.5.10 (INCLUDES CPUJAN2013):
10.2.0.5.914275629 [*] DATABASE PATCH SET UPDATE 10.2.0.5.9 (INCLUDES CPUOCT2012)
10.2.0.5.813923855 [*] DATABASE PATCH SET UPDATE 10.2.0.5.8 (INCLUDES CPU JUL2012)
10.2.0.5.713632743 [*] DATABASE PATCH SET UPDATE 10.2.0.5.7 (INCLUDES CPU APR2012)
10.2.0.5.613343471 [*] DATABASE PATCH SET UPDATE 10.2.0.5.6 (INCLUDES CPU JAN2012)
10.2.0.5.512827745 [*] DATABASE PSU 10.2.0.5.5 (INCLUDES CPUOCT2011)
10.2.0.5.412419392 DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)
10.2.0.5.311724962 DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
10.2.0.5.210248542 DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
10.2.0.5.19952230 DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
10.2.0.58202632 10.2.0.5.0 PATCH SET FOR ORACLE DATABASE SERVER
    
10.2.0.4.1716619897 [*] DATABASE PSU 10.2.0.4.17 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJUL2013):
10.2.0.4.1616056269 [*] DATABASE PSU 10.2.0.4.16 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUAPR2013)
10.2.0.4.1514736542 [*] DATABASE PSU 10.2.0.4.15 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJAN2013):
10.2.0.4.1414275630 [**] DATABASE PSU 10.2.0.4.14 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUOCT2012)
0.2.0.4.1313923851 [*] DATABASE PSU 10.2.0.4.13 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJUL2012)
10.2.0.4.1212879933 [*] 
DATABASE PSU 10.2.0.4.12 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUAPR2012)
10.2.0.4.1112879929 [*] DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4 | INCLUDES CPUJAN2012)
10.2.0.4.1012827778 DATABASE PSU 10.2.0.4.10 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUOCT2011)
10.2.0.4.912419397 DATABASE PSU 10.2.0.4.9 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJUL2011)
10.2.0.4.811724977 DATABASE PSU 10.2.0.4.8 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUAPR2011)
10.2.0.4.710248636 DATABASE PSU 10.2.0.4.7 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJAN2011)
10.2.0.4.69952234 DATABASE PSU 10.2.0.4.6 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUOCT2010) 
10.2.0.4.59654991 DATABASE PSU 10.2.0.4.5 (REQUIRES PRE-REQUISITE 10.2.0.4.4 | INCLUDES CPUJUL2010)    [overlay PSU]
10.2.0.4.49352164 DATABASE PSU 10.2.0.4.4 (INCLUDES CPUAPR2010)
10.2.0.4.39119284 DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)
10.2.0.4.28833280 DATABASE PSU 10.2.0.4.2 (INCLUDES CPUOCT2009)
10.2.0.4.18576156 DATABASE PSU 10.2.0.4.1 (INCLUDES CPUJUL2009)
10.2.0.46810189 10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.35337014 10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER
10.2.0.24547817 10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER
    
10.1.0.54505133 10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER
10.1.0.44163362 10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER
10.1.0.33761843 10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER
    
9.2.0.84547809 9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.74163445 9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.63948480 9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.53501955 ORACLE 9I DATABASE SERVER RELEASE 2 - PATCH SET 4 VERSION 9.2.0.5.0
9.2.0.43095277 9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.32761332 9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER
9.2.0.22632931 9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER
    
9.0.1.53301544 9.0.1.5 PATCHSET
9.0.1.42517300 9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER
9.0.1.32271678 9.0.1.3. PATCH SET FOR ORACLE DATA SERVER
    
8.1.7.42376472 8.1.7.4 PATCH SET FOR ORACLE DATA SERVER
8.1.7.32189751 8.1.7.3 PATCH SET FOR ORACLE DATA SERVER
8.1.7.21909158 8.1.7.2.1 PATCH SET FOR ORACLE DATA SERVER
Posted by at No comments:

Wednesday, March 19, 2014

Oracle 11GR2 (11.2.0.4) Database Software Installation


                                      11.2.0.4 Installation Steps 

 Step 1:Installation of Oracle Sotware 11.2.0.4 Home

Steps to Invoke Xconsole of the server to start Installation:

Example:

 Login cygwin àxhost +192.168.1.1
  ssh oracle@192.168.1.1
  Invoke the runInstaller to get the Xwindow

Invoke runInstaller from 11.2.0.4 software as Oracle user :
192.168.1.1 (oracle in )/dbdata/11.2.0.4_software> cd database
192.168.1.1 (oracle in )/dbdata/11.2.0.4_software/database> ls
install       readme.html   response      rootpre       rootpre.sh    rpm           runInstaller  sshsetup      stage         welcome.html

192.168.1.1 (oracle in )/dbdata/11.2.0.4_software/database> ./runInstaller










Run rootpre.sh as root user before starting the installation :

192.168.1.1:/# sh /dbdata/11.2.0.4_software/database/rootpre.sh
/dbdata/11.2.0.4_software/database/rootpre.sh output will be logged in /tmp/rootpre.out_14-03-18.09:56:58
Checking if group services should be configured....
Nothing to configure.


Skip the security update by unchecking it
















Pass ‘Yes’ to skip the security update and proceed with installation




















  
Select Install database software only to install the 11.2.0.4 software


Select Single Instance database Installation for Standalone Installation

 


Select English as a base language for the installation



Select Enterprise Edition version for the software installation



Provide Oracle Base as ‘/orasw/oracle’ and pass the software location to install the Oracle Home



Select Operating System Group as “DBA” for Oracle user




Crosscheck to ensure all the pre-requisites satisfied before installing :
If any pre-requisites failed confirm with Unix admin if it’s installed then check the box
“Ignore All” checkbox at right top corner and proceed with installation

 



Once Installation completed, ensure to run root.sh script with the help of Unix admin then click ok to complete the software installation


192.168.1.1:# (oracle in )/orasw/oracle/product/11.2.0.4> sh root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /orasw/oracle/product/11.2.0.4

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]:
The contents of "coraenv" have not changed. No need to overwrite.

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 script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

Click Close to finish the 11.2.0.4 Installation 

Posted by at No comments:

Sunday, March 16, 2014

Oracle 11GR2(11.2.0.2) Database Software Installation and Database Creation


11G Release 2 Installation Steps

Step 1:Installation of Oracle Sotware 11.2.0.2 Home 









 

Installing Software only -11.2.0.2 Oracle Home Installation:




















Specifying Single Instance database installation (If it’s a single node installation)



















Selecting Default English Language:



















Selecting Enterprise Edition  for Production :



















Specifying the Oracle Base and Software Location to be installed:




















Specifying the OS group for Oracle Home:
  



















Pre-requisite Check should be checked carefully and proceed without fail at OS level Parameter:

(If any OS Patch or Kernel Parameter fails need to fix before proceeding )






































Once Installation of Software Completed , need to run root.sh script as a root user:

Make sure to take backup of existing Oraenv File or should not replace the existing files while running this script as root user
 


Software Installation Completed:





















Database Creation 11G Release 2-11.2.0.2

 Invoke DBCA to create database :


































Select option according to the required environment: 

      General Purpose Or Transaction Processing for OLTP environment






















 Specifying Global Database name or SID for the new database:  


















    Disable the Oracle Enterprise Manager and if needed we can configure it later separately: 
 

















As per our Standard Oracle Administrative Password is same as existing database

Select Option template or common location to specify the database files separately in different mount points to avoid I/O contention:
 



















 
      Configuring AMM (Automatic memory management feature available in 11G to tune both SGA and PGA)  
 

















Configure Database Block Size and Maximum number of processes:







Specifying Database character set as similar to our environment:


  

To install database files in different mount points to avoid contention need to modify the destination for each database files in this “Database Storage “ page as below:
 
 

Database Created Successfully

















Posted by at No comments:
Subscribe to: Posts (Atom)