DB link to standbyFirst, I don't understandby why connect to a not open standby.
Second, maybe this also works for you, like:
[EMAIL PROTECTED] oracle]$ sqlplus internal/[EMAIL PROTECTED] @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
[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).