linux 操作 oracle

xiaoxiao2022-06-11  26

linux 连接oracle

 

[test@localhost /]$ su - oraclePassword: [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> statusConnecting 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 directoryConnecting 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 startiSQL*Plus 10.2.0.1.0Copyright (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 PRCOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.http://你的IP:1158/em/console/aboutApplication

转载请注明原文地址: https://www.6miu.com/read-4930162.html

最新回复(0)