Home » Posts tagged 'Oracle 11g'

Tag Archives: Oracle 11g

BRTOOLS 720 (for Oracle 10g and 11g)


You can download

Brtools 7.20 is available on the servicemarket place at the following link

http://service.sap.com/swdc

Download
Support Packages and Patches – Entry by Application Group
Additional Components
SAP Kernel
SAP Kernel 64bit
Choose your OS
Choose Oracle

DBATL720O10_1-20005243.SAR DBATOOLS Package for Oracle 10g and 11g

The oss note 12741 is also useful for download paths for all released Brtools.

Advertisements

Just for Refresh : Steps to upgrade Oracle from 11.1.0.6.0 to 11.1.0.7.0


steps to upgrade 11.1.0.6.0 to 11.1.0.7.0

Step1:

using winSCP or anyother tool copy the patch file p6890831_111070_Linux-x86-64.zip to the environment from the machine where you are having patch file.

Step2:
login : oracle
password:
Uncompress the binary source
$unzip p6890831_111070_Linux-x86-64.zip
Example:-
After unzipping , you can find the below folder Disk1
c111ptqhdd009: /home/oracle
$ cd /oracle/app/patches/
c111ptqhdd009: /oracle/app/patches
$ ls
Disk1 p6890831_111070_Linux-x86-64.zip

Step3:
Bring down the application

Step4:
login : oracle
password:
Bring down the database
sqlplus ‘/as sysdba’
sql>shutdown immediate;
sql>exit
>ps -ef |grep pmon

Make sure that oracle is not running
>lsnrctl stop
>lsnrctl status
Make sure that the listener is not running.
Take a cold database backup
Controlfiles, datafiles, redo logs, archive files, tempfiles must be included in the backup. If the files are in different paths, the same has to be backedup.
>mkdir /backup_date
>cp /App1/oracle/oradata/orcl/*.* /backup/backup_date
>cd $ORACLE_HOME/dbs
>cp inittest.ora inittest.ora_bkpdate
>cp spfiletest.ora spfiletest.or_bkpdate
>cp orapwtest.ora orapwtest.ora_bkpdate
(more…)