Oracle Database Installation in Local Environment

Steps to Setup Oracle Database Software Installation :

      

1. Download the software from Oracle website. Click Here


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


3. Create table-space, schema using command prompt


4. 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;


5. 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.