Unable to start solution manager instance

[Former Member]

Dear Guru's,

We have installed 2 instance in single host, one is sandbox instance and another one is solution manager instance. Earlier both the instance worked fine. Recently we faced some issue in solman. Solman instance was unable to start but sandbox instance was running without any issue.

Error Message while try to start the solman instance.

=====================================================================================================

solccp01:sm1adm 1> startsap

Checking db6 db Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

13:25:26 30.03.2010 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.94 700 - AIX v10.35 5L-64 bit 070123

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 270348) is already running .....

• saposcol already running

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

03/30/2010 13:25:26 0 0 SQL1026N The database manager is

already active

.

SQL1026N The database manager is already active.

=====================================================================================================

SAP : Solution Manager 7.0

OS : AIX 5.3

DB : DB2 9.5

Kindly suggest what could be done to resolve this issue.

regards,

Guna

[RajeevP]

Hi Guna,

This is a BASIS issue. You can invite more comments if you post this in Neweaver Adminstrator section.

At a frist look, this seems to be DB issue for me. could you please check what is the result of R3trans -d? Also check whether the DB is active or not as it is DB2.

Rajeev

[Former Member]

Dear Rajeev,

As you requested, Kindly find the below information

solccp01:sm1adm 1> R3trans -d

This is R3trans version 6.14 (release 700 - 05.03.09 - 08:28:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = DB6 --- DB2DB

DFT = 'SM1'"

R3trans finished (0012).

solccp01:sm1adm 2> startsap

Checking db6 db Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

10:17:42 21.04.2010 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.94 700 - AIX v10.35 5L-64 bit 070123

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 335944) is already running .....

************************************************************************

saposcol already running

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

04/21/2010 10:17:42 0 0 SQL1026N The database manager is already active

.

SQL1026N The database manager is already active.

Activate database failed

R3trans connect failed

DB startup failed

solccp01:sm1adm 3>

Also we have another instance running in the same host. Its running sucessfully without any issue.

regards,

Guna

[RajeevP]

Dear Guna,

As I suspected, the issue is with the DB. As the R3trans -d failed with 0012, you need to concentrate on the DB level. I will recommend an DB2 person or a BASIS expert to have a look at the logs of DB.

As a first step, you may try to start the DB2.

Call db2cmd to enter to the db2 command prompt. Then call 'db2 list active databases' to check your database, if your db is not listed there , try db2start or db2 activate database <dbname>.

Rajeev

[Former Member]

Dear Rajeev,

As per your information, we checked the database level, Kindly check the below output for those commands,

=======================================================================================================

db2 => list active databases

Active Databases

Database name = SM1

Applications connected currently = 0

Database path = /db2/SM1/db2sm1/NODE0000/SQL00001/

db2 => db2start

SQL1026N The database manager is already active.

db2 => activate database SM1

SQL1490W Activate database is successful, however, the database has already

been activated on one or more nodes.

db2 =>

=====================================================================================================

regards,

Guna