求救！！！为什么升级linux后，监听就打不开了？？？？

LoveWinter

这个问题很有可能是你的机器上有多个Oracle产品存在,
例如Oracle  10G 和Oracle Client.  

每个Oracle产品在安装后都会改写注册表和环境变量,
而且都是后安装的产品会将路径写在%PATH%变量的
前面;

同理, 如果 一台机器中既安装了9i又安装了10G,
ORACLE_HOME这个环境变量必须去掉,否则监听器
会启动失败. 这样我们需要写两个不同的启动脚本
来启动不同版本的数据库.

因此,执行下面的命令:
set  ORACLE_HOME=xxx
set  ORACLE_SID=xxx
set  TNS_ADMIN=xxx
set  PATH=xxx  (ORACLE会按照PATH里面定义的路径顺序
去找不同版本的程序)
lsnrctl  start
sqlplus "/ as sysdba"  (如果用的是OS认证)

husthxd

最初由 zhaocfan 发布
[B]还是不行,我加上了跟踪,也产生了文件,我用tkprof编辑后,没有找到任何有用信息
Sort options: default

********************************************************************************
count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing
elapsed  = elapsed time in seconds executing
disk     = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows     = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: listener.trc
Trace file compatibility: 10.01.00
Sort options: default

       0  session in tracefile.
       0  user  SQL statements in trace file.
       0  internal SQL statements in trace file.
       0  SQL statements in trace file.
       0  unique SQL statements in trace file.
     689  lines in trace file.
       0  elapsed seconds in trace file. [/B]

use trcasst not tkprof to analyze the trace file.

zhaocfan

版主, 我就安装了一个oracle10环境变量我也看了,也都没有问题,错误还是一样.

怎么办啊!!!!!!

zhaocfan

用trcasst过滤出了,信息为:
(c) 版权所有 2001, 2004 Oracle。保留所有权利。


    *************************************************************************
    *                        Trace Assistant                                *
    *************************************************************************

<--- Received 187 bytes - Connect packet  timestamp=01-NOV-2004 18:25:47:662
Current NS version number is: 313.
Lowest NS version number can accommodate is: 300.
        Maximum SDU size: 2048
        Maximum TDU size: 4096
        NT protocol characteristics:
                Test for more data
                Spawner is running
                Hang on to Listener connection
                Test operation
                Full duplex I/O
                Urgent data support
                Generate SIGURG signal
                Handoff connection to another
        Line turnaround value: 0
        Connect data length: 129
        Connect data offset: 58
        Connect data maximum size: 2048
                Disable NA services on this connection
                No NA services are linked in
                Disable NA services on this connection
                No NA services are linked in
    (ADDRESS=(PROTOCOL=beq)(PROGRAM=/home/oracle/product/10.1/db_1/bin/tns
    lsnr)(ENVS=)(ARGV0=)(ARGS='LISTENER,-inherit')(DETACH=yes))

---> Send 32 bytes - Accept packet  timestamp=01-NOV-2004 18:25:47:709
Accepted NS version number is: 313.
        Accepted maximum SDU size: 2048
        Accepted maximum TDU size: 4096
        Connect data length: 373
        Connect data offset: 32
                Native Services wanted
                Disable NA services on this connection
                No NA services are linked in
                Disable NA services on this connection
                No NA services are linked in
        Packet data is in the following data packet

---> Send 383 bytes - Data packet  timestamp=01-NOV-2004 18:25:47:730
    TNSLSNR for Linux: Version 10.1.0.3.0 - Production
    System parameter file is /home/oracle/product/10.1/db_1/network/admin/
    listener.ora
    Log messages written to /home/oracle/product/10.1/db_1/network/log/lis
    tener.log
    Trace information written to /home/oracle/product/10.1/db_1/log/listen
    er.trc
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=100.1.1.197)(P
    ORT=1521)))
不明白这个错误是什么意思,查不到

    Native Services wanted
Disable NA services on this connection
No NA services are linked in
Disable NA services on this connection
No NA services are linked in

zhaocfan

各位大侠,救命啊!!!!

zhaocfan

不明白这个错误是什么意思,查不到

Native Services wanted
Disable NA services on this connection
No NA services are linked in
Disable NA services on this connection
No NA services are linked in

enhydra

这个问题还解决了?我现在碰到了同样的问题.