Invalid username/password logon

[Former Member]

Hi to all:

I am installing ECC in AIX with RDBMS Oracle 10.2.0.2 in Productive System in HA mode with HAMP. When balancing the services Cluster I have problems starting SAP.

I have executed the R3trans –x and this is the log file:

4 ETW000 R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 16.03.2008 - 00:43:05

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] Sun Mar 16 00:43:05 2008 71 0.000071

4 ETW000 [dev trc ,00000] db_con_init called 28 0.000099

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 46 0.000145

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.o' ...

4 ETW000 66 0.000211

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.o), hdl 0

4 ETW000 13557 0.013768

4 ETW000 [dev trc ,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.o' loaded

4 ETW000 44 0.013812

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.o

4 ETW000 52 0.013864

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PRD/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.107)

4 ETW000 81 0.013945

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.o

4 ETW000 48 0.013993

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.o

4 ETW000 74 0.014067

4 ETW000 [dev trc ,00000] New connection 0 created 31 0.014098

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 56 0.014154

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 47 0.014201

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 45 0.014246

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 52 0.014298

4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/PRD/SYS/exe/run:/oracle/PRD/102_64/lib from environment

4 ETW000 358 0.014656

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 60 0.014716

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 30 0.014746

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 3826 0.018572

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 38 0.018610

4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 48 0.018658

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 52 0.018710

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110f9a780 0x110fb2bf8 0x110fb24a8

4 ETW000 62 0.018772

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 38 0.018810

4 ETW000 [dev trc ,00000] Allocating server context handle 31 0.018841

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x110fb5d98,srvhp=0x110fb5fb8)

4 ETW000 97 0.018938

4 ETW000 [dev trc ,00000] Assigning server context 0x110fb5fb8 to service context 0x110fb5d98

4 ETW000 41433 0.060371

4 ETW000 [dev trc ,00000] Allocating user session handle 89 0.060460

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x110fb5d98,srvhp=0x110fb5fb8,usrhp=0x110fa2560)

4 ETW000 58 0.060518

4 ETW000 [dev trc ,00000] Assigning user session 0x110fa2560 to service context 0x110fb5d98

4 ETW000 11081 0.071599

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE (:A0, :A1); END;

4 ETW000 83 0.071682

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO (:A0); END;

4 ETW000 212 0.071894

4 ETW000 [dev trc ,00000] Now '/@PRD' is connected (con_hdl 0, nls_hdl 0).

4 ETW000 1018 0.072912

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 58 0.072970

4 ETW000 [dev trc ,00000] SELECT USERID, PASSWD FROM SAPUSER WHERE USERID IN (:A0, :A1)

4 ETW000 417 0.073387

4 ETW000 [dev trc ,00000] OCI-call failed with -1=OCI_ERROR 960 0.074347

4 ETW000 [dev trc ,00000] SQL error 942: 'ORA-00942: table or view does not exist'

4 ETW000 48 0.074395

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-942 when accessing table SAPUSER

4 ETW000 53 0.074448

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 942 28 0.074476

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 87 0.074563

4 ETW000 [dev trc ,00000] Rolling back transaction ... 34 0.074597

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x110fb5d98,usrhp=0x110fa2560)

4 ETW000 187 0.074784

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 486 0.075270

4 ETW000 [dev trc ,00000] Try to connect with default password 29 0.075299

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 48 0.075347

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 51 0.075398

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110f9a780 0x110fb2bf8 0x110fb24a8

4 ETW000 63 0.075461

4 ETW000 [dev trc ,00000] Assigning username to user session 0x110fa2560 30 0.075491

4 ETW000 [dev trc ,00000] Assigning password to user session 0x110fa2560 43 0.075534

4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=0x110fb5d98,srvhp=0x110fb5fb8,usrhp=0x110fa2560)

4 ETW000 52 0.075586

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

4 ETW000 22605 0.098191

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '1017'

4 ETW000 48 0.098239

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 1017 29 0.098268

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 1017 performing CON [dblink#3 @ 431]

4 ETW000 141 0.098409

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-01017: invalid username/password; logon denied [dblink#3 @ 431]

4 ETW000 47 0.098456

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"

In node 2 of a Cluster System I have the Test instance. The solution that we proposed is with two instances of RDBMS Oracle (one in Node 1, and other in Node 2) for productive system. In Node 2, we have 2 instances of Oracle in Node 2.

listener.ora:

epsbgst:oraprd 12> cat listener.ora

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = PRD.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = PRD)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = epsbgst)

(PORT = 1537)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PRD)

(ORACLE_HOME = /oracle/PRD/102_64)

)

)

tnsnames.ora:

epsbgst:oraprd 13> cat tnsnames.ora

################

1. Filename......: tnsnames.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

PRD.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = epsbgst)

(PORT = 1537)

)

)

(CONNECT_DATA =

(SID = PRD)

(GLOBAL_NAME = PRD.WORLD)

)

)

sqlnet.ora:

epsbgst:oraprd 15> cat sqlnet.ora

################

1. Filename......: sqlnet.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/SQLNET.ORA#4 $

################

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

1. 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

1. 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

1. 05.01.06 set to default

#TCP.NODELAY=YES

1. 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

How I can see with what user and password the R3trans try to connect to database??

I have read the following notes:

Note 400241

Note 50088

Note 361641

I am trying with this script that I have readed in NOTE 361641 :

sqlplus /NOLOG @?/rdbms/admin/oradbusr.sql SAPPRD UNIX PRD X;

But these throw No Match. I think the problem is that I have not filled the fields with correct values.

If I executed this script:

SELECT OWNER FROM DBA_TABLES WHERE TABLE_NAME = 'T000';

The result is:

SAPSR3

The SAP System ID (SAPSID) = PRD

Database ID (DBSID) = PRD

Thanks you very much in advance!!!

[Former Member]

Hi Guys,

Just one thing else I'd like to add, regarding the issue with SAPUSER table error in case you're running the R3trans -d | -x with ora<SID> (instead of <SID>adm account):

As already stated, the SAPUSER table is owned by OPS$<SID>ADM database user and, besides grant to select on that table to the OPS$ORA<SID> database user, it also requires to be created a public synonym SAPUSER for OP$<SID>ADM.SAPUSER table.

Try that out and it should solve it.

I hope it helps...

Cheers,

-Felipe

[Former Member]

Hi Juan,

Would you please post your solution as i am experiencing the same problem ?

[fidel_vales]

Hi,

as what user have you executed "R3trans -x"?

The problem is not the ORA-01017, you get this one because you are not using the default password and SAP is not able to retrieve that password from the SAPUSER table. The first error you get is:

> 4 ETW000 http://dbsloci. ,00000 *** ERROR => ORA-942 when accessing table SAPUSER

find out who is the owner of this table (select owner from dba_tables where table_name='SAPUSER')

In a unix system that should be the OPS$<SID>ADM (that could change if you have performed a system copy)

your SAPSID is PRD, the answer of the first questions should be "prdadm", the answer to the second shoudl be ops$prdadm. I assume the first one is the key

The issue has nothing to do with os_authent_prefix or "uppercase"

Rgds

[Former Member]

I have executed the R3trans -x with oraprd user.

The answer to your query is:

SQL> select owner from dba_tables where table_name='SAPUSER';

OWNER

-

---

OPS$PRDADM

I have executed the R3trans also with prdadm, this is the result:

epsbgst:prdadm 7> cat trans.log

4 ETW000 R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 16.03.2008 - 15:44:23

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] Sun Mar 16 15:44:23 2008 76 0.000076

4 ETW000 [dev trc ,00000] db_con_init called 28 0.000104

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 49 0.000153

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PRD/SYS/exe/run/dboraslib.o' ...

4 ETW000 69 0.000222

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/PRD/SYS/exe/run/dboraslib.o), hdl 0

4 ETW000 5735 0.005957

4 ETW000 [dev trc ,00000] Library '/usr/sap/PRD/SYS/exe/run/dboraslib.o' loaded

4 ETW000 45 0.006002

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.o

4 ETW000 50 0.006052

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PRD/SYS/exe/run/dboraslib.o' is "700.08", patchlevel (0.107)

4 ETW000 207 0.006259

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.o

4 ETW000 48 0.006307

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/PRD/SYS/exe/run/dboraslib.o

4 ETW000 75 0.006382

4 ETW000 [dev trc ,00000] New connection 0 created 35 0.006417

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 56 0.006473

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 48 0.006521

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 44 0.006565

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 53 0.006618

4 ETW000 [dev trc ,00000] Got LIBPATH=/usr/lib:/lib:/usr/sap/PRD/SYS/exe/run:/oracle/client/10x_64/instantclient from environment

4 ETW000 391 0.007009

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.2.0' 73 0.007082

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 30 0.007112

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 2073 0.009185

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 40 0.009225

4 ETW000 [dev trc ,00000] Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 48 0.009273

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 54 0.009327

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110f990c0 0x110fb1538 0x110fb0de8

4 ETW000 61 0.009388

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 38 0.009426

4 ETW000 [dev trc ,00000] Allocating server context handle 32 0.009458

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x110fb46d8,srvhp=0x110fb48f8)

4 ETW000 86 0.009544

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541

4 ETW000 4950 0.014494

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 49 0.014543

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 29 0.014572

4 ETW000 [dev trc ,00000] Try to connect with default password 86 0.014658

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

4 ETW000 49 0.014707

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 50 0.014757

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x110f990c0 0x110fb1538 0x110fb0de8

4 ETW000 51 0.014808

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x110fb48f8)

4 ETW000 46 0.014854

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x110fb46d8,srvhp=0x110fb48f8)

4 ETW000 46 0.014900

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x110fb48f8 32 0.014932

4 ETW000 [dev trc ,00000] Allocating server context handle 31 0.014963

4 ETW000 [dev trc ,00000] Attaching to DB Server PRD (con_hdl=0,svchp=0x110fb46d8,srvhp=0x110fb48f8)

4 ETW000 53 0.015016

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541

4 ETW000 2022 0.017038

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 47 0.017085

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12541 28 0.017113

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12541 performing CON [dblink#3 @ 431]

4 ETW000 140 0.017253

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#3 @ 431]

4 ETW000 46 0.017299

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"

The listener are running with oraprd user.

Can you help me??

Thanks you very much in advance!!

[Former Member]

I have read the note 662644 and I have executed the query as follow:

epsbgst:oraprd 1> sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Sun Mar 16 16:24:17 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> connect /as sysdba

Connected.

SQL> desc t000;

ERROR:

ORA-04043: object t000 does not exist

SQL> desc sapr3.t000;

ERROR:

ORA-04043: object sapr3.t000 does not exist

Any idea ??

[Former Member]

Hi. I'm think you have problem with tnsnames.ora or sqlnet.ora. Check both files. If you have other server with running SAP on them you can copy this files and adapt from

current SAP server. Read about NAMES.DIRECTORY_PATH

maybe need this.

Also read the Note 609332.

regards.

Edited by: Sergo Beradze on Mar 16, 2008 6:01 PM

[fidel_vales]

>

> I have executed the R3trans -x with oraprd user.
> 

Hi,

That is your first mistake.

oraprd user is configured to administer Oracle, not SAP. R3trans -x has to be executed as prdadm.

All the OPS$ mechanism is to be used by prdadm and you keep using it as oraprd:

>

>I have read the note 662644 and I have executed the query as follow:
>epsbgst:oraprd 1> sqlplus /nolog
>SQL*Plus: Release 10.2.0.2.0 - Production on Sun Mar 16 16:24:17 2008
>Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>SQL> connect /as sysdba
>Connected.
>SQL> desc t000;
>ERROR:
>ORA-04043: object t000 does not exist
>SQL> desc sapr3.t000;
>ERROR:
>ORA-04043: object sapr3.t000 does not exist
> 

lots of ideas

1.-

> epsbgst:oraprd 1> sqlplus /nolog

you are connecting as user ops$oraprd. Unless you have done "something" special, this user is not created by SAP and should not have access to any SAP tables. That is one of the reasons you should not try R3trans -x as this user

2.-

> SQL> connect /as sysdba

Now you connect as SYS user with sysdba authorizations.

> SQL> desc t000;

table t000 belongs to the SAP schema not to the SYS schema. It is a normal error

3.-

>SQL> desc sapr3.t000;

>ERROR:

>ORA-04043: object sapr3.t000 does not exist

clear, your SAP schema is NOT SAPR3. Looking at your data your SAP schema is SAPSR3 (you mistyped the schema name)

4.- I do not think Sergo is correct (at least with the current information) it seems that your listener is not running.

When you execute R3trans -x with the correct OS user you are getting the following error:

> 4 ETW000 http://dboci.c ,00000 *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12541

ORA-12541 is selfexplanatory (at teh end of the trace file you have the description:

>4 ETW000 dblink ,00431 **LOG BY0=>ORA-12541: TNS:no listener* dblink#3 @ 431

I hope it is clear now and i have not forgotten anything (it is a little long answer)

[Former Member]

Hi Fidel. The Juan Carlos Castillo wrote :

"The listener are running with oraprd user"

therefore I have suggested to check up tnsmames and sqlnet files. Regards.

[fidel_vales]

Hi,

sorry, I miss that part (even when it is clearly there)

you are correct, starting point would be note 609332

[Former Member]

The problem has solved.

Thanks you to all.

[Former Member]

And in what there was a problem?

[Former Member]

In Note 620540 - Authentication Troubleshooting Guide I have read this:

ORA-01017: invalid username/password; logon denied

This problem is usually a setup or configuration issue with the Oracleserver.

Possible cause:

1. Problem: os_authent_prefix is set. It is a mandatory requirement that os_authent_prefix not be set to a non-null value when using kerberos authentication. This is set in the init.ora file or the spfile..

Action: Connect to the database as system and run the query:

select value from v$parameter where name = 'os_authent_prefix';

If a value other than null is returned then either edit the init.ora or change the spfile, then restart the instance.

2. Problem: Username is not uppercase. In order for a user to be kerberos authenticated the database username must be explicitly created as uppercase.

Action: Connect to the database as system and run the query :

select username, password from dba_users;

Check that the user is in uppercase, if not then recreate the user. Also check that the password is defined as #EXTERNAL# to ensure it will be externally authenticated.

RESULTS:

SQL> select username, password from dba_users;

USERNAME PASSWORD

-

---

-

---

OPS$ORAPRD EXTERNAL

OPS$SAPSERVICEPRD EXTERNAL

OPS$PRDADM EXTERNAL

SYS 90196F9DA7B4F387

SYSTEM 8C20BDB2A8F546FA

SAPSR3 7FBE1EDA70C931A1

OUTLN 4A3BA55E08595C81

TSMSYS 3DF26A8B17D0F29F

DIP CE4A36B8E06CA59C

DBSNMP E066D214D5421CCC

SQL> select value from v$parameter where name = 'os_authent_prefix';

VALUE

-

---

ops$

In Point 1 SAP says if a value other than null is returned then either edit the init.ora or change the spfile, then restart the instance. What changes do you think that I have do in init.ora or spfile.

THANKS YOU in advance