error ORA-12640

[Former Member]

While I was instaling java-addin - database instance, system didn't start.

In logs I've got following information.

Thu Sep 13 13:58:50 2007

C *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12640

[dboci.c 4313]

C *** ERROR => CONNECT failed with sql error '12640'

[dbsloci.c 11044]

C Try to connect with default password

C Connecting as SAPBSD/<pwd>@BSD on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 0000000011862CC0 000000000815FEB0 0000000008A9A888

C Detaching from DB Server (con_hdl=0,svchp=0000000008A9A748,srvhp=0000000011881D18)

C Attaching to DB Server BSD (con_hdl=0,svchp=0000000008A9A748,srvhp=0000000011881D18)

C

C Thu Sep 13 13:58:54 2007

C *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12640

[dboci.c 4313]

C *** ERROR => CONNECT failed with sql error '12640'

[dbsloci.c 11044]

B ***LOG BY2=> sql error 12640 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> ORA-12640: Authentication adapter initialization failed [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 12640 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-12640: Authentication adapter initialization failed [dblink#3 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1426]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10283]

M

Does anybody have same problem?

Regards

Damian

[Former Member]

I tried everything, now SAP is involved

[Former Member]

chance is always

[Former Member]

How can I create SAPUSER table cause I've lost it?

[Former Member]

Read note

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Any chance for any points??

Regards

Andreas

[Former Member]

I wrote password:sap and system started but this doesn't solve a problem

[Former Member]

Use brtools to change the password of user sapr3 to something different than SAP. It looks like that for some reason, the password stored in the sapuser table and the passowrd of user sapr3 do not match

Make sure that you do not change the password of user sapr3 using sql commands from sqlplus. Always change it from brtools

Regards

Andreas

[Former Member]

I've recreated user "OPS$DOMAIN\SIDADM" but nothing change still I've got ORA-1037

Does anybody know default password of SAP<SID> user??

[former_member204746]

there are no default password, you choose the password upon installation.

[Former Member]

you should change the password for the SAP Database user with BR*Tools.

e.g. like that

brconnect -u system/pw -f chpass -o sap<SID> -p <new password)

Best regards

[Former Member]

Which OPS$ Users do you have?

select username from dba_users where username like '%OPS%'

You can create SAPUSER Table according to the SAP Note (as the others have already mentioned it):

400241 - Problems with ops$ or sapr3 connect to Oracle

[Former Member]

Now I can connect :

sqlplus /nolog

connect SAP<SID>/password

But SAP cannot start cause he can't login with user sidadm to read password for SAP<SID>

[Former Member]

user is belonging to group ORA_DBA,ORA_BSD_DBA,ORA_OPER_DBA and to global and local administrators, it is user sidadm

[Former Member]

now I can't connect to DB

connect /as sysdba

ORA-01031: insufficient privileges

[Former Member]

How are you trying to connect, with orasid or sidadm? To connect / as sysdba, the OS user should belong to the dba group

[former_member204746]

make sure that service OracleService[SID] is up. also check if OracleTNSLIstener[SID] is up. this is why you get the insufficient privileges mesasge

[Former Member]

It doesn't work I've got following

• ERROR => OCI-call 'OCISessionBegin' failed with rc=1017

[dboci.c 4532]

C *** ERROR => CONNECT failed with sql error '1017'

[dbsloci.c 11044]

B ***LOG BY2=> sql error 1017 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 1017 performing CON [dblink#3 @ 431] [dblink 0431 ]

B ***LOG BY0=> ORA-01017: invalid username/password; logon denied [dblink#3 @ 431] [dblink 0431 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1426]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c

users are unblock

1. SQLNET.ORA Network Configuration File: D:\oracle\BSP\920\NETWORK\ADMIN\sqlnet.ora

2. Generated by Oracle configuration tools.

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES)

#tcp.nodelay = yes

tcp.nodelay = true

[Former Member]

That is another error now, the previous error looks like it is solved.

Check whether creating the OPS$ mechanism according to Note 50088 solves your problem

Another useful note is Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Regards

Andreas

[Former Member]

SIDadm is in local administrators group and Domain administrators group

[Former Member]

ok, please try the following then

On database server find file:

{$ORACLE_HOME}\NETWORK\ADMIN\sqlnet.ora

and set :

SQLNET.AUTHENTICATION_SERVICES= (NONE)

Then restart the listener process and see if it works

Regards

Andreas

[Former Member]

users are domain users

[Former Member]

Try adding your OS sidadm user to the administrator's group

[Former Member]

users SIDadm and SAPServiceSID are unblock, and they are unblock in oracle dba_users.

System ORacle 10g Solution MAnager 4.0.. After upgrade to SM4.0 system was running but during installation java database instance system crashed