R3trans -d RC 12 after upgrade to Oracle 11

[Former Member]

Hi!

I have a SLES11 x86_64 (uname -a : Linux myhostname 2.6.27.19-5-default #1 SMP 2009-02-28 04:40:21 +0100 x86_64 x86_64 x86_64 GNU/Linux)

I have just finish to upgrade oracle from 10.2.0.4 to 11.2.0.1

The upgrade process finish with no problem.

Database start and stop with no problem with user oraSID

But when I try to run (as SIDadm) R3trans -x i receive the error:

R3trans -d
This is R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tnsname = 'TRS'"
R3trans finished (0012).

Into the trans.log fiel I have:

4 ETW000  [dbsloci.    ,00000]  *** ERROR => CONNECT failed with sql error '1017'
4 ETW000
 27  0.255119
4 ETW000  [dev trc     ,00000]     set_ocica() -> SQL error code 1017
 14  0.255133
4 ETW000  [dev trc     ,00000]  -->oci_get_errmsg (con_hdl=0, rc=1017)
 15  0.255148
4 ETW000  [dev trc     ,00000]     OCIErrorGet -> SQL error code: 1017
 65  0.255213
4 ETW000  [dev trc     ,00000]     ORA-01017: invalid username/password; logon denied

4 ETW000
 25  0.255238
4 ETW000  [dblink      ,00431]  ***LOG BY2=>sql error 1017   performing CON [dblink#5
 @ 431]
4 ETW000
391  0.255629
4 ETW000  [dblink      ,00431]  ***LOG BY0=>ORA-01017: invalid username/password; log
on denied [dblink#5 @ 431]
4 ETW000
 23  0.255652
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_ora_tn
sname = 'TRS'"

I have applied all SAP notes related to ORA-01017 (OPS$SIDADM) user and recreate it....

I have also upgrade BRtools and oralib...

can someone have an idea on how to solve this ?

THX

[nicola_blasi]

I know this is an old message but i want share with you a problem correlated to ORA 1017 solved with the parameter "remote_os_authent = TRUE".

Before figuring out the solution , i've noted that avoid the OPS$ mechanism using the default password for schema SAPR3(SAPSR3) the system goes up but was full of dump with error ORA  00021 and ORA 1001 etc

In oracle DB we had an ORA 3137 error TTC protocol internal error:[12209].

When we adjusted the OPS$ also the problem solved.

Bye

Nick

[former_member184628]

Hi All,

We were getting this error in windows landscape and the issue was fixed after adding parameter

*.os_authent_prefix='O$'

in the initSID.ora file and later on generating spfile.

I hope this will help others.

Best Regards,

Sharib Tasneem

[Former Member]

Hello:

We had the same problem after upgrade to Oracle 11 on AIX6.1. Even though we had information on hand that it was obsolete, we put entry "remote_os_authent = TRUE" in initSID.ora and R3trans started working correctly again.

Regards,

Robert

[zoltan_sera]

Hi,

I used chdbpass to recreate ops$ user und sapuser table.

This told me to have en entry "remote_os_authent = TRUE" in initSID.ora.

But this parameter was not set.

After setting this parameter was the login to DB possible.

Best Regards

Zoltan

[zoltan_sera]

Hello,

I have the same problem: oracle upgrade from 10.2.0.4 to 11.2.0.1 (on HP-UX IA 64 B.11.31)

R3trans -d -> RC=12

in trans.log:

Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x60000000010ae0f8, srvhp=0x60000000010b1728, usrhp=0x60000000011b4570)

OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR

OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:

ORA-01017: invalid username/password; logon denied

Thank you in advance.

[nirmal_konchada]

Hi,

Your OPS$ user must have got locked.

Please check.

Regards,

Nirmal.K

[Former Member]

I just saw this message...

we have the same problem, after oracle upgrade from from 10.2.0.4 to 11.2.0.2.0 (on linux x86_64 SLES 10)

R3trans -d

stops with

ORA-01017: invalid username/password; logon denied

And, yes we checked note 400241several times....

But we can't find the error/solution.

So I'm interested in this message.... is it solved now? How?

Maybe that can also work for us ....

Thank you very much in advance for your answer.

[Former Member]

Hi,

It might be the problem with OPS$ usr.

Please look into the below possibilities also:

Ref notes : 400241 , 361641

from sqlplus --- sql > select * from dba_role_privs where grantee like 'ops%';

o/p like this :

GRANTEE GRANTED_ROLE ADM DEF

ops$sidadm sapdba no yes

ops$sidadm connect yes yes

ops$sidadm Resource yes yes

with above notes, u can create new ops$ user and can able to change the pwd also.

With Regards

CSK

[Former Member]

Hi !

This is a CI installation.

OPS$SAPSERVICESID user in not here...

I can only startup and stop the DB with ORASID account....

regards

[Former Member]

Well,

You can also use SIDADM to startup and stop DB. Set the proper env variables and try it out.

Let me know.

-Manny

[cris_hansen]

Hi Pierfrancesco,

A direct installation of SAP products with Oracle Version 11.2 is planned in Q3/2010. Until then, you should use Oracle Version 10.2 with a subsequent upgrade to 11.2 to perform an SAP installation. SAP Note 1398634 contain more details about this.

Sorry for not give you a solution.

All the best,

Cristiano

[Former Member]

Yes...

But I have made an upgrade from Oracle 10.2.0.4 to Oracle .11.2

The problem was that after the oracle upgrade, SAP system do not start anymore.

Database seems to have no problem. The problem seems to be in the Listener or in the enviroment.....

But I'm still do not find the solution.

[JPReyes]

This is a CI installation.
OPS$SAPSERVICESID user in not here...

i think you said you are using Linux so thats ok... you should only use OPS$SAPSERVICESID in windows...

Check SAP Note 400241.

Regards

Juan

[Former Member]

oraSID env below:

rom-lab105:oratrs 51> env
USER=oratrs
LOGNAME=oratrs
HOME=/oracle/TRS
PATH=/oracle/TRS/112_64/bin:/usr/sap/TRS/SYS/exe/run:/oracle/TRS/bin:/usr/local/bin:/bin:/usr/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin
MAIL=/var/mail/oratrs
SHELL=/bin/csh
SSH_CLIENT=10.4.40.52 63231 22
SSH_CONNECTION=10.4.40.52 63231 10.4.5.105 22
SSH_TTY=/dev/pts/1
TERM=xterm
HOSTTYPE=x86_64
VENDOR=suse
OSTYPE=linux
MACHTYPE=x86_64-suse-linux
SHLVL=1
PWD=/oracle/TRS
GROUP=dba
HOST=rom-lab105
CSHEDIT=emacs
CPU=x86_64
HOSTNAME=rom-lab105.
INPUTRC=/etc/inputrc
LESS=-M -I
LESSOPEN=lessopen.sh %s
LESSCLOSE=lessclose.sh %s %s
LESS_ADVANCED_PREPROCESSOR=no
LESSKEY=/etc/lesskey.bin
PAGER=less
MORE=-sl
MINICOM=-c on
MANPATH=/usr/share/man:/usr/local/man
INFODIR=/usr/local/info:/usr/share/info:/usr/info
INFOPATH=/usr/local/info:/usr/share/info:/usr/info
XKEYSYMDB=/usr/share/X11/XKeysymDB
XNLSPATH=/usr/share/X11/nls
COLORTERM=1
XCURSOR_THEME=DMZ
QT_HOME_DIR=/usr/share/desktop-data
LANG=en_US.UTF-8
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/TRS/112_64
ORACLE_SID=TRS
ORA_CRS_HOME=/opt/oracle/product/11gR1/crs
ORA_ASM_HOME=/opt/oracle/product/11gR1/asm
FROM_HEADER=
NNTPSERVER=news
WINDOWMANAGER=/usr/bin/gnome
PYTHONSTARTUP=/etc/pythonstart
XDG_DATA_DIRS=/usr/local/share:/usr/share:/etc/opt/kde3/share:/opt/kde3/share:/usr/share/gnome/help
XDG_CONFIG_DIRS=/etc/xdg
G_BROKEN_FILENAMES=1
G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-1,CP1252
ENV=/etc/bash.bashrc
CSHRCREAD=true
LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
LS_OPTIONS=-N --color=tty -T 0
SAPSYSTEMNAME=TRS
DIR_LIBRARY=/usr/sap/TRS/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/TRS/SYS/exe/run:/oracle/TRS/112_64/lib
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=TRS
dbs_ora_schema=SAPSR3
DB_SID=TRS
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/TRS
rom-lab105:oratrs 52>

SIDadm env below:

trsadm 51> env
USER=trsadm
LOGNAME=trsadm
HOME=/home/trsadm
PATH=/oracle/TRS/112_64/bin:/usr/java/j2sdk1.4.2_12/bin:.:/home/trsadm:/usr/sap/TRS/SYS/exe/run:/home/trsadm/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin
MAIL=/var/mail/trsadm
SHELL=/bin/csh
SSH_CLIENT=10.4.40.52 63240 22
SSH_CONNECTION=10.4.40.52 63240 10.4.5.105 22
SSH_TTY=/dev/pts/2
TERM=xterm
HOSTTYPE=x86_64
VENDOR=suse
OSTYPE=linux
MACHTYPE=x86_64-suse-linux
SHLVL=1
PWD=/home/trsadm
GROUP=sapsys
HOST=rom-lab105
CSHEDIT=emacs
CPU=x86_64
HOSTNAME=rom-lab105.
INPUTRC=/etc/inputrc
LESS=-M -I
LESSOPEN=lessopen.sh %s
LESSCLOSE=lessclose.sh %s %s
LESS_ADVANCED_PREPROCESSOR=no
LESSKEY=/etc/lesskey.bin
PAGER=less
MORE=-sl
MINICOM=-c on
MANPATH=/usr/share/man:/usr/local/man
INFODIR=/usr/local/info:/usr/share/info:/usr/info
INFOPATH=/usr/local/info:/usr/share/info:/usr/info
XKEYSYMDB=/usr/share/X11/XKeysymDB
XNLSPATH=/usr/share/X11/nls
COLORTERM=1
XCURSOR_THEME=DMZ
QT_HOME_DIR=/usr/share/desktop-data
LANG=en_US.UTF-8
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/TRS/112_64
ORACLE_SID=TRS
ORA_CRS_HOME=/opt/oracle/product/11gR1/crs
ORA_ASM_HOME=/opt/oracle/product/11gR1/asm
FROM_HEADER=
NNTPSERVER=news
WINDOWMANAGER=/usr/bin/gnome
PYTHONSTARTUP=/etc/pythonstart
XDG_DATA_DIRS=/usr/local/share:/usr/share:/etc/opt/kde3/share:/opt/kde3/share:/usr/share/gnome/help
XDG_CONFIG_DIRS=/etc/xdg
G_BROKEN_FILENAMES=1
G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-1,CP1252
ENV=/etc/bash.bashrc
CSHRCREAD=true
LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
LS_OPTIONS=-N --color=tty -T 0
SAPSYSTEMNAME=TRS
DIR_LIBRARY=/usr/sap/TRS/SYS/exe/run
LD_LIBRARY_PATH=/usr/sap/TRS/SYS/exe/run:/oracle/client/10x_64/instantclient
JAVA_HOME=/usr/java/j2sdk1.4.2_12
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=TRS
dbs_ora_schema=SAPSR3
DB_SID=TRS
TNS_ADMIN=/usr/sap/TRS/SYS/profile/oracle
NLS_LANG=AMERICAN_AMERICA.UTF8
SAPDATA_HOME=/oracle/TRS
rom-lab105:trsadm 52>

Edited by: Pierfrancesco Cocco on Jun 10, 2010 12:42 PM

[Former Member]

I have this problem:

SQL> SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'SAPUSER';

no rows selected

So I have decided to create again OPS$ user with oradbusr.sql

and:

sqlplus /NOLOG @oradbusr.sql SAPSR3 UNIX TRS x

but after this.. I still have "no row selected" on the query above !!

[JPReyes]

SELECT * FROM DBA_SYNONYMS WHERE SYNONYM_NAME = 'SAPUSER';

You don't need that your system is not running on Windows.

Please read the note in detail.

Regards

Juan

[Former Member]

Check the Environment variables, on the App server host and compare these with the working ones.

And try to login to db with sapserviceSID and SIDADM. I guess the password in the db is different than the one which you are trying to connect.

If password is different, rest the sapserviceSID password and sasr1db password and change it under config tool too.

reply here.

Thanks

Manny.