on 11-11-2009 11:15 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
on command prompt type r3trans -d and check return code should be 0 if sap is able to connect to database.
Regards,
Nikunj Thaker.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.