OraFAQ Forum: Networking and Gateways » Accessing Oracle database from a remote machine programatically

Home » RDBMS Server » Networking and Gateways » Accessing Oracle database from a remote machine programatically

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Accessing Oracle database from a remote machine programatically [message #274964]

Wed, 17 October 2007 23:25

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.

Report message to a moderator

Re: Accessing Oracle database from a remote machine programatically [message #274965 is a reply to message #274964]

Wed, 17 October 2007 23:35

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

By creating Database Link.

Report message to a moderator

Re: Accessing Oracle database from a remote machine programatically [message #274967 is a reply to message #274965]

Wed, 17 October 2007 23:38

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.

Report message to a moderator

Re: Accessing Oracle database from a remote machine programatically [message #274970 is a reply to message #274967]

Wed, 17 October 2007 23:42

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

Report message to a moderator

Re: Accessing Oracle database from a remote machine programatically [message #274971 is a reply to message #274970]

Wed, 17 October 2007 23:48

janani.raman
Messages: 4
Registered: October 2007

Junior Member

I want a program compatible with all the versions.

Report message to a moderator

Re: Accessing Oracle database from a remote machine programatically [message #275225 is a reply to message #274964]

Thu, 18 October 2007 22:33

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.

Report message to a moderator

Re: Accessing Oracle database from a remote machine programatically [message #275228 is a reply to message #275225]

Thu, 18 October 2007 22:44

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.

Report message to a moderator

Re: Accessing Oracle database from a remote machine programatically [message #275231 is a reply to message #274964]

Thu, 18 October 2007 22:49

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.

Report message to a moderator

Re: Accessing Oracle database from a remote machine programatically [message #275441 is a reply to message #275228]

Sat, 20 October 2007 01:46

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

Report message to a moderator

Previous Topic:	RADIUS authentication - ORA-12638
Next Topic:	About Sqlnet.ora

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 15:23:31 CST 2024