| Problems during binding SpotLight to the instance [message #459997] |
Wed, 09 June 2010 05:45  |
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 #460616 is a reply to message #460536] |
Sun, 13 June 2010 02:24  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
