Oracle Startup

Материал из noname.com.ua
Версия от 15:53, 28 сентября 2012; Sirmax (обсуждение | вклад)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к навигацииПерейти к поиску
export ORACLE_SID=TERATEST
export ORACLE_HOME=/oracle/10.2.0

bash-3.00$ sqlplus / as SYSDBA 
SQL*Plus: Release 10.2.0.5.0 - Production on Thu Mar 3 15:41:22 2011
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 6442450944 bytes
Fixed Size                  2061736 bytes
Variable Size            3791653464 bytes
Database Buffers         2634022912 bytes
Redo Buffers               14712832 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

bash-3.00$ lsnrctl start LISTENER_TERATEST
LSNRCTL for Solaris: Version 10.2.0.5.0 - Production on 03-MAR-2011 15:42:46
Copyright (c) 1991, 2010, Oracle.  All rights reserved.
Starting /oracle/10.2.0/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 10.2.0.5.0 - Production
System parameter file is /oracle/10.2.0/network/admin/listener.ora
Log messages written to /oracle/10.2.0/network/log/listener_teratest.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s-k10om)(PORT=1522)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=s-k10om)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_TERATEST
Version                   TNSLSNR for Solaris: Version 10.2.0.5.0 - Production
Start Date                03-MAR-2011 15:42:46
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/10.2.0/network/admin/listener.ora
Listener Log File         /oracle/10.2.0/network/log/listener_teratest.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s-k10om)(PORT=1522)))
Services Summary...
Service "TERATEST" has 1 instance(s).
  Instance "TERATEST", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully