I got similar problems recently, and the solution I found --at least,
which works for me-- was to update the tnsnames.ora of the (unix) server
where our OBIee repository is installed.
I had first updated tnsnames.ora on my PC (which is where the Admin part
is installed), which allows to imports tables & views from database
(probably the state where you are now, kranthikiranchokkarapu.)
But after that I couldn't access to any data of them, nor update the row
count of the tables in the physical layer.
What was fuzzing me is that with SQL+ it did work correctly, on my PC as
well as on the server.
Finally I double-checked all the tnsnames.ora and found out that the one
of the server was not uptodate which the database name of my newly
After fixing this, I still had to restart the OBIee server services, and
the restart the session on my PC too, and since then it works ok now.
Hope that this will help you.
Please Mark if it helps You.....
Thanks to AjeetR and Ram. "You should create two different databases instead of two connection pools under one database." It works now!
^-- What? Why? It's actually a good practice to have 2 connection pools per data source to seperate data-retrieval pools from initialization block pools!