`
Jack Wu
  • 浏览: 891498 次
  • 来自: ...
社区版块
存档分类
最新评论

BASIS-- SAP: Troubleshooting Server Startup

阅读更多
Checklist for troubleshooting SAP server startup:

What to Check How to Check It Tips
Network
  1. Make sure that your database is mounted and open.
  2. Use either Control Panel >> Services >> Oracle TNSListener, or the command lsnrctl (preferable) to start the listener service
  3. execute tnsping <SID>
  4. execute tp connect <SID> (from /usr/sap/trans/bin dir). If it doesn't work, do a tp go <SID> to show the environment variables.
Check listener.ora, tnsnames.ora, sqlnet.ora. Using lsnrctl gives more feedback, which is recorded in the file listener.log. Also see sqlnet.log
Database Use svrmgr or sqldba to check database startup and shutdown:
  1. connect internal
  2. shutdown
  3. startup
  1. add the immediate or abort options to shutdown if necessary
  2. divide startup into phases by starting startup nomount, then continuing with alter database mount and alter database open
  3. try alter database recover after a crash or power failure
Applications After successfully starting the database, start the application services (from NT, use the SAP Service Manager). From UNIX, use the startsap r3 script).
  • Check the logs in the directory usr/sap/SID/DVEBMGS/work
  • For NT, make sure the Oracle and SAP Services are started. Also check that the NT service RPC is started and working (test it by adding a new printer; if the first screen shows up, it should be OK).
SAP DB + Applications If both the DB and applications startup are fine when performed separately, try starting them together with the SAP Service Manager (NT) or startsap (UNIX). For NT, the startsap script can be found in usr/sap/SID/SYS/exe/run/strdbs.cmd


Troubleshooting other applications:

Application How to Check It Tips
SQL*Plus Make sure that
  1. the services OracleServiceSID and OracleTNSListener are started
  2. the database is started and opened
  3. the command tnsping <SID> returns OK (see above for tips on troubleshooting the listener)
First try running the SQL*Plus client from the server (Start >> Oracle for Windows NT >> SQL_Plus 3.x), Enter system/manager for username/password and <SID> for host string.
     

Sample Oracle Network Configuration Files for SAP 

These are sample files for configuring the Oracle network services. The three files involved are listenter.ora, tnsnames.ora, and sqlnet.ora. These files can be generated using the NETV8.EXE utility (included on the SAP 4.0B upgrade CD). The utility can generate files for different Oracle versions, including 7.2, 7.3, and 8.0.

These are sample files for an SAP server called "sap2" with a system ID of "D01". Note that network files for Oracle 7 are located in the folder <OracleHome>/Network/Admin; those for Oracle 8 are located in the folder <OracleHome>/Net80/Admin. 


 Sample Oracle Network LISTENER.ORA Files 
 ################
# Filename......: listener.ora (for Oracle 8)
# Node..........: local.world
# Date..........:
################
LISTENER =
        (ADDRESS =
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = sap2)
          (Port = 1527)
        )
        (ADDRESS=
          (COMMUNITY= TCP.world)
          (Host = sap2)
          (PROTOCOL= TCP)
          (Port= 1521)
        )
        (ADDRESS=
          (COMMUNITY= TCP.world)
          (Host = sap2)
          (PROTOCOL= TCP)
          (Port= 1526)
        )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SDU = 4096)
      (SID_NAME = D01)
      (ORACLE_HOME = C:\ORANT)
      (PRESPAWN_MAX = 10)
    )
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )
PASSWORDS_LISTENER = (oracle)


 

 

Sample Oracle Network TNSNAMES.ORA Files

# TNSNAMES.ORA (for Oracle 8)
Tcp-loopback.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
D01.world =
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = sap2)
          (Port = 1521)
        )
        (ADDRESS =
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = sap2)
          (Port = 1526)
        )
    )
    (CONNECT_DATA = (SID = D01)
    )
  )

Sample Oracle Network SQLNET.ORA File (Oracle 7 or 8)

 AUTOMATIC_IPC = ON
 TRACE_LEVEL_CLIENT = OFF
 names.directory_path = (TNSNAMES)
 NAMES.DEFAULT_DOMAIN = world
 NAME.DEFAULT_ZONE = world
 names.default_domain=world 
来源:http://www.geocities.com/SiliconValley/Grid/4858/sap/Basis/startup.htm


分享到:
评论

相关推荐

    TNS-12541: TNS: 无监听程序 TNS-12560

    Luocs说:这是我一个朋友的一个监听器问题解决案例,这是昨天发生的事情,我一直跟朋友一起Troubleshooting,折腾了半天最后是BUG所致。再次汗颜,Windows平台惹不起啊!好,那么下面开始分享我朋友的案例! 环境...

    TNV-101-TCL: Troubleshooting with the Sniffer Pro Network Analyzer

    - **课程名称**:Troubleshooting with the Sniffer Pro Network Analyzer(使用Sniffer Pro网络分析仪进行故障排除) - **课程编号**:TNV-101-TCL - **课程目标**:本课程主要教授如何使用Sniffer Pro网络分析仪来...

    vsphere-esxi-vcenter-server-501-troubleshooting-guide

    《vSphere ESXi vCenter Server 5.0 故障排查指南》 vSphere是VMware公司推出的一款虚拟化管理平台,它集成了ESXi主机和vCenter Server,为企业数据中心提供了一个强大的虚拟化解决方案。本指南针对vSphere 5.0版本...

    TNV-202-TCL: Switched Ethernet Analysis and Troubleshooting

    标题与描述中的“TNV-202-TCL: Switched Ethernet Analysis and Troubleshooting”指的是一门由Network Associates提供的专业课程,旨在教授学员如何分析和解决交换式以太网(Switched Ethernet)网络的问题。...

    vsphere-esxi-vcenter-server-511-troubleshooting-guide

    《vSphere ESXi vCenter Server 5.1 故障排查指南》 vSphere是VMware公司推出的一款虚拟化管理平台,它包含了ESXi(一个轻量级的操作系统,专门用于运行虚拟机)和vCenter Server(一个集中式管理工具)。本指南...

    TNV-313-TCL: Microsoft Windows NT Analysis and Troubleshooting

    根据给定文件的信息,我们可以深入探讨“TNV-313-TCL: Microsoft Windows NT Analysis and Troubleshooting”这一主题,这是一个关于微软Windows NT操作系统网络分析与故障排除的专业课程资料。下面将对其中的关键...

    2010最新版CCNP TSHOOT实验指导书

    Lab 2-1:Introduction to Troubleshooting Lab 3-1:Maintenance and Troubleshooting Tools Lab 4-1:Layer 2 Connectivity and Spanning Tree Lab 4-2:Layer 3 Switching and First-Hop Redundancy Lab 5-1:Layer 3 ...

    http-video-streaming-troubleshooting:一组解决HTTP视频流问题的解决方案

    "http-video-streaming-troubleshooting-master"可能是项目源代码或文档集合,包含有关如何识别和解决上述问题的具体步骤、示例代码、调试工具和其他实用资源。深入研究这些文件可以帮助开发者和运维人员更好地理解...

    Troubleshooting Guide - SAP XI 3.0 SAP NW 70

    ### SAP NetWeaver Process Integration (PI) 3.0 / SAP NetWeaver 7.0 Troubleshooting Guide #### 概述 SAP NetWeaver Process Integration (PI) 3.0 和 SAP NetWeaver 7.0(版本 2004s)是SAP公司推出的一系列...

    vsphere-esxi-vcenter-server-55-troubleshooting-guide

    在IT领域,vSphere是VMware公司推出的一款虚拟化管理平台,它包含了ESXi(一个轻量级的操作系统,用于运行虚拟机)和vCenter Server(一个中央管理系统,用于集中管理和监控ESXi主机和虚拟机)。《vSphere ESXi ...

    ChatGPT for Google-4.3.2.zip

    注意:Brave/Opera用户请在安装后按照以下说明操作:https://github.com/wong2/chat-gpt-google-extension#troubleshooting 这是一个简单的扩展,可以显示来自ChatGPT以及Google和其他搜索引擎的响应 特征: *支持...

    CCNA学习指南第7版英文版,word格式

    - **第五章:可变长度子网掩码(VLSMs)、汇总与故障排除(Variable Length Subnet Masks (VLSMs), Summarization, and Troubleshooting)** - VLSM技术:了解可变长度子网掩码的优势及其在大型网络中的应用。 - ...

    oracle自动存储管理结构图

    - `oracleasm troubleshooting` **2. Device Discovery (设备发现)** - **定义:** 自动发现ASM可以使用的存储设备的过程。 - **工具:** - `/dev/oracleasm` - `/proc/partitions` - `dd` - `od` - `kfod`...

    VMware_vSphere6.0与vCenter6.0安装及配置

    启用后,除 vpxuser 外的任何用户都无法直接对 ESXi 进行操作,必须通过 vCenter Server 进行。 - Configure Management Network:配置管理网络。 - Restart Management Network:重启管理网络。 - Test ...

    817-1658.pdf Oracle Solaris 9 - System Administration Guide: Bas

    8. Troubleshooting and Debugging:故障排除和调试,介绍了故障排除和调试的方法和工具等。 讨论了故障排除和调试的方法(如问题重现、日志分析等)、故障排除和调试的工具(如truss、dtrace等)、故障排除和调试...

    10135A-Configuring, Managing and Troubleshooting Microsoft Exchange2010_Vol1

    综上所述,《10135A-Configuring, Managing and Troubleshooting Microsoft Exchange 2010_Vol1》是一份非常有价值的培训资料,对于希望深入了解Exchange Server 2010配置、管理和故障排除方面的IT专业人士来说,它...

    SAP BPC学习资料(强力推荐与传播)_新版SP03_Microsoft

    ### SAP BPC 7.0 SP03 for the Microsoft Platform: Key Knowledge Points #### Introduction to SAP BPC 7.0 SP03 SAP Business Planning and Consolidation (BPC) is a comprehensive solution that enables ...

    rh-service-mesh-v2-troubleshooting-resources:红帽服务网状故障排除教程资源

    服务网格:故障排除教程资源 服务网格:故障排除教程资源 01-设定 使用本教程开头的讲师提供的参数修改了params.env vi params.env USER_NAMESPACE="userXX_namespace" ...02-部署Jump App微服务 ...

    2013年中国数据库大会-31-利用 XEvent进行高级Troubleshooting

    它提供了一种有效的方式来诊断和解决问题,可以显著减少Troubleshooting所需的时间,并深入揭示SQL Server的内部运作情况。 二、扩展事件的特点 1. 轻量级、高性能:扩展事件相比传统的追踪机制,对系统资源的要求...

Global site tag (gtag.js) - Google Analytics