Modify the contents of sqlnet.ora file using a command line interface

  • Hello,

    I would like to modify the contents of sqlnet.ora file using a command line interface. Does Oracle ship with any such tool?

    I could also write a small program which parses the file and updates it. However i want to avoid it, provided Oracle provides an inbuilt functionality to do the same.

    In short this is what i would like to do:

    Change existing line ' SQLNET.AUTHENTICATION_SERVICES= (NTS)' to 'SQLNET.AUTHENTICATION_SERVICES= (none)'

    Any help would be very much appreciated.

    Regards,

    Kiran Hegde

  • kiran.hegde (8/23/2010)


    I would like to modify the contents of sqlnet.ora file using a command line interface. Does Oracle ship with any such tool?

    I could also write a small program which parses the file and updates it. However i want to avoid it, provided Oracle provides an inbuilt functionality to do the same.

    In short this is what i would like to do:

    Change existing line ' SQLNET.AUTHENTICATION_SERVICES= (NTS)' to 'SQLNET.AUTHENTICATION_SERVICES= (none)'

    Any help would be very much appreciated.

    Oracle does not provides any "editor" - editting a small text file is something host Operating System does.

    If host environment is Unix you can use "vi" while if host environment is Windows you can use notepad.

    Hope this helps.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply