ORACLE DBA

Upgrade Oracle 11.2.0.3 RAC to 11.2.0.4 - ( Out-of-Place Manual Upgrade ) The different upgrade methods you can use to upgrade your database to the new Oracle Database release or higher are: 1) Database Upgrade Assistant (DBUA) 2) Manual Upgrade 3) Export/Import 4) Data Copying 5) Golden Gate 1) DBUA (Database Upgrade Assistant)  The Database Upgrade Assistant (DBUA) interactively steps you through the upgrade process and configures the database for the new Oracle Database  release. The DBUA automates the upgrade process by performing all of the tasks normally performed manually. The DBUA makes appropriate recommendations for configuration options such as tablespaces and redo logs. You can then act on these recommendations. This method is very easy and user friendly. But if any error occurs it will take time to diagnose the error as the upgrade process is done automatically by the upgrade assistant. For more information, refer to the following link: 10.2=>  http://docs.orac

ASMSNMP user in ASM 11g (user creation/password change) We generally receive few errors related to asmsnmp user while using ASM. Few of them are : Could not validate ASMSNMP password due to following error- “ORA-01031: insufficient privileges” ORA-01990: error opening password file ‘/u02/app/11.2.0/grid/dbs/orapw’ ORA-15306: ASM password file update failed on at least one node ORA-01918: user ‘ASMSNMP’ does not exist Mostly the reason is missing asmsnmp user or missing password file in ASM instances. 1. How to create asmsnmp user ——————————————- First Check which all users are present for ASM  >> SQL> select * from v$pwfile_users; no rows selected OR ASMCMD> lspwusr Username sysdba sysoper sysasm This shows no user are present A) Create a password file if not already present $orapwd file=/u01/app/11.2.0/grid/dbs/orapw+ASM password= ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Remember below important point about password f

QL> startup ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated SQL> create pfile from spfile; create pfile from spfile * ERROR at line 1: ORA-01565: error in identifying file '?/dbs/spfile@.ora' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3   SQL> shut abort SQL> create pfile='/home/oracle/initORA11G.ora' from spfile='+DATA/ORA11G/spfileORA11G.ora'; File created. oracle@rac1.localdomain:/home/oracle [ORA11G1] >dba SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 6 20:15:29 2016 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup pfile='/home/oracle/initORA11G.ora'; ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size                  2228904 bytes Variable Size             956304728 bytes Database Buf