Results 1 to 5 of 5

Thread: Connecting as SysDBA

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

    Connecting as SysDBA

    Can't we connect to server as sysdba from a Client machine? If I tried to connect as sysdba it is showing message
    ORA-12203: TNS:unable to connect to destination.


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

    Re: Connecting as SysDBA

    Yes you can connect to server as sysdba from a Client machine. Do you have the required priviliges to do so ?


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

    Re: Connecting as SysDBA

    How to give priveleges to connect from a client machine?


  4. #4
    Junior Member
    Join Date
    Nov 2007
    Answers
    2

    Re: Connecting as SysDBA

    you hav to set up SID username and password.....


  5. #5
    Junior Member
    Join Date
    Nov 2007
    Answers
    22

    Wink Re: Connecting as SysDBA

    ya you can connect the server via client machine only can see the tns names.ora file which is place on the client machine and give a proper host name in it or give a server ip in it so that you can definatly connect as a sysdba no problem to connect

    can you connect to a any schma from the client machine? if you connect then you will also connect as a sysdba also.


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