Linux机启动Oracle的过程记录

SSH Secure Shell 3.2.0 (Build 267)
Copyright (c) 2000-2002 SSH Communications Security Corp - http://www.ssh.com/

This copy of SSH Secure Shell is a non-commercial version.
This version does not include PKI and PKCS #11 functionality.


Last login: Thu Dec 31 17:57:40 2009 from 192.168.0.21

# Last login: Thu Dec 31 17:59:11 2009 from 192.168.0.151
# su - oracle
[oracle@localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 31-DEC-2009 18:03:03

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /oracle_11/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /oracle_11/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /oracle_11/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.50)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.50)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 31-DEC-2009 18:03:05
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle_11/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /oracle_11/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.50)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "game" has 1 instance(s).
Instance "game", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Service "wapgame" has 1 instance(s).
Instance "wapgame", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$ echo $ORACLE_SID
orcl
[oracle@localhost ~]$ export ORACLE_SID=wapgame
[oracle@localhost ~]$ echo $ORACLE_SID
wapgame
[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Dec 31 18:04:23 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> conncet^H
SP2-0042: unknown command "connce" - rest of line ignored.
SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 523108352 bytes
Fixed Size 1301024 bytes
Variable Size 146802144 bytes
Database Buffers 369098752 bytes
Redo Buffers 5906432 bytes
Database mounted.
Database opened.
SQL> connect system/******
Connected.
SQL>