on 07-13-2007 5:38 AM
Hi,
I want to grant sysdba privilege to ops$ user. For that i have to set the remote_login_passwordfile parameter in the init<sid.ora file to EXCLUSIVE ryt..But as there is no such parameter in the file, i added up one. But still the parameter value is shown as NONE.
Can anyone please help me...
Regards
Dhanya
That problem is resolved...Now it is with r3trans -d.
Error is:
This is r3trans version 6.13<release 640 - 25.07.06 - 17:34:00>.
2EETW169 no connect possible: "DBMS = ORACLE -dbs_ora_tnsname = 'SM3'"
r3trans finished<0012>.
any idea????
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
am including trans.log here..
4 ETW000 r3trans version 6.13 (release 640 - 25.07.06 - 17:34:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 29.07.2006 - 15:58:59
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] Sat Jul 29 15:59:01 2006 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0.000000
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0.000000
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 6862 0.006862
4 ETW000 [dev trc ,00000] using "E:\usr\sap\SM3\SYS\exe\run\dboraslib.dll"
4 ETW000 27 0.006889
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 14 0.006903
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 21 0.006924
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.142)
4 ETW000 133 0.007057
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 21 0.007078
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 33 0.007111
4 ETW000 [dev trc ,00000] New connection 0 created 21 0.007132
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 26 0.007158
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 20 0.007178
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 18 0.007196
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 22 0.007218
4 ETW000 [dev trc ,00000] Setting DIR_CLIENT_ORAHOME is not set as environment variable,
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 193 0.007411
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 132 0.007543
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment
4 ETW000 23 0.007566
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 19404 0.026970
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSOL's password 25 0.026995
4 ETW000 [dev trc ,00000] Connecting as /@SM3 on connection 0 (nls_hdl 0) ... (dbsl 640 110706)
4 ETW000 25 0.027020
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 23 0.027043
4 ETW000 [dev trc ,00000] 0 WE8DEC 1 026DEC20 026E3C88 026E36F0
4 ETW000 132 0.027175
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 26 0.027201
4 ETW000 [dev trc ,00000] Allocating server context handle 17 0.027218
4 ETW000 [dev trc ,00000] Attaching to DB Server SM3 (con_hdl=0,svchp=026E3644,svrhp=0037BB3C)
4 ETW000 46 0.027264
4 ETW000 [dev trc ,00000] Assigning server context 0037BB3C to service context 026E3644
4 ETW000 25410 0.052674
4 ETW000 [dev trc ,00000] Allocating user session handle 44 0.052718
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=026E3644,srvhp=0037BB3C,usrhp=026E90F0)
4 ETW000 32 0.052750
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000 4076 0.056826
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 24 0.056850
4 ETW000 [dev trc ,00000] Try to connect with default password 22 0.056872
4 ETW000 [dev trc ,00000] Connecting as SAPSOL/<pwd>@SM3 on connection 0 (nls_hdl 0) ... (dbsl 640 110706)
4 ETW000 21 0.056893
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 23 0.056916
4 ETW000 [dev trc ,00000] 0 WE8DEC 1 026DEC20 026E3C88 026E36F0
4 ETW000 23 0.056939
4 ETW000 [dev trc ,00000] Assigning username to user session 026E90F0 14 0.056953
4 ETW000 [dev trc ,00000] Assigning password to user session 026E90F0 19 0.056972
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=026E3644,srvhp=0037BB3C,usrhp=026E90F0)
4 ETW000 24 0.056996
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000 3499 0.060495
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 25 0.060520
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#2 @ 419]
4 ETW000 63 0.060583
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#2 @ 419]
4 ETW000 32 0.060615
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SM3'"
any clue..???
Hello,
The OPS$ user is not properly configured:
<quote>
<i>4 ETW000 [dev trc ,00000] Connecting as <b>/@SM3</b> on connection 0 (nls_hdl 0) ... (dbsl 640 110706)
[...]
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = <b>1017</b></i>
</quote>
And you have changed the default password for the user SAPSOL
<quote><i>
4 ETW000 [dev trc ,00000] Try to connect with <b>default password</b> 22 0.056872
4 ETW000 [dev trc ,00000] Connecting as <b>SAPSOL/<pwd>@SM3</b> on connection 0 (nls_hdl 0) ... (dbsl 640 110706)
[...]
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = <b>1017</b>
4 ETW000 3499 0.060495
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error <b>'1017'</b>
4 ETW000 25 0.060520
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#2 @ 419]
4 ETW000 63 0.060583
4 ETW000 [dblink ,00419] ***LOG BY0=><b>ORA-01017: invalid username/password; logon denied</b> [dblink#2 @ 419]
</i><quote>
1) take a look at the note
50088 Creating OPS$ users on Windows NT/Oracle
2) Change the password for SAPSOL using SAP tools:
brconnect -u system/<syst_pwd> -f chpass -o sap<SAPSOL -p <new_sap_pwd>
If you do BOTH this issue will be solved.
o/p of trans.log
4 ETW000 r3trans version 6.13 (release 640 - 25.07.06 - 17:34:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 01.08.2006 - 13:53:20
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] Tue Aug 01 13:53:22 2006 0.000000
4 ETW000 [dev trc ,00000] db_con_init called 0.000000
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0.000000
4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0.000000
4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 6892 0.006892
4 ETW000 [dev trc ,00000] using "E:\usr\sap\SM3\SYS\exe\run\dboraslib.dll"
4 ETW000 27 0.006919
4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 13 0.006932
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll
4 ETW000 19 0.006951
4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "640.00", patchlevel (0.142)
4 ETW000 131 0.007082
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll
4 ETW000 19 0.007101
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll
4 ETW000 32 0.007133
4 ETW000 [dev trc ,00000] New connection 0 created 21 0.007154
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 26 0.007180
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 17 0.007197
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 18 0.007215
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 21 0.007236
4 ETW000 [dev trc ,00000] Setting DIR_CLIENT_ORAHOME is not set as environment variable,
4 ETW000 assuming using instant client with unspecified location.
4 ETW000 192 0.007428
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 131 0.007559
4 ETW000 [dev trc ,00000] got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment
4 ETW000 22 0.007581
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 18591 0.026172
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSOL's password 24 0.026196
4 ETW000 [dev trc ,00000] Connecting as /@SM3 on connection 0 (nls_hdl 0) ... (dbsl 640 110706)
4 ETW000 26 0.026222
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 22 0.026244
4 ETW000 [dev trc ,00000] 0 WE8DEC 1 026DEC20 026E3C88 026E36F0
4 ETW000 89 0.026333
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 26 0.026359
4 ETW000 [dev trc ,00000] Allocating server context handle 17 0.026376
4 ETW000 [dev trc ,00000] Attaching to DB Server SM3 (con_hdl=0,svchp=026E3644,svrhp=0037BCFC)
4 ETW000 46 0.026422
4 ETW000 [dev trc ,00000] Assigning server context 0037BCFC to service context 026E3644
4 ETW000 24761 0.051183
4 ETW000 [dev trc ,00000] Allocating user session handle 41 0.051224
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=026E3644,srvhp=0037BCFC,usrhp=026E90F0)
4 ETW000 32 0.051256
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000 4053 0.055309
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 25 0.055334
4 ETW000 [dev trc ,00000] Try to connect with default password 20 0.055354
4 ETW000 [dev trc ,00000] Connecting as SAPSOL/<pwd>@SM3 on connection 0 (nls_hdl 0) ... (dbsl 640 110706)
4 ETW000 21 0.055375
4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch
4 ETW000 20 0.055395
4 ETW000 [dev trc ,00000] 0 WE8DEC 1 026DEC20 026E3C88 026E36F0
4 ETW000 20 0.055415
4 ETW000 [dev trc ,00000] Assigning username to user session 026E90F0 14 0.055429
4 ETW000 [dev trc ,00000] Assigning password to user session 026E90F0 20 0.055449
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=026E3644,srvhp=0037BCFC,usrhp=026E90F0)
4 ETW000 24 0.055473
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1017
4 ETW000 3579 0.059052
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'
4 ETW000 23 0.059075
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 1017 performing CON [dblink#2 @ 419]
4 ETW000 53 0.059128
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#2 @ 419]
4 ETW000 19 0.059147
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'SM3'"
and the query returned:
USERNAME
-
DBSNMP
OPS$SOLADM
OPS$SOLMAN\SAPSERVI
OPS$SOLMAN\SOLADM
OUTLN
SAPSOL
SYS
SYSTEM
8 rows selected.
this is a local installation...
Good,
I can see several inconsistencies.
1) the OPS$ users are:
USERNAME
-
DBSNMP
<b>OPS$SOLADM
OPS$SOLMAN\SAPSERVI
OPS$SOLMAN\SOLADM</b>
OUTLN
SAPSOL
SYS
SYSTEM
But you are telling me that you are trying to connect with user
USERNAME: <b>SM3ADM</b>
There is no OPS$ create for this user.
and the local installation is on the server
USERDOMAIN: <b>BALDE-6</b>
but the "domain" for the user created is different:
USERNAME
-
DBSNMP
OPS$SOLADM
OPS$<b>SOLMAN</b>\SAPSERVI
OPS$SOLMAN\SOLADM
OUTLN
SAPSOL
SYS
SYSTEM
The ops$ users are NOT properly created.
I have to point again to the note 50088.
There you have a script called "ORADBUSR.TXT" , "oradbusr10.zip" if you are using 10g.
the instructions to execute are on the script:
<i>NT: sqlplus /nolog @oradbusr.sql <b>SCHEMAOWNER</b> NT <b>COMPUTER</b>|DOMAIN SAP_SID </i>
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.