Certainly you CAN use tns to connect. I do. But be careful your SQLDEveloper is using the correct tnsnames.ora in case you have more than one. To be safe I'll enter my entry of interest in all copies of tnsnames.ora on the client machine.
As already said perhaps the user exists without any objects.
If you can connect as system then run the following query from sqlplus:
SELECT object_name,object_type from dba_objects where owner=<owner>;
This will lists all objects owned by that user where owner is the schema you're trying to connect to in SQLDeveloper.
If nothing is returned then your user does not have any objects.
If you can't connect as System, then the earlier query will do.
Main Topics
Browse All Topics
by: mrjoltcolaPosted on 2009-07-30 at 15:26:39ID: 24984951
SQL Developer uses Java / JDBC to connect, so you don't need the Oracle client. Sounds like you did get connected, but apparently the schema user you connected to has no objects. That is normal.
Try creating a table or verify the username you are connecting with.
You say they exist. Can you login via sqlplus and do the following, then run the same from SQL Developer:
select table_name from user_tables;