Oracle database issue after refresh

[former_member532966]

Greetings Team,

I am unable to connect to sap but unable to connect....after system refresh

The trans.log shows connected but i am unable to connect from sapgui...

Here it shows it connected to system PRD instead of QAS after system refresh from PRD

Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'QAS' --- SYSTEM = 'PRD'.

what have to do to change it to QAS

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'QAS' --- SYSTEM = 'PRD'.

sapqas:qasadm 55> cat trans.log
4 ETW000 R3trans version 6.26 (release 753 - 11.04.18 - 20:18:03).
4 ETW000 unicode enabled version
4 ETW000 ===============================================
4 ETW000 date&time : 04.10.2018 - 09:50:31
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000 [ dev trc,00000] Thu Oct 4 09:50:31 2018
4 ETW000 [ dev trc,00000] Loading DB library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' ...
4 ETW000 [ dev trc,00000] Library '/usr/sap/QAS/SYS/exe/run/dboraslib.so' loaded
4 ETW000 [ dev trc,00000] Version of '/usr/sap/QAS/SYS/exe/run/dboraslib.so' is "753.02", patchlevel (0.201)
4 ETW000 [ dev trc,00000] read_con_info_ssfs(): DBSL supports extended connect protocol
4 ETW000 ==> connect info for default DB will be read from ssfs
4 ETW000 [ dev trc,00000] Register application info.
4 ETW000 [ dev trc,00000] Oracle client version: 11.2.0.4.0, V3, default build, (dbsl 753 160318, UNICODE[2], LE)
4 ETW000 [ dev trc,00000] Installed Oracle client patches:
4 ETW000 [ dev trc,00000] # Patch 19852360 : Created on 20 Oct 2014, 08:17:43 hrs PST8PDT
4 ETW000 [ dev trc,00000] # Patch 12985200 : Created on 2 Jul 2014, 09:45:20 hrs PST8PDT
4 ETW000 [ dev trc,00000] # Patch 11742262 : Created on 6 Nov 2013, 15:22:08 hrs CET
4 ETW000 [ dev trc,00000] New environment handle env=4c3aec0 for nls=0, con=0 created
4 ETW000 [ dev trc,00000] Client NLS setting (by OCINlsGetInfo(con=0)): 'AMERICAN_AMERICA.UTF16'
4 ETW000 [ dev trc,00000] local client OS environment: NLS_LANG = 'AMERICAN_AMERICA.UTF8'
4 ETW000 [ dev trc,00000] NLS_NCHAR not set
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@QAS on connection 0 (nls 0) ... (dbsl 753 160318, UNICODE[2], LE)
4 ETW000 [ dev trc,00000] New service svc=4c48a58 in env(con=0)=4c3aec0 created, OCIHandleAlloc()->rc=0
4 ETW000 [ dev trc,00000] New server handle srv=4c4bcf0 created and attached to 'QAS', OCIServerAttach(con=0,svc=4c48a58)
4 ETW000 [ dev trc,00000] OCISessionBegin(con=0, svc=4c48a58, srv=4c4bcf0='QAS'): start session usr=4c7aeb0='SAPSR3', rc=0
4 ETW000 [ dev trc,00000] Now 'SAPSR3/<pwd>@QAS' is connected: con=0, nls=0, session=274, time='2018-10-04 09:50:31'
4 ETW000 [ dev trc,00000] DB instance QAS is running on sapqas with ORACLE version 11.2.0.4.0 since SEP 29, 2018, 15:15:30.
4 ETW000 [ dev trc,00000] con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8
4 ETW000 [ dev trc,00000] 0 UTF16 AL16UTF16 4c3aec0 4c46a38 4c47ab8 4c48b38
4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0)
4 ETW000 [ dev trc,00000] -->DbSlControl(con=0,cmd=43=DBSL_CMD_SAPRELEASE_SET) -> basis rel.='701'=701)
4 ETW000 [ dev trc,00000] NTAB: ddntt_column_check(no_of_columns = 22): DBSQLTIMESTMP not found, COMPCNT found, VERSION found => DDNTT db_structure is 'B'
4 ETW000 [ dev trc,00000] NTAB: unicodelg of executable is 2, SVERS nametab: unicodelg = 2, version = 'B'
4 ETW000 [ dev trc,00000] NTAB: Lock entries before commit is enabled via rsdb/ntab/lock_entries_for_commit profile parameter setting.
4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'QAS' --- SYSTEM = 'PRD'.
4 ETW690 COMMIT "0" "0"
4 ETW000 date&time : 04.10.2018 - 09:50:32
4 ETW000 function : CONNECT
4 ETW000 buffersync : YES
4 ETW724 clients : default
4 ETW000 inline stats : YES
4 ETW000 fastimp-type :
4 ETW000 l.s.m. : VECTOR
4 ETW000 purgedocu : YES
4 ETW000 commit : 100000
4 ETW000 table cache : dynamic
4 ETW000
4 ETW000 [ dev trc,00000] Thu Oct 4 09:50:32 2018
4 ETW000 [ dev trc,00000] Disconnecting from ALL connections:
4 ETW000 [ dev trc,00000] Disconnecting con=0
4 ETW000 [ dev trc,00000] OCISessionEnd(con=0, svc=4c48a58, srv=4c4bcf0='QAS'): Close session usr=4c7aeb0, rc=0
4 ETW000 [ dev trc,00000] OCIServerDetach(stale1 con=0, svc=4c48a58, srv=4c4bcf0='QAS') successfully detached
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0, svc=4c48a58): Server handle srv=4c4bcf0 freed
4 ETW000 [ dev trc,00000] OCIHandleFree(con=0): Service hdl. svc=4c48a58 freed.
4 ETW000 [ dev trc,00000] Disconnected from connection 0
4 ETW000 [ dev trc,00000] statistics db_con_commit (com_total=1, com_tx=1)
4 ETW000 [ dev trc,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0000).
4 ETW000 date&time: 04.10.2018 - 09:50:32

======================================================================
sapqas:qasadm 56>

SQL> select name from v$database;

NAME
---------
QAS

SQL>

Thanks

indranil roy

[Former Member]

Hello,

Please let us know the output of R3trans -d

Regards,

Manjunath

[Leventy]

NLS_NCHAR not set 4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@S0G on connection 0 (nls 0) ... (dbsl 754 200323, UNICODE[2], LE) 4 ETW000 [ dev trc,00000] OCIHandleAlloc(con=0, env=55dd2047d0c0): New service svc=55dd204ae510 created, rc=0 4 ETW000 [ dev trc,00000] OCIServerAttach(con=0, svc=55dd204ae510): New server hdl. srv=55dd204b13b0 attached to 'S0G' 4 ETW000 [ dev trc,00000] OCISessionBegin(con=0, svc=55dd204ae510, srv=55dd204b13b0='S0G'): start session usr=55dd204e5d50='SAPSR3', rc=0 4 ETW000 [ dev trc,00000] Now 'SAPSR3/<pwd>@S0G' is connected: con=0, nls=0, session=975, time='2025-02-21 11:18:51' 4 ETW000 [ dev trc,00000] DB instance S0G is running on sdea-odb-s4201 with ORACLE version 19.23.0.0.0 since FEB 11, 2025, 13:56:59. 4 ETW000 [ dev trc,00000] con=0, V$NLS_PARAMETERS: NLS_LANG=AMERICAN_AMERICA.UTF8, NLS_NCHAR=UTF8 4 ETW000 [ dev trc,00000] con CharacterSet (DB) NCharSet svchp srvhp usrhp nls TNS 4 ETW000 [ dev trc,00000] 0 UTF8 UTF8 55dd204ae510 55dd204b13b0 55dd204e5d50 0 S0G 4 ETW000 [ dev trc,00000] nls CharacterSet (Env) NCharSet envhp errhp er2hp bathp 4 ETW000 [ dev trc,00000] 0 UTF16 AL16UTF16 55dd2047d0c0 55dd204ac500 55dd204ad580 55dd204ae600 4 ETW000 [ dev trc,00000] Connection 0 opened (DBSL handle 0) 4 ETW000 [ dev trc,00000] -->DbSlControl(con=0,cmd=43=DBSL_CMD_SAPRELEASE_SET) -> basis rel.='740'=740) 4 ETW000 [ dev trc,00000] NTAB: ddntt_column_check(no_of_columns = 22): DBSQLTIMESTMP not found, COMPCNT found, VERSION found => DDNTT db_structure is 'B ' 4 ETW000 [ dev trc,00000] NTAB: unicodelg of executable is 2, SVERS nametab: unicodelg = 2, version = 'B' 4 ETW000 [ dev trc,00000] NTAB: Lock entries before commit is enabled via rsdb/ntab/lock_entries_for_commit profile parameter setting. 4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'S0G' --- SYSTEM = 'AEE'.