11.2.0.1.0 database creation through dbca

-
Login to oracle
set the oracle enviornment if not set
Create Listener through netca









[oracle@localhost ]$ dbca










Click "Yes"











Click "Next"



Click "Finish"








Installation complete.

Comments

Post a Comment

Popular posts from this blog

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...
Read more

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...
Read more

RMAN compression

-
RMAN Compression: There are 3 three types of compression by default: 1.       Null compression ·         Usages only till Oracle version 10.1 by default ·         RMAN skips the block that have never been used when backing up datafiles into backup sets. ·         E.g. let’s tablespace having once datafile of size 100MB and out of 100 MB only 50 is used. Then RMAN will backup only 50 MB. 2.       Unused block compression ·         Oracle version 10.2 forward, uses ‘Null’ and ‘unused block’ compression. ·         More compact backups of datafiles by skipping datafile blocks that are not currently used to store data. ·         In previous release, RMAN only supported NULL compression, which skipped space in ...
Read more