R3trans error

[Former Member]

Hi Guru ,

I encounter when i bring up the SAP

4 ETW000 R3trans version 6.05 (release 46D - 07.09.04 - 10:30:00).

4 ETW000 ===============================================

4 ETW000

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

4 ETW000 date&time : 11.02.2008 - 17:30:36

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [developertra,00000] Mon Feb 11 17:30:36 2008 253 0.000253

4 ETW000 [developertra,00000] db_con_init called 12 0.000265

4 ETW000 [developertra,00000] create_con (con_name=R/3) 62 0.000327

4 ETW000 [developertra,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' ...

4 ETW000 33 0.000360

4 ETW000 [developertra,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 23317 0.023677

4 ETW000 [developertra,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' loaded

4 ETW000 19 0.023696

4 ETW000 [developertra,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/d

oraslib.so

4 ETW000 37 0.023733

4 ETW000 [developertra,00000] Version of library '/usr/sap/PRD/SYS/exe/run/dboraslib.so' is "46D.

0", patchlevel (0.1685)

4 ETW000 152 0.023885

4 ETW000 [developertra,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/

boraslib.so

4 ETW000 24 0.023909

4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run

dboraslib.so

4 ETW000 33 0.023942

4 ETW000 [developertra,00000] New connection 0 created 28 0.023970

4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 57 0.024027

4 ETW000 [developertra,00000] find_con found the following connection for reuse:

4 ETW000 19 0.024046

4 ETW000 [developertra,00000] Got ORACLE_HOME=/oracle/PRD/920_64 from environment

4 ETW000 469 0.024515

4 ETW000 [developertra,00000] -->oci_initialize 26 0.024541

4 ETW000 [developertra,00000] Got ORACLE_SID=PRD from environment 24 0.024565

4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 20 0.024585

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPPRD's password 34 0.024619

4 ETW000 [developertra,00000] Connecting as /@PRD on connection 0 ... 30 0.024649

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='PRD') 14 0.024663

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1019 1471 0.026134

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1019'

4 ETW000 22 0.026156

4 ETW000 [developertra,00000] Try to connect with default password 12 0.026168

4 ETW000 [developertra,00000] Connecting as SAPPRD/<pwd>@PRD on connection 0 ...

4 ETW000 19 0.026187

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPPRD', dbname='PRD')

4 ETW000 18 0.026205

4 ETW000 [developertra,00000] Mon Feb 11 17:30:38 2008 2064919 2.091124

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12705 41 2.091165

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 25 2.091190

4 ETW000 [developertra,00000] Got ORACLE_SID=PRD from environment 125 2.091315

4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

4 ETW000 22 2.091337

4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPPRD's password 19 2.091356

4 ETW000 [developertra,00000] Connecting as /@PRD on connection 0 ... 13 2.091369

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='PRD') 13 2.091382

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12705 52986 2.144368

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 88 2.144456

4 ETW000 [developertra,00000] Try to connect with default password 12 2.144468

4 ETW000 [developertra,00000] Connecting as SAPPRD/<pwd>@PRD on connection 0 ...

4 ETW000 19 2.144487

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPPRD', dbname='PRD')

4 ETW000 18 2.144505

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12705 54072 2.198577

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'

4 ETW000 23 2.198600

4 ETW000 [dblink ,00627] ***LOG BY2=>sql error 12705 performing CON 98 2.198698

4 ETW000 [dblink ,00627] ***LOG BY0=> 14 2.198712

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"

Please assist me... step by step...

i already see note but it cant help me out..please..

Note 403004 - Database connect using R3trans fails

Note 121004 - ORA-1019 for Connect to an Oracle database

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Note 361641 - Creating OPS$ users on UNIX

Note 592657 - ORA-12701/ORA-12705/ORA-12709

Edited by: Mohd Zaki Ahmad Zaini on Feb 11, 2008 7:37 PM

[Former Member · Accepted solution]

HI,

Did you delete the ORA_NSL33 variable? It's still needed to connect to oracle client.

provide env. variable for <SID>adm and ora<SID> user.

also check Note 964783 - Updating Oracle client on host with multiple SAP systems

regards,

kasuahl

[Former Member · Accepted solution]

sorry guru late reply...,

Actually im doing DBMIG.R3S ...

Im not delete the NLS_33 this is the variable in ORAPRD

1. Oracle RDBMS Environment

THREAD=NOPS; export THREAD

if [ $THREAD = NOPS ]; then

DBSID=PRD

else

if [ $THREAD != "001" ]; then

DBSID=PRD_$

else

DBSID=PRD

fi

fi

dbms_type=ORA; export dbms_type

dbs_ora_tnsname=$DBSID; export dbs_ora_tnsname

dbs_ora_schema=SAPPRD; export dbs_ora_schema

ORACLE_PSRV=PRD; export ORACLE_PSRV

ORACLE_SID=$DBSID; export ORACLE_SID

ORACLE_HOME=/oracle/PRD/920_64; export ORACLE_HOME

ORACLE_BASE=/oracle; export ORACLE_BASE

ORA_NLS=/oracle/PRD/920_64/ocommon/NLS_723/admin/data; export ORA_NLS

ORA_NLS32=/oracle/PRD/920_64/ocommon/NLS_733/admin/data; export ORA_NLS32

ORA_NLS33=/oracle/PRD/920_64/ocommon/nls/admin/data; export ORA_NLS33

NLS_LANG=AMERICAN_AMERICA.WE8DEC ; export NLS_LANG

SAPDATA_HOME=/oracle/PRD; export SAPDATA_HOME

DIR_LIBRARY=/usr/sap/PRD/SYS/exe/run; export DIR_LIBRARY

is it because the schema Database change SR3????

please help

[Former Member · Accepted solution]

Hi guru ,

I hits this error when i try to connect using <SID>adm user

ECCPRD:prdadm 22> sqlplus /nolog

SQL*Plus: Release 9.2.0.7.0 - Production on Tue Feb 12 11:09:31 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba

ERROR:

ORA-12705: invalid or unknown NLS parameter value specified

SQL>

[Former Member · Accepted solution]

Hi,

ORA-12705: invalid or unknown NLS parameter value specified

error indicate : You specified an invalid NLS parameter, variable NLS_LANG have wrong value in registry

Either remove the invalid setting from the registry, unset it in the command prompt.

i.e

C:\>set NLS_LANG=

C:\>connect /as sysdba

also check Note 521230 - FAQ: Client software 9i or earlier on UNIX

regards,

kaushal

[Former Member · Accepted solution]

Hi guru...

Still Can't UP the SAP

ECCPRD:prdadm 25> startsap

Starting SAP-Collector Daemon

-

---

13:37:25 12.02.2008 WARNING: Effective userid not root! Expect problems !

Cannot create Shared Memory

Start of saposcol failed

Checking SAP R/3 PRD Database

-

---

Database is not available via /usr/sap/PRD/SYS/exe/run/R3trans -d -w

Starting SAP R/3 PRD Database

-

---

Startup-Log is written to /home/prdadm/startdb.log

Database startup failed!

See /home/prdadm/startdb.log for details

ECCPRD:prdadm 26> sqlplus /nolog

SQL*Plus: Release 9.2.0.7.0 - Production on Tue Feb 12 13:39:30 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba

Connected.

SQL> connect sapprd/sap as sysdba;

Connected.

SQL>

Please assist me and file that required to help me to solve this matter pleaseee GURU!!!! ......

[Former Member · Accepted solution]

Hi,

did you check /home/prdadm/startdb.log

provide it

regards,

kaushal