Re: DB link to standby

DB link to standbyFirst, I don't understandby why connect to a not open standby. Second, maybe this also works for you, like:
[oracle_at_misc3 oracle]$ sqlplus internal/password_at_standby @test.sql

SQL*Plus: Release 8.1.7.0.0 - Production on Thu Dec 18 23:59:20 2003

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

  COUNT(*)

         8

Disconnected from Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production

[oracle_at_misc3 oracle]$ cat test.sql

select count(*) from v$session;
exit
----- Original Message -----
To: Multiple recipients of list ORACLE-L Sent: Thursday, December 18, 2003 9:59 PM

On standby database server, you can connect to "/ as sysdba" and query fixed tables/views. Is it possible to create a database link which connects to sysdba user to query the fixed tables/view? I tried, but getting following error
ORA-02068: following severe error from TEST_SB ORA-01033: ORACLE initialization or shutdown in progress Thanks
Ashish

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zhu chao
  INET: chao_ping_at_vip.163.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).