启动linux system 中oracle 10g 的监听及数据库实例
1.使用oracle 用户登录linux 系统#
# su - oracle
$
2.启动监听
$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-OCT-2009 16:37:54
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/oracle/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/oracle/network/admin/listener.ora
Log messages written to /u01/oracle/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 22-OCT-2009 16:37:56
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/network/admin/listener.ora
Listener Log File /u01/oracle/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$
3.登录sqlplus
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 22 16:38:15 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL>
4.connect user
SQL>
SQL> conn sys/pwd as sysdba
Connected to an idle instance.
SQL>
SQL>
5.start database intance
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 247463936 bytes
Fixed Size 1218772 bytes
Variable Size 79693612 bytes
Database Buffers 163577856 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
6.执行查询命令:
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DEPT TABLE
EMP TABLE
BONUS TABLE
SALGRADE TABLE
SQL> exit
---------------------------------------------------------------
OK ,ORACLE10g数据库已经启动了,呵呵！祝你好运！
页:
[1]