windows

How to Set ORACLE_HOME & ORACLE_SID on Windows Server

We will be finding out the way to set oracle environment path for windows server. What is ORACLE_HOME used for? The ORACLE_HOME is an environment variable which is used to set and define the path of Oracle Home (server) Directory. How to set ORACLE_HOME in Environment variable To set the ORACLE_HOME environment variable go to …

How to Set ORACLE_HOME & ORACLE_SID on Windows Server Read More »

Oracle 12C database startup on windows platform

1. First We need to set the environment path for PATH,ORACLE_HOME and ORACLE_SID. we can get the path of sid from services.msc C:\Windows\system32>set PATH=f:\app\ankush\product\12.1.0\dbhome_4\bin C:\Windows\system32>set ORACLE_HOME=f:\app\ankush\product\12.1.0\dbhome_4\ C:\Windows\system32>set ORACLE_SID=GRP 2. Connect to sqlplus utility and fire the startup command. C:\Windows\system32>sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 30 00:20:10 2018 Copyright (c) 1982, …

Oracle 12C database startup on windows platform Read More »