cancel
Showing results for 
Search instead for 
Did you mean: 

R3trans -d error

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

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

Former Member
0 Kudos

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>

Former Member
0 Kudos

does the R3trans -d gives the return code 0

Rohit

Former Member
0 Kudos

No Rohit, if its zero then no issue ..

Its giving RC 0012

former_member759680
Contributor
0 Kudos

after starting the DB from sql prompt, does it say database open?

if not try command - alter database open;

if it throws and error about log or datafiles, run this command - alter database check datafiles;

then try alter databse open;

Former Member
0 Kudos

SQL> startup

ORACLE instance started.

Total System Global Area 9714008064 bytes

Fixed Size 2185336 bytes

Variable Size 2378016648 bytes

Database Buffers 7331643392 bytes

Redo Buffers 2162688 bytes

Database mounted.

Database opened.

SQL>

so datadbase is open ..

0 Kudos

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)

Former Member
0 Kudos

Agree with Fidel.

Please post the output of listener log alongwith tnsnames.ora when it is started.

Pravin

Former Member
0 Kudos

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

################

  1. Filename......: tnsnames.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

The logs say about the error

"CONNECT failed with sql error '1033' "

Refer to Note 655240,it should solve your issue

Rohit

Former Member
0 Kudos

i have checked this note all settings are same and correct. also i have restarted DB and listener but no luck

Hoping to hear soon

Thanks

Former Member
0 Kudos

Can you confirm that at sqlplus you can actually login to the database and check the status of the database ??

Pravin

Former Member
0 Kudos

yes.. i can logging in database .. its up & running

Former Member
0 Kudos
ORA-01033: ORACLE initialization or shutdown in progress

Your database seems to be not opened completely. Execute following commands manually and check the output.

> sqlplus / as sysdba

> shutdown immediate

> startup

Former Member
0 Kudos

I checked the status of database and its up and running .

Former Member
0 Kudos

what was the scenario, were you doing or changing something or upgrading the db ?

what is the value of db_cache_size ?

former_member204746
Active Contributor
0 Kudos

LOG BY2=>sql error 1033 performing CON

Means that database is not up.

try this:

sqlplus / as sysdba

shutdown immediate;

startup;

then, start SAP

Former Member
0 Kudos

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.

Former Member
0 Kudos

yes , i have checked lnsrctl status. tnsnames.ora , and env .. still no luck . started DB and Listeners 2 times but no luck ..

But i too feel some where i am missing something but what ?

Thanks