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
Error ORA-12514 TNS: listener does not know
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?
When you give
tnsping <instance>
does it respond?
Dear Anderson
TnSping test
TNS-03505: Failure to determine the name
TnSping test
TNS-03505: Failure to determine the name
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))
)
)
-
- Rank: Analista Sênior
- Posts: 153
- Joined: Thu, 01 Nov 2007 2:53 pm
- Location: Osasco
Eli Dias
Oracle Certified Professional
Oracle Certified Professional
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,
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,
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.
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.
-
- Rank: Analista Sênior
- Posts: 153
- Joined: Thu, 01 Nov 2007 2:53 pm
- Location: Osasco
Eli Dias
Oracle Certified Professional
Oracle Certified Professional
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,
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,
-
- Rank: Analista Sênior
- Posts: 153
- Joined: Tue, 27 May 2008 1:31 pm
- Location: Rio de Janeiro - RJ
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
I searched and found this post.
http://forum.imasters.uol.com.br/index. ... __threaded
I hope I could have helped.
Att,
Alex Silva
-
- Rank: Estagiário Júnior
- Posts: 1
- Joined: Mon, 08 May 2017 10:20 pm
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
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
-
- Information
-
Who is online
Users browsing this forum: No registered users and 6 guests