DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  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 sivakumarnv@yahoo.com

    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.