All geek questions in one place

How to create a link to an Oracle database with sysdba privileges

I want to:

select * from v$database@standby ;

Problem:

  • the backup is set up so that only the SYSDBA user can connect to the request
  • I can’t find out how to use the database link using the sysdba privilege

My goal is to display system information / statistics from an Oracle backup database on a web page.

I am using Oracle APEX. Pages are computed from mod_plsql, which is executed from an Oracle database, so it is easy to display the result of this kind of query.

Alternative:

  • How to select * from a "shell script"?
+4
source share
2 answers

I don’t think you can do this based on a few things that I saw through Google.

To summarize, the connection is remote because sysdba uses authentication through a password file. Database links do not attempt to authenticate this path; they are authenticated in the remote database, and not externally.

Here is a link to a site that briefly touches on the topic.

+3
source

I think you want:

 CREATE PUBLIC DATABASE LINK STANDBY

not CREATE DATABASE LINK STANDBY. I just checked this from sqlplus / as sysdba and was able to query.

0
source

Source: https://habr.com/ru/post/1382521/

More articles:


All Articles