Oracle小记

Oracle小记

oracle实例启动

Centos6.5 有两个数据库实例 one 和 dci

需要都起来

关键:操作每个数据库实例之前设置ORACLE_SID变量
export ORACLE_SID=数据库实例

使用oracle用户登录主机

[root@entel2 ~]# su - oracle
oracle@entel2:[/oracle]$export ORACLE_SID=one
oracle@entel2:[/oracle]$sqlplus sys/system as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 28 07:23:47 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>startup

监听启动

切到oracle用户

[root@entel2 ~]# su - oracle

查看监听状态

[root@fsailing1 ~]# su - oracle
[oracle@fsailing1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-12018 08:06:23

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

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                11-12018 18:55:14
Uptime                    0 days 13 hr. 11 min. 8 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fsailing1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "one" has 1 instance(s).
  Instance "one", status READY, has 1 handler(s) for this service...
Service "oneXDB" has 1 instance(s).
  Instance "one", status READY, has 1 handler(s) for this service...
Service "one_XPT" has 1 instance(s).
  Instance "one", status READY, has 1 handler(s) for this service...
The command completed successfully

启动/停止

lsnrctl start/stop