How to create Oracle database link with sysdba privilege

oracle oracle-apex dblink
CamilleHuot picture CamilleHuot · Nov 22, 2011 · Viewed 11.6k times · Source

I want to:

  select * from v$database@standby;

Problem:

  • standby is mounted so only a SYSDBA user can connect to query it
  • I can't find out how to use a database link using SYSDBA privilege

My goal is to display system information/stats from a standby Oracle database on a web page.

I'm using Oracle APEX. Pages are computed from mod_plsql which runs from an Oracle DB so it is easy to display the result of this kind of query.

Alternative:

  • How to select * from "shell script"?

Answer

DCookie picture DCookie · Nov 23, 2011

I don't think you can do this, based on the few things I've seen via Google.

To sum up, connecting remotely as sysdba uses authentication via the password file. Database links do not attempt to authenticate this way, they are authenticated in the remote database and not externally.

Here's a link to a site that briefly touches upon the subject.

Related questions

Is it possible to output a SELECT statement from a PL/SQL block?

How can I get a PL/SQL block to output the results of a SELECT statement the same way as if I had done a plain SELECT? For example how to do a SELECT like: SELECT foo, bar FROM foobar; …

Read More
Get started link does not work in oracle 11g server

I have started using Oracle database server on Windows 7 64 bit OS and I have encountered the following error. "Error- Windows cannot find 'http://127.0.01:%HTTPPORT%/apex/f?p=4950'. Make sure you typed the name correctly, and then try again" I …

Read More
Oracle Apex 5.0 - Display static image

I'm new to Oracle Apex and I'm really struggling how to display static images on a desktop application. I uploaded an image at Shared Components -> Files -> Static Application Files and was given the reference #APP_IMAGES#…

Read More