Download and Installation of Oracle VM Virtual machine

 Step by step with snap shot 

Download and Installation of Oracle VM Virtual machine in windows 

Here we will see, from where we can download the oracle Vm virtual machine and how install it .

1. Prerequisites

2.Download location

3. Installation .

1. Prerequisites

               i) Memory (RAM) 2 GB

               ii)Hared Disk space 8GB

2. Download Location 

                http://www.oracle.com/technetwork/server-storage/virtualbox/downloads/index.html

this is the location where you will get the oracle VM

from here you can select your platform where you need to install oracle vm

3. Installation 

                after download you will get this file

•  Double click on the setup file.

image "a"

•  I am installing in "windows7" so i am getting image "a" else you will directly reach to next step

image "b"

•  Click on "next"

image "c"

• Select the option according to your choice. it will not effect on installation. 

image "d"

• Installation started  

image "e"

• Click on "finish" and your installation is complete. 

image "f"

"Image F" sis showing the Oracle VM virtual box.

• You can download this in PDF format  form below link

              "http://chetanyadavds.blogspot.in/p/documentation.html"

Or

• You can watch this on video on

               "http://chetanyadavds.blogspot.in/p/videos.html"

any mistake is there or you wanna give any suggestion so please write to me ............

tns error

ORA-12154 : "TNS:could not resolve  service name"

Cause : oracle Net Services cannot locate the connect descriptor specified in the  tnsnames.ora configuration .

>> verify the tnsnames.ora files exists and that accessible .
>>verify that tnsnames.ora file in the location by the TNS_ADMIN environment variable.

ORA-12198: "TNS: could not find  path to destination  "
ORA-12203: "TNS: unable to connect the destination "

>> verify that you have correctly enter the service name of the database that you  want to connect.
>> verify that service name address ADDRESS parameter in the connect descriptor of your  tnsname.ora file are correct .
>> verify that you tnsname.ora  file stored in the directory defined in the TNS_ADMIN environment Variable

any mistake is there or u wanna give any suggestion so please write to me ............

tnsnames.ora

sample tnsnames.ora

---------------------------------------------------------------------------------------------------

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = xp)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

---------------------------------------------------------------------------------------------------



here my DB name is "ORCL"
host is "XP"

The tnsnames.ora file is used to store the net services names. The deafault location is %ORACLE_HOME\network\admin on windows and $ORACLE_HOME/netwrok/admin/on UNIX.

any mistake is there or u wanna give any suggestion so please write to me ............

Configuring Network settings on Oracle VM

any mistake is there or u wanna give any suggestion so please write to me ............

how to create tablesape in oracle

Create tablespace
SQL> create tablesapce tablesape_name
        datafile 'datafilepath'
        size 40m
        autoextend on
        next 32 m
        extend management local;


Create Temporary tablespce 

SQL> create temporary tablesapce tablesape_name
        datafile 'datafilepath'
        size 40m
        autoextend on
        next 32 m

        extend management local;

(temporary tablespce can have only temp files not datafiles )





any mistake is there or u wanna give any suggestion so please write to me ............

Difference between 10g and 11g

1.Simplified and improved automatic memory management

2.New fault diagnosability infrastructure to prevent, detect, diagnose, and help resolve critical database errors

3.Invisible Indexes

4.Virtual columns

5.Enhanced security for password-based authentication by enabling use of mixed case in passwords.

6.Tablespace-level encryption

7.Ability to online redefine tables that have materialized view logs

any mistake is there or u wanna give any suggestion so please write to me ............

Create database manually

Create database manually in windows
or Create database through command line

STEP1: c:\> set oracle sid= rose 

STEP2:  create Pfile


 pfile content these parameter 
 "db_NAME=ROSE
   SGA_TARGET=600M
   COMPATIBLE =10.2.0 (your db version)"

Step3: (for windows we need to create instance)


create instance

"C:\>oradim -new -sid ROSE -SRVCOracleServiceROSE -STARTMODE auto -SRVCSTART system -PFILE  C:\ORACLE_HOME\database\INITrose.ORA"



Instance created.


step 4:  c:\>sqlplus  sys as sysdba


step 5:   SQL> startup nomount


 step 6: SQL> create database Rose;




step 7:  create datafile system
               SQL> alter tablespace
               system add
               datafile 'C:\%ORACLE_HOME%\rose\system01.dbf '                size 500m

Tablespace altered.

Step 8: create datafile SYSAUX
              SQL>alter tablespace
             SYSAUX add
             datafile 'C:\%ORACLE_HOME%\rose\SYSAUX01.dbf '             size 500m

Tablespace altered.
 
STEP 9:  Create temporary tablespace
                 SQL> CREATE TEMPORARY tablespace temp
                 tempfile 'C:\%ORACLE_HOME%\rose\tmp01.tmp '     size 100m
 Tablespace created.


 Step 10:  add log files Group
                  SQL>alter database
                  add logfile
                  group 2 'C:\%ORACLE_HOME%\rose\log06.log' SIZE 25M, 
                 group 3 'C:\>ORACLE_HOME%\oradata\rose\log07.log' SIZE 25M
 
Step 11:NOW RUN

SQL>@%ORACLE_HOME%\rdbms\admin\CATALOG.SQL


SQL>@%ORACLE_HOME%\rdbms\admin\CATAPROC.SQL

DONE .......


any mistake is there or u wanna give any suggestion so please write to me ............