帮忙!我的数据库是oracle8i的,我在自己的机子(windows)上装了一个以管理员的身份登录到oracle执行
sql> $lsnctrl set log_status off;成功可在的服务器上(linux),就不行SQL> $lsnrctl set log_status off;
SP2-0734: unknown command beginning "$lsnrctl s..." - rest of line ignored.
SQL> 这是什么原因啊?
sql> $lsnctrl set log_status off;成功可在的服务器上(linux),就不行SQL> $lsnrctl set log_status off;
SP2-0734: unknown command beginning "$lsnrctl s..." - rest of line ignored.
SQL> 这是什么原因啊?
window下是$,linux下是!
SQL> $lsnrctl status
SP2-0734: unknown command beginning "$lsnrctl s..." - rest of line ignored.
SQL> !lsnrctl statusLSNRCTL for Linux: Version 10.2.0.4.0 - Production on 30-SEP-2009 11:45:31Copyright (c) 1991, 2007, Oracle. All rights reserved.Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 30-SEP-2009 12:49:59
Uptime 0 days 0 hr. 58 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/app/oracle/product/10.2.0.1/db_1/network/admin/listener.ora
Listener Log File /opt/app/oracle/product/10.2.0.1/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "cqwt" has 1 instance(s).
Instance "cqwt", status READY, has 1 handler(s) for this service...
Service "cqwtXDB" has 1 instance(s).
Instance "cqwt", status READY, has 1 handler(s) for this service...
Service "cqwt_XPT" has 1 instance(s).
Instance "cqwt", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$
SQL> $lsnrctl set log_status off;$是linux系统的标志,就像window dos下的>
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
D:\>[oracle@localhost ~]$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-SEP-2009 13:48:04Copyright (c) 1991, 2005, Oracle. All rights reserved.真正的命令是:lsnrctl set log_status off;至于2楼说的:SQL> !lsnrctl set log_status off; ! 在SQL里面表示执行非SQL的语句
如:
SQL> !fdisk -lwindow下是$,linux下是!