Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_SQL to Create views
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 <ORACLE-L_at_fatcity.com>Oracle 8.1.6
> cc:
Sent by: root Subject: setting up HACMP and
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: jacinth_at_mail.ev1.net 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: tday6_at_csc.com 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: kgel_at_ppoone.com 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: kgel_at_ppoone.com 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: 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).Received on Mon Sep 24 2001 - 10:32:22 CDT
![]() |
![]() |