Skip to Content
0
Apr 30, 2012 at 12:32 PM

unable to start SLM(SOLUTION MANAGER)

61 Views

Hi All,

startsap

Checking SLM Database

------------------------------

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

------------------------------

/usr/sap/SLM/SYS/exe/run/startsap:

/usr/sap/SLM/SCS02/exe/saposcol: not found

Start of saposcol failed

Running /usr/sap/SLM/SYS/exe/run/startdb

Trying to start SLM database ...

Log file: /export/home/slmadm/startdb.log

/usr/sap/SLM/SYS/exe/run/startdb: Terminating

with error code 12

DB startup failed

slmadm> pwd

/export/home/slmadm

slmadm> more startdb.log

------------------------------ Mon Apr 30

13:15:30 BST 2012

LOGFILE FOR STARTING ORACLE

Trying to start SLM database ...

------------------------------ Mon Apr 30

13:15:30 BST 2012

checking required environment variables

ORACLE_HOME is >/oracle/SLM/102_64<

ORACLE_SID is >SLM<

------------------------------ Mon Apr 30

13:15:30 BST 2012

check initora

------------------------------ Mon Apr 30

13:15:30 BST 2012

check initora

------------------------------ Mon Apr 30

13:15:30 BST 2012

checking V2 connect

TNS Ping Utility for Solaris: Version

10.2.0.2.0 - Production on 30-APR-2012 13:15:30

Copyright (c) 1997, 2005, Oracle. All rights

reserved.

Used parameter files:

/usr/sap/SLM/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION =

(ADDRESS_LIST = (ADDRESS = (COMMUNITY =

SAP.WORLD) (PROTOCOL = TCP) (HOST = tsapngn)

(PORT = 1525))) (CONNECT_DATA = (SI

D = SLM) (GLOBAL_NAME = SLM.WORLD)))

OK (0 msec)

tnsping: V2 connect to SLM

------------------------------ Mon Apr 30

13:15:30 BST 2012

Connect to the database to check the database

state:

R3trans: connect check finished with return

code: 12

Database not available

------------------------------ Mon Apr 30

13:15:30 BST 2012

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

------------------------------ Mon Apr 30

13:15:30 BST 2012

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on

Mon Apr 30 13:15:31 2012

Copyright (c) 1982, 2005, Oracle. All Rights

Reserved.

Connected to an idle instance.

ORA-01081: cannot start already-running ORACLE

- shut it down first

Disconnected

------------------------------ Mon Apr 30

13:15:31 BST 2012

Connect to the database to verify, that the

database is now open

R3trans check finished with return code: 12

*** ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/SLM/SYS/exe/run/startdb: Terminating

with error code 12

When gave shutdown for datbase , i got the

below error.

SQL> shutdown

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are permitted

While checking R3trans -d

This is R3trans version 6.14 (release 700 -

03.06.11 - 17:57:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE

--- dbs_ora_tnsname = 'SLM'"

R3trans finished (0012).

While giving the command ps -ef|grep ora_, the database services are running properly

kINDLY Provide me your help in starting the application

Sytem details:

SOLARIS 5.9,oracle10.2,sap kernel 700,unicode

Regards

Ram