Home » RDBMS Server » Networking and Gateways » Accessing Oracle database from a remote machine programatically
Accessing Oracle database from a remote machine programatically [message #274964] Wed, 17 October 2007 23:25 Go to next message
janani.raman
Messages: 4
Registered: October 2007
Junior Member
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.
Re: Accessing Oracle database from a remote machine programatically [message #274965 is a reply to message #274964] Wed, 17 October 2007 23:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

By creating Database Link.
Re: Accessing Oracle database from a remote machine programatically [message #274967 is a reply to message #274965] Wed, 17 October 2007 23:38 Go to previous messageGo to next message
janani.raman
Messages: 4
Registered: October 2007
Junior Member
How can i do that? I m new to oracle. i want to use C# to get all that information. help me out please.
Re: Accessing Oracle database from a remote machine programatically [message #274970 is a reply to message #274967] Wed, 17 October 2007 23:42 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
With which version of the database are you working?

David
Re: Accessing Oracle database from a remote machine programatically [message #274971 is a reply to message #274970] Wed, 17 October 2007 23:48 Go to previous messageGo to next message
janani.raman
Messages: 4
Registered: October 2007
Junior Member
I want a program compatible with all the versions.
Re: Accessing Oracle database from a remote machine programatically [message #275225 is a reply to message #274964] Thu, 18 October 2007 22:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>can i access the database without Oracle client?
Yes, by using ODBC or JDBC interface.
Alternatively, use PERL & DBD/DBI interface.
Re: Accessing Oracle database from a remote machine programatically [message #275228 is a reply to message #275225] Thu, 18 October 2007 22:44 Go to previous messageGo to next message
janani.raman
Messages: 4
Registered: October 2007
Junior Member
Does ODBC or JDBC provide the following information, ie.,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.
Re: Accessing Oracle database from a remote machine programatically [message #275231 is a reply to message #274964] Thu, 18 October 2007 22:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I suggest you inform your boss that you are clueless & this task should be assigned to somebody who at least knows how to spell ODBC, know what ODBC is, & know how to use ODBC.

I wonder if you have ever created a single SQL statement.
Re: Accessing Oracle database from a remote machine programatically [message #275441 is a reply to message #275228] Sat, 20 October 2007 01:46 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Ana and others provide you how to access your database from remote site.
now what ever you want to know about your database it is depand on connected database user privileges.


if you have sufficient privileges to check V$, DBA_ views.

Regards
Mohammed Taj
Previous Topic: RADIUS authentication - ORA-12638
Next Topic: About Sqlnet.ora
Goto Forum:
  


Current Time: Thu Mar 28 13:16:55 CDT 2024