dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: remote connectivity

  1. #1
    Join Date
    May 2002
    Posts
    193
    Dear sir,

    I would like to know the procedure that I will have to follow if I need to connect to a database in a different place. I would like to know what sort of net connectivity I should be having and how I should connect to the database over there.

    If the complete procedure is available in any particulr website, do let me know about the URL..


    Thanks and Regards,


    K.Diwakar

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    What do you want?

    1. Connect directly by a client
    2. Connect through a db link from another database
    3. Are there firewall between the 2 machines (I think yes but you don't tell us many things in your previous post)

    cheers

    Angel

  3. #3
    Join Date
    May 2002
    Posts
    193
    Originally posted by aarroyob
    What do you want?

    1. Connect directly by a client
    2. Connect through a db link from another database
    3. Are there firewall between the 2 machines (I think yes but you don't tell us many things in your previous post)

    cheers

    Angel

    Sir
    excuse me if I had not responded properly...

    Right now Iam in a place say X and my database is in a place say Y. I need to log in as a DBA to monitor the database there. I need to know as to the procedure involved in the process of connecting to the database in the place Y. I have only worked in a LAN type of network in my office and all this is new to me. Hence I need more info on this. And right now we do not have any firewall.

    Regards,


    K.Diwakar


    K.Diwakar

  4. #4
    Join Date
    Jun 2001
    Posts
    316
    add this in ur tnsnames.ora...network/admin

    ORANAME=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = remote addr)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = ORASID)
    )
    )

    then connect as username@ORANAME/password

    HTH!!

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Then configure your tnsnames as helpe said. But if you want to perform all the administrative task in this database:

    Change the value for the REMOTE_LOGIN_PASSWORDFILE to shared in the init.ora file. This will allow you to connect to this database only with sys and internal remotely.

    Shutdown the database ( at this moment you can't so somebody will do for you)

    Restart the database to take the new modifications in the parameters file.

    Cheers

    Angel

  6. #6
    Join Date
    May 2002
    Posts
    193
    Originally posted by helpme
    add this in ur tnsnames.ora...network/admin

    ORANAME=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = remote addr)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = ORASID)
    )
    )

    then connect as username@ORANAME/password

    HTH!!

    Ok...Thanks a lot...

    Regards,


    K.Diwakar

  7. #7
    Join Date
    May 2002
    Posts
    193
    Originally posted by aarroyob
    Then configure your tnsnames as helpe said. But if you want to perform all the administrative task in this database:

    Change the value for the REMOTE_LOGIN_PASSWORDFILE to shared in the init.ora file. This will allow you to connect to this database only with sys and internal remotely.

    Shutdown the database ( at this moment you can't so somebody will do for you)

    Restart the database to take the new modifications in the parameters file.

    Cheers

    Angel

    Dear Sir,

    when you say that I will have to set the parameter REMOTE_LOGIN_PASSWORDFILE to shared mode.., I need to know if you mean this parameter in the target d/b at the remote location (placeY) or on tha database in my place(x) ??

    Could you please clarify again,

    Regards,

    K.Diwakar

  8. #8
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Of course in the remote database.

    Cheers

    Angel


  9. #9
    Join Date
    May 2002
    Posts
    193
    Originally posted by aarroyob
    Of course in the remote database.

    Cheers

    Angel




    Thx a lot....



    K.Diwakar

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