cancel
Showing results for 
Search instead for 
Did you mean: 

Solution Manager is not starting up

Former Member
0 Kudos

Hi All,

I have Solution Manager installed on my Windows 2003 box along with SAP Web AS J2EE engine. I am trying to bring Solution Manager but disp_work.exe process is getting stopped after showing status running for few seconds. I checked the syslog and getting this error there:

Database: Database error 1034 at CON

Whereas i have checked the listener is up and running and Services Window pane is showing my Oracle DB is also up and running. Here imp points to note are that:

1. Oracle_Home is set to DB path of SAP J2EE engine.

2. ORACLE_SID is set to <SAPSID> and not <SOLSID>

Please let me know where exactly the issue is because of which my Sol Manager set up is not working fine.

Accepted Solutions (0)

Answers (8)

Answers (8)

Former Member
0 Kudos

I searched LOG_ARCHIVE_DEST parameter and the location where i could locate it is E:\oracle\SOL\saptrace\background\alert_sol.log file and the value of this parameter is:

log_archive_dest = D:\oracle\SOL\oraarch\SOLarch

Folder SOLarch was not available earlier. I created this folder here but still the result of all these 3 commands remained unchanged

sunny_pahuja2
Active Contributor
0 Kudos

Hi David,

Is this system is MCOD system ?

Could you please execute below command and let us know the result:

select name from v$database;

Thanks

Sunny

Former Member
0 Kudos

I have logged in using soladm user and here ORACLE_SID is set to SOL. This is the output of 3 commands:

OUTPUT:

1. C:\Documents and Settings\soladm>r3trans -d

This is r3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'SOL'"

r3trans finished (0012).

2. C:\Documents and Settings\soladm>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 09:04:09 2009

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

SQL> conn / as sysdba

Connected to an idle instance.

SQL> shutdown

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SQL> startup

ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated

ORA-09291: sksachk: invalid device specified for archive destination

OSD-04018: Unable to access the specified directory or device.

O/S-Error: (OS 3) The system cannot find the path specified.

SQL> exit

Disconnected

3. C:\Documents and Settings\soladm>tnsping SOL

TNS Ping Utility for 64-bit Windows: Version 10.2.0.2.0 - Production on 11-NOV-2

009 09:04:56

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

Used parameter files:

D:\usr\sap\SOL\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 = tombrady12) (PORT = 1528))) (CONNECT_DATA = (SI

D = SOL) (GLOBAL_NAME = SOL.WORLD)))

OK (20 msec)

Former Member
0 Kudos
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated

Check parameter LOG_ARCHIVE_DEST

Former Member
0 Kudos

There are two components installed:

1. Solution Manager:

SID: SOL

2. SAP J2EE Engine:

SID: TR1

And, at preset ORACLE_HOME points to DB corresponding to >SAP J2EE Engine> SID i.e.

C:\OracleTR1\102

Thanks

Former Member
0 Kudos

Hi David,

I think is this case you should have two <sid>adm users.

If you login with soladm then you should be able to see proper environment varialbes set.

Please let us know if you have proper environment variables set for soladm user with SID as SOL.

Cheers...,

Raghu

Former Member
0 Kudos

David,

C:\Documents and Settings\Administrator>r3trans -d

I think you are logging in as Administrator. Try login as user sidadm and then give a go.

Former Member
0 Kudos

Please ignore my previous reply as formattin is absurd there

This is the output of the above mentioned commands:

COMMANDS:

1. Check DB whether it is up and running. Login to SQL plus as "/as sysdba". If it says Idle instance start the DB using the command "startup"

2. Check the Listner is able to connect to the DB. goto command prompt and execute the command "tnsping " If it is not connected, please check the listener.ora file which is located at /oracle//102/database

3. check whether R3trans working fine Excute the "R3trand -d" in the command prompt.

OUTPUT:

1. C:\Documents and Settings\Administrator>r3trans -d

'r3trans' is not recognized as an internal or external command, operable program or batch file.

2. C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 06:43:39 2009 Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

2. C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 06:43:39 2009 Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn / as sysdba

ERROR: ORA-12560: TNS:protocol adapter error

Note: If i set ORACLE_SID value to <SOLSID>, output is:

C:\Documents and Settings\Administrator>set ORACLE_SID=SOL C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 06:50:40 2009 Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn / as sysdba Connected to an idle instance.

SQL> shutdown ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SQL> startup

ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated

ORA-09291: sksachk: invalid device specified for archive destination

OSD-04018: Unable to access the specified directory or device.

O/S-Error: (OS 3) The system cannot find the path specified. SQL>

3. C:\Documents and Settings\Administrator>tnsping

SOL TNS Ping Utility for 64-bit Windows: Version 10.2.0.2.0 - Production on 11-NOV-2 009 06:44:18 Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files: E:\oracle\TR1\102\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP .WORLD) (PROTOCOL = TCP) (HOST = tombrady12) (PORT = 1528))) (CONNECT_DATA = (SI D = SOL) (GLOBAL_NAME = SOL.WORLD))) OK (60 msec)

Please let me know why these commands are not running properly.

Former Member
0 Kudos

This is the output of the above mentioned commands:

COMMANDS:

1. Check DB whether it is up and running.

Login to SQL plus as "/as sysdba".

If it says Idle instance start the DB using the command "startup"

2. Check the Listner is able to connect to the DB.

goto command prompt and execute the command "tnsping <SID>"

If it is not connected, please check the listener.ora file which is located at /oracle/<SID>/102/database

3. check whether R3trans working fine

Excute the "R3trand -d" in the command prompt.

OUTPUT:

1. C:\Documents and Settings\Administrator>r3trans -d

'r3trans' is not recognized as an internal or external command,

operable program or batch file.

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 06:43:39 2009

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

2. C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 06:43:39 2009

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

SQL> conn / as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

Note: If i set ORACLE_SID value to <SOLSID>, output is:

C:\Documents and Settings\Administrator>set ORACLE_SID=SOL

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 06:50:40 2009

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

SQL> conn / as sysdba

Connected to an idle instance.

SQL> shutdown

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

SQL> statrtup

SP2-0042: unknown command "statrtup" - rest of line ignored.

SQL> startup

ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated

ORA-09291: sksachk: invalid device specified for archive destination

OSD-04018: Unable to access the specified directory or device.

O/S-Error: (OS 3) The system cannot find the path specified.

SQL>

3. C:\Documents and Settings\Administrator>tnsping SOL

TNS Ping Utility for 64-bit Windows: Version 10.2.0.2.0 - Production on 11-NOV-2

009 06:44:18

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

Used parameter files:

E:\oracle\TR1\102\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP

.WORLD) (PROTOCOL = TCP) (HOST = tombrady12) (PORT = 1528))) (CONNECT_DATA = (SI

D = SOL) (GLOBAL_NAME = SOL.WORLD)))

OK (60 msec)

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

First of all tell us are you using different SID for SAP and database ?

> OUTPUT:

>

> 1. C:\Documents and Settings\Administrator>r3trans -d

> 'r3trans' is not recognized as an internal or external command,

> operable program or batch file.

>

> C:\Documents and Settings\Administrator>sqlplus /nolog

>

> SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 06:43:39 2009

>

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

>

> 2. C:\Documents and Settings\Administrator>sqlplus /nolog

>

> SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 06:43:39 2009

>

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

>

> SQL> conn / as sysdba

> ERROR:

> ORA-12560: TNS:protocol adapter error

>

>

> Note: If i set ORACLE_SID value to <SOLSID>, output is:

> C:\Documents and Settings\Administrator>set ORACLE_SID=SOL

>

> C:\Documents and Settings\Administrator>sqlplus /nolog

>

> SQL*Plus: Release 10.2.0.2.0 - Production on Wed Nov 11 06:50:40 2009

>

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

>

> SQL> conn / as sysdba

> Connected to an idle instance.

> SQL> shutdown

> ORA-01034: ORACLE not available

> ORA-27101: shared memory realm does not exist

> SQL> statrtup

> SP2-0042: unknown command "statrtup" - rest of line ignored.

> SQL> startup

> ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated

This error is coming because your log_archive_dest parameter is set to previous SID.

First tell us SID of your SAP system and Database system.

Thanks

Sunny

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

Check this [link|;

Thanks

Sunny

Former Member
0 Kudos

Hi,

1. Check DB whether it is up and running.

Login to SQL plus as "/as sysdba".

If it says Idle instance start the DB using the command "startup"

2. Check the Listner is able to connect to the DB.

goto command prompt and execute the command "tnsping <SID>"

If it is not connected, please check the listener.ora file which is located at /oracle/<SID>/102/database

3. check whether R3trans working fine

Excute the "R3trand -d" in the command prompt.

Rgds,

JP.

Former Member
0 Kudos

on command prompt type r3trans -d and check return code should be 0 if sap is able to connect to database.

Regards,

Nikunj Thaker.

Former Member
0 Kudos

Hi,

just because the services are up does not mean the database is up....

logon via sqlplus "/ as sysdba" is it connecting to an idle instance or are you getting connected ?

Mark