Error ORA-12514 TNS: listener does not know

[hervalg]

I have Oracle installed on a Windows XP machine as a test bench, and from today's message appears when trying to enter PL / SQL: ORA-12514 TNS: Listener has no knowledge about the service currently requested in the connection descriptor.
until yesterday connected to the base normally. This machine is networked to the company and connect in the server database normally, but in the bank of my machine the message occurs. Tentei logar in Oracle as sqlplus / nolog, SYSDBA, and the message appears: ORA-12560 Error of protoco adapter.
Please would like someone to help me because I need this test base.

Environment information:
* Oracle version: 10.2.0
* Operating system: Windows XP

[elidias7]

Good Morning.

Did you ever check if Oracle's servics in this machine are Start?

embraces,

[hervalg]

Prezador Eli Dias
Yes, all services are in the "air" ..

[ruevers]

So in the listener is configured by name or IP, if it is ip, the machine is fixed or dynamic ... sends your listener file.ora to take a look ...

When you give

tnsping <instance>

does it respond?

[hervalg]

Dear Anderson

TnSping test
TNS-03505: Failure to determine the name

Select all

SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = PLSExtProc) 
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_2) 
      (PROGRAM = extproc) 
    ) 
    (SID_DESC = 
      (SID_NAME = TESTE) 
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_2) 
    ) 
    (SID_DESC = 
      (SID_NAME = TESTE2) 
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_2) 
    ) 
  ) 
 
LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = TI)(PORT = 1522)) 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) 
    ) 
  )

[hervalg]

I created the test instance2, it is working, but the test does not.

[elidias7]

Good Morning.

Try to redo Listener configurations, such as listener address and "Database Services".
After that it creates a configuration in tnsnames to verify that the connections are being established.

embraces,

[hervalg]

Dear Eli

Refizes Listener, I changed TNSNAMES, and the problem persisted.

Must have given any crash worse in the bank, I have the test base2, I will not try to put the test in the air.

Thanks for the help.

[elidias7]

Can not give up this way!
If it were a production environment ???
How would you explain to your head of this? ?

Have you tried setting the oracle_sid varianvel to attempt connection like sysdba or nolog ???

Hugs,

[alexrsilva]

As my Database Oracle 10g was with the same problem.
I searched and found this post.
http://forum.imasters.uol.com.br/index. ... __threaded
I hope I could have helped.

Att,

Alex Silva

[williamlima.ti]

Good evening,

I am also starting in Oracle and I had the same problem as the post and I decided as follows:
1 - In attempts to log in locally on the XE I appealed for reinstalling Oracle . In the reinstallation process I only opted for "repairing" the software. After you finish repaired I tried to log in with local user and password: [color=# 8040ff] success [/color] . Log in normally (however I did not discover the reason for working before)

2 - The other day I went to the service and connected normally (by the network). In the meantime, I turned off the machine. When I got home and tried to log in to my local base I had the same problem again: PL / SQL Developer [Content] Ora-12514: TNS: Listener has no knowledge about the service requested currently in the connection descriptor

Solution
1 - Repeat step 1 (not too productive but would solve the problem)
2 - I discovered that there is a service that was "stopped on my machine ", called: OracleServicexe. I noticed because I suspected that, at the time of reinstalling Oracle the service started again, but when I turned off the machine it stopped, because it rises only manually. Therefore: [color=# 8000FF] Enter Windows 7 services, find the service called OracleServiceXE and start it and try to log back. [/color] will probably work out