Chinaunix

标题: oracle 菜鸟问题 [打印本页]

作者: GuanKA1    时间: 2006-03-18 14:44
标题: oracle 菜鸟问题
我在查看ORACLE启动的时候出现了
[oracle@linux ~]$ lsnrctl service

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 18-MAR-2006 14:36:52

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
The command completed successfully
我在启动的时候
[oracle@linux ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 18-MAR-2006 14:42:53

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

Starting /oracle/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.1.0.2.0 - Production
System parameter file is /oracle/network/admin/listener.ora
Log messages written to /oracle/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   Linux Error: 98: Address already in use

Listener failed to start. See the error message(s) above...
请问个位高手这是什么原因.
作者: mocou    时间: 2006-03-18 18:16
你的lsnrctl 已起来了吧
作者: GuanKA1    时间: 2006-03-18 18:59
是起来了,但是我忘记密码了,请问如何解决
作者: mocou    时间: 2006-03-18 19:05
直接修改密码可以吗
作者: GuanKA1    时间: 2006-03-19 02:37
好像是不成,我连sqlplus都进步去。请问如何处理呀?我刚刚接触oracle什么都不太懂请您说的具体一点。
作者: yanxhyyy    时间: 2006-03-19 16:19
在oracle用户中
sqlplus  '/as sysdba'
就进入sqlplus了




欢迎光临 Chinaunix (http://bbs.chinaunix.net/) Powered by Discuz! X3.2