on 10-30-2009 7:54 AM
Hi;
Our set up is:
CI and DB: AIX & ECC 6.0& Oracle
We are having one 32 bit win application server. Yesterday we have added another 64 bit win applciation server but at the time of starting the same it is giving the following error:
Fri Oct 30 12:46:58 2009
C Oracle Client Version: '10.2.0.4.0'
C application info callback registered
C Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.WE8DEC'
C Logon as OPS$-user to get SAPR3E's password
C Connecting as /@R3E on connection 0 (nls_hdl 0) ... (dbsl 700 220409)
C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch
C 0 WE8DEC 000000000991D050 0000000009925280 00000000099303C8
C Attaching to DB Server R3E (con_hdl=0,svchp=0000000009930288,srvhp=0000000009932698)
C
C Fri Oct 30 12:47:01 2009
C Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0000000009930288, srvhp=0000000009932698, usrhp=0000000013931670)
C
C Fri Oct 30 12:47:02 2009
C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
C ORA-01017: invalid username/password; logon denied
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11239]
C Try to connect with default password
C Connecting as SAPR3E/<pwd>@R3E on connection 0 (nls_hdl 0) ... (dbsl 700 220409)
C Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch
C 0 WE8DEC 000000000991D050 0000000009925280 00000000099303C8
C Starting user session: OCISessionBegin(con_hdl=0, usr=SAPR3E/<pwd>, svchp=0000000009930288, srvhp=0000000009932698, usrhp=0000000013931670)
C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:
C ORA-01017: invalid username/password; logon denied
C *** ERROR => CONNECT failed with sql error '1017'
[dbsloci.c 11239]
B ***LOG BY2=> sql error 1017 performing CON [dbsh#3 @ 1208] [dbsh 1208 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#3 @ 1208] [dbsh 1208 ]
B ***LOG BY2=> sql error 1017 performing CON [dblink#8 @ 433] [dblink 0433 ]
B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#8 @ 433] [dblink 0433 ]
M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1502]
M in_ThErrHandle: 1
M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10621]
M
M Info for wp 0
M
I have check all windown environment variables and SAPR3E user status. All things are OK. Pl guide.
The following environment variables are set:
ComSpec=C:\WINDOWS\system32\cmd.exe
DBMS_TYPE=ORA
DBS_ORA_SCHEMA=SAPR3E
dbs_ora_tnsname=R3E
DIR_LIBRARY=
mmr3dev\sapmnt\R3E\SYS\exe\nuc\NTAMD64
JAVA_HOME=C:\j2sdk1.4.2_16-x64
NLS_LANG=AMERICAN_AMERICA.WE8DEC
ORACLE_SID=R3E
OS=Windows_NT
PROMPT=$P$G
SAPEXE=
mmr3dev\sapmnt\R3E\SYS\exe\nuc\NTAMD64
SAPLOCALHOST=mmkndr3prdas1
SAPSYSTEMNAME=R3E
Kindly suggest.
Regards,
Rahul.
ORA-01017: invalid username/password; logon denie
Check Note - 717677 first.
If ops$ user exists do this:
check the schema user that is locked, you can use the following commands:
sqlplus "/as sysdba"
select username,account_status from dba_users;
in case user is locked then unlock it using the command:
alter user <user_name> account unlock;
P.S. you can excute R3trans -d to get a more exact error.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi;
The said problem has been resolved after changing the SAP service owner to sidadm.
Thanks for your suuport.
Regards,
Rahul.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi;
The user is not locked and r3trans -d giving RC=0.
Regards,
Rahul.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.