TNS:listener does not currently know of service requested in connect descriptor

[soumyarajesh]

Hi,
I installed Oracle 10g release 2 on HPitanium
and creted two databases.
When i creted i tried connecting to the database i was able to but after i disconnected when i try connectiong again i'm getting this error.
Last time i had this error i uninstalled oracle and installed it back it wass working but again i have the same problem.
Can you please suggest me some help?

[Peter Godron]

Hi,
First: ensure your db is running.

Then:
"Action: - Wait a moment and try to connect a second time.

- Check which services are currently known by the listener by executing: lsnrctl services

- Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.

- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.

- Check for an event in the listener.log file."

[Volker Borowski]

Several things to check:

You have one ORACLE_HOME with two databases or do you have installed the Software twice in diffrent locations ?

You have one or two listeners configured ?
You have one or two listeners running ?

How do you try to connect ?
- connect system/your_password@service1
- connect / as sysdba
- connect /

Clip and attach the sequence you are trying including the error message.

checkout for files
listener.ora
sqlnet.ora
tnsnames.ora

Attach them if possible/permitted.
This will give us better information to help you !

Volker