on 08-14-2014 9:49 AM
Hello,
nus650pa:dv8adm 23% more trans.log
4 ETW000 R3trans version 6.05 (release 46D - 12.07.06 - 16:40:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 date&time : 14.08.2014 - 16:58:18
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [developertra,00000] Thu Aug 14 16:58:19 2014 170924 0.170924
4 ETW000 [developertra,00000] db_con_init called 1225 0.172149
4 ETW000 [developertra,00000] create_con (con_name=R/3) 22426 0.194575
4 ETW000 [developertra,00000] Loading DB library '/usr/sap/DV8/SYS/exe/run/dboraslib.so' ...
4 ETW000 136 0.194711
4 ETW000 [developertra,00000] load shared library (/usr/sap/DV8/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 369207 0.563918
4 ETW000 [developertra,00000] Library '/usr/sap/DV8/SYS/exe/run/dboraslib.so' loaded
4 ETW000 174 0.564092
4 ETW000 [developertra,00000] function DbSlExpFuns loaded from library /usr/sap/DV8/SYS/exe/run/dboraslib.so
4 ETW000 694 0.564786
4 ETW000 [developertra,00000] Version of library '/usr/sap/DV8/SYS/exe/run/dboraslib.so' is "46D.00", patchlevel (0.2186)
4 ETW000 15725 0.580511
4 ETW000 [developertra,00000] function dsql_db_init loaded from library /usr/sap/DV8/SYS/exe/run/dboraslib.so
4 ETW000 60 0.580571
4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from library /usr/sap/DV8/SYS/exe/run/dboraslib.so
4 ETW000 121 0.580692
4 ETW000 [developertra,00000] New connection 0 created 96 0.580788
4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 14511 0.595299
4 ETW000 [developertra,00000] find_con found the following connection for reuse:
4 ETW000 53 0.595352
4 ETW000 [developertra,00000] Got ORACLE_HOME=/oracle/DV8/920_64 from environment
4 ETW000 73038 0.668390
4 ETW000 [developertra,00000] -->oci_initialize 589 0.668979
4 ETW000 [developertra,00000] Got ORACLE_SID=DV8 from environment 56 0.669035
4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
4 ETW000 52 0.669087
4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 33 0.669120
4 ETW000 [developertra,00000] Connecting as /@DV8 on connection 0 ... 91 0.669211
4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='DV8') 999 0.670210
4 ETW000 [developertra,00000] Thu Aug 14 16:58:20 2014 245280 0.915490
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1017 263 0.915753
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 858 0.916611
4 ETW000 [developertra,00000] Try to connect with default password 38 0.916649
4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@DV8 on connection 0 ...
4 ETW000 53 0.916702
4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='DV8')
4 ETW000 46 0.916748
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1017 118256 1.035004
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 86 1.035090
4 ETW000 [developertra,00000] Got ORACLE_SID=DV8 from environment 716 1.035806
4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
4 ETW000 55 1.035861
4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3's password 33 1.035894
4 ETW000 [developertra,00000] Connecting as /@DV8 on connection 0 ... 29 1.035923
4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='', dbname='DV8') 28 1.035951
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1017 126719 1.162670
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 165 1.162835
4 ETW000 [developertra,00000] Try to connect with default password 36 1.162871
4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@DV8 on connection 0 ...
4 ETW000 47 1.162918
4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='DV8')
4 ETW000 42 1.162960
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1017 123784 1.286744
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 70 1.286814
4 ETW000 [dblink ,00627] ***LOG BY2=>sql error 1017 performing CON 1140 1.287954
4 ETW000 [dblink ,00627] ***LOG BY0=> 42 1.287996
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'DV8'"
Please help.
Thanks and Regards
Priyanshu Srivastava
Dear
In SQlnet.ora file,SQLNET.AUTHENTICATION_SERVICES = (NTS) .Should this be changed to None?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear
you can try this also
connect / as sysdba
select username,account_status from dba_users;
If any OPS$, SAPSR3*, SYS, SYSTEM users are locked then open it using the below command.
ALTER USER <username> ACCOUNT UNLOCK;
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear
create ops$user
OPS$ users based on sap note 50088 - Creating OPS$ users on Windows NT/Oracle
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear
First to say that the OPS$ user seems to be properly configured as it connects without problems and it is able to read the SAPUSER table to get the password for the SAP user:
> 4 ETW000 dev trc ,00000 Got SAPSR3's password from OPS$-user 506 0.058556
but using this password fails.
Reason: The password for this user has been changed using ORACLE tools.
That is wrong, if you do so then you get this problem.
If you want to change the password for the SAP user then you must use SAP tools (BRCONNECT):
brconnect -u system/<syst_pwd> -f chpass -o sap<sid> -p <new_sap_pwd>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.