This discussion is archived
6 Replies Latest reply: May 10, 2012 1:34 AM by 793965 RSS

ORA-01041 while connecting to database

793965 Explorer
Currently Being Moderated
hi gems...

We have changed the system date of the server. We made it backdated by two months.

But after that, we cant connect to the database. Not from sysdba, not from non-sysdba. Evene sqlplus "/as sysdba" is also failing.

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

My database is 11gr1 and windows server.


The last few lines of alert log:

***********************************************************************

Fatal NI connect error 12631, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

VERSION INFORMATION:
     TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Time: 27-APR-2012 12:12:00
Tracing not turned on.
Tns error struct:
ns main err code: 12631

TNS-12631: Username retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Fri Apr 27 12:12:17 2012


***********************************************************************

Fatal NI connect error 12631, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

VERSION INFORMATION:
     TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
     Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Time: 27-APR-2012 12:12:17
Tracing not turned on.
Tns error struct:
ns main err code: 12631

TNS-12631: Username retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0



please help... thanks in advance
  • 1. Re: ORA-01041 while connecting to database
    Think_dba Journeyer
    Currently Being Moderated
    Can you set below in your SQLNET.ora and try again?

    SQLNET.AUTHENTICATION_SERVICES = (NONE)
  • 2. Re: ORA-01041 while connecting to database
    839439 Pro
    Currently Being Moderated
    Hi

    The above error can occur when the DB is down.

    in some case it is reported as bug

    Refer to MOS Note 429252.1

    Workaround is to build a local view for the remote table and use that view in the report.
    check the below link :

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



    --neeraj                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
  • 3. Re: ORA-01041 while connecting to database
    sybrand_b Guru
    Currently Being Moderated
    We have changed the system date of the server. We made it backdated by two months.
    
    But after that, we cant connect to the database. Not from sysdba, not from non-sysdba. Evene sqlplus "/as sysdba" is also failing.
    
    the error is: ORA-01041: internal error. hostdef extension doesn't exist
    And we still can't look up errors in the online documentation at http://tahiti.oracle.com and we require this forum to do this for free.

    Please: stop abusing this forum, ignoring the forums etiquette, and go somewhere else. To a chatroom for instance.

    -------------
    Sybrand Bakker
    Senior Oracle DBA
  • 4. Re: ORA-01041 while connecting to database
    793965 Explorer
    Currently Being Moderated
    thanks vishwanath...I have changed the sqlnet.ora and the problem got resolved.

    @Sybrand: I know that documentation is there and i read that regularly whenevr i get time, but documentation is a huge thing and the company doesnot give that much of time when this type of issue raises in database because entire development and testing get stopped. That why I did some googling and i found in most of them to raise a bug. Thats why i asked it here. I know you all are there to help us, atleast we can discuss the issues with you all as we are newbies and you all are the gems in oracle.

    Thanks a lot for your help vishwanath.
  • 5. Re: ORA-01041 while connecting to database
    sybrand_b Guru
    Currently Being Moderated
    Looking up documentation takes 5 seconds.
    Asking in a forum of volunteers will take much longer.
    Your approach indicates lack of industry and stupidity of your company.

    If you continue to ignore forums etiquette, I will not hesitate to mark your 'contributions' (basically all doc questions) as abuse of this forum, because that is what it is.

    ------------
    Syband Bakker
    Senior Oracle DBA
  • 6. Re: ORA-01041 while connecting to database
    793965 Explorer
    Currently Being Moderated
    Sybrand...i will take care of this from future...thanks...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points