Steps to Setup Oracle Software Installation

Step 1: Download the software from Oracle website. Click Here

Step 2: Once the download is complete means proceed for installation. For reference use the link: Click Here

Step 3: Create table-space, schema using command prompt

  • Login into the database using default username and password which you given during installation.
  • Create table space using command : create tablespace TS_NAME DATAFILE 'temp_core.dat' SIZE 100M REUSE AUTOEXTEND ON;
  • Create user using command: create user camelone identified by password default tablespace TS_NAME;
  • Grant role and permission to the user : grant dba,connect,resource to camelone;

Step 4: Once the installation is done, use the third part tool or database connector like Oracle SQL Developer link or PLSQL connector to connect to the database.

That's all. Now you can hopefully connect and build any web application using oracle of any version.