TNS:Protocol Adapter Error Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TNS:Protocol Adapter Error

  1. #1
    Join Date
    Nov 2000
    I have oracle 8i on Win NT in home pc.
    I am able to startup the Database thru the NT services.
    But if I do the startup from server manager, at the time of
    giving the command

    connect internal

    i am getting the error TNS:Protocol Adapter Error.

    I have given my sid in the tnsnames.ora and the host
    name is my ip address.
    Is there any default ip address which can be given so that i can do a startup from the server manager or what can be the alternative host name other than the ip address.

  2. #2
    Join Date
    Feb 2001

    Thumbs up

    Hi Swetha,

    Very NEW to ORacle isn't it?

    Ok Follow the steps.

    After creating the database successfully and running the req. scripts u r ready to enter into the db but u r not able to do and this is ur problem....

    goto C prompt set oracle_sid = ABCD

    (ABCD - your db sid)

    type oradim

    It gives help or straightaway type this..

    C:\oradim -new -sid ABCD -intpwd password -pfile filepath(This pfile is optional)

    Run this if there is any error see the help by typing oradim

    then goto svrmgr
    connect internal

    Still u can not solve the problem then mail me and my mail id is

    Siva Kumar N.V
    PeopleSoft Architect

  3. #3
    Join Date
    Jan 2001
    try connecting as internal through sql plus and let us knwo the results.


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