ORA-12505: TNS:listener

After reinstalling the oracle software, I get this in the dbconsole in all related database:
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
In the sysman log I've find this:
2009-09-01 20:47:51,811 [HttpRequestHandler-884010469] ERROR eml.OMSHandshake getParameterFromDB.564 - Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL= TCP)(HOST=xxxx.xxxx.xxxx.xxxx)(PORT=1527)))(CONNEC T_DATA=(SERVICE_NAME=xxxx)
What could be the problem?

hello,
What is your version database ?
what is the action you have executed to get this error message ?
can execute 'ping server' ?
can you execute tnsping Database ?
can You execute lsnrctl status 'name_listener' ?
can you connect sqlplus system/password ?

Also, run the comment lsnrctl services to be sure the service you are listing in the tnsnames.ora file does exist and resolves to the correct database. Also, be sure that the port in your tnsnames.ora entry matches the port that the listener is running on.

http://www.oracle.com/technology/documentation/dat abase.htmlOracle Documentation Page.
Find version of db you are working with.
You want the REFERENCE MANUAL
Part II - Static Data Dictionary Views
This will give you a list of the data dictionary views that are available.
USER_xxx tells about what you own
ALL_xxx tells about what you have access to
DBA_xxx tells about what is in the database <--- Not everyone will have
access to these.
If you are just learning oracle, this will be an invaluable manual for you.
The key to working with Oracle is being able to do research.

Hi,
>How can I get all user names including default users?
SELECT * FROM all_users;
>How I retrieve all system table names?
SELECT * FROM dictionary;
will return all dictionary tables you have permisions to.