ORA -12571:TNS: Packet writer failure
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: ORA -12571:TNS: Packet writer failure

  1. #1
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    ORA -12571:TNS: Packet writer failure

    Hello friends,
    RDBMS Version: 9.2.1.0
    Operating System and Version: Windows 2000Pro
    Error Number (if applicable): TNS 12571
    I am Installing oracle 9i database release2 on windows 2k Professional and i m using preconfigured database it was installing perfectly but as soon as it start DBCA for creating database after 46% installation it is saying ORA-12571 : TNS : Packet writer failure.

    Please suggest what should i do?
    thanks
    Abhishek

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    During the installation , in NET8 CONFIGURATION ASSISTANCE step, it would have asked you for SERVICE NAME, HOST NAME, and once u give this info, it will ask you to connect to DB, the username and password you provided might not be correct.Please try this giving sys username and password and your installtion will work.


    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    S/W install is done, only DB creation has probs.

    Check if Alert.log/install_logs say any thing.

    You usually get this error if you are connected to instance & instance goes down (due many reasons) & then you try to execute some
    query/process or so.

    Check if Pwd file is getting created.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    TNS Packet failure :

    Ya u r right ABHAYSK s/w is installed but problem with DBCA thats why it is unable to create DB .
    Now tell me what are the othe ways to connect to SQL plus ? or do i have to create the database manually.
    Abhi

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Using DBCA, just save the DB creation script.

    run the batch file generated, you will know where is the problem.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    TNS Packet writer failure

    Hi Friends
    still i am facing the same problem, i am trying to create manual database, after connecting to idle instance (sqlplus /nolog) when
    i tried to connect as internal or sys i get the same packet failure error.
    pls advise
    Abhishek

  7. #7
    Join Date
    Nov 2001
    Location
    Bangalore
    Posts
    41
    Abhisek

    Oracle 9i doesnot support svrmgr!

    set Oracle_sid=
    sqlplus /nolog
    connect sys/sys as sysdba -- if this doesnot work then
    connect sys/change_on_install as sysdba
    connect sys/oracle as sysdba < if this too doesnot work then
    connect system/manager
    connected.
    alter user sys identified by xxx;
    connect sys/xxx as sysdba
    then startup nomount pfile='.....'
    create database command...

    if you have any problems do let me know..

    i can send you step by step installation document..

    Sanjay
    san

  8. #8
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    Problem is still same

    Hi friends

    i have already mentioned that i am able to connect to idle instance (usine sqlplus /nolog) but after that i m unable to connect because it gives packet failure error, i have tried all the users suggested by sanjay then it gives
    ora-03113 end of file on communication channel.
    so i am still at the square?
    please advise
    Abhishek

  9. #9
    Join Date
    May 2000
    Location
    Delhi
    Posts
    108

    ORA-12571: is there the problem with WIN2k pro

    Hi ofcourse i did all this things even i tried soln provided by oracle , and i am not using terminal server
    i m using windows 2000 professional.
    is there the problem with WIN2k pro or problem is something else

    Pls advise what should i do?
    Should I change my operating system to NT/Win2K(Server), Or should I wait for oracle assistance.
    because i am in diehard situaion.

    Abhishek

  10. #10
    Join Date
    Nov 2001
    Location
    Bangalore
    Posts
    41
    Can you breif me what all the steps you followed.
    and also try send me a mail on sanjaygk at hotmail.com so that i can send you a step by step installtaion document both on solaris and windows 2000 professional.

    don't worry you can create, i will help you
    san

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width