Archived discussions are read-only. Learn more about SAP Q&A

Oracle 11g issue after Unicode Conversion

Hi all,

Over this weekend I have done a Unicode conversion on our QA system. We have a CI server and a DB server.

Following the steps for the Target System Installation (once the export completed successfully) I installed the Global Preparation on the DB server, and then did the Database Installation, all went well.

The issue is that I have now installed the Central Instance (on the separate server) and it reaches a point in the installation where it needs to check that the database is running on the DB server (which is up) and then start up the SAP instance.

But I get an error, and if I run a R3trans -x I get a RC=12 and the following output from the trans.log.

Any assistance would be appreciated.

Brad

zamdv20187:vrqadm 30> cat /tmp/sapinst_instdir/ERPEhP4/LM/COPY/ORA/SYSTEM/DISTRIBUTED/AS-ABAP/CI/start_VRQ_DVEBMGS04.log

Database VRQ must be started on remote server

Log on to remote server and start database

zamdv20187:vrqadm 31> R3trans -x

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

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

R3trans finished (0012).

zamdv20187:vrqadm 32> cat trans.log

4 ETW000 R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 08.05.2011 - 16:03:35

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -x

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

4 ETW000 [dev trc ,00000] Sun May 8 16:03:35 2011 147 0.000147

4 ETW000 [dev trc ,00000] db_con_init called 34 0.000181

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 52 0.000233

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/VRQ/SYS/exe/run/dboraslib.so' ...

4 ETW000 32 0.000265

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

4 ETW000 15466 0.015731

4 ETW000 [dev trc ,00000] Library '/usr/sap/VRQ/SYS/exe/run/dboraslib.so' loaded

4 ETW000 31 0.015762

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/VRQ/SYS/exe/run/dboraslib.so

4 ETW000 53 0.015815

4 ETW000 [dev trc ,00000] Version of '/usr/sap/VRQ/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.25)

4 ETW000 75 0.015890

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/VRQ/SYS/exe/run/dboraslib.so

4 ETW000 21 0.015911

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/VRQ/SYS/exe/run/dboraslib.so

4 ETW000 66 0.015977

4 ETW000 [dev trc ,00000] New connection 0 created 22 0.015999

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 30 0.016029

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 30 0.016059

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 45 0.016104

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 23 0.016127

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 590 0.016717

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 33 0.016750

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 3220 0.019970

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): 'AMERICAN_AMERICA.UTF8'

4 ETW000 59 0.020029

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPVRQ's password 16 0.020045

4 ETW000 [dev trc ,00000] Connecting as /@VRQ on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

4 ETW000 20 0.020065

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 55 0.020120

4 ETW000 [dev trc ,00000] 0 UTF8 0 0x148e0b70 0x148e85c0 0x148f8cb8

4 ETW000 62 0.020182

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 35 0.020217

4 ETW000 [dev trc ,00000] Allocating server context handle 19 0.020236

4 ETW000 [dev trc ,00000] Attaching to DB Server VRQ (con_hdl=0,svchp=0x148f8be8,srvhp=0x148fbf48)

4 ETW000 56 0.020292

4 ETW000 [dev trc ,00000] Assigning server context 0x148fbf48 to service context 0x148f8be8

4 ETW000 45608 0.065900

4 ETW000 [dev trc ,00000] Allocating user session handle 116 0.066016

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x148f8be8, srvhp=0x148fbf48, usrhp=0x148e8dd8)

4 ETW000 75 0.066091

4 ETW000 [dev trc ,00000] Assigning user session 0x148e8dd8 to service context 0x148f8be8

4 ETW000 22344 0.088435

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=53, stmth_p=0x14904af0)

4 ETW000 189 0.088624

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1); END;

4 ETW000 50 0.088674

4 ETW000 [dev trc ,00000] CbApplInfoGet() failed! Ignore, but uninstall callback to avoid more erroneous calls

4 ETW000 408 0.089082

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=54, stmth_p=0x14905b48)

4 ETW000 41 0.089123

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;

4 ETW000 40 0.089163

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x14905b48)

4 ETW000 2950 0.092113

4 ETW000 [dev trc ,00000] SELECT SID FROM V$MYSTAT WHERE ROWNUM<2

4 ETW000 46 0.092159

4 ETW000 [dev trc ,00000] Connected to session 132. 1445 0.093604

4 ETW000 [dev trc ,00000] Now '/@VRQ' is connected: con_hdl=0, nls_hdl=0, session_id=132.

4 ETW000 73 0.093677

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x14905b48)

4 ETW000 54 0.093731

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 40 0.093771

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x14905b48)

4 ETW000 1303 0.095074

4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 45 0.095119

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-1403 when accessing table SAPUSER

4 ETW000 1519 0.096638

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1403 82 0.096720

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 271 0.096991

4 ETW000 [dev trc ,00000] Rolling back transaction ... 69 0.097060

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x148f8be8,usrhp=0x148e8dd8)

4 ETW000 739 0.097799

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 1796 0.099595

4 ETW000 [dev trc ,00000] Try to connect with default password 32 0.099627

4 ETW000 [dev trc ,00000] Connecting as SAPVRQ/<pwd>@VRQ on connection 0 (nls_hdl 0) ... (dbsl 700 151208)

4 ETW000 44 0.099671

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 77 0.099748

4 ETW000 [dev trc ,00000] 0 UTF8 0 0x148e0b70 0x148e85c0 0x148f8cb8

4 ETW000 43 0.099791

4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0x148e8dd8

4 ETW000 40 0.099831

4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0x148e8dd8

4 ETW000 106 0.099937

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPVRQ/<pwd>, svchp=0x148f8be8, srvhp=0x148fbf48, usrhp=0x148e8dd8)

4 ETW000 78 0.100015

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

4 ETW000 11982 0.111997

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

4 ETW000 52 0.112049

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 28 0.112077

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 431]

4 ETW000 271 0.112348

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]

4 ETW000 66 0.112414

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

zamdv20187:vrqadm 33>

replied

Well on unix like OS, you would only need to change dbs_ora_schema to SAPSR3.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question