ORA-01041: internal error. hostdef extension doesn't exist

[Former Member]

Dear Experts

We are getting following error

Hi,

If I comment out SQLNET.AUTHENTICATION_SERVICES= (NTS) then it is

giving error(ORA-01031:insufficient privileges) while connecting to

database using 'conn /as sysdba'.

We are getting errors in SM21:

ORA-28000: the account is locked

ORA-28547: connection to server failed, probable Oracle Net

Also, we are contineously getting ST22 dumps - DBIF_REPO_SQL_ERROR

Pls make a note that we have recently done Oracle patch set upgrade

(interim patch).

please find the Check Db we are getting

26.11.2008 07:00:58 Job started

26.11.2008 07:00:58 Step 001 started (program RSDBAJOB, variant &0000000000425, user ID BASIS001)

26.11.2008 07:00:58 Execute logical command BRCONNECT On host milkndeccprd

26.11.2008 07:00:58 Parameters: -u / -jid CHECK20081126070000 -c -f check

26.11.2008 07:01:00 BR0801I BRCONNECT 7.00 (36)

26.11.2008 07:01:00 BR0280I BRCONNECT time stamp: 2008-11-26 07.01.00

26.11.2008 07:01:00 BR0301E SQL error -1041 at location BrInitOraCreate-2, SQL statement:

26.11.2008 07:01:00 'CONNECT / AT PROF_CONN IN SYSOPER MODE'

26.11.2008 07:01:00 ORA-01041: internal error. hostdef extension doesn't exist

26.11.2008 07:01:00 BR0303E Determination of Oracle version failed

26.11.2008 07:01:00 BR0280I BRCONNECT time stamp: 2008-11-26 07.01.00

26.11.2008 07:01:00 BR0301E SQL error -1041 at location db_connect-2,SQL statement:

26.11.2008 07:01:00 'CONNECT /'

26.11.2008 07:01:00 ORA-01041: internal error. hostdef extension doesn't exist

26.11.2008 07:01:00 BR0310E Connect to database instance MI3 failed

26.11.2008 07:01:00

26.11.2008 07:01:00 BR0806I End of BRCONNECT processing: cdzimvpz.log2008-11-26 07.01.00

26.11.2008 07:01:00 BR0280I BRCONNECT time stamp: 2008-11-26 07.01.00

26.11.2008 07:01:00 BR0804I BRCONNECT terminated with errors

26.11.2008 07:01:00 External program terminated with exit code 3

26.11.2008 07:01:00 BRCONNECT returned error status E

Regards

Yogesh

[Former Member]

Hi,

Which OS are you using ? If it is AIX, then check SAP note 328822.

Regards,

Venkata S Pagolu

[carsten_esser]

Konstantinas advice did it in my case. Thank you!

[Former Member]

Hi,

there is no user sysdba. That's a role.

I believe that it's your schema owner who is locked (SAPR3 or SAPSR3).

Unlock it and set the FAILED_LOGIN_ATTEMPTS to unlimited as described at SAP Note 951167.

Regards,

Konstantina

[Former Member]

Hi Yogesh,

Logon with user having same privileges as sysdba.

Execute:

ALTER USER sysdba ACCOUNT UNLOCK;

Regards,

Ganesh

[markus_doehr2]

> If I comment out SQLNET.AUTHENTICATION_SERVICES= (NTS) then it is

> giving error(ORA-01031:insufficient privileges) while connecting to

> database using 'conn /as sysdba'.

any reason why do you did that?

Markus