Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12514: TNS:listener does not currently know of service requested

644810Jun 12 2008 — edited Nov 19 2008

I'm seeing ORA-12514 error when I'm trying to login to the database sqlplus scott/tiger@orcl

I'm not sure what might be causing it because it is happening after some time passes from the reboot. So when I reboot the system, I can log in to scott/tiger@orcl however, 3 or 4 hrs later, when i try to login again I get ORA-12514.

I tried restarting listener and service, nothing seems to help
I'm running Oracle 10g R2 10.2.0.1.0 and i applied patch 10.2.0.3
I already reinstalled everythign and recreated schema 3 times.
The only thing I can do to get this working again is to reboot the system.
I'm on Windows XP

Does anyone know how to fix this issue?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2008

Added on Jun 12 2008

#general-database-discussions

21 comments

16,995 views