Posts

Oracle Linux Server 6.0 readiness for Oracle Binary

-
Image
Next Screen.... Click on Skip... Click on N ext..... Click on disred lanugage, English by default Selected. Click Next.. Click Next Click Next Click Re-initalize all  Enter Hostname Select Timezone and Click Next Enter Root Password and Click Next Procced with "Create Custom Layout" Base System Base Compatibilty Libraries Console Internet Tools Debugging Tools Directory Client Hardware Monitoring utilites Java Platform Large Systems Performance Network file system client Perfomance Tools Perl Support Storage Availabilty Tools iSCSI Storage Client Servers Server Platform System administration tools Web Services PHP Support TurboGears application framework Web Server Web Servlet Engine Databases MySQL Database client MySQL Database server PostgreSQL Database Client PostgreSQ...
Post a Comment
Read more

11.2.0.4 binary information

-
Table 1 Installation Types and Associated Zip Files Installation Type Zip File Oracle Database (includes Oracle Database and Oracle RAC) Note: you must download both zip files to install Oracle Database. p13390677_112040_ platform _1of7.zip p13390677_112040_ platform _2of7.zip Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart) p13390677_112040_ platform _3of7.zip Oracle Database Client p13390677_112040_ platform _4of7.zip Oracle Gateways p13390677_112040_ platform _5of7.zip Oracle Examples p13390677_112040_ platform _6of7.zip Deinstall p13390677_112040_ platform _7of7.zip
Post a Comment
Read more

Database upgrade -11.2.0.1 to 11.2.0.4

-
Database upgrade -11.2.0.1 to 11.2.0.4 Complete Checklist for out-of-Place Manual Upgrade from Previous 11.2.0.N Version to the Latest 11.2.0.N Patchset (Doc ID 1276368.1) STEP 1) Download the 11.2.0.4 or RDBMS software. STEP 2) Install the latest 11.2.0.4 RDBMS Software into a new ORACLE_HOME. STEP 3 ) After installing the latest 11.2.0.4 RDBMS software, run Pre-upgrade tool (utlu112i.sql) on database (11.2.0.1). You need to review pre-upgrade output and fix if any issues before upgrading to the latest release of 11.2.0.4. STEP 4) Run  dbupgdiag.sql  script from the below My Oracle Support article to verify that all the components in dba_registry are valid and no invalid data dictionary objects exist in dba_objects. Note 556610.1  Script to Collect DB Upgrade/Migrate Diagnostic Information ( dbupgdiag.sql ) $ sqlplus / as sysdba sql> alter session set nls_language=’American’; sql> @ dbupgdiag.sql sql> exit If the  db...
Post a Comment
Read more

Supported oracle database upgrade path

-
Table 1-1 Examples of Upgrade Paths for Oracle Database 12 c Current Release Upgrade Options 12.1.0.1, 12.1.0.2 11.2.0.3 or later Direct upgrade is supported.  Perform the upgrade using the current  Oracle Database Upgrade Guide , which is this guide. 11.2.0.1, 11.2.0.2 11.1.0.6, 11.1.0.7 10.2.0.2, 10.2.0.3, 10.2.0.4 and 10.2.0.5 10.1.0.5 9.2.0.8 or earlier Direct upgrade to Oracle Database 12 c  is not supported. Solution:  Upgrade to an intermediate Oracle Database release that can be directly upgraded to the current release. You must upgrade Oracle Database releases that are not supported for direct upgrade in this release to an intermediate Oracle Database release that is supported for direct upgrade. When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release documentation. After you complete an upgrade to the intermediate release Oracle Database, you can upgrade the intermediate relea...
Post a Comment
Read more

Data Guard Physical Standby Setup in Oracle Database 11g Release 2

-
System Configuration: Two VMS          1. Primary Server                  OS - Redhat Linux 5.11          Oracle - 11.2          IP - 192.168.1.100          Hostname - sourcenode01        2. Standby Server          OS - Redhat Linux 5.11          Oracle - 11.2 (Only software has installed)          IP - 192.168.1.101          Hostname - targetnode01 Primary Server Setup Logging Check that the primary database is in archivelog mode. SQL> select name from v$database; NAME --------- SRC01 SQL> select log_mode from v$database; LOG_MODE ------------ ARCHIVELOG SQL> If it is noarchivelog mode, switch is to archivelog mode. SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE...
Post a Comment
Read more