Results 1 to 7 of 7

Thread: Kill a session from client machine

  1. #1
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Kill a session from client machine

    I granted sysdba privilege to a user. In toad , Using that username from a client machine, I killed two sessions .
    But in SQL *PLUS, using the same username, If I try to connect as sysdba from a client machine it is showing message
    ORA-12203: TNS:unable to connect to destination
    What might be the problem?

    Last edited by krishnaindia2007; 01-21-2008 at 04:38 AM.

  2. #2
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Kill a session from client machine

    set the init.ora parameter REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE.


  3. #3
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Kill a session from client machine

    Already it was set to EXCLUSIVE.


  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Kill a session from client machine

    Then try to grant the previliges again in sql*plus and execute the commands.


  5. #5
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Kill a session from client machine

    Quote Originally Posted by krishnaindia2007 View Post
    Already it was set to EXCLUSIVE.
    set sqlnet.authentication_services=(NTS) In sqlnet.ora
    and u check ur client machine included in ora_dba


  6. #6
    Junior Member
    Join Date
    Feb 2008
    Answers
    28

    Re: Kill a session from client machine

    hi all

    some one asked questions, and some others giving solutions. but final result ( problem rectified or not ) is not here. If any one could solved the problem please post that here...then new comers get chance to know what happened( rectified or not).


    Jaya



  7. #7
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Kill a session from client machine

    Quote Originally Posted by jaya_geek View Post
    hi all

    some one asked questions, and some others giving solutions. but final result ( problem rectified or not ) is not here. If any one could solved the problem please post that here...then new comers get chance to know what happened( rectified or not).


    Jaya
    To connect sys/xxx as sysdba in client system, u need to follow below steps

    1.in init.ora REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE
    2.Client machine name should be included in ora_dba group (In server system)
    3.set sqlnet.authentication_services=(NTS) In sqlnet.ora (in both server and client system)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact