Home » SQL & PL/SQL » Client Tools » Problems during binding SpotLight to the instance (Oracle11 on Linux Red Hat 4)
Problems during binding SpotLight to the instance [message #459997] Wed, 09 June 2010 05:45 Go to next message
rodnower
Messages: 17
Registered: June 2010
Location: Israel
Junior Member
Hello, I have RAC Oracle11 installation built from 2 nodes running on Linux Red Hat OS.

Now, I try to make connection from SpotLight running on Windows 7 to the Instance of one of nodes (TNS name of it is: LIBD1)

This what I do:

Make new connection -> give user with SYS permission -> connect -> get error about that, that user not configured -> User Configuration Wizard opens -> give SYS as user with sysdba permissions (real SYS not other user with SYS permission) -> check "configure new user" option -> give new user name -> next

And I get error: DBMS_SQL access.denied.

What I do wrong?
Thank you for ahead.
Re: Problems during binding SpotLight to the instance [message #460416 is a reply to message #459997] Fri, 11 June 2010 02:41 Go to previous messageGo to next message
Frank Naude
Messages: 4564
Registered: April 1998
Senior Member
Quote:
And I get error: DBMS_SQL access denied.


You may need to do a GRANT EXECUTE ON DBMS_SQL TO ...
Re: Problems during binding SpotLight to the instance [message #460536 is a reply to message #460416] Fri, 11 June 2010 16:46 Go to previous messageGo to next message
rodnower
Messages: 17
Registered: June 2010
Location: Israel
Junior Member
To ... ? To new user? but in which state? I choose to create new user with SYS permissions and I get error during creation.
Moreover, before, I try to configure existing user and before SpotLight configuration I grant him all permissions with Toad.
Re: Problems during binding SpotLight to the instance [message #460616 is a reply to message #460536] Sun, 13 June 2010 02:24 Go to previous message
rodnower
Messages: 17
Registered: June 2010
Location: Israel
Junior Member
This the full error in spotlight:
An error has occured in table DropSysSyn in connection LIBD1 with the following error
ORA-29471: DBMS_SQL access denied
ORA-06512: at "SYS.DBMS_SQL", line 1017
ORA-06512: at line 8 in table DropSYSSyn

This is information from appropriate trace file:
DBMS_SQL Security error: ORA-29471!
0x4cf622608 1046 package body SYS.DBMS_SQL
0x4ff284580 16 anonymous block
Previous Topic: Executing SQL statement for UNIX script
Next Topic: "X Rows Selected" message being suppressed
Goto Forum:
  


Current Time: Wed Apr 08 02:01:31 CDT 2020