Checklist for troubleshooting SAP server startup:
What to Check | How to Check It | Tips |
---|
Network | - Make sure that your database is mounted and open.
- Use either Control Panel >> Services >> Oracle TNSListener, or the
command lsnrctl (preferable) to start the listener service
- execute tnsping <SID>
- 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: - connect internal
- shutdown
- startup
| - add the immediate or abort options to shutdown
if necessary - divide startup into phases by starting startup nomount,
then continuing with alter database mount and alter database open - 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 - the services OracleServiceSID and OracleTNSListener are started
- the database is started and opened
- 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.
|
|
No comments:
Post a Comment