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

Thread: Accessing Oracle Database programatically from a remote machine

  1. 10-18-2007, 12:39 AM #1
    janani.raman
    janani.raman is offline Junior Member
    Join Date
    Oct 2007
    Posts
    6

    Accessing Oracle Database programatically from a remote machine

    How to access Oracle database from a remote machine on the network? i want to get the list of all files related to a database and their file path. can i access the database without Oracle client? i want to do all this programatically.
    Reply With Quote Reply With Quote
  2. 10-18-2007, 02:53 AM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you can use jdbc, odbc
    Reply With Quote Reply With Quote
  3. 10-18-2007, 03:06 AM #3
    janani.raman
    janani.raman is offline Junior Member
    Join Date
    Oct 2007
    Posts
    6
    How do i get all the information using these?
    Reply With Quote Reply With Quote
  4. 10-18-2007, 03:11 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    using the internet
    Reply With Quote Reply With Quote
  5. 10-18-2007, 05:35 AM #5
    janani.raman
    janani.raman is offline Junior Member
    Join Date
    Oct 2007
    Posts
    6
    Does ODBC require any installations of oracle?
    Reply With Quote Reply With Quote
  6. 10-18-2007, 05:42 AM #6
    janani.raman
    janani.raman is offline Junior Member
    Join Date
    Oct 2007
    Posts
    6
    Does ODBC and JDBC provide all the information? i mean i want the following information on the datafile : Log mode, last SCN archived, current no of user sessions, maximum no of user sessions, tablespace status, total space allocatedm free space, space percentage, file path, version of the oracle server. also the folwing information on archive log : Log mode, last SCN archived, current no of user sessions, maximum no of user sessions, oldest online log sequence no, current online log sequence no, archived log destination, archived log format, automatic archive log purge option. further the followinf information on the control files : Log mode, last SCN archived, current no of user sessions, maximum no of user sessions. can ODBC help in these? I want to get all these information remotely. please help me as to how i can get all these details remotely.
    Reply With Quote Reply With Quote
  7. 10-18-2007, 05:50 AM #7
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do you know anything at all about computers?
    Reply With Quote Reply With Quote
  8. 10-23-2007, 04:15 AM #8
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    yes ineed.. create your own application the like of OEM..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  9. 10-23-2007, 05:22 AM #9
    Bore
    Bore is offline Advisor
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Yes, ODBC requires Oracle client. Only JDBS Thin driver can operate without client
    BTW I wander do you have an idea about what scn and log mode means ;-)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width