To Start Oracle 11g DB
orcl
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 Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
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
SQL>
[oracle@oraxxxx ~]$ export $ORACLE_SID=orcl
[oracle@oraxxxx ~]$ echo $ORACLE_SIDorcl
[oracle@oraxxxx ~]$ sqlplus "/ as
sysdba"
SQL*Plus: Release 11.2.0.1.0 Production
on Mon Jun 17 11:05:30 2013Copyright (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