启动oracle 时遇到的一个问题

athlon_r

1. 
   
2. [oracle@CC ~]$ lsnrctl start
   
3. 
   
4. LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-MAR-2006 11:18:00
   
5. 
   
6. Copyright (c) 1991, 2005, Oracle.  All rights reserved.
   
7. 
   
8. Starting /home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
   
9. 
   
10. TNS-12537: TNS:connection closed
    
11. TNS-12560: TNS:protocol adapter error
    
12.   TNS-00507: Connection closed
    
13.    Linux Error: 29: Illegal seek
    

复制代码

请问 是哪里出了问题?

dancingpig

TNS-12537 TNS:connection closed

Cause: "End of file" condition has been reached; partner has disconnected. This is an informational message.

Action: No action required.



TNS-12560 TNS:protocol adapter error

Cause: A generic protocol adapter error occurred.

Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete.




TNS-00507 Connection closed

Cause: Normal "end of file" condition has been reached; partner has disconnected. This is an informational message.

Action: No action required.




综合看来你的问题是不是lsnrctl的配置不对？

athlon_r

我 这个是刚装在as4上面的 oracle

装好后启动就是这样了
应该如何配置lsnrctl呢

dancingpig

如果你建立oracle的数据库，他的dbca会帮你在lsncrtl的配置文件里设置的
如果有问题你可以在oracle的安装目录下找到network目录下面有个admin目录
我现在在windows机器上，你的linux应该是一样的
然后有个listener.ora文件这个就是lsnrctl的配置文件，你用vi开开来看看
[PHP]
LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)[color="Red"](HOST = ludi)(PORT = 1521))<----------------这行你可以改host的地址，改成ip也可以
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = E:\oracle\ora92)
      (SID_NAME = orcl)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = stand)
      (ORACLE_HOME = E:\oracle\ora92)
      (SID_NAME = stand)
    )
  )


[/PHP]

然后你44看

athlon_r

将host段 改成ip地址后 启动又出问题了

1. [oracle@CC admin]$ lsnrctl start
   
2. 
   
3. LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 09-MAR-2006 12:31:16
   
4. 
   
5. Copyright (c) 1991, 2005, Oracle.  All rights reserved.
   
6. 
   
7. Starting /home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
   
8. 
   
9. TNSLSNR for Linux: Version 10.2.0.1.0 - Production
   
10. System parameter file is /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
    
11. Log messages written to /home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
    
12. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
    
13. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.68)(PORT=1521)))
    
14. 
    
15. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
    
16. TNS-12547: TNS:lost contact
    
17. TNS-12560: TNS:protocol adapter error
    
18.   TNS-00517: Lost contact
    
19.    Linux Error: 104: Connection reset by peer
    
20. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.68)(PORT=1521)))
    
21. TNS-12547: TNS:lost contact
    
22. TNS-12560: TNS:protocol adapter error
    
23.   TNS-00517: Lost contact
    
24.    Linux Error: 104: Connection reset by peer
    

复制代码

dancingpig

你把你的listener.ora贴上来看看

athlon_r

1. # listener.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
   
2. # Generated by Oracle configuration tools.
   
3. 
   
4. SID_LIST_LISTENER =
   
5.   (SID_LIST =
   
6.     (SID_DESC =
   
7.       (SID_NAME = PLSExtProc)
   
8.       (ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
   
9.       (PROGRAM = extproc)
   
10.     )
    
11.   )
    
12. 
    
13. LISTENER =
    
14.   (DESCRIPTION_LIST =
    
15.     (DESCRIPTION =
    
16.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    
17.       (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    
18.     )
    
19.   )
    

复制代码

dancingpig 兄有IM? 用im比较方便
详细信息里有我的msn

dancingpig

你这个10G的我不是很确定
你把原来的文件保存下，然后试下这样配置可以否
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
  )

改下，改为
LISTENER =  
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
你试下可以不可以，按照oracle的提示你这个问题应该是参数写错了
见PM

athlon_r

仍然不行

你要不要ssh上去看看

dancingpig

是不是有东西占着1521口