Friday, September 27, 2013

"Invalid Entry Size" Error during Oracle Database Installation

INFO: Number of threads for fast copy :1
INFO: invalid entry size (expected 452539260 but got 452538217 bytes)
SEVERE: oracle.sysman.oii.oiif.oiifb.OiifbEndIterateException: invalid entry size (expected 452539260 but got 452538217 bytes)
        at oracle.sysman.oii.oiic.OiicInstallAPISession.doOperation(OiicInstallAPISession.java:490)
        at oracle.sysman.oii.oiic.OiicAPIInstaller.doOperation(OiicAPIInstaller.java:1010)
        at oracle.sysman.oii.oiic.OiicAPIInstaller.doOperation(OiicAPIInstaller.java:971)
        at oracle.install.driver.oui.OUISetupDriver.setup(OUISetupDriver.java:444)
        at oracle.install.driver.oui.SetupJob.call(SetupJob.java:178)
        at oracle.install.driver.oui.SetupJob.call(SetupJob.java:52)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
        at java.util.concurrent.FutureTask.run(FutureTask.java:123)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:651)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:676)
        at java.lang.Thread.run(Thread.java:637)

INFO: Update the state machine to STATE_READY
INFO: isSuccessfullInstallation: false
INFO: isSuccessfullRemoteInstallation: true
INFO: Adding ExitStatus FAILURE to the exit status set
INFO: Shutting down OUISetupDriver.JobExecutorThread
SEVERE: [FATAL] invalid entry size (expected 452539260 but got 452538217 bytes)
   CAUSE: No additional information available.
   ACTION: Refer to the logs or contact Oracle Support Services
   SUMMARY:
       - invalid entry size (expected 452539260 but got 452538217 bytes).
Refer associated stacktrace #oracle.install.commons.util.exception.DefaultErrorAdvisor:5637
INFO: Advice is ABORT
SEVERE: Unconditional Exit
INFO: Adding ExitStatus FAILURE to the exit status set
INFO: Finding the most appropriate exit status for the current application
INFO: Exit Status is -1
INFO: Shutdown Oracle Database 11g Release 2 Installer
INFO: Unloading Setup Driver

CAUSE
The cause was due to corrupted Installation Source files which can happen during download, copy, or ftp transfer to another server.

SOLUTION
Once the Oracle installation kit has been downloaded from either OTN or Oracle Software Delivery Cloud confirm the file sizes and checksums match the values from the download site.

 If you are moving the software installation from one server to another then transfer the source using ftp/scp in binary mode and check the above values before starting the installation.

Monday, September 16, 2013

SQL Developer


Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. SQL Developer can connect to any Oracle Database version 10g and later and runs on Windows, Linux and Mac OSX.

The latest release of Oracle SQL Developer is version 4 and even it supports oracle database.
In this post we are going to see how to download and install the SQL Developer. As a DBA these utilities are very helpful and makes our job easier.
Step1:  Download the SQL Developer V3.2.2 and Java JDK6u45
  • You can download the SQL Developer from here. Make sure you logged into Oracle and must accept the license agreement before download. 

  • In order to deploy the SQL Developer in windows 64 bit platform we need to download the Java 6 JDK. That can be downloaded from here.  I downloaded and installed jdk-6u45-windows-x64.exe
Step2:  Set the PATH 
  • Extract the downloaded sqldeveloper64-3.2.20.09.87-no-jre file. Get into the folder and find the sqldeveloper application. It will give you a small windows asking for java path as shown below.
                       
  • Click OK.  Welcome page of SQL Developer         

STEP 3: Make the Connection
  • To establish a connection between our database and SQL developer, firstly our database server must be up and running and listener must be up. Click on "+" symbol to enter the connection details.
Here In my case my database server is running on Linux VM.
           IP Address:     192.168.1.5 (Bridged)
           Schema:          HR
           ORACLE_SID:   test
  • Once the test connection is success you can click on Connect to start working with HR schema. Expand the tab you can see the all Database Objects.
This is how we can simply make the connection. Make sure your target IP is pinging from the windows and listener must be up and running. Please let me know your views on this.

Creating Virtual Machine(VM)

In this post we are going to see "How to Create VM". I hope you are finished installing Virtual Box. It's time to create a virtual machine so that you can start playing with another operating system.Before Virtualbox I had to boot the OS again and  I had to switch to another OS. Dual Boot was the option in the beginning where it needs to shutdown my current OS. But with this Virtualization problem got solved.Now a days everyone is looking for the Virtualization.
  • Once the installation of VirtualBox is done.The very first screen is going to looks like below screen.

  • It's always to save the VBox files in another drive.So I'm changing the default location of Vbox files.Click on File --> Preferences

  •  In Default Machine folder click on Others. It is going to ask you where to save the file.Here you can give the (D:\,E:\ drives). Here In my case I've created new folder.
                           
  • You can see the same in the following screenshot.
  • Click on New to create VM. It's going to pop you a window asking for 
    Name: The Machine name
    Type :  OS type (ex: windows/linux/solaris)
    Version: 32/64bit. 
                          
  • Specify the RAM you want to allocate the VM machine.It will warn you if you give more than 65% of you RAM.Specify the RAM and Click Next

  •  For a VM we need to create the hard drive too. Click on Create


  • Click on Next



  •  Click Next



  • Mention the Hard drive size . Here we are logically assigning the space.So even if you don't have 100gb of space still you can able to give.Click on Create


  •  We have finished creating the virtual machine.



  • Now we can able to put the CD/DVD iso and we can start installing the OS. Settings -->Storage-->+ symbol-->Choose disk


  •  Give the input in the ISO format or you can insert the CD/DVD drive.


  •  You can able to see the inserted iso image under the controller IDE. Click OK


  •  click on Start  to start the Virtual Machine.


The same approach is used to install any operating system .In the above example I used linux. This is how we can able to create the Virtual Machine after that we can start installing the Operating system by giving the iso image as input.


Installation of Virtual Box

Virtual Box Installation

In this post we are going to see how to download and install the Virtual Box. In the previous post I have mentioned the download links.Otherwise click here to visit the site.
  • Once you landed into the site, based on OS platform you can download the Virtual Box.I have downloaded windows version in my case. Following screen depicts you downloading process.
VBox  4.2.16 Download 

  •  Double click on the setup file to start the installation.Click on Next
  • Click Next
  • Click Next 

  •  Click Yes

  • Click Install




  •  Started installing Virtual Box.You can see the progress 


  •  Click on Finish. 


Every windows user is familiar with this type of installation. It's just like installing any other software. I hope this post is somewhat useful for the newbies.As we installed VirtualBox, we will try to create a virtual machine. 

In the Next post we are going to see "How to create a VM"

Oracle VirtualBox New Release

Oracle VirtualBox 4.2.18 was released 6th September, 2013

VirtualBox is powerful Cross-platform Virtualization Software for x86-based systems.
"Cross-platform" means that it installs on Windows, Linux, Mac OS X and Solaris x86 computers. And "Virtualization Software" means that you can create and run multiple Virtual Machines, running different operating systems, on the same computer at the same time. For example, you can run Windows and Linux on your Mac, run Linux and Solaris on your Windows PC, or run Windows on you Linux systems. 

Oracle VM VirtualBox is availble as Open Source or pre-built Binaries for Windows, Linux, Mac OS X and Solaris.

Windows 32/64 bit users can download by clicking here 

For other platforms you can visit the site.


Next post will be the installation and advanced usage of Virtualbox.