To download the latest OPatch version from My Oracle Support (MOS)
using the next reference:
Patch 6880880.
Or
using the next URL:
https://updates.oracle.com/download/6880880.html
2) In the "Platform" field select the relevant
platform that corresponds to the Oracle product.
3) Click the Download button
Sunday, August 11, 2013
Oracle Database Client
Installing
using response file in silent mode:
1.
Download the software
2. unzip the software. A directory called client is created at the location.
unzip <file_name>
3. Copy the original response file to temp location.Original response file location will be <Base_Dir>/client/response.
2. unzip the software. A directory called client is created at the location.
unzip <file_name>
3. Copy the original response file to temp location.Original response file location will be <Base_Dir>/client/response.
Saturday, March 16, 2013
Upgrades of Oracle databases from any version to any version on any platform
Oracle Docs:
Upgrade:
Upgrade:
1. Complete checklist for manual upgrades of Oracle databases from any version to any version on any platform (documents only from 7.3.x>>8.0.x>>8.1.x>>9.0.x>>9.2.x>>10.1.x>>10.2.x>>11.1.x>>11.2.x) [ID 421191.1]
- This document provides only the links to others which clearly explains the steps of migrating Oracle databases manually from any version to any version on any platform.
2. Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]
- This document is created for use as a guideline and checklist when manually upgrading from Oracle 9iR2 (9.2), Oracle 10gR1 (10.1), Oracle 10gR2 (10.2) or Oracle 11gR1 (11.1) to Oracle 11gR2 (11.2).
3. Complete Checklist to Upgrade the Database to 11gR2 using DBUA [ID 870814.1]
- The purpose of this article is to minimize the downtime while upgrading the database using DBUA.
4. Information Center: Upgrading and Migration Oracle Database [ID 1351112.2] .
5. Master Note For Oracle Database Upgrades and Migrations [ID 1152016.1]
- This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Database Upgrade and Migration.
6. Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset. [ID 1276368.1]
- This document explains how to perform an out-of place manual database upgrade from 11.2.0.1 to 11.2.0.2 or later version of 11.2.0.N.Thursday, January 10, 2013
AIX for Oracle DBA
A) Memory Consumption:
$ svmon -G size inuse free pin virtual memory 5079040 5076409 2631 706856 2983249 pg space 7864320 12885 work pers clnt other pin 540803 0 2758 163295 in use 2983249 0 2093160
Wednesday, January 9, 2013
Manual Creation of Oracle Database
1. Create the pfile and sample parameter file is below
DUMMY.__db_cache_size=109051904
DUMMY.__java_pool_size=4194304
DUMMY.__large_pool_size=4194304
DUMMY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
DUMMY.__pga_aggregate_target=167772160
DUMMY.__sga_target=251658240
DUMMY.__shared_io_pool_size=0
DUMMY.__shared_pool_size=125829120
DUMMY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/DUMMY/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/ORADATA/DUMMY/fra/DUMMY/controlfile/control_01_.ctl','/ORADATA/DUMMY/fra2/DUMMY/controlfile/control_02_.ctl'
DUMMY.__db_cache_size=109051904
DUMMY.__java_pool_size=4194304
DUMMY.__large_pool_size=4194304
DUMMY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
DUMMY.__pga_aggregate_target=167772160
DUMMY.__sga_target=251658240
DUMMY.__shared_io_pool_size=0
DUMMY.__shared_pool_size=125829120
DUMMY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/DUMMY/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/ORADATA/DUMMY/fra/DUMMY/controlfile/control_01_.ctl','/ORADATA/DUMMY/fra2/DUMMY/controlfile/control_02_.ctl'
Friday, January 4, 2013
Using ssh-keys from Openssh to Tectiassh and vice-versa
How to find the server is Openssh or Tectiassh
> ssh -V
> ssh -V
Configuration starts from here
1. On SERVERA with Openssh:
1. ssh-keygen -t rsa
2. cd .ssh
3. It creates two files id_rsa and id_rsa.pub
4. Create a file authorized_keys and copy/paste id_rsa.pub into it.
5. ssh-keygen -e -f id_rsa.pub >Openssh_to_Tectiassh
2. cd .ssh
3. It creates two files id_rsa and id_rsa.pub
4. Create a file authorized_keys and copy/paste id_rsa.pub into it.
5. ssh-keygen -e -f id_rsa.pub >Openssh_to_Tectiassh
Subscribe to:
Posts (Atom)