Monday, June 17, 2013

To Start/Stop Oracle 11g DB on Linux 5.3 OS

To Start Oracle 11g DB

[oracle@oraxxxx ~]$ export  $ORACLE_SID=orcl
[oracle@oraxxxx ~]$ echo $ORACLE_SID
orcl

[oracle@oraxxxx ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 17 11:05:30 2013
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1052233728 bytes
Fixed Size                  2220032 bytes
Variable Size             792723456 bytes
Database Buffers          251658240 bytes
Redo Buffers                5632000 bytes
Database mounted.
Database opened.

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraxxxx ~]$ sqlplus "/ as sysdba"
Connected to: 
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>

 
To Stop Oracle 11g DB

[oracle@oraxxxx ~]$ sqlplus "/ as sysdba"
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraxxxx ~]$ sqlplus "/ as sysdba"
Connected to an idle instance.
SQL>

No comments:

Post a Comment