DBA Hub

📋Steps in this guide1/4

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

oracle configurationintermediate
by OracleDba
13 views
1

Overview

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
2

Section 2

SQL*Plus: Release 12.1.0.2.0 Production on Tue Oct 30 00:20:10 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 3841982464 bytes
3

Section 3

Fixed Size 3052576 bytes Variable Size 872418272 bytes Database Buffers 2952790016 bytes Redo Buffers 13721600 bytes Database mounted. Database opened.
4

Section 4

3. At last check the status of database. SQL> select name,open_mode from v$database; NAME OPEN_MODE ——— ——————– GRP READ WRITE

Comments (0)

Please to add comments

No comments yet. Be the first to comment!