on 04-27-2009 2:36 PM
Hi Experts,
My database and listener r up and running . now when i start SAP , it gives me error ,
wmgadm> startsap
Checking WMG Database
-
ABAP Database is not available via R3trans
Starting SAP-Collector Daemon
-
***********************************************************************
This is Saposcol Version COLL 20.95 700 - V3.72 64Bit
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 20931) is already running .....
************************************************************************
saposcol already running
ABAP Database WMG must be started on remote server
And when i did R3trans -d i got 00012 return code .
Trans.log states as below
[dev trc ,00000] Assigning server context 0x1b43728 to service context 0x1b41438
4 ETW000 72078 0.100843
4 ETW000 [dev trc ,00000] Allocating user session handle 51 0.100894
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728,usrhp=0x1b315e8)
4 ETW000 34 0.100928
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
4 ETW000 9125 0.110053
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x1b43728)
4 ETW000 23 0.110076
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728)
4 ETW000 22 0.110098
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1b43728 222 0.110320
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1033'
4 ETW000 41 0.110361
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 14 0.110375
4 ETW000 [dev trc ,00000] Try to connect with default password 54 0.110429
4 ETW000 [dev trc ,00000] Connecting as SAPDAT/<pwd>@WMG on connection 0 (nls_hdl 0) ... (dbsl 700 030508)
4 ETW000 24 0.110453
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 25 0.110478
4 ETW000 [dev trc ,00000] 0 UTF8 1 0x1b29380 0x1b30dd0 0x1b41508
4 ETW000 23 0.110501
4 ETW000 [dev trc ,00000] Allocating server context handle 13 0.110514
4 ETW000 [dev trc ,00000] Attaching to DB Server WMG (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728)
4 ETW000 34 0.110548
4 ETW000 [dev trc ,00000] Assigning server context 0x1b43728 to service context 0x1b41438
4 ETW000 67834 0.178382
4 ETW000 [dev trc ,00000] Assigning username to user session 0x1b315e8 19 0.178401
4 ETW000 [dev trc ,00000] Assigning password to user session 0x1b315e8 45 0.178446
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728,usrhp=0x1b315e8)
4 ETW000 27 0.178473
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033
4 ETW000 7041 0.185514
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=0x1b43728)
4 ETW000 22 0.185536
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x1b41438,srvhp=0x1b43728)
4 ETW000 21 0.185557
4 ETW000 [dev trc ,00000] Deallocating server context handle 0x1b43728 121 0.185678
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1033'
4 ETW000 56 0.185734
4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1033 13 0.185747
4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1033 performing CON [dblink#5 @ 431]
4 ETW000 109 0.185856
4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01033: ORACLE initialization or shutdown in progress [dblink#5 @ 431]
4 ETW000 21 0.185877
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'WMG'"
Please help me out
well,
as everything else fails lets start from the beginning.
Provide the EXACT output of the following commands executed as wmgadm
1) sqlplus / as sysdba
select * from v$instance
2) connect /
3) connect / @WMG
also attach the environment variables of this user. use the "code" tags
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please find the reply here.
SQL> select * from v$instance
2 ;
INSTANCE_NUMBER INSTANCE_NAME
-
-
HOST_NAME
-
VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE
-
-
-
--- -
-
LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
-
-
--- -
-
-
BLO
---
1 WMG
reuxeuuz373
10.2.0.2.0 27-APR-09 OPEN NO 1 STARTED
INSTANCE_NUMBER INSTANCE_NAME
-
-
HOST_NAME
-
VERSION STARTUP_TIME STATUS PAR THREAD# ARCHIVE
-
-
-
--- -
-
LOG_SWITCH_WAIT LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
-
-
--- -
-
-
BLO
---
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
SQL> connect /
Connected.
SQL> connect / @WMG
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Warning: You are no longer connected to ORACLE.
SQL>
Hi,
Very good and nice.
have you realized that you are getting the same error on SQL plus when you do what I asked:
> SQL> connect / @WMG
> ERROR:
> ORA-01033: ORACLE initialization or shutdown in progress
A bequeue (not sure if it is written like this) connection to the DB is working fine (no errors) but a connection using the listener does not work.
That is telling me that your tnsnames probably is not correct and you are trying to connect to the wrong instance.
Review your "network" connection files as the issue seems to be there.
Please, focus on the problem (also to all people that keep posting the same once and again)
orawmg> tail -30 listener.log
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=WMG)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=reuxeuuz373)(PORT=1527)))
Listener completed notification to CRS on stop
28-APR-2009 09:20:26 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=reuxeuuz373)(USER=orawmg))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869824)) * stop * 0
TNSLSNR for Solaris: Version 10.2.0.2.0 - Production on 28-APR-2009 09:20:38
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /oracle/WDG/102_64/network/admin/listener.ora
Log messages written to /oracle/WDG/102_64/network/log/listener.log
Trace information written to /oracle/WDG/102_64/network/trace/listener.trc
Trace level is currently 0
Started with pid=11552
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=WMG.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=WMG)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=reuxeuuz373)(PORT=1527)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
28-APR-2009 09:20:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=reuxeuuz373)(USER=orawmg))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869824)) * status * 0
28-APR-2009 09:20:59 * (CONNECT_DATA=(SID=WMG)(GLOBAL_NAME=WMG.WORLD)(CID=(PROGRAM=R3trans)(HOST=reuxeuuz374)(USER=wmgadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=149.184.192.252)(PORT=34475)) * establish * WMG * 0
28-APR-2009 09:20:59 * (CONNECT_DATA=(SID=WMG)(GLOBAL_NAME=WMG.WORLD)(CID=(PROGRAM=R3trans)(HOST=reuxeuuz374)(USER=wmgadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=149.184.192.252)(PORT=34476)) * establish * WMG * 0
28-APR-2009 09:25:41 * (CONNECT_DATA=(SID=WMG)(GLOBAL_NAME=WMG.WORLD)(CID=(PROGRAM=R3trans)(HOST=reuxeuuz374)(USER=wmgadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=149.184.192.252)(PORT=34477)) * establish * WMG * 0
28-APR-2009 09:25:41 * (CONNECT_DATA=(SID=WMG)(GLOBAL_NAME=WMG.WORLD)(CID=(PROGRAM=R3trans)(HOST=reuxeuuz374)(USER=wmgadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=149.184.192.252)(PORT=34478)) * establish * WMG * 0
WARNING: Subscription for node down event still pending
28-APR-2009 09:27:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=reuxeuuz373)(USER=wmgadm))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869824)) * status * 0
28-APR-2009 09:27:48 * ping * 0
orawmg> pwd
/oracle/WMG/102_64/network/log
When i chekced sqlnet.log , i see below error .
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Solaris: Version 10.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 10.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.2.0 - Production
Time: 28-APR-2009 08:05:07
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=172.28.160.249)(PORT=63822))
any IDea here please
Edited by: Dharmendra Kumar on Apr 28, 2009 10:39 AM
Please find enty of tnsnames.ora
orawmg> pwd
/oracle/WMG/102_64/network/admin
orawmg> ls
listener.1.ora listener.ora.backup sqlnet.1.ora tnsnames.1.ora
listener.2.ora samples sqlnet.2.ora tnsnames.2.ora
listener.ora shrept.lst sqlnet.ora tnsnames.ora
orawmg> cat tnsnames.ora
################
Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $
################
WMG.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = reuxeuuz373)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = WMG)
(GLOBAL_NAME = WMG.WORLD)
)
)
Edited by: Dharmendra Kumar on Apr 28, 2009 10:59 AM
Dharmendra,
Check out Fidel's post here.
Your DB is still in shutdown process. All the processes of oracle will not respond unless it is shutdown.
So you need to perform shutdown immediate or shutdown abort in worst case.
Then perform startup.
Update your results once you are done with this.
Thanks & Regards
Babu
Thnaks to al for ur response and kind help given to me .
I am happy to say issue is fixed now and am progressing further . ..
Yes , it was not issue with database status as many had suggested , i had seen database was running and in open state . even though i shutdown and restarted .
Issue was fixed with modifying listener.log file , setting env for database and changing password for SAPDAT ..
Thanks to all
Cheers
Check the alert log and verify that the database has been shutdown or started up.
To be sure
At sqlplus do a shutdown and then a startup and try R3trans -d
Pravin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The logs say about the error
"CONNECT failed with sql error '1033' "
Refer to Note 655240,it should solve your issue
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
have you already checked that all database environment variables are poiting to the correct listener and tnsname, have you run lsnrctl status? tnsping? using ora(SID) user in case of Unix/Linux or (SID)adm in case of Windows. If when using sqlplus connection the database looks up and running and SAP is not connecting then some variable should be the problem because R3trasn will try to connect using the info that variables point to.
I saw a problem like this in Windows and we needed to reboot the system and then everything worked perfectly after that.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.