| SQL behaving differently on different RAC Node [message #146939] |
Mon, 14 November 2005 16:42  |
hrshah74
Messages: 2
Registered: November 2005
|
Junior Member |
|
|
We have an Oracle RAC running on two nodes. Running following select statement on node 1 returns ORA-04052, but running same select statement on node 2 is successfull.
select pkg1.get_user_name from dual;
I've no clue...why something like this is happening. Any help is appreciated.
Thanks
|
|
|
|
| Re: SQL behaving differently on different RAC Node [message #146952 is a reply to message #146939] |
Mon, 14 November 2005 19:42  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
No information on oracle version/ OS.
The said error is very generic.
Please post what the package you are talking about does.
Post your sample session. There should be more errors accompanying.
Is there a database link involved?
if so, make sure the corresponding entries are made in tnsnames.ora file on both the nodes.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
