linux 操作 oracle

linux 连接oracle

 

[test@localhost /]$ su - oracle
Password:
[oracle@localhost ~]$

//查看监听

 

[oracle@localhost ~]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-AUG-2009 14:51:43

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

 

// 退出监听
LSNRCTL> exit

 

1. 启动isqlplus(isqlplus就是在浏览器可以使用的sqlplus，具体的用法，会在后面讲)

[oracle@graduate ~]$ isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
warning, got duplicate tcp line.
Starting iSQL*Plus ...
iSQL*Plus started.

2. 启动em(enterprise managment)

在在终端提示符下输入命令如下：

关于emctl的用法，可以在提示符下，直接输入emctl，不加任何其他选项，将会出现usage

。

[oracle@graduate ~]$emctl start dbconsole

TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://你的IP:1158/em/console/aboutApplication