阳光石油网|石油技术交流|石油人论坛

 找回密码
 欢迎注册
查看: 4532|回复: 4

landmark的Oracle OWSYSSID问题求教!!

[复制链接]
  • TA的每日心情
    奋斗
    2018-6-30 14:42
  • 签到天数: 17 天

    [LV.4]偶尔看看III

    发表于 2009-10-11 16:11:29 | 显示全部楼层 |阅读模式

    马上注册,下载丰富资料,享用更多功能,让你轻松玩转阳光石油论坛。

    您需要 登录 才可以下载或查看,没有账号?欢迎注册

    x
    图片:


    Project Admin 有个错误提示:
    Error Opening OWSYS
    The master database owsys could not be connected.
    Check to see that the value of OWSYSSID is set correctly.
    Make sure that connection to OWSYSSID can be made.
    Make sure that both ORACLE and listener are running.
    RUN orastat for more diagnosic information.
    See the OpenWorks System Administraion Guide for details

    orastat  信息如下:


    liu6{ow03}% orastat
    ------------------------------------------------------------------------------
    # Checking environmentals on host: liu6...
    OWHOME is set to:              /home2/OpenWorks
    ORACLE_HOME is set to:         /home2/oracle/OraHome1
    ORACLE_SID is set to:          owwsy
    OWSYSSID is set to:            owwsy
    ------------------------------------------------------------------------------
    # Determining Landmark applications installed ...
    GeoDataLoad: GeoDataLoad        2003.12.0.1     UPDATE PASSED 12102005@10:22:48 /home2/OpenWorks/GeoDataLoa
    d Linux
    SeisWorks: SeisWorks    2003.12.1       INSTALL PASSED 10102005@15:29:03 /home2/OpenWorks/SeisWorks Linux
    SeisUtils: SeisUtils    2003.12.1       INSTALL PASSED 10102005@15:30:37 /home2/OpenWorks/SeisUtils Linux
    StratWorks: StratWorks  2003.12.0.1     INSTALL PASSED 10102005@15:40:18 /home2/OpenWorks/StratWorks Linux
    StratUtil: StratUtil    2003.12.0.1     INSTALL PASSED 10102005@15:39:52 /home2/OpenWorks/StratUtil Linux
    PetroWorks: PetroWorks  2003.12.0.0     INSTALL PASSED 10102005@15:45:26 /home2/OpenWorks/PetroWorks Linux
    SynTool: SynTool        2003.12 INSTALL PASSED 10102005@16:13:33 /home2/OpenWorks/SynTool Linux
    ------------------------------------------------------------------------------
    # Checking background daemons ...
    Dynamic PD is ENABLED
    NetD is operational on host localhost for Dynamic PD
    Dynamic PD Session is RUNNING: SessionID: OPENWORKS_600_ow03@192.0.2.88:0_PD Value: liu6:27962
    Dynamic Pointing Dispatcher operational. checkpd returns OK
    root      6418     1  0 15:18 ?        00:00:00 /home2/OpenWorks/lam/bin/lmgrd -c /home2/OpenWorks/lam/lice
    nse.dat
    root      6435  6418  0 15:18 ?        00:00:00 licsrv -T liu6 7.2 3 -c /home2/OpenWorks/lam/license.dat --
    lmgrd_start 4ad186e3
    LAM SERVER (lmgrd) running OK
    root      6435  6418  0 15:18 ?        00:00:00 licsrv -T liu6 7.2 3 -c /home2/OpenWorks/lam/license.dat --
    lmgrd_start 4ad186e3
    licsrv server running OK
    ------------------------------------------------------------------------------
    # ORACLE sids/host accessable through listener are ...
    Found /home2/oracle/OraHome1/network/admin/tnsnames.ora
    INST1_HTTP  liu6
    OWWSY  liu6
    *** Cannot rsh to liu6 as ow03
    *** Unable to check ORACLE daemons
    NetD server running OK on liu6 for Project Management purposes
    checkRSvD returns OK for liu6 for Project Management purposes
    ------------------------------------------------------------------------------
    # Checking ORACLE daemons on liu6...
    oracle    6539     1  0 15:19 ?        00:00:00 ora_pmon_owwsy
    pmon running OK on liu6
    oracle    6541     1  0 15:19 ?        00:00:00 ora_dbw0_owwsy
    dbw0 running OK on liu6
    oracle    6543     1  0 15:19 ?        00:00:00 ora_lgwr_owwsy
    lgwr running OK on liu6
    oracle    6547     1  0 15:19 ?        00:00:00 ora_smon_owwsy
    smon running OK on liu6
    oracle    6549     1  0 15:19 ?        00:00:00 ora_reco_owwsy
    reco running OK on liu6
    oracle    6549     1  0 15:19 ?        00:00:00 ora_reco_owwsy
    tnslsnr running OK on liu6
    ------------------------------------------------------------------------------
    # Checking sqlplus/sql*net as ow03...
    ERROR:
    *** WARNING: Database cannot be accessed by ow03 ***
    *** Make sure that ow03 is an External ORACLE User
  • TA的每日心情
    开心
    2011-11-29 01:02
  • 签到天数: 1 天

    [LV.1]初来乍到

    发表于 2010-12-28 16:50:03 | 显示全部楼层
    tnslsnr没有起来(要用dba的用户起),或是数据库根本没有起来
  • TA的每日心情
    开心
    2011-11-29 01:02
  • 签到天数: 1 天

    [LV.1]初来乍到

    发表于 2010-12-28 16:50:36 | 显示全部楼层
    兄弟现在搞定了没有
  • TA的每日心情
    慵懒
    2017-3-30 08:46
  • 签到天数: 64 天

    [LV.6]常住居民II

    发表于 2011-9-12 11:18:34 | 显示全部楼层
    oracle没起来吧
    lsnrctl -status看看
  • TA的每日心情
    无聊
    2014-7-3 16:31
  • 签到天数: 5 天

    [LV.2]偶尔看看I

    发表于 2012-10-23 18:43:00 | 显示全部楼层
    我的也是这个问题,请教下,能不能详细的说明下
    您需要登录后才可以回帖 登录 | 欢迎注册

    本版积分规则

    QQ|Archiver|手机版|小黑屋|阳光石油网 ( 鲁ICP备2021003870号-1 )

    GMT+8, 2024-5-21 07:44 , Processed in 0.066285 second(s), 23 queries .

    Powered by Discuz! X3.4 Licensed

    Copyright © 2001-2021, Tencent Cloud.

    快速回复 返回顶部 返回列表