I made sure all my authorities on everything that I thought they were
required on was set. But I am still getting the errors below.
Does anyone have any ideas why the error would be occuring ?? I really need
to get this fixed.
Kevin
-----Original Message-----
Sent: Friday, September 21, 2001 3:25 PM
To: Multiple recipients of list ORACLE-L
Hi Gang;
I have a piece of SQL that generates a SQL statement that will create a
view for a user.
On our DEV machine the user can use it just fine. But, on our Test machine
they keep getting the error :
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "PCM$.CALCFEESCHEDGETDATA", line 71
ORA-06512: at line 1
I looked at all the security I could think of:
select on all the mentioned tables by the owner
select any table granted by sys
create view granted by sys
create any view granted by sys
execute on dbms_sql and dbms_sys_sql granted by sys
Nothing works.
HELP.--------- Any suggestions on where to go now ??
Thanks
Kevin
-----Original Message-----
Sent: Friday, September 21, 2001 2:17 PM
To: Multiple recipients of list ORACLE-L
How are your permissions?
jacinth
<jacinth To: Multiple recipients of list
ORACLE-L
@mail.ev1.net <[EMAIL PROTECTED]>
> cc:
Sent by: root Subject: setting up HACMP and
Oracle 8.1.6
09/21/2001
02:20 PM
Please
respond to
ORACLE-L
I hope someone may be able to shed some light on this. Oracle does not
seem to have much information on setting up failover on HA, other than
OPS (which we are not doing). I am not an HA expert, so I may just be
missing something or not asking right questions.
HW: IBM S7A
OS: AIX 4.3.3
Oracle 8.1.6
Scenario: Two nodes, one set up production, the other test/batch. We
are trying to configure so that when production goes down, it fails over
to node B, shutting down test/batch in process. Oracle is installed on
each node, but in different directories.
Problem: On failover to node B, there are problems starting up DB, and
a noteable failure to start the listener. Listener log not much help.
HACMP log shows:
Could not load program oracleeml:
Dependent module libobk.a(shr.o) could not be loaded.
Could not load module libobk.a(shr.o).
Error was: No such file or directory
The file does exist.
Anyone have ideas?
-Denise Horton-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: jacinth
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
