Changing Owner of Oracle Database Software

CHANGING OWNER OF ORACLE DATABASE SOFTWARE



1) Taken rman backup of databases in /backup2

2) shutdown the databases  and stopped listener

3) Change Permissons
  cd /db ----> all data and redo log files and file locations
  chown -R oracle:dba *

  cd /oradump ---> all archivelog recover dump locations
  chown -R oracle:dba *

  cd /var/opt
  chown -R oracle:dba *

4) Ran root .sh

Before running root.sh

Cors verified Oracle owner and greoup valuse in below script

/db/app/oracle/product/11.2.0/dbhome_2/install/utl/rootmacro.sh

ORACLE_HOME=/db/app/oracle/product/11.2.0/dbhome_2
ORACLE_OWNER=oracle
OSDBA_GROUP=dba
MAKE=/usr/bin/make


5) ran root.sh as root


make sure permissions like below for $ORACLE_HOME/bin/oracle

-rwsr-s--x    1 oracle   dba       309595361 Oct 24 2014  oracle

if not change:

chmod 6751 oracle


6) started listener and databases

if listener staet failes maksure below

cd /var/tmp/.oracle

delete all files in this and start listener again

No comments:

Post a Comment